Lesson 2 | Databases |
Objective | List the functions of databases. |
Database Functions
To understand the role of a database, you must understand the difference between data and information.
The best way to understand the difference is through the simple example of the phone book.
A phone book contains data. When you look up a needed phone number, that particular portion of the data becomes information.
It is that simple. Facts without meaning are data. Facts about something that you want become information. Information is the portion of data that is useful to you.
Store, search, and report
A database is an organized set of data elements that conform to a data model.
The model's purpose is to structure the storage of data to facilitate rapid and flexible views based on any number of user-specified conditions or criteria. In other words, a database is both the storage of the data and also the software
"engine" that churns that data into informational reports when a person queries the system.
The following are examples of how databases are used in Web applications:
- Searching for information about the site, company, or products
- Storage of information about particular products
- Display of a winter catalog's clothes, or just size 9 clothes
- Inventory records for June
- Personalization data, for example, everyone in Department X born in July
- Automatic site updates or product updates based on some criteria
- Transaction history information for one's particular VISA card
- Supplier information, vendor information, or product information based on name, date, or item number
The value of data
History identifies our world's evolution by titling its eras in ages:
- the Stone Age,
- Bronze Age,
- Steam Age,
- Nuclear Age,
- Jet Age, and
- the Information Age.
These titles depict the most vital element of that time around which all human activity has revolved.
Our current age, the Information Age, is so named because for the first time on the planet, information has become more valuable than all other commodities (land, wheat, steel, or gold).
In highly developed countries, less than 15 percent of all workers produce tangible goods (that is, they manufacture something) and over 50 percent spend their day simply handling information. Information is more precious, then, than manufactured goods.
Working the systems
The computer, and specifically the database, has enabled information handlers to pass off the processing and storage of data to these automated systems.
The same workers are now able to request information from these systems and make critical and profitable decisions as a result. Such workers are called Knowledge Workers because they know how to
utilize those systems to produce information necessary for improved decisions.
Higher-quality decisions result in cost savings, which means greater efficiency, resulting in increased wealth for their organizations.
These decisions are all dependent on access to information which, in the Information Age, is almost always accessed through the database.
The latest twist to the evolution of information access is the Internet, with its promise to broaden that access through the use of effectively designed Web pages.
Many shapes and sizes
Databases are an integral part of any Web site that goes beyond a rudimentary informational type of site. Clearly,
there is a wide array of functionality that can be added to Web sites through the use of databases. You will be
learning more about the types of models that databases are constructed on, as well as looking further into ways that
robust database applications are leveraged for Web functionality.
In the next lesson, your task is to learn the major types of databases.