The Computer Revolution/Databases/basic structure

From Wikibooks, open books for an open world
< The Computer Revolution
Jump to navigation Jump to search

Data Base Storage Hierarchy[edit | edit source]

Data Bases
A data base is more than a collection of information. It is logical rather than random organization of info designed for a specific purpose. Data bases can be any size or degree of detail, they can be stored manually or by computer. As you will see below they are hierarchical in structure.
Bits & Characters
A bit is the smallest unit of data a computer can store. These representations are made with 0 meaning off and 1 meaning on. Bit is short for "binary digit". When bits are combined into groups of 8 they are called a byte or character. A character can be a letter (A,B,C) number (1,2,3)or special character (+,=,$.) For example the letter G in bits is 01000111. A computer's memory is stored in multiples of bytes like kilobytes, megabytes, gigabytes and so on. Bits and bytes are not what the user sees, they are what "the hardware sees" and uses to store info.
Fields make the binary digits meaningful to users. Examples of a fields are names, addresses, or social security number. A field is comprised of one or more characters. They are useful in storing different types of data like, dates, text only, numbers only, web links only, pictures, sound, or video.
A record is made up of several fields. Its purpose is to store multiple pieces of information about a single entity.
Stephen Harper 24 Susex Drive; Ottawa Ontario, is an example of a record.
At the top of the data base hierarchy is the File. As you may have guessed a File is a collection of related records. A company may keep various types of files which record information about employees. A file named "Past Employees" may contain information such as date hired, date released, reason for release, salary at time of release and so on. Examples of other types of files are: payroll, retirement benefits, and sales.
There are two types of files known as Program and Data. A program file contains software and instructs the computer to act on information in the data files. Two of the most important types of program files are source and executable. Data files contain several types of data like text, graphics, audio, and video. But unlike program files they do not instruct the computer to do anything. They are used to store data only.

Database Query Queries are the primary mechanism for retrieving information from a database. They consist of questions presented to the database in a predefined format. A database query can be either a select query or an action query. A select query is simply a data retrieval query. An action query can ask for additional operations with the data, such as insertion, updating, or deletion. Languages used to interact with databases are called query languages. The most popular query language standard is Structured Query Language (SQL).

Database Report

"Report" is used to create a formal and attractive output for the data or when information is to be presented in a professional way. It can be designed to include all the records which are located in the assigned table or from the results that are created from the query. Hence, just as queries; reports can generate or even can pull all the information from more than one table at a time if they are in a way related to each other and even they can saved as objects in the database file in Microsoft Access. Reports are often created using Microsoft Access Report Wizard and they can be even formatted, designed, or even modifies as needed using appropriate tools in Design view ribbon. ⇑===== Database management system(DBMS) ===== A DBMS is a software program that is use to create database application. Database applications are the way you can use the data stored in a database. A rational database is the most common type computerized database. They help make the data useful to use instead having a ton of data.A database has a faster response time, lower storage requirements, and is also easier to secure. Data accuracy is increased because this is cutting down the possibility of any errors that can be made or any inconsistencies when multiple tables are uploaded together. The main disadvantage that a database may have is the vulnerability it is exposed to. The database is exposed to records that are accidentally deleted or problems if the computer system failed. This is the main reason that extra precautions need to be taken while using databases, such as back up procedures and extra security to your computer system.

Understanding Computers Today and Tomorrow 13th Edition