-
公开(公告)号：US10552847B2
公开(公告)日：2020-02-04
申请号：US15467081
申请日：2017-03-23
IPC分类号： G06F16/00 , G06Q30/00 , G06F7/02 , G06F16/242 , G06F16/25 , G06F16/2457 , G06F17/27
摘要： 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.
-
公开(公告)号：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.
-
公开(公告)号：US20170147672A1
公开(公告)日：2017-05-25
申请号：US14951974
申请日：2015-11-25
摘要： Technical solutions are described for determining data replication cost for a data server. In an example, a method for estimating the data replication cost includes receiving an identification of a source table and an identification of a target table for the data replication. The method further includes receiving a selection of a data replication scheme to be used to replicate the data. A costing system that implements the method determines the data replication cost, based on a conversion cost for conversion of the data from the source table to the target table, and a transfer cost for transfer of the data from the source table to the target table. The costing system communicates the data replication cost to an administrator.
-
4.发明授权Dynamically associating different query execution strategies with selective portions of a database table 有权动态地将不同的查询执行策略与数据库表的选择性部分相关联公开(公告)号：US09063982B2
公开(公告)日：2015-06-23
申请号：US13748670
申请日：2013-01-24
CPC分类号： G06F17/3053 , G06F17/30545
摘要： A query facility for database queries dynamically determines whether selective portions of a database table are likely to benefit from separate query execution strategies, and constructs an appropriate separate execution strategies accordingly. Preferably, the database contains at least one relatively large table comprising multiple partitions, each sharing the definitional structure of the table and containing a different respective discrete subset of the table records. The query facility compares metadata for different partitions to determine whether sufficiently large differences exist among the partitions, and in appropriate cases selects one or more partitions for separate execution strategies. Preferably, partitions are ranked for separate evaluation using a weighting formula which takes into account: (a) the number of indexes for the partition, (b) recency of change activity, and (c) the size of the partition.
摘要翻译： 用于数据库查询的查询工具动态地确定数据库表的选择性部分是否可能受益于单独的查询执行策略，并相应地构建适当的单独的执行策略。 优选地，数据库包含至少一个包括多个分区的相对较大的表，每个分区共享表的定义结构，并且包含表记录的不同相应离散子集。 查询设施比较不同分区的元数据，以确定分区之间是否存在足够大的差异，并且在适当的情况下选择一个或多个分区用于单独的执行策略。 优选地，使用考虑到的加权公式对分区进行分级评估：（a）分区的索引的数量，（b）更改活动的新近度，以及（c）分区的大小。
-
公开(公告)号：US20180276683A1
公开(公告)日：2018-09-27
申请号：US15467081
申请日：2017-03-23
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.
-
公开(公告)号：US20170149870A1
公开(公告)日：2017-05-25
申请号：US14950919
申请日：2015-11-24
CPC分类号： H04L67/101 , H04L43/0852
摘要： A system, method and program product for providing latency management for use with a database management system. A system is disclosed having: a system for capturing and storing a maximum latency (ML) whenever a derived source is created from a source data; a system for determining a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query; and a system for causing the source data to be used in response to the difference being greater than the ML, and for causing the derived source to be used in response to the difference being less than the ML.
-
7.发明申请Dynamically Associating Different Query Execution Strategies with Selective Portions of a Database Table 有权动态地将不同的查询执行策略与数据库表的选择性部分相关联公开(公告)号：US20130132405A1
公开(公告)日：2013-05-23
申请号：US13748670
申请日：2013-01-24
IPC分类号： G06F17/30
CPC分类号： G06F17/3053 , G06F17/30545
摘要： A query facility for database queries dynamically determines whether selective portions of a database table are likely to benefit from separate query execution strategies, and constructs an appropriate separate execution strategies accordingly. Preferably, the database contains at least one relatively large table comprising multiple partitions, each sharing the definitional structure of the table and containing a different respective discrete subset of the table records. The query facility compares metadata for different partitions to determine whether sufficiently large differences exist among the partitions, and in appropriate cases selects one or more partitions for separate execution strategies. Preferably, partitions are ranked for separate evaluation using a weighting formula which takes into account: (a) the number of indexes for the partition, (b) recency of change activity, and (c) the size of the partition.
摘要翻译： 用于数据库查询的查询工具动态地确定数据库表的选择性部分是否可能受益于单独的查询执行策略，并相应地构建适当的单独的执行策略。 优选地，数据库包含至少一个包括多个分区的相对较大的表，每个分区共享表的定义结构，并且包含表记录的不同相应离散子集。 查询设施比较不同分区的元数据，以确定分区之间是否存在足够大的差异，并且在适当的情况下选择一个或多个分区用于单独的执行策略。 优选地，使用考虑到的加权公式对分区进行分级评估：（a）分区的索引的数量，（b）更改活动的新近度，以及（c）分区的大小。
-
公开(公告)号：US20200311079A1
公开(公告)日：2020-10-01
申请号：US16369035
申请日：2019-03-29
发明人： Shantan Kethireddy , Ruiping Li , Nogi Simanjuntak , Ying Zeng
IPC分类号： G06F16/2453
摘要： A method, system and computer program product for providing workload isolation in a hybrid database system, by: performing a workload in a separate workload isolation system of the hybrid database system, wherein the separate workload isolation system manages data copied from one or more source systems of the hybrid database system and stored on one or more data hubs managed by the separate workload isolation system, and the workload enters the source systems and is re-routed from the source systems to the separate workload isolation system in order to isolate the source systems from the workload being performed by the separate workload isolation system using the data hubs.
-
公开(公告)号：US10565597B2
公开(公告)日：2020-02-18
申请号：US15623940
申请日：2017-06-15
IPC分类号： G06F16/00 , G06Q30/00 , G06F7/02 , G06F16/242 , G06F16/25 , G06F16/2457 , G06F17/27
摘要： 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.
-
公开(公告)号：US10956447B2
公开(公告)日：2021-03-23
申请号：US16681758
申请日：2019-11-12
摘要： Technical solutions are described for determining data replication cost for a data server. In an example, a method for estimating the data replication cost includes receiving an identification of a source table and an identification of a target table for the data replication. The method further includes receiving a selection of a data replication scheme to be used to replicate the data. A costing system that implements the method determines the data replication cost, based on a conversion cost for conversion of the data from the source table to the target table, and a transfer cost for transfer of the data from the source table to the target table. The costing system communicates the data replication cost to an administrator.
-
-
-
-
-
-
-
-
-
搜索结果
14 条记录 (耗时 0.024 秒)
