McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Life Long Learning
Data Files
The Buzz in IT
Ask the Author
Did You Know
Purchasing
Cool Web Sites
I-Witness
Interactive Companion
Did You Know
Crossword
Glossary
Group Activity #4
Retread Auto Database
Privacy
Cracked Companies
DBs & DBMSs
Personal Portals
Security Tracking
Mixed Quiz
Feedback
Help Center


I-Series Computing Concepts
Stephen Haag, University of Denver
Maeve Cummings, Pittsburg State University
Alan I Rea, Jr., Western Michigan University

Files And Databases

Glossary


Access speed    is the time between when you ask for a file and the computer delivers it to you.
Alphabetic validation    makes sure only letters appear in a field.
Archive    is a copy of older data that becomes historical records.
Attribute    is a quality than an object possesses.
Child    is a sub-directory or sub-folder.
Class    is a collection of similar objects.
Cluster    is an organized collection of sectors.
Compound primary key    occurs when two or more fields identify a distinct record.
Compressed file    is a smaller file due to file compression.
Compression ratio    determines how small you want a compressed file to be.
Compression software    is utility software that allows you to compress a file or files.
Data    are distinct itmes that don't have much meaning to you in a given context.
Database    stores and organizes data.
Database administrator (DBA)    designs, implements, and maintains solutions to business challenges using databases.
Database management system (DBMS)    is application software that allows you to arrange, modify, and extract data from a database to create information.
Data broker    is a company that searches many databases and returns information to you.
Data dictionary    defines the basic organization of a database.
Data file    contains organized data destined for use in a database.
Data integrity    makes sure the right type of data is in each field.
Data security    restricts database access for viewing, organizing and updating data files.
Data structure    organizes data in a uniform manner.
Decompress    is "unshrinking" a compressed file back to its original size.
Defragmentation program    reallocates file clusters and decreases fragmentation.
Disk compression utility    operates between the compressed files and the operating system.
Entity    is a distinct item in a database.
Field    is the smallest piece of meaningful data.
Field name    describes what's in a field.
File allocation table (FAT)    is a file that stores information about the physical location of every file on the computer's hard disk.
File backup system    copies files and stores them in a safe place.
File compression    can shrink a file or files into a smaller file.
File management system    coordinates how the computer organizes and keeps track of files.
Form    is a graphical interface that makes it easy to add or delete data.
Fragmentation    occurs when your computer places parts of files over many hard disk areas.
Hierarchical database    uses an inverted directory tree structure to organize data under different directories.
Hypertext database    lists each Web address as an object linked to its respective Web page.
Importing    is bringing files into a database.
Information    is organized data that have meaning and are useful to you in a given context.
Many-to-many relationship    relates many records in a record type to many others in a different record type.
Middleware    is a software application that works between the database and the Web browser.
Network database    uses a tree structure similar to the hierarchical database, but its children can have more than one parent.
Numeric validation    makes sure only numbers appear in a field.
Object-oriented database    uses objects to represent entities rather than fields in tables.
One-to-many relationship    relates one record of a record type to many others of a different type.
One-to-one marketing    allows businesses to provide you with goods and services they tailor to your buying habits.
One-to-one relationship    means that one record of a related type can be related only to one other different record in a record type.
Parent    is a directory similar to a folder in file systems.
Personal portal    integrates all of your information in one Web site.
Primary key    is the field in a table that is specific to only one record in the table.
Property    is the type of data in a field (for example, numeric, date, and currency).
Query    is specialized language for extracting data from a database.
Query-by-example (QBE)    tells the database what kind of information you want.
Query language    is a specialized language that uses English statements to pull data from a database.
Record    is a complete data entry.
Relational database    stores data in tables that have rows and columns.
Relationship    is an assocation between database entries.
Report    is a graphical display of your data.
Report generator    creates a written or Web report of information you request.
Sector    is a single area that can hold a certain number of bytes of data.
Structured query language (SQL)    is the default query language for most databases.
Table    is an organized collection of records.
Unzipping    is another word for decompressing a file.
Web catalog    uses a database to provide images, information and pricing on available items.
Web-enabled database access    modifies and presents information through a Web browser.
Zipping    is another word for compressing a file.




McGraw-Hill/Irwin