Question

In: Statistics and Probability

In your own words please describe What is RDBMS? Also provide what are possible strength and...

In your own words please describe What is RDBMS?

Also provide what are possible strength and weakness points? Is it still used in today world and if yes then for what applications?

Solutions

Expert Solution

RDBMS stands for relational database management system. RDBMS is a software system which is used to store only data which need to be stored in the form of tables. Such data is also called structured data. We will delve onto it in some time but before that we'll try to explore about the origin of database management systems (DBMS) for storage.

The DBMS was introduced during 1960's to store any data. It also offers manipulation of the data like insertion, deletion, and updating of the data and also performs the functions like defining, creating, revising and controlling the database. It is specially designed to create and maintain data and enable the individual business application to extract the desired data for reporting and analytical purposes.

Relational Database Management System (RDBMS) was an advanced version of a DBMS and it came into existence during 1970's thus providing more efficiency than DBMS.

Strengths:

1. RDBMS uses a tabular structure where the headers are the column names, and the rows contain corresponding values thus providing ease of reporting.

2. It support many users at a time.

3. RDBMS can be normalised for better reporting purposes.

4. RDBMS has multiple levels of security. Log files are created at OS, Command, and object level.

Weaknesses:

1. The RDBMS don't fit with every domain, i.e., unstructured data.

2. Large hardware and software maintenance is required.

3. Weak Distributed Availability due to Poor Horizontal Scalability.

4. The drawback of decreased performance as if the schema is normalized we have to use multiple joins to collect together the data you need. Joins are expensive. That’s why it makes sense to denormalize the schema in order to decrease the number of necessary joins and in turn improve the performance. However, this leads to redundancy and the danger of inconsistency.

RDBMS is still used in today's world with a few examples as MySQL, Oracle, SQL Server, etc. They help us in providing visual representation of data thus making it easier for reporting.

However, with time since a lot of data is unstructured (over 90%) in the form of audio, images, text and also with the advent of cloud storage by Google Cloud Platform, Amazon Web Services, Microsoft Azure, a lot of data is in the later format and is required for analysis.


Related Solutions

In your own words, please explain the Conflict Perspective. Provide an example. In your own words,...
In your own words, please explain the Conflict Perspective. Provide an example. In your own words, please explain the Interactionist Perspective. Provide an example.
List and describe the challenges in environmental regulation. Please provide with your own words (150-300 words)
List and describe the challenges in environmental regulation. Please provide with your own words (150-300 words)
* Please use your own words. * Please provide sources for your answers. 1. Provide an...
* Please use your own words. * Please provide sources for your answers. 1. Provide an example of any two leading companies from the same industry which are competing directly for marketshare. Give a short profile (300-500 words) for each (provide references for your answers). 2. If you are the manager of one of these companies, what pricing policy do you adopt to be in the first position? Why? (100-200 words) 3. When the whole sector of the market is...
In your own words, being as specific as possible, describe what occurs inside an atom to...
In your own words, being as specific as possible, describe what occurs inside an atom to create the emission spectrum for any given element In your own words, being as specific as possible, describe how and explain why the emission spectra for Hydrogen and Nitrogen gas differ – beyond the obvious differences in color! In your own words, being as specific as possible, describe how the combination of oxygen and hydrogen gases affects the hydrogen chemical fingerprint within the water...
In your own words, please describe the difference between demand and quantity demanded. Also, can you...
In your own words, please describe the difference between demand and quantity demanded. Also, can you please focus on one product and give three current scenarios in the market for that product that pertain to a change in demand for the product.
Describe and discuss in your own words adolescent sexuality. Use own words please
Describe and discuss in your own words adolescent sexuality. Use own words please
In your own words, please provide a brief industry overview for PetSmart. What is the industry...
In your own words, please provide a brief industry overview for PetSmart. What is the industry trends for PetSmart?
Anwser in your own words Describe in your own words, what should be included in health...
Anwser in your own words Describe in your own words, what should be included in health record documentation best practices. Provide at least one example of how HIM's ensure these best practices are met.
1- What is the concept of sustainable income? Please describe it in your own words. Can...
1- What is the concept of sustainable income? Please describe it in your own words. Can you give an example of what this number may look like by using the income statement of a real-life company? 2-There are different tools for analyzing the financial statements of a company, such as horizontal analysis, vertical analysis, ratios for measuring financial health and profitability, and so forth. Before we begin using these tools, however, it is important to know the purpose of each...
Index In your own words please describe what an index is and offer potential positive and...
Index In your own words please describe what an index is and offer potential positive and negative aspects of using an index.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT