|
A database is a collection of data that is organized so that
its contents can easily be accessed, managed, and updated.
The most prevalent type of database is the relational database,
a tabular database in which data is defined so that it can
be reorganized and accessed in a number of different ways.
Structured Query Language is a standard language for making
interactive queries (searches) from and for updating a database.
Database systems incorporate the following common components.
- Table: The purpose of the database is to store information;
the place where data is stored is called a table. A table
consists of row and columns. A row, also called a record,
contains information about each item you are tracking in
the table. A column, also known as a field, stores each
characteristic you are tracking in the table.
- Form: Forms offer a way to access information in database
tables. Forms often display the same fields as tables, but
they display only one record at a time.
- Queries [Searches]: Queries are quick, interactive ways
to retrieve information from the database.
- Reports: To retrieve information about the database,
you use a report. A report is a procedure that extracts
information in the database, formats the information with
background text, and sends it to an output device (usually
in the printer).
There are many ways of making a Web page enter and retrieve/display
data from a database. You can use several scripting languages
such as Active
Server Pages (ASP) or Cold
Fusion to accomplish this. They work very well with HTML
code which makes it easier to integrate them into existing Web
pages.
Granite Web Design strongly recommends Microsoft SQL (Sequel
Server) as a choice of database. SQL is recognized as the high-end
database solution for most Web developers. Since most Web hosts
offer very affordable rates for SQL accounts, you can take advantage
of all that SQL has to offer without great expense. SQL is designed
to be secure, stable and robust. It can handle high traffic
easily and has built in fault tolerance tools for protection
against database corruption. Also, SQL has advanced tools such
as stored procedures, scheduling and automated backups. These
ensure more productivity and security as database solution.
SQL is a must for a mission critical database component for
an Internet based enterprise. |
Domain
Registration 
