Google simulates Ethereum Blockchain with BigQuery data analysis platform

in #bitcoin6 years ago

Google, the Internet search engine giant (and more), has integrated Ethereum Blockchain into its BigQuery Data Analysis Platform.

In a blog post on Saturday, the company said that while APIs exist for commonly used functions such as checking the transaction status or wallet balance, it is not easy to access. All data is stored on Ethereum Blockchain.
The article goes on to say that perhaps the API does not allow "blockchain" data to be viewed comprehensively.

With the new service to provide an overview of Blockech's Ethereum, Google said:

""Visualize like this ... it's useful for making business decisions, such as improvements to the Ethereum architecture. With the new tool, checking whether the Ethereum system is running at full capacity and whether it needs to be upgraded or not is done with a simple database query. "

The software system that Google built on the Google Cloud platform does some things: it synchronizes Ethereum Blockchain with computers running Parity; It retrieves data from the daily Ethereum ledger, including the results of smart contract transactions; and "bundle and archive date-specific data into BigQuery for easy analysis and aggregation, cost savings."

In some examples describing how well the tool works for users, Google provides an example of a portion of CryptoKitties, the DApp-authorizing application with the most intelligent contract transaction volume on Ethereum. Blockchain. Below is an overview of the CryptoKitties breeders' accounts of 10 or more digital cats; The size of the blobs show their reproductive power.

Overview of the CryptoKitties pedigree

OmiseGO trading fluctuations from September 201/20 until now, illustrated by Google's BigQuery

The second example looks at data from the OmiseGo ERC-20 token project, with the number of recipients (green lines) suddenly skyrocketing on 30/09/2017, while redirects no again

Explanation?

The spike segment in the green activity area corresponds to a recent airdrop, in which many OMG tokens have been sent in many wallets at once. We can surmise that many users have kept the tokens they received, at least that week.

A whole new thing is the ability to compare smart contracts, especially in their functions. Integrating Ethereal into BigQuery brings the freedom that comes with a large set of analysis tools.

Ethereum data collected by BigQuery is updated daily. To make full use of its functionality, a working knowledge of database programming would certainly be useful, since all queries are done using SQL.

Google is also gearing up for a number of other blockchain-related tools - previously announced a new suite of development tools to provide customers with an easy way to build smart contracts. deploy decentralized applications.

Coin Marketplace

STEEM 0.28
TRX 0.13
JST 0.032
BTC 65229.52
ETH 2946.17
USDT 1.00
SBD 3.67