-
公开(公告)号: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.
-
公开(公告)号: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.
-
公开(公告)号:US10394790B2
公开(公告)日:2019-08-27
申请号:US15227988
申请日:2016-08-04
发明人: Brian R. Muras
IPC分类号: G06F17/30 , G06F16/22 , G06F16/245 , G06F16/2453
摘要: 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.
-
公开(公告)号:US10361930B2
公开(公告)日:2019-07-23
申请号:US15886463
申请日:2018-02-01
发明人: Bin Cao , Jessica R. Eidem , Brian R. Muras , Jingdong Sun
IPC分类号: H04L12/26 , H04L9/00 , G06F16/2455 , H04L12/24 , G06F9/455
摘要: A streams manager monitors performance of a streaming application and determines if operators are underperforming according to a threshold. When the performance needs to be improved, the streams manager automatically modifies the flow graph to offload or reroute a stream of data, or part of a stream of data, to a similar operator to more efficiently utilize streaming resources. Operators are provided with multiple ports to allow the streams manager to send additional streams to the operator.
-
公开(公告)号:US10353864B2
公开(公告)日:2019-07-16
申请号:US14582175
申请日:2014-12-23
摘要: A respective volatility attribute associated with each of one or more tables of a computerized database is used to determine circumstances under which a page of table data is paged out of memory, by preferentially retaining pages from volatile database tables in memory. 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.
-
公开(公告)号:US10303674B2
公开(公告)日:2019-05-28
申请号:US15172451
申请日:2016-06-03
发明人: Brian R. Muras
IPC分类号: G06F17/30 , G06F16/22 , G06F16/245 , G06F16/2453
摘要: 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.
-
公开(公告)号:US10223542B2
公开(公告)日:2019-03-05
申请号:US14565540
申请日:2014-12-10
摘要: Systems, methods, and computer program products to perform an operation comprising upon determining that a received query requests values of sensitive data stored in a secure database table of a database, computing a security score for the received query based on a determined specificity of a selection predicate of the received query, and upon determining that the security score exceeds a security threshold, performing a predefined operation to restrict access to the requested values of the sensitive data.
-
公开(公告)号: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.
-
公开(公告)号:US10152509B2
公开(公告)日:2018-12-11
申请号:US14863425
申请日:2015-09-23
摘要: 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.
-
公开(公告)号:US20180276684A1
公开(公告)日:2018-09-27
申请号:US15623940
申请日:2017-06-15
CPC分类号: G06Q30/0185 , G06F7/02 , G06F7/026 , G06F16/243 , G06F16/24575 , G06F16/254 , G06F17/2705 , G06F17/2735 , G06F17/278 , G06F2207/025
摘要: Aspects include obtaining a pattern that describes an event in a natural language format. The pattern that describes the event is converted into at least one identified pattern key value pair. A database transaction is monitored and converted into a least one database transaction key value pair. A similarity score is calculated by scoring similarities between the identified pattern key value pair(s) and the database transaction key value pair(s). Based on similarity score meeting a threshold, an alert is output to indicate that the database transaction matches the pattern that describes the event.
-
-
-
-
-
-
-
-
-