Database systems were conceived to store information comfortably and quickly and to reply to requests of high complexity. If these features are combined with the Internet’s communication potential, it is possible to make any research in WWW accessible databases, however complex it may be. The combination of Internet and databases offers a large scope of application to website providers. They can offer websites whose information are used only at the moment of a database’s access. Websites are no longer static but dynamic and user-specific.
Investigations into the acceptance of websites have shown that static and well designed websites have a high click rate but that visitors rarely come back again. Dynamic websites which allow the visitor to make an interactive selection of requested information proved to be more successful.
Access to database systems is realized with the aid of script languages. Webland AG supports the following script languages:
MSSQL is a powerful client-server database system. MSSQL database systems are not file-based but are running on special and powerful database servers. Access to a MS SQL database can be made both with Access (from version 2003 onwards) and with the MSSQL Server Management Studio (most recent version). The Express version (Microsoft SQL Server Management Studio Express) can be downloaded for free at www.microsoft.com. Advantages of MS SQL:
Scope of application: MSSQL is an optimal solution for powerful and dynamic websites at mid and high level, wherever data security is of importance, high data volumes arise and performance is an issue.
MySQL is a client-server database system primarly used in conjunction with the script languages Perl and PHP. Access to a MySQL database is made, for example, with "SQLyog MySQL GUI" (a web-based graphic desktop for easy treatment of MySQL databases). You can download "SQLyog MySQL GUI" for free in our download area. Advantages of MySQL:
Scope of application: MySQL is an optimal solution for powerful and dynamic websites in conjunction with the script languages PHP and Perl.
MS Access is not designed for use in 24x7 server applications. This means that entirely database-based websites should definitely be operated with a MSSQL (or MySQL) database.
MS Access is a member of Microsoft Office-Suite and is therefore widely spread. Access is a file-based client database system.
Scope of application: MS Access is the solution for small private websites for operating a guestbook or similar applications.