公开(公告)号：US07158994B1

公开(公告)日：2007-01-02

申请号：US10006605

申请日：2001-12-05

申请人： Wayne Smith ,  Mahesh Subramaniam ,  Subramanian Muralidhar

发明人： Wayne Smith ,  Mahesh Subramaniam ,  Subramanian Muralidhar

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

CPC分类号： G06F17/30418 ,  G06F17/30383 ,  G06F17/30457 ,  Y10S707/954 ,  Y10S707/99932 ,  Y10S707/99943 ,  Y10S707/99944

摘要： Techniques are provided for creating object-oriented materialized views. The object-oriented materialized views may be object materialized views or object-relational materialized views. The base tables may be object tables, object relational tables, or relational tables. The object-oriented materialized views may be refreshed, fully or incrementally. When an object-oriented materialized view is created, refresh code is generated for it. Through the use of object-oriented materialized views, users gain both the efficiency of materialized views and the power of the object-oriented paradigm.

摘要翻译： 提供了用于创建面向对象的物化视图的技术。 面向对象的物化视图可以是对象物化视图或物体关系物化视图。 基表可以是对象表，对象关系表或关系表。 面向对象的物化视图可以被刷新，完全或递增。 当创建面向对象的物化视图时，会为其生成刷新代码。 通过使用面向对象的物化视图，用户可以获得物化视图的效率和面向对象范式的力量。

公开(公告)号：US06965899B1

公开(公告)日：2005-11-15

申请号：US09968703

申请日：2001-09-28

申请人： Mahesh Subramaniam ,  Joan Loaiza

发明人： Mahesh Subramaniam ,  Joan Loaiza

IPC分类号： G06F17/30

CPC分类号： G06F17/30339 ,  Y10S707/99943

摘要： Techniques are provided for allowing the reorganization and/or redefinition of data in a relational database with minimal or no downtime by allowing “online” reorganization/redefinition of the data. According to one aspect of the invention, an empty revised table is created in the same schema as the target table. The revised table is created with the attributes that are desired for the reorganization/redefinition of the target table. Triggers, constraints, grants and indexes that are associated with the target table are replicated for the revised table. The reorganization/redefinition is performed by using an underlying mechanism that involves using incrementally maintainable materialized views.According to one feature, the revised table is initialized and periodically synchronized with the target table. After the reorganization and/or redefinition is complete on the revised table, the revised table and the target table switch identities such that the revised table is now the target table and the target table becomes the revised table.

摘要翻译： 提供了技术，允许通过允许“在线”重组/重新定义数据，使关系数据库中的数据重新组织和/或重新定义最少或无停机时间。 根据本发明的一个方面，在与目标表相同的模式中创建空修订表。 修改后的表格将使用目标表重组/重新定义所需的属性创建。 与目标表关联的触发器，约束，授权和索引将复制为修订的表。 重组/重新定义是通过使用涉及使用增量可维护的物化视图的底层机制来执行的。 根据一个特征，修改的表被初始化并且与目标表周期性地同步。 修改后的表格和/或重新定义完成后，修订表和目标表切换标识，使修订表现在成为目标表，目标表成为修订表。

公开(公告)号：US06532479B2

公开(公告)日：2003-03-11

申请号：US09322153

申请日：1999-05-28

申请人： Benny Souder ,  Alan Robert Downing ,  Harry Sun ,  Alan J. Demers ,  James William Stamos ,  John C. Graham ,  Curtis Elsbernd ,  Mahesh Subramaniam ,  Wayne E. Smith

发明人： Benny Souder ,  Alan Robert Downing ,  Harry Sun ,  Alan J. Demers ,  James William Stamos ,  John C. Graham ,  Curtis Elsbernd ,  Mahesh Subramaniam ,  Wayne E. Smith

IPC分类号： G06F1200

CPC分类号： G06F17/30575 ,  Y10S707/99952

摘要： Replication for front office automation involves the use of snapshots that are instantiated on laptops, in which refreshing the snapshots is driven from a master site with a high-performance protocol. All of the necessary snapshot metadata for performing the snapshot refreshes is stored at the master site, so that the laptop only needs to send a single refresh request. In response to the refresh request, the master site reconciles the differences between the master tables and the laptop's snapshots and transmits the differences to the laptop, reducing the necessary network traffic for updating a snapshot to a single round trip.

摘要翻译： 用于前台自动化的复制涉及使用在笔记本电脑上实例化的快照，其中使用高性能协议从主站点刷新快照。 用于执行快照刷新的所有必需的快照元数据都存储在主站点，以便笔记本电脑只需要发送单个刷新请求。 响应刷新请求，主站点协调主表和笔记本电脑快照之间的差异，并将差异传输到笔记本电脑，从而减少将快照更新到单次往返的必要网络流量。

公开(公告)号：US20140323181A1

公开(公告)日：2014-10-30

申请号：US13874459

申请日：2013-04-30

申请人： Mahesh Subramaniam ,  Jamuna Rani Balu

发明人： Mahesh Subramaniam ,  Jamuna Rani Balu

IPC分类号： H04W92/08

CPC分类号： H04M1/7253 ,  H04M1/72527 ,  H04W4/38 ,  H04W84/18

摘要： A system and method to acquire data from a sensor and transfer the data to an external device is disclosed. The sensor retrieves data that corresponds to vibration or pressure and send the millivolt (mV) signal to an accessory. The accessory acquires the data will be much more cost effective compared to dedicated instruments to acquire data and analyze data in itself. The external device collects data and can email the data or sent to cloud due to ready interface from the external device. More advanced calculations can be performed on cloud and results sent back to the external device for detail analysis. The embodiment provides such back and forth analysis using the accessory.

摘要翻译： 公开了一种从传感器获取数据并将数据传送到外部设备的系统和方法。 传感器检索对应于振动或压力的数据，并将毫伏（mV）信号发送到附件。 与专用仪器相比，附件获取的数据将更加成本有效地获取数据并分析数据本身。 外部设备收集数据，并可以通过外部设备接口准备好电子邮件发送数据或发送到云端。 可以对云进行更高级的计算，并将结果发送回外部设备进行详细分析。 该实施例使用附件提供了这种前后分析。

公开(公告)号：US20140129587A1

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

申请号：US13670471

申请日：2012-11-07

申请人： Mahesh Subramaniam

发明人： Mahesh Subramaniam

IPC分类号： G06F17/30 ,  G09G5/34

CPC分类号： G09G5/34 ,  G06F16/24568 ,  G09G5/346

摘要： This embodiment relates to Distributed Control Systems graphics display for better viewing and process control. DCS graphics display presents the entire plant process as a scrollable application. Data files, describing the equipments, pipes, and distances between them are used as inputs to create graphic display. A rendering engine converts the input data files into viewable graphic display with static and dynamic elements shown. A facility is provided for Users/operators to query process condition on graphic display. The results of query are published as list and marked in Graphic display. The rendering engine displays the graphic, at the maximum zoom level, so as to include all results of query.

摘要翻译： 该实施例涉及分布式控制系统图形显示器，用于更好地观看和过程控制。 DCS图形显示将整个工厂流程呈现为可滚动应用程序。 描述设备，管道和它们之间的距离的数据文件用作输入以创建图形显示。 渲染引擎将输入数据文件转换为可见图形显示，显示静态和动态元素。 为用户/操作者提供了一个设施来查询图形显示的过程状态。 查询结果作为列表发布，并以图形显示标记。 渲染引擎以最大缩放级别显示图形，以便包括查询的所有结果。

公开(公告)号：US07103612B2

公开(公告)日：2006-09-05

申请号：US10400225

申请日：2003-03-26

申请人： Wayne E. Smith ,  Jing Liu ,  James Stamos ,  Mahesh Subramaniam

发明人： Wayne E. Smith ,  Jing Liu ,  James Stamos ,  Mahesh Subramaniam

IPC分类号： G06F17/30

CPC分类号： G06F17/30578 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945

摘要： A method and system are provided for instantiating objects for participation in information sharing relationships. According to one technique, a copy of an object is made, where the copy includes all changes made prior to a particular point in time, and no changes made after the particular point in time. The copy is used to create a second object. Data that reflects the particular point in time is stored, and subsequently used to determine which changes should be applied to the second object. Data that indicates that the creation time of the second object is stored, and subsequently used to determine which changes should be applied to the original object.

摘要翻译： 提供了一种用于实例化对象以用于参与信息共享关系的方法和系统。 根据一种技术，制作对象的副本，其中副本包括在特定时间点之前进行的所有更改，并且在特定时间点之后不做更改。 该副本用于创建第二个对象。 存储反映特定时间点的数据，随后用于确定哪些更改应用于第二个对象。 指示第二个对象的创建时间被存储的数据，并且随后用于确定哪些更改应用于原始对象。

公开(公告)号：US08161536B1

公开(公告)日：2012-04-17

申请号：US09881537

申请日：2001-06-14

申请人： Mahesh Subramaniam ,  Debashish Chatterjee ,  Debashis Saha ,  Lakshminarayanan Chidambaran

发明人： Mahesh Subramaniam ,  Debashish Chatterjee ,  Debashis Saha ,  Lakshminarayanan Chidambaran

IPC分类号： H04L29/06

CPC分类号： H04L67/2814 ,  H04L63/083 ,  H04L63/0884

摘要： Techniques for authenticating users when an operation requested by a user in one of the systems of a distributed system is redirected to another system of the distributed system. The user is authenticated in the usual way to the one system but is authenticated to the other system for the redirected operation by an authentication proxy in the first system. The fact that the authentication proxy is providing a redirected operation means that the user who requested the operation has been authenticated to the one system. The other system is thus able to authenticate the user for the redirected operation with different authentication information than would otherwise be required. An example of how the techniques are used is a distributed database system where one of the database systems in the distributed system is a cache for another of the database systems.

摘要翻译： 当用户在分布式系统的一个系统中请求的操作被重定向到分布式系统的另一个系统时，用于认证用户的技术。 用户以通常的方式对一个系统进行认证，但是通过第一系统中的认证代理对另一个系统进行重定向操作的认证。 认证代理提供重定向操作的事实意味着请求操作的用户已被认证到一个系统。 因此，另一个系统能够以与否则需要的不同的认证信息来认证重定向操作的用户。 如何使用这些技术的一个例子是分布式数据库系统，其中分布式系统中的一个数据库系统是另一个数据库系统的高速缓存。

公开(公告)号：US07769714B2

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

申请号：US11935939

申请日：2007-11-06

申请人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

发明人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

IPC分类号： G06F17/30

CPC分类号： G06F17/30578 ,  G06F11/2097

摘要： An approach is provided to automatically resolve conflict between instantiation and ongoing data replication operations. In an embodiment, incremental change records that describe one or more database operations are received at a sink entity. Here, all of the one or more database operations have occurred in a second database after a particular time. A first database operation in the one or more database operations to a particular row in the first database is applied. When a conflict with a second database operation that operates on the particular row is detected, one or more compensating actions, which may, but are not limited to, be a different database operation and/or an operation that creates a conflict log entry, may be performed. Here, the second database operation has occurred in the second database prior to the particular time. When the second database operation is to be performed, an appropriate operation may be performed.

摘要翻译： 提供了一种方法来自动解决实例化和正在进行的数据复制操作之间的冲突。 在实施例中，描述一个或多个数据库操作的增量更改记录在汇实体处被接收。 这里，在特定时间之后，所有一个或多个数据库操作都发生在第二数据库中。 应用第一个数据库中特定行的一个或多个数据库操作中的第一个数据库操作。 当检测到对在特定行上操作的第二数据库操作的冲突时，一个或多个补偿动作（其可以但不限于是不同的数据库操作和/或创建冲突日志条目的操作）可以 被执行。 这里，第二数据库操作已经在特定时间之前在第二数据库中发生。 当要执行第二数据库操作时，可以执行适当的操作。

公开(公告)号：US07031974B1

公开(公告)日：2006-04-18

申请号：US10308851

申请日：2002-12-02

申请人： Mahesh Subramaniam

发明人： Mahesh Subramaniam

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  Y10S707/99943

摘要： Techniques are disclosed for sharing information in a wide variety of contexts. An information sharing system is described that allows both an explicit capture process and an implicit capture process to add information items to a staging area. Further, the information sharing system supports both implicit and explicit consumption of information items that are stored in said staging area. A rules engine is provided to allow users to create and register rules that customize the behavior of the capture processes, the consuming processes, and propagation processes that propagate information from the staging areas to designated destinations. Techniques are also described for achieving exactly-once handling of sequence of items, where the items are maintained in volatile memory. Techniques are also provided for recording DDL operations, and for asynchronously performing operations based on the previously-performed DDL operations.

摘要翻译： 公开了用于在各种上下文中共享信息的技术。 描述了一种信息共享系统，其允许显式捕获进程和隐式捕获进程将信息项添加到分段区域。 此外，信息共享系统支持存储在所述登台区域中的信息项目的隐式和显式消费。 提供了规则引擎，以允许用户创建和注册规则，该规则可自定义捕获进程的行为，消费过程以及将信息从分段区域传播到指定目的地的传播过程。 还描述了用于实现一次处理物品序列的技术，其中物品被保存在易失性存储器中。 还提供了用于记录DDL操作以及基于先前执行的DDL操作进行异步执行操作的技术。

公开(公告)号：US20090119346A1

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

申请号：US11935939

申请日：2007-11-06

申请人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

发明人： Edwina Lu ,  Mahesh Subramaniam ,  Lik Wong ,  James Stamos ,  Nimar Singh Arora

IPC分类号： G06F17/30

CPC分类号： G06F17/30578 ,  G06F11/2097

摘要： An approach is provided to automatically resolve conflict between instantiation and ongoing data replication operations. In an embodiment, incremental change records that describe one or more database operations are received at a sink entity. Here, all of the one or more database operations have occurred in a second database after a particular time. A first database operation in the one or more database operations to a particular row in the first database is applied. When a conflict with a second database operation that operates on the particular row is detected, one or more compensating actions, which may, but are not limited to, be a different database operation and/or an operation that creates a conflict log entry, may be performed. Here, the second database operation has occurred in the second database prior to the particular time. When the second database operation is to be performed, an appropriate operation may be performed.

摘要翻译： 提供了一种方法来自动解决实例化和正在进行的数据复制操作之间的冲突。 在实施例中，描述一个或多个数据库操作的增量更改记录在汇实体处被接收。 这里，在特定时间之后，所有一个或多个数据库操作都发生在第二数据库中。 应用第一个数据库中特定行的一个或多个数据库操作中的第一个数据库操作。 当检测到对在特定行上操作的第二数据库操作的冲突时，一个或多个补偿动作（其可以但不限于是不同的数据库操作和/或创建冲突日志条目的操作）可以 被执行。 这里，第二数据库操作已经在特定时间之前在第二数据库中发生。 当要执行第二数据库操作时，可以执行适当的操作。