EITH - A Unifying Representation for Database Schema and Application Code in Enterprise Knowledge Extraction

The integration of heterogeneous legacy databases requires understanding of database structure and content. We previously developed a theoretical and software infrastructure to support the extraction of schema and business rule information from legacy sources, combining database reverse engineering with semantic analysis of associated application code (DRE/SA). In this paper, we present a compact formalism called EITH that unifies the representation of database schema and application code. EITH can be efficiently derived from various types of schema representations, particularly the relational model, and supports comparison of a wide variety of schema and code constructs to enable interoperation. Unlike UML or E/R diagrams, for example, EITH has compact notation, is unambiguous, and uses a small set of efficient heuristics. We show how EITH is employed in the context of SEEK, using a construction project management example. We also show how EITH can represent various structures in rela...

• Type: Conference
• Year: 2003
• Where: ER
• Authors: Mark S. Schmalz, Joachim Hammer, Mingxi Wu, Oguzhan Topsakal
• Keywords: E/R Diagrams, EITH Design Philosophy, ER 2003, Formalism Called Eith