Microsoft Technology Licensing, LLC

Kwanghyun Park

Jignesh Patel

Nikhil Teletia

Jae Young Do

Cesar Alejandro Galindo-Legaria

Yuan Yu

Conor J Cunningham

Alan D Halverson

Carlo Aldo Curino

Rathijit Sen

Subramaniam Venkatraman Krishnan

Raghunath Ramakrishnan

Konstantinos Karanasos

Karthik Saligrama Ramachandra

Matteo Interlandi

Markus Weimer

Fotios Psallidas

Kameswara Venkatesh Emani

Ivan Popivanov

Doris Suiyi Xin

Karla Jean Saur

The description relates to executing an inference query relative to a database management system, such as a relational database management system. In one example a trained machine learning model can be stored within the database management system. An inference query can be received that applies the trained machine learning model on data local to the database management system. Analysis can be performed on the inference query and the trained machine learning model to generate a unified intermediate representation of the inference query and the trained model. Cross optimization can be performed on the unified intermediate representation. Based upon the cross-optimization, a first portion of the unified intermediate representation to be executed by a database engine of the database management system can be determined, and, a second portion of the unified intermediate representation to be executed by a machine learning runtime can be determined.

Query processing with machine learning

Replicating a primary application cache that serves a primary application on one network node into a secondary application cache that serves a secondary application on a second network node. Cache portions that are within the primary application cache are identified, and then identifiers (but not the cache portions) are transferred to the second network node. Once these identifiers are received, the cache portions that they identify may then be retrieved into the secondary application caches. This process may be repeatedly performed such that the secondary application cache moves towards the same state as the primary application cache though the state of the primary application cache also changes as the primary application operates by receiving read and write requests.

Application cache replication to secondary application(s)

Processing a database query. A method includes receiving a database query from a user. The database query includes one or more imperative functions. The one or more imperative functions are converted to one or more declarative query representations. The one or more declarative query representations include standardized relational operators included in a relational query language. Further, the one or more declarative query representations are optimizable by a query optimizer of the database. The database query is optimized at the query optimizer to create a query plan by evaluating any declarative query representation originally in the database query received from the user and the one or more declarative query representations.

Method for optimization of imperative code executing inside a relational database engine

Replicating a primary application cache within a secondary application cache

The automated recovery of the warmth of cache of an application that has been subject to a running state change that degraded the warmth of the cache. To prepare for a loss in warmth, the cache portion identifiers are captured, and corresponding cache portions are stored in an external store. Thereafter, the application experiences changes in state. In order to warm the application cache more quickly, cache portions identified by the captured cache portion identifiers are retrieved from the external data store and placed in the application cache.

Automatic recovery of application cache warmth

The automated recovery of the warmth of cache of an application that has been subject to a running state change that degraded the warmth of the cache. To prepare for a loss in warmth, the state of a cache portion identifiers are captured. Such identifies the cache portions that are within the application cache at an instant in time. Thereafter, the application experiences a change in running state that diminishes the warmth of the application cache. For instance, the application might be stopped and restarted. After and despite this cache degradation, the application may continue to operate. However, in order to warm the application cache more quickly, while the application is operating, the application cache is automatically warmed. For instance, while the application is operating, cache portions identified by the captured cache portion identifiers are automatically accessed from a source that is external to the application cache.

Growing community of inventors

Madison, WI, United States of America

Kwanghyun Park