Advertisement

Database Management

  • Wolfram Wingerath
  • Norbert Ritter
  • Felix Gessert
Chapter
Part of the SpringerBriefs in Computer Science book series (BRIEFSCOMPUTER)

Abstract

The first databases were hierarchical and network databases, developed during the 1960s. They exposed procedural query interfaces (as opposed to descriptive ones), so that accessing specific information in one of these systems was similar to navigating to a specific file within a file system.

References

  1. [Agr+09]
    Parag Agrawal et al. “Asynchronous View Maintenance for VLSD Databases”. In: Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data. SIGMOD ’09. Providence, Rhode Island, USA: ACM, 2009, pp. 179–192. isbn: 978-1-60558-551-2. doi: 10.1145/1559845.1559866. url: http://doi.acm.org/10.1145/1559845.1559866.
  2. [BC79]
    O. Peter Buneman and Eric K. Clemons. “Efficiently Monitoring Relational Databases”. In: ACM Trans. Database Syst. 4.3 (Sept. 1979), pp. 368–382. issn: 0362-5915. doi: 10.1145/320083.320099. url: http://doi.acm.org/10.1145/320083.320099.
  3. [BCL89]
    José A. Blakeley, Neil Coburn, and Per-Ake Larson. “Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates”. In: ACM Trans. Database Syst. 14.3 (Sept. 1989), pp. 369–400. issn: 0362-5915. doi: 10.1145/68012.68015. url: http://doi.acm.org/10.1145/68012.68015.
  4. [BD91]
    Peter J. Brockwell and Richard A. Davis. Time Series: Theory and Methods. 2nd Edition. Springer Science & Business Media, 1991.Google Scholar
  5. [BKS00]
    Ladjel Bellatreche, Kamalakar Karlapalem, and Michel Schneider. “On Efficient Storage Space Distribution Among Materialized Views and Indices in Data Warehousing Environments”. In: Proceedings of the Ninth International Conference on Information and Knowledge Management. CIKM ’00. McLean, Virginia, USA: ACM, 2000, pp. 397–404. isbn: 1-58113-320-0. doi: 10.1145/354756.354846. url: http://doi.acm.org/10.1145/354756.354846.
  6. [Bli+16]
    Craig Blitz et al. Oracle Coherence 12c: Planning a Successful Deployment. Tech. rep. Oracle Corporation, June 2016.Google Scholar
  7. [BLT86]
    José A. Blakeley, Per-Ake Larson, and Frank Wm Tompa. “Efficiently Updating Materialized Views”. In: SIGMOD Rec. 15.2 (June 1986), pp. 61–71. issn: 0163-5808. doi: 10.1145/16856.16861. url: http://doi.acm.org/10.1145/16856.16861.
  8. [BM90]
    José A. Blakeley and Nancy L. Martin. “Join Index, Materialized View, and Hybrid-Hash Join: A Performance Analysis”. In: Proceedings of the Sixth International Conference on Data Engineering. Washington, DC, USA: IEEE Computer Society, 1990, pp. 256–263. isbn: 0-8186-2025-0. url: http://dl.acm.org/citation.cfm?id=645475.654167.
  9. [CB74]
    Donald D. Chamberlin and Raymond F. Boyce. “SEQUEL: A Structured English Query Language”. In: Proceedings of the 1974 ACM SIGFIDET (Now SIGMOD) Workshop on Data Description, Access and Control. SIGFIDET ’74. Ann Arbor, Michigan: ACM, 1974, pp. 249–264. doi: 10.1145/800296.811515. url: http://doi.acm.org/10.1145/800296.811515.
  10. [Cha+09]
    Leonardo Weiss F. Chaves et al. “Towards Materialized View Selection for Distributed Databases”. In: Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology. EDBT ’09. Saint Petersburg, Russia: ACM, 2009, pp. 1088–1099. isbn: 978-1-60558-422-5. doi: 10.1145/1516360.1516484. url: http://doi.acm.org/10.1145/1516360.1516484.
  11. [Cha95]
    Sharma Chakravarthy. “Early Active Database Efforts: A Capsule Summary”. In: IEEE Trans. on Knowl. and Data Eng. 7.6 (Dec. 1995), pp. 1008–1010. issn: 1041-4347. doi: 10.1109/69.476505. url: http://dx.doi.org/10.1109/69.476505.
  12. [Cod70]
    E. F. Codd. “A Relational Model of Data for Large Shared Data Banks”. In: Commun. ACM 13.6 (June 1970), pp. 377–387. issn: 0001-0782. doi: 10.1145/362384.362685. url: http://doi.acm.org/10.1145/362384.362685.
  13. [Cod71]
    E. F. Codd. “A Data Base Sublanguage Founded on the Relational Calculus”. In: Proceedings of the 1971 ACM SIGFIDET (Now SIGMOD) Workshop on Data Description, Access and Control. SIGFIDET ’71. San Diego, California: ACM, 1971, pp. 35–68. doi: 10.1145/1734714.1734718. url: http://doi.acm.org/10.1145/1734714.1734718.
  14. [Cod82]
    E. F. Codd. “Relational Database: A Practical Foundation for Productivity”. In: Commun. ACM 25.2 (Feb. 1982), pp. 109–117. issn: 0001-0782. doi: 10.1145/358396.358400. url: http://doi.acm.org/10.1145/358396.358400.
  15. [CPM96]
    Roberta Cochrane, Hamid Pirahesh, and Nelson Mendonça Mattos. “Integrating Triggers and Declarative Constraints in SQL Database Systems”. In: Proceedings of the 22th International Conference on Very Large Data Bases. VLDB ’96. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 1996, pp. 567–578. isbn: 1-55860-382-4. url: http://dl.acm.org/citation.cfm?id=645922.673498.
  16. [CY12]
    Rada Chirkova and Jun Yang. “Materialized Views”. In: Foundations and Trends in Databases 4.4 (2012), pp. 295–405. issn: 1931-7883. doi: 10.1561/1900000020. url: http://dx.doi.org/10.1561/1900000020.
  17. [D+́94]
    Oscar Díaz et al. “Supporting Dynamic Displays Using Active Rules”. In: SIGMOD Rec. 23.1 (Mar. 1994), pp. 21–26. issn: 0163-5808. doi: 10.1145/181550.181555. url: http://doi.acm.org/10.1145/181550.181555.
  18. [Das+12]
    Shirshanka Das et al. “All Aboard the Databus!: Linkedin’s Scalable Consistent Change Data Capture Platform”. In: Proceedings of the Third ACM Symposium on Cloud Computing. SoCC ’12. San Jose, California: ACM, 2012, 18:1–18:14. isbn: 978-1-4503-1761-0. doi: 10.1145/2391229.2391247. url: http://doi.acm.org/10.1145/2391229.2391247.
  19. [Datb]
    Oracle Active Data Guard: Real-Time Data Protection and Availability. Oracle. Oct. 2015.Google Scholar
  20. [DF14]
    Ted Dunning and Ellen Friedman. Time Series Databases: New Ways to Store and Access Data. Ed. by Mike Loukides. O’Reilly Media, Nov. 2014.Google Scholar
  21. [EC75]
    Kapali P. Eswaran and Donald D. Chamberlin. “Functional Specifications of a Subsystem for Data Base Integrity”. In: Proceedings of the 1st International Conference on Very Large Data Bases. VLDB ’75. Framingham, Massachusetts: ACM, 1975, pp. 48–68. isbn: 978-1-4503-3920-9. doi: 10.1145/1282480.1282484. url: http://doi.acm.org/10.1145/1282480.1282484.
  22. [Elk90]
    Charles Elkan. “Independence of Logic Database Queries and Update”. In: Proceedings of the Ninth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. PODS ’90. Nashville, Tennessee, USA: ACM, 1990, pp. 154–160. isbn: 0-89791-352-3. doi: 10.1145/298514.298557. url: http://doi.acm.org/10.1145/298514.298557.
  23. [Eri98]
    Joakim Eriksson. “Real-Time and Active Databases: A Survey”. In: Active, Real-Time, and Temporal Database Systems: Second International Workshop, ARTDB-97 Como, Italy, September 8–9, 1997 Proceedings. Ed. by Sten F. Andler and Jörgen Hansson. Berlin, Heidelberg: Springer Berlin Heidelberg, 1998, pp. 1–23. isbn: 978-3-540-49151-4. doi: 10.1007/3-540-49151-1_1. url: http://dx.doi.org/10.1007/3-540-49151-1_1.
  24. [FS76]
    James P. Fry and Edgar H. Sibley. “Evolution of Data-Base Management Systems”. In: ACM Comput. Surv. 8.1 (Mar. 1976), pp. 7–42. issn: 0360-0300. doi: 10.1145/356662.356664. url: http://doi.acm.org/10.1145/356662.356664.
  25. [GGD95]
    Andreas Geppert, Stella Gatziu, and Klaus R. Dittrich. “A designer’s benchmark for active database management systems: 007 meets the BEAST”. In: Rules in Database Systems: Second International Workshop, RIDS ’95 Glyfada, Athens, Greece September 25–27, 1995 Proceedings. Ed. by Timos Sellis. Berlin, Heidelberg: Springer Berlin Heidelberg, 1995, pp. 309–323. isbn: 978-3-540-45137-2.Google Scholar
  26. [GJSM96]
    Ashish Gupta, H. V. Jagadish, and Inderpal Singh Mumick. “Data integration using self-maintainable views”. In: Advances in Database Technology – EDBT ’96: 5th International Conference on Extending Database Technology Avignon, France, March 25–29, 1996 Proceedings. Ed. by Peter Apers, Mokrane Bouzeghoub, and Georges Gardarin. Berlin, Heidelberg: Springer Berlin Heidelberg, 1996, pp. 140–144. isbn: 978-3-540-49943-5. doi: 10.1007/BFb0014149. url: http://dx.doi.org/10.1007/BFb0014149.
  27. [GM99]
    Ashish Gupta and Iderpal Singh Mumick. Materialized views: techniques, implementations, and applications. MIT press, 1999. isbn: 0-262-57122-6.Google Scholar
  28. [Gol]
    Oracle GoldenGate 12c: Real-Time Access to Real-Time Information. Oracle. Mar 2015.Google Scholar
  29. [Haz]
    Hazelcast: Continuous Query Cache. Accessed: 2017-11-12. Hazelcast. 2017. url: http://docs.hazelcast.org/docs/latest-development/manual/html/Distributed_Query/Continuous_Query_Cache.html
  30. [HW93]
    E. Hanson and J. Widom. An Overview of Production Rules in Database Systems. Technical Report 1993-18. Stanford University, 1993. url: http://ilpubs.stanford.edu:8090/25/.CrossRefGoogle Scholar
  31. [Ign]
    Introducing Apache Ignite TM. GridGain Systems Inc. 2017.Google Scholar
  32. [Inf]
    Overview of InfoSphere CDC (IBM Infosphere Change Data Capture, Version 6.5.2). Accessed: 2017-11-12. IBM. 2011. url: https://www.ibm.com/support/knowledgecenter/en/SSTRGZ_10.1.3/com.ibm.cdcdoc.mcadminguide.doc/concepts/overview_of_cdc.html.
  33. [Kle16]
    Martin Kleppmann. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. O’Reilly, 2016.Google Scholar
  34. [Lab+00]
    Wilburt Labio et al. “Performance Issues in Incremental Warehouse Maintenance”. In: Proceedings of the 26th International Conference on Very Large Data Bases. VLDB ’00. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 2000, pp. 461–472. isbn: 1-55860-715-3. url: http://dl.acm.org/citation.cfm?id=645926.671684.
  35. [LS93]
    Alon Y. Levy and Yehoshua Sagiv. “Queries Independent of Updates”. In: Proceedings of the 19th International Conference on Very Large Data Bases. VLDB ’93. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 1993, pp. 171–181. isbn: 1-55860-152-X. url: http://dl.acm.org/citation.cfm?id=645919.672674.
  36. [Luc+17]
    Greg Luck et al. Mastering Hazelcast IMDG. Tech. rep. Hazelcast, Feb. 2017.Google Scholar
  37. [MK+17]
    Chuck Murray, Tom Kyte, et al. “Using Continuous Query Notification (CQN)”. In: Oracle Database Development Guide, 12c Release 1 (12.1). Oracle, May 2017.Google Scholar
  38. [Mor83]
    Matthew Morgenstern. “Active Databases As a Paradigm for Enhanced Computing Environments”. In: Proceedings of the 9th International Conference on Very Large Data Bases VLDB ’83. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 1983, pp. 34–42. isbn: 0-934613-15-X. url: http://dl.acm.org/citation.cfm?id=645911.671127.
  39. [Mul11]
    Greg Sabino Mullane. “NOTIFY vs. Prepared Transactions in Postgres(the Bucardo solution)”. In: End Point Blog (May 2011). Accessed:2017-11-12. url: https://www.endpoint.com/blog/2011/05/03/notify-vs-prepared-transactions-in.
  40. [Mul14]
    Greg Sabino Mullane. “Version 5 of Bucardo database replication system”. In: End Point Blog (June 2014). Accessed: 2017-11-12. url: https://www.endpoint.com/blog/2014/06/23/bucardo-5-multimaster-postgres-released.
  41. [Nak01]
    Hiroaki Nakamura. “Incremental Computation of Complex Object Queries”. In: Proceedings of the 16th ACM SIGPLAN Conference on Object- oriented Programming Systems, Languages, and Applications. OOPSLA ’01. Tampa Bay FL, USA: ACM, 2001, pp. 156–165. isbn: 1-58113-335-9. DOI: 10.1145/504282.504294 url: http://doi.acm.org/10.1145/504282.504294.
  42. [NLR98]
    Anisoara Nica, Amy J. Lee, and Elke A. Rundensteiner. “The CVS Algorithm for View Synchronization in Evolvable Large-Scale Information Systems”. In: Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology. EDBT ’98. Berlin, Heidelberg: Springer-Verlag, 1998, pp.359–373. isbn: 3-540-64264-1. url: http://dlacmorg/citation.cfm?id=645338.757494.Google Scholar
  43. [Nota]
    PostgreSQL 9.6 Documentation: Notify. Accessed: 2017-05-13. The PostgreSQL Global Development Group. 2017. url: https://www.postgresql.org/docs/9.6/static/sql-notify.html.
  44. [Notb]
    SQL Server 2008 R2 Books Online: Creating a Query for Notification. Accessed: 2017-05-12. Microsoft. 2017. url:https://msdn.microsoft.com/en-us/library/ms181122.aspx.
  45. [Notc]
    SQL Server 2008 R2 Books Online: Planning for Notifications. Accessed: 2017-05-12. Microsoft. 2017. url: https://technet.microsoftcom/en-us/library/ms187528(v=sql105).aspx{#}Anchor\_1.Google Scholar
  46. [Notd]
    SQL Server 2008 R2 Books Online: Query Notification Messages. Accessed: 2017-05-13. Microsoft. 2017. url: https://msdn.microsoft.com/en-us/library/ms189308(v=sql.105).aspx.
  47. [Note]
    SQL Server 2008 R2 Books Online: Understanding When Query Notifications Occur. Accessed: 2017-05-15. Microsoft. 2017. url: https://msdn.microsoft.com/en-us/library/ms188323(v=sql.105).aspx.
  48. [Notf]
    SQL Server 2008 R2 Books Online: Using Query Notifications. Accessed: 2017-05-13. Microsoft. 2017. url: https://technet.microsoft.com/en-us/library/ms175110(v=sql105).aspx.
  49. [Oll06]
    T William Olle. “Nineteen Sixties History of Data Base Management”.In: History of Computing and Education 2 (HCE2): IFIP 19th World Computer Congress, WG 9.7, TC 9: History of Computing Proceedings of the Second Conference on the History of Computing and Education, August 21–24, 2006, Santiago, Chile Ed. by John Impagliazzo. Boston, MA: Springer US, 2006, pp. 67–75.isbn: 978-0-387-34741-7. DOI:10.1007/978-0-387-34741-7_4. url: https://doi.org/10.1007/978-0-387-34741-7_4.
  50. [Ora]
    Oracle Database Development Guide 12c Release 1 (12.1) Oracle.May 2016.Google Scholar
  51. [PD99]
    Norman W.Paton and Oscar Díaz. “Active Database Systems”. In: ACM Comput. Surv. 31.1 (Mar. 1999), pp. 63–103. issn: 0360-0300. DOI:10.1145/311531.311623. url: http://doi.acm.org/10.1145/311531.311623.CrossRefGoogle Scholar
  52. [Pur+93]
    B. Purimetla et al. A Study of Distributed Real-Time Active Database Applications Tech. rep. Amherst, MA, USA, 1993.Google Scholar
  53. [Qua+96]
    Dallan Quass et al. “Making Views Self-maintainable for Data Warehousing”. In: Proceedings of the Fourth International Conference on Parallel and Distributed Information Systems. DIS’96.MiamiBeach,Florida, USA: IEEE Computer Society, 1996, pp. 158–169. isbn: 0-8186-7475-X. url: http://dl.acm.org/citation.cfm?id=382006.383205.
  54. [Ram+96]
    Krithi Ramamritham et al. “Integrating Temporal, Real-time, an Active Databases”. In: SIGMOD Rec. 25.1 (Mar 1996), pp. 8–12. issn: 0163-5808. DOI: 10.1145/381854.381868. url: http://doi.acm.org/10.1145/381854.381868.CrossRefGoogle Scholar
  55. [Ruz+11]
    Joseph Ruzzi et al. Oracle Coherence Developer’s Guide Release 3.7.12011.Google Scholar
  56. [Ruz+14a]
    Joseph Ruzzi et al. “Querying Data In a Cache”. In: Oracle Fusion Middleware: Developing Applications with Oracle Coherence, 12c (12.1.2). Oracle,May 2014.Google Scholar
  57. [Ruz+14b]
    Joseph Ruzzi et al. “Using Continuous Query Caching”. In: Oracle Fusion Middleware: Developing Applications with Oracle Coherence, 12c (12.1.2) Oracle, May 2014.Google Scholar
  58. [Sal+00]
    Kenneth Salem et al. “How to Roll a Join: Asynchronous Incremental View Maintenance”. In: SIGMOD Rec. 29.2 (May 2000), pp. 129–140. issn:0163-5808. DOI: 10.1145/335191.335393. url: http://doi.acm.org/10.1145/335191.335393.CrossRefGoogle Scholar
  59. [Sch+91]
    Ulf Schreier et al. “Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS”. In: Proceedings of the 17th International Conference on Very Large Data Bases. VLDB ’91. San Francisco, CA, USA:Morgan Kaufmann Publishers Inc., 1991, pp. 469–478. isbn: 1-55860-150-3. url: http://dl.acm.org/citation.cfm?id=645917.672314.
  60. [SD95]
    Eric Simon and Angelika Kotz Dittrich. “Promises and Realities of Active Database Systems”. In: Proceedings of the 21th International Conference on Very Large Data Bases. VLDB ’95. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 1995, pp. 642–653. isbn: 1-55860-379-4. url: http://dl.acm.org/citationcfm?id=645921.673319.
  61. [Sig+18]
    Benoît Sigoure et al. OpenTSDB Accessed: 2018-05-10. 2018. url: http://opentsdb.net/.
  62. [SKM92]
    Eric Simon, Jerry Kiernan, and Christophe de Maindreville. “Implementing High Level Active Rules on Top of a Relational DBMS”. In: Proceedings of the 18th International Conference on Very Large Data Bases. VLDB ’92. San Francisco, CA, USA: Morgan Kaufmann Publishers Inc., 1992,pp. 315–326. isbn: 1-55860-151-1. url: http://dl.acm.org/citation.cfm?id=645918.672488.
  63. [SP89]
    Arie Segev and Jooseok Park. “Maintaining Materialized Views in Distributed Databases”. In: Proceedings of the Fifth International Conference on Data Engineering. Washington, DC, USA: IEEE Computer Society 1989, pp. 262–270. isbn: 0-8186-1915-5. url: http://dl.acm.org/citation.cfm?id=645474.653729
  64. [Sto+90]
    Michael Stonebraker et al. “On Rules, Procedure, Caching and Views in Data Base Systems”. In: Proceedings of the 1990 ACM SIGMOD Inter- national Conference on Management of Data. SIGMOD ’90. Atlantic City New Jersey USA:ACM, 1990, pp. 281–290. isbn: 0-89791-365-5. DOI: 10.1145/93597.98737. url:http://doi.acm.org/10.1145/93597.98737.
  65. [Sto86]
    Michael Stonebraker. “Object Management in POSTGRES Using Procedures”. In: Proceedings on the 1986 International Workshop on Object- oriented Database Systems. OODS ’86. Pacific Grove, California, USA: IEEE Computer Society Press, 1986, pp. 66–72. isbn: 0-8186-0734-3. url: http://dl.acm.org/citation.cfm?id=318826.318840.
  66. [TL76]
    D. C. Tsichritzis and F H. Lochovsky. “Hierarchical Data-Base Management: A Survey”. In: ACM Comput. Surv 8.1 (Mar 1976), pp.105–123. issn: 0360-0300. DOI: 10.1145/356662.356667. url: http://doi.acm.org/10.1145/356662.356667.CrossRefGoogle Scholar
  67. [Vis96]
    Dimitri Vista. “Optimizing incremental view maintenance expressions in relational databases”. PhD thesis. University of Toronto, 1996.Google Scholar
  68. [Vis98]
    Dimitra Vista. “Integration of incremental view maintenance into query optimizers”. In: Advances in Database Technology — EDBT’98: 6th International Conference on Extending Database Technology Valencia, Spain, March 23–27, 1998 Proceedings. Ed. by Hans-Jörg Schek et al. Berlin,Heidelberg: Springer Berlin Heidelberg, 1998. Chap. EDBT 1998: Advances in Database Technology — EDBT’98, pp. 374–388.textscisbn: 978-3-540-69709-1. DOI: 10.1007/BFb0100997. textscurl: https://doi.org/10.1007/BFb0100997.Google Scholar
  69. [Wit+07]
    Andrew Witkowski et al. “Continuous Queries in Oracle”. In: Proceedings of the 33rd International Conference on Very Large Data Bases. VLDB ’07. Vienna, Austria: VLDB Endowment, 2007, pp. 1173–1184. ISBN:978-1-59593-649-3. url: http://dl.acm.org/citation.cfm?id=1325851.1325985.
  70. [Yi+03]
    Ke Yi et al. “Efficient Maintenance of Materialized Top-kViews”. In: Proceedings of the 19th International Conference on Data Engineering (2003).Google Scholar
  71. [Inf16]
    InfluxData Inc. InfluxDB Accessed: 2016-09-18.2016. url: https://www.influxdata.com/time-series-platform/influxdb/.
  72. [Pro18]
    Project FiFo. DalmatinerDB Accessed: 2018-05-10.2018. url: https://dalmatiner.io/.

Copyright information

© The Author(s), under exclusive license to Springer Nature Switzerland AG 2019

Authors and Affiliations

  • Wolfram Wingerath
    • 1
  • Norbert Ritter
    • 2
  • Felix Gessert
    • 1
  1. 1.Baqend GmbHHamburgGermany
  2. 2.University of HamburgHamburgGermany

Personalised recommendations