Dynamically deployed virtual machine

    公开(公告)号:US10545781B2

    公开(公告)日:2020-01-28

    申请号:US15809031

    申请日:2017-11-10

    摘要: A virtual machine data handling system includes a data handling system, a hypervisor, and a dynamically deployed virtual machine. The data handling system includes a plurality of physical computing resources (e.g., a processor and a memory). The hypervisor is implemented by the processor and the memory and deploys virtual machines from a master image. The dynamically deployed virtual machine is initially deployed by the hypervisor as a Linked Clone of the master image. The dynamically deployed virtual machine is subsequently dynamically deployed by the hypervisor copying a plurality of virtual memory segments from the master image until the dynamically deployed virtual machine is an independent Full Clone of the master image. The hypervisor may copy the plurality of virtual memory segments from the master image if at least one of the physical resources is operating below a utilization threshold.

    Query restart based on changing system resources and an amount of data change

    公开(公告)号:US10409812B2

    公开(公告)日:2019-09-10

    申请号:US15384595

    申请日:2016-12-20

    IPC分类号: G06F16/00 G06F16/2453

    摘要: Techniques are described for re-starting queries based on an expected amount of data to be changed in a database. Embodiments of the present disclosure may generally receive a first query to be executed against a database, and start execution of the first query against the database according to a first access plan. Upon detecting, during execution of the first query, that an amount of data to be changed in one or more tables of the database as a result of a second query satisfies a predetermined condition, embodiments of the present disclosure determine whether to re-start execution of the first query against the database with a second access plan different from the first access plan or wait a predetermined period of time before re-starting execution of the first query against the database with the first access plan.

    Table organization using one or more queries

    公开(公告)号:US10394790B2

    公开(公告)日:2019-08-27

    申请号:US15227988

    申请日:2016-08-04

    发明人: Brian R. Muras

    摘要: A method, system and computer program product are provided for reorganizing a database table according to a set of queries. More specifically, the table is reorganized such that random I/O is reduced by more tightly grouping together rows in the table associated with each of the referencing queries. This enables more associated rows from a given table relevant to a query to be read into memory for a given I/O operation.

    Table organization using one or more queries

    公开(公告)号:US10303674B2

    公开(公告)日:2019-05-28

    申请号:US15172451

    申请日:2016-06-03

    发明人: Brian R. Muras

    摘要: A method, system and computer program product are provided for reorganizing a database table according to a set of queries. More specifically, the table is reorganized such that random I/O is reduced by more tightly grouping together rows in the table associated with each of the referencing queries. This enables more associated rows from a given table relevant to a query to be read into memory for a given I/O operation.

    Managing a computerized database using a volatile database table attribute

    公开(公告)号:US10216741B2

    公开(公告)日:2019-02-26

    申请号:US14582167

    申请日:2014-12-23

    IPC分类号: G06F17/30

    摘要: A respective volatility attribute associated with each of one or more tables of a computerized database is used in any of various aspects to (a) determine how table data is stored in a physical storage device; (b) regulate the use of a materialized query table using database table data; and/or (c) influence circumstances under which indexes are created or advised by database analytic software. Various optional additional uses of a volatility attribute to manage a database are disclosed. Preferably, database parameters are automatically monitored over time and database table volatility state is automatically determined and periodically adjusted.

    Query hint learning in a database management system

    公开(公告)号:US10152509B2

    公开(公告)日:2018-12-11

    申请号:US14863425

    申请日:2015-09-23

    IPC分类号: G06F17/30 G06F17/27 G06N99/00

    摘要: Disclosed aspects relate to query hint learning in a database management system. A hint in a first query is detected by the database management system. The first query has a first signature. A second query is received by the database management system. The second query has a second signature. A determination is made by the database management system that the second signature correlates with the first signature. A query plan is established by the database management system. The query plan is based on the second query and uses the hint in the first query. In response to receiving the second query, the database management system processes the query plan.