56 subscribers
با برنامه Player FM !
پادکست هایی که ارزش شنیدن دارند
حمایت شده
Allen Day: Google’s Mission to Provide Open Datasets for Public Blockchains
Manage episode 232838327 series 1652309
Public blockchains produce enormous amounts of data. In theory, anyone can access the raw contents of transaction and blocks. In practice, however, querying blockchains can prove to be a daunting task.
The difficulty lies in the fact that blockchains are particular types of distributed databases and thus carry several limitations. Most, if not all, blockchains lack the most basic SQL querying capabilities supported by nearly every off-the-shelf database system.
Take Bitcoin as an example. Its API lacks even the most basic calls which would allow a user to query any address and receive the balance. In order to achieve this, block explorers and alike have developed sophisticated middleware infrastructure that parses the blockchain, normalizes the data, and stores it in a database, where it can be queried. In the best of cases, companies offer API calls for only a limited set of operations. Google hopes to change this by freeing blockchain datasets.
We’re joined by Allen Day, Science Advocate at Google’s Singapore office. Earlier this year, he and his team released the Bitcoin blockchain as a public dataset in Big Query, Google big data IaaS offering. In August, they added Ethereum to their list of freely available public datasets, which includes US census data, cannabis genomes, and the entirety of Reddit and Github. Anyone wishing to query the data can do so in SQL on the Big Query website or via an API. For instance, a relatively simple query would return the daily mean transaction fees since the Genesis Block in just a few seconds.
Coupled with Google’s AI and Machine Learning infrastructure and other open data sets, one can only imagine the potentially groundbreaking insights we could gain from this data.
Topics covered in this episode:
- Allen’s background as a geneticist
- The similarities between blockchains and evolution process in lifeforms
- Google’s cloud platform and its various components
- Big Query and its publicly available datasets
- The Bitcoin and Ethereum datasets in Big Query
- Why this data is useful to the public and for what it may be used
- The particular challenges in implementing Ethereum as opposed to Bitcoin
- Insights we may gain by crossing blockchain dataset with other data
- How machine learning and AI could help us better understand specific transaction patterns
Episode links:
- Bitcoin in BigQuery: blockchain analytics on public data
- Bitcoin Blockchain Public Dataset
- Ethereum in BigQuery: a Public Dataset for smart contract analytics
- Ethereum in BigQuery: how we built this dataset
- Ethereum Blockchain Public Dataset
- Change Agent by Daniel Suarez
- Real-time Ethereum Notifications for Everyone for Free
- ethjs-abi library, compiled for use in Google BigQuery
- Kaggle: Your Home for Data Science
- The Strange Inevitability of Evolution - Issue 20: Creativity - Nautilus
- Reddit_
- Google Cloud
Thank you to our sponsors for their support:
- The open, decentralized trading protocol for ERC20 tokens using the Dutch auction mechanism. More at epicenter.tv/dutchx.
- Deploy enterprise-ready consortium blockchain networks that scale in just a few clicks. More at aka.ms/epicenter.
This episode is hosted by Sébastien Couture. Show notes and listening options: epicenter.tv/254
611 قسمت
Allen Day: Google’s Mission to Provide Open Datasets for Public Blockchains
Epicenter - Learn about Crypto, Blockchain, Ethereum, Bitcoin and Distributed Technologies
Manage episode 232838327 series 1652309
Public blockchains produce enormous amounts of data. In theory, anyone can access the raw contents of transaction and blocks. In practice, however, querying blockchains can prove to be a daunting task.
The difficulty lies in the fact that blockchains are particular types of distributed databases and thus carry several limitations. Most, if not all, blockchains lack the most basic SQL querying capabilities supported by nearly every off-the-shelf database system.
Take Bitcoin as an example. Its API lacks even the most basic calls which would allow a user to query any address and receive the balance. In order to achieve this, block explorers and alike have developed sophisticated middleware infrastructure that parses the blockchain, normalizes the data, and stores it in a database, where it can be queried. In the best of cases, companies offer API calls for only a limited set of operations. Google hopes to change this by freeing blockchain datasets.
We’re joined by Allen Day, Science Advocate at Google’s Singapore office. Earlier this year, he and his team released the Bitcoin blockchain as a public dataset in Big Query, Google big data IaaS offering. In August, they added Ethereum to their list of freely available public datasets, which includes US census data, cannabis genomes, and the entirety of Reddit and Github. Anyone wishing to query the data can do so in SQL on the Big Query website or via an API. For instance, a relatively simple query would return the daily mean transaction fees since the Genesis Block in just a few seconds.
Coupled with Google’s AI and Machine Learning infrastructure and other open data sets, one can only imagine the potentially groundbreaking insights we could gain from this data.
Topics covered in this episode:
- Allen’s background as a geneticist
- The similarities between blockchains and evolution process in lifeforms
- Google’s cloud platform and its various components
- Big Query and its publicly available datasets
- The Bitcoin and Ethereum datasets in Big Query
- Why this data is useful to the public and for what it may be used
- The particular challenges in implementing Ethereum as opposed to Bitcoin
- Insights we may gain by crossing blockchain dataset with other data
- How machine learning and AI could help us better understand specific transaction patterns
Episode links:
- Bitcoin in BigQuery: blockchain analytics on public data
- Bitcoin Blockchain Public Dataset
- Ethereum in BigQuery: a Public Dataset for smart contract analytics
- Ethereum in BigQuery: how we built this dataset
- Ethereum Blockchain Public Dataset
- Change Agent by Daniel Suarez
- Real-time Ethereum Notifications for Everyone for Free
- ethjs-abi library, compiled for use in Google BigQuery
- Kaggle: Your Home for Data Science
- The Strange Inevitability of Evolution - Issue 20: Creativity - Nautilus
- Reddit_
- Google Cloud
Thank you to our sponsors for their support:
- The open, decentralized trading protocol for ERC20 tokens using the Dutch auction mechanism. More at epicenter.tv/dutchx.
- Deploy enterprise-ready consortium blockchain networks that scale in just a few clicks. More at aka.ms/epicenter.
This episode is hosted by Sébastien Couture. Show notes and listening options: epicenter.tv/254
611 قسمت
All episodes
×
1 DappCon 25: The Ticker Is $ETH - Jerome de Tychey, Joshua Dávila & Nixorokish 1:12:32

1 Lombard: Unlocking Bitcoin DeFi Through Liquid, Yield-Bearing LBTC - Jacob Phillips 1:11:09

1 ETHPrague: ETH Renaissance - Austin Griffith, Brenda Loya, Joseph Schweitzer, Marek Olszewski 1:00:25

1 Initia: Incentively Aligned Appchains - Ezaan Mangalji, Anil Lulla & Jose Maria Macedo 1:02:08

1 Ethereum Foundation: Humanity’s Shared World Computer - Hsiao-Wei Wang & Tomasz Stańczak 1:10:21

1 Taiko: Scaling Ethereum in a Decentralised Manner - Joaquin Mendes 1:08:05

1 Mysten Labs: How Sui Leverages Move to Build the Composable Web3nternet - Adeniyi Abiodun 1:03:09

1 Tally: The Software Layer for Tokenized Organizations - Dennison Bertram 1:01:21

1 Lido V3: Ushering in Institutional Staking Through stVaults - Hasu 1:19:32

1 Solana: From On-Chain Nasdaq to the Pump Fun Craze - Anatoly Yakovenko 1:18:28

1 Build on Bitcoin: Combining Bitcoin's Security With Ethereum's Versatility - Alexei Zamyatin 1:10:10

1 Puja Ohlhaver: Why Community Currencies Are Crucial for Governance in DeSoc 1:04:42

1 Nevermined: Payment System for the AI Agentic Economy - Don Gossen 1:04:38

1 Turtle Club: Helping Web3 Users Monetize Their On-Chain Activity - Esfandiar Lagevardi 1:09:25


1 Balancer: Custom AMMs and Liquidity Solutions - Fernando Martinelli 1:04:35



1 RedStone: The Oracle Pioneering the Future of DeFi - Marcin Kaźmierczak 1:04:40

1 Privado ID & Quark ID: On-Chain ZK-Powered Unified ID - Diego Fernandez & Evin McMullen 1:06:49

1 Abundance: The First 1 Gigagas/second Stack for Sovereign Rollups - Hilmar Orth 1:09:00

1 Monad: The EVM-Compatible 10,000 TPS L1 Blockchain - Keone Hon 1:10:54


1 Bitcoin OS: Bitcoin Block 853626 Changed Everything For BTC Smart Contracts - Edan Yago 1:10:20

1 Symbiotic: Scaling Shared Security Through Restaking - Misha Putiatin 1:05:36

1 Ari Juels: Can AI Weaponize Blockchain Smart Contracts? - Chainlink 1:04:05


1 Anoma: Solving Cross-Chain Interoperability Through Intents - Adrian Brink 1:05:02

1 Dappnode: Plug-n-Play Decentralization - Eduardo Antuña, Pol Lanski 1:18:46


1 Blockworks: The Future of Crypto = AI, Memecoins and DePIN - Jason Yanowitz Live @Permissionless 59:58

1 Konstantin Lomashuk: '#bitcoin is like a #memecoin' - cyber·Fund 1:06:57

1 Celestia: 1Gb Blocks, Rollup Interoperability & Lazy Bridging. Ismail Khoffi & Mustafa Al-Bassam 1:03:48

1 Numerai & Predictoor: How AI Changed Crypto Prediction Markets - Trent McConaghy & Richard Craib 1:20:36


1 Arcium: Parallelized Confidential Computing Network - Yannik Schrade 1:02:10

1 Polymer: A New Era for Interoperability...on Ethereum! - Bo Du 1:02:19




1 MultiversX: Blockchain Sharding 101 - Lucian Mincu 1:08:49

1 Mel Project: Is Web3 Truly Decentralised? - Eric Tung 1:18:06

1 How Gnosis 3.0 Paves the Way for Mass Adoption - Friederike Ernst 1:10:20


1 ‘Aave v4 Will Unify Cross-Chain Liquidity’ - Stani Kulechov 1:10:48

1 Fabric Ventures' Investment Thesis Since the Dawn of Bitcoin to AI - Richard Muirhead 1:09:24

1 Plurality: How Taiwan Managed to Unite Its People Through Tech - Audrey Tang & Glen Weyl 1:01:32

1 'Ethereum Needs Polygon's Aggregation Layer to Scale' - Brendan Farmer & Sandeep Nailwal 1:05:56

1 EthStaker: Ethereum Staking Wars - Nixorokish & Superphiz 1:02:09

1 PsyDAO: Decentralising Psychedelic Research - Dima Buterin & Paul Kohlhaas 1:21:46

1 Crypto ETFs: Trojan Horse or Big Win? - Austin Griffith, Mona El Isa, Peter Van Valkenburgh 1:12:29



1 Near Protocol: 'Blockchains Cannot Scale Without Sharding!' - Illia Polosukhin & Alex Skidanov 1:45:33

1 'Is Tether's USDT Safe?' - Paolo Ardoino 1:27:32
به Player FM خوش آمدید!
Player FM در سراسر وب را برای یافتن پادکست های با کیفیت اسکن می کند تا همین الان لذت ببرید. این بهترین برنامه ی پادکست است که در اندروید، آیفون و وب کار می کند. ثبت نام کنید تا اشتراک های شما در بین دستگاه های مختلف همگام سازی شود.