专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US06823373B1 System and method for coupling remote data stores and mobile devices via an internet based server 有权
标题翻译：通过基于互联网的服务器耦合远程数据存储和移动设备的系统和方法
公开(公告)号：US06823373B1
公开(公告)日：2004-11-23
申请号：US09637958
申请日：2000-08-11
申请人： Girish Pancha , A. Adam Wilson , Sankaran Suresh , Spencer A. Lord
发明人： Girish Pancha , A. Adam Wilson , Sankaran Suresh , Spencer A. Lord
IPC分类号： G06F1300
CPC分类号： H04L67/2819 , H04L67/04 , H04L67/2828 , H04L69/08 , H04L69/329 , H04W8/18 , H04W8/245 , Y10S707/99945 , Y10S707/99948
摘要： The present invention provides a mobile data communication system which couples application specific remote data sources and mobile devices via an internet based server. An interface is provided by the server for extracting data from the application specific remote data sources. The extracted data is then generalized into generic objects and presented on the mobile devices by device specific application templates.
摘要翻译：本发明提供了一种移动数据通信系统，其通过基于因特网的服务器耦合特定于应用的远程数据源和移动设备。接口由服务器提供，用于从应用程序特定的远程数据源中提取数据。然后将提取的数据概括为通用对象，并通过设备特定应用程序模板在移动设备上呈现。

2. 发明授权

US06208990B1 Method and architecture for automated optimization of ETL throughput in data warehousing applications 失效
标题翻译：在数据仓库应用程序中自动优化ETL吞吐量的方法和架构
公开(公告)号：US06208990B1
公开(公告)日：2001-03-27
申请号：US09116426
申请日：1998-07-15
申请人： Sankaran Suresh , Jyotindra Pramathnath Gautam , Girish Pancha , Frank Joseph DeRose , Mohan Sankaran
发明人： Sankaran Suresh , Jyotindra Pramathnath Gautam , Girish Pancha , Frank Joseph DeRose , Mohan Sankaran
IPC分类号： G06F1730
CPC分类号： G06F17/30563 , Y10S707/99936 , Y10S707/99943 , Y10S707/99945
摘要： A computer software architecture to automatically optimize the throughput of the data extraction/transformation/loading (ETL) process in data warehousing applications. This architecture has a componentized aspect and a pipeline-based aspect. The componentized aspect refers to the fact that every transformation used in this architecture is built up with transformation components selected from an extensible set of transformation components. Besides simplifying source code maintenance and adjustment for the data warehouse users, these transformation components also provide these users the building blocks to effectively construct pertinent and functionally sophisticated transformations in a pipelined manner. Within a pipeline, each transformation component automatically stages or streams its data to optimize ETL throughput. Furthermore, each transformation either pushes data to another transformation component, pulls data from another transformation component, or performs a push/pull operation on the data. Thereby, the pipelining; staging/streaming; and pushing/pulling features of the transformation components effectively optimizes the throughput of the ETL process.
摘要翻译：一种计算机软件架构，用于自动优化数据仓库应用程序中数据提取/转换/加载（ETL）流程的吞吐量。该架构具有组件化方面和基于流水线的方面。组件化方面是指在该架构中使用的每个变换都是由可扩展的转换组件集合中选择的转换组件构建的。除了简化数据仓库用户的源代码维护和调整外，这些转换组件还为这些用户提供了以流水线方式有效构建相关和功能复杂的转换的构建块。在管道中，每个转换组件自动对其数据进行排序或流式传输，以优化ETL吞吐量。此外，每个变换将数据推送到另一个变换组件，从另一变换组件中提取数据，或对数据执行推/拉操作。因此，流水线; 分段/流式传输并且转换组件的推/拉功能有效地优化了ETL过程的吞吐量。

3. 发明授权

US5794246A Method for incremental aggregation of dynamically increasing database data sets 失效
标题翻译：动态增加数据库数据集的增量聚合方法
公开(公告)号：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。如果输入的组标识符与任何存储的组标识符不匹配，则输入的组标识符和对应的数据值被存储在中间文件中，并且将一个计数值附加到该特定组标识符。一旦确定了新组输入数据中的所有组标识符，计算机将对中间文件所做的所有更改存储到聚合数据集中。

4. 发明授权

US06032158A Apparatus and method for capturing and propagating changes from an operational database to data marts 失效
标题翻译：用于从操作数据库捕获和传播变化到数据集市的装置和方法
公开(公告)号：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.
摘要翻译：一种用于响应于由事务对存储在操作数据库的源表中的数据所做的改变来更新数据集市的目标表的方法。由事务在源表中更改的数据存储在更改捕获数据库的动态映像表中。在事务处理源表中未被更改但仍需要映射到目标表的数据存储在变更捕获数据库的静态映像表中。更改捕获数据库还包含有关事务的相关信息。一旦动态和静态映像表被正确地分级，更改将从更改捕获数据库传播到数据集市的目标表。换句话说，从变更捕获数据库中提取数据，随后进行变换和加载，从而最小化对操作数据库的影响。因此，更改捕获数据库的表被截断以丢弃现在不再需要的数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式