Best Relational Database- Oracle Database
I have used this Database for storing and retrieving the data for a web application. As it is a relational database management system and …
Overview
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered.…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
- In memory feature - very fast. Earlier queries used to run in fetching data used to take time now it is very fast. We can even select which table shou...
- Oracle Database restoration and recovery is complex. RMAN backup recovery has quite a lot of steps and is complex. In other databases, it is very much...
Pricing
N/A
Unavailable
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
167 people also want pricing
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
What is TeamDesk?
TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Database?
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
Oracle Database Video
Oracle's Converged Database
Oracle Database Competitors
- PostgreSQL
- MariaDB Platform
- Microsoft
Oracle Database Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
PostgreSQL and MariaDB Platform are common alternatives for Oracle Database.
Reviewers rate Support Rating highest, with a score of 10.
The most common users of Oracle Database are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(1191)Attribute Ratings
Reviews
(1-3 of 3)Companies can't remove reviews or game the system. Here's why
November 03, 2021
Non-stop traffic with Oracle Database
We use Oracle 12c databases to store information from many of the critical modules of our MLFF (Multi Lane Free Flow) tolling solutions. Oracle Database 12c can handle variable workloads, maintaining throughput at peak moments. Our solutions utilize many different technologies, but rely on Oracle Database as a key component.
- Oracle Database 12c has the ability to scale to support intensive workloads.
- PL/SQL provides an efficient way to develop data-intensive processes that are able to interact with data without transferring it to an app server
- Partitioning, Compression and Encryption are some of the optional features that enhance performance, reduce costs and secure the information stored in Oracle Database 12c
- New (actually it is more than five years old) multi-tenant architecture is not as straightforward as SQL Server, but it has been enhanced in Oracle 12c Release 2 and later 18c and 19c.
- Many features require additional licensing (either as options or as packs) that increase the total cost
- As a software center, we are able to work with a proven platform that is recognized by our customers as a solid and secure Database, leveraging their previous knowledge and experience with Oracle.
We use SQL Server for other modules of our MLFF Tolling System, so I work on a daily basic with both database engines. Oracle is recognized and distinguished by scalability and performance, ensuring a secure environment to host our critical data that comes from multiple roadside sites and from partner agencies, guaranteeing the availability and stability of stored data.
200
All development roles, including Software Architects, .Net Developers, Testers, Configuration Managers and Database Developers. We design, develop, deploy and test our Multi Lane Free Flow tolling systems using Oracle Databases
5
Configuration Managers install and deploy Oracle Database instances, on Development, Testing, Performance and User Acceptance environments. The Database Developers program with PL/SQL and review SQL embedded on the App layer, and also conduct performance testing.
- Our software solution -- most critical modules use Oracle Database to store critical information
- PL/SQL Programming is simple and powerful, allowing efficient data processing on the data layer
- Features like ASMM (Automatic Shared Memory Management) allow DBA to focus on important things rather than dealing with frequent configuration updates
- Installation and deployment process using the relatively new CDB (Container + Pluggable Databases) architecture is more complex than a non CDB architecture
No
April 11, 2018
My thought on Oracle Database 12C
The Oracle 12C Database is used as a core business backbone for modeling the process of selling products in more than 25 countries in one of the biggest retailers in the world. The database not only deposit the data but also contains the business logic in PL/SQL packages.
- high performance
- mature and reliable
- rich in features
- can be expensive
- big footprint
- stability
- security
it was not my choice for Oracle 12C, but during the years I've learned on the advantages. If I would choose the Oracle 12C, I'll take it for the possibility to start from Standard and to go to enterprise based on a business case of use. I really like the possibility to have the logic in the database (triggers/ procedures/functions/packages)
80
Application Users
Developers
Business Analysts
Developers
Business Analysts
10
Oracle Database Administration Users
- store/retrieve data
- store business logic
- transfer data
- devops processes with no downtime via EBR
- running Oracle database on docker
- using database for feeding and consuming web services via JSON
- document store
Not Sure
- Product Features
- Product Usability
- Product Reputation
I would choose hard on the edition of the database. Sometimes even the express edition offers all you need for an internal application and if it scales up you can easily change to a standard or even an enterprise edition.
- Implemented in-house
- Professional services company
I can't disclose the company
Yes
Change management was a minor issue with the implementation
- understanding the business needs and implementing them in database
- human factors
- time compression
- administration via EM
- database development via SQL Developer with revers engineering on models
- reporting with APEX
- reading logs
- administering without proper options installed
No
February 27, 2016
Oracle Database - Simply The Best
Oracle Database is being used in the areas of data warehousing and transaction processing across the whole organization. The business problems it addresses are various log data collection, search engine marketing, and website content optimization. In addition it is used to cleanse, aggregate, load and transform data in the data warehouse, with the data eventually consumed by data analysts and data scientists.
- Maintain data integrity: with database supplied primary/unique keys and referential integrity constraints, data integrity is well-maintained in a highly efficient manner. More over, oracle database enforces transaction integrity and read consistency, and it is extremely rare to have data corruption.
- Versatility and flexibility in usage: Oracle is very versatile and has many capabilities that allow for a great variety of usage and creativity. Most of the real life business use cases can be addressed by it, and one just needs to know how to better take advantage of it.
- Rock-solid foundation and exciting new features: Oracle database has come a long way (created in the mid to late 1970s), and evolved to be the best relational database platform. It has also incorporated many new features over the years, either inside the database engine itself or through add-on options/products. It has a strong life even faced with the new-age challenges such as big data analytics.
- It would be nice to have schema-based privilege grants. Currently, the object privileges are granted either per individual objects (very small knife), or on all objects (very big knife). We need something in between: schema-based privilege grants with the ability to cover new objects owned by a particular schema after the grant. For example: one could use "grant select on all tables of A to B;".
- It may be nice to have the ability to issue commit on behave of another session for its completed but uncommitted transactions. Imagine a scenario that one session issues an update on a table, and after some time the update is completed but the person doesn't commit. The table remains to be locked by the session. Another session needs to update on the same rows after the prior session's update, but it has to wait or kill the other session. Killing the other session means rolling back that session's transaction and losing all of its effort. In this case, if we want to preserve the other session's update, it would be nice to commit on behave of that session (instead of simply killing the session and losing its transaction), and then do our update.
- The use of Oracle Database has improved overall availability, performance, and the capabilities of the business systems, and it has a positive impact on ROI.
- Oracle has the reputation of being expensive. If not planned, sized, and estimated appropriately, one could over spend on things that are not necessary. That will inevitably result in a negative impact on ROI.
- Think about long term, and the availability of people's skill sets within the organization, and the skills accessible outside. Use the right tools for the jobs.
- Data manipulation and query
- Data processing and transformation
- Loading data into the database
- Unload massive amount of data out of the database
- Some analytics queries and functions
- Monolithic nature of the database storage layer
No