Row identification column authorization profiles
AssigneeSap SE
InventorFrank Benkstein
Life of this patent
Estimating the term…
Abstract
Tables in a database can include an internal RowID column. For each new row or new version of a row in the table, a new RowID can be assigned and stored in the RowID column. RowID values can be stored using either or both of range compression and block compression, or other compression approaches. In response to receipt of a query of the database table, at least one of a forward look up and a reverse lookup of a DocID value associated with a specific RowID value can be performed.
Claims20
A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
- assigning, to at least one of a new row and a new version of a row added to a database table, a RowID value comprising a sequential integer value;
- storing the RowID value in a RowID column of the database table;
- compressing the RowID column according to a compression approach;
- accessing the RowID column in response to receipt of a query of the database table to perform at least one of a forward lookup and a reverse lookup of a DocID associated with a specific RowID value, the DocID value comprising a numerical identifier associated with at least one of a document and a value associated with the row of the database table corresponding to the specific RowID value;
- returning, based on the least one of the forward lookup and the reverse lookup, at least one of the specific RowID or the DocID associated with the RowID.
A system comprising:
- at least one programmable processor;
- a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
- assigning, to at least one of a new row and a new version of a row added to a database table, a RowID value comprising a sequential integer value;
- storing the RowID value in a RowID column of the database table;
- compressing the RowID column according to a compression approach;
- accessing the RowID column in response to receipt of a query of the database table to perform at least one of a forward lookup and a reverse lookup of a DocID associated with a specific RowID value, the DocID value comprising a numerical identifier associated with at least one of a document and a value associated with the row of the database table corresponding to the specific RowID value;
- returning, based on the least one of the forward lookup and the reverse lookup, at least one of the specific RowID or the DocID associated with the RowID.
A computer-implemented method comprising:
- assigning, to at least one of a new row and a new version of a row added to a database table, a RowID value comprising a sequential integer value;
- storing the RowID value in a RowID column of the database table;
- compressing the RowID column according to a compression approach;
- accessing the RowID column in response to receipt of a query of the database table to perform at least one of a forward lookup and a reverse lookup of a DocID associated with a specific RowID value, the DocID value comprising a numerical identifier associated with at least one of a document and a value associated with the row of the database table corresponding to the specific RowID value;
- returning, based on the least one of the forward lookup and the reverse lookup, at least one of the specific RowID or the DocID associated with the RowID.
Dependencies are inferred from the claim text.