Restructuring partitioned normal form relations without information loss

SIAM Journal on Computing

Volumn 29, Issue 5, 2000, Pages 1550-1567

  Vincent, Millist W ^a   Levene, Mark ^b  

^a UNIVERSITY OF SOUTH AUSTRALIA   (Australia)

^b UNIVERSITY COLLEGE LONDON   (United Kingdom)

Author keywords

[No Author keywords available]

Indexed keywords

OPTIMIZATION; QUERY LANGUAGES; USER INTERFACES;

NEST;

RELATIONAL DATABASE SYSTEMS;

EID: 0034546695     PISSN: 00975397     EISSN: None     Source Type: Journal    
DOI: 10.1137/S0097539797326319     Document Type: Article

References (29)

1. S. ABITEBOUL AND N. BIDOIT, Non first normal form relations: An algebra allowing data restructuring, J. Comput. System Sci., 33 (1986), pp. 361-393.
2. S. ABITEBOUL AND R. HULL, Restructuring hierarchical database objects, Theoret. Comput. Sci., 62 (1988), pp. 3-38.
3. S. ABITEBOUL, R. HULL, AND V. VIANU. Foundations of Databases, Addison-Wesley, Reading, MA, 1995.
4. S. ABITEBOUL, M. SCHOLL, G. GARDARIN, AND E. SIMON, Towards DBMSs for supporting new applications, in 12th International Conference on Very Large Data Bases, Kyoto, Japan, 1986, pp. 423-435.
5. E. F. CODD, A relational model of data for large shared data banks, Comm. ACM, 13 (1970), pp. 377-387.
6. Z. GALIL, An almost linear-time algorithm for computing a dependency basis in a relational database, J. ACM, 29 (1982), pp. 96-102.
7. M. GYSSENS, J. PAREDAENS, AND D. VAN GUCHT, On a hierarchy of classes for nested databases, Inform. Process. Lett., 36 (1990), pp. 259-266.
8. G. HULIN, On restructuring nested relations in partitioned normal form, in 16th International Conference on Very Large Data Bases, Brisbane, Australia, 1990, pp. 626-637.
9. R. HULL, Relative information capacity of simple relational database schemata, SIAM J. Comput., 15 (1986), pp. 856-886.
10. R. HULL, A survey of theoretic research on typed complex database objects, in Databases, J. Paredaens, ed., Academic Press, London, 1987, pp. 193-256.
11. R. HULL AND C. K. YAP, The format model: A theory of database organization, J. ACM, 31 (1984), pp. 518-537.
12. M. LEVENE, The Nested Universal Relational Database Model, Springer-Verlag, Berlin, 1992.
13. M. LEVENE AND G. LOIZOU, NURQL: A nested universal relation query language, Information Syst., 14 (1989), pp. 307-316.
14. A. MAKINOUCHI, A consideration on normal form of not-necessarily-normalized relations in the relational data model, in 3rd International Conference on Very Large Data Bases, Tokyo, Japan, 1977, pp. 447-453.
15. R. J. MILLER, Y. E. IOANNIDIS, AND R. RAMAKRISHNAN, Schema equivalence in heterogenous systems: Bridging theory and practice, Information Syst., 19 (1994), pp. 3-13.
16. R. J. MILLER, Y. E. IOANNIDIS, AND R. RAMAKRISHNAN, The use of information capacity in schema integration and translation, in 19th International Conference on Very Large Data Bases, Dublin, Ireland, 1993, pp. 120-133.
17. Z. M. OZSOYOGLU AND L.-Y. YUAN, A new normal form for nested relations, ACM Trans. Database System, 12 (1987), pp. 111-136.
18. J. PAREDAENS, P. DEBRA, M. GYSSENS, AND D. VAN GUCHT, The Structure of the Relational Database Model, Springer-Verlag, Berlin, 1989.
19. J. PAREDAENS AND D. VAN GUCHT, Converting nested algebra expressions into flat algebra expressions, ACM Trans. Database Systems, 17 (1992), pp. 65-93.
20. P. PISTOR, The advanced information prototype (AIM-P): Advanced database technology for integrated applications, IBM Systems J., 28 (1987), pp. 661-681
21. M. A. ROTH, H. F. KORTH, AND A. SILBERSCHATZ, Extended algebra and calculus for nested relational databases, ACM Trans. Database Systems, 13 (1988), pp. 389-417
22. R. SACKS-DAVIS, A. KENT, K. RAMAMOHANARAO, J. THOM, AND J. ZOBEL, ATLAS: A Nested Relational Database System for Text Applications, Technical report CITRI/TR-92-52, Departments of Computer Science, RMIT and The University of Melbourne, Australia, 1992.
23. H.-J. SCHEK, H. B. PAUL, M. SCHOLL, AND G. WEIKUM, The DASDBS project: Objectives, experiences, and future prospects, IEEE Transactions on Knowledge and Data Engineering, 2 (1990), pp. 25-43.
24. H.-J. SCHEK AND M. H. SCHOLL, The relational model with relation-valued Attributes, Information Syst., 11 (1986), pp. 137-147.
25. H.-J. SCHEK AND W. WATERFELD. A database kernel system for geo-scientific applications, in Symposium on Spatial Data Handling, 1986.
26. M. SCHOLL, VERSO: A database machine based on nested relations, in Nested Relations and Complex Objects in Databases, S. Abiteboul, P. C. Fischer, and H.-J. Schek, eds., Springer-Verlag, Berlin, 1989, pp. 27-49.
27. M. STONEBRAKER AND D. MOORE, Object-Relational DBMSs, Morgan-Kauffman, San Francisco, CA, 1996.
28. S. J. THOMAS AND P. C. FISCHER, Nested relational structures, in the Theory of Databases, P. C. Kanellakis, ed., JAI Press, Greenwich, CT, 1986, pp. 269-307.
29. D. VAN GUCHT, Multilevel nested, relational structures, J. Comput. System Sci., 36 (1988), pp. 77-105.