- Authors:
- Thomas M. Connolly,
- Carolyn E. Begg
This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phasesconceptual, logical, and physical database design. Background: Introduction to Databases; Database Environment; Database Architectures and the Web. The Relational Model and Languages: The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE). Database Analysis and Design: Database System Lifecycle; Database Analysis and the DreamHome Case Study; EntityRelationship Modeling; Enhanced EntityRelationship Modeling; Normalization; Advanced Normalization. Methodology: MethodologyConceptual Database Design; MethodologyLogical Database Design for Relational Model; MethodologyPhysical Database Design for Relational Databases; MethodologyMonitoring and Tuning the Operational System. Selected Database Issues: Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs and Replication: Distributed DBMSsConcepts and Design; Distributed DBMSsAdvanced Concepts; Replication and Mobile Databases. Object DBMSs: Object-Oriented DBMSsConcepts and Design; Object-Oriented DBMSsStandards and Languages; Object-Relational DBMSs. Web and DBMSs: Web Technology and DBMSs; Semistructured Data and XML. Business Intelligence Technologies: Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Appendices: Users' Requirements Specification for DreamHome Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to PyrrhoA Liteweight RDBMS. Web Appendices: File Organization and Storage Structures; When Is a DBMS Relational?; Commercial DBMSs: Access and Oracle; Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts. This book is ideal for readers interested in database management or database design.
Cited By
- Kadyanan I, Dwidasmara I, Mahendra I, Mogi I and Sudarma I The Design of Typical Balinese Food Recommendation System Using Hybrid Method of Collaborative Filtering and Slope One Algorithm on Mobile Device Platform Proceedings of the 2019 5th International Conference on Computing and Artificial Intelligence, (111-116)
- Kingdon A, Nayembil M, Richardson A and Smith A (2016). A geodata warehouse, Computers & Geosciences, 96:C, (87-97), Online publication date: 1-Nov-2016.
- Kudo T, Ishino M, Saotome K and Kataoka N (2016). A Proposal of Transaction Processing Method for MongoDB, Procedia Computer Science, 96:C, (801-810), Online publication date: 1-Oct-2016.
- Appelgren Lara G, Delgado M and Marín N Fuzzy Multidimensional Modelling for Flexible Querying of Learning Object Repositories Proceedings of the 10th International Conference on Flexible Query Answering Systems - Volume 8132, (112-123)
- Aydonat U and Abdelrahman T Hardware Support for Relaxed Concurrency Control in Transactional Memory Proceedings of the 2010 43rd Annual IEEE/ACM International Symposium on Microarchitecture, (15-26)
Index Terms
- Database Systems: A Practical Approach to Design, Implementation and Management