Principles of Database Manageme 1st edition by Wilfried Lemahieu, Seppe vanden Broucke, Bart Baesens – Ebook PDF Instant Download/Delivery: 1316952983, 9781316952986
Full download Principles of Database Manageme 1st edition after payment
Product details:
ISBN 10: 1316952983
ISBN 13: 9781316952986
Author: Wilfried Lemahieu, Seppe vanden Broucke, Bart Baesens
This comprehensive textbook teaches the fundamentals of database design, modeling, systems, data storage, and the evolving world of data warehousing, governance and more. Written by experienced educators and experts in big data, analytics, data quality, and data integration, it provides an up-to-date approach to database management. This full-color, illustrated text has a balanced theory-practice focus, covering essential topics, from established database technologies to recent trends, like Big Data, NoSQL, and more. Fundamental concepts are supported by real-world examples, query and code walkthroughs, and figures, making it perfect for introductory courses for advanced undergraduates and graduate students in information systems or computer science. These examples are further supported by an online playground with multiple learning environments, including MySQL, MongoDB, Neo4j Cypher, and tree structure visualization. This combined learning approach connects key concepts throughout the text to the important, practical tools to get started in database management.
Principles of Database Manageme 1st Table of contents:
Part I: Databases and Database Design
1. Fundamental Concepts of Database Management
1.1 Applications of Database Technology
1.2 Key Definitions
1.3 File versus Database Approach to Data Management
1.3.1 The File-Based Approach
1.3.2 The Database Approach
1.4 Elements of a Database System
1.4.1 Database Model versus Instances
1.4.2 Data Model
1.4.3 The Three-Layer Architecture
1.4.4 Catalog
1.4.5 Database Users
1.4.6 Database Languages
1.5 Advantages of Database Systems and Database Management
1.5.1 Data Independence
1.5.2 Database Modeling
1.5.3 Managing Structured, Semi-Structured, and Unstructured Data
1.5.4 Managing Data Redundancy
1.5.5 Specifying Integrity Rules
1.5.6 Concurrency Control
1.5.7 Backup and Recovery Facilities
1.5.8 Data Security
1.5.9 Performance Utilities
Summary
Problems and Exercises
2. Architecture and Categorization of DBMSs
2.1 Architecture of a DBMS
2.1.1 Connection and Security Manager
2.1.2 DDL Compiler
2.1.3 Query Processor
2.1.3.1 DML Compiler
2.1.3.2 Query Parser and Query Rewriter
2.1.3.3 Query Optimizer
2.1.3.4 Query Executor
2.1.4 Storage Manager
2.1.4.1 Transaction Manager
2.1.4.2 Buffer Manager
2.1.4.3 Lock Manager
2.1.4.4 Recovery Manager
2.1.5 DBMS Utilities
2.1.6 DBMS Interfaces
2.2 Categorization of DBMSs
2.2.1 Based on Data Model
2.2.1.1 Hierarchical DBMSs
2.2.1.2 Network DBMSs
2.2.1.3 Relational DBMSs
2.2.1.4 Object-Oriented DBMSs
2.2.1.5 Object-Relational/Extended Relational DBMSs
2.2.1.6 XML DBMSs
2.2.1.7 NoSQL DBMSs
2.2.2 Based on Degree of Simultaneous Access
2.2.3 Based on Architecture
2.2.4 Based on Usage
Summary
Problems and Exercises
3. Conceptual Data Modeling Using the (E)ER Model and UML Class Diagram
3.1 Phases of Database Design
3.2 The Entity Relationship (ER) Model
3.2.1 Entity Types
3.2.2 Attribute Types
3.2.3.1 Domains
3.2.3.2 Key Attribute Types
3.2.3.3 Simple vs Composite Attributes
3.2.3.4 Single-Valued vs Multi-Valued Attributes
3.2.3.5 Derived Attributes
3.2.4 Relationship Types
3.2.4.1 Degree and Roles
3.2.4.2 Cardinalities
3.2.4.3 Relationship Attributes
3.2.5 Weak Entity Types
3.2.6 Ternary Relationship Types
3.2.7 ER Model Examples
3.2.8 ER Model Limitations
3.3 The Enhanced ER (EER) Model
3.3.1 Specialization/Generalization
3.3.2 Categorization
3.3.3 Aggregation
3.3.4 EER Model Examples
3.3.5 Designing an EER Model
3.4 UML Class Diagram
3.4.1 Object Orientation Recap
3.4.2 Classes
3.4.3 Variables
3.4.4 Access Modifiers
3.4.5 Associations
3.4.5.1 Association Class
3.4.5.2 Unidirectional vs Bidirectional Association
3.4.5.3 Qualified Association
3.4.6 Specialization/Generalization
3.4.7 Aggregation
3.4.8 UML Example
3.4.9 Advanced UML Concepts
3.4.9.1 Changeability Property
3.4.9.2 Object Constraint Language (OCL)
3.4.9.3 Dependency Relationship
3.4.10 UML vs EER
Summary
Problems and Exercises
4. Organizational Aspects of Data Management
4.1 Data Management
4.1.1 Catalogs and Metadata
4.1.2 Metadata Modeling
4.1.3 Data Quality
4.1.3.1 Data Quality Dimensions
– Accuracy
– Completeness
– Consistency
– Accessibility
4.1.3.2 Data Quality Issues
4.1.4 Data Governance
4.2 Data Management Roles
4.2.1 Information Architect
4.2.2 Database Designer
4.2.3 Data Owner
4.2.4 Data Steward
4.2.5 Database Administrator
4.2.6 Data Scientist
Summary
Problems and Exercises
People also search for Principles of Database Manageme 1st :
principles-of-database-management-wilfried-lemahieu
principles of database management – wilfried lemahieu pdf
principles of database management lemahieu pdf
principles of database management
principles of database management solutions
Tags: Wilfried Lemahieu, Seppe vanden Broucke, Bart Baesens, Database Manageme