Enterprise systems are large-scale software applications to support business operations; they typically include software systems for data management, business process/workflow management, information flows, reporting, and data analytics. Focusing only the data management aspect, a typical enterprise has to struggle with many data integration difficulties, since its data are usually spread around many database systems, workflow systems, file systems, etc. and in a variety of form possibly with no coherent semantics. In this course, we plan to cover some fundamental data modeling and manipulation techniques, and based on these models, we will explore the data integration problems, frameworks, and techniques. Topics covered include conjunctive queries, relational query languages, Datalog, data integration frameworks (GAV, LAV, GLAV), data exchange formalisms.
Once the quarter starts, instructor approval is required to maintain enrollment in the course.