Sybase, Inc.

Mark Delafranier

Anil Kumar Goel

Mihnea Andrei

Anisoara Nica

Steven A Kirk

Rolando Blanco

Ivan T Bowman

David Wein

Muhammed Sharique

Jeffrey J Plager

Vipul Sharma

Systems, methods and computer program product embodiments for providing table parameterized function (TPF) functionality in a database are disclosed herein. An embodiment includes defining a TPF in a database, wherein the definition of the TPF defines one or more parameters of the TPF, at least one of the parameters being a table parameter. A query is received that operates to call the TPF, wherein the query defines one or more input parameters, the input parameters comprising at least one table input parameter to be used as input for calling the TPF. The query is processed to produce a result, and the result of the query is returned.

Table parameterized functions in database

A set-oriented locking based on in-memory bitmap for a column store database is described. An example method includes establishing a column-based in-memory database including a main store and a delta store, where the delta store has a plurality of row-visibility lock bitmaps visible to transactions at various points in time. The lock bitmaps represent a bit encoding to indicate whether there are granted row locks tables in the database. A delete or an update statement is executed with a transaction on a table. A set of row locks on rows of the table manipulated by the delete or the update statement are requested to preclude other transactions from currently deleting or updating the same rows. Accordingly, set operations are performed on the lock bitmap to manage the set of row locks associated with the transaction.

Set-oriented locking based on in-memory bitmaps for a column-oriented database

Growing community of inventors

Waterloo, Canada

Mark Delafranier