Study IS 300: Chapter 5 Flash Cards

 
Pile Management Card
IS 300: Chapter 5

loading
Problems of file processing?
-Data redundancy
-Lack of Data Integration
-Data dependence
-Integrity
File processing system was replaced by.....?
Database management approach.
Systems that organized data into specialized files of data records desighned for processing only by specific application programs. Data are organized, stored, and processed in independent files of data records.
File processing systems
Using special-purpose software to analyze data from a data warehouse to find hidden patterns and trends
data mining
data that defines the data in the data warehouse
metadata
stored in a metadata repository and cataloged by a metadata directory
metadata
holds subsets of data from the data warehouse that focus on specific aspects of a company, such as department or a business process.
data marts
Data warehouse are subdivided into _______
data marts
An integrated collection of data extracted from operational, historical, and external databases, and cleaned, transformed, and cataloged for retrieval and analysis (data mining), to provide business intelligence for business decision making
data warehouse
consist of hyperlinked pages of multimedia(storing links to certain sources)
hypermedia databases
contain a wealth of information available from commercial online services and from many sources on the World Wide Web. Data are available in the form of statistics on economic and demographic activity from statistical data banks
External databases.
Ensuring that the data in an org's distrubuted databases are consistently and concurrently ______ is a major challenge of distributed database management
updated
________ and ________ of databases are done to improve database performance at end user worksites
Replication and distribution
_________ databases may be copies of operational, analytical, hypermedia, discussion databases or any other type of database.
distributed databases
the concept of distributing databases or portions of a database at remote sites where the data are most frequently referenced. Sharing data is made possible through a network that internconnects the distributed databases.
Distributed databases
4 types of databases?
-Operational databases
-Distributed databases
-External databases
-Hypermedia databases
databases that store detailed data needed to support the business processes and operations of a company. Can be distributed
Operational databases
also known as subject area databases, transaction databases, and production databases
operational databases
__________ contain data elements describing entities and relationships among entities
databases
an intergrated collection of logically related data elements. It consolidates many records previously stored in separate files so that a common pool of data serves many applications
database
an obsolete transaction or master file retained for backup purposes or for long-term historical storage called archival storage
history file
These are classified by the application for which they are primarily used, and are classified by their performance
file
a group of related records
a file, or table
represents a collection of attributes that describe entity
record
A collection of related data fields treated as a unit
record
object, person, place, or event
entity
a caracterisitic or quality
attribute
a data field represents an _________ of some entity
attribute
A data element that consists of a grouping of characters that describe a particular attribute of an entity.
field
consists of a single alphabetic, numeric, or other symbol.
character
The most basic logical data element
character
The three major components of Data resource management are
-database administration
-data administration
-data planning
a mangagerial activity that applies information systems technology and management tools to the task of managing an organization's data resources.
Data resource management
Place this card into pile: