EXAM B ITM 310 Flashcards
attribute
Each characteristic or quality of a particular entity.
big data
A collection of data so large and complex that it is difficult to manage using traditional database management systems.
bit
A binary digit—that is, a 0 or a 1.
business rules
Precise descriptions of policies, procedures, or principles in any organization that stores and uses data to generate information.
byte
A group of eight bits that represents a single character.
database management system (DBMS)
The software program (or group of programs) that provide access to a database.
data dictionary
A collection of definitions of data elements; data characteristics that use the data elements; and the individuals, business functions, applications, and reports that use these data elements.
data file (also table)
A collection of logically related records.
data governance
An approach to managing information across an entire organization.
data lake
A central repository that stores all of an organization’s data, regardless of their source or format.
data mart
A low-cost, scaled-down version of a data warehouse that is designed for the end-user needs in a strategic business unit (SBU) or a department.
data model
A diagram that represents entities in the database and their relationships.
data silo
A collection of data held by one group that is not easily accessible by other groups.
data warehouse
A repository of historical data that are organized by subject to support decision makers in the organization
entity
Any person, place, thing, or event of interest to a user.
entity relationship (ER) diagram
Document that shows data entities and attributes and relationships among them.
entity relationship (ER) modeling
The process of designing a database by organizing data entities to be used and identifying the relationships among them.
explicit knowledge
The more objective, rational, and technical types of knowledge.
field
A characteristic of interest that describes an entity.
foreign key
A field (or group of fields) in one table that uniquely identifies a row (or record) of another table.
functional dependency
A means of expressing that the value of one particular attribute is associated with, or determines, a specific single value of another attribute.
instance
Each row in a relational table, which is a specific, unique representation of the entity.
intellectual capital (or intellectual assets)
other terms for knowledge
joint operation
A database operation that combines records from two or more tables in a database.
knowledge management (KM)
A process that helps organizations identify, select, organize, disseminate, transfer, and apply information and expertise that are part of the organization’s memory and that typically reside within the organization in an unstructured manner.
Knowledge management systems (KMS)
Information technologies used to systematize, enhance, and expedite intra- and interfirm knowledge management.
master data
A set of core data, such as customer, product, employee, vendor, geographic location, and so on, that spans an enterprise’s information systems.
master data management
A process that provides companies with the ability to store, maintain, exchange, and synchronize a consistent, accurate, and timely “single version of the truth” for the company’s core master data
multidimensional structure
Storage of data in more than two dimensions; a common representation is the data cube.
normalization
A method for analyzing and reducing a relational database to its most streamlined form to ensure minimum redundancy, maximum data integrity, and optimal processing performance.
primary key
A field (or attribute) of a record that uniquely identifies that record so that it can be retrieved, updated, and sorted.
query by example
To obtain information from a relational database, a user fills out a grid or template—also known as a form—to construct a sample or a description of the data desired.
record
A grouping of logically related fields.
relational database model
Data model based on the simple concept of tables in order to capitalize on characteristics of rows and columns of data.
relationships
Operators that illustrate an association between two entities.