| front |
back |
revisions |
lasted changed by |
history |
| Problems of file processing? |
-Data redundancy
-Lack of Data Integration
-Data dependence
-Integrity |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
 |
| File processing system was replaced by.....? |
Database management approach. |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| 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 |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| Using special-purpose software to analyze data from a data warehouse to find hidden patterns and trends |
data mining |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| data that defines the data in the data warehouse |
metadata |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| stored in a metadata repository and cataloged by a metadata directory |
metadata |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| 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 |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| Data warehouse are subdivided into _______ |
data marts |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| 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 |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| consist of hyperlinked pages of multimedia(storing links to certain sources) |
hypermedia databases |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| 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. |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| Ensuring that the data in an org's distrubuted databases are consistently and concurrently ______ is a major challenge of distributed database management |
updated |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| ________ and ________ of databases are done to improve database performance at end user worksites |
Replication and distribution |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| _________ databases may be copies of operational, analytical, hypermedia, discussion databases or any other type of database. |
distributed databases |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| 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 |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| 4 types of databases? |
-Operational databases
-Distributed databases
-External databases
-Hypermedia databases |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| databases that store detailed data needed to support the business processes and operations of a company. Can be distributed |
Operational databases |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| also known as subject area databases, transaction databases, and production databases |
operational databases |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| __________ contain data elements describing entities and relationships among entities |
databases |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| 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 |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| an obsolete transaction or master file retained for backup purposes or for long-term historical storage called archival storage |
history file |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| These are classified by the application for which they are primarily used, and are classified by their performance |
file |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| a group of related records |
a file, or table |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| represents a collection of attributes that describe entity |
record |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| A collection of related data fields treated as a unit |
record |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| object, person, place, or event |
entity |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| a caracterisitic or quality |
attribute |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| a data field represents an _________ of some entity |
attribute |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| A data element that consists of a grouping of characters that describe a particular attribute of an entity. |
field |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| consists of a single alphabetic, numeric, or other symbol. |
character |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| The most basic logical data element |
character |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| The three major components of Data resource management are |
-database administration
-data administration
-data planning |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
| a mangagerial activity that applies information systems technology and management tools to the task of managing an organization's data resources. |
Data resource management |
0 |
Saad Mon, 30 Jun 2008 09:45:42 GMT |
|
