1 / 17

Mastering Database Management Systems: A Comprehensive Guide

Explore the world of databases with this comprehensive guide. Learn about data organization, record storage, query languages, and more. Understand how to manage files, establish relationships, and optimize performance.

rlevine
Download Presentation

Mastering Database Management Systems: A Comprehensive Guide

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 13.3: Databases Invitation to Computer Science, Java Version, Second Edition

  2. Databases • An electronic database • Stores data items • Data items can be extracted • Data items can be sorted • Data items can be manipulated to reveal new information Invitation to Computer Science, Java Version, Second Edition

  3. Data Organization • Byte • A group of eight bits • Can store the binary representation of a single character or of a small integer number • A single unit of addressable memory • Field • A group of bytes used to represent a string of characters Invitation to Computer Science, Java Version, Second Edition

  4. Data Organization (continued) • Record • A collection of related fields • Data file • Related records are kept in a data file • Database • Related files make up a database Invitation to Computer Science, Java Version, Second Edition

  5. Figure 13.3 Data Organization Hierarchy Invitation to Computer Science, Java Version, Second Edition

  6. Figure 13.4 Records and Fields in a Single File Invitation to Computer Science, Java Version, Second Edition

  7. Figure 13.5 One Record in the Rugs-For-You Employees File Invitation to Computer Science, Java Version, Second Edition

  8. Database Management Systems • Database management system (DBMS) • Manages the files in a database • Relational database model • Conceptual model of a file as a two-dimensional table Invitation to Computer Science, Java Version, Second Edition

  9. Database Management Systems (continued) • In a relational database • A table represents information about an entity • A row contains data about one instance of an entity • A row is called a tuple • Each category of information is called an attribute Invitation to Computer Science, Java Version, Second Edition

  10. Figure 13.6 Employees Table for Rugs-For-You Invitation to Computer Science, Java Version, Second Edition

  11. Figure 13.7 InsurancePolicies Table for Rugs-For-You Invitation to Computer Science, Java Version, Second Edition

  12. Database Management Systems (continued) • Specialized query languages • Enable the user or another application program to query the database • Example: SQL (Structured Query Language) • Relationships among different entities in a database • Established through the correspondence between primary keys and foreign keys Invitation to Computer Science, Java Version, Second Edition

  13. SELECT ID, LASTNAME, FIRSTNAME, PAYRATEFROM EMPLOYEESWHERE LASTNAME = ‘KAY’ ; Invitation to Computer Science, Java Version, Second Edition

  14. Figure 13.8 Three Entities in the Rugs-For-You Database Invitation to Computer Science, Java Version, Second Edition

  15. Other Considerations • Performance issues • Large files are maintained on disk • Organizing record storage on disk can minimize time to access a particular record • Creating additional records to be stored with the file can significantly reduce access time Invitation to Computer Science, Java Version, Second Edition

  16. Other Considerations (continued) • Distributed databases • Allow physical data to reside at separate and independent locations that are networked • Massive, integrated government databases raise legal, political, social, and ethical issues Invitation to Computer Science, Java Version, Second Edition

  17. Summary • Database: allows data items to be stored, extracted, sorted, and manipulated • Relational database model: conceptual model of a file as a two-dimensional table Invitation to Computer Science, Java Version, Second Edition

More Related