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 discuss some fundamental data modeling and manipulation techniques that will be useful in tackling these data integration problems. Topics covered include relational data modeling and query languages, Datalog, data integration frameworks (GAV, LAV, GLAV), data exchange formalisms, views and updates.
This course will tentatively be offered as hybrid/in-person, however all UCSB courses may need to start the Spring term remotely in the event that the university doesn't receive final approval for hybrid/in-person instruction from the Santa Barbara Public County Health prior to the start of the term.