umd-dslam / p2pdb Goto Github PK

Is your feature request related to a problem? Please describe.

https://github.com/apache/calcite/blob/ce0118b4149eb303813d0af2537a7185e9945115/core/src/test/java/org/apache/calcite/test/MultiJdbcSchemaJoinTest.java#L53-L91

• Deploy TimeScaleDB

  • https://docs.timescale.com/latest/getting-started/installation/docker/installation-docker

docker run -d --name timescaledb -p 5432:5432 -e POSTGRES_PASSWORD=password timescale/timescaledb:latest-pg11

docker exec -it timescaledb psql -U postgres

• configuration: https://docs.timescale.com/latest/getting-started/configuring

• Deploy Apache Calcite

• Execute query plans generated by Calcite on TimeScaleDB

  • https://codeday.me/jp/qa/20190710/1216256.html

• Deploy Ethereum

• Register info using smart contract

• how to query info from Ethereum blockchain

Is your feature request related to a problem? Please describe.

https://www.youtube.com/watch?v=HqzUt6FpuKY

Is your feature request related to a problem? Please describe.

We need to build an EC2 image installed both TimescaleDB and Spark so that multiple EC2 instances can form a contractor group and then enable groups to do federated join process.

Is your feature request related to a problem? Please describe.

https://docs.timescale.com/clustering/using-timescaledb/limitations#distributed-hypertable-limitations

Joins on data nodes are not supported. Joining a distributed hypertable with another table requires the other table to reside on the access node. This also limits the performance of joins on distributed hypertables.

Is your feature request related to a problem? Please describe.
https://travis-ci.org/ for continuous integration

Is your feature request related to a problem? Please describe.

• Shuffle Hash Join: works based on the concept of map-reduce.
• Broadcast Hash Join: a very common way to join two tables under the special condition that one of your tables is small.
• Sort -Merge Join: The first step is to sort the datasets and the second operation is to merge the sorted data in the partition by iterating over the elements and according to the join key join the rows having the same value.

Is your feature request related to a problem? Please describe.

We need the smart contract being scheduled and executed after the query process.

• The Advantages of Decentralized Scheduling With Ethereum Alarm Clock
  https://blog.chronologic.network/the-advantages-of-decentralized-scheduling-with-ethereum-alarm-clock-8e8acf96a344
• https://www.ethereum-alarm-clock.com/
• https://ethereum.stackexchange.com/questions/42/how-can-a-contract-run-itself-at-a-later-time