US 11,989,166 B2
Systems and methods for improved servicing of queries for blockchain data
Leo Liang, Oakland, CA (US); Jie Zhang, Oakland, CA (US); Wisam Dakka, Oakland, CA (US); and Xiaolei Peng, Oakland, CA (US)
Assigned to Coinbase, Inc., Oakland, CA (US)
Filed by Coinbase, Inc., Oakland, CA (US)
Filed on Sep. 23, 2022, as Appl. No. 17/935,002.
Prior Publication US 2024/0104071 A1, Mar. 28, 2024
Int. Cl. G06F 16/00 (2019.01); G06F 8/36 (2018.01); G06F 16/215 (2019.01); G06F 16/903 (2019.01)
CPC G06F 16/215 (2019.01) [G06F 8/36 (2013.01); G06F 16/903 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system for improved servicing of queries for blockchain data, the system comprising:
a first dataset, wherein the first dataset is populated based on receiving first on-chain data from a blockchain node of a blockchain network, wherein the first on-chain data comprises hexadecimal encoded data from a first block of the blockchain network;
a second dataset, wherein the second dataset is populated based on transforming the first on-chain data in a first format to a second format, wherein the second format comprises a columnar oriented format; and
a multi-layer data platform comprising one or more processors and non-transitory computer-readable media storing instructions that, when executed by the one or more processors, cause operations comprising:
receiving, from a first application, a first query for the first on-chain data of the blockchain network;
determining a first query characteristic of the first query;
determining a first blockchain characteristic of the first on-chain data;
determining, based on the first query characteristic and the first blockchain characteristic, whether the first query can be served by the first dataset or the second dataset;
in response to determining that the first query cannot be served by the first dataset or the second dataset, generating a second query to the blockchain node for the first on-chain data;
receiving, from the blockchain node, a first response to the second query, wherein the first response comprises the first on-chain data; and
transmitting the first on-chain data to the first application.