Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
A normal form for precisely characterizing redundancy in nested relations
ACM Transactions on Database Systems (TODS)
Performance evaluation of the object-relational transformation methodology
Data & Knowledge Engineering
A Comparative Study of Various Nested Normal Forms
IEEE Transactions on Knowledge and Data Engineering
Extending UML for Object-Relational Database Design
«UML» '01 Proceedings of the 4th International Conference on The Unified Modeling Language, Modeling Languages, Concepts, and Tools
A Normal Form For Entity-Relationship Diagrams
Proceedings of the Fourth International Conference on Entity-Relationship Approach
A Normal Form Object-Oriented Entity Relationship Diagram
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
On Transformations from UML Models to Object-Relational Databases
HICSS '01 Proceedings of the 34th Annual Hawaii International Conference on System Sciences ( HICSS-34)-Volume 3 - Volume 3
ACM SIGMOD Record
Oracle Database 10g PL/SQL Programming
Oracle Database 10g PL/SQL Programming
Unified Modeling Language User Guide, The (2nd Edition) (Addison-Wesley Object Technology Series)
Unified Modeling Language User Guide, The (2nd Edition) (Addison-Wesley Object Technology Series)
Theory of Relational Databases
Theory of Relational Databases
Generating Compact Redundancy-Free XML Documents from Conceptual-Model Hypergraphs
IEEE Transactions on Knowledge and Data Engineering
Database Processing: Fundamentals, Design, and Implementation (10th Edition)
Database Processing: Fundamentals, Design, and Implementation (10th Edition)
Information and Software Technology
| Hi-index | 0.00 |
This paper presents a methodology for designing proper nesting structures of user-defined types in object-relational databases. Briefly, we envision that users model a real-world application by using the EER model, which results in an EER schema. Our algorithm then uses the theory we developed for nested relations to generate scheme trees from the EER schema. We shall prove that the resulting scheme trees have exactly the same information content as the EER schema, and the scheme-tree instances over the resulting scheme trees do not store information redundantly. Finally, the scheme trees are transformed to Oracle Database 10g nested object types for implementation. The algorithm in this paper forms the core of a computerized object-relational database design tool we shall develop in the future.