公开(公告)号：US06266673B1

公开(公告)日：2001-07-24

申请号：US09589601

申请日：2000-06-07

申请人： Chin-Heng Hong ,  Sudheer Thakur ,  Anil Nori ,  Joyo Wijaya

发明人： Chin-Heng Hong ,  Sudheer Thakur ,  Anil Nori ,  Joyo Wijaya

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944

摘要： A mechanism is described for processing requests to specify operations to database objects. A request to perform an action on a set of multiple objects is received by a database system. The request includes references to each object in the set, each reference indicating a table where the respective object resides. The reference is used to locate the object, and once located, the action is performed on the object. The reference may indicate a table using a unique table id not used in any of a plurality of databases to identify a table. The action request may be to modify the object, the references may include references to objects that reside in different database systems.

摘要翻译： 描述了一种用于处理对数据库对象指定操作的请求的机制。 数据库系统接收到对一组多个对象执行操作的请求。 请求包括对集合中每个对象的引用，每个引用指示相应对象所在的表。 该引用用于定位对象，一旦找到，对对象执行操作。 参考可以指示使用在多个数据库中的任何一个中未使用的唯一表id来标识表的表。 动作请求可以是修改对象，引用可以包括对驻留在不同数据库系统中的对象的引用。

公开(公告)号：US06134558A

公开(公告)日：2000-10-17

申请号：US961740

申请日：1997-10-31

申请人： Chin-Heng Hong ,  Sudheer Thakur ,  Anil Nori ,  Joyo Wijaya

发明人： Chin-Heng Hong ,  Sudheer Thakur ,  Anil Nori ,  Joyo Wijaya

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944

摘要： A method and apparatus for generating references to a set of objects which reside in a plurality databases is described. Each object is associated with a table from a plurality of tables that are contained in the plurality of databases. An object id is associated with each object; the object id uniquely identifies the object relative to the objects in the set of objects. A table id is associated with each table; the table id uniquely identifies the table relative to tables in the plurality of tables. A table containing an object is located based on the table id associated with the table, and the object is located in the table based on the object id associated with the object. A table mapping is generated. The table mapping maps a set of tables to databases associated with the set of tables. The set of tables are from the plurality of tables. References to objects from the set of object are generated. Each reference comprises data that identifies an object. The reference contains data representing the object id of the referenced object, the object referred to by the reference. The reference also contains data representing the table id of the table containing the referenced object. An object is located based on the table mapping and the reference referring to the object. The table containing the object is located based on the data in the reference, the data representing the table id associated with the table containing the object.

摘要翻译： 描述了一种生成对驻留在多个数据库中的一组对象的引用的方法和装置。 每个对象与来自多个数据库中包含的多个表的表相关联。 对象id与每个对象相关联; 对象id唯一地标识相对于对象集合中的对象的对象。 表id与每个表相关联; 表id唯一地标识相对于多个表中的表的表。 包含对象的表基于与表相关联的表id来定位，并且该对象位于表中，基于与对象相关联的对象id。 生成表映射。 表映射将一组表映射到与该组表相关联的数据库。 表的集合来自多个表。 生成来自该对象对象的引用。 每个引用包括标识对象的数据。 引用包含表示引用对象的对象标识的数据，引用对象所引用的对象。 该引用还包含表示包含引用对象的表的表id的数据。 基于表映射和引用对象的引用来定位对象。 包含对象的表根据引用中的数据定位，表示与包含对象的表相关联的表id的数据。

公开(公告)号：US6108664A

公开(公告)日：2000-08-22

申请号：US962415

申请日：1997-10-31

申请人： Anil Nori ,  Chin Hong ,  Joyo Wijaya ,  Tze-Pin Cheng ,  Robert P. Kooi, deceased

发明人： Anil Nori ,  Chin Hong ,  Joyo Wijaya ,  Tze-Pin Cheng ,  Robert P. Kooi, deceased

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30607 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945

摘要： A method and apparatus for presenting and modifying data from a set of tables in a database is provided. A view that is defined is based on a set of one or more tables that may include relational tables or object tables. The view defines a presentation of data from the one or more tables as a set of objects that reside in the database. Data is read from the one or more rows of the tables based on the view, and is presented as a set of objects that reside in the database. An object id that is based on data from the one or more rows is generated and associated with each object presented. The view may specify which columns from the one or more tables contain values used to generate the object ids. A trigger may associated with the view. The set of objects presented may be presented as objects having an attribute that is a column object. Column objects include user specified object types, collection objects (e.g. nested tables and variable arrays), or references to objects.

摘要翻译： 提供了一种用于从数据库中的一组表格呈现和修改数据的方法和装置。 定义的视图基于可以包括关系表或对象表的一组或多个表的集合。 该视图将来自一个或多个表的数据的呈现定义为驻留在数据库中的一组对象。 基于视图从表的一行或多行中读取数据，并将其呈现为驻留在数据库中的一组对象。 基于来自一行或多行的数据的对象id被生成并且与呈现的每个对象相关联。 视图可以指定一个或多个表中的哪些列包含用于生成对象ID的值。 触发器可能与视图相关联。 所呈现的对象集可以被呈现为具有作为列对象的属性的对象。 列对象包括用户指定的对象类型，集合对象（例如嵌套表和变量数组）或对象的引用。

公开(公告)号：US20090313436A1

公开(公告)日：2009-12-17

申请号：US12465667

申请日：2009-05-14

申请人： Muralidhar Krishnaprasad ,  Anil Nori ,  Subramanian Muralidhar ,  Sudhir Mohan Jorwekar ,  Lakshmi Suresh Goduguluru

发明人： Muralidhar Krishnaprasad ,  Anil Nori ,  Subramanian Muralidhar ,  Sudhir Mohan Jorwekar ,  Lakshmi Suresh Goduguluru

IPC分类号： G06F12/08 ,  G06F12/00

CPC分类号： G06F12/0802 ,  G06F12/0813

摘要： A cache region can be created in a cache in response to receiving a cache region creation request from an application. A storage request from the application can identify the cache region and one or more objects to be stored in the cache region. Those objects can be stored in the cache region in response to receiving the storage request.

摘要翻译： 响应于从应用程序接收高速缓存区域创建请求，可以在高速缓存中创建高速缓存区域。 来自应用的存储请求可以识别高速缓存区域和要存储在高速缓存区域中的一个或多个对象。 响应于接收到存储请求，可以将这些对象存储在高速缓存区域中。

公开(公告)号：US20060123020A1

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

申请号：US11004933

申请日：2004-12-07

申请人： Andrew Bybee ,  Anil Nori ,  Balan Raman ,  Timothy McKee ,  Walter Smith

发明人： Andrew Bybee ,  Anil Nori ,  Balan Raman ,  Timothy McKee ,  Walter Smith

IPC分类号： G06F7/00

CPC分类号： G06F16/164

摘要： A file system that does not require unique item names, or any item name at all, is described herein. If an item has an ambiguous name, the file system performs a disambiguating procedure to provide the client (user or application) a conceptually unique name, including a fully qualified path. The file system provides usability features such that the file system maintains compatibility with legacy applications and systems, including creating a synthetic item name when the item has no name, and disambiguating two items having the same name by using a disambiguating character, such as a small integer or alphanumeric character.

摘要翻译： 本文描述了不需要唯一项目名称或任何项目名称的文件系统。 如果某个项目具有不明确的名称，则文件系统将执行消歧义过程，以向客户端（用户或应用程序）提供概念上唯一的名称，包括完全限定的路径。 文件系统提供可用性特征，使得文件系统保持与遗留应用和系统的兼容性，包括当该项目没有名称时创建合成项目名称，以及通过使用消歧字符来消除具有相同名称的两个项目，例如小的 整数或字母数字字符

公开(公告)号：US06738782B2

公开(公告)日：2004-05-18

申请号：US10096008

申请日：2002-03-11

申请人： Nipun Agarwal ,  Dinesh Das ,  Viswanathan Krishnamurthy ,  Ravi Murthy ,  Anil Nori ,  Jagannathan Srinivasan

发明人： Nipun Agarwal ,  Dinesh Das ,  Viswanathan Krishnamurthy ,  Ravi Murthy ,  Anil Nori ,  Jagannathan Srinivasan

IPC分类号： G06F1730

CPC分类号： G06F17/30471 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A method and system for optimizing the execution of database statement is described. Optimization of database statements having non-boolean predicates is disclosed. Also disclosed is the determination and use of different granularity levels of information for submitting database statement predicates to optimizer-related functions.

摘要翻译： 描述了优化数据库语句执行的方法和系统。 公开了具有非布尔谓词的数据库语句的优化。 还披露了将数据库语句谓词提交给优化器相关函数的不同粒度级别的信息的确定和使用。

公开(公告)号：US20050050537A1

公开(公告)日：2005-03-03

申请号：US10646645

申请日：2003-08-21

申请人： J. Thompson ,  Anil Nori

发明人： J. Thompson ,  Anil Nori

IPC分类号： G06F9/44

CPC分类号： G06F17/30067 ,  G06F8/24 ,  G06F17/30607 ,  Y10S707/99944

摘要： Various embodiments of the present invention are directed to a method for manipulating a plurality of discrete units of information (“Items”) in a hardware/software interface system for a computer system, said method comprising interconnecting said Items with a plurality of Relationships and managing said Relationships at the hardware/software interface system level. Each Relationship constitutes, at the hardware/software interface system level, a mapping between a pair of Items that said Relationship interconnects. Moreover, each Relationship may have properties of its own distinct and separate from the properties of the Items it interconnects.

摘要翻译： 本发明的各种实施例涉及一种在用于计算机系统的硬件/软件接口系统中操纵多个离散信息单元（“项目”）的方法，所述方法包括将所述项目与多个关系互连并管理 在硬件/软件界面系统层面说关系。 每个关系在硬件/软件界面系统层面上构成了所述关系互连的一对项目之间的映射。 此外，每个关系可以具有其自身的属性，与其互连的项目的属性不同。

公开(公告)号：US20050049994A1

公开(公告)日：2005-03-03

申请号：US10646940

申请日：2003-08-21

申请人： J. Thompson ,  Kim Cameron ,  Walter Smith ,  Anil Nori

发明人： J. Thompson ,  Kim Cameron ,  Walter Smith ,  Anil Nori

IPC分类号： G06F17/30

CPC分类号： G06F17/30595

摘要： Various embodiments of the present invention are directed to a method, in a computer system, for a hardware/software interface system to manipulate a plurality of discrete units of information having properties understandable by said hardware/software interface system (“Items”). The method uses a base schema comprising at least one of an Item as a base Item from which all other Items are derived, and at least one of a property as a base property from which all other properties are derived. Furthermore, an Item may comprise a property for referencing Categories to which the Item is a member. The Item may also comprises a property for a unique identification of that Item in the hardware/software interface system.

摘要翻译： 本发明的各种实施例涉及一种在计算机系统中用于硬件/软件接口系统来操纵具有由所述硬件/软件接口系统（“项目”）可理解的属性的信息的多个离散单元的方法。 该方法使用包括作为所有其他项目的基础项目的至少一个的基本模式，以及从其导出所有其他属性的作为基本属性的属性中的至少一个。 此外，项目可以包括用于引用项目是成员的类别的属性。 该项目还可以包括用于在硬件/软件接口系统中该物品的唯一标识的属性。

公开(公告)号：US20050049993A1

公开(公告)日：2005-03-03

申请号：US10646580

申请日：2003-08-21

申请人： Anil Nori ,  Sameet Agarwal ,  J. Thompson ,  Pedro Celis ,  David Campbell ,  F. Terek

发明人： Anil Nori ,  Sameet Agarwal ,  J. Thompson ,  Pedro Celis ,  David Campbell ,  F. Terek

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

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

摘要： Various embodiments of the present invention are directed to a data store comprising Items, Elements, and Relationships. An Item is a unit of data storable in a data store and further comprises said Element and said Relationship. An Element is an instance of a type comprising one or more fields. A Relationship is a link between at least two Items. The data store further comprising a Core Schema to define a set of Core Items by which a hardware/software interface system understands and directly processes said set of Core Items in a predetermined and predictable way. The Core Items are derived (directly or indirectly) from a common single Base Item which, in turn, is a foundational Item in a Base Schema.

摘要翻译： 本发明的各种实施例涉及包括项目，元素和关系的数据存储。 项目是可存储在数据存储中的数据的单元，并且还包括所述元素和所述关系。 元素是包含一个或多个字段的类型的实例。 关系是至少两个项目之间的链接。 所述数据存储器还包括核心模式以定义一组核心项目，硬件/软件接口系统通过该核心模块系统以预定和可预测的方式理解并直接处理所述一组核心项目。 核心项目是从一个普通的单个基础项目派生（直接或间接的），而该基础项目又是基本模式中的基础项目。

公开(公告)号：US06286015B1

公开(公告)日：2001-09-04

申请号：US09149889

申请日：1998-09-08

申请人： Rajagopalan Govindarajan ,  Viswanathan Krishnamurthy ,  Anil Nori

发明人： Rajagopalan Govindarajan ,  Viswanathan Krishnamurthy ,  Anil Nori

IPC分类号： G06F1730

CPC分类号： G06F17/30607 ,  Y10S707/99942 ,  Y10S707/99944 ,  Y10S707/99952

摘要： A method and apparatus are provided for handling within a database system data items that are associated with data types whose native structure is not known to the database system. The data items are stored within the database system in their native structure, even though it is not understood by the database system. To store the data items, the database system calls a pickling routine that is provided by the user, or by the runtime subsystem of the programming environment that is native to the data item. To retrieve the routine from storage, the database system calls an unpickling routine, also provided by the user or the appropriate runtime subsystem. Because the database maintains the data items in their native format, no conversions are required as the data items are passed between the database system and external routines that manipulate the data items. Techniques are also provided for declaring attributes of the data item that can be accessed within the database system. The user provides routines for the database system to call in order to access the declared attributes, which may be different than the actual attributes that the data item has in its native environment.

摘要翻译： 提供了一种方法和装置，用于在数据库系统内处理与其本身结构对于数据库系统不知道的数据类型相关联的数据项。 数据项以其本机结构存储在数据库系统中，即使数据库系统不了解。 为了存储数据项，数据库系统调用由用户提供的酸洗程序，或者由数据项原生的编程环境的运行时子系统。 要从存储中检索该例程，数据库系统调用由用户或适当的运行时子系统提供的unpickling例程。 由于数据库以其本机格式维护数据项，因此数据项在数据库系统和操作数据项的外部例程之间传递时，不需要转换。 还提供了用于声明可在数据库系统中访问的数据项的属性的技术。 用户提供数据库系统调用的例程，以访问声明的属性，这可能与数据项在其本机环境中具有的实际属性不同。