Enterprise Integration & Modeling: Metadatabase Research Home
 home || MDB Research | Virtual Lab | Case Tool | Downloads | Publications | Researchers | Links

TSER: A Data Modeling System Using The Two-Stage Entity-Relationship Approach


TSER is a LISP-based data modeling system consisting of three major components: (1) the modeling construct and interface facilities, (2) mapping algorithms, and (3) a design knowledgebase. The modeling construct is comprised of a Semantic Entity-Relationship model for System Analysis tasks and an Operational Entity-Relationship model for database design. The mapping algorithms integrate these two models and create relational schemata featuring both normalized data structures and appropriate integrity rules. Finally, generic modeling rules and application specific knowledge constitute the knowledge base that can be used both internally (by the mapping algorithms) and externally (by the users of the system). Using the Two-stage Entity-Relationship approach (Hsu, 1985) as its methodology, the system can provide multiple functionalities. It can be employed as a rule-based data modeling assistant. The system can also perform the function of an information management front-end for conventional database management systems. But most of all, TSER is designed to facilitate the informational integration in computerized manufacturing enterprises, where the overwhelming tasks of planning and control of heterogeneous distributed databases demand such a system. Implementation of TSER is currently underway using a Xerox LISP machine.


viu.eng.rpi.edu is hosted by Professor Cheng Hsu.
Rensselaer Polytechnic Institute
Department of Industrial and Systems Engineering (formally Decision Sciences & Engineering Systems)
110 8th St., Center for Industrial Innovation, Room 5123, Troy, NY 12180-3590

Copyright 1997-2014. MetaWorld, Nothing on this site may be commercially used without written consent.

Valid XHTML 1.0! Valid CSS!