- Advertisement -

Ethereum dataset is now available on Google BigQuery courtesy of the data warehousing solution of Google – Google Cloud’s Petabyte. This availability, according to a blog post by the company, is expected to make smart contracts analytics very easy to explore.

A New Dawn In Blockchain Data Accessibility

It is now possible for Google users to access all the historical data of Ethereum. Some of the ETL projects by Ethereum available on GitHub and which can be outsourced from Ethereum blockchain to Google’s BigQuery are the source codes.

The principal reason for allowing Ethereum blockchain to be available on Google Cloud is to ensure that every data saved on Ethereum can be accessed easily by Google. Ethereum has always had APIs allowing some of its functions (e.g. checking of wallet balances) to be randomly accessed but it was not possible before now to access stored data on the blockchain with its API endpoints.

The endpoints of API may not allow blockchain data to be viewed at once or in groups but features on Google’s OLAP BigQuery allow such analysis. On Google’s blog, the transaction costs and transfers of Ethereum were displayed in a chart all aggregated by a day. This kind of visual gives support to changes in priority in Ethereum when such a change is deemed necessary.

Benefits Of The Sync

Computers that are equipped with Parity which is an Ethereum client can now be synchronized with Google Cloud. This would make applications building absolutely easy

In the same vein, BigQuery can now extract and explore data from the Ethereum ledger on a daily basis. Such data include stored partitioned data and token transfers and this is projected to lead to greater efficiency.

- Advertisement -

Furthermore, the library feature present on BigQuery Python ensures that clients can query kernels’ data tables which is a free inbuilt browser on Kaggle.

Analysis Of Smart Contracts

Already, some smart contract functions such as transaction times, calls, and function analytics have been enabled on Google BigQuery.

In an attempt to ascertain which smart contract is mostly used, BigQuery has embarked on querying dataset transactions and contract tables of Ethereum. And to this effect, the 10 leading Ethereum ERC-721 contracts based on transactions were displayed on the chart.

In all, CryptoKitties game’s smart contract emerged as the most popular of the ERC-21 smart contracts. In situations where it was discovered that a birth event was seen to be logged by a contract source code, it is possible to question the circumstances behind the event by making use of the tables.

Similarly, suppose an individual wishes to find out games that are related to CryptoKitties, such can be done by using the Jaccard similarity coefficient. This is a statistical tool that utilizes JavaScript to compare and contrast sample tests.

More Possibilities Of Visualizations

With graph data that are directed, it is also possible to gain an insight into data insomuch that transfer sets are included in its wallet addresses.

For instance, not less than two trading partners are contained in the first forty thousand transactions. On the blog, Gephi-made visualization software was made available. This displays different colors separated by addresses in groups. This graphic was calculated using Modularity algorithm.

Interestingly, many a bunch of the source code for the smart contract are free. This allows users of Google to know the function that a particular contract performs based on its name. This is also possible with sourceless contracts since a similar function name carries a similar function signature.