Databases and Information Management Flashcards
is a subset of a data warehouse in which a summarized or highly focused portion of the organization’s
data is placed in a separate database for a specific population of users.
Data mart
where the same attribute may have different values
Data Inconsistency
, events are linked over time.
Sequences
occurs when different groups in an organization independently
collect the same piece of data and store it independently of each other.
Data Redundancy
A group of related files makes up a
Database
deals with the policies and
processes for managing the availability, usability, integrity, and security of the
data employed in an enterprise, with special emphasis on promoting privacy,
security, data quality, and compliance with government regulations.
Data governance
These tools are
able to extract key elements from large unstructured data sets, discover
patterns and relationships, and summarize the information. Businesses might
turn to text mining to analyze transcripts of calls to customer service centers to
identify major service and repair issues.
Text mining tools
acts as an interface
between application programs and the physical data files.
DBMS
supports multidimensional data analysis, enabling users to
view the same data in different ways using multiple dimensions.
OLAP - Online analytical processing
Rows are commonly referred to as records, or in very technical terms, as
Tuples
is software that permits an
organization to centralize data, manage them efficiently, and provide access
to the stored data by application programs.
Database management system
is a person, place, thing, or event on
which we store and maintain information
Entity
capability to specify the structure of the content
of the database. It would be used to create database tables and to define the
characteristics of the fields in each table
Data definition
presents data as they would be
perceived by end users or business specialists,
Logic View
represents a single character, which can be a letter, a number, or another symbol.
Byte
Type of information obtained in data mining are
Association, sequences, classification, clustering, and forecasting.
stores the data and procedures that act on those data as objects that can be automatically retrieved and shared
Object-oriented DBMS
A group of related fields, such as the student’s name, the course taken,
the date, and the grade, comprises a
Record
represent data as two-dimensional tables (called relations). Tables may be referred to as files. Each table contains data on an
entity and its attributes.
Relational DBMS
is a database that stores current and historical data of
potential interest to decision makers throughout the company.
consolidates and standardizes
information from different operational databases so that the information can be
used across the enterprise for management analysis and decision making
Data warehouse
Problems with traditional file environment
- Data Redundancy and Inconsistency
- Program-Data Dependence
- Lack of Flexibility
- Poor Security
- Lack of data sharing and availability