Teradata Us, Inc.

Mohamed Yassin Eltabakh

Mohammed Yassin Al-Kateb

Awny Kayed Al-Omari

Sanjay Nair

Robert Matthew Wehrmeister

Kashif Abdullah Siddiqui

Mahbub Hasan

B Anantha Subramanian

Paul Laurence Sinclair

Grace Kwan-On Au

Christina Pavlopoulou

A database system receives a request from a user. The request invokes a data set function (DSF) and uses a property to be provided by the DSF. The database system determines that a function descriptor is available for the DSF. The function descriptor is expressed as markup language instructions. The function descriptor defines the property of the DSF. The database system uses the function descriptor to define a property for the DSF.

Enabling cross-platform query optimization via expressive markup language

Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable. A determination is made that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. A determination is made to change an order of the join operation from the plurality of AF properties and query-level properties.

Optimizing the execution order between analytical functions and joins in SQL queries

One or a soft correlation of a database can be adjusted (e.g., modified, replaced, overwritten) for use with respect to one or more record(s) of the database associated with the soft correlation, by considering at least one or more violations of the soft correlations in the one or more of records database records associated with the soft correlation. In addition, an adjusted soft correlation can be stored and used for optimizations of database queries pertaining to one or more records associated with the adjusted soft correlation. Typically, the adjusted soft correlation is adjusted by at least considering the violations of an original soft correlation in the one or more records relating to the database queries.

Management of soft correlation for databases and optimization of database queries

Growing community of inventors

Worcestor, MA, United States of America

Mohamed Yassin Eltabakh