DBMS_DATA_MINING package for Machine Learning inside the database Posted on September 28, 2021, updated on September 27, 2021 by Yannick Jaquier Table of contents Preamble Loading dataset Dataset queries and charts Model creation and testing Conclusion DBMS_PREDICTIVE_ANALYTICS all in one bonus package References Continue reading
PostgreSQL graphical monitoring tools comparison Posted on August 28, 2021, updated on September 20, 2021 by Yannick Jaquier Table of contents Preamble pgAdmin Postgres Enterprise Manager Postgres Enterprise Manager Server Postgres Enterprise Manager Agent OmniDB Percona Monitoring and Management Server Client PGWatch To be continued... References Continue reading
PostgreSQL backup and restore tools comparison for PITR recovery Posted on July 28, 2021, updated on August 2, 2021 by Yannick Jaquier Table of contents PostgreSQL backup and restore Pg_basebackup PgBackRest EDB Backup and Recovery Tool Barman To be continued... References Continue reading
GoldenGate for Big Data and Kafka Handlers hands-on – part 2 Posted on June 28, 2021, updated on June 22, 2021 by Yannick Jaquier Table of contents Preamble Oracle test case creation GoldenGate extract configuration GoldenGate for Big Data and Kafka Handler configuration GoldenGate for Big Data and Kafka Connect Handler configuration References Continue reading
GoldenGate for Big Data and Kafka Handlers hands-on – part 1 Posted on May 27, 2021, updated on May 28, 2021 by Yannick Jaquier Table of contents Preamble 19c pluggable database configuration GoldenGate 19.1 installation GoldenGate 19.1 for Big Data Installation Kafka configuration References Continue reading
Network encryption hands-on with Java, Python and SQL*Plus Posted on April 26, 2021, updated on April 21, 2021 by Yannick Jaquier Table of contents Preamble Database server configuration for network encryption Activating network encryption with Java Oracle JDBC Thin Driver Oracle JDBC OCI Driver Activating network encryption with Python Conclusion References Continue reading