Logical Schema Design that Quantifies Update Inefficiency and Join Efficiency

Author(s):  
Sebastian Link ◽  
Ziheng Wei
Keyword(s):  
Author(s):  
Shusaku Egami ◽  
Takahiro Kawamura ◽  
Yuichi Sei ◽  
Yasuyuki Tahara ◽  
Akihiko Ohsuga
Keyword(s):  

AIChE Journal ◽  
2021 ◽  
Author(s):  
Hawley Helmbrecht ◽  
Nuo Xu ◽  
Rick Liao ◽  
Elizabeth Nance

2003 ◽  
Vol 45 (4) ◽  
Author(s):  
Jens Lechtenbörger ◽  
Gottfried Vossen

ZusammenfassungObwohl der Einsatz von Data-Warehouse-Systemen zur gängigen Praxis moderner IT-Landschaften gehört, haben methodische Untersuchungen zum qualitätsorientierten Schemaentwurf erst in jüngerer Zeit begonnen. Ausgehend von einem Schemaentwurfsprozess für Data-Warehouse-Systeme werden aktuelle Entwicklungen zur Qualitätssicherung und Data-Warehouse-spezifische Qualitätskriterien wie Summierbarkeit sowie deren Verallgemeinerung zu mehrdimensionalen Normalformen und Selbstwartbarkeit vorgestellt.


Author(s):  
Lex Wedemeijer

Enterprises need data resources that are stable and at the same time flexible to support current and new ways of doing business. However, there is a lack of understanding how flexibility of a Conceptual Schema design is demonstrated in its evolution over time. This case study outlines the evolution of a highly integrated Conceptual Schema in its business environment. A gradual decline in schema quality is observed: size and complexity of the schema increase, understandability and consistency decrease. Contrary to popular belief, it is found that changes aren’t driven only by “accepted” causes like new legislation or product innovation. Other change drivers are identified like error correction, changing perceptions of what the information need of the business is and elimination of derived data. The case shows that a real Conceptual Schema is the result of “objective” design practices as well as the product of negotiation and compromise with the user community.


Author(s):  
Lex Wedemeijer

Enterprises need data resources that are stable and at the same time flexible to support current and new ways of doing business. However, there is a lack of understanding how flexibility of a Conceptual Schema design is demonstrated in its evolution over time. This case study outlines the evolution of a highly integrated Conceptual Schema in its business environment. A gradual decline in schema quality is observed: size and complexity of the schema increase, understandability and consistency decrease. Contrary to popular belief, it is found that changes arent driven only by accepted causes like new legislation or product innovation. Other change drivers are identified like error correction, changing perceptions of what the information need of the business is and elimination of derived data. The case shows that a real Conceptual Schema is the result of objective design practices as well as the product of negotiation and compromise with the user community.


Sign in / Sign up

Export Citation Format

Share Document