Non-stop traffic with Oracle Database
Updated November 03, 2021
Non-stop traffic with Oracle Database
Score 9 out of 10
Vetted Review
Verified User
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?
Yes
Are you happy with Oracle Database's feature set?
Yes
Did Oracle Database live up to sales and marketing promises?
Yes
Did implementation of Oracle Database go as expected?
Yes
Would you buy Oracle Database again?
Yes
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
| Pros | Cons |
|---|---|
Like to use Relatively simple Technical support not required Well integrated Consistent Convenient 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