Logical database design principles. (2005)

• Record Type: Book
• Further Information: Note: John Garmany, Jeff Walker, Terry Clark.
• Other Names: Garmany, John; Walker, Jeff; Clark, Terry
• Contents: INTRODUCTION TO LOGICAL DATABASE DESIGN; Understanding a Database; Database Architectures; Relational Databases; Creating the Database; System Development Life Cycle (SDLC); Systems Planning: Assessment and Feasibility; System Analysis: Requirements; System Analysis: Requirements Checklist; Models Tracking and Schedules; Design Modeling; Functional Decomposition Diagram; Data Flow Diagrams; Data Dictionary; Logical Structures and Decision Trees; System Design: Logical; ; SYSTEM DESIGN AND IMPLEMENTATION; The ER Approach; Entities and Entity Types; Attribute Domains; Attributes; Set-Valued Attributes; Weak Entities; Constraints; Lookup Tables and Consistency; Modeling Approaches; Relationships; Cardinality; Schemas; Implementation: Converting the ERD; Specifications and Documentation; ; CONVERTING THE LOGICAL DATA MODEL; Database Architecture; SQL; DDL Commands; Data Retrieval; DML Statements and Implicit Cursors; SELECT Statements; Cartesian Product; DML: INSERT Commands; DML: UPDATE Command; DML: DELETE Statements; Transaction Commands; DCL Commands; ; FORMAL DATA NORMALIZATION; Definitions of Normal Forms; Introduction to Relational Algebra; Comparison Operations and Logical Operators; Summary; ; DATA DENORMALIZATION; Historical Perspective on Disk Costs; The Importance of Database Performance to the Logical Model; Introducing Data Redundancy: Size versus Volatility; The Theory of Dr. Ralph Kimball; Pre-Joining Entities Together; Pre-Aggregating Summary Information; Non-First Normal Form Entities; Horizontal and Vertical Partitioning for Performance; Summary; ; OBJECT-ORIENTED DESIGN; Object-Oriented Terminology; Object-Oriented Design; Creating the Object Model; Methods and Database Objects; Summary; ; OBJECT-RELATIONAL DESIGN; Advantages of Object-Relational Databases; Object Types; Object Views; Using Logical Pointers; Comparison of Object-Oriented and Object-Relational Databases; Creating the Object-Relational Design; Summary; ; DESIGNING REPLICATED DATABASES; Manual Replication Techniques; Standby Database; Replication Using Triggers; Replication Using Views; One-Way Replication; Writeable Replication; Updateable Replication; What Are Conflicts?; Which Form of Replication is Right for You?; Planning Your Replication Schema; Summary; ; DESIGN OF THE OLTP DATABASE; Designing for Online Transaction Processing; Normalization; Data Storage; SQL Reuse; Database Locking and Waiting; Deadlocks; Rollbacks; Indexing; Summary; ; DESIGN OF DATA WAREHOUSES AND DECISION; SUPPORT SYSTEM DATABASES; What Is a Data Warehouse?; Gathering Data; Staging and Processing Data; Loading and Unloading Data; Data Marts; Designing the Data Warehouse; Summary
• Publisher Details: Boca Raton, Fla : Auerbach Publications
• Publication Date: 2005
• Extent: 1 online resource (xvii, 180 pages), illustrations
• Subjects: 005.74; Database design; COMPUTERS -- Desktop Applications -- Databases; COMPUTERS -- Database Management -- General; COMPUTERS -- System Administration -- Storage & Retrieval; Database design; Electronic books
• Languages: English
• ISBNs: 0203505166; 9780203505168; 9780849318535
• Related ISBNs: 084931853X; 084931853X
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.