Course Hero Logo

Lecture Notes 7.pdf - - Client/Server Database Computing...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 3 out of 8 pages.

1 - Client/Server Database Computing Client/Serverdatabase computing evolved in response to the drawbacks of the mainframe and PC/file server computing environments By combining the processing power of the mainframe and the flexibility and price of the PC, Client/Server database computing encompasses the best of both. Client/Server database computing can be defined as the logical partitioning of the user interface, database management, and business logic between the client computer, also called workstation, and server computer. The user interface can be text based or graphical based. The server computer controls database management, i.e., where data is stored, manipulated, and stored. In the Client/Server database environment, all database processing occurs on the server. Business logic can be located on the server, the client, or mixed between the two. This type of logic governs the processing of the application. Data Architecture Relational databases are mostly used by Client/Server application, where the server is a database server. Interaction between client and server is in the form of transactions in which client makes database request and receives a database response. In such a system, the server is responsible for maintaining the database. Thus, a complex database management system software module is required. Various types of applications that make use of the database are installed on client machine. The “glue” that ties client and server together is a software that enables the client to make request for access to the server’s database. This is an SQL (Structured Query Language). According to this architecture, all the application software used for data analysis, resides on the client side, while the server is concerned with managing the database. The importance of this architecture depends on the nature of application and where it is going to be implemented. And the main purpose is to provide on line access for record keeping. Suppose a database with millions of records resides and is maintained on the server and some user wants to fetch a query that involves a few records only. This can be achieved by a number of search criteria. An initial client query may yield a server response that satisfies one search criteria. The user then adds additional qualifiers and issues a new query. Returned records are once again filtered. Finally, client composes next request with additional qualifiers. The resulting search criteria yield desired match, and the record is returned to the client. Such Client/Server architecture is well-suited for such types of applications because: Searching and sorting of large databases are a massive job that require large disk space, high speed CPU along with high speed Input/Output architecture. In a single user workstation such a storage space and high power might not be necessary and also expensive.
2 Tremendous traffic burden would be placed on the network to move the millions

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 8 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags
Database management system, Client server

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture