| Publisher | Australian Computer Society | ||
|---|---|---|---|
| Format | 184.2KB PDF | Date added | 08 Sep 2006 |
| Topics | Database Applications, Database Management | ||
| Downloads | 4 | ||
Though it is commonly agreed that the design of large database schemata requires group effort, database design from component subschemata has not been investigated thoroughly. This paper investigates snowflake-like subschemata of database schemata expressed in the Higher-order Entity-Relationship Model (HERM). These subschemata are almost hierarchical in the sense that they may contain cycles in the schema, but not in the instances. The paper shows that each HERM schema can be decomposed into such subschemata using a small set of composition constructors.
Related white papers
Improving the Accuracy of Spend Analysis through Data Quality
Organisations can spend as much as 60 percent of revenue to acquire the goods and services necessary to conduct business. Procurement professionals are being asked to reduce the organisation's overall...
The ROI of Data Governance: Seven Ways Your Data Governance Program Can Help Save You Money
In difficult economic climates, responsible leaders look for opportunities to contain costs. Data governance programs are well positioned to assist in these efforts. This white paper from Gwen Thomas of...
Observing Data Quality Service Level Agreements
This white paper by David Loshin from Knowledge Integrity examines how to measure data quality and what to do when the data does not meet the level of acceptability. When...
Populating a Data Quality Scorecard with Relevant Metrics
Too often, data governance teams rely on existing measurements as the metrics used to populate a data quality scorecard. But without a defined understanding of the relationship between specific measurement...
Log4plsql: Open-Source Tool for PL/SQL Logging
The implementation of logs is a significant element in development strategy: exhaustive yet concise logs are required to enable code debugging and the tracing of functional events. At the same...
State Bank of Mauritius Improves Reporting Capabilities Using Oracle Technology
Founded in 1973, State Bank of Mauritius (SBM) is the country's second largest domestic bank in terms of assets. The bank wanted to expand use of technology to improve financial...
Understanding System Statistics
Although system statistics haven't yet achieved much popularity, they are not only important overall but actually critical to certain optimization options in 10g. System statistics give the optimizer more of...



