Skip header Section
Skip Bibliometrics Section
Database Management SystemsJune 2000
- Authors:
- Raghu Ramakrishnan,
- Johannes Gehrke
Skip Abstract Section
Abstract
From the Publisher:
Database Management Systems (DBMS) is a must for any course in database systems or file organization. DBMS provides a hands-on approach to relational database systems, with an emphasis on practical topics such as indexing methods, SQL, and database design. New to this edition are the early coverage of the ER model, new chapters on Internet databases, data mining, and spatial databases, and a new supplement on practical SQL assignments (with solutions for instructors' use). Many other chapters have been reorganized or expanded to provide up-to-date coverage.
Cited By
- Chatelain P and Milhaud X (2024). Estimation and prediction with data quality indexes in linear regressions, Computational Statistics, 39:6, (3373-3404), Online publication date: 1-Sep-2024.
- Winker T, Çalikyilmaz U, Gruenwald L and Groppe S Quantum Machine Learning for Join Order Optimization using Variational Quantum Circuits Proceedings of the International Workshop on Big Data in Emergent Distributed Environments, (1-7)
- Peng Z, Wang Z and Deng D (2023). Near-Duplicate Sequence Search at Scale for Large Language Model Memorization Evaluation, Proceedings of the ACM on Management of Data, 1:2, (1-18), Online publication date: 13-Jun-2023.
- Luo Z, Cai S, Wang Y and Ooi B (2023). Regularized Pairwise Relationship based Analytics for Structured Data, Proceedings of the ACM on Management of Data, 1:1, (1-27), Online publication date: 26-May-2023.
- Liu X, Wang S, Sun M, Pan S, Li G, Jha S, Yan C, Yang J, Lu S and Cheung A (2023). Leveraging Application Data Constraints to Optimize Database-Backed Web Applications, Proceedings of the VLDB Endowment, 16:6, (1208-1221), Online publication date: 1-Feb-2023.
- Xia Y, Yu X, Butrovich M, Pavlo A and Devadas S Litmus: Towards a Practical Database Management System with Verifiable ACID Properties and Transaction Correctness Proceedings of the 2022 International Conference on Management of Data, (1478-1492)
- Bahrami S and Ghasemi R (2022). A new secure and searchable data outsourcing leveraging a Bucket-Chain index tree, Journal of Information Security and Applications, 67:C, Online publication date: 1-Jun-2022.
- Magalhaes A, Monteiro J and Brayner A (2021). Main Memory Database Recovery, ACM Computing Surveys, 54:2, (1-36), Online publication date: 31-Mar-2022.
- Sun X, Sun S, Luo Q and He B (2022). An in-depth study of continuous subgraph matching, Proceedings of the VLDB Endowment, 15:7, (1403-1416), Online publication date: 1-Mar-2022.
- Console M, Guagliardo P and Libkin L (2022). Fragments of bag relational algebra, Information Systems, 105:C, Online publication date: 1-Mar-2022.
- Wu Y, Chang R, Hellerstein J, Satyanarayan A and Wu E (2022). DIEL: Interactive Visualization Beyond the Here and Now, IEEE Transactions on Visualization and Computer Graphics, 28:1, (737-746), Online publication date: 1-Jan-2022.
- Singla S, Eldawy A, Diao T, Mukhopadhyay A and Scudiero E The Raptor Join Operator for Processing Big Raster + Vector Data Proceedings of the 29th International Conference on Advances in Geographic Information Systems, (324-335)
- Shrivastava P, Jain S and Gupta S (2021). Reducing Replica Update Cost in Replicated DRTDBS, International Journal of Knowledge-Based Organizations, 11:3, (15-28), Online publication date: 1-Jul-2021.
- Ives Z, Pottinger R, Kumar A, Gehrke J and Giceva J (2021). The future of data(base) education, Proceedings of the VLDB Endowment, 14:12, (3239-3239), Online publication date: 1-Jul-2021.
- Wei Z and Link S (2021). Embedded Functional Dependencies and Data-completeness Tailored Database Design, ACM Transactions on Database Systems, 46:2, (1-46), Online publication date: 30-Jun-2021.
- Arenas M, Croquevielle L, Jayaram R and Riveros C When is approximate counting for conjunctive queries tractable? Proceedings of the 53rd Annual ACM SIGACT Symposium on Theory of Computing, (1015-1027)
- Zou J, Das A, Barhate P, Iyengar A, Yuan B, Jankov D and Jermaine C (2021). Lachesis, Proceedings of the VLDB Endowment, 14:8, (1262-1275), Online publication date: 1-Apr-2021.
- Jonathan A, Chandra A and Weissman J WASP Proceedings of the 21st International Middleware Conference, (221-235)
- Pham T, Tran N, Pham H, Nguyen T and Ta Minh T Efficient Low-Latency Dynamic Licensing for Deep Neural Network Deployment on Edge Devices Proceedings of the 2020 3rd International Conference on Computational Intelligence and Intelligent Systems, (44-49)
- George J, Verma M, Venkatasubramanian R and Subrahmanyam P go-pmem Proceedings of the 2020 USENIX Conference on Usenix Annual Technical Conference, (859-872)
- Pandey S and Shanker U (2020). Transaction scheduling protocols for controlling priority inversion, Computer Science Review, 35:C, Online publication date: 1-Feb-2020.
- Surbakti F, Wang W, Indulska M and Sadiq S (2022). Factors influencing effective use of big data, Information and Management, 57:1, Online publication date: 1-Jan-2020.
- Hogan A, Riveros C, Rojas C and Soto A A Worst-Case Optimal Join Algorithm for SPARQL The Semantic Web – ISWC 2019, (258-275)
- Orvalho P, Terra-Neves M, Ventura M, Martins R and Manquinho V Encodings for Enumeration-Based Program Synthesis Principles and Practice of Constraint Programming, (583-599)
- Xia M, Chi K, Wang X and Cheng Z (2019). Mode-oriented hybrid programming of sensor network nodes for supporting rapid and flexible utility assembly, Computer Networks: The International Journal of Computer and Telecommunications Networking, 158:C, (77-97), Online publication date: 20-Jul-2019.
- Cao Y, Fan W and Yuan T (2019). Block as a value for SQL over NoSQL, Proceedings of the VLDB Endowment, 12:10, (1153-1166), Online publication date: 1-Jun-2019.
- Shrivastava P and Shanker U Real Time Transaction Management in Replicated DRTDBS Databases Theory and Applications, (91-103)
- Choi J, Nam E, Seong Y, Yoon J, Lee S, Kim H, Park J, Woo Y, Lee S and Min S (2018). HIL, ACM Transactions on Storage, 14:4, (1-29), Online publication date: 30-Nov-2018.
- Cao Y, Fan W, Geerts F and Lu P (2018). Bounded Query Rewriting Using Views, ACM Transactions on Database Systems, 43:1, (1-46), Online publication date: 11-Apr-2018.
- Komamizu T, Amagasa T and Kitagawa H CROISSANT Proceedings of the 19th International Conference on Information Integration and Web-based Applications & Services, (284-288)
- Cao Y, Fan W, Wang Y, Yuan T, Li Y and Chen L BEAS Proceedings of the 2017 ACM International Conference on Management of Data, (1667-1670)
- Naeem M, Dobbie G, Lutteroth C and Weber G (2017). Skewed distributions in semi-stream joins, Information Systems, 64:C, (63-74), Online publication date: 1-Mar-2017.
- Bater J, Elliott G, Eggen C, Goel S, Kho A and Rogers J (2017). SMCQL, Proceedings of the VLDB Endowment, 10:6, (673-684), Online publication date: 1-Feb-2017.
- Peng C, Du H and Warren Liao T (2017). A research on the cutting database system based on machining features and TOPSIS, Robotics and Computer-Integrated Manufacturing, 43:C, (96-104), Online publication date: 1-Feb-2017.
- Huang H, Song J, Lin X, Ma S and Huai J TGraph Proceedings of the 25th ACM International on Conference on Information and Knowledge Management, (2469-2472)
- Rein P Deducing classes: integrating the domain models of object-oriented applications Companion Proceedings of the 2016 ACM SIGPLAN International Conference on Systems, Programming, Languages and Applications: Software for Humanity, (67-68)
- Lu Y, Chowdhery A and Kandula S Optasia Proceedings of the Seventh ACM Symposium on Cloud Computing, (57-70)
- Shaikhha A, Klonatos Y, Parreaux L, Brown L, Dashti M and Koch C How to Architect a Query Compiler Proceedings of the 2016 International Conference on Management of Data, (1907-1922)
- Cao Y and Fan W An Effective Syntax for Bounded Relational Queries Proceedings of the 2016 International Conference on Management of Data, (599-614)
- Cao Y, Fan W, Geerts F and Lu P Bounded Query Rewriting Using Views Proceedings of the 35th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, (107-119)
- Ma S, Li J, Hu C, Lin X and Huai J (2016). Big graph search, Frontiers of Computer Science: Selected Publications from Chinese Universities, 10:3, (387-398), Online publication date: 1-Jun-2016.
- Lu Y, Shu J and Sun L (2016). Blurred Persistence, ACM Transactions on Storage, 12:1, (1-29), Online publication date: 26-Feb-2016.
- (2015). Practical Identification of Dynamic Precedence Criteria to Produce Critical Results from Big Data Streams, Big Data Research, 2:4, (127-144), Online publication date: 1-Dec-2015.
- Youyou Lu , Jiwu Shu , Jia Guo , Shuai Li and Mutlu O (2015). High-Performance and Lightweight Transaction Support in Flash-Based SSDs, IEEE Transactions on Computers, 64:10, (2819-2832), Online publication date: 1-Oct-2015.
- Xiao L, Ren K, Zheng Q and Gibson G ShardFS vs. IndexFS Proceedings of the Sixth ACM Symposium on Cloud Computing, (236-249)
- Hammoud M, Rabbou D, Nouri R, Beheshti S and Sakr S (2015). DREAM, Proceedings of the VLDB Endowment, 8:6, (654-665), Online publication date: 1-Feb-2015.
- Ghodsnia P, Bowman I and Nica A Parallel I/O aware query optimization Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, (349-360)
- Mani G, Byun J and Cocca P Enhancing communication and collaboration through integrated internet and intranet architecture Proceedings of the 31st ACM international conference on Design of communication, (91-100)
- Zhang C and Ré C Towards high-throughput gibbs sampling at scale Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data, (397-408)
- Ghoting A, Gunnels J, Kambadur P, Pednault E and Squillante M (2013). Trends and outlook for the massive-scale analytics stack, IBM Journal of Research and Development, 57:3-4, (2-2), Online publication date: 1-May-2013.
- Tserendorj T, Grimm S and Hitzler P Approximate instance retrieval on ontologies Proceedings of the 21st international conference on Database and expert systems applications: Part I, (503-511)
- Staworko S, Boneva I and Groz B The view update problem for XML Proceedings of the 2010 EDBT/ICDT Workshops, (1-9)
- Zhang W, Zhang Y, Cheema M and Lin X Counting distinct objects over sliding windows Proceedings of the Twenty-First Australasian Conference on Database Technologies - Volume 104, (75-84)
- Ramaswamy S and Rose K (2009). Towards optimal indexing for relevance feedback in large image databases, IEEE Transactions on Image Processing, 18:12, (2780-2789), Online publication date: 1-Dec-2009.
- Nehme R, Works K, Rundensteiner E and Bertino E (2009). Query mesh, Proceedings of the VLDB Endowment, 2:2, (1530-1533), Online publication date: 1-Aug-2009.
- Deng K, Zhou X, Shen H, Sadiq S and Li X (2009). Instance optimal query processing in spatial networks, The VLDB Journal — The International Journal on Very Large Data Bases, 18:3, (675-693), Online publication date: 1-Jun-2009.
- Nassiri-Mofakham F, Nematbakhsh M, Baraani-Dastjerdi A and Ghasem-Aghaee N (2009). Electronic promotion to new customers using mkNN learning, Information Sciences: an International Journal, 179:3, (248-266), Online publication date: 15-Jan-2009.
- Engle J and Robertson E HLS Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge, (28-39)
- Lohfert R, Lu J and Zhao D Solving SQL Constraints by Incremental Translation to SAT Proceedings of the 21st international conference on Industrial, Engineering and Other Applications of Applied Intelligent Systems: New Frontiers in Applied Artificial Intelligence, (669-676)
- Jouini K and Jomier G Avoiding version redundancy for high performance reads in temporal databases Proceedings of the 4th international workshop on Data management on new hardware, (41-46)
- Taylor C, Gittens M and Miranskyy A A case study in database reliability Proceedings of the 1st international workshop on Testing database systems, (1-6)
- Saito T and Morishita S Relational-style XML query Proceedings of the 2008 ACM SIGMOD international conference on Management of data, (303-314)
- Cappos J and Hartman J San Fermín Proceedings of the 5th USENIX Symposium on Networked Systems Design and Implementation, (147-160)
- Buchsbaum A, Gansner E, Procopiuc C and Venkatasubramanian S (2008). Rectangular layouts and contact graphs, ACM Transactions on Algorithms, 4:1, (1-28), Online publication date: 1-Mar-2008.
- Zhang Y, Fan W, Chen H, Sheng H and Wu Z Extending online travel agency with adaptive reservations Proceedings of the 2007 OTM Confederated international conference on On the move to meaningful internet systems: CoopIS, DOA, ODBASE, GADA, and IS - Volume Part I, (285-299)
- Ghelli G, Onose N, Rose K and Siméon J A better semantics for XQuery with side-effects Proceedings of the 11th international conference on Database programming languages, (81-96)
- Han W, Lee J, Moon Y and Jiang H Ranked subsequence matching in time-series databases Proceedings of the 33rd international conference on Very large data bases, (423-434)
- Lin X, Zhang Q, Yuan Y and Liu Q (2007). Error minimization in approximate range aggregates, Data & Knowledge Engineering, 62:1, (156-176), Online publication date: 1-Jul-2007.
- Stahlberg P, Miklau G and Levine B Threats to privacy in the forensic analysis of database systems Proceedings of the 2007 ACM SIGMOD international conference on Management of data, (91-102)
- Byun J, Sohn Y and Bertino E Systematic control and management of data integrity Proceedings of the eleventh ACM symposium on Access control models and technologies, (101-110)
- Zhuge H and Xing Y Integrity theory for resource space model and its application Proceedings of the 6th international conference on Advances in Web-Age Information Management, (8-24)
- Xu C and Cheung S Inconsistency detection and resolution for context-aware middleware support Proceedings of the 10th European software engineering conference held jointly with 13th ACM SIGSOFT international symposium on Foundations of software engineering, (336-345)
- Xu C and Cheung S (2005). Inconsistency detection and resolution for context-aware middleware support, ACM SIGSOFT Software Engineering Notes, 30:5, (336-345), Online publication date: 1-Sep-2005.
- Vieira J, Bernardino J and Madeira H Efficient compression of text attributes of data warehouse dimensions Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery, (356-367)
- Shmueli E, Waisenberg R, Elovici Y and Gudes E Designing secure indexes for encrypted databases Proceedings of the 19th annual IFIP WG 11.3 working conference on Data and Applications Security, (54-68)
- Davis J, Burnside E, Dutra I, Page D, Ramakrishnan R, Costa V and Shavlik J View learning for statistical relational learning Proceedings of the 19th international joint conference on Artificial intelligence, (677-683)
- Govindaraju N and Manocha D Efficient relational database management using graphics processors Proceedings of the 1st international workshop on Data management on new hardware, (1-es)
- Jagadish H, Ooi B, Tan K, Yu C and Zhang R (2005). iDistance, ACM Transactions on Database Systems, 30:2, (364-397), Online publication date: 1-Jun-2005.
- Cheng R, Xia Y, Prabhakar S and Shah R Change Tolerant Indexing for Constantly Evolving Data Proceedings of the 21st International Conference on Data Engineering, (391-402)
- Liu J, Vincent M, Liu C and Mohania M Checking multivalued dependencies in XML Proceedings of the 7th Asia-Pacific web conference on Web Technologies Research and Development, (320-332)
- Varró G, Friedl K and Varró D (2005). Graph Transformation in Relational Databases, Electronic Notes in Theoretical Computer Science (ENTCS), 127:1, (167-180), Online publication date: 1-Mar-2005.
- Özsoyoǧlu G, Altingövde I, Al-Hamdani A, Özel S, Ulusoy Ö and Özsoyoǧlu Z (2004). Querying web metadata, ACM Transactions on Database Systems, 29:4, (581-634), Online publication date: 12-Dec-2004.
- Bruni R (2004). Discrete models for data imputation, Discrete Applied Mathematics, 144:1-2, (59-69), Online publication date: 1-Nov-2004.
- Agrawal R, Bayardo R, Faloutsos C, Kiernan J, Rantzau R and Srikant R Auditing compliance with a Hippocratic database Proceedings of the Thirtieth international conference on Very large data bases - Volume 30, (516-527)
- Lechner S and Schrefl M Trasformers-by-example Proceedings of the 2004 ACM symposium on Applied computing, (1654-1661)
- Gummadi A, Yoon J, Shah B and Raghavan V A bitmap-based access control for restricted views of XML documents Proceedings of the 2003 ACM workshop on XML security, (60-68)
- Yu H, Agrawal D and El Abbadi A Tabular placement of relational data on MEMS-based storage devices Proceedings of the 29th international conference on Very large data bases - Volume 29, (680-693)
- Hankins R and Patel J Data morphing Proceedings of the 29th international conference on Very large data bases - Volume 29, (417-428)
- Gionis A, Kujala T and Mannila H Fragments of order Proceedings of the ninth ACM SIGKDD international conference on Knowledge discovery and data mining, (129-136)
- Çamoglu O, Kahveci T and Singh A Towards Index-based Similarity Search for Protein Structure Databases Proceedings of the IEEE Computer Society Conference on Bioinformatics
- Cooperman G and Robinson E Memory-based and disk-based algorithms for very high degree permutation groups Proceedings of the 2003 international symposium on Symbolic and algebraic computation, (66-73)
- Yiannis J and Zobel J External sorting with on-the-fly compression Proceedings of the 20th British national conference on Databases, (115-130)
- Kim K, Kim Y and Lee H The framework for the message transport agent in a web-based information system Proceedings of the 2nd international conference on Human.society@internet, (582-587)
- O'Connell S and Winterbottom N (2003). Performing joins without decompression in a compressed database system, ACM SIGMOD Record, 32:1, (6-11), Online publication date: 1-Mar-2003.
- Oliveira S and Zaïane O Foundations for an access control model for privacy preservation in multi-relational association rule mining Proceedings of the IEEE international conference on Privacy, security and data mining - Volume 14, (19-26)
- Fernández M, Kadiyska Y, Suciu D, Morishima A and Tan W (2002). SilkRoute, ACM Transactions on Database Systems, 27:4, (438-493), Online publication date: 1-Dec-2002.
- Lou W and Lu H Efficient prediction of web accesses on a proxy server Proceedings of the eleventh international conference on Information and knowledge management, (169-176)
- Kounev S and Buchmann A Improving data access of J2EE applications by exploiting asynchronous messaging and caching services Proceedings of the 28th international conference on Very Large Data Bases, (574-585)
- Ramamurthy R, DeWitt D and Su Q A case for fractured mirrors Proceedings of the 28th international conference on Very Large Data Bases, (430-441)
- Agrawal R, Kiernan J, Srikant R and Xu Y Hippocratic databases Proceedings of the 28th international conference on Very Large Data Bases, (143-154)
- Özsoyoǧlu G, Al-Hamdani A, Altingövde I, Özel S, Ulusoy Ö and Özsoyoǧlu Z Sideway value algebra for object-relational databases Proceedings of the 28th international conference on Very Large Data Bases, (59-70)
- Buneman P, Khanna S, Tajima K and Tan W Archiving scientific data Proceedings of the 2002 ACM SIGMOD international conference on Management of data, (1-12)
- Bolchini C and Schreiber F (2002). Smart card embedded information systems, Data & Knowledge Engineering, 41:2-3, (159-182), Online publication date: 1-Jun-2002.
- Ramakrishnan R Data and knowledge in database systems Handbook of data mining and knowledge discovery, (73-78)
- Yu C (2002). High-dimensional indexing, 10.5555/1791550, Online publication date: 1-Jan-2002.
- Ailamaki A, DeWitt D, Hill M and Skounakis M Weaving Relations for Cache Performance Proceedings of the 27th International Conference on Very Large Data Bases, (169-180)
- Yu C, Ooi B, Tan K and Jagadish H Indexing the Distance Proceedings of the 27th International Conference on Very Large Data Bases, (421-430)
- Lin S, Özsu M, Oria V and Ng R An Extendible Hash for Multi-Precision Similarity Querying of Image Databases Proceedings of the 27th International Conference on Very Large Data Bases, (221-230)
- Buneman P, Davidson S, Fan W, Hara C and Tan W Keys for XML Proceedings of the 10th international conference on World Wide Web, (201-210)
- Fan W, Kuper G and Siméon J A unified constraint model for XML Proceedings of the 10th international conference on World Wide Web, (179-190)
- Doan A and Levy A Efficiently ordering query plans for data integration Proceedings of the 1999 International Conference on Intelligent Information Integration - Volume 23, (52-60)
Please enable JavaScript to view thecomments powered by Disqus.