The Oracle server has capability to support an object relational database model as below and fully integrated with the relational model.
- Support object-oriented programming
- Support complex data types
- Support complex business objects
With the Oracle architecture, it support multitier application design and improve the performance and functionality for data warehouse and OLTP application. It apply to client / server based application or web-based application.
Benefits for Data warehouse:-
- Simultaneously happen for insert, update, delete activities.
- Database partitioning (usually by date)
- Database archiving
Benefits for OLTP (Online Transaction Processing) Application:-
- Real-time data sharing
- Huge buffer cache transmitting
- Logical constraints integration
Example:- Develop an Internet business application
- A product to store and manage the data
- A platform can support real-time transaction with robust engine to support complicated business logic and multi-users concurrent transactions
- A product can integrate to application and database level for monitoring and diagnostic purpose
- A product can support huge data archiving for complex reporting and matrix generation
With the Oracle Internet Platform, it includes everything that you needed for above requirements. It has the advance graphical user interface (GUI) to provide users for the development, deploying, testing, monitoring, migration, administration and many more as one.
With the Oracle Developer Suite, it provides users to develop the forms and reports through data warehouse using SQL, PL/SQL, Java to write the store procedure, functions and packages.
