International Business Machines Corporation

Jason Alexander Cu

Guogen Zhang

Mengchu Cai

Yun Yu Wang

Fen-Ling Lin

Li-Mey P Lee

Allan Benjamin Lebovitz

Yao Ching Stephen Chen

Yao-Ching Stephen Chen

Andrei Fedorovich Lurie

Christopher John Crone

Yue Huang

A method and system for utilizing a column function for a relational database in a structure query language (SQL) environment is disclosed. The column function is capable of performing an operation on an indeterminate number of entries. The relational database utilizes data including a plurality of entries capable of being organized into at least one column and at least one row. The method and system include allowing a user to specify the at least one row as an argument for a generalized scalar function and simulating a column environment for the at least one row using the generalized scalar function to allow the at least one row to be provided to the column function as though the at least one row was a column. The method and system also include performing the column function on the at least one row to provide at least one output.

Method and system for utilizing a generic scalar function to allow a column function to operate on row data

Disclosed is method for processing an aggregate function. Rows that contain a reference to intermediate result structures are grouped to form groups. For each group, aggregate element structures are formed from the intermediate result structures and, if the aggregate function specifies ordering, the aggregate element structures are sorted based on a sort key.

Optimizing aggregate processing

Disclosed is a method, system, and program for processing an aggregate function. Rows that contain a reference to intermediate result structures are grouped to form groups. For each group, aggregate element structures are formed from the intermediate result structures and, if the aggregate function specifies ordering, the aggregate element structures are sorted based on a sort key.

Method, system, and program for optimizing aggregate processing

Disclosed is a method, system, and program for processing a function. A set of nested functions are received. A composite function is generated for the set of nested functions. A tagging template is generated for the set of nested functions that corresponds to the composite function. A result is produced by evaluating the composite function using the tagging template.

Method, system, and program for optimizing processing of nested functions

In one embodiment, at least a portion of an object model having at least one namespace is serialized. An ancestor namespace is searched for based on a current namespace declaration. The ancestor namespace is associated with an ancestor prefix and an ancestor uniform resource indicator (URI). The current namespace is associated with a current prefix and current URI. The search is performed to find an ancestor prefix matches the current prefix. When the current namespace is an implicit no default namespace and the ancestor namespace is an explicit default namespace based on, at least in part, the ancestor prefix, a serialized namespace declaration is generated for the current namespace.

Growing community of inventors

San Jose, CA, United States of America

Jason Alexander Cu