is a collection of data within defined parameters (a data model) that allows the data elements to be predictable.
Picture it as an electronic filing system: to keep organized, you would add tabbed folders perhaps by function, such as payroll.
Databases provide a standardized system for users to store, retrieve, and protect their data. They are important components of Web applications because they provide search functions and access to information resources beyond individual Web pages.
After completing this module, you will be able to:
- Describe the characteristics of hierarchical and relational databases
- Describe the characteristics of database-driven Web sites
- Describe the technologies used to connect databases to the Web
- Explain the process used to connect a database to the Web using ODBC
- Explain the purpose of SQL
The two most common types of databases you will likely encounter are hierarchical and relational databases.
Microsoft SQL-Server and Sybase define a database as a collection of data items that have a common owner, and multiple databases are typically managed by a single instance of the database management software. This can be quite confusing if you work with multiple products because, for example, a database as defined by Microsoft SQL Server and Sybase is exactly what Oracle Corporation calls a schema.
A database object is a named data structure that is stored in a database. The specific types of database objects supported in a database vary from vendor to vendor and from one database model to another. Database model refers to theway in which
a database organizes its data to pattern the real world. The most common database models are presented in “Prevalent Database Models,” later in this chapter. Afile is a collection of related records that are stored as a single unit by an operating
system. Given the unfortunately similar definitions of files and databases, how can we make a distinction? A number of Unix operating system vendors call their password file a database
, yet database expertswill quickly point out that, in fact, it
is not. The answer lies in an understanding of certain characteristics or properties that databases possess that ordinary files do not, including the following:
- Management by a Database Management System (DBMS)
- Layers of data abstraction
- Physical data independence
- Logical data independence