Sumário Itens Encontrados: 505Chapter 1: Introduction to Database Systems1.1 Defi nitions and Rationale1.2 Objectives of a Database System1.2.1 Primary and Secondary Objectives1.2.2 Clarifi cation on Data Independence1.3 Advantages of a Database System1.4 Approaches to Database Design1.4.1 Conventional Files1.4.2 Database Approach1.5 Desirable Features of a DBS1.6 Database Development Life Cycle1.8 Review Questions1.9 References and/or Recommended Readings Chapter 2: The Database System Environment2.1 Levels of Architecture.2.1.1 External Level2.1.2 Conceptual Level2.1.3 Internal Level2.2 Inter-Level Mappings.2.3 Database Personnel2.3.1 Database Administrator and Data Architect2.3.2 Tools Expert2.3.3 Application Programmer2.3.4 User Liaison Specialist2.3.5 Network and Infrastructure Specialist2.4 The Database Management System2.5 Components of DBMS Suite2.5.1 The DBMS Engine2.5.2 Data Defi nition Subsystem2.5.3 The User Interface Subsystem2.5.4 Application Development Subsystem2.5.5 Data Administration Subsystem2.5.6 Data Dictionary Subsystem2.5.7 Data Communications Manager2.5.8 Utilities Subsystem2.6 Front-End and Back-End Perspectives2.7 Database System Architecture2.8 Database Management System Classifi cations2.8.1 Classifi cation Based on Data Models2.8.2 Classifi cation Based on Number of Users2.8.3 Classifi cation Based on Site Confi guration2.8.4 Classifi cation Based on Database Purpose 2.10 Review Questions2.11 References and/or Recommended ReadingsPart B: The Relational Database ModelChapter 3: The Relational Model3.1 Basic Concepts3.2 Domains3.3 Relations3.3.1 Properties of a Relation3.3.2 Kinds of Relations3.4 Relational Database System3.5 Identifying Relationships3.6 Representing Relationships3.6.1 The Entity-Relationship Model3.6.2 The Object-Relationship Model3.6.4 Multiplicity of Relationships3.7 Implementing Relationships3.8 Innovation: Relation-Attributes List and Relationship List3.9 Database Naming Convention3.11 Review Questions3.12 References and/or Recommended ReadingsChapter 4: Integrity Rules and Normalization4.1 Fundamental Integrity Rules4.2 Foreign Key Concept4.3 Rationale for Normalization 4.4 Functional Dependence and Non-Loss Decomposition4.4.1 Functional Dependence4.4.2 Non-Loss Decomposition4.5 First Normal Form4.5.1 Problems with Relations in 1NF Only4.6 Second Normal Form4.6.1 Problems with Relations in 2NF Only4.7 Third Normal Form4.7.1 Problems with Relations in 3NF Only4.8 Boyce-Codd Normal Form4.9 Fourth Normal Form4.9.1 Multi-Valued Dependency4.9.2 Faginâs Theorem4.9.3 The Zoo Revisited4.10 Fifth Normal Form4.10.1 Defi nition of Join Dependency4.10.2 Fagin´s Theorem4.11 An Example4.12 Other Normal Forms4.12.1 The Domain-Key Normal Form4.12.2 The Sixth Normal Form4.14 Review Questions4.15 References and/or Recommended ReadingsChapter 5: Database Modeling and Design5.1 The Database Model and Database Design5.1.1 The Database Model5.1.2 Database Design.5.2 The E-R Model Revisited5.3 Database Design via the E-R Model 5.4 The Extended Relational Model5.4.1 Entity Classifi cations5.4.2 Surrogates5.4.3 E-Relations and P-Relations5.4.4 Integrity Rules5.5 Database Design via the XR Model5.5.1 Determining the Kernel Entities5.5.2 Determining the Characteristic Entities5.5.3 Determining the Designative Entities5.5.4 Determining the Associations5.5.5 Determining Entity Subtypes and Super-types5.5.6 Determining Component Entities5.5.7 Determining Additional Properties5.5.8 Additional Applications of the XR Model5.6 The UML Model5.7 Database Design via the UML Model5.8 Innovation: The Object/Entity Specifi cation Grid5.9 Database Design via Normalization Theory5.9.1 Example: Mountaineering Problem5.9.2 Determining Candidate Keys and then Normalizing5.10 Database Model and Design Tools5.12 Review Questions5.13 References and/or Recommended ReadingsChapter 6: Database User Interface Design6.1 Overview6.2 Deciding on the User Interface6.3 Steps in the User Interface Design6.3.1 Menu or Graphical User Interface6.3.2 Command-Based User Interface 6.4 User Interface Development and Implementation6.6 Review Questions6.7 References and/or Recommend ReadingsChapter 7: Relational Algebra7.1 Overview7.2 Basic Operations of Relational Algebra7.2.1 Primary and Secondary Operations7.2.2 Codd´s Original Classifi cation of Operations.7.2.3 Nested Operations7.3 Syntax of Relational Algebra7.3.1 Select Statement7.3.2 Projection Statement7.3.3 Natural Join Statement7.3.4 Cartesian Product7.3.5 Theta-Join7.3.6 Inner and Outer Joins7.3.7 Union,Intersection,and Difference Statements7.3.8 Division Statement7.4 Aliases,Renaming,and the Relational Assignment7.4.1 The Alias Operation7.4.2 The Assignment Operation7.4.3 The Rename Operation7.5 Other Operators7.7 Review Questions7.8 References and/or Recommended Readings Chapter 8: Relational Calculus8.1 Overview8.2 Calculus Notations and Illustrations8.3 Quantifi ers,Free and Bound Variables8.3.1 Well-Formed Formula8.3.2 Free and Bound Variables8.4 Substitution Rule and Standardization Rules8.5 Introductory Query Optimization8.6 Domain-Oriented Relational Calculus8.8 Review Questions8.9 References and/or Recommended ReadingsChapter 9: Refl ective Look at the Relational Database Model9.1 The Relational Model Summarized9.2 Ramifi cations of the Relational Model9.2.1 Coddâs Early Benchmark9.2.2 Revised Defi nition of a Relational System9.2.3 Far-Reaching Consequences9.4 Review Questions9.5 ReferencesPart C: The Structured Query LanguageChapter 10: Overview of SQL10.1 Important Facts10.1.1 Commonly Used DDL Statements10.1.2 Commonly Used DML and DCL Statements10.1.3 Syntax Convention 10.2 Advantages of SQL10.4 Review Questions10.5 Recommended ReadingsChapter 11: SQL Data Defi nition Statements11.1 Overview of Oracleâs SQL Environment11.2 Basic Concepts in a Typical Oracle Database Environment11.3 Database Creation11.4 Database Management11.5 Tablespace Creation11.6 Tablespace Management11.7 Table Creation11.8 Dropping or Modifying a Table11.9 Working with Indexes11.10 Working with Sequences11.10.1 Creating and Using Sequences11.10.2 Altering and Dropping Sequences11.11 Working with Synonyms11.13 Review Questions11.14 References and/or Recommended ReadingsChapter 12: SQL Data Manipulation Statements12.1 Insertion of Data12.2 Update Operations12.3 Deletion of Data12.4 Commit and Rollback Operations12.5 Basic Syntax for Queries12.6 Simple Queries 12.7 Queries Involving Multiple Tables12.7.1 The Traditional Method12.7.2 The ANSI Method12.8 Queries Involving the Use of Functions12.8.1 Row Functions12.8.2 Date Functions12.8.3 Data Conversion Functions12.8.4 Programmer-Defi ned Functions12.8.5 Aggregation Functions12.8.6 Analytic Functions12.9 Queries Using the LIKE and BETWEEN Operators12.10 Nested Queries12.10.1 Nested Queries Involving Use of the IN Operator12.10.2 Nested Queries Involving use of ANY or ALL Operator12.10.3 Nested Queries Using the Existential Quantifi er12.11 Queries Involving Set Operations12.12 Queries with Runtime Variables12.13 Queries Involving SQL*Plus Format Commands12.14 Embedded SQL12.15 Dynamic Queries12.17 Review Questions12.18 References and/or Recommended ReadingsChapter 13: Logical Views and System Security13.1 Traditional Logical Views13.1.1 View Creation13.1.2 View Modifi cation and Removal13.1.3 Usefulness and Manipulation of Logical Views 13.2 System Security13.2.1 Access to the System13.2.2 Access to the System Resources13.2.3 Access to the System Data13.3 Materialized Views13.3.1 Creating a Materialized View13.3.2 Altering or Dropping a Materialized View13.5 Review Questions13.6 References and/or Recommended ReadingsChapter 14: The System Catalog14.1 Introduction14.2 Three Important Catalog Tables14.2.1 The User_Tables View14.2.2 The User_Tab_Columns View14.2.3 The User_Indexes View14.3 Other Important Catalog Tables14.4 Querying the System Catalog14.5 Updating the System Catalog14.7 Review Questions14.8 References and/or Recommended ReadingsChapter 15: Some Limitations of SQL15.1 Programming Limitations15.2 Limitations on Views15.2.1 Restriction on Use of the Order-By Clause for Earlier Versions of SQL15.2.2 Restriction on Data Manipulation for Views involving UNION,INTERSECT,or JOIN15.2.3 Restriction on the Use of Aggregation Functions for Earlier Versions of SQL15.3 Stringent Enforcement of Referential Integrity15.4 Limitations on Calculated Columns15.5 If-Then Limitation15.7 Review Questions15.8 Recommended ReadingsPart D: Advanced TopicsChapter 16: Database Administration16.1 Database Installation,Creation,and Confi guration16.2 Database Security16.3 Database Management16.4 Database Backup and Recovery16.4.1 Oracle Backups: Basic Concept16.4.2 Oracle Recovery: Basic Concept16.4.3 Types of Failures16.4.4 Database Backups16.4.5 Basic Recovery Steps16.4.6 Oracleâs Backup and Recovery Solutions16.5 Database Tuning16.5.1 Tuning Goals16.5.2 Tuning Methodology16.6 Database Removal16.8 Review Questions16.9 References and/or Recommended ReadingsChapter 17: Distributed Database Systems17.1 Preliminaries17.2 Advantages of Distributed Database Systems17.3 12 Rules for Distributed Database Systems 17.4 Challenges to Distributed Database Systems17.4.1 Query Optimization17.4.2 Catalog Management17.4.3 Update Propagation17.4.4 Concurrency17.4.5 Transaction Management17.5 Database Gateways17.6 The Future of Distributed Database Systems17.6.1 Object Technology17.6.2 Electronic Communication Systems17.6.3 Cloud Technology17.6.4 Big Data17.8 Review Questions17.9 References and/or Recommended ReadingsChapter 18: Object Databases18.1 Overview18.2 Overview of Object-Oriented Database Management Systems18.3 Challenges for Object-Oriented Database Management Systems18.4 Hybrid Approach18.6 Review Questions18.7 References and/or Recommended ReadingsChapter 19: Data Warehousing19.1 Overview19.1.1 Defi nitions19.1.2 Acquiring a Data Warehouse 19.2 Rationale for Data Warehousing19.3 Characteristics of a Data Warehouse19.3.1 Defi nitive Features19.3.2 Nature of Data Stored19.3.3 Processing Requirements19.3.4 12 Rules for Data Warehousing19.4 Data Warehouse Architecture19.4.1 Basic Data Warehouse Architecture19.4.2 Data Warehouse Architecture with a Staging Area19.4.3 Data Warehouse Architecture with a Staging Area and Data Marts19.5 Extraction,Transformation,and Loading19.5.1 What Happens During the ETL Process19.5.2 ETL Tools19.5.3 Daily Operations and Expansion of the Data Warehouse19.7 Review Questions19.8 References and/or Recommended ReadingsChapter 20: Web-Accessible Databases20.1 Introduction20.2 Web-Accessible Database Architecture20.3 Supporting Technologies20.4 Implementation with Selected DBMS Suites20.4.1 Implementation via Oracle20.4.2 Implementation via DB220.4.3 Implementation via MySQL20.5 Generic Implementation via Front-End and Back-End Tools20.6 Challenges and Opportunities20.6.1 Cloud Computing and Big Data20.6.2 Cybersecurity 20.8 Review Questions20.9 References and/or Recommended ReadingsChapter 21: Using Database Systems to Anchor ManagementSupport Systems21.1 Overview of Management Support Systems21.2 Building System Security Through Database Design21.3 Case Study: Dynamic Menu Interface Designer21.3.1 Database Requirements of the DMID21.3.2 Overview of the DMIDâs User Interface Requirements21.3.3 Management of System Constraints via the DMID21.3.4 Access to System Resources21.3.5 Usefulness and Applicability of the DMID21.4 Selected MSS Project Ideas21.4.1 Electoral Management System21.4.2 Health Information Management System21.4.3 Strategic Education Management System21.4.4 Flight Information Management System21.4.5 Financial Information Management System21.4.6 Disease Recognition System21.4.7 Cognitive Leadership Analysis System21.4.8 Financial Status Assessment System21.4.9 College/University Administrative Information System21.6 Review Questions21.7 References and/or Recommended Readings Part E: Overview of Selected DBMS SuitesChapter 22: Overview of Oracle22.1 Introduction22.2 Main Components of the Oracle Suite22.2.1 Oracle Server22.2.2 Oracle PL/SQL and SQL*Plus22.2.3 Oracle Developer Suite22.2.4 Oracle Enterprise Manager Database Control and SQL Developer22.2.5 Oracle Enterprise Manager Grid Control22.2.6 Oracle Database Confi guration Assistant22.2.7 Oracle Warehouse Builder22.3 Shortcomings of Oracle22.5 Review Questions22.6 References and/or Recommended ReadingsChapter 23: Overview of DB223.1 Introduction23.2 Main Components of the DB2 Suite23.2.1 DB2 Universal Database Core23.2.2 Command Line Processor Plus (CLPPlus)23.2.3 IBM InfoSphere Information Server23.2.4 IBM Data Studio23.2.5 IBM InfoSphere Warehouse23.3 Shortcomings of DB223.5 Review Questions23.6 References and/or Recommended Readings Chapter 24: Overview of MySQL24.1 Introduction to MySQL24.2 Main Features of MySQL24.3 Main Components of MySQL24.4 Alternate Storage Engines24.5 Shortcomings of MySQL24.5.1 Limitations on Logical Views24.5.2 Limitations on Subqueries24.5.3 Limitation on Server-Side Cursors24.5.4 Other Limitations24.7 Review Questions24.8 References and/or Recommended ReadingsChapter 25: Overview of Microsoft SQL Server25.1 Introduction25.1.1 Brief History25.1.2 Operating Environment25.1.3 Microsoft SQL Server Editions25.2 Main Features of Microsoft SQL Server25.3 Main Components of Microsoft SQL Server Suite25.3.1 Server Components25.3.2 Management Tools25.3.3 Development Tools25.3.4 Client Connectivity25.3.5 Code Samples25.4 Shortcomings of Microsoft SQL Server25.6 Review Questions25.7 References and/or Recommended ReadingsPart F: Appendices.Appendix A1: Review of TreesA1.1 Introduction to TreesA1.2 Binary TreesA1.2.1 Overview of Binary TreesA1.2.2 Representation of Binary TreesA1.2.3 Application of Binary TreesA1.2.4 Operations on Binary TreesA1.2.5 Implementation of Binary TreesA1.2.6 Binary Tree TraversalsA1.2.7 Using Binary Trees to Evaluate ExpressionsA1.3 Threaded Binary TreesA1.4 Binary Search TreesA1.5 Height-Balanced TreesA1.6 HeapsA1.6.1 Building the HeapA1.6.2 Processing the Heap (Heap-Sort)A1.7 M-Way Search Trees and B-TreesA1.7.1 Defi nition of B-TreeA1.7.2 Implementation of the B-treeA1.9 References and/or Recommended ReadingsAppendix A2: Review of HashingA2.1 IntroductionA2.2 Hash FunctionsA2.2.1 Absolute AddressingA2.2.2 Direct Table LookupA2.2.3 Division-RemainderA2.2.4 Mid-SquareA2.2.5 FoldingA2.2.6 TruncationA2.2.7 Treating Alphanumeric Key ValuesA2.3 Collision ResolutionA2.3.1 Linear ProbingA2.3.2 Synonym ChainingA2.3.3 RehashingA2.4 Hashing in JavaA2.6 References and/or Recommended ReadingsAppendix A3: Review of Information-Gathering TechniquesA3.1 Rationale for Information GatheringA3.2 InterviewingA3.2.1 Steps in Planning the InterviewA3.2.2 Basic Guidelines for InterviewsA3.3 Questionnaires and SurveysA3.3.1 Guidelines for QuestionnairesA3.3.2 Using Scales in QuestionnairesA3.3.3 Administering the QuestionnaireA3.4 SamplingA3.4.1 Probability Sampling TechniquesA3.4.2 Non-Probability Sampling TechniquesA3.4.3 Sample CalculationsA3.5 Observation and Document ReviewA3.6 PrototypingA3.7 BrainstormingA3.8 Object Identifi cationA3.8.1 The Descriptive Narrative ApproachA3.8.2 The Rule-of-Thumb ApproachA3.10 References and/or Recommended ReadingsAppendix A4: BNF Syntax for Selected SQL StatementsA4.1 Database ManagementA4.1.1 Syntax for Create-Database StatementA4.1.2 Syntax for Alter-Database StatementA4.2 Tablespace ManagementA4.2.1 Syntax for Create-Tablespace StatementA4.2.2 Syntax for Alter-Tablespace StatementA4.3 Tables ManagementA4.3.1 Syntax for Create-Table StatementA4.3.2 Syntax for Alter-Table StatementA4.4 Index ManagementA4.4.1 Syntax for Create-Index StatementA4.4.2 Syntax for Alter-Index StatementA4.5 Data Insertion,Update,and DeletionA4.5.1 Abridged Syntax for the Insert StatementA4.5.2 Abridged Syntax for the Update StatementA4.5.3 Syntax for Delete Statement and Truncate StatementA4.6 Transaction ManagementA4.7 Building QueriesA4.7.1 Abridged Syntax for the Select StatementA4.7.2 Modifi ed From-Clause for ANSI JoinA4.7.3 Some Commonly Used Row FunctionsA4.7.4 Some Commonly Used Date Manipulation FunctionsA4.7.5 Some Commonly Used Data Conversion FunctionsA4.7.6 Some Valid Date and Numeric FormatsA4.7.7 Commonly Used Aggregation FunctionsA4.7.8 Syntax for Using Analytic FunctionsA4.7.9 Syntax for Nested QueriesA4.8 Managing Logical ViewsA4.8.1 Creating the Logical ViewA4.8.2 Altering or Dropping the Logical ViewA4.9 Managing System SecurityA4.9.1 Syntax for Create-Profi le StatementA4.9.2 Syntax for Altering or Dropping a Profi leA4.9.3 Syntax for Creating User Account(s)A4.9.4 Syntax for Altering or Dropping User Account(s)A4.9.5 Syntax for Creating,Altering,or Dropping Role(s)A4.9.6 Syntax for Granting or Revoking Privilege(s)Appendix A5: Sample Exercises and Examination Questions