misterhonkers.com

A new feature of the select statement allows a sub query to be used in place of a table in a from clause like get rich in wow. In this kind of architecture, database and client application remains on one machine i.e. there is no client-server technology, there is no centralization of database, and basically it is a stand alone system. In this kind of architecture, database and client application is on two different machines i.e. Database on one machine and the application on another machine. N- Tier Architecture: - In this kind of architecture, there is a middle-ware in between the client and database. Middle ware checks the validity of the client i.e. weather the client can access the database or not. Hence there is security in it as well as middle-ware allows multiple clients access.