Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Maintenance of active database queries

A database, active technology, applied in the field of database query

Active Publication Date: 2015-08-19
INFOR US LLC
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Again resulting in a lot of useless work

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
  • Maintenance of active database queries
  • Maintenance of active database queries
  • Maintenance of active database queries

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0014] Exemplary embodiments relate to resolving conflicts between active database transactions using incremental maintenance processing. To improve database performance, materialized views are used to store the results of subqueries. Embodiments described herein avoid having to recompute a materialized view from scratch after each database update by using an incremental view maintenance process that updates the materialized view with tracking information generated during the initial materialization of the view. view.

[0015] Embodiments described herein resolve conflicts between active transactions by using incremental maintenance processing. When a transaction (T1) commits and updates a data item required by the active transaction (T2) (eg, writes a new value or deletes the data item), T2 is marked for maintenance on the change. Before T2 completes, the incremental maintenance process modifies the execution of T2 according to all changes made to required items by the comm...

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 aspect includes a method for maintaining active queries. The method includes executing a query based on data items in at least two relations in a database. The executing includes outputting a query result and control information associated with the query. The query result and the control information are recorded. A notification that at least one of the data items has been updated subsequent to the executing is received. The query result is modified, responsive to the control information, to reflect the data items that were updated subsequent to the executing.

Description

[0001] Cross References to Related Applications [0002] This application claims the benefit of US Application No. 13 / 722067, filed December 20, 2012, the entire contents of which are incorporated herein by reference. Background technique [0003] The present invention relates to database queries, and more particularly to the maintenance of proactive database queries. [0004] Database management systems enable users to store and update large amounts of information, while also supporting queries for that information. Ideally, queries return answers that reflect the latest data in the database. However, long-running queries or transactions may need to process data that other parallel transactions are trying to update. [0005] Several existing concurrency control techniques attempt to manage such conflicting updates. For example, lock-based techniques can be utilized to prevent multiple transactions from gaining access to conflicting data items by making conflicting transact...

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): G06F17/30
CPCG06F17/30424G06F16/2308G06F16/24539G06F16/245G06F16/2379G06F16/24537
Inventor 托德·L·费尔德赫伊曾
Owner INFOR US LLC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com