Shared Flashcard Set

Details

Database Vocabulary
This vocabulary is meant to further the knowledge of the basics of databases.
36
Other
11th Grade
11/12/2009

Additional Other Flashcards

 


 

Cards

Term
Database
Definition
a collection of information stored in an organized form on a computer
Term
Database program
Definition
a software tool used for organizing and retrieving information in a database
Term
Table
Definition
a collection of related information
Term
Record
Definition
the information related to one person, product, or event
Term
Field
Definition
Each piece of information in a record
Term
Computed fields
Definition
they display values calculated from values in other numeric fields
Term
Form view
Definition
Shows one record at a time
Term
List views
Definition
Shows several records in a list
Term
Import data
Definition
the way databases get information from word processors, spreadsheets, and other databases
Term
Query
Definition
An information request
Term
Report
Definition
an ordered list of selected records and fields in an easy-to-read format
Term
Query language
Definition
Is the language used to request information with language that is more precise than english
Term
Structured Query Language (SQL)
Definition
A standard language that is used for programming complex queries
Term
Geographical information systems (GIS)
Definition
allows for anyone to combine tables of data
Term
Personal information manager
Definition
A program that can automate address and phone books, appointment calendars, to-do lists and miscellaneous notes
Term
File manager
Definition
a program that allows the user to work with one file at a time
Term
Database-management system (DBMS)
Definition
a program or system of programs that can manipulate data in large collections of files
Term
Relational database
Definition
a program that allows tables to be related to each other so that changes in one table are reflected in other tables automatically
Term
Batch processing
Definition
a way for people to accumulate information and feed them into a computer in large batches
Term
Interactive processing
Definition
Users are able to interact with data and change information in real time
Term
Client/server
Definition
An easier way for the client to access the information with a simpler user interface then a normal database
Term
Data warehouses
Definition
They are large, relatively expensive and centralized but they give users direct access to data
Term
Distributed databases
Definition
databases that spread data across networks on several different computers rather than store it in one central site
Term
Data mining
Definition
the discovery and extraction of hidden predictive information from large databases.
Term
XML
Definition
a newer, more powerful data description language that was designed with database access in mind.
Term
Directories
Definition
databases that can store any sort of basic information
Term
Customer relationship management (CRM)
Definition
software systems for organizing and tracking information on customers
Term
Dirty data
Definition
data that contains errors
Term
Data scrubbing
Definition
the process of going through a database and eliminating dirty data
Term
Object-oriented databases
Definition
store objects, like pictures and their descriptions
Term
Natural language
Definition
queries that can be made in regular english
Term
Privacy
Definition
the notion of access
Term
Access
Definition
the physical proximity to a person or knowledge about that person
Term
Record matching
Definition
matching information from multiple databases that have one thing in common
Term
Right to privacy
Definition
not actually in the constitution, but is implied by other constitutional guarantees
Term
Code of Fair Information Practices
Definition
there can be no secret government databases and the people should be able to see the information stored about them on government databases
Supporting users have an ad free experience!