Chapter 11 - I. Chapter 11 Databases A. File and Database...

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

View Full Document Right Arrow Icon
I. Chapter 11 – Databases A. File and Database Concepts 1. Database Basics a) A database is a collection of information (1) Typically stored as computer files b) The tasks associated with creating, maintaining, and accessing the information in databases are referred to as data management, file management, or database management. c) Databases can be used in a variety of ways (1) Collect and store data (2) Update data (3) Organize and output data (4) Distribute data (5) Find data (6) Analyze data d) Data mining refers to the process of analyzing existing information in databases to discover previously unknown and potentially useful information, including relationships and patterns (1) Data warehouse (2) Predictive analytics e) OLAP (online analytical processing) allows decision makers to look for relationships between multiple data dimensions (1) Executive dashboard software 2. Database Models a) An unstructured file has a unique structure 1 Chapter 11
Background image of page 1

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

View Full DocumentRight Arrow Icon
b) A structured file uses a uniform format to store data c) The underlying structure of a database is referred to as a database model d) The simplest model for storing data is a flat file that consists of a single, two-dimensional table of data elements e) A field contains the smallest unit of meaningful information f) Each field has a unique field name g) Variable-length field vs. fixed-length field h) A record is a collection of data fields i) The template for a record is referred to as a record type j) A record that contains data is referred to as a record occurrence k) A relationship is an association between data that is stored in different record types (1) One-to-many (2) Many-to-many (3) One-to-one l) Cardinality refers to the number of associations that can exist between two record types m) The relationship between record types can be depicted graphically with an entity-relationship diagram n) A hierarchical database arranges record types in a hierarchy o) The network database model allows many-to-many relationships in addition to one-to-many relationships p) A relationship database stores data in a collection of related tables q) A dimensional database organizes relationships over three or more dimensions r) An object database stores data as objects, which can be grouped into classes and defines by attributes and methods\ s) An object-rational database is used to describe a variety of technologies that combine object- oriented and relational concepts 2 Chapter 11
Background image of page 2
B. Data Management Tools
Background image of page 3

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

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

This note was uploaded on 08/30/2011 for the course CGS 2100C taught by Professor Abadallah during the Spring '08 term at University of Central Florida.

Page1 / 9

Chapter 11 - I. Chapter 11 Databases A. File and Database...

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

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