bustech6-8

• vs
• product statistics, sales projections, future growth, and/or trends

purpose to support performing of daily operational tasks

refers to how well a system can adapt to increased demands

rules that enforce basic and fundamental information-based constraints

• Increased scalability and performance
• Reduced information redundancy
• Increased information integrity (quality)
• Increased information security

stores information in the form of logically related two-dimensional tables

duplication of info or storing the same info in multiple places

provides real-time information in response to query requests

immediate, up-to-date information

a field that uniquely identifies a given entity in a table

physical storage of info on a storage device such as a hard disk

measures how quickly a system performs a certain process or transaction

a flexible way of representing objects and their relationships

focuses on how users logically access info to meet their particular bus needs

rules that help ensure the quality of info

allows seperate systems to communicate directly with ea other

measure of quality of info

refers to extent of detail within the info

process that weeds out and fixes or discards inconsistent, incorrect or incomplete info

information is organized into a tree-like structure (using parent/child relationships) in such a way that it cannot have too many relationships

takes info entered into a given system and sends it automatically to all downstream systems and processes

primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse

• –The rows in each table contain the entities
• –In Figure 7.1 CUSTOMER includes Dave’s Sub Shop and Pizza Palace entities

•primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes

uses a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making

the process of analyzing data to extract information not offered by the raw data alone

contains a subset of data warehouse information

interactive website kept constantly updated and relevent to the needs of its customers through the use of a database

software through which users and application programs interact with a database

maintains info about various types of obj (inventory), events (transactions), people (employees), and places (warehouses).

common term for representation of multidimensional info

enforces bus rules vital to an org success and often requires more insight and knowledge than relational integrity constraints

refers to applications and technologies that are used to gather, provide access to and analyze data and info to support decision-making efforts

takes info entered into a given system and sends it automatically to all upstream systems and processes

• –The columns in each table contain the attributes
• –In Figure 7.1 attributes for CUSTOMER include Customer ID, Customer Name, Contact Name

encompasses all organizational info primary purpose to support the performing of managerial analysis tasks