The design and implementation of an ORM-based information warehouse

Simple item page
dc.contributor.authorChau, Vo Thi Ngoc
dc.contributor.authorChittayasothorn, Suphamit
dc.date.accessioned2026-08-06T09:53:30Z
dc.date.available2026-08-06T09:53:30Z
dc.date.issued2005-12-01
dc.description.abstractSince 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.
dc.identifier.citationIti 3rd International Conference on Information and Communications Technology Icict 2005 Enabling Technologies for the New Knowledge Society, 2005, 277-289, 2005
dc.identifier.doi10.1109/ITICT.2005.1609630
dc.identifier.other2-s2.0-33847732732
dc.identifier.urihttps://dspace.kmitl.ac.th/handle/123456789/1120
dc.sourceIti 3rd International Conference on Information and Communications Technology Icict 2005 Enabling Technologies for the New Knowledge Society
dc.titleThe design and implementation of an ORM-based information warehouse
dc.typeConference Paper

Files

Collections

Research