top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the advantages of Oracle?

+1 vote
What are the advantages of Oracle?
posted Jan 22, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
Best answer

Portability: Oracle is ported to more platforms than any of its competitors, running on more than 100 hardware platforms and 20 networking protocols.

Market Presence: Oracle is by far the largest RDBMS vendor and spends more on R & D than most of its competitors earn in total revenue. This market clout means that you are unlikely to be left in the lurch by Oracle and there are always lots of third party interfaces available.

Backup and Recovery: Oracle provides industrial strength support for on-line backup and recovery and good software fault tolerence to disk failure. You can also do point-in-time recovery.

Performance: Speed of a 'tuned' Oracle Database and application is quite good, even with large databases. Oracle can manage > 100GB databases.

Multiple database support: Oracle has a superior ability to manage multiple databases within the same transaction using a two-phase commit protocol.

answer Jan 23, 2015 by Arun Gowda
0 votes

The Oracle Database Management System (ODBMS) provides you with the ability to store data that you can access quickly, easily and securely. The ODBMS also provides management tools that make it easier to work with data, and many programming languages such as Java, .NET and PHP provide drivers that make building data-centric applications much easier.

Data Security

When you store personal or corporate data, you want the information to be secure. The Oracle Database Management System facilitates secure data storage by maintaining access control lists that store encrypted information about the privileges of each user. You can also encrypt transmissions to and from the "Oracle Data Vault." The auditing features permit you to review data elements and alerts you to data fields that might need to be masked or re-classified.

Efficient Application Development

Many programming languages such as Java and Microsoft .NET contain classes for working with data inside of an Oracle database. This allows you to quickly and easily write applications to access, retrieve and update the data rather than having to write complex programs to access other data formats. The Oracle database also provides a wide array of functions, stored procedures and programming constructs utilizing an extension of SQL called "PL/SQL." The ability to program the database directly permits more efficient data manipulation and data definition.

Better Data Design and Mining

Oracle databases provide tools that simplify both the design and creation of database objects. These tools provide you with the ability to create diagrams of database tables and transactions. Oracle database management systems also permit capturing transactional data and provide surface maps to investigate what data is most often accessed. This facilitates the creation of charts and other reports that can aid in making solid business decisions, thereby saving time and money.

Simplified Data Administration

You can also administrate data in Oracle easily using management tools that are part of the Oracle system. These include tools to start or stop Oracle instances, "SQL Developer" for writing PL/SQL and "Enterprise Manager/Ops Center" to assist your DBAs with daily administration.

answer Jan 23, 2015 by Manikandan J