Types of Databases Database Systems 9th Edition 17 Databases can be classified

Types of databases database systems 9th edition 17

This preview shows page 17 - 29 out of 56 pages.

Types of Databases Database Systems, 9th Edition 17 Databases can be classified according to: Number of users Database location(s) Expected type and extent of use Single-user database supports only one user at a time Desktop database: single-user; runs on PC Multiuser database supports multiple users at the same time Workgroup and enterprise databases
Image of page 17

Subscribe to view the full document.

Types of Databases (cont’d.) Database Systems, 9th Edition 18 Centralized database : data located at a single site Distributed database : data distributed across several different sites Operational database : supports a company’s day-to-day operations Transactional or production database Data warehouse : stores data used for tactical or strategic decisions
Image of page 18
Types of Databases (cont'd.) Database Systems, 9th Edition 19 Unstructured data exist in their original state Structured data result from formatting Structure applied based on type of processing to be performed Semistructured data have been processed to some extent Extensible Markup Language (XML) represents data elements in textual format XML database supports semistructured XML data
Image of page 19

Subscribe to view the full document.

Database Systems, 9th Edition 20
Image of page 20
Why Database Design Is Important Database Systems, 9th Edition 21 Database design focuses on design of database structure used for end-user data Designer must identify database’s expected use Well-designed database: Facilitates data management Generates accurate and valuable information Poorly designed database: Causes difficult-to-trace errors
Image of page 21

Subscribe to view the full document.

Evolution of File System Data Processing Database Systems, 9th Edition 22 Reasons for studying file systems: Complexity of database design is easier to understand Understanding file system problems helps to avoid problems with DBMS systems Knowledge of file system is useful for converting file system to database system File systems typically composed of collection of file folders, each tagged and kept in cabinet Organized by expected use
Image of page 22
Evolution of File System Data Processing (cont'd.) Database Systems, 9th Edition 23 Contents of each file folder are logically related Manual systems Served as a data repository for small data collections Cumbersome for large collections Computerized file systems Data processing (DP) specialist converted computer file structure from manual system Wrote software that managed the data Designed the application programs
Image of page 23

Subscribe to view the full document.

Evolution of File System Data Processing (cont'd.) Database Systems, 9th Edition 24 Initially, computer file systems resembled manual systems As number of files increased, file systems evolved Each file used its own application program to store, retrieve, and modify data Each file was owned by individual or department that commissioned its creation
Image of page 24
Database Systems, 9th Edition 25
Image of page 25

Subscribe to view the full document.

Database Systems, 9th Edition 26
Image of page 26
Database Systems, 9th Edition 27
Image of page 27

Subscribe to view the full document.

Problems with File System Data Processing Database Systems, 9th Edition 28 File systems were an improvement over manual system File systems used for more than two decades Understanding the shortcomings of file systems aids in development of modern databases
Image of page 28
Image of page 29
  • Spring '16

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

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes