1 / 34

Chapter 1

Chapter 1. Introduction to Database Management. Welcome!. Database technology: crucial to the operation and management of modern organizations Major transformation in computing skills Significant time commitment Exciting journey ahead. Book Goals. First course in database management

joan-gross
Download Presentation

Chapter 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 1 Introduction to Database Management

  2. Welcome! • Database technology: crucial to the operation and management of modern organizations • Major transformation in computing skills • Significant time commitment • Exciting journey ahead

  3. Book Goals • First course in database management • Practical textbook • Fundamentals of relational databases • Query formulation • Data modeling, normalization, and physical design • Database application development • Database administration and database processing environments • Detailed material

  4. Outline • Database characteristics • DBMS features • Architectures • Organizational roles

  5. Initial Vocabulary • Data: raw facts about things and events • Information: transformed data that has value for decision making • Essential to organize data for retrieval and maintenance

  6. Database Characteristics • Persistent • Inter-related • Shared

  7. University Database

  8. Water Utility Database

  9. Database Management System (DBMS) • Collection of components that support data acquisition, dissemination, storage, maintenance, retrieval, and formatting • Enterprise DBMSs • Desktop DBMSs • Embedded DBMSs • Major part of information technology infrastructure

  10. Database Definition • Define database structure before using a database • Tables and relationships • SQL CREATE TABLE statement • Graphical tools

  11. University Database

  12. Table Definition Window

  13. Table Contents (Rows)

  14. University Database (ERD)

  15. Nonprocedural Access • Query: request for data to answer a question • Indicate what parts of database to retrieve not the procedural details • Improve productivity and improve accessibility • SQL SELECT statement and graphical tools

  16. Graphical Tool for Nonprocedural Access

  17. Application Development • Form: formatted document for data entry and display • Report: formatted document for display • Use nonprocedural access to specify data requirements of forms and reports

  18. Sample Data Entry Form

  19. Sample Report

  20. Procedural Language Interface • Combine procedural language with nonprocedural access • Why • Batch processing • Customization and automation • Performance improvement

  21. Transaction Processing • Transaction: unit of work that should be reliably processed • Control simultaneous users • Recover from failures

  22. Database Technology Evolution

  23. DBMS Marketplace • Enterprise DBMS • Oracle: dominates in Unix; strong in Windows • SQL Server: strong in Windows • DB2: strong in mainframe environment • Teradata: usage as a data warehouse platform • Significant open source DBMSs: MySQL, Progress, Firebird, PostgreSQL, open source Ingres • Desktop DBMS • Access: dominates • FoxPro, Paradox, Approach, FileMaker Pro

  24. Data Independence • Software maintenance is a large part (50%) of information system budgets • Reduce impact of changes by separating database description from applications • Change database definition with minimal effect on applications that use the database

  25. Three Schema Architecture

  26. Differences among Levels • External • FacultyAssignmentFormView: data required for the form in Slide 18 (Figure 1.9) • FacultyWorkLoadReportView: data required for the report in Slide 19 (Figure 1.10) • Conceptual: tables in Slide 14 • Internal • Files needed to store the tables • Extra files to improve performance

  27. Client-Server Architecture

  28. Parallel Database Architecture

  29. Distributed Database Architecture

  30. Cloud Computing

  31. Organizational Roles

  32. Database Specialists • Database administrator (DBA) • More technical • DBMS specific skills • Data administrator • Less technical • Planning role

  33. DBA Responsibilities

  34. Summary • Databases and database technology vital to modern organizations • Database technology supports daily operations and decision making • Nonprocedural access is a crucial feature • Many opportunities to work with databases

More Related