Google Announces Availability Of Ethereum Dataset On Big Query For Smart Contract Analytics

Google Announces Availability Of Ethereum Dataset On Big Query For Smart Contract Analytics 1

Following its decision to make the Bitcoin dataset publicly available for analysis on it’s infrastructure server earlier this year, Google Cloud has announced the availability of the Ethereum blockchain data for exploration with BigQuery.

BigQuery is a RESTful web service that enables interactive analysis of massively large datasets.

Ethereum was largely built off the back of Bitcoin’s blockchain, where its creator, Vitalik Buterin, substantially extended its set of proficiency by including a virtual machine that can execute arbitrary code stored on the blockchain as smart contracts.

In form and structure, Ethereum practically mirrors Bitcoin, as it primarily serves to record immutable transactions. However, while both are essentially OLTP databases, providing little in the way of OLAP (analytics) functionality, the Ethereum dataset is notably distinct from the Bitcoin dataset.

Coinbase 3

According to Google, one of such disparities between both cryptocurrencies is the composition and mechanism of value transfer. While Ether value transfers are precise and direct, its predecessor—Bitcoin, has a more difficult value transfer mechanism.

Google also notes that with Ethereum, an aggregate of coordinated smart contracts could be used to build a decentralized autonomous organization (DAO). The Ethereum blockchain peer-to-peer software has an API for a subset of random-access functions such as checking wallet balances, but it still doesn’t include API endpoints for accessing data stored on-chain and for viewing the blockchain data in aggregate.

Google also believes the Ethereum architecture could be due for an upgrade. Expanding on this point the blogpost reads in part:

“BigQuery has strong OLAP capabilities to support this type of analysis, ad-hoc and in general, without requiring additional API implementation.”

The tech giant said it has built a software system on Google Cloud that synchronizes the Ethereum blockchain to computers running Par A visualization.

This system along with the underpinning database query are useful for making business decisions, such as improving the “Ethereum architecture itself (is the system running close to capacity and due for an upgrade?) to balance sheet adjustments (how quickly can a wallet be rebalanced?)”

The blogpost goes on to highlight the routine of Google Cloud, which will perform a daily extraction of data from the Ethereum blockchain ledger, including the “results of smart contract transactions, such as token transfers.” It will also de-normalize and store date-partitioned data to BigQuery for easy and cost-effective exploration.
Going forward, Google maintains that it hopes to welcome more contributors and blockchains to its platform.

Google Announces Availability Of Ethereum Dataset On Big Query For Smart Contract Analytics 2
About the author

E-Crypto News was developed to assist all cryptocurrency investors in developing profitable cryptocurrency portfolios through the provision of timely and much-needed information. Investments in cryptocurrency require a level of detail, sensitivity, and accuracy that isn’t required in any other market and as such, we’ve developed our databases to help fill in information gaps.

Related Posts

Leave a Reply

E-Crypto News Executive Interviews



bitcoin
Bitcoin (BTC) $ 32,690.00
ethereum
Ethereum (ETH) $ 1,909.92
tether
Tether (USDT) $ 0.997613
binance-coin
Binance Coin (BNB) $ 285.96
cardano
Cardano (ADA) $ 1.21
dogecoin
Dogecoin (DOGE) $ 0.226335
xrp
XRP (XRP) $ 0.627747
usd-coin
USD Coin (USDC) $ 0.999530
polkadot
Polkadot (DOT) $ 14.96
binance-usd
Binance USD (BUSD) $ 0.999639
USD
EUR
GBP
bitcoinBitcoin (BTC)
$ 32,690.00
ethereumEthereum (ETH)
$ 1,909.92
tetherTether (USDT)
$ 0.997613
bitcoin-cashBitcoin Cash (BCH)
$ 461.41
litecoinLitecoin (LTC)
$ 124.99
bitcoinBitcoin (BTC)
27.464,67
ethereumEthereum (ETH)
1.604,63
tetherTether (USDT)
0,838150
bitcoin-cashBitcoin Cash (BCH)
387,66
litecoinLitecoin (LTC)
105,01
bitcoinBitcoin (BTC)
23,505.58
ethereumEthereum (ETH)
1,373.32
tetherTether (USDT)
0.717329
bitcoin-cashBitcoin Cash (BCH)
331.77
litecoinLitecoin (LTC)
89.87

Automated trading with HaasBot Crypto Trading Bots

Crypto Scams

What Role Do Cryptocurrencies Play In The Era Of Ransomware Attacks?
June 9, 2021
Crypto Scams On The Rise As Market Enters Bull Cycle
Crypto Scams On The Rise As Market Enters Bull Cycle
December 22, 2020
Harpreet Singh Sahni perpetrated the Plus Gold Union Coin (PGUC) scam
Sydney Concert Promoter Harpreet Sahni Involved In $50M Crypto PGUC Scam
November 2, 2020
KuCoin hackers steal $150 million
KuCoin Exchange Hacked But Insurance Will Cover The Stolen $150M
September 29, 2020
Mining City insists that it is legit
Mining City Refutes Claims By Philippines SEC Of Being A Scam
September 23, 2020

Blockchain/Cryptocurrency Questions and Answers

What Is Plethori Platform And How Does It Work?
June 12, 2021
What Is The Fudge Token?
What Is The Fudge Token?
June 5, 2021
What Is Shiba Inu (SHIB) Cryptocurrency And How Does It Work?
What Is Shiba Inu (SHIB) Cryptocurrency And How Does It Work?
May 31, 2021
What Is PancakeSwap And How Does It Work?
What Is PancakeSwap And How Does It Work?
May 27, 2021
How Has Internet Computer (ICP) Become A Top-10 Crypto?
How did “Internet Computer Coin”(ICP) Become A Top-5 Crypto?
May 19, 2021


CryptoCurrencyUSDChange 1hChange 24hChange 7d
Bitcoin32,625 1.49 % 4.18 % 14.86 %
Ethereum1,901.2 1.53 % 5.36 % 19.64 %
Tether0.9976 0.23 % 0.71 % 0.09 %
Binance Coin284.57 2.70 % 0.05 % 17.86 %
Cardano1.220 0.88 % 1.29 % 17.72 %
Dogecoin0.2255 2.09 % 6.98 % 26.61 %
XRP0.6260 1.86 % 3.98 % 25.11 %
USD Coin1.000 0.05 % 0.27 % 0.12 %
Polkadot14.80 3.51 % 9.97 % 35.17 %
Binance USD0.9959 0.43 % 0.79 % 0.34 %

bitcoin
Bitcoin (BTC) $ 32,690.00
ethereum
Ethereum (ETH) $ 1,909.92
tether
Tether (USDT) $ 0.997613
binance-coin
Binance Coin (BNB) $ 285.96
cardano
Cardano (ADA) $ 1.21
dogecoin
Dogecoin (DOGE) $ 0.226335
xrp
XRP (XRP) $ 0.627747
usd-coin
USD Coin (USDC) $ 0.999530
polkadot
Polkadot (DOT) $ 14.96
binance-usd
Binance USD (BUSD) $ 0.999639