-
公开(公告)号:US20150339358A1
公开(公告)日:2015-11-26
申请号:US14283641
申请日:2014-05-21
Applicant: International Business Machines Corporation
Inventor: Arun Balasubramanyan , Yuntao Liu , Pamela K. Prinz , Mary E. Rudden , John A. Tobasco
IPC: G06F17/30
CPC classification number: G06F17/30563
Abstract: A method is provided for managing queries in business intelligence platforms. The method includes receiving, by a processor, a first query requesting data from at least one business intelligence content, the first query having a first format. The method further includes determining, by the processor, at least one requirement to complete the first query. The method further includes converting, by the processor, the first query to a second query configured to be used by an Extract, Transform, and Load (ETL) program, in response to determining that the at least one requirement exceeds a threshold, the second query having a second format.
Abstract translation: 提供了一种在商业智能平台中管理查询的方法。 该方法包括由处理器接收从至少一个商业智能内容请求数据的第一查询,第一查询具有第一格式。 该方法还包括由处理器确定完成第一查询的至少一个要求。 所述方法还包括响应于确定所述至少一个要求超过阈值,由所述处理器将所述第一查询转换为被提取,转换和加载(ETL)程序配置为使用的第二查询,所述第二查询 具有第二格式的查询。
-
公开(公告)号:US10997193B2
公开(公告)日:2021-05-04
申请号:US15846407
申请日:2017-12-19
Applicant: International Business Machines Corporation
Inventor: Arun Balasubramanyan , Yuntao Liu , Pamela K. Prinz , Mary E. Rudden , John A. Tobasco
IPC: G06F16/25
Abstract: A method and system for managing queries in business intelligence platforms. It is determined that at least one requirement to complete a first query exceeds a threshold and in response, a redacted report failing to exceed the threshold is generated. The first query requests data from at least one business intelligence content from a first geographical region. In response to detecting a rejection, by a user, of the redacted report after the user had been prompted, to accept or reject the redacted report: (i) the first query is converted to a second query configured to be used by an Extract, Transform, and Load (ETL) program from a second geographical region; and (ii) a report responsive to the first query is generated.
-
3.
公开(公告)号:US20160134490A1
公开(公告)日:2016-05-12
申请号:US14538125
申请日:2014-11-11
Applicant: International Business Machines Corporation
Inventor: Arun Balasubramanyan , Yuntao Liu , Pamela K. Prinz , Mary E. Rudden
CPC classification number: G06F17/30371 , G06F17/30575 , G06Q10/06 , H04L41/147 , H04L41/5009 , H04L41/5032 , H04L43/067
Abstract: A method of managing event metrics for service management analytics. The method includes: determining, by a computer processor, whether a record associated with service level management needs to be versioned based on metric metadata; if so, capturing, by the computer processor, present state of the record; versioning, by the computer processor, the captured present state of the record; summarizing and aggregating, by the computer processor, the versioned record; generating, by the computer processor, snapshots of the summarized and aggregated records; and attaching, by the computer processor, reference attributes to the snapshots.
Abstract translation: 管理服务管理分析的事件度量的一种方法。 该方法包括:由计算机处理器确定与服务级别管理相关联的记录是否需要基于度量元数据进行版本化; 如果是,则由计算机处理器捕获记录的状态; 由计算机处理器进行版本控制,捕获记录的当前状态; 由计算机处理器汇总和汇总版本记录; 由计算机处理器生成摘要和汇总记录的快照; 并且由计算机处理器将引用属性附加到快照。
-
公开(公告)号:US10102240B2
公开(公告)日:2018-10-16
申请号:US14538125
申请日:2014-11-11
Applicant: International Business Machines Corporation
Inventor: Arun Balasubramanyan , Yuntao Liu , Pamela K. Prinz , Mary E. Rudden
Abstract: Aspects of the present invention manage event metrics as a function of service management analytics. In response to determining that a version of record associated with a service level management agreement should be saved (versioned), aspects capture the presence of reference attributes of the record, and summarize and aggregate values of organizing dimensions of the reference attributes of each of a plurality of records that includes the versioned record. Aspects generate a snapshot that comprises a subset of the summarized and aggregated, final values of the organizing dimensions of the reference attributes that are selected as having values that are associated with an event occurrence, and attach the summarized and aggregated values of the organizing dimensions of to the snapshot.
-
公开(公告)号:US20180107722A1
公开(公告)日:2018-04-19
申请号:US15846407
申请日:2017-12-19
Applicant: International Business Machines Corporation
Inventor: Arun Balasubramanyan , Yuntao Liu , Pamela K. Prinz , Mary E. Rudden , John A. Tobasco
IPC: G06F17/30
CPC classification number: G06F16/254
Abstract: A method and system for managing queries in business intelligence platforms. It is determined that at least one requirement to complete a first query exceeds a threshold and in response, a redacted report failing to exceed the threshold is generated. The first query requests data from at least one business intelligence content from a first geographical region. In response to detecting a rejection, by a user, of the redacted report after the user had been prompted, to accept or reject the redacted report: (i) the first query is converted to a second query configured to be used by an Extract, Transform, and Load (ETL) program from a second geographical region; and (ii) a report responsive to the first query is generated.
-
公开(公告)号:US09892179B2
公开(公告)日:2018-02-13
申请号:US14283641
申请日:2014-05-21
Applicant: International Business Machines Corporation
Inventor: Arun Balasubramanyan , Yuntao Liu , Pamela K. Prinz , Mary E. Rudden , John A. Tobasco
IPC: G06F17/30
CPC classification number: G06F17/30563
Abstract: A method is provided for managing queries in business intelligence platforms. The method includes receiving, by a processor, a first query requesting data from at least one business intelligence content, the first query having a first format. The method further includes determining, by the processor, at least one requirement to complete the first query. The method further includes converting, by the processor, the first query to a second query configured to be used by an Extract, Transform, and Load (ETL) program, in response to determining that the at least one requirement exceeds a threshold, the second query having a second format.
-
-
-
-
-