International Business Machines Corporation

Jing Jing Liu

Zan Zhou

Chen Wang

Sheng Zhao

Fu Fei Xu

Guang Zhou Zhang

Lei Qiu

Jing Wang

Wei Sun

Peng Hui Jiang

Zhi Hu Wang

Ning Duan

Wei Peng Huang

Xiao Bo Li

Yun Zheng

Xin Tang

DaJiang Tao

A database is selected from a plurality of databases included in the distributed database cluster. A shard map of the database is acquired, wherein the shard map includes a distribution of a plurality of shards on the plurality of nodes, and one or more nodes of the plurality of nodes each includes at least one shard of an old version of the database to be upgraded to a new version. A sustainable serviceability of the database corresponding to each of the one or more nodes is predicted according to the shard map based on the assumption that the at least one shard of each of the one or more nodes has been upgraded from the old version to the new version.

Database upgrade in a distributed database cluster

Embodiments relate to an eigenvalue-based data query. An aspect includes receiving a query request that includes a query statement. Another aspect includes calculating eigenvalues of key component elements in the query statement. Another aspect includes matching eigenvalues of nodes in an execution plan of a historical query statement to the eigenvalues of the key component elements. Yet another aspect includes based on determining success of matching the eigenvalues of the key component elements to the eigenvalues of the nodes in an execution plan of the historical query statement, generating an execution plan of the query statement.

Eigenvalue-based data query

An index for large databases is disclosed. Data is grouped into clusters and the clusters are grouped into levels of detail. Analysis results are determined based on progressive data sampling. Sampling is conducted based on the level of detail required and/or the resources (time or computing resources) that are available. Larger, more concentrated clusters, at higher levels of detail, are sampled more sparsely. Smaller, more diffuse clusters, at lower levels of detail, are sampled more intensively. Analysis results, including outlier data, include proportional representation from the whole database up to the level of detail required. Results are quickly determined with specified degree of accuracy, based on initial sampling, and are refined with subsequent sampling.

Database index for constructing large scale data level of details

A mechanism is provided for controlling the internal air-quality of a vehicle. Responsive to determining that a speed of a vehicle fails to be above the predetermined low-speed threshold, a determination is made as to whether an internal air-quality from an internal air-quality sensor is better than the external air-quality from an external air-quality sensor. Responsive to the internal air-quality being better than the external air-quality, a ventilation control mechanism is signaled to utilize a recirculating-air mode, wherein the ventilation control mechanism either stays in an already initiated recirculation-air mode or switches to the recirculating-air mode. Responsive to the internal air-quality being worse than the external air-quality, the ventilation control mechanism is signaled to utilize a fresh-air mode, wherein the ventilation control mechanism either stays in an already initiated fresh-air mode or switches to the fresh-air mode.

Intelligent automotive air-quality assessment and management

Growing community of inventors

Beijing, China

Jing Jing Liu