Difference between Database Administrator (DBA) and Database Engineer

• 
• 

PrevNext

1. Database Administrator (DBA) :A database administrator is responsible for management of a database (DB). His/her duties involve administration, performance tuning, optimization, backup and recovery of a database. The DBA is more of a management profile. The DBA also enhances the Logical Design of the database. He/she may...

Continue reading

From DBA to Data Scientist

• 
• 

PrevNext

Charlie Berger wants DBAs and database developers to click a link in their autonomous database service console that can open a new world in their careers. It’s there alongside the common data management options for downloading clients or setting passwords, and it’s called Oracle ML Users. “You click...

Continue reading

Difference between Oracle and SQL Server

• 
• 

PrevNext

1. Oracle DatabaseOracle Database (commonly referred to as Oracle DBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle...

Continue reading

Why recovery is needed in DBMS

• 
• 

PrevNext

Basically, whenever a transaction is submitted to a DBMS for execution, the operating system is responsible for making sure or to be confirmed that all the operation which need to be in performed in the transaction have completed successfully and their effect is either recorded in the database...

Continue reading

Metadata in DBMS and it’s types

• 
• 

PrevNext

Metadata is simply defined as data about data. It means it is a description and context of the data. It helps to organize, find and understand data. Let me explain to you by giving a real-world example of metadata:Every time you take a photo with today’s cameras a...

Continue reading

How to use DBSAT for Oracle 20c and the Autonomous Database

• 
• 
• 
• 

PrevNext

“There should be no on/off button for security, it should always be on, everything should always be encrypted – there should be no option to turn security off” – Larry EllisonIf you would like to check how secure your Oracle database it, just run the free tool called...

Continue reading

Types of Spatial Queries in DBMS

• 
• 

PrevNext

Any type of spatial data that is data related to location and which represents objects defined in a geometric space, is stored and maintained by Spatial Databases. These are used to handle these Spatial Databases. Spatial database mainly contain representation of simple geometric objects such as 3D objects,...

Continue reading

Oracle Database Appliance X8 More Powerful, Higher Capacity, Improved Connectivity

• 
• 

PrevNext

ODA has experienced broad adoption around the world in all industries across a wide range of customers, from SMBs to Fortune 100 corporations. As a result, we continue to invest in Oracle Database Appliance by offering the latest generation hardware along with on-going software enhancements for all supported...

Continue reading

Simplified Data Guard Integration with Oracle Database Appliance

• 
• 

PrevNext

The ODA 19.8 Release integrates Oracle Data Guard configuration, simplifying the deployment of Data Guard between Oracle Database Appliance systems down to a single command!Oracle Data Guard is an application that ensures high availability, data protection, and disaster recovery for enterprise data. It supports one or more standby...

Continue reading

Types of OLAP Systems in DBMS

• 
• 

PrevNext

There are 3 main types of OLAP servers are as following:1. Relational OLAP (ROLAP) – Star Schema based –The ROLAP is based on the premise that data need not to be stored multidimensionally in order to viewed multidimensionally, and that it is possible to exploit the well-proven relational...

Continue reading

New report ranks Oracle as overall leader in enterprise cloud databases

• 
• 
• 
• 

PrevNext

A report published by KuppingerCole Analysts AG, Leadership Compass: Enterprise Databases in the Cloud, ranks Oracle Autonomous Database as the overall leader versus Amazon and Microsoft with leadership positions in cloud database products and technology, and cloud database innovation. In ranking Oracle as the overall leader, analysts at...

Continue reading

Use of DBMS in System Software

• 
• 
• 
• 

PrevNext

Here we are going to discuss about how a user interacts with a DBMS, and how the DBMS is related to system software. Using a general-purpose programming language, user can write a source program in the normal way. However, instead of writing I/O statements of the form provided...

Continue reading

Difference between RDBMS and DBMS

Database Management System (DBMS) is a software that is used to define, create and maintain a database and provides controlled access to the data.Relational Database Management System (RDBMS) is an advanced version of a DBMS. DBMS RDBMS  DBMS stores data as file. RDBMS stores data in tabular form....

Continue reading