DBMS:

1). It stands for the database management system.

2). It stores the data in the file format.

3). The normalization concepts are not present/available.

4). File system & xml are the examples.

5). It does not use the distributed databases.

6). It deals with the small organizations and the small data. It involves the single users.

7) It is the program for managing the databases on the computer networks and the system hard disks.

8) It does not support the integrity constants. The integrity constants are not imposed at the file level. The developer’s tasks are to impose the integrity constants at the application level.

9) ACID properties are implemented by the developers and the users.

10) It follows less than the seven rules of the Dr. E.F codd.

11) Low software and hardware requirements.

12) It came into the market around the year 1960.

13) Data redundancy is difficult to handle.

14) Security for the data are not available.Single level security.

RDBMS:

1). It stands for the relational database management system.

2). It stores the data in the tabular format.

3). The normalization concepts are present/available.

4). MySQL, oracle, PostgreSQL and sql server are the examples.

5). It uses the distributed databases.

6). It deals with the large organizations and the large data. It involves the multiple users.

7) It is the database systems which are used for maintaining the relationships among the tables.

8) It supports the integrity constraints. The integrity constants are imposed at the schema level.

9) ACID properties are defined in the integrity constants.

10) It follows at least the seven rules or eight rules of the Dr. E.F. codd.

11) High software and hardware requirements.

12). It came into the market around the year 1970.

13) In order to avoid the data redundancy, keys and indexes are used.

14) Multiple level securities. Securities for the data are available at the command level, logging level and the object level.

Save

Save

Save

Save

Related Posts

Vimeo Evolving after Facebook and YouTube.

2017-03-11 15:10:53
rahulkumar_1988

18

What is RDBMS?

2017-03-03 12:11:19
rahulkumar_1988

18

Dolibarr Erp and Zoho Crm.

2017-02-20 14:02:51
rahulkumar_1988

18

Difference between long and clob?

2017-02-20 11:02:02
rahulkumar_1988

18

Difference between blob and clob.

2017-02-16 15:06:12
rahulkumar_1988

18

How to create YouTube Channel and Become Billionaire?

2017-02-02 12:22:11
rahulkumar_1988

18

Features Of List and Set in the java.

2016-12-08 12:37:13
rahulkumar_1988

18

Entry and Exist Criteria.

2016-10-31 05:43:20
rahulkumar_1988

18

Difference between for and while loop in java.

2016-10-20 13:50:58
rahulkumar_1988

18

Leave a Reply

Your email address will not be published. Required fields are marked *