Write 400–600 words that respond to the following questions with your thoughts,

Question

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas:

Of the various relational database platforms available, the ones based on client/server architecture seem to be most prevalent for a wide range of systems. An SQL Server is an example of this type of platform. Another common type is the desktop or file-based programs, such as Access.

Research and compare the 2 platforms.

Consider specific metrics (e.g. costs, robustness, size, and throughput) in your comparison, and investigate advantages and disadvantages of both.

Offer specific examples where each type might be an appropriate choice for a solution.

Explanation / Answer

let starat with MS Access, it is a Rapid Application Development (RAD) which rapidly builds forms and bound to relational data. Mainly it is based on a file-based database engine (Jet/ACE).on the other hand SQL Server is based on the client/server model. So the SQL Server need services which provide access to the data store which is bit complicate deployment in some cases. Hence the basically the similarity between these two are both relational database management systems of the Microsoft.

Differences:

Cost: MS Access having the free distributable runtime (2007 or later) uses Jet SQL

While SQL Server also work as free with the Transact SQL. But if SQL Server, if the need isn't too great, then it provides a good step up from Access when the file reaches to repair and compact.

Robustness:

SQL Server is a more robust and fully featured database management system as compared to access. An access implementation may be run ten simultaneous sessions while a SQL Server implementation can manage over thousands of simultaneous clients. And for internet based applications that should be needed to scale and provided availability, the pure robustness makes of SQL server the first choice.

Size:

Microsoft Access store up to 2GB per database and use one only core to process. On the other hand SQL Server supports up to 10GB per database and lesser of 1 Socket or 4 cores with max one physical CPU.

Throughput:

When there is no network and no server and single user then Access become faster than sql server. SQL server provided you large extra layer that involves transactions and a socket based (network) connection.SQL server or Access does not change the speed of file reading from the disk drive. Access has often 50% faster when no network is involved.

Advantages:

Access-

Sql server -

Disadvantages:

Access-

Below having some points that clearly reflects the advantages of SQL over Access.

Scale:

  SQL Server can hold more data and will handle far more parallel clients as compared to access.

Security:

  For multi-user database, SQL Server provided the higher level of security.

Stability and Reliability:

Access is a file based engine where each user connects directly to the file while SQL Server is a service based database engine that is designed for multi-user access.

Data Integrity

Data integrity in SQL Server is better by the use of 'triggers' which can be applied on record for added, updated or deleted.

Important point:

SQL Server is a bigger and more complex than is Access and not suitable for a company having IT support.

It also costs more for implement and development than Access.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.