A DBMS prototype to support extended NF2 relations: An integrated view on flat tables and hierarchies

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 1986, Pages 356-367

  Dadam, P ^a   Kuespert, K ^a   Andersen, F ^a   Blanken, H ^a   Erbe, R ^a   Guenauer, J ^a   Lum, V ^a,b   Pistor, P ^a   Walch, G ^a  

^a IBM   (Germany)

^b NAVAL POSTGRADUATE SCHOOL   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DIGITAL STORAGE; HIERARCHICAL SYSTEMS; RELATIONAL DATABASE SYSTEMS;

COMPLEX OBJECTS; HIERARCHICAL STRUCTURES; LOGICAL DATA MODELS; NORMAL FORM; PERFORMANCE ASPECTS; RELATIONAL DATA MODELS; RELATIONAL DATABASE MANAGEMENT SYSTEMS; STORAGE STRUCTURES;

INFORMATION MANAGEMENT;

EID: 85032171467     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/16894.16889     Document Type: Conference Paper

References (44)

1. Astrahan, in M et al System R Relational Approach to Database Management ACM Trans on Database Systems, Vol 1, No 2, June 1976, pp 97-137
2. Blanken, H et al Storage Structures and Query Handling for Tune Versions in an Advanced Information Management System (in preparation)
3. Bartels, R, Moeller, J Entwurf und Implementierung einer regelbasierenden Planungskomponente fuer die Optimierung von Datenbankanfragen in einer SEQUEL-artigen Sprache (Design and Implementation of a Rule-Based Planning Component for the Optimization of SEQUEL-like Database Quenes) Master's Thesis, Tech University of Darmstadt and IBM Heidelberg Scientific Center, Nov 1985 (in German)
4. Chamberlin, D D et al SEQUEL 2 A Unified Approach to Data Definition, Manipulation, and Control IBM Journal of Research and Development, Vol 20, No 6, 1976, pp 560-575
5. Date, C J An Introduction to Database Systems (3rd ed) Addison-Wesley Publ Comp, Reading, Mass, March 1981
6. Deppisch, U, Guenauer, J, Walch, G Speicherungsstrukturen und Adressierungstechniken fuer komplexe Objekte des NF2-Relationenmodells (Storage Structures and Addressing Techniques for Complex Objects of the NF2 Data Model) Proc Conf 'Datenbanksysteme fuer Buero, Techmk und Wissenschaft' (A Blaser, P Pistor, eds), Karlsruhe, West Germany, March 1985, Informatik- Fachbenchte 94, Springer-Verlag, Berlin Heidelberg New York Tokyo, pp 441-459 (in German)
7. Dadam, P, Lum, V, Praedel, U, Schlageter, G Selective Deferred Index Maintenance and Concurrency Control in Integrated Information Systems Proc VLDB 85, Stockholm, Sept 1985, pp 142-150
8. Dadam, P, Lum, V, Werner, H -D Integration of Time Versions into a Relational Database System Proc VLDB 84, Singapore, Aug 1984, pp 509-522
9. Dadam, P, Pistor, P, Schek, H-J Praedikat-Sperren rmttels Textfragmenten (Predicate Locking Based on Text Fragments) Proc 12 Gl-Jahrestagung (J Nehmer, ed), Kaiserslautern, West Germany, Oct 1982, Informatik-Fachbenchte 57, Springer-Verlag, Berlin Heidelberg, New York Tokyo, pp 648-668 (in German)
10. Dadam, P, Pistor, P, Schek, H -J A Predicate Oriented Locking Approach for Integrated Information Systems Proc IFIP Congress, Pans, France, Sept 1983, pp 763-768
11. Haskin, R L, Lone, R A On Extending the Functions of a Relational Database System Proc SIGMOD 82, Orlando, Flonda, June 1982, pp 207-212
12. Haerder, T, Reuter, A Database Systems for Nonstandard Applications Proc Int Computing Symposium (HJ Schneider, ed), Erlangen, West Germany, March 1983, Teubner-Verlag, Stuttgart, pp 452-466
13. SQL/Data System, Concepts and Faculties IBM Corp, GH24-5013
14. IBM Systems Journal (Special Issue on DB2), Vol 23, No 2, 1984
15. IBM Systems Journal (Special Issue on IMS), Vol 16, No 2, 1977
16. Query-by-Example, Terminal User's Guide, IBM Corp, SH20-2078
17. Jaeschke, G Nonrecursive Algebra for Relations with Relation Valued Attributes Technical Report TR 85 03 001, IBM Scientific Center, Heidelberg, West Germany, March 1985
18. Jaeschke, G Recursive Algebra for Relations with Relation Valued Attnbutes Technical Report TR 85 03 002, IBM Scientific Center, Heidelberg, West Germany, March 1985
19. Jarke, M, Koch, J Query Optimization in Database Systems ACM Computmg Surveys, Vol 16, No 2, June 1984, pp 111-152
20. Jaeschke, G, Schek, H -J Remarks on the Algebra of Non First Normal Form Relations Proc ACM SIGACT-SIGMOD Symp on Principles of Data Base Systems, Los Angeles, Cal, March 1982, pp 124-138
21. Katz, R H Information Management for Engineering Design Springer-Verlag, Berlin Heidelberg New York Tokyo, 1985
22. Kropp, D, Schek, H -J, Walch, G Text Field Indexing Proc Meeting of the German Chapter of the ACM on Data Base Technology (J Niedereichholz, ed), Bad Nauheim, West Germany, Sept 1979, Teubner-Verlag, Stuttgart, pp 101-115
23. Kuespert, K et al Storage Structures and Addressing Concepts for Complex Objects of the NF2 Data Model (in preparation)
24. Kropp, D, Walch, G A Graph Structured Text Field Index Based on Word Fragments Information Processing and Management, Vol 17, No 6, 1981, pp 363-376
25. Lone, R A Issues in Databases for Design Applications File Structures and Databases for CAD (J Encarnacao, F L Krause, eds), North-Holland Publ Comp, 1982
26. Lone, R A et al User Interfaces and Access Techniques for Engineering Databases Research Report RJ4155, IBM Research Lab, San Jose, Cal, Jan 1984
27. Lone, R A, Plouffe, W Complex Objects and Their Use in Design Transactions Proc Annual Meetmg - Database Week Engineering Design Applications (IEEE), San Jose, Cal, May 1983, pp 115-121
28. Lum, V et al Designing DBMS Support for the Temporal Dimension Proc SIGMOD 84, Boston, Mass, June 1984, pp 115-130
29. Lum, V et al Design of an Integrated DBMS to Support Advanced Applications Proc Int Conf on Foundations of Data Organization (Invited Talk), Kyoto, Japan, May 1985, pp 21-31 (a very similar version of this paper has also been published in Proc Conf "Datenbanksysteme fuer Buero, Technik und Wissenschaft" (A Blaser, P Pistor, eds), Karlsruhe, West Germany, March 1985, Informatik-Fachbenchte 94, Spnnger-Verlag, Berlin Heidelberg New York Tokyo, pp 362-381)
30. Ott, N, Horlaender, K Removing Redundant Join Operations in Queries Involving Views Information Systems, Vol 10, No 3, 1985, pp 279-288
31. Pistor, P, Andersen, F Principles for Designing a Generalized NF2 Data Model with an SQL-type Language Interface IBM Scientific Center, Heidelberg, West Germany, Jan 1986 (submitted for publication)
32. Pistor, P, Hansen, B, Hansen, M Erne sequelartige Sprachschmttstelle fuer das NF2-Modell (A SEQUEL-kke Interface for the NF2 Model) Proc 13 Gl-Jahrestagung, Sprachen fuer Datenbanken (JW Schmidt, ed), Hamburg, West Germany, Oct 1983, Informatik-Fachbenchte 72, Spnnger-Verlag, Berlin Heidelberg New York Tokyo, pp 134-147 (in German)
33. Pistor, P, Traunmueller, R A Data Base Language for Sets, Lists, and Tables Technical Report TR 85 10 004, IBM Scientific Center, Heidelberg, West Germany, Oct 1985
34. Schenk, H Implementational Aspects of the CODASYL DBTG Proposal Proc IFIP Working Conf on Data Base Management (J W Kkmbie, K L Koffeman, eds), Cargese, Italy, April 1974, North-Holland Publ Comp, pp 399-411
35. Schek, H-J The Reference String Indexing Method Proc Information Systems Methodology (G Bracchi, P C Lockemann, eds), Venice, Italy, 1978, Lecture Notes in Computer Science 65, Spnnger-Verlag, Berlin Heidelberg New York Tokyo, pp 432-459
36. Schek, H-J Towards a Basic Relational NF2 Algebra Processor Proc Int Conf on Foundations of Data Organization, Kyoto, Japan, May 1985
37. Selmger, P et al Access Path Selection in a Relational Database Management System Proc SIGMOD 79, Boston, Mass, May 1979, pp 23-34
38. Shu, N C A-Onented and Visual-Directed Application Development System for Non-Programmers Proc IEEE Workshop on Visual Languages, Hiroshima, Japan, Dec 1984, pp 162-170
39. Shu, N C, Lum, V Y, Tung, F C, Chang, C L Specification of Forms Processing and Busmess Procedures for Office Automation IEEE Trans on Software Eng, Vol SE-8, No 5, Sept 1982, pp 499-512
40. Schek, H-J, Pistor, P Data Structures for an Integrated Data Base Management and Information Retneval System Proc VLDB 82, Mexico City, Sept 1982, pp 197-207
41. Schkolmck, M, Sorenson, P The Effects of Denormal-lzation on Database Performance Research Report RJ3082, IBM Research Lab, San Jose, Cal, March 1981
42. Schek, H-J, Scholl, in An Algebra for the Relational Model with Relation-Valued Attnbutes To appear in Information Systems, Vol 11, No 2, 1986 (also available as Technical Report DVSI-1984-T1, Tech University of Darmstadt, West Germany)
43. Stonebraker, M et al The Design and Implementation of INGRES ACM Trans on Database Systems, Vol 1, No 3, Sept 1976, pp 189-222
44. Zloof, in M Query-by-Example A Data Base Language IBM Systems Journal, Vol 16, No 4, 1977, pp 324-343