Unlock instant, AI-driven research and patent intelligence for your innovation.

Set-oriented visibility state retrieval scheme

A state and row state technology, applied in the field of set-oriented visibility state retrieval scheme, can solve problems such as high transaction cost

Inactive Publication Date: 2016-06-01
SAP AG
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, for analytical queries that may need to access a large number of rows in a table or all rows in a table, this row-oriented VSR operation incurs a high transaction cost because it is done for each row one by one

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
  • Set-oriented visibility state retrieval scheme
  • Set-oriented visibility state retrieval scheme
  • Set-oriented visibility state retrieval scheme

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] Provided herein are systems, methods, and / or computer program products, and / or combinations and subcombinations thereof, for determining a row visibility state.

[0013] figure 1 is a block diagram of a database system 100 for determining row visibility status according to an example embodiment. Database system 100 includes database management system 140 and client 110 in communication with DBMS 140 . DBMS 140 may be a system that runs on a server and is accessible to client 110 over a network, such as network 120, as described below. Although client 110 is in figure 1 is represented as a separate physical machine from DBMS 140, but this is represented by way of example and not limitation. In another embodiment, client 110 and DBMS 140 occupy the same physical system. In yet another embodiment, client 110 is a software application that needs to access DBMS 140 . Client 110 can request access to DBMS 140 . Additionally, both client 110 and DBMS 140 can operate on c...

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

Disclosed herein are system, method, and computer program product embodiments for determining row visibility states. An embodiment operates by initializing a result bitmap for rows based on visible row state values of row state bitmaps corresponding to the rows, wherein values of the result bitmap indicate whether the row are visible or not visible; determining one or more rows whose corresponding visible row state values indicate that the one or more rows are not visible; and determining whether to update the result bitmap to indicate that the one or more rows are visible based on one or more versioned row state values, wherein the one or more versioned row state values indicate whether the corresponding rows are not visible or possibly visible.

Description

technical field [0001] The present invention relates to visibility state retrieval (VSR), in particular to a set-oriented visibility state retrieval scheme. Background technique [0002] Visibility State Retrieval (VSR) operations are used to decide whether one or more specified rows should be visible for a given query. In database systems whose transaction processing is based on multiversion concurrency control (MVCC) or snapshot isolation, the visibility of a given row for a given query is typically based on when the row was most recently modified and when the query started Decide. Typically, the state of the rows that need to be checked for a query is traversed individually one by one. However, for analytical queries that may need to access a large number of rows in a table or all rows in a table, such row-oriented VSR operations incur a high transaction cost because this is done for each row one by one. Contents of the invention [0003] According to an aspect of th...

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
CPCG06F16/90335G06F16/90328G06F16/24542G06F16/23G06F16/2282G06F16/2322G06F16/2474
Inventor J.李M.安德雷C.弗洛伦多I.施雷特A.K.戈尔
Owner SAP AG