Skip to main content
SpringerLink
Log in

Postrelational Databases

  • Chapter
  • First Online:
SQL & NoSQL Databases

  • 10k Accesses

Abstract

Chapter 6 is dedicated to postrelational databases such as federal, temporal, multidimensional databases as well as data warehousing, object-relational, knowledge-based and fuzzy-based databases.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Periodically extracted parts of tables (called snapshots) improve local autonomy.

  2. 2.

    In distributed SQL expressions, the two-phase commit protocol guarantees consistency.

  3. 3.

    Indicators are often also called facts, see also Sect. 6.7 on facts and rules of knowledge databases.

  4. 4.

    For more information, look up the KDD (knowledge discovery in databases) process.

  5. 5.

    See the ETL (extract, transform, and load) process below.

  6. 6.

    Research literature also calls them “complex objects”.

  7. 7.

    The NF2 model (NF2 = non first normal form) supports nested tables.

References

  • Berson, A., Smith, S.: Data Warehousing, Data Mining and OLAP. McGraw-Hill, New York (1997)

    Google Scholar 

  • Bertino E., Martino L.: Object-Oriented Database Systems. Addison Wesley, Wokingham (1993)

    Google Scholar 

  • Bordogna G., Pasi G. (eds.): Recent Issues on Fuzzy Databases. Physica, Heidelberg (2000)

    MATH  Google Scholar 

  • Bosc P., Kacprzyk J. (eds.): Fuzziness in Database Management Systems. Physica, Heidelberg (1995)

    MATH  Google Scholar 

  • Cattell R. G.G.: Object Data Management—Object-Oriented and Extended Relational Database Systems. Addison Wesley, Reading (1994)

    Google Scholar 

  • Ceri S., Pelagatti G.: Distributed Databases—Principles and Systems. McGraw-Hill, New York (1985)

    Google Scholar 

  • Chen G.: Design of Fuzzy Relational Databases Based on Fuzzy Functional Dependenciey. PhD Thesis No. 84, Leuven, Belgium (1992)

    Google Scholar 

  • Chen G.: Fuzzy Logic in Data Modeling—Semantics, Constraints, and Database Design. Kluwer, Boston (1998)

    Google Scholar 

  • Clifford, J., Warren, D.S.: Formal semantics for time in databases. ACM Trans. Database Syst. 8(2), 214–254 (1983)

    Article  Google Scholar 

  • Clocksin W.F., Mellish C.S.: Programming in Prolog. Springer, Berlin (1994)

    Book  Google Scholar 

  • Coad P., Yourdon E.: Object-Oriented Design. Yourdon Press, Englewood Cliffs (1991)

    Google Scholar 

  • Cremers A.B. et al.: Deduktive Datenbanken—Eine Einführung aus der Sicht der logischen Programmierung. Vieweg, Braunschweig (1994)

    Chapter  Google Scholar 

  • Dadam P.: Verteilte Datenbanken und Client/Server-Systeme. Springer, Berlin (1996)

    Chapter  Google Scholar 

  • Dittrich K.R. (ed.): Advances in Object-Oriented Database Systems. Lecture Notes in Computer Science, Vol. 334. Springer, Berlin (1988)

    Google Scholar 

  • Etzion O., Jajodia S., Sripada S. (eds.): Temporal Databases—Research and Practice. Lecture Notes in Computer Science. Springer, Berlin (1998)

    Google Scholar 

  • Gadia, S.K.: A Homogeneous Relational Model and Query Languages for Temporal Databases. ACM Trans. Database Syst. 13(4), 418–448 (1988)

    Article  MathSciNet  Google Scholar 

  • Gallaire, H., et al.: Logic and databases: A deductive approach. ACM Comput. Surv. 16(2), 153–185 (1984)

    Article  MathSciNet  Google Scholar 

  • Gardarin G., Valduriez P.: Relational Databases and Knowledge Bases. Addison Wesley, Reading (1989)

    Google Scholar 

  • Geppert A.: Objektrelationale und objektorientierte Datenbankkonzepte und -systeme. dpunkt, Heidelberg (2002)

    Google Scholar 

  • Gluchowski P., Gabriel R., Chamoni P.: Management Support Systeme und Business Intelligence—Computergestützte Informationssysteme für Fach- und Führungskräfte. Springer, Berlin (2008)

    Google Scholar 

  • Heuer A.: Objektorientierte Datenbanken. Addison Wesley, Reading (1997)

    Google Scholar 

  • Hughes J.G.: Object-Oriented Databases. Prentice-Hall, New York (1991)

    Google Scholar 

  • Inmon W.H.: Building the Data Warehouse. Wiley, Indianapolis (2005)

    Google Scholar 

  • Jarke M., Lenzerini M., Vassiliou Y., Vassiliadis P.: Fundamentals of Data Warehouses. Springer, Berlin (2000)

    Book  Google Scholar 

  • Kacprzyk J., Zadrozny S.: FQUERY for access—Fuzzy querying for a windows-based DBMS. In: Bosc P., Kacprzyk J. (eds.) Fuzziness in Database Management Systems, pp. 415–433. Physica, Heidelberg (1995)

    Chapter  Google Scholar 

  • Kemper A., Eickler A.: Datenbanksysteme—Eine Einführung. Oldenbourg, München (2013)

    Google Scholar 

  • Kim W.: Introduction to Object-Oriented Databases. The MIT Press, Cambridge (1990)

    Google Scholar 

  • Kimball R., Ross M., Thorntwaite W., Mundy J., Becker B.: The Datawarehouse Lifecycle Toolkit. Wiley, Indianapolis (2008)

    Google Scholar 

  • Lang S.M., Lockemann P. C.: Datenbankeinsatz. Springer, Berlin (1995)

    Google Scholar 

  • Lausen G., Vossen G.: Objekt-orientierte Datenbanken: Modelle und Sprachen. Oldenbourg, Berlin (1996)

    Google Scholar 

  • Lorie R.A., Kim W., McNabb D., Plouffe W., Meier A.: Supporting complex objects in a relational system for engineering databases. In: Kim W. et al. (eds.) Query Processing in Database Systems, pp. 145–155. Springer, Berlin (1985)

    Google Scholar 

  • Maier D., Warren D.S.: Computing with Logic—Logic Programming with Prolog. Benjamin/ Cummings, Menlo Park (1988)

    Google Scholar 

  • Martin J., Odell J.J.: Object-Oriented Analysis and Design. Prentice-Hall, Englewood Cliffs (1992)

    Google Scholar 

  • Meier A.: Erweiterung relationaler Datenbanksystems für technische Anwendungen. Informatik-Fachberichte, Vol. 135. Springer, Berlin (1987)

    Google Scholar 

  • Meier A. (Hrsg.): WWW & Datenbanken. Praxis der Wirtschaftsinformatik, Vol. 37, No. 214. dpunkt, Heidelberg (2000)

    Google Scholar 

  • Meier A., Wüst T.: Objektorientierte und objektrelationale Datenbanken—Ein Kompass für die Praxis. dpunkt, Heidelberg (2003)

    Google Scholar 

  • Meier A., Werro N., Albrecht M., Sarakinos M.: Using a Fuzzy Classification Query Language for Customer Relationship Management. Proc. 31st International Conference on Very Large Databases (VLDB), Trondheim, Norway, pp. 1089–1096 (2005)

    Google Scholar 

  • Meier A., Schindler G., Werro N.: Fuzzy classification on relational databases (Chapter XXIII). In: Galindo J. (ed.): Handbook of Research on Fuzzy Information Processing in Databases. Vol. II, pp. 586–614. IGI Global, Pennsylvania (2008)

    Google Scholar 

  • Mucksch, H., Behme, W. (eds.) Das Data-Warehouse-Konzept—Architektur. Datenmodelle, Anwendungen. Gabler, Wiesbaden (2000)

    Google Scholar 

  • Myrach, T.: Temporale Datenbanken in betrieblichen Informationssystemen—Prinzipien, Konzepte, Umsetzung. Teubner, Wiesbaden (2005)

    Book  Google Scholar 

  • Özsu M.T., Valduriez P.: Principles of Distributed Database Systems. Prentice Hall, Englewood Cliffs (1991)

    Google Scholar 

  • Petra F.E.: Fuzzy Databases—Principles and Applications. Kluwer, Boston (1996)

    Google Scholar 

  • Pons O., Vila M.A., Kacprzyk J. (eds.): Knowledge Management in Fuzzy Databases. Physica, Heidelberg (2000)

    MATH  Google Scholar 

  • Rahm E.: Mehrrechner-Datenbanksysteme. Addison Wesley, Bonn (1994)

    Google Scholar 

  • Rothnie, J.B., et al.: Introduction to a System for Distributed Databases. ACM Trans. Database Syst. 5(1), 1–17 (1980)

    Article  Google Scholar 

  • Schek, H.-J., Scholl, M.H.: The Relational Model with Relation-Valued Attributes. Inf. Syst. 11(2), 137–147 (1986)

    Article  Google Scholar 

  • Schindler G.: Fuzzy Datenanalyse durch kontextbasierte Datenbankabfragen. Deutscher Universitäts-Verlag, Wiesbaden (1998)

    Google Scholar 

  • Shenoi, S., Melton, A., Fan, L.T.: Functional Dependencies and Normal Forms in the Fuzzy Relational Database Model. Inf. Sci. 60, 1–28 (1992)

    Article  MathSciNet  Google Scholar 

  • Snodgrass, R.T.: The Temporal Query Language TQuel. ACM Trans. Database Syst. 12(2), 247–298 (1987)

    Article  MathSciNet  Google Scholar 

  • Snodgrass, R.T., et al.: A TSQL2 Tutorial. SIGMOD-Record 23(3), 27–33 (1994)

    Article  Google Scholar 

  • Stein, W.: Objektorientierte Analysemethoden—Vergleich, Bewertung, Auswahl. Bibliographisches Institut, Mannheim (1994)

    Google Scholar 

  • Stonebraker M.: The Ingres Papers. Addison Wesley, Reading (1986)

    Google Scholar 

  • Stonebraker M.: Object-Relational DBMSʼs—The Next Great Wave. Morgan Kaufmann, San Francisco (1996)

    Google Scholar 

  • Takahashi Y.: A Fuzzy Query Language for Relational Databases. In: Bosc P., Kacprzyk J. (eds.) Fuzzyness in Database Management Systems, pp. 365–384. Physica, Heidelberg (1995)

    Chapter  Google Scholar 

  • Türker C.: SQL:1999 & SQL:2003—Objektrelationales SQL, SQLJ & SQL/XML. dpunkt, Heidelberg (2003)

    Google Scholar 

  • Werro N.: Fuzzy Classification of Online Customers. Springer, Heidelberg (2015)

    Google Scholar 

  • Williams R. et al.: R*: An Overview of the Architecture. In: Scheuermann P. (ed.) Improving Database Usability and Responsiveness, pp. 1–27. Academic, New York (1982)

    Google Scholar 

  • Witten I. H., Frank E.: Data Mining. Morgan Kaufmann, Amsterdam (2005)

    Google Scholar 

  • Zadeh L. A.: Fuzzy Sets. Information and Control, No. 8, pp. 338–353 (1965)

    Article  MathSciNet  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department für Informatik, Universität Fribourg, Fribourg, Switzerland

    Andreas Meier

  2. Departement für Informatik, Hochschule Luzern, Rotkreuz, Switzerland

    Michael Kaufmann

Authors
  1. Andreas Meier
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Michael Kaufmann
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Michael Kaufmann .

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Fachmedien Wiesbaden GmbH, part of Springer Nature

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Meier, A., Kaufmann, M. (2019). Postrelational Databases. In: SQL & NoSQL Databases. Springer Vieweg, Wiesbaden. https://doi.org/10.1007/978-3-658-24549-8_6

Download citation

Publish with us

Policies and ethics

Search

Navigation