456-Study-Guide-1

456-Study-Guide-1 - Database Systems, Chapter 1 Explain the...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Systems, Chapter 1 Explain the difference between data and information Data = raw facts, information=result of processing data to reveal meaning Information requires context to reveal meaning Raw data must be formatted for storage, processing, and presentation Explain what a database is, the various types of databases Database = shared, integrated computer structure that stores a collection of end user data (raw facts) and metadata (data about data) DBMS is collection of programs that control access to data, intermediary between the use and database o Single User DB – supports 1 user at a time (desktop) o Multiuser DB – multiple users at same time (workgroup and enterprise) o Centralized DB – located at a single site o Distributed DB – across several different sites o Operational DB – supports day to day operations (transaction/production) o Data warehouse – stores data for tactical or strategic decisions o Unstructured data – exists in original state o Structured data – formatted, based on processing to be done o Semi-structured data – processed somewhat o XML DB – supported semi-structured XML data Extensible Markup Language (XML) – data elements in textual formal Explain how modern databases evolved from file systems File systems – collection of file folders, kept in cabinet, organized by expected use Manual systems – data repository for SMALL data collections Computerized file systems – data processing specialist converted files with software and programs to manage the data o Initially resembled manual o Evolved as each file used its own application program to store, retrieve and modify o Evolved as each file was owned by the dept. that created it DBMS developed to address weaknesses Identify the flaws with file system data management Simple file system retrieval required extensive programming Ad hoc queries impossible System administration is complex Changing existing structure was difficult Security features difficult to program (were often omitted) Identify the main components of the database system 1. Hardware – all the system’s physical devices 2. Software – 3 types: a. Operating system software b. DBMS software c. Application programs and utility software 3.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

456-Study-Guide-1 - Database Systems, Chapter 1 Explain the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online