Data info Flashcards
Database
a collection of organized data that allows access, retrieval, and use of data
Data
raw facts that describe the characteristics of an event or object
Information
Data converted into a meaningful and useful context
master data management (MDM)
processes to integrate data from various sources and enterprise apps in order to create unified view of data
Document Management System (DMS)
hardware and software to manage, archive, and purge files and other electronic documents
enterprise content management (ECM)
aimed at managing the life-cycle of information from initial publication creation all the way through archival and eventually disposal.
Database Management System (DBMS)
Facilitates access to centralized data, allows data to be managed efficiently, operates logical and physical views, Solves problems of traditional files environment
Traditional File Environment
Using one application at a time to manage data, leading to data issues
data redundancy
occurs when unnecessary duplicate information exists in a database
data inconsistency
occurs when the same data element has different values
Program-data dependence
When changes in program requires changes to data accessed by program
Data filtering and profiling
Inspecting the data for errors, inconsistencies, redundancies, and incomplete information.
Data Quality
the process of correcting, standardizing, and verifying the integrity of the data
data synchronization
the process of Integrating, matching, or linking data from disparate sources
Data enrichment
Enhancing data using information from internal and external data sources.
data maintenance
checking and controlling data integrity over time
relational database management system
Data are grouped into similar collections, called tables, and the relationships between tables are formed by using a common field
Rows
in a database table this is used for the records of different entities
Fields
In a database columns in the table; describes a characteristic of the record
Key field
A field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted
Primary Key
A field (or group of fields) that uniquely identifies a given entity in a table
Foreign Key
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables