deck_293416 Flashcards

2
Q

Bit

A

Smallest unit of data a computer can handle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Byte

A

Group of bit. Single charactere: letter, number, etc..

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Field

A

Grouping of charactere into a word, a group of words, or a complete number / Columns in a relational DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Record

A

A group of related fields, such as the student’s name, the course taken, the date, and the grade, it is a row in a relational DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

File

A

A Group of related records / A talbe in a relational DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Database

A

Def 1: Group of related files Def 2: A collection of data organized to serve many applications efficiently by centralizing the data and managing redundant data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Entity

A

A person, place, thing, or event about which we store and maintain information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Attribute

A

Characteristic or quality describing a particular entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Problems with traditional file environment

A
  • Data redundancy and Inconsistency - Program Data dependance - Lack of flexibility - Poor security - Lack of Data Sharing and Availability
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Data Redundancy

A

The presence of duplicate data in multiple data files so that the same data are stored in more than one place or location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Data Inconsistency

A

The same attribute may have different values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Program–Data Dependence

A

The coupling of data stored in files and the specific programs required to update and maintain those files so that changes in programs require changes to the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Lack of flexibility

A

A traditional file system can deliver routine scheduled reports after extensive programming efforts, but it cannot deliver ad hoc reports or respond to unanticipated information requirements in a timely fashion

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Poor security

A

Because there is little control or management of data, access to and dissemination of information may be out of control

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Database Management System (DBMS)

A

Software that permits an organization to centralize data, manage them efficiently, and provide access to the stored data by application programs It relieves the programmer or end user from the task of understanding where and how the data are actually stored by separating the logical and physical views of the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Logical View

A

Presents data as they would be perceived by end users or business specialists

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Physical View

A

Shows how data are actualy organized and structured on physical storage media

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Relational DBMS

A

Represents data as a 2 dimentiona table called relations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Key Field / Primary Key

A

A field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Foreign Key

A

a lookup fi eld to look up data about another relational database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

3 Operations of the relational database

A
  • Select - Joint - Project
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Select operation of a relational database

A

Creates a subset consisting of all records in the file that meet stated criteria

24
Q

Join operation of the relational database

A

Combines relational tables to provide the user with more information than is available in individual tables

25
Q

Project operation of a relational database

A

Creates a subset consisting of columns in a table, permitting the user to create new tables that contain only the information required

26
Multimedia
The integration of two or more types of media such as text, graphics, sound, voice, full-motion video, or animation into a computer-based application
27
object-oriented DBMS (OODBMS)
Better suited than simple DBSM to handle graphics-based or multimedia applications.It stores the data and procedures that act on those data as objects that can be automatically retrieved and shared
28
 object-relational DBMS
 provide capabilities of both object-oriented and relational DBMS
29
 Data Definition
The component of a database management system that defines each data element as it appears in the database
30
Data Dictionary
 an automated or manual file that stores definitions of data elements and their characteristics
31
 data Manipulation Language
A language associated with a database management system that end users and programmers use to manipulate data in the database
32
 Structured Query Language (SQL)
The most prominent data manipulation language today
33
Normalization
process of creating small, stable, yet flexible and adaptive data structures from complex groups of data
34
 Referential Integrity Rules
 ensure that relationships between coupled tables remain consistent
35
 Entity-Relationship Diagram
A methodology for documenting databases illustrating the relationship between various entities in the database
36
 Data Warehouse
 Database that stores current and historical data of potential interest to decision makers throughout the company. It consolidates and standardize information which can be easily accessed, but can no longer be altered. Also provides a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities
37
Data Mart
A subset of the data warehouse in which a summarized or highly focused portion of the organization’s data is put in a separate database for a specific population of users  
38
 Online aAnalytical Processing (OLAP)
Supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions. Each aspect of information—product, pricing, cost, region, or time period—represents a different dimension
39
Data mining
 Data mining provides insights into corporate data that cannot be obtained with OLAP by finding hidden patterns and relationships in large databases and inferring rules from them to predict future behaviour. The types of information obtainable from data mining include associations, sequences, classifications, clusters, and forecasts
40
Data mining Association
Occurrences linked to a single event
41
Data mining Sequences
Findes relationships between events that are linked over time  
42
Data mining Classification
 Recognizes patterns that describe the group to which an item belongs by examining existing items that have been classified and by inferring a set of rules
43
Data Mining Clustering
 Can discover different groupings within data
44
Data Mining Forecasting
 It uses a series of existing values to forecast what other values will be
45
Predctive analytics
Use data mining techniques, historical data, and assumptions about future conditions to predict outcomes of events, such as the probability that a customer will respond to an offer or purchase a specific product  
46
Text Mining
 extract key elements from large unstructured data sets, discover patterns and relationships, and summarize the information
47
Web Mining
The discovery and analysis of useful patterns and information from the World Wide Web
48
Database server
 In a client/ server environment, the DBMS resides on a dedicated computer
49
Information Policy
 specifies the organization’s rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information
50
Data Administration
Is responsible for the specific policies and procedures through which data can be managed as an organizational resource
51
Data Governance
  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
52
Database Administration
Refers to the more technical and operational aspects of managing data, including physical database design and maintenance
53
 Data Quality Audit
 a structured survey of the accuracy and level of completeness of the data in an information system
54
Data Cleansing
 consists of activities for detecting and correcting data in a database that are incorrect, incomplete, improperly formatted, or redundant. It not only corrects errors but also enforces consistency