Information Systems Chapter 3

Data Driven Web Site

acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

Fragmentation

approach to a distributed DBMS addresses how tables are divided among multiple locations. There are three variations: horizontal, vertical, and mixed.

Allocation

approach to a distributed DBMS combines fragmentation and replication, with each site storing the data it uses most often.

Replication

approach to a distributed DBMS has each site store a copy of the data in the organization's database.

Object Oriented Database

both data and their relationships are contained in a single object. An object consists of attributes and methods that can be performed on the object's data.

Data Model

determines how data is created, represented, organized, and maintained. It usually contains data structure, operations, and integrity rules.

Database Administrators

found in large organizations, design and set up databases, establish security measures, develop recovery procedure, evaluate database performance, and add fine tune database functions.

Online Analytical Processing

generates business intelligence. It uses multiple sources of information and provides multidimensional analysis, such as viewing data base on time, product, and location.

Normalization

improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Physical View

involves how data is stored on and retrieved from storage media, such as hard disks, magnetic tapes, or CDs.

Logical View

involves how information appears to users and how it can be organized and retrieved.

Data Warehouse

is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

Database

is a collection of related data that is stored in a central location or in multiple locations.

Foreign Key

is a field in a relational table that matches the primary key column of another table. It can be used to cross reference tables.

Structured Query Language

is a standard fourth generation query language used y many DBMS packages, such as Oracle 11g and Microsoft SQL server. SQL consists of several key words specifying actions to take.

Big Data

is data so voluminous that conventional computing methods are not able to efficiently process and manage it.

Network Model

is similar to the hierarchical model, but records are organized differently. Instead, each record in the network model can have multiple parent and child records.

Database Management Systems

is software for creating, storing, maintaining, and accessing database files. A DBMS makes using databases more efficient.

Data Hierarchy

is the structured and organization of data, which involves fields, records, and files.

Data Mining Analysis

is used to discover patterns and relationships.

Online Transaction Processing

is used to facilitate and manage transaction-oriented applications, such as point of sale, data entry, and retrieval transaction processing. It generally uses internal data and responds in real time.

Data Mart

is usually a smaller version of data warehouse, used by a single department or function.

Random Access File Structure

records can be accessed in any order, regardless of their physical locations in storage media. This method of access is fast and very effective when a small number of records need to be processed daily or weekly.

Indexed Sequential Access Method

records can be accessed sequentially or randomly, depending on the number being accessed. For a small number, random access is used, and for a large number, sequential access is used.

Sequential Access File Structure

records in files are organized and processed in numerical or sequential order, typically the order in which they were entered.

Encapsulation

refers to the grouping into a class of various objects along with their attributes and methods-meaning, grouping related items into a single unit. This helps handle more complex types of data, such as image sand graphs.

Inheritance

refers to the new objects being created faster and more easily by entering new data in attributes.

Extraction, Transformation, and Loading

refers to the processes used in data warehouse. It includes extracting data from outside sources, transforming it to fit operational needs, and loading it onto the end target.

Create, Read, Update, and Delete (CRUD)

refers to the range of functions that data administrators determine who has permission to perform certain functions.

Distribute Database Management System

stored data on multiple servers throughout an organization.

Data Dictionary

stores definitions, such as data types for fields, default values, and validation rules for data in each field.

Hierarchical Model

the relationships between records form a tree like structure. Records are called nodes, and relationships between records are called branches. The node at the top is called the root, and every other node has a parent. Nodes with the same parents are called twins or siblings.

Primary Key

uniquely identifies every record in a relational database. Examples include student ID numbers, account numbers, Social Security numbers, and invoice numbers.

Business Analytics

used data and statistical methods to gain insight into the data and provide decision makers with information they can act on.

Relational Model

uses a two-dimensional table of rows and columns of data. Rows are records, and columns are fields.

Query by Example

you request data from a database by constructing a statement made up of query forms. With current graphical databases, you simply click to select query forms instead of having to remember keywords, as you do with SQL. You can add AND, OR, and NOT operators to the QBE form to fine-tune the query.