Overall Satisfaction 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.
Do you think Oracle Database delivers good value for the price?
Are you happy with Oracle Database's feature set?
Did Oracle Database live up to sales and marketing promises?
Did implementation of Oracle Database go as expected?
Would you buy Oracle Database again?
I believe that Oracle Database can be used almost on any scenario, starting with small department solutions to actually any enterprise level system. It includes many features that allow a single database to work as an OLTP and Data Warehouse at the same time, reducing hardware requirements and the need to implement ETL or integration solutions between OLTP and DW.
Using Oracle Database
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
Using Oracle Database
Many of the powerful options can be auto-configured but there are still many things to take into account at the moment of installing and configuring an Oracle Database, compared with SQL Server or other databases. At the same time, that extra complexity allows for detailed configuration and guarantees performance, scalability, availability and security.
Like to use
Technical support not required
Feel confident using
Lots to learn
- 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