1 / 25

Introduction to Database Processing

Introduction to Database Processing. Art or Engineering. Database design and development involves both art and engineering Gathering and organizing user requirements is an art Transforming the resulting designs into physical applications involves engineering. Types of Data Stored.

filia
Download Presentation

Introduction to Database Processing

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. Introduction to Database Processing

  2. Art or Engineering • Database design and development involves both art and engineering • Gathering and organizing user requirements is an art • Transforming the resulting designs into physical applications involves engineering

  3. Types of Data Stored • Today, most newer databases are able to store a large variety of data, including… • Scalar data • Names, dates, phone numbers • Pictures • Audio • Video

  4. Database Example 1 Mary Richards Housepainting • Self Employed Entrepreneur • Single User Database • 3 Tables (Customers, Jobs, Source) • Data Needs: • Track how customers, jobs, and referrals relate • Record bid estimates • Track referral sources • Produce mailing labels

  5. Mary Richards’ Tables SOURCE CUSTOMER JOB

  6. Database Example 2 Treble Clef Music • Multi-User database on LAN • 3 Tables (Customers, Instruments, Rentals) • Data Needs: • Track instrument rentals • Handle multi-user issues

  7. Treble Clef Form 1

  8. Treble Clef Form 2

  9. Treble Clef Form 3

  10. Database Example 3 State Licensing & Vehicle Registration Bureau • 52 Centers, 37 Offices, Hundreds of Users • 40 Tables • Data Needs: • Track drivers licensing issues • traffic violations, accidents, arrests, limitations • Track auto registration issues • revenue, law enforcement • Integrate the needs of many departments

  11. Database Example 4 Calvert Island Reservations Centre • Chamber of Commerce • Promotional database provides access to data • Customer and reservation database processes • Data Needs: • Store multimedia data (photos, video clips, sound clips) • Must be Web / browser accessible • Uses Web technologies including HTTP, DHTML, and XML

  12. Comparison Among Database Examples

  13. Applications versus Database Management Systems (DBMS) • The Database Management System (DBMS) provides functionality above and beyond the storage of information. • Users want to see reports, forms, and query results – not simply data • As such, application development is crucial to the design and development of the DBMS

  14. In the Beginning, There Were File-Processing Systems • The first business information systems stored information by grouping similar data into separate files.

  15. A File-Processing System

  16. Problems with File-Processing Systems • Data separated and isolated • Data often duplicated • Application program dependent • Incompatible data files • Difficult to understand

  17. Duplication of Data • When storing the same data in multiple locations, the likelihood of inconsistency is very high. • What is my real name? • Table 1: my name is Dan • Table 2: my name is Danielle • Table 3: my name is Daniel • Table 4: my name is Don

  18. The Data in a DBMS • Data is integrated • Data duplication is reduced • Data is program independent • Data is easy to understand

  19. A DMBS

  20. Database is Self-Describing • A database contains a data dictionary • A data dictionary is data about the data (metadata) • It describes the structure and format of the information contained within the database

  21. The Hierarchy of Data File-Processing DBMS

  22. DBMS –the Past • 1970, E.F. Codd • Normalization Process • Compute Intensive

  23. DBMS –the Present • Ashton - Tate: dBase II, now Borland • Oracle, Focus, Ingress ported down • Paradox, Revelation, MDBS, Helix, Foxpro, Access built specifically for microcomputers

  24. DBMS –the Future Trends • Client-Server Applications • Integration of Internet Technology • Distributed Processing • Object-Oriented DBMS

  25. Database Processing Eighth Edition Chapter 1 David M. Kroenke Introduction to Database Processing

More Related