Organizations have different database need which change over time and which are unpredictable. Many organizations use Access database to handle many database issues, even though the database has its limitations. This paper explores Access database and its limitations; features, components of RDBMS including its pros and cons; and the difference between a database and a DBMS.
Access and Its Limitations in a Distributed Database Model
Microsoft Access database operates fully as an RDBMS with numerous excellent features. The database can meet the needs of many small to intermediate database need (Vine, 2012). Access database is effective for relational databases as it makes it possible to create vital database solutions quickly. Access lacks complex solutions like security, reliability, performance and scalability (Adikesavan, 2014). However, these features are unimportant for numerous solutions in relation to the capability of Access (Vine, 2012). For example, Access database solves many database issues that workgroups, small teams and individuals within a network face. Access database can handle numerous database difficulties in an organization compared to other expensive and sophisticated databases (Vine, 2012). People without IT knowledge can use Access database to handle different database issues cost-effectively.
Delegate your assignment to our experts and they will do the rest.
However, Access database has some limitations that hinder its application in a distributed database model. For example, Access is not suitable for web solutions because it was not designed to develop a website (Vine, 2012). Access database cannot be used in intranets and its core Jet Engine is less useful unless the number of simultaneous users is small (Vine, 2012). Access database only supports windows platforms and thus other platforms like Android, iPad, Mac are unsupported (Vine, 2012). There are also deployment issues as users must have an Access database and install Access to enjoy Access applications. Access database consumes a large space and the presence of different versions also causes challenges (Vine, 2012). Besides, Access database lacks the same security levels as mainframe database systems or SQL server (Adikesavan, 2014). Access lacks a robust data recovery and integrity compared to SQL Server (Adikesavan, 2014). Access is not scalable because it is restricted to 2 GB and if a database surpasses this, Access cannot solve the problem (Vine, 2012). Access is also limited in the number of simultaneous users.
Features and Components of an RDBMS
Features of RDBMS include the provision of data stored in tables, data is arranged in columns and rows, it supports virtual tables in which SQL queries can be used to retrieve data. RDBMS also offers data uniqueness because of the presence of the primary key. It also offers foreign key that maintains a single column in different tables to establish a relationship between them. It also offers referential integrity (Adikesavan, 2014).
RDBMS has various components that include Hardware to support it, data dictionary to store data information, Users of the system, SQL Engine to interpret and execute SQL queries, and interface drivers to define data insertion, deletion, or retrieval techniques (Adikesavan, 2014).
The presence of numerous features and components gives RDBMS different advantages. For example, it is fast and precise, offers high data security level, has a definite mechanism for individuals to work on it, it only allows data retrieval using SQL queries and it is durable, consistent and supports isolation (Adikesavan, 2014).
Nevertheless, an RDBMS has some limitations. For example, it is challenging to manage during certain times, working with it requires adequate training and skills, it only works when supported by the required hardware and software and it is expensive (Adikesavan, 2014).
Difference between a Database and a DBMS
A database is different from a Database management system as a database comprises a collection of interrelated data whereas a DBMS is a platform in which the database can be created and updated using SQL queries (Chopra, 2010). A DBMS depicts relationships between different tables in a database, functions with different databases and maintains relationships between different databases. A DBMS supports data analysis by allowing users to create reports, graphs or tables (Chopra, 2010).
In conclusion, databases and database systems constitute vital components of the database environment, even though they are different based on their functions and the operations that can be done on them.
References
Adikesavan, T. A. (2014). Management information systems . Place of publication not identified: Prentice-Hall Of India.
Chopra, R. (2010). Database management systems (DBMS): A practical approach : concepts, principles, case studies, experiments . New Delhi: S. Chand.
Vine, M. A. (2012). Microsoft Access VBA programming for the absolute beginner . Boston, MA: Course Technology, Cengage Learning.