chapter01a2 - Concepts of Database Management Fifth Edition...

Info icon This preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Concepts of Database  Concepts of Database  Management, Fifth Edition Management, Fifth Edition Chapter 1:  Chapter 1:  Introduction to Database  Introduction to Database  Management Management
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 Objectives Why study database management? Introduce Premiere Products, the company that is used as the basis for many of the examples throughout the text Introduce basic database terminology Describe database management systems Explain the advantages and disadvantages of database processing Introduce Henry Books, the company that is used in the case that runs throughout the text
Image of page 2
3 Why manage data? Changing view of data Higher costs of lost data Encouragement of “team problem- solving” Flexible reporting Integrating it into decision-making better
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4 Background Info DBMS software $25B/year industry Networked DBMS growing fastest DB research underpins communication systems Enterprise applications multimedia Internet scientific applications
Image of page 4
5 Data Management Tasks designing the file or database structure entering the data updating data by adding, changing, or deleting sorting the data searching through the data for a record or group of records obtaining screen or printed output Common tasks for flat files and databases are:
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6 Approaches to Data Management include: Custom Program Approach File Processing System Approach Database Management System Approach
Image of page 6
7 Contrasting Database and File System Designs
Image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
8 Problems associated with file processing systems Application/Program dependence Data is separate and isolated Data reduplication Multiple formats; hard to share data across applications.
Image of page 8
9 Database Management Systems Operating System Database Management System Application Programs Databases Data Dictionary Database Management
Image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
10 Disadvantages of DBMS Approach Cost Size Complexity Additional Hardware Requirements Higher Impact of Failure Recovery more difficult
Image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern