Supercharge Your Innovation With Domain-Expert AI Agents!

SQL processing engine for blockchain ledger

A blockchain and ledger technology, applied in the field of systems for querying blockchain data, can solve the problems of multiple devices being unable to access at the same time and difficult to retrieve data.

Pending Publication Date: 2020-12-25
GREEN MARKET SQUARE LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, multiple devices cannot access the same block of data at the same time without causing serious problems or risking overwriting stored data
Also, since database storage systems have minimal or no data redundancy, data that is accidentally lost is difficult to retrieve except manually from backup storage

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQL processing engine for blockchain ledger
  • SQL processing engine for blockchain ledger
  • SQL processing engine for blockchain ledger

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] It will be readily appreciated that the components generally described and illustrated in the drawings herein may be arranged and designed in various configurations. Accordingly, the following detailed description of embodiments of at least one of a method, apparatus, non-transitory computer-readable medium, and system, as shown in the accompanying figures, is not intended to limit the scope of the claimed application, but merely represents Selected embodiment.

[0029] The features, structures, or characteristics described throughout this specification may be combined or removed in any suitable manner in one or more embodiments. For example, use of the phrase "exemplary embodiments," "some embodiments," or other similar language throughout this specification refers to the fact that a particular feature, structure, or characteristic described in connection with the embodiments can be included in at least one embodiment . Thus, appearances of the phrases "exemplary emb...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

An example operation may include one or more of receiving a structured query language (SQL) request which applies to a subset of blocks from among blocks stored on a blockchain ledger, storing, in a cache, a portion of the blocks from among the blocks stored on the blockchain ledger, identifying one or more blocks which the SQL request applies to, which are not stored in the cache, and retrievingthe identified one or more blocks not stored in the cache from the blockchain ledger, performing an SQL operation to merge one or more blocks from the cache which the SQL request applies to and the one or more blocks retrieved from the blockchain ledger, and transmitting the merged blocks to a computing system that is associated with the received SQL request.

Description

technical field [0001] The present application generally relates to a system for querying blockchain data, and in particular relates to a SQL processing engine that can use a cache table to store blocks in a blockchain ledger and respond to SQL queries with partial predicate pushdown. Background technique [0002] A centralized database stores and maintains data in a single database (such as a database server) at one location. This location is typically a central computer, such as a desktop central processing unit (CPU), server CPU, or mainframe. Information stored in a centralized database can often be accessed from a number of different points. For example, multiple users or client workstations can work simultaneously on a centralized database based on a client / server configuration. The centralized database is easy to manage, maintain and control due to its single location, especially suitable for security needs. In a centralized database, data redundancy is minimized b...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/2455G06F16/27G06F21/60G06F21/62G06F21/64
CPCG06F21/602G06F21/6227G06F21/64G06F16/24552G06F16/27G06F16/24553G06F16/9024G06F16/221G06F16/24539
Inventor T·J·德安O·博尔宁K·阿拉文德V·阿格拉瓦尔
Owner GREEN MARKET SQUARE LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More