Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which are initial RDBMS, Hierarchical & N/w database ?

April 26, 2017database Hierarchical initial RDBMS

1

Posted

Which are initial RDBMS, Hierarchical & N/w database ?

2 Answers

0

Posted

RDBMS – R system Hierarchical – IMS N/W – DBTG 59.Difference between Oracle 6 and Oracle 7 ORACLE 7 ORACLE 6 Cost based optimizer • Rule based optimizer Shared SQL Area • SQL area allocated for each user Multi Threaded Server • Single Threaded Server Hash Clusters • Only B-Tree indexing Roll back Size Adjustment • No provision Truncate command • No provision Database Integrity Constraints • Provision at Application Level Stored procedures, functions packages & triggers • No provision Resource profile limit. It prevents user from running away with system resources • No provision Distributed Database • Distributed Query Table replication & snapshots• No provision Client/Server Tech. • No provision 60.

0

Posted

RDBMS – R system Hierarchical – IMS N/W – DBTG 59.Difference between Oracle 6 and Oracle 7 ORACLE 7 ORACLE 6 Cost based optimizer Rule based optimizer Shared SQL Area SQL area allocated for each user Multi Threaded Server Single Threaded Server Hash Clusters Only B-Tree indexing Roll back Size Adjustment No provision Truncate command No provision Database Integrity Constraints Provision at Application Level Stored procedures, functions packages & triggers No provision Resource profile limit. It prevents user from running away with system resources No provision Distributed Database Distributed Query Table replication & snapshots No provision Client/Server Tech. No provision 60.