Showing Page:
Database Management System
Student’s name
Institution Affiliation
Showing Page:
Relational database management system
Using a relational database, you may store and get data that is connected to one another.
This kind of database is used to store and retrieve data. It's never been easier to search and get
certain database values than it is now. The term "relational" alludes to the idea that the values in
each table are related to one another. Tables may also be linked to one another. The relational
nature of the database allows for querying across several tables (Setyawati et al., 2018). Since the
introduction of the relational model, relational databases have gained in popularity as a
consequence of its simplicity and ease of use. In a relational database, keys are unique identifiers
that are assigned to each row of data in a table of records. It is simple to see how data points are
related in a table since each column specifies an attribute, and each record frequently has a value
for that attribute, which is defined by each column in the table. Unlike other types of databases,
relational databases can handle massive volumes of data and complicated queries. In today's
databases, it is typical to have several tables. A large number of tables, together referred to as
"relations," are often used in order to hold data. These tables are made up of rows and columns,
which are referred to as records or columns, depending on the context (fields). Just a few of the
features accessible in this application include the ability to add, alter, and search for data. An
RDBMS (relational database management system) has the capability of displaying information.
Examples include showing data in tables, much like spreadsheets, allowing for the viewing and
even modification of individual table entries, as well as displaying data in a variety of other formats
(Setyawati et al., 2018). Forms may be created in some RDMBS applications to make data entry
and updating more convenient for users.
What is SQL
SQL is the most frequently used computer language in the world for collecting and
organizing data from relational databases. Databases are divided into two types: those that have
rows and columns and those that do not contain rows and columns. SQL is the computer
programming language that is used to create relational databases (Deari et al., 2018). This tool
streamlines the process of pulling specific data from databases in order to do research. Although
data extraction from a company's database is conducted in a different platform such as Python or
R, SQL is necessary for data extraction from the company's database.
Showing Page:
Pro of SQL
The speed with which SQL databases operate is one of the reasons they are so popular.
When it comes to obtaining large amounts of data from a database, SQL queries are a well-
established fact of existence. Because of its data processing capabilities, SQL is the most often
used programming language in a relational database management system. SQL databases, on the
other hand, do not need any programming skills. It is significantly more straightforward to make
use of a database like this than it is to write a huge amount of code. Another benefit of SQL is the
high degree of security that it provides for its users. Using a restriction on the amount of views
they may see, users can limit their access to a subset of data, but this prevents them from examining
the whole database (Deari et al., 2018). User interaction with SQL is accomplished using a set of
straightforward commands that are useful for a variety of applications. Because of their simplicity,
the instructions can be followed by those who are not programmers.
Cons of SQL
Due to its poor user interface, basic activities seem to be impossible to do! Databases are
tough to work with because of their complexity. SQL has also been reprimanded for its tense
relationship with data manipulation languages, which has been criticized (DML). They can't bear
the sight of one another. Several downsides of SQL databases include a lack of or unequal platform
compatibility, insufficient data management, and an excessive level of complexity in the language
and semantics.
Pro of SQLite
SQLite is a well-known on-disk file format that has been used effectively for many years.
SQLite has a lot of disadvantages, the most notable of which are as follows: The impact on the
environment is negligible: Because of its minimal size, the SQLite library is straightforward to
use. It is possible that this program will use less than 600KiB of storage space depending on the
operating system on which it is installed. SQLite is also self-contained, which means that it does
not need the installation of any additional requirements in order to perform properly. There are
several advantages to using a "zero-configuration" database since it may be used right away and
without any further setup (Yu, 2020). Given that SQLite is not a server process and does not have
any configuration files to deal with, there is no need to stop, start, or restart SQLite at any point.
Showing Page:
The procedure of installing and integrating SQLite is greatly simplified as a result of these features.
Furthermore, the SQLite database engine is free of advertisements: SQLite is a database
management system that stores data in a single file, as opposed to other database management
systems that store data in several files. Transferring this file may be accomplished via the use of
file transfer protocols or removable storage media. It may be placed at any point in the directory's
hierarchical structure.
Cons of SQLite
Although it offers a lot of benefits, SQLite has a number of drawbacks, including the
following: There is a restriction to the number of concurrent users: One or more processes may
access and query SQLite databases at the same time, but only one process at a time may update a
SQLite database at the same time. When compared to client/server relational database management
systems such as MySQL or PostgreSQL, SQLite can handle far more concurrent queries than the
vast majority of other embedded database management systems. SQLite does not have a user
management system, but database systems often have. Instead, they provide user assistance or
regulated connections with access privileges to the database and tables that have been specified.
The fact that SQLite reads and writes to a regular disk file means that the usual access permissions
of the operating system apply. SQLite, on the other hand, makes it difficult to have a large number
of users who have varying levels of access to the database.
SQLite and Microsoft Access
Microsoft Access is a database management system that can be used by both home users
and small company owners to manage their databases (DBMS). Because of its limitations,
Microsoft Access is unable to handle large numbers of database requests. Data processing
solutions for medium- to large-sized businesses such as Microsoft SQL Server are an excellent fit
for this platform. SQLite is a database engine that is widely used. It is also free.
Showing Page:
Setyawati, E., Wijoyo, H., & Soeharmoko, N. (2020). Relational Database Management System
Deari, R., Zenuni, X., Ajdari, J., Ismaili, F., & Raufi, B. (2018, September). Analysis and
Comparison of Document-Based Databases With SQL Relational Databases: MongoDB
vs MySQL. In Proceedings of the International Conference on Information Technologies
(InfoTech 2018) (pp. 1-10).
Yu, Y. (2020). Embedded Internet of Things Applications of SQLite Based on WinCE Mobile

Unformatted Attachment Preview

Name: Description: ...
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.