Simple conditions for guaranteeing higher normal forms in relational databases
A key is simple if it consists of a single attribute. It is shown that if a relation schema...
Deriving functional dependencies from the entity-relationship model
The process of database design can be divided into several sta,ges. This four-stage process comprises: Rquirements collection: In this...
Physical design refinement: The ‘merge-reduce’ approach
Physical database design tools rely on a DBA-provided workload to pick an “optimal” set of indexes and materialized views....
Applying object-oriented analysis and design
Tradional analysis and design techniques imply constant paradigm shifts, since manipulate different concepts at each different phase of software...
Data abstractions for database systems
Data abstractions were originally conceived as a specification tool in programming. They also appear to be useful for exploring...
A research typology for object-oriented analysis and design
This article evaluates current research on object-oriented analysis and design (OOAD). Critical components in OOAD are identified and various...
Extending the database relational model to capture more meaning
During the last three or four years several investigators have been exploring “semantic models” for formatted databases. The intent...
Reduced MVDs and minimal covers
Multivalued dependencies (MVDs) are data dependencies that appear frequently in the “real world” and play an important role in...
On the design of relational database schemata
The purpose of this paper is to present a new approach to the conceptual design of relational databases based...
Updating derived relations: detecting irrelevant and autonomously computable updates
Consider a database containing not only base relations but also stored derived relations (also called materialized or concrete views)....
