Mark Delafranier is a notable inventor based in Waterloo, Canada. He has made significant contributions to the field of database technology, holding 2 patents that showcase his innovative approach to solving complex problems in data management.

Latest Patents

One of Mark's latest patents is titled "Table parameterized functions in database." This invention discloses systems, methods, and computer program product embodiments for providing table parameterized function (TPF) functionality in a database. 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.

Another significant patent is "Set-oriented locking based on in-memory bitmaps for a column-oriented database." This invention describes a set-oriented locking mechanism based on in-memory bitmaps for a column store database. 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 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.

Career Highlights

Mark Delafranier is currently employed at Sybase, Inc., where he continues to develop innovative solutions in database technology. His work has significantly impacted the efficiency and functionality of database systems.

Collaborations

Mark has collaborated with notable colleagues such as Anil Kumar Goel and Anisoara Nica, contributing to a dynamic work environment that fosters innovation and creativity.

Conclusion

Mark Delafranier is a distinguished inventor

This text is generated by artificial intelligence and may not be accurate.

Please report any incorrect information to [email protected]