• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Linking Access Front-Ends to... > Evaluating the Benefits of Migrating...

Evaluating the Benefits of Migrating to Client/Server Databases

Modern client/server databases, typified by Microsoft SQL Server 2000, provide a much more reliable and scalable data storage environment than shared-file databases, such as Jet. The vast majority of production databases used by all but very small organizations follow the client/server model. Oracle currently claims the lion’s share of the client/server relational database management system (RDBMS) business, but IBM, Microsoft, and Sybase each own significant market share.

Client/server technology offloads much of the data-processing workload to the server. When an RDBMS client instructs the server to execute an SQL SELECT * statement having WHERE clause criteria, only those rows that meet the criteria pass over the network to the client. If you replace * with an explicit field list, the RDBMS only populates query columns that correspond to the specified fields. Minimizing the amount of data transmitted to the client saves costly network bandwidth and improves performance, especially for remote users who access the database over low-speed connections.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint