Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
IBM originally created SQL for use between databases located on mainframe computers and the users on client machines. The users were connected to the mainframes via a local area network (LAN). SQL was adopted as the standard language of communication between databases and users. An intranet is basically a small Internet. The main difference is that an intranet is for a single organization's use, whereas the Internet is accessible to the general public. The user (client) interface in an intranet remains the same as that in a client/server environment. SQL requests are routed through the Web server and languages (such as HTML) before being directed to the database for evaluation. An intranet is primarily used for inner-corporate applications, documents, forms, Web pages, and email.
Database security is much more stable than security on the Internet. Always be sure to use the security features available to you through your database server.