Development

Service Oriented Architecture

• Oracle Service Bus, Its main function is acting as a mediator between different applications allowing them to communicate between themselves, without having to do it directly, wrapping the complexity that such communication involves. It allows to do everything from simple routing and transformation to complex orchestrations with the limitation of being synchronous and sequential.

• Oracle BPEL Process Manager allows the orchestration of more complex flows with asynchronous and parallel processing flows. The instances are sturdy and traceable, since the state is stored in databases.

• Oracle JCA adapters allow integration with any data source, be it an application, database, messaging, etc. Particularly helpful is the integration with stored procedures and AQ queues, since they enable a very simple integration with applications developed with BD Oracle.

• JAX-WS and JAX-RS are development standards of WebServices and RESTful in java that allow a rest from the communication details and structure transformations and to focus on the required functionalities.

Web Applications

• Oracle ADF is the proposal for the development of Oracle JSF applications in a JEE platform with high Java productivity levels in JEE servers.

• Responsive applications based on Javascript frameworks such as JQuery, Bootstrap, AngularJS and RESTful services using the JAX-RS standard, which greatly simplifies the development of these services.

Extraction, transformation, data loading (ETL) and Integration/ Extracción transformación y carga de datos (ETL) e Integración

• Oracle Data Integrador (ODI) allows the development of transfer components between very diverse data sources. Using java`s jdbc connector technology it is configured to operate with most known DB's. Allows the configuration of connectors to data sources with lesser-known drivers. It integrates:

  • SQL statements with the following patterns: delete-insert, truncate-insert, append and merge.

  • Change capture components like goldengate and others.

  • Stored procedures.

  • Initialization of execution parameters using SQL.

  • Webservice call.

  • FTP, HTTP, SSH and SFTP servers.

  • E-mail servers.

  • OS command execution.

DB Oracle components

• PL / SQL is a powerful and elegant procedural language with which the stored procedures in Oracle DB are developed. Their characteristics are:

  • Variable use of automatic bind.

  • Natural integration with dyinamic and static SQL sentences.

  • Effective and simple exception handling.

  • Java component integration

  • Powerful libraries for: CML, JSON, I/O, messaging, process control, HTML, HTTP, etc.

  • Collection use: registers, normal and associative arrangements, tables in memory, etc.

  • Bulk data operations

• AQ queues allow Oracle application integration to be developed in a fully decoupled manner with producer / consumer or publisher / subscriber patterns with 2-phase commit protection, as well as integration with services using JCA adapter technology for AQ queues

• Oracle SQL language is characterized by the following

  • Handling SQL sentence standarts

  • A powerful cost-based optimizer that can be controlled by hints and inspected through execution plans and others.

  • A lock architecture at the row level which operates with consistent reading among multiple versions.

  • A powerful set of functions such as: generation and parsing of XML, handling of dates, regular expressions.

  • Analytic functions, allowing a great amount of operations, such as:

    • Percentage of the total.

    • Difference with the value of the previous record.

    • Obtaining multidimensional groupings.

    • Obtaining group rankings.

    • Etc.

  • Merge sentence performing insert if the record doesn't exist or update otherwise.

• Oracle has a series of objects that support the development of efficient applications:

  • Sequences that allow the generation of correlative keys avoiding contention between processes or users.

  • Materialized views that allow for complex precalculated results.

  • Triggers that allow the implementation of complex business rules at the DB level, both in validation and data updating.