• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/37

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

37 Cards in this Set

  • Front
  • Back
  • 3rd side (hint)
ad hoc query
spur of the moment question
centralized database
data location at a single site
data
raw facts
data anomaly
data stored in multiple places not updated in all places
data dependence
when data structure changes, it breaks everything. flat files
data dictionary
the metadata of a database, tables, fields, etc
data inconsistency
different data in different tables
data independence
making structural changes doesn't break everything. relational database
data integrity
data is consistent with the real world
data management
study of the proper storage, generation and retrieval of data
data redundancy
storage of same data at multiple locations
data warehouse
used to generate reports for strategic or tactical decisions
database
a shared integrated system for storing data
database design
design of the structure used to store data
database management system
DBMS, a collection of programs that gives access to data and data structures
database system
hardware, software, people, procedures and data
desktop database
a single user database
distributed database
supports data distributed across several different sites
enterprise database
a database shared by the whole company across many departments
журнал
САМУРАЙ читает женский ЖУРНАЛ и СЛОВА, написанные там, разят его прямо в серде
field
column, used to define and store data
file
a collection of related records
information
processed data
islands of information
the same data stored in different locations, the term used to describe these locations
logical data format
a human view of the data (as compared to the machine view)
metadata
data about data
operational database
a databased designed to handle day to day operations
performance tuning
activities which make the database more efficient and quicker
physical data format
how the machine views data as compared to how a person views data
production database
sometimes referred to as a companies operational database
query
a request made to the DBMS for database manipulation or reporting
structural dependence
access to the file is dependent on its structure. refers to the short comings of flat files
query result set
the DBMS response to a query
record
a collection of fields or columns that describes a person place or thing
structural independence
changes to database structure are easy and don't break applications
unstructured data
data that exists in its raw state as it was collected
structured data
formatting data to make storage reporting and use easier