公开(公告)号：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: 用于估计数据存储库的查询的运行时间的方法可以抽象，提取或以其他方式生成查询的一个或多个参数。 此后，抽象参数可以与一个或多个统计查询记录相关联。 从这些统计查询记录可以估计查询运行时间。 还描述了相关设备，计算机程序产品和计算机系统。

公开(公告)号：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.

公开(公告)号：US08402044B2

公开(公告)日：2013-03-19

申请号：US12834750

申请日：2010-07-12

Applicant: Thomas Zurek

Inventor： Thomas Zurek

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30545 ,  G06F17/30477

Abstract: In one embodiment the present invention includes a computer-implemented method comprising receiving a first query in a local computer system to access data stored on a remote computer system the local computer system. Data elements of the remote data are associated with data elements of the local data. The query is transformed into multiple queries. A second query is sent to the remote computer system to retrieve remote data. A first data result is received and stored on the local computer system and incorporated into a third query. The third query is executed against the local data and the first data result to produce a result. Sensitive data may be stored locally in a dimension table of a star schema and non-sensitive data may be stored remotely in a fact table and another dimension table of the star schema, for example.

公开(公告)号：US20120011149A1

公开(公告)日：2012-01-12

申请号：US12834750

申请日：2010-07-12

Applicant: Thomas Zurek

Inventor： Thomas Zurek

IPC: G06F17/30

CPC classification number: G06F17/30545 ,  G06F17/30477

Abstract: In one embodiment the present invention includes a computer-implemented method comprising receiving a first query in a local computer system to access data stored on a remote computer system the local computer system. Data elements of the remote data are associated with data elements of the local data. The query is transformed into multiple queries. A second query is sent to the remote computer system to retrieve remote data. A first data result is received and stored on the local computer system and incorporated into a third query. The third query is executed against the local data and the first data result to produce a result. Sensitive data may be stored locally in a dimension table of a star schema and non-sensitive data may be stored remotely in a fact table and another dimension table of the star schema, for example.

Abstract translation: 在一个实施例中，本发明包括计算机实现的方法，包括在本地计算机系统中接收第一查询以访问存储在本地计算机系统的远程计算机系统上的数据。 远程数据的数据元素与本地数据的数据元素相关联。 该查询被转换成多个查询。 第二个查询将发送到远程计算机系统以检索远程数据。 第一数据结果被接收并存储在本地计算机系统上并且被并入第三查询中。 针对本地数据和第一数据结果执行第三个查询以产生结果。 敏感数据可以本地存储在星型模式的维度表中，并且非敏感数据可以远程存储在事实表中，例如，星型模式的另一维度表。

公开(公告)号：US20100169267A1

公开(公告)日：2010-07-01

申请号：US12347729

申请日：2008-12-31

Applicant: Peter John ,  Thomas Zurek

Inventor： Peter John ,  Thomas Zurek

IPC: G06F17/30

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

公开(公告)号：US07668803B2

公开(公告)日：2010-02-23

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

公开(公告)号：US20080275900A1

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

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

公开(公告)号：US07356524B2

公开(公告)日：2008-04-08

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