公开(公告)号：US20140358865A1

公开(公告)日：2014-12-04

申请号：US14369826

申请日：2011-12-28

申请人： Hans-Gerd Brummel ,  Stephan Grimm ,  Thomas Hubauer ,  Mikhail Roshchin ,  Michael Watzke

发明人： Hans-Gerd Brummel ,  Stephan Grimm ,  Thomas Hubauer ,  Mikhail Roshchin ,  Michael Watzke

IPC分类号： G06F17/30

CPC分类号： G06F16/245 ,  G06F16/2365 ,  G06N5/025 ,  G06N5/041

摘要： Rules of a rule base are transformed in an automated fashion in order to be able to conduct consistency checks and generate explanations and thus classify and correct existing rules. This is beneficial in particular in large systems with existing rule bases, e.g., wherein each rule is associated with at least a diagnostic task of a component of a technical system, e.g., a power system. The task can be subject to fault detection, fault isolation, predictive diagnosis or reporting. The solution presented provides an overview of large sets of rules and thus allows determining which rules are suitable and which are not. The invention is applicable for all kinds of technical systems, e.g., industry and automation systems, in particular power systems.

摘要翻译： 规则库的规则以自动化方式进行转换，以便能够进行一致性检查并生成解释，从而对现有规则进行分类和更正。 这在具有现有规则库的大型系统中是有益的，例如，其中每个规则与至少技术系统的部件（例如电力系统）的诊断任务相关联。 该任务可以进行故障检测，故障隔离，预测诊断或报告。 所提供的解决方案概述了大量规则，从而可以确定哪些规则是合适的，哪些规则不适用。 本发明适用于各种技术系统，例如工业和自动化系统，特别是电力系统。

公开(公告)号：US20090043726A1

公开(公告)日：2009-02-12

申请号：US11836186

申请日：2007-08-09

申请人： Michael Watzke

发明人： Michael Watzke

IPC分类号： G06F7/00

CPC分类号： G06F17/30592 ,  Y10S707/99932

摘要： There is provided a method, a system and a machine readable medium to execute a spatial query against a plurality of input tables of a distributed database. The method comprises: mapping spatial objects of a first input table to a first spatial grid, the first spatial grid including a plurality of first spatial cells; redistributing the spatial objects of the first input table to a first intermediate table of one or more access module processors based on the first spatial cell of the first spatial grid to which each of the spatial objects is mapped; determining whether one or more first spatial cells of the first spatial grid are skewed; subdividing each of the skewed one or more first spatial cells to a second spatial grid, the second spatial grid including a plurality of second spatial cells; mapping spatial objects of the first intermediate file to the second spatial grid, the second spatial grid including a plurality of second spatial cells; redistributing the spatial objects of the first intermediate file to one or more access module processors based on the second spatial cell of the second spatial grid to which each of the spatial objects is mapped; mapping spatial objects of a second input table to the first spatial grid and the second spatial grid; redistributing the spatial objects of the second input table to a second intermediate file of one or more access module processors based on the first spatial cell of the first spatial grid and the second spatial cell of the second spatial grid to which each of the spatial objects is mapped; and joining the spatial objects of the first intermediate file to spatial objects of the second intermediate file for each first spatial cell of the first spatial grid or the second spatial cell of the second spatial grid.

摘要翻译： 提供了一种针对分布式数据库的多个输入表执行空间查询的方法，系统和机器可读介质。 该方法包括：将第一输入表的空间对象映射到第一空间网格，所述第一空间网格包括多个第一空间单元; 基于每个空间对象映射到的第一空间网格的第一空间单元，将第一输入表的空间对象重新分配到一个或多个访问模块处理器的第一中间表; 确定所述第一空间网格中的一个或多个第一空间单元是否倾斜; 将每个倾斜的一个或多个第一空间单元细分为第二空间网格，所述第二空间网格包括多个第二空间单元; 将所述第一中间文件的空间对象映射到所述第二空间网格，所述第二空间网格包括多个第二空间单元; 基于每个空间对象映射到的第二空间网格的第二空间单元，将第一中间文件的空间对象重新分配到一个或多个访问模块处理器; 将第二输入表的空间对象映射到所述第一空间网格和所述第二空间网格; 基于第一空间网格的第一空间单元和第二空间网格的第二空间单元，将每个空间对象的空间对象重新分配到一个或多个访问模块处理器的第二中间文件 映射 以及将第一中间文件的空间对象连接到第二空间网格的第一空间网格或第二空间网格的第二空间单元的每个第一空间单元的第二中间文件的空间对象。

公开(公告)号：US11468057B2

公开(公告)日：2022-10-11

申请号：US17051769

申请日：2019-04-16

申请人： Jan-Gregor Fischer ,  Michael Watzke ,  Michael Pirker

发明人： Jan-Gregor Fischer ,  Michael Watzke ,  Michael Pirker

IPC分类号： G06F16/2453 ,  G06F16/248 ,  G06F16/25 ,  G06F40/237 ,  G06F40/30

摘要： A system for providing a generic query interface for industrial systems of different customers includes an interface configured to input customer queries of customer industrial systems. The system also includes a query processing unit that is configured to automatically perform a query decomposition of the input customer query into query parts based on a query reformulation model stored in a database of the system. For each decomposed query part, it is determined whether the decomposed query part is available in an application semantic model stored in the database of the system. Query parts not available in the application semantic model are automatically reformulated based on the query reformulation model, and a query recomposition of the query parts available in the application semantic model and the reformulated semantic query parts is automatically performed to generate a generic query applied to an application logic of the system to provide a query result.

公开(公告)号：US08635608B2

公开(公告)日：2014-01-21

申请号：US11849500

申请日：2007-09-04

申请人： Bhashyam Ramesh ,  Michael Watzke

发明人： Bhashyam Ramesh ,  Michael Watzke

IPC分类号： G06F9/45

CPC分类号： G06F8/65

摘要： There is provided a method, system and computer program for updating at least one component in a multi-component software application. The method includes receiving application data describing characteristics of the software application, receiving update data describing at least one update applicable to the software application and reviewing the application data and update data to determine whether the at least one update is applied to the software application.

摘要翻译： 提供了一种用于在多组件软件应用程序中更新至少一个组件的方法，系统和计算机程序。 所述方法包括接收描述所述软件应用的特征的应用数据，接收描述适用于所述软件应用的至少一个更新的更新数据，以及查看所述应用数据和更新数据以确定所述至少一个更新是否应用于所述软件应用。

公开(公告)号：US20210240707A1

公开(公告)日：2021-08-05

申请号：US17051769

申请日：2019-04-16

申请人： Jan-Gregor Fischer ,  Michael Watzke ,  Michael Pirker

发明人： Jan-Gregor Fischer ,  Michael Watzke ,  Michael Pirker

IPC分类号： G06F16/2453 ,  G06F16/248 ,  G06F16/25 ,  G06F40/30 ,  G06F40/237

摘要： A system for providing a generic query interface for industrial systems of different customers includes an interface configured to input customer queries of customer industrial systems. The system also includes a query processing unit that is configured to automatically perform a query decomposition of the input customer query into query parts based on a query reformulation model stored in a database of the system. For each decomposed query part, it is determined whether the decomposed query part is available in an application semantic model stored in the database of the system. Query parts not available in the application semantic model are automatically reformulated based on the query reformulation model, and a query recomposition of the query parts available in the application semantic model and the reformulated semantic query parts is automatically performed to generate a generic query applied to an application logic of the system to provide a query result.

公开(公告)号：US09110947B1

公开(公告)日：2015-08-18

申请号：US13618875

申请日：2012-09-14

申请人： Michael Watzke ,  Bhashyam Ramesh

发明人： Michael Watzke ,  Bhashyam Ramesh

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30486 ,  G06F17/30315

摘要： A database system may process multiple column-oriented tasks in parallel for a database being stored according to a row-partitioning protocol. The database system may determine when the query should process the column-oriented task serially or in parallel. For parallel processing, the database system may generate processing tasks for each unique column-oriented task contained in the query used to retrieve column data and to process the column data according to the column-oriented tasks requested. A method of operating the database system may determine that multiple column-oriented tasks included in a query are to be processed in parallel. The method may further include generating a processing task for each unique column-oriented task included in the query. The method may further include performing the column-oriented tasks in parallel based on the processing threads. The method may implement various considerations in determining to process to the column-oriented tasks in parallel.

摘要翻译： 数据库系统可以根据行分区协议并行存储数据库来处理多个面向列的任务。 数据库系统可以确定查询何时应该串行或并行处理面向列的任务。 对于并行处理，数据库系统可以为包含在用于检索列数据的查询中的每个独特的面向列的任务生成处理任务，并根据所请求的面向列的任务来处理列数据。 操作数据库系统的方法可以确定包括在查询中的多个面向列的任务将被并行处理。 该方法还可以包括为查询中包括的每个独特的面向列的任务生成处理任务。 该方法还可以包括基于处理线程来并行地执行面向列的任务。 该方法可以在确定并行处理到面向列的任务时实现各种考虑。

公开(公告)号：US20070174278A1

公开(公告)日：2007-07-26

申请号：US11622595

申请日：2007-01-12

申请人： Bhashyam Ramesh ,  Michael Watzke

发明人： Bhashyam Ramesh ,  Michael Watzke

IPC分类号： G06F7/00

CPC分类号： G06F17/30584 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99936

摘要： A method and system for performing logical partial declustering in a shared-nothing database environment. The solution defines a partial declustering technique that can be used to dynamically adapt the declustering of base tables or intermediate result sets. The partial declustering technique is defined to limit the number of partitions (P) involved in an operation. The technique is defined to limit the operation to a subset of the system partitioning map (SPM). There are two components: the association between the data values and partitions is altered by restricting the data values to P′ partition values where P′ is less than P; and the actual partitions of the SPM selected are then derived based on a seed derived from a dynamic parameter, such as a session number, or a static parameter, such as a table identifier. In the case of intermediate result sets the number of P′ partitions selected is a cost based decision based on the estimated number of rows in the input intermediate result sets. In the case of a base table the number of P′ partitions is selected based on the table DDL. There is no physical partitioning definitions, rather logical partitions are defined based on subsetting the SPM.

摘要翻译： 一种用于在无共享数据库环境中执行逻辑部分去聚簇的方法和系统。 该解决方案定义了一种部分去聚簇技术，可用于动态调整基表或中间结果集的去聚类。 定义了部分去聚类技术来限制操作中涉及的分区（P）的数量。 该技术被定义为将操作限制为系统分区映射（SPM）的子集。 有两个组件：通过将数据值限制为P'小于P的P'分区值来改变数据值和分区之间的关联; 并且然后基于从诸如会话号码的动态参数或诸如表标识符的静态参数导出的种子导出所选择的SPM的实际分区。 在中间结果集的情况下，所选择的P'分区的数量是基于输入中间结果集中的估计行数的基于成本的决定。 在基表的情况下，根据表DDL选择P'分区的数量。 没有物理分区定义，而是基于子集SPM来定义逻辑分区。

公开(公告)号：US08005836B2

公开(公告)日：2011-08-23

申请号：US11622595

申请日：2007-01-12

申请人： Bhashyam Ramesh ,  Michael Watzke

发明人： Bhashyam Ramesh ,  Michael Watzke

IPC分类号： G06F17/30

CPC分类号： G06F17/30584 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99936

摘要： A method and system for performing logical partial declustering in a shared-nothing database environment. The solution defines a partial declustering technique that can be used to dynamically adapt the declustering of base tables or intermediate result sets. The partial declustering technique is defined to limit the number of partitions (P) involved in an operation. The technique is defined to limit the operation to a subset of the system partitioning map (SPM). There are two components: the association between the data values and partitions is altered by restricting the data values to P′ partition values where P′ is less than P; and the actual partitions of the SPM selected are then derived based on a seed derived from a dynamic parameter, such as a session number, or a static parameter, such as a table identifier. In the case of intermediate result sets the number of P′ partitions selected is a cost based decision based on the estimated number of rows in the input intermediate result sets. In the case of a base table the number of P′ partitions is selected based on the table DDL. There is no physical partitioning definitions, rather logical partitions are defined based on subsetting the SPM.

摘要翻译： 一种用于在无共享数据库环境中执行逻辑部分去聚簇的方法和系统。 该解决方案定义了一种部分去聚簇技术，可用于动态调整基表或中间结果集的去聚类。 定义了部分去聚类技术来限制操作中涉及的分区（P）的数量。 该技术被定义为将操作限制为系统分区映射（SPM）的子集。 有两个组件：通过将数据值限制为P'小于P的P'分区值来改变数据值和分区之间的关联; 并且然后基于从诸如会话号码的动态参数或诸如表标识符的静态参数导出的种子导出所选择的SPM的实际分区。 在中间结果集的情况下，所选择的P'分区的数量是基于输入中间结果集中的估计行数的基于成本的决定。 在基表的情况下，根据表DDL选择P'分区的数量。 没有物理分区定义，而是基于子集SPM来定义逻辑分区。

公开(公告)号：US20090064123A1

公开(公告)日：2009-03-05

申请号：US11849500

申请日：2007-09-04

申请人： Bhashyam Ramesh ,  Michael Watzke

发明人： Bhashyam Ramesh ,  Michael Watzke

IPC分类号： G06F9/44

CPC分类号： G06F8/65

摘要： There is provided a method, system and computer program for updating at least one component in a multi-component software application. The method includes receiving application data describing characteristics of the software application, receiving update data describing at least one update applicable to the software application and reviewing the application data and update data to determine whether the at least one update is applied to the software application.

摘要翻译： 提供了一种用于在多组件软件应用程序中更新至少一个组件的方法，系统和计算机程序。 所述方法包括接收描述所述软件应用的特征的应用数据，接收描述适用于所述软件应用的至少一个更新的更新数据，以及查看所述应用数据和更新数据以确定所述至少一个更新是否应用于所述软件应用。

公开(公告)号：US07640257B2

公开(公告)日：2009-12-29

申请号：US11836186

申请日：2007-08-09

申请人： Michael Watzke

发明人： Michael Watzke

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30592 ,  Y10S707/99932

摘要： There is provided a method, a system and a machine readable medium to execute a spatial query against a plurality of input tables of a distributed database. The method comprises: mapping spatial objects of a first input table to a first spatial grid, the first spatial grid including a plurality of first spatial cells; redistributing the spatial objects of the first input table to a first intermediate table of one or more access module processors based on the first spatial cell of the first spatial grid to which each of the spatial objects is mapped; determining whether one or more first spatial cells of the first spatial grid are skewed; subdividing each of the skewed one or more first spatial cells to a second spatial grid, the second spatial grid including a plurality of second spatial cells; mapping spatial objects of the first intermediate file to the second spatial grid, the second spatial grid including a plurality of second spatial cells; redistributing the spatial objects of the first intermediate file to one or more access module processors based on the second spatial cell of the second spatial grid to which each of the spatial objects is mapped; mapping spatial objects of a second input table to the first spatial grid and the second spatial grid; redistributing the spatial objects of the second input table to a second intermediate file of one or more access module processors based on the first spatial cell of the first spatial grid and the second spatial cell of the second spatial grid to which each of the spatial objects is mapped; and joining the spatial objects of the first intermediate file to spatial objects of the second intermediate file for each first spatial cell of the first spatial grid or the second spatial cell of the second spatial grid.

摘要翻译： 提供了一种针对分布式数据库的多个输入表执行空间查询的方法，系统和机器可读介质。 该方法包括：将第一输入表的空间对象映射到第一空间网格，所述第一空间网格包括多个第一空间单元; 基于每个空间对象映射到的第一空间网格的第一空间单元，将第一输入表的空间对象重新分配到一个或多个访问模块处理器的第一中间表; 确定所述第一空间网格中的一个或多个第一空间单元是否倾斜; 将每个倾斜的一个或多个第一空间单元细分为第二空间网格，所述第二空间网格包括多个第二空间单元; 将所述第一中间文件的空间对象映射到所述第二空间网格，所述第二空间网格包括多个第二空间单元; 基于每个空间对象映射到的第二空间网格的第二空间单元，将第一中间文件的空间对象重新分配到一个或多个访问模块处理器; 将第二输入表的空间对象映射到所述第一空间网格和所述第二空间网格; 基于第一空间网格的第一空间单元和第二空间网格的第二空间单元，将每个空间对象的空间对象重新分配到一个或多个访问模块处理器的第二中间文件 映射 以及将第一中间文件的空间对象连接到第二空间网格的第一空间网格或第二空间网格的第二空间单元的每个第一空间单元的第二中间文件的空间对象。