Automatic SQL Tuning Sets (ASTS) in Oracle 19c and 20c

• 
• 

PrevNext

A well performing SQL statement starts all of sudden to misbehave? Fixing such queries is very much embedded into Oracle Autonomous’ strategy and here is how Automatic SQL Tuning Sets help. What is the Automatic SQL Tuning Set? – Nigel Bayliss explains it all in a short informative...

Continue reading

Difference between Relational database and NoSQL

1. Relational Database: RDBMS stands for Relational Database Management Systems. It is most popular database. In it, data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily accessed because data is store in...

Continue reading

Difference between Database and DBMS

A collection of related pieces of data, whose purpose is to solve the data management needs of an institution is called a Database. Database Management Systems (DBMS), on the other hand, are very complex software which save the data on the secondary storage devices and which are used...

Continue reading

Introduction of 3-Tier Architecture in DBMS

• 
• 

PrevNext

DBMS 3-tier Architecture DBMS 3-tier architecture divides the complete system into three inter-related but independent modules as shown below: 1. Physical Level: At the physical level, the information about the location of database objects in the data store is kept. Various users of DBMS are unaware of the...

Continue reading

DBMS Architecture 2-Level, 3-Level

• 
• 

PrevNext

Two tier architecture: Two tier architecture is similar to a basic client-server model. The application at the client end directly communicates with the database at the server side. API’s like ODBC,JDBC are used for this interaction. The server side is responsible for providing query processing and transaction management...

Continue reading

Difference between Database System and Data Warehouse

Database System: Database System is used in traditional way of storing and retrieving data. The major task of database system is to perform query processing. These systems are generally referred as online transaction processing system. These systems are used day to day operations of ans organization. Data Warehouse:...

Continue reading

Disadvantages of DBMS

• 
• 

PrevNext

There are many advantages and disadvantages of DBMS (Database Management System). Disadvantages of DBMS are explained as following below. 1. Increased Cost: These are different types of costs: 1.1 Cost of Hardware and Software – This is the first disadvantage of database management system. This is because for...

Continue reading

Advantages of DBMS over File system

• 
• 

PrevNext

What is File System? A File Management system is a DBMS that allows acces to single files or tables at a time. In a File System, data is directly stored in set of files. It contains flat files that have no relation to other files (when only one...

Continue reading

ACID Properties in DBMS

• 
• 
• 

PrevNext

A transaction is a single logical unit of work which accesses and possibly modifies the contents of a database. Transactions access data using read and write operations. In order to maintain consistency in a database, before and after the transaction, certain properties are followed. These are called ACID...

Continue reading

Difference between File System and DBMS

• 
• 

PrevNext

Prerequisite – DBMS over File system A File Management system is a DBMS that allows acces to single files or tables at a time. In a File System, data is directly stored in set of files. It contains flat files that have no relation to other files (when...

Continue reading

Differences between Operational Database Systems and Data Warehouse

• 
• 

PrevNext

The Operational Database is the source of data for the information distribution center. It incorporates point by point data utilized to run the day to day operations of the trade. The information as often as possible changes as upgrades are made and reflect the current esteem of the...

Continue reading

Difference between Single User and Multi User Database Systems

A criterion for classifying a database system is according to the number of users who can use the system concurrently. It can be divided into single-user and multi-user database systems. 1. Single User Database Systems : In these DBMS, at one time, only a single user can access...

Continue reading

A Fully Refreshed Oracle Audit Vault and Database Firewall for Auditing and Monitoring

Organizations today have hundreds or even thousands of databases, applications, and operating systems where user and administrator activities need to be audited and monitored for security and compliance reasons.  That oversight requires continuous collection and analysis of huge amounts of activity data in order to run reports and...

Continue reading

Difference between CouchDB and Relational Database

1. CouchDB: Apache CouchDB is an open-source document-oriented NoSQL database that uses multiple formats and protocols to store, transfer, and process its data, it uses JSON to store data, JavaScript as its query language using MapReduce, and HTTP for an API. It was developed by Apache Software Foundation...

Continue reading