-
transactional info vs analytical info
-
packingslip, sales receipt and/or airline ticket
- vs
- product statistics, sales projections, future growth, and/or trends
-
transactional information
-
encompasses all the info contained within a single bus process or unit of workprimary
purpose to support performing of daily operational tasks
-
scalability
refers to how well a system can adapt to increased demands
-
relational integrity constraint
rules that enforce basic and fundamental information-based constraints
-
relational database advantages
- Increased flexibility
- Increased scalability and performance
- Reduced information redundancy
- Increased information integrity (quality)
- Increased information security
-
relational database model
stores information in the form of logically related two-dimensional tables
-
redundancy
duplication of info or storing the same info in multiple places
-
real-time system
provides real-time information in response to query requests
-
real-time information
immediate, up-to-date information
-
primary key
a field that uniquely identifies a given entity in a table
-
physical view
physical storage of info on a storage device such as a hard disk
-
performance
measures how quickly a system performs a certain process or transaction
-
network database model
a flexible way of representing objects and their relationships
-
logical view
focuses on how users logically access info to meet their particular bus needs
-
integrity constraint
rules that help ensure the quality of info
-
integration
allows seperate systems to communicate directly with ea other
-
information integrity
measure of quality of info
-
information granularity
refers to extent of detail within the info
-
information cleansing or scrubbing
process that weeds out and fixes or discards inconsistent, incorrect or incomplete info
-
hierarchical database model
information is organized into a tree-like structure (using parent/child relationships) in such a way that it cannot have too many relationships
-
forward integration
takes info entered into a given system and sends it automatically to all downstream systems and processes
-
foreign key
primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
-
extraction transformation and loading
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
-
-
a person, place, thing, transaction, or event about which information is stored
- –The rows in each table contain the entities
- –In Figure 7.1 CUSTOMER includes Dave’s Sub Shop and Pizza Palace entities
-
-
•a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
•primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes
-
data-mining tools
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
-
data mining
the process of analyzing data to extract information not offered by the raw data alone
-
data mart
contains a subset of data warehouse information
-
data-driven website
interactive website kept constantly updated and relevent to the needs of its customers through the use of a database
-
database management system
software through which users and application programs interact with a database
-
database
maintains info about various types of obj (inventory), events (transactions), people (employees), and places (warehouses).
-
cube
common term for representation of multidimensional info
-
business-critical integrity constraint
enforces bus rules vital to an org success and often requires more insight and knowledge than relational integrity constraints
-
business intelligence
refers to applications and technologies that are used to gather, provide access to and analyze data and info to support decision-making efforts
-
backward integration
takes info entered into a given system and sends it automatically to all upstream systems and processes
-
-
•characteristics or properties of an entity class
- –The columns in each table contain the attributes
- –In Figure 7.1 attributes for CUSTOMER include Customer ID, Customer Name, Contact Name
-
analytical information
encompasses all organizational info primary purpose to support the performing of managerial analysis tasks
|
|