17643235. REDUCED LATENCY QUERY PROCESSING simplified abstract (INTERNATIONAL BUSINESS MACHINES CORPORATION)

From WikiPatents
Jump to navigation Jump to search

REDUCED LATENCY QUERY PROCESSING

Organization Name

INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor(s)

Daniel Martin of Leinfelden-Echterdingen (DE)

Sowmya Kameswaran of San Jose CA (US)

Vassil Radkov Dimov of Stuttgart (DE)

Christian Michel of Sindelfingen (DE)

Manogari Nogi Simanjuntak of San Jose CA (US)

REDUCED LATENCY QUERY PROCESSING - A simplified explanation of the abstract

This abstract first appeared for US patent application 17643235 titled 'REDUCED LATENCY QUERY PROCESSING

Simplified Explanation

The abstract describes a method, computer program products, and systems for optimizing database queries by selecting the most efficient accelerator database system for execution. The primary database system is associated with two accelerator database systems, and modifications made to the primary database system are replicated into both accelerators. The method involves examining latency data to determine which accelerator has replicated the modifications to a specific table faster. Based on this examination, the first accelerator database system is selected for executing the query statement, and the query is routed to that system.

  • The method optimizes database queries by selecting the most efficient accelerator database system for execution.
  • The primary database system is associated with two accelerator database systems.
  • Modifications made to the primary database system are replicated into both accelerator systems.
  • Latency data is examined to determine which accelerator has replicated the modifications faster.
  • The first accelerator database system is selected for executing the query statement.
  • The query statement is routed to the selected accelerator database system for execution.

Potential applications of this technology:

  • Database optimization: This technology can be used to improve the performance and efficiency of database queries by selecting the most suitable accelerator database system for execution.
  • Big data processing: With the increasing volume of data, this technology can help optimize the processing of large datasets by selecting the most efficient accelerator system.
  • Real-time analytics: By selecting the fastest accelerator system, this technology can enhance the speed and responsiveness of real-time analytics applications.

Problems solved by this technology:

  • Inefficient query execution: Traditional database systems may not always select the most efficient accelerator system for executing queries, leading to slower performance.
  • Latency issues: Replicating modifications to multiple accelerator systems can introduce latency, and this technology helps identify the system with the lowest latency for query execution.

Benefits of this technology:

  • Improved query performance: By selecting the most efficient accelerator system, this technology can significantly enhance the speed and efficiency of database queries.
  • Reduced latency: The examination of latency data ensures that the query is routed to the accelerator system with the lowest latency, minimizing delays in query execution.
  • Enhanced scalability: The ability to replicate modifications to multiple accelerator systems allows for improved scalability and handling of large datasets.


Original Abstract Submitted

Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: receiving by primary database system a query statement that references a first table, wherein the primary database system is associated to a first accelerator database system and a second accelerator database system, wherein modifications performed on tables of the primary database system are iteratively replicated into the first accelerator database system and the second accelerator database system; examining latency data that specifies a latency with which a modification to the first table has been replicated into the first accelerator database system and a latency with which a modification to the first table has been replicated into the second accelerator database system; selecting, in dependence on the examining, the first accelerator database system for execution of the query statement; routing the query statement to the first accelerator database system for execution in response to the selecting.

Retrieved from "http://wikipatents.org/index.php?title=17643235._REDUCED_LATENCY_QUERY_PROCESSING_simplified_abstract_(INTERNATIONAL_BUSINESS_MACHINES_CORPORATION)&oldid=25708"