I use Oracle databases with multiple clients mainly for analyzing financial transactions. They use it to find the profit and loss for each and every day of trading activity.
Finding out out a single day's profit and loss used to take them almost seven days to calculate. For example, if they wanted to find out something new, they could find the profit and loss of the day's data only by the following week. So we introduced Oracle Database Appliance for the extra data and to gather all the information we have across all the systems. We built a warehouse database that will accommodate all the information and we reduced the time to determine the entire transactions of P and L into a single day.
The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day. This is our main use for Oracle. The business intelligence and data warehousing features are the best part of Oracle Database Appliance.
How many Oracle Database License required by ODA?