Quiz 1 Flashcards
What is Data
Raw facts
What is information?
the result of processing raw data to reveal its meaning
what is Knowledge
familiarity awareness and understanding of information
a discipline that focuses on properly generating storage and retrieval of data
Data management
a shared integrated computer structure that stores a collection of End-user-data and meta data
Database
Meta data
data about data
DBMS
Database management system
data inconsistency
when different versions of the same data appear in different places
Query
specific request
ad hoc query
spur of the moment question
query result set
what the dbms sends back
Data Quality
a comprehensive approach to promoting accuracy validity and timeliness of data
Single-user data base
supports one user
runs on personal computer
desktop database
multiuser data base
Supports multiple users at the same time
workgroup database
small number of users less then 50
enterprise database
more then 50 users
centralized database
data located at a single site
distributed database
data distributed across several different sites
general-purpose databases
contain a wide variety of data used in multiple diciplines
discipline-specific databases
contain data focused on specific subject areas
operational database
supports a company’s day to day transactions
operational databases are also known as
Online transactions processing (oltp), transaction, production database
analytical databases
focus on storing historical data
Data warehouse
stores data in a format optimized for decision making
Set of tools that provide advanced data analysis
OLAP online analytical processing
Business intelligence
approach to capture and process business data to help support business decisions
data that exist in raw state
Unstructured data
result of formating unstructured data to facilitate storaage
Structured data
semistructured data
some structuring has been done
special language used to manipulate data elements in a textual format
Markup Language XML
supports the storage and management of semistructured xml data
XML database
Social Media
anywhere anytime access style database
Not only SQL
NoSQL
focus on design of database
database design
access to a file is dependent on its structure
Structural dependence
You can change the file structure without affecting the application
Structural independence
exists when you can change the data storage characteristics with out afftecting the programs ability to access the data
data independence
When you cant change data storage characteristics and still access the data
Data dependence
How the human views the data
Logical data format
how the computer must work with the data
Physical data format
Scattered locations of information
Islands of information
keeping data in more then one place
Data redundancy
when required changes in redundant data are not successful
Data anomaly
organization of components that define and regulate the collection, storage management and use of data withing a database environment
Database System
Used to look up required data component structures and relationships
Data dictionary
relates to activities that make the database perform more effciently
Performance Tuning
Nonprocedural language, lets the user specify what must be done without having to specify how
Query language
SQL structured query language
de facto language of most dbms
Loose coupling
Keeping the database separate from the application(dbms)
