International Business Machines Corporation

Wisconsin Alumni Research Foundation

Pivotal Software, Inc.

Navneet Sankara Potti

Fatma Ozcan

Avrilia Floratou

Nimrod Megiddo

Jignesh Patel

Uday B Kale

Mir Hamid Pirahesh

Rogers Jeffrey Leo John

Methods, systems, and computer program products for accelerate database through runtime code generation are described. A system provides a library of transformation functions that each transform an original function in an intermediate representation into a transformed function in the intermediate representation. The system receives a query. The system obtains an original database function used to execute the query, the original database function being in the intermediate representation. The system generates a new function that is a query specialized version of the original database function. The system generates a result for the query, including executing the new function instead of the original database function.

Database acceleration through runtime code generation

A computer-implemented method according to one embodiment includes receiving a request for data, locating the data at one or more partitions of a heterogeneously partitioned table, determining an access method associated with each of the one or more partitions, and requesting the data from the one or more partitions, utilizing the access method associated with each of the one or more partitions.

Accessing tables with heterogeneous partitions

In one embodiment, a computer-implemented method includes inserting a set of accessed objects into a cache, where the set of accessed objects varies in size. An object includes a set of object components, and responsive to receiving a request to access the object, it is determined that the object does not fit into the cache given the set of accessed objects and a total size of the cache. A heuristic algorithm is applied, by a computer processor, to identify in the set of object components one or more object components for insertion into the cache. The heuristic algorithm considers at least a priority of the object compared to priorities of one or more objects in the set of accessed objects. The one or more object components are inserted into the cache.

Caching policies for selection and replacement of objects

Domain specific programming is facilitated through the use of a conversational interface using natural language commands from the user and natural language cues to the user. The natural language conversation provides the actual program and thus can be saved and edited for future use.

Growing community of inventors

Madison, WI, United States of America

Navneet Sankara Potti