top of page
All posts
Why are external DWH orchestrators a "cargo cult"? An introduction to the in-database framework DBLiner
Whenever a company faces the task of building a corporate data warehouse (DWH) based on PostgreSQL or the massively parallel processing (MPP) database Greenplum, architects instinctively reach for the usual stack: Apache Airflow, Dagster, or Prefect. The setup follows a classic pattern: a heavy external infrastructure is provisioned, and Python-based workers are deployed. On a set schedule, these workers wake up, establish a session with the database, and send a single line o
Admin
Oct 196 min read
Working with CerebroSQL on Linux OS
Ubuntu 20.04 INSTALLING ttf-mscorefonts-installer is MANDATORY. 1. Installing Windows fonts (the main font of the program is Tahoma and a...
Admin
Aug 28, 20211 min read
Roaming Service for Primary Oracle Instance (ADG)
Перемещаемые сервисы гарантируют подключение пользователей к промышленной БД несмотря на фактическое ее расположение (после переключения)
Admin
Aug 28, 20211 min read
How to setup SQL*Plus prompt
Configuring the SQLPLUS prompt in Oracle DBMS when connecting from the command line
Admin
Aug 28, 20211 min read
Quick installation of Oracle DBMS versions 11G and older in Linux (without installing the UEK kernel
Step-by-step process of setting up a new Linux OS server for later installation of Oracle DBMS versions 11G and older
Admin
May 14, 20212 min read
Oracle database migration from AIX to Linux (Cross Platform Transportable Tablespaces)
Describes the sequence of actions for migrating a database from AIX OS to Linux OS using the Step by Step migration (TTC) mechanism.
Admin
May 14, 20213 min read
Installing and Configuring APEX in Oracle Database
Installing and configuring APEX in Oracle DBMS
Admin
May 14, 20211 min read
bottom of page