Building a solar production datalake in autonomous database with native JSON and REST enabled support | Part one


The idea here is to create an open community to share solar production data for machine learning research purposes that will be used later to help in automation of solar production facilities.

The architecture of the solution is pretty simple, an autonomous database with a raw table to store JSON data and REST enabled to allow data ingestion easily.

In coming posts we’ll add a couple more components to the picture in order to api-enable the solution, but for the moment let’s keep it simple.

STEP 1: CREATE DATABASE

You can create the database in less than 5 minutes, just google for how to do it

STEP 2: CREATE RAW TABLE

Open database actions web tool and execute:

create table rawsolardata (id number primary key,  jdoc JSON);

STEP 3: REST ENABLE THE TABLE

STEP4: TEST

curl --location --request POST \
'https://g41b847d6ef1298-db202109081829.adb.eu-frankfurt-1.oraclecloudapps.com/ords/admin/rawsolardata/' \
--header 'Content-Type: application/json' \
--data-binary '{
  "id": "3",
  "jdoc": "{\"d\":\"2012-04-23T18:25:43.511UTC\",\"pv\": 300,\"m\": -500}",
  "sys_ime_oson_9ff246e3ae1e4f05bf27dc09ca615308": "3"
}'

To be continued

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.