Abstract
Since 1995, star schema has been popularly utilized to represent warehouse data at the logical level. Information warehouse design mainly focuses on the design of a warehouse star schema. There are many proposals on conceptual data warehouse design of a star schema based on some well-known data models such as the entity relationship model (ERM), and an extension to the Unified Modeling Language (UML). This paper presents the design and implementation of an information warehouse using the object role model (ORM) as the data model both for user modeling of the warehouse and for the underlying implementation model of the system. A warehouse multi-star/star schema is automatically generated from the input schema description based on ORM using a deep-structured natural language interface. Users input simple English sentences together with the structured sections for type declarations and constraints on these sentences. Since the input ORM schema can also be transformed into 5NF operational relational schemas, this system allows warehouse users to generate star schemas from their operational schemas
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.