Shared Flashcard Set

Details

K321
Chap 5
33
Management
Undergraduate 4
10/02/2013

Additional Management Flashcards

 


 

Cards

Term
Attributes
Definition
Pieces of information describing a particular entity
Term
Data administration
Definition
a special organizational function for managing the organizations's data resources, concerned with information policy, data planning, maintenance of data dictionaries, and data quality standards.
Term
Data cleansing
Definition
Activities for detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant. AKA data scrubbing.
Term
Data definition
Definition
Specifies the structure of the content of a database.
Term
Data dictionary
Definition
An automated or manual tool for storing and organizing information about the data maintained in a database.
Term
Data manipulation language
Definition
a language associated with a database management system that end users and programmers use to manipulate data in the database.
Term
Data mart
Definition
a small data warehouse containing only a potion of the organization's data for a specified function or population of users.
Term
Data mining
Definition
analysis of large pools of data to find patterns and rules that can be used to guide decision making and predict future behavior.
Term
Data quality audit
Definition
a survey and/or sample of files to determine accuracy and completeness of data in an information system.
Term
Data warehouse
Definition
a database, with reporting and query tools, that stores current and historical data extracted from various operational systems and consolidated for management reporting and analysis.
Term
Database
Definition
a group of related files
Term
Database administration
Definition
refers to the more technical and operational aspects of managing data, including physical database design and maintenance.
Term
Database management system (DBMS)
Definition
special software to create and maintain a database and enable individual business applications to extract the data they need without having to create separate files or data definitions in their computer programs.
Term
Database Server
Definition
A computer in a client/server environment that is responsible for running a DBMS to process SQL statements and perform database management tasks.
Term
Entity
Definition
a person, place, thing, or event about which information must be kept.
Term
Entity-relationship diagram
Definition
a methodology for documenting databases illustration the relationship between various entities in the database.
Term
Field
Definition
a grouping of characters into a word, a group of words, or a complete number, such as a person's name or age.
Term
Foreign key
Definition
field in a database table that enables users to find related information in another database table.
Term
Information policy
Definition
formal rules governing the maintenance, distribution, and use of information in an organization.
Term
Key Field
Definition
a field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted.
Term
Normalization
Definition
the process of creating small stable data structures from complex groups of data when designing a relational database.
Term
Object-oriented DBMS
Definition
an approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared; the objects can contain multimedia.
Term
Object-relational DBMS
Definition
a database management system that combines the capabilities of a relational DBMS for storing traditional information and the capabilities of an object-oriented DBMS for storing graphics and multimedia.
Term
Online analytical processing (OLAP)
Definition
capability for manipulating and analyzing large volumes of data from multiple perspectives.
Term
Predictive analysis
Definition
use of datamining techniques, historical data, and assumptions about future conditions to predict outcomes of events.
Term
Primary key
Definition
Unique identifier for all the information in any row of a database table.
Term
Records
Definition
groups of related fields
Term
Referential integrity
Definition
rules to ensure that relationships between coupled database tables remain consistent
Term
Relational database
Definition
a type of logical database model that treats data as if they were stored in two-dimensional tables. It can relate data stored in one table to data in another as long as the two tables share a common data element.
Term
Structured Query language (SQL)
Definition
the standard data manipulation language for relational database management systems.
Term
Text mining
Definition
discovery of patterns and relationships from large sets of unstructured data.
Term
Tuples
Definition
rows or records in a relational database.
Term
Web mining
Definition
discovery and analysis of useful patterns and information from the World Wide Web.
Supporting users have an ad free experience!