- 专利标题: Early diagnosis of hardware, software or configuration problems in data warehouse system utilizing grouping of queries based on query parameters
-
申请号: US15617201申请日: 2017-06-08
-
公开(公告)号: US10423479B2公开(公告)日: 2019-09-24
- 发明人: Lukasz Gaza , Artur M. Gruszecki , Tomasz Kazalski , Bartlomiej T. Malecki , Konrad K. Skibski , Tomasz Stradomski
- 申请人: International Business Machines Corporation
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理机构: Winstead, P.C.
- 代理商 Robert A. Voigt, Jr.
- 主分类号: G06F11/07
- IPC分类号: G06F11/07 ; G06F16/21 ; G06F16/25 ; G06F16/2455 ; G06F16/2457 ; G06F11/34
摘要:
A method, system and computer program product for providing early diagnosis of hardware, software or configuration problems in a data warehouse system. A received query is parsed to determine the properties of the query. The query may then be joined to existing groups of queries if those groups have shared properties of the query. After executing the query according to an execution plan, results from the execution of the query is received, which may include problem(s) that occurred during execution of the query. For those problems that reach a pre-defined threshold of becoming a “group problem” in those groups joined by the query, the problem is reported to the end user concerning those groups where the problem exceeds the pre-defined threshold. In this manner, an early diagnosis of the problems in the data warehouse system that can cause delay and failure of the processing of queries is able to occur.
公开/授权文献
信息查询