Shared Flashcard Set

Details

quiz chapter 3
DIGITAL DIVIDE
40
Computer Science
Undergraduate 2
04/29/2015

Additional Computer Science Flashcards

 


 

Cards

Term
attribute
Definition
characteristic of an entity
Term
big data
Definition
large amounts of unstructured data that is difficult or impossible to capture, store, and manipulate using traditional database management systems
Term
business intelligence (BI)
Definition
gathering enough of the right information in a timely manner and usable form and analyzing it so that it can have a positive effect on business strategy
Term
character
Definition
A basic building block of most information, consisting of uppercase letters, lowercase letters, numeric digits, or special symbols
Term
competitive intelligence
Definition
intelligence One aspect of business intelligence limited to information about competitors and the ways that knowledge affects strategy, tactics, and operations
Term
concurrency control
Definition
A method of dealing with a situation in which two or more users or applications need to access the same record at the same time.
Term
counterintelligence
Definition
The steps an organization takes to protect information sought by “hostile” intelligence gatherers.
Term
dashboard
Definition
shows current data, graphs, and tables to help managers make better real-time decisions
Term
data administrator
Definition
A nontechnical position responsible for defining and implementing consistent principles for a variety of data issues.
Term
data cleansing (data cleaning or data scrubbing)
Definition
The process of looking for and fixing inconsistencies to ensure that data is accurate and complete.
Term
data definition language (DDL)
Definition
A collection of instructions and commands used to define and describe data and relationships in a specific database
Term
data dictionary
Definition
A detailed description of all the data used in the database
Term
data item
Definition
The specific value of an attribute.
Term
data manipulation language (DML)
Definition
A specific language, provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports
Term
data mart
Definition
A subset of a data warehouse, used by small and mediumsized businesses and departments within large companies to support decision making
Term
data mining
Definition
An information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse
Term
data model
Definition
A diagram of data entities and their relationships
Term
data warehouse
Definition
A large database that collects business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers, in support of management decision making
Term
database administrators (DBAs)
Definition
A skilled IS professional who directs all activities related to an organization’s database.
Term
database approach to data management
Definition
An approach to data management where multiple information systems share a pool of related data
Term
database management system (DBMS)
Definition
A group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs
Term
domain
Definition
The allowable values for data attributes
Term
enterprise data modeling
Definition
modeling done at the level of the entire enterpris
Term
entity
Definition
A general class of people, places, or things for which data is collected, stored, and maintained
Term
entity-relationship (ER) diagrams
Definition
) diagrams Data models that use basic graphical symbols to show the organization of and relationships between data.
Term
field
Definition
Typically a name, number, or combination of characters that describes an aspect of a business object or activity
Term
file
Definition
A collection of related records
Term
hierarchy of data
Definition
Bits, characters, fields, records, files, and databases In-memory database
Term
joining
Definition
Manipulating data to combine two or more tables
Term
key performance indicators (KPIs)
Definition
The ability to combine two or more tables through common data attributes to form a new table with only the unique data attributes
Term
NoSQL database
Definition
database management systems that can handle or accommodate data that does not fit into tables required by traditional relational databases
Term
online analytical processing (OLAP)
Definition
Software that allows users to explore data from a number of perspectives.
Term
predictive analysis (also called predictive analytics)
Definition
A form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events, such as future product sales or the probability that a customer will default on a loan.
Term
primary key
Definition
A field or set of fields that uniquely identifies the record
Term
projecting
Definition
Manipulating data to eliminate columns in a table
Term
record
Definition
A collection of data fields all related to one object, activity, or individual
Term
relational model
Definition
A database model that describes data in which all data elements are placed in two-dimensional tables, called relations, which are the logical equivalent of files
Term
schema
Definition
A description of the entire database.
Term
selecting
Definition
Manipulating data to eliminate rows according to certain criteria
Term
traditional approach to data management
Definition
An approach to data management whereby each distinct operational system uses data files dedicated to that system.
Supporting users have an ad free experience!