Database Systems: A Practical Approach to Design, Implementation and Management

摘要: 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 for relational Database Management Systems is presented simple, step-by-step instructions conjunction with realistic worked example using three explicit phasesconceptual, logical, physical design. Background: Introduction to Databases; Environment; Architectures Web. Relational Model Languages: model; Algebra Calculus; SQL: Data Manipulation; Definition; Query-By-Example (QBE). Analysis Design: System Lifecycle; DreamHome Case Study; EntityRelationship Modeling; Enhanced Normalization; Advanced Normalization. Methodology: MethodologyConceptual Design; MethodologyLogical Design Model; MethodologyPhysical MethodologyMonitoring Tuning Operational System. Selected Issues: Security Administration; Professional, Legal, Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs Replication: DBMSsConcepts DBMSsAdvanced Concepts; Replication Mobile Databases. Object DBMSs: Object-Oriented DBMSsStandards Languages; Object-Relational DBMSs. Web Technology DBMSs; Semistructured XML. Business Intelligence Technologies: Warehousing OLAP; Mining. Appendices: Users' Requirements Specification Other Studies; Alternative Modeling Notations; Summary of Methodology PyrrhoA Liteweight RDBMS. File Organization Storage Structures; When Is DBMS Relational?; Commercial Access Oracle; Programmatic SQL; Estimating Disk Space Requirements; Object-Orientation; Example Scripts. book ideal readers interested management or