SEOMining SEOMining

Creating Databases  «Prev  Next»
Lesson 6

Web Application Conclusion

This module covered the Importance of databases to Web applications. Databases provide search functions and access to information resources. By now, you should be able to describe:
  1. The characteristics of hierarchical and relational databases
  2. The characteristics of database-driven Web sites
  3. The technologies and protocols used to connect databases to the Web
  4. How to connect a database to the Web using OBDC
  5. The purpose of the SQL database language


In this module, you were introduced to the following terms:
  1. Database: A collection of data within defined parameters (a data model) that makes the data elements predictable.
  2. Hierarchical database: Database based on top-down relationships among data elements. Hierarchical databases are used for core business applications such as payroll and accounts receivable.
  3. Relational database: Database based on the metaphor of a basic table with rows and columns. Data elements stored in these tables share a relationship defined by a common element called a key.
  4. Middleware: Software that functions as a translator to enable one application to communicate with another that either runs on a different platform or comes from a different vendor.
  5. ODBC: Open Database Connectivity (ODBC) is a database access protocol based on the Windows NT platform.
  6. SQL: Structured Query Language (SQL) is a standardized database language that lets you access data in relational database management systems by describing the data you want to see.
In the following module, you will learn about the different media available on Web sites and the formats associated with each.

Database Review - Quiz

Click the Quiz link below to test your understanding of databases.
Database Review - Quiz

Communication Between webSites Databases - Exercise

Click the Exercise link below to test your knowledge of the various elements that connect a user to database information via a website.
Communication Between Web Sites Databases - Exercise