Non-stop traffic with Oracle Database
Lisandro Fernigrini profile photo
December 04, 2019

Non-stop traffic with Oracle Database

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Database 12c

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.
Yes - I'm a member of AROUG (Argentina Oracle User Group). As a member, I collaborate on the organization of events like the former OTN Tour (now Oracle Groundbreakers Tour) that visits Argentina each year. This allows me to interact with Oracle professionals from other parts of my country, and also with speakers that come from all around the world. It is a great experience that provides both "technical" knowledge but also a lot of new perspectives from people working in different countries.
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 12c delivers good value for the price?

Yes

Are you happy with Oracle Database 12c's feature set?

Yes

Did Oracle Database 12c live up to sales and marketing promises?

Yes

Did implementation of Oracle Database 12c go as expected?

Yes

Would you buy Oracle Database 12c again?

Yes

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 12c

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
Oracle Database is a proven platform that allows our customers to adapt to variable workloads, ensuring availability and scalability.

Using Oracle Database 12c

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.
ProsCons
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