Web Publishing Tools, Techniques and Methods
Organizations that need to present large volumes of data on their websites should consider managing their data in a data management system, rather than "hard coding" its data on static web pages.
For example, if an organization wants to list all the products and services that it sells, it would be preferable to store the inventory list in a database and dynamically generate a web page that requires that data at the time the page is requested. This is particularly important when that data is volatile (e.g. products for sale are frequently added or dropped; prices are changed).
When data is stored in a database, it can be dynamic filtered, sorted or summarized base on the specific requirement. If the data appears on multiple web pages, it needs to be updated in only one place.
To generate dynamic web pages, special web hosting services are required. They must either support a database management system (e.g. MySQL, SQL Server) or a flat file that contains encoded data (e.g. XML database).
The web hosting functionality must also support a server-side scripting language that can dynamically read the data from the database, filter rows, sort rows and dynamically integrate the result set into a web page.