公开(公告)号：US06044374A

公开(公告)日：2000-03-28

申请号：US970950

申请日：1997-11-14

申请人： Diaz Nesamoney ,  Parth S. Chandra ,  Sanjeev Gupta ,  Girish Pancha ,  Jeffrey B. Taylor ,  M S Kiumarse Zamanian

发明人： Diaz Nesamoney ,  Parth S. Chandra ,  Sanjeev Gupta ,  Girish Pancha ,  Jeffrey B. Taylor ,  M S Kiumarse Zamanian

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  Y10S707/99931 ,  Y10S707/99952

摘要： A method and system for accessing and sharing metadata amongst a number of data marts through the use of object referencing. A global repository is created. Shared folders containing metadata is contained in the global repository. Any number of data marts can be linked to the global repository. Stored within the folders of the linked data marts are references pointing to certain metadata stored in the shared folders of the global repository. Multiple data marts can reference the same metadata in the global repository. Thereby, the same metadata can be accessed, used, and shared by multiple users across different data marts, provided that they have been granted the proper authority. New metadata can be promoted from a linked data mart into the global repository so that it can be shared, and updates to shared metadata can be automatically propagated to all users referencing that metadata.

摘要翻译： 一种用于通过使用对象引用在多个数据集市中访问和共享元数据的方法和系统。 创建一个全局库。 包含元数据的共享文件夹包含在全局存储库中。 任何数量的数据集市都可以链接到全局存储库。 存储在链接的数据集市的文件夹内的是指向存储在全局存储库的共享文件夹中的某些元数据的引用。 多个数据集市可以引用全局存储库中的相同元数据。 因此，相同的元数据可以被不同数据集市的多个用户访问，使用和共享，只要它们已被授予适当的权限。 可以将新的元数据从链接的数据集市推广到全局存储库中，以便可以共享，并且可以自动将对共享元数据的更新传播到引用该元数据的所有用户。

公开(公告)号：US6014670A

公开(公告)日：2000-01-11

申请号：US966449

申请日：1997-11-07

申请人： M S Kiumarse Zamanian ,  Diaz Nesamoney

发明人： M S Kiumarse Zamanian ,  Diaz Nesamoney

IPC分类号： G06F17/30

CPC分类号： G06F17/30563 ,  Y10S707/99942

摘要： A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for storing the processed data. A mapping is used for directing the data flow between the I/O ports corresponding to the source, the plurality of transformation objects, and the target. The mapping specifies the connectivity between the source, transformation, and target objects as well as the order of these connections. There are a number of different transformations which can be performed to manipulate the data. Some such transformations include: an aggregator transformation, an expression transformation, a filter transformation, a lookup transformation, a query transformation, a sequence transformation, a stored procedure transformation, and an update strategy transformation.

公开(公告)号：US20110219403A1

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

申请号：US12939064

申请日：2010-11-03

申请人： Diaz Nesamoney ,  Parth S. Chandra

发明人： Diaz Nesamoney ,  Parth S. Chandra

IPC分类号： H04N7/025

CPC分类号： H04N7/025

摘要： An advertising system delivers video ads into hypertext documents, where these ads provide enhanced user interactivity features selected and configured by advertisers or other ad sponsors. The system also provides sophisticated tracking and real time reporting of viewer interactivity with the video ads and their enhanced features.

摘要翻译： 广告系统将视频广告投放到超文本文件中，其中这些广告提供由广告商或其他广告赞助商选择和配置的增强的用户交互功能。 该系统还提供了视频广告及其增强功能的复杂跟踪和观看者互动性的实时报告。

公开(公告)号：US06032158A

公开(公告)日：2000-02-29

申请号：US850490

申请日：1997-05-02

申请人： Pinaki Mukhopadhyay ,  Diaz Nesamoney ,  Mohan Sankaran ,  Sankaran Suresh ,  Sanjeev K. Gupta

发明人： Pinaki Mukhopadhyay ,  Diaz Nesamoney ,  Mohan Sankaran ,  Sankaran Suresh ,  Sanjeev K. Gupta

IPC分类号： G06F17/30

CPC分类号： G06F17/30563 ,  G06F17/30345 ,  G06F17/30371 ,  G06F17/30592 ,  Y10S707/99952

摘要： A method for updating a target table of a data mart in response to changes made by a transaction to data stored in a source table of an operational database. Data that was changed in the source table by the transaction is stored in a dynamic image table of a change capture database. Data that was not changed in the source table by the transaction, but which is nevertheless required to be mapped to the target table, is stored in a static image table of the change capture database. The change capture database also contains relevant information regarding the transaction. Once the dynamic and static image tables are properly staged, the changes are propagated from the change capture database to the target tables of the data marts. In other words, data is extracted from the change capture database and subsequently transformed and loaded, thereby minimizing the impact to the operational database. Thereupon, the tables of the change capture database are truncated to discard data which is now no longer needed.

摘要翻译： 一种用于响应于由事务对存储在操作数据库的源表中的数据所做的改变来更新数据集市的目标表的方法。 由事务在源表中更改的数据存储在更改捕获数据库的动态映像表中。 在事务处理源表中未被更改但仍需要映射到目标表的数据存储在变更捕获数据库的静态映像表中。 更改捕获数据库还包含有关事务的相关信息。 一旦动态和静态映像表被正确地分级，更改将从更改捕获数据库传播到数据集市的目标表。 换句话说，从变更捕获数据库中提取数据，随后进行变换和加载，从而最小化对操作数据库的影响。 因此，更改捕获数据库的表被截断以丢弃现在不再需要的数据。

公开(公告)号：US09693013B2

公开(公告)日：2017-06-27

申请号：US12939064

申请日：2010-11-03

申请人： Diaz Nesamoney ,  Parth S. Chandra

发明人： Diaz Nesamoney ,  Parth S. Chandra

IPC分类号： H04N7/025

CPC分类号： H04N7/025

摘要： An advertising system delivers video ads into hypertext documents, where these ads provide enhanced user interactivity features selected and configured by advertisers or other ad sponsors. The system also provides sophisticated tracking and real time reporting of viewer interactivity with the video ads and their enhanced features.

公开(公告)号：US5794246A

公开(公告)日：1998-08-11

申请号：US846934

申请日：1997-04-30

申请人： Mohan Sankaran ,  Sankaran Suresh ,  Mon Wong ,  Diaz Nesamoney

发明人： Mohan Sankaran ,  Sankaran Suresh ,  Mon Wong ,  Diaz Nesamoney

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

CPC分类号： G06F17/30412 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99937 ,  Y10S707/99942

摘要： A method of performing incremental aggregation of dynamically increasing database data sets. An embodiment of the present invention operates within a data mart or data warehouse to aggregate data stored within an operational database corresponding to newly received data to provide current information. Initially, a computer server creates an intermediate file which is initialized by the server with an aggregate data set. The aggregate data set consists of data values and count values that each correspond to specific group identifiers. The computer determines if any group identifiers within a new set of inputs data are identical to any group identifiers stored within the intermediate file. If an inputted group identifier matches a stored group identifier, the inputted data value is aggregated with the stored data value and the count value corresponding to the specific stored group identifier is incremented by one. If an inputted group identifier does not match any of the stored group identifiers, the inputted group identifier and corresponding data value are stored within the intermediate file and a count value of one is appended to that specific group identifier. Once all the group identifiers within the new set of input data have been determined, the computer stores all the changes that were made to the intermediate file into the aggregate data set.

摘要翻译： 执行动态增加的数据库数据集的增量聚合的方法。 本发明的一个实施例在数据集市或数据仓库内操作以聚集存储在与新接收的数据相对应的操作数据库内的数据，以提供当前信息。 最初，计算机服务器创建由服务器用聚合数据集初始化的中间文件。 聚合数据集由数据值和计数值组成，每个值对应于特定的组标识符。 计算机确定新组输入数据中的任何组标识符是否与存储在中间文件中的任何组标识符相同。 如果输入的组标识符与存储的组标识符匹配，则将输入的数据值与存储的数据值进行聚合，并将与特定存储的组标识符相对应的计数值增加1。 如果输入的组标识符与任何存储的组标识符不匹配，则输入的组标识符和对应的数据值被存储在中间文件中，并且将一个计数值附加到该特定组标识符。 一旦确定了新组输入数据中的所有组标识符，计算机将对中间文件所做的所有更改存储到聚合数据集中。

公开(公告)号：US06339775B1

公开(公告)日：2002-01-15

申请号：US09442060

申请日：1999-11-16

申请人： Kiumarse Zamanian ,  Diaz Nesamoney

发明人： Kiumarse Zamanian ,  Diaz Nesamoney

IPC分类号： G06F1730

CPC分类号： G06F17/30563 ,  G06F17/30569 ,  Y10S707/99942 ,  Y10S707/99944

摘要： A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for storing the processed data. A mapping is used for directing the data flow between the I/O ports corresponding to the source, the plurality of transformation objects, and the target. The mapping specifies the connectivity between the source, transformation, and target objects as well as the order of these connections. There are a number of different transformations which can be performed to manipulate the data. Some such transformations include: an aggregator transformation, an expression transformation, a filter transformation, a lookup transformation, a query transformation, a sequence transformation, a stored procedure transformation, and an update strategy transformation.

摘要翻译： 用于指定在数据仓库应用程序中如何操纵数据的变换描述语言（TDL）。 TDL包括用于存储原始数据的源，用于根据预定义指令处理原始数据的一个或多个变换对象以及用于存储处理后的数据的目标。 映射用于引导对应于源，多个转换对象和目标的I / O端口之间的数据流。 该映射指定源，转换和目标对象之间的连接以及这些连接的顺序。 可以执行许多不同的变换来操纵数据。 一些这样的变换包括：聚合器变换，表达式变换，过滤器变换，查找变换，查询变换，序列变换，存储过程变换和更新策略变换。