-
公开(公告)号：US10169595B2
公开(公告)日：2019-01-01
申请号：US15160977
申请日：2016-05-20
摘要： Systems, methods, and computer program products to perform an operation comprising identifying a first access to a first subset of a first database table on a first storage node, of a plurality of storage nodes, identifying a second access to a second subset of the first database table on a second storage node, of the plurality of storage nodes, and performing a predefined operation to restrict access to the first database table on the plurality of storage nodes based on the first and second accesses.
-
公开(公告)号：US10114826B2
公开(公告)日：2018-10-30
申请号：US14312673
申请日：2014-06-23
IPC分类号： G06F17/30
摘要： A database table is monitored to automatically determine its volatility, and at least one volatility attribute expressing volatility state is saved. The volatility attribute is used to manage the database, e.g., to determine an optimum query execution strategy for a query involving data in the table, and/or for determining whether to re-optimize a previously saved query execution strategy and/or for managing storage and retrieval of table data. Preferably, parameters of the database table are captured at regular sampling intervals and a figure of merit representing volatility is computed from the parameter values. Preferably, the database supports the SQL database language, and the volatility attribute is or includes the SQL VOLATILE attribute. In an additional embodiment, the database manager may express volatility of a database table as a value within a range.
-
公开(公告)号：US10108665B2
公开(公告)日：2018-10-23
申请号：US14734503
申请日：2015-06-09
摘要： A first database management system (DBMS) running on first computer having a first set of computing resources determines that with respect to the first set of computing resources a first query access plan for executing a query satisfies a set of query optimization criteria. A determination is then made that with respect to a second set of computing resources the first query access plan fails a set of preliminary criteria. In response to this failure determination, a second query access plan for executing the query is generated. Prior to having a second DBMS running on a second computer having the second set of computing resources receive a request to execute the query, a determination is made that with respect to the second set of computing resources the second query access plan satisfies the set query optimization criteria.
-
公开(公告)号：US10061811B2
公开(公告)日：2018-08-28
申请号：US14869476
申请日：2015-09-29
发明人： Bin Cao , Jessica R. Eidem , Brian R. Muras , Jingdong Sun
CPC分类号： G06F16/24568 , G06F11/3034 , G06F11/3041 , G06F11/3409 , G06F16/2453 , G06F16/24542 , G06F16/24544 , G06F16/24554 , G06F16/26 , G06F16/35 , G06F16/9535
摘要： Embodiments of the preset disclosure include a method, a system, and a computer program product for rearranging a set of filters within a data streams environment. The method includes setting a first filter ordering of two or more filter processing elements. The method includes determining a filtering efficiency of the first filter ordering. The determining of the filtering efficiency includes monitoring a runtime, one or more tuples, and an amount of tuples retained after filtering of the first filter ordering. The method includes creating a second filter ordering of the two or more filter processing elements. The method includes comparing the filtering efficiency of the second filter ordering to the first filter ordering. The method includes selecting the second filter ordering in response to comparing the filtering efficiency of the second filter ordering to the filtering efficiency of the first filter ordering.
-
公开(公告)号：US10055459B2
公开(公告)日：2018-08-21
申请号：US14935896
申请日：2015-11-09
IPC分类号： G06F17/30
CPC分类号： G06F16/24545 , G06F16/2453 , G06F16/24542 , G06F16/24544 , G06F16/24549 , G06F16/24565
摘要： Disclosed aspects relate to query hint management for a database management system. With respect to a hint for a query, a set of hint profile data is established. The database management system detects a triggering event. Based on the set of hint profile data, the database management system determines to perform a hint action in response to the triggering event. Performance of the hint action is initiated.
-
公开(公告)号：US10025824B2
公开(公告)日：2018-07-17
申请号：US14722950
申请日：2015-05-27
发明人： Bin Cao , Jessica R. Eidem , Brian R. Muras , Jingdong Sun
摘要： Embodiments of the preset disclosure include a method, a system, and a computer program product for rearranging a set of filters within a data streams environment. The method includes setting a first filter ordering of two or more filter processing elements. The method includes determining a filtering efficiency of the first filter ordering. The determining of the filtering efficiency includes monitoring a runtime, one or more tuples, and an amount of tuples retained after filtering of the first filter ordering. The method includes creating a second filter ordering of the two or more filter processing elements. The method includes comparing the filtering efficiency of the second filter ordering to the first filter ordering. The method includes selecting the second filter ordering in response to comparing the filtering efficiency of the second filter ordering to the filtering efficiency of the first filter ordering.
-
公开(公告)号：US10025821B2
公开(公告)日：2018-07-17
申请号：US14751237
申请日：2015-06-26
IPC分类号： G06F17/30
摘要： A computer-implemented method for determining a query execution plan based on transaction state may include determining that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state. In response to the determining, the first set of database values may have a first set of statistics generated and the second set of database values may have a second set of statistics generated. The first and second set of statistics may be for use in determining a query execution plan.
-
公开(公告)号：US10002170B2
公开(公告)日：2018-06-19
申请号：US15280043
申请日：2016-09-29
IPC分类号： G06F17/30
CPC分类号： G06F16/248 , G06F16/221 , G06F16/2237 , G06F16/2264 , G06F16/2272 , G06F16/2282 , G06F16/2443 , G06F16/245 , G06F16/951
摘要： A method for managing a database is disclosed. Managing the database includes managing a table of the database, the table having a set of fields including a first field in a first row of the table. Managing the table includes selecting, in the first field, a first input value configured to identify a first dynamic data function utilized to determine a first output value for the first field. Managing the table includes determining the first output value for the first field using the first dynamic data function. Managing the table includes returning (for a read request) the first output value for the first field.
-
公开(公告)号：US20180107958A1
公开(公告)日：2018-04-19
申请号：US15294461
申请日：2016-10-14
CPC分类号： G06Q10/0637 , G06Q10/06315 , G06Q20/0658 , G06Q20/382 , G06Q2220/00
摘要： A blockchain configuration may require constant and large amounts of resources to maintain a growing structure. One example method of operation may include receiving blockchain transactions and creating a blockchain block, identifying miner devices to process the blockchain block, identifying expenses associated with each of the miner devices, selecting an optimal cost miner device among the miner devices based on the identified expenses associated with each of the miner devices, and assigning the optimal cost miner device to solve the blockchain block.
-
公开(公告)号：US20180095780A1
公开(公告)日：2018-04-05
申请号：US15809031
申请日：2017-11-10
CPC分类号： G06F9/45558 , G06F8/60 , G06F8/63 , G06F2009/45562 , G06F2009/45583
摘要： 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.
-
-
-
-
-
-
-
-
-
搜索结果
305 条记录 (耗时 0.035 秒)
