How easy or difficult life would have been in absence of Database Management System?
Answers
Answer:
RDBMS
An RDBMS model manages a database by allowing users to define and ascertain relationships between multiple tables within a repository. A standard language called Structured Query Language (SQL) is used to communicate with and manipulate the database [27,28]. SQL allows users to perform complex queries and analysis with relatively basic syntax [28]. A relational database has tables that consist of rows that represent records and columns that contain descriptive characteristics such as heart rate, age, or gender. Assigning a unique identifier to each row enables the table to be linked to rows from other tables in the database that share the same identifier. For example, if a researcher needed to combine a table that contained patient heights with a table that contained patient weights in order to calculate BMI, an SQL statement could be written to link the two tables together by matching the unique patient identifier from each table.
However, using an RDBMS to manage and store clinic databases has some limitations that must be considered. An RDBMS does not easily support documents such as medical imagery or free text [27,29]. In addition, clinical databases often contain a large number of fields that primarily remain unpopulated [27]. An RDBMS managing an SHR with an excessive number of blank fields may experience substandard performance and inefficiencies [27].