公开(公告)号：US20060259460A1

公开(公告)日：2006-11-16

申请号：US11129139

申请日：2005-05-13

Applicant: Thomas Zurek ,  Klaus Nagel ,  Stefan Dipper

Inventor： Thomas Zurek ,  Klaus Nagel ,  Stefan Dipper

IPC: G06F17/30

CPC classification number: G06F17/30964 ,  Y10S707/944 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99945

Abstract: A method for estimating a runtime of a query of a data repository may abstract, extract, or otherwise generate one or more parameters of the query. Thereafter, the abstracted parameters may be associated with one or more statistical query records. From these statistical query records, a query runtime may be estimated. Related apparatuses, computer program products, and computer systems are also described.

Abstract translation: 用于估计数据存储库的查询的运行时间的方法可以抽象，提取或以其他方式生成查询的一个或多个参数。 此后，抽象参数可以与一个或多个统计查询记录相关联。 从这些统计查询记录可以估计查询运行时间。 还描述了相关设备，计算机程序产品和计算机系统。

公开(公告)号：US07779041B2

公开(公告)日：2010-08-17

申请号：US11799814

申请日：2007-05-02

Applicant: Thomas Zurek

Inventor： Thomas Zurek

IPC: G06F17/30

CPC classification number: G06F17/30592

Abstract: In one aspect, in a computer-implemented method may make data anonymous, so that the data may be used during testing. The method may include receiving, from a user interface, an indication of a type of shuffling to be performed on data. Moreover, the data may be shuffled based on the received indication of the shuffling type. The shuffling may rearrange the data to make the data anonymous. The shuffled data may be provided to an application. Related systems, apparatus, methods, and/or articles are also described.

Abstract translation: 在一方面，在计算机实现的方法中可以使数据匿名，使得在测试期间可以使用数据。 该方法可以包括从用户界面接收要针对数据执行的混洗类型的指示。 此外，可以基于接收到的混洗类型的指示来对数据进行混洗。 混洗可以重新排列数据，使数据无名。 洗牌数据可以被提供给应用。 还描述了相关系统，装置，方法和/或制品。

公开(公告)号：US20080140615A1

公开(公告)日：2008-06-12

申请号：US12032518

申请日：2008-02-15

Applicant: Thomas Zurek ,  Klaus Nagel ,  Stefan Dipper

Inventor： Thomas Zurek ,  Klaus Nagel ,  Stefan Dipper

IPC: G06F17/30

CPC classification number: G06F17/30964 ,  Y10S707/944 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99945

Abstract: A method for estimating a runtime of a query of a data repository may abstract, extract, or otherwise generate one or more parameters of the query. Thereafter, the abstracted parameters may be associated with one or more statistical query records. From these statistical query records, a query runtime may be estimated. Related apparatuses, computer program products, and computer systems are also described

Abstract translation: 用于估计数据存储库的查询的运行时间的方法可以抽象，提取或以其他方式生成查询的一个或多个参数。 此后，抽象参数可以与一个或多个统计查询记录相关联。 从这些统计查询记录可以估计查询运行时间。 还描述了相关设备，计算机程序产品和计算机系统

公开(公告)号：US08145626B2

公开(公告)日：2012-03-27

申请号：US12347729

申请日：2008-12-31

Applicant: Peter John ,  Thomas Zurek

Inventor： Peter John ,  Thomas Zurek

IPC: G06F17/00

CPC classification number: G06F17/30592

Abstract: In one embodiment the present invention includes a method comprising receiving a data filter for filtering a collection of data, wherein the collection of data is configured as a star schema including a fact table and dimension tables. The data filter is applied against the dimension tables to generate a modified dimension table. The modified dimension tables are applied against the fact table to produce a modified fact table. The data filter is then applied against the modified fact table to generate a second modified fact table, which is the output of the process.

Abstract translation: 在一个实施例中，本发明包括一种方法，包括接收用于过滤数据集合的数据过滤器，其中数据的收集被配置为包括事实表和维度表的星型模式。 数据过滤器应用于维度表以生成修改的维度表。 修改的维度表适用于事实表，以生成修改后的事实表。 然后将数据过滤器应用于修改的事实表，以生成第二个修改后的事实表，该表是进程的输出。

公开(公告)号：US20060116984A1

公开(公告)日：2006-06-01

申请号：US10999744

申请日：2004-11-29

Applicant: Thomas Zurek

Inventor： Thomas Zurek

IPC: G06F17/30

CPC classification number: G06F17/30592 ,  Y10S707/99931 ,  Y10S707/99933

Abstract: A system and method for improving a query on a relational database in a business intelligence system is provided. A multidimensional data table is provided in the database. A sampling dimension is appended to the data table. The sampling dimension includes a number of cells, and wherein each cell includes a sampling value corresponding to the data of at least one of the dimensions of the data table. The data table is then clustered in at least one of the dimensions based on the associated sampling value in the sampling dimension. A query for a subset of data can then be executed on the clustered data table based on the sampling values.

公开(公告)号：US07610272B2

公开(公告)日：2009-10-27

申请号：US10999744

申请日：2004-11-29

Applicant: Thomas Zurek

Inventor： Thomas Zurek

IPC: G06F17/30

CPC classification number: G06F17/30592 ,  Y10S707/99931 ,  Y10S707/99933

Abstract: A system and method for improving a query on a relational database in a business intelligence system is provided. A multidimensional data table is provided in the database. A sampling dimension is appended to the data table. The sampling dimension includes a number of cells, and wherein each cell includes a sampling value corresponding to the data of at least one of the dimensions of the data table. The data table is then clustered in at least one of the dimensions based on the associated sampling value in the sampling dimension. A query for a subset of data can then be executed on the clustered data table based on the sampling values.

Abstract translation: 提供了一种用于改善商业智能系统中关系数据库查询的系统和方法。 数据库中提供了一个多维数据表。 采样维度附加到数据表。 采样维度包括多个小区，并且其中每个小区包括对应于数据表的维度中的至少一个的数据的采样值。 然后基于采样维度中相关联的采样值将数据表聚集到至少一个维度中。 然后可以基于采样值在群集数据表上执行对数据子集的查询。

公开(公告)号：US07610265B2

公开(公告)日：2009-10-27

申请号：US11117895

申请日：2005-04-29

Applicant: Thomas Zurek

Inventor： Thomas Zurek

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30424 ,  G06F17/30495 ,  Y10S707/99932 ,  Y10S707/99935

Abstract: A method determines whether a structural indicator of a first table of results generated from a first data repository query matches a corresponding structural indicator of a second table of results generated from a substantially identical second data repository query. If the first and second table structural indicators match, then values from at least two corresponding cells from each of the first and second tables are aggregated. If the aggregated values from the first and second tables are identical, then an indication is provided indicating that the first data repository query results are accurate. Related apparatuses, computer program products, and computer systems are also described.

Abstract translation: 一种方法确定从第一数据存储库查询生成的第一结果表的结构指示符是否与从基本相同的第二数据存储库查询生成的第二结果表的对应结构指示符相匹配。 如果第一和第二表结构指示符匹配，则来自第一和第二表中的每一个的至少两个相应单元格的值被聚合。 如果来自第一和第二表的聚合值相同，则提供指示第一数据库查询结果是准确的指示。 还描述了相关设备，计算机程序产品和计算机系统。

公开(公告)号：US20080046721A1

公开(公告)日：2008-02-21

申请号：US11504916

申请日：2006-08-15

Applicant: Thomas Zurek ,  Bernhard Hornung

Inventor： Thomas Zurek ,  Bernhard Hornung

IPC: H04L9/00

CPC classification number: G06Q10/06

Abstract: A selection of a plurality of data sources which characterize characteristics and key figures are received. Thereafter, a multiprovider is dynamically generated that is based on the selection and which includes characteristics and key figures from each of the selected data sources. Queries may then be run on top of the multiprovider and reported. Related apparatus, systems, methods, and articles are also described.

Abstract translation: 接收表征特征和关键图形的多个数据源的选择。 此后，基于选择动态地生成多维数据库，并且包括来自每个所选数据源的特征和关键数字。 然后可以在多维数据库之上运行查询并报告。 还描述了相关装置，系统，方法和制品。

公开(公告)号：US20070136323A1

公开(公告)日：2007-06-14

申请号：US11302855

申请日：2005-12-13

Applicant: Thomas Zurek ,  Stefan Dipper ,  Stefan Unnebrink ,  Klaus Nagel ,  Erich Marschall ,  Franz Faerber ,  Guenter Radestock ,  Christian Bartholomae

Inventor： Thomas Zurek ,  Stefan Dipper ,  Stefan Unnebrink ,  Klaus Nagel ,  Erich Marschall ,  Franz Faerber ,  Guenter Radestock ,  Christian Bartholomae

IPC: G06F7/00

CPC classification number: G06F17/30592 ,  Y10S707/99943

Abstract: Systems and techniques for mapping data structures in a data processing environment to help ensure the accessibility of stored information. In one implementation, an article includes a machine-readable medium storing instructions. The instructions are operable to cause one or more machines to perform operations. The operations include receiving a first data storage schema in which a characteristic in a first dimension table is mapped by a first table and a second table and generating a second data storage schema. The first table maps the characteristic to a first object that include attributes to which time information is irrelevant to data processing activities and the second table maps the characteristic to a second object that include attributes to which time information is relevant to data processing activities. The second data storage schema includes a fact table including at least some facts drawn from the first data storage schema and a second dimension table that includes at least some characteristics drawn from at least one of the first object and the second object.

Abstract translation: 用于在数据处理环境中映射数据结构的系统和技术，以帮助确保存储信息的可访问性。 在一个实现中，物品包括存储指令的机器可读介质。 该指令可操作以使一个或多个机器执行操作。 操作包括接收第一数据存储模式，其中通过第一表和第二表映射第一维表中的特征，并生成第二数据存储模式。 第一表将特征映射到第一对象，其包括时间信息与数据处理活动无关的属性，第二表将特征映射到第二对象，第二对象包括时间信息与数据处理活动相关的属性。 第二数据存储模式包括包括从第一数据存储模式中提取的至少一些事实的事实表以及包括从第一对象和第二对象中的至少一个绘制的至少一些特征的第二维度表。

公开(公告)号：US20060248052A1

公开(公告)日：2006-11-02

申请号：US11117895

申请日：2005-04-29

Applicant: Thomas Zurek

Inventor： Thomas Zurek

IPC: G06F17/30

CPC classification number: G06F17/30424 ,  G06F17/30495 ,  Y10S707/99932 ,  Y10S707/99935

Abstract: A method determines whether a structural indicator of a first table of results generated from a first data repository query matches a corresponding structural indicator of a second table of results generated from a substantially identical second data repository query. If the first and second table structural indicators match, then values from at least two corresponding cells from each of the first and second tables are aggregated. If the aggregated values from the first and second tables are identical, then an indication is provided indicating that the first data repository query results are accurate. Related apparatuses, computer program products, and computer systems are also described.