公开(公告)号：US07308460B2

公开(公告)日：2007-12-11

申请号：US11016240

申请日：2004-12-17

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose A. Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter A. Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose A. Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter A. Carlin

IPC分类号： G06F17/30

CPC分类号： G06F7/00 ,  G06F17/30289 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

摘要翻译： 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码，并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册，该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先，类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二，类必须能够返回用户定义类型的空值。 第三，类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求，数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列，将变量和参数声明为函数和存储过程，以及评估SQL查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

公开(公告)号：US06976029B2

公开(公告)日：2005-12-13

申请号：US10775282

申请日：2004-02-10

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose A. Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter A. Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose A. Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter A. Carlin

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

CPC分类号： G06F7/00 ,  G06F17/30289 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

摘要翻译： 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码，并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册，该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先，类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二，类必须能够返回用户定义类型的空值。 第三，类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求，数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列，将变量和参数声明为函数和存储过程，以及评估SQL查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

公开(公告)号：US07596576B2

公开(公告)日：2009-09-29

申请号：US11057475

申请日：2005-02-14

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose A. Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter A. Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose A. Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter A. Carlin

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

CPC分类号： G06F7/00 ,  G06F17/30289 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

摘要翻译： 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码，并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册，该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先，类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二，类必须能够返回用户定义类型的空值。 第三，类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求，数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列，将变量和参数声明为函数和存储过程，以及评估SQL查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

公开(公告)号：US20050177585A1

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

申请号：US11057475

申请日：2005-02-14

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

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

CPC分类号： G06F7/00 ,  G06F17/30289 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

公开(公告)号：US20050177583A1

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

申请号：US11016240

申请日：2004-12-17

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

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

CPC分类号： G06F7/00 ,  G06F17/30289 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

公开(公告)号：US20050177589A1

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

申请号：US10775282

申请日：2004-02-10

申请人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

发明人： Ramachandran Venkatesh ,  Jun Fang ,  Jose Blakeley ,  Beysim Sezgin ,  Balaji Rathakrishnan ,  Peter Carlin

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

CPC分类号： G06F7/00 ,  G06F17/30289 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

摘要翻译： 数据库系统和方法允许用户以实现定义用户定义类型的结构的类的高级编程语言编写程序代码，并且可以在该类型的实例上调用方法。 该类然后向数据库系统注册，该系统针对类强制执行用户定义类型的特定合同。 合同包括以下要求。 首先，类必须为数据库存储中的用户定义类型的持久化实例指定多种不同格式之一。 第二，类必须能够返回用户定义类型的空值。 第三，类必须提供一种将用户定义类型转换为另一种类型的方法。 一旦满足这些要求，数据库系统就可以创建用户定义类型的实例。 可以在可以使用任何其他内置类型的所有上下文中使用用户定义的类型。 这包括定义表的列，将变量和参数声明为函数和存储过程，以及评估SQL查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

公开(公告)号：US07437346B2

公开(公告)日：2008-10-14

申请号：US10776664

申请日：2004-02-10

申请人： Shrinivas Ashwin ,  Jose A. Blakeley ,  Peter Carlin ,  Jun Fang ,  Ajay Kalhan ,  Christian Kleinerman ,  Stefano Stefani ,  Aleksandras Surna ,  Honggang Zhang

发明人： Shrinivas Ashwin ,  Jose A. Blakeley ,  Peter Carlin ,  Jun Fang ,  Ajay Kalhan ,  Christian Kleinerman ,  Stefano Stefani ,  Aleksandras Surna ,  Honggang Zhang

IPC分类号： G06F7/00

CPC分类号： G06F17/30504 ,  Y10S707/99931 ,  Y10S707/99936 ,  Y10S707/99943

摘要： Various embodiments of the present invention are direct to the utilization of Blob Handles (BHs) which are an internal representation of a large value. BHs are immutable and stateless references to a large data object. The structure of a BH contains enough information to return an ILockBytes interface in order to provide access to the corresponding large data block, and a BH can also return information regarding its own lifetime description. A BH can be completely described using (a) a pointer to the beginning of BH data and (b) the byte-length of the BH.

摘要翻译： 本发明的各种实施例直接利用作为大值的内部表示的Blob句柄（BH）。 BH是不可变的和无状态的引用大型数据对象。 BH的结构包含足够的信息来返回ILockBytes接口，以便提供对相应的大数据块的访问，并且BH还可以返回关于其自身寿命描述的信息。 可以使用（a）指向BH数据的开始的指针和（b）BH的字节长度来完全描述BH。

公开(公告)号：US20130151459A1

公开(公告)日：2013-06-13

申请号：US13818305

申请日：2011-07-29

申请人： Jun Fang

发明人： Jun Fang

IPC分类号： G06N5/02

CPC分类号： G06N5/022 ,  G06F17/30678

摘要： A method is provided for “but reasoning” with an inconsistent knowledge base. The method not only gives an answer to a Boolean question but also additional and instructive information. The method first finds a bridge statement that explains a contradiction between the answer and the inconsistent knowledge base. The method then selects a but statement that causes the contradiction with the answer, and constructs and validates a but answer with the answer, the but statement, and optionally the bridge statement.

摘要翻译： 提供了一种具有不一致知识库的“但推理”的方法。 该方法不仅给出了布尔问题的答案，还给出了额外的和有启发性的信息。 该方法首先找到解释答案与不一致知识库之间的矛盾的桥梁语句。 然后，该方法选择一个导致与答案矛盾的声明，并用答案，but语句，以及可选的bridge语句来构造和验证一个但是答案。

公开(公告)号：US08401998B2

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

申请号：US12875004

申请日：2010-09-02

申请人： Pradeep Jnana Madhavarapu ,  Priyank Porwal ,  Vaibhav Kamra ,  Alexandru C. Chirica ,  Cristian Diaconu ,  Jun Fang ,  Srinivasmurthy P. Acharya

发明人： Pradeep Jnana Madhavarapu ,  Priyank Porwal ,  Vaibhav Kamra ,  Alexandru C. Chirica ,  Cristian Diaconu ,  Jun Fang ,  Srinivasmurthy P. Acharya

IPC分类号： G06F17/30

CPC分类号： G06F17/30174 ,  G06F11/1471 ,  G06F11/2038 ,  G06F11/2041 ,  G06F11/2097 ,  G06F2201/855

摘要： The present invention extends to methods, systems, and computer program products for mirroring file data. Generally, high availability and disaster recovery (“HADRON”) is achieved within a database management system by detecting which parts of a file have changed and sending the changed parts to secondaries. Adjacent or partially overlapping parts of a file can coalesce to form larger chunks of changed data. Coalescing reduces the overall number of chunks that are tracked.

摘要翻译： 本发明扩展到用于镜像文件数据的方法，系统和计算机程序产品。 通常，通过检测文件的哪些部分已更改并将更改后的部分发送到次要数据库管理系统中，可实现高可用性和灾难恢复（HADRON）。 文件的相邻或部分重叠的部分可以合并以形成更大的更改数据块。 合并减少了跟踪的块的总数。

公开(公告)号：US20120303667A1

公开(公告)日：2012-11-29

申请号：US13565608

申请日：2012-08-02

申请人： Pradeep Madhavarapu ,  Michael Warmington ,  Alexandru Chirica ,  Jun Fang ,  Rohan Kumar ,  Maciej Plaza ,  Srini Acharya

发明人： Pradeep Madhavarapu ,  Michael Warmington ,  Alexandru Chirica ,  Jun Fang ,  Rohan Kumar ,  Maciej Plaza ,  Srini Acharya

IPC分类号： G06F17/30

CPC分类号： G06F17/30082 ,  G06F17/30091 ,  G06F17/30286 ,  G06F17/30318

摘要： A method for managing a binary object in a database system is provided. The method may include receiving a request to store the binary object and determining if a size of the binary object is above a first threshold. If the size is less than the first threshold, the method may include storing the binary object in a database of the database system using a database communication protocol. If the size is above the first threshold, the method may include determining if the size is above a second threshold. To this end, if the size is less than the second threshold, the method may include storing the binary object in a file system of the database system using the database communication protocol. Furthermore, if the size is above the second threshold, the method may include storing the binary object in the file system using a file system communication protocol.

摘要翻译： 提供了一种用于管理数据库系统中的二进制对象的方法。 该方法可以包括接收存储二进制对象的请求，并确定二进制对象的大小是否高于第一阈值。 如果大小小于第一阈值，则该方法可以包括使用数据库通信协议将二进制对象存储在数据库系统的数据库中。 如果大小高于第一阈值，则该方法可以包括确定大小是否高于第二阈值。 为此，如果大小小于第二阈值，则该方法可以包括使用数据库通信协议将二进制对象存储在数据库系统的文件系统中。 此外，如果大小高于第二阈值，则该方法可以包括使用文件系统通信协议将二进制对象存储在文件系统中。