Transactional Event Queues

Oracle Advanced Queuing (or AQ) vs Transactional Event Queues

Açıklaması şöyle

Oracle Database has had queueing for many years (since Oracle 8). The older implementation was (and still is) called Oracle Advanced Queuing (or AQ). TxEventQ is a newer implementation that is optimized for much higher throughput and lower latency, and it provides transactional semantics (hence the name). There are clients in all common languages, and you can set up propagation between databases, even across long distances.

Kafka APIs for Transactional Event Queues

Oracle Database 23c Free ile geliyor. Açıklaması şöyle

It has three main parts:

1. The ability for Java applications written using the Kafka API for Java to use the Oracle Database as a Kafka broker,

2. The ability for the Oracle Database to provide Kafka REST APIs, and

3. Connectors that allow the propagation of events between Kafka and the Oracle Datbase, and vice versa.

Şeklen şöyle

Oracle Advanced Queuing

Giriş

Açıklaması şöyle.  Oracle Advanced Queuing yerine Transactional Event Queues kullanılabilir

Oracle Database has had queueing for many years (since Oracle 8). The older implementation was (and still is) called Oracle Advanced Queuing (or AQ).

Oracle Cloud Infrastructure - OCI

SDK

Oracle Cloud Infrastructure altyapıya erişim için aynı AWS gibi SDK sağlıyor

Maven

Şu satırı dahil ederiz

<dependency>
  <groupId>com.oracle.oci.sdk</groupId>
  <artifactId>oci-java-sdk-common</artifactId>
  <version>3.2.0</version>
</dependency>
<dependency>
  <groupId>com.oracle.oci.sdk</groupId>
  <artifactId>oci-java-sdk-common-httpclient-jersey</artifactId>
  <version>3.2.0</version>
</dependency>
<dependency>
  <groupId>com.oracle.oci.sdk</groupId>
  <artifactId>oci-java-sdk-identity</artifactId>
  <version>3.2.0</version>
</dependency>

Burada bir örnek var

OCI GoldenGate

Açıklaması şöyle. Change Data Capture (CDC) içindir.

OCI offers a fully managed NoSQL Cloud Database, a robust alternative to Amazon DynamoDB, and a comprehensive Change Data Capture tool known as OCI GoldenGate. 

Kafka Connect OracleCdcSourceConnector

Bir yazı burada

Oracle LogMiner

Giriş

Hem Kafka Connect hem de Debezium bu arayüzü kullanııyor

Kafka Connect 

Kafka Connect için açıklaması şöyle

This connector uses the Oracle LogMiner interface to query online and archived redo log files. That’s an Oracle specific way to stream both the DML and DDL directly from the redo of the database. This is similar to how the Debezium project reads the Postgres write-ahead log or the MySQL binlog.

Debezium 

Debezium için açıklaması şöyle

Debezium ingests change events using Oracle’s native LogMiner database package. Oracle LogMiner is part of the Oracle Database utilities and provides a well-defined, easy-to-use, and comprehensive interface for querying online and archived redo log files.

The first time the Debezium Oracle connector starts, it performs an initial consistent snapshot of the database to see its entire history. You can change this behavior by setting the snapshot.mode. After the connector completes its initial snapshot, the Debezium connector continues streaming from the position it reads from the current system change number (SCN) position in the redo log. The initial snapshot ensures that the connector has a complete and consistent data set.

The Debezium connector for Oracle Databases supports the following database versions:
Oracle Database 12.2 EE
Oracle Database 19.3 EE
Oracle Database 21.3 EE

The Oracle connector used with Oracle Real Application Clusters (RAC) is in Technology Preview (TP) for this release.

Oracle Goldengate

Kafka'dan Oracle NoSQL Veri Tabanına

Açıklaması şöyle

Oracle’s GoldenGate seamlessly orchestrates data replication from source to sink through remote capture processes, known as Extract and Replicat. The Extract process captures the data and records it to trail files. These trail files are then leveraged to create a Replicat process, effectively applying the records to the sink.

Şeklen şöyle

PostgreSQL Veri Tabanından Oracle Veri Tabanına

Şeklen şöyle Burada iki tane ürün var

1. Goldengate 21c OCI Marketplace for PostgreSQL

2. OCI Goldengate for Oracle

Oracle APEX

Giriş

Açıklaması şöyle

In a way, Oracle Forms can be considered the grand-grand-grandfather of Oracle APEX. The basic idea behind these technologies is the same — easy creation of data-driven web applications with a minimal amount of coding required. Oracle APEX takes this philosophy much further, however, and is a much more evolved and modern technology. Also, most (if not all) Forms modules have their APEX counterparts.

The history of Oracle APEX dates back to 1999 when it was known as Oracle HTML DB (there were also other names, such as Flows and Project Marvel). Over the years, many versions of this technology have been released, and a few groundbreaking features have been introduced — such as plug-ins, Interactive Grid, or REST and PWA support.

Just like Forms, Oracle APEX uses the PL/SQL programming language. However, in APEX, a simple data-driven application can be created entirely — or almost entirely — through the use of specialized Wizards that allow you to connect various ready-made elements and make them work together. You can set up basic business logic, create a layout and interface, and get things working without writing a single line of code. Of course, if you’re not afraid of the command line and have the necessary coding skills (or team up with someone skilled), you can still use them to deliver more complex and powerful solutions.

It’s also worth noting that APEX uses the same database that Forms does (Oracle DB), so it’s equally scalable, safe, and stable. You also retain access to important features, ML/AI modules, Spatial, and so on. The main difference is that, unlike Forms, APEX works in the cloud.

There are no plans to abandon the development of Oracle APEX. It’s quite the opposite: APEX is becoming popular in the world of low-code development and, thus, is actively developed and supported by Oracle – which is great news for your software. The current version of Oracle Application Express is 22.1, and it was released in May 2022.