利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

67 条记录 (耗时 0.03 秒)

    System and method for providing user defined types in a database system
    1.
    发明授权
    System and method for providing user defined types in a database system 有权
    在数据库系统中提供用户定义类型的系统和方法

    公开(公告)号：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查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

    System and method for providing user defined types in a database system
    2.
    发明授权
    System and method for providing user defined types in a database system 失效
    在数据库系统中提供用户定义类型的系统和方法

    公开(公告)号：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查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

    System and method for providing user defined types in a database system
    3.
    发明授权
    System and method for providing user defined types in a database system 有权
    在数据库系统中提供用户定义类型的系统和方法

    公开(公告)号：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查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

    System and method for providing user defined aggregates in a database system
    4.
    发明授权
    System and method for providing user defined aggregates in a database system 有权
    在数据库系统中提供用户定义的聚合的系统和方法

    公开(公告)号：US07376656B2

    公开(公告)日：2008-05-20

    申请号：US10775982

    申请日：2004-02-10

    申请人： Jose A. Blakeley ,  Hongang Zhang ,  Balaji Rathakrishnan ,  Ramachandran Venkatesh ,  Beysim Sezgin ,  Alexios Boukouvalas ,  Cesar A. Galindo-Legaria ,  Peter A. Carlin

    发明人： Jose A. Blakeley ,  Hongang Zhang ,  Balaji Rathakrishnan ,  Ramachandran Venkatesh ,  Beysim Sezgin ,  Alexios Boukouvalas ,  Cesar A. Galindo-Legaria ,  Peter A. Carlin

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

    CPC分类号： G06F17/30607 ,  G06F17/30412 ,  G06F17/30421 ,  Y10S707/955 ,  Y10S707/99944

    摘要： 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 aggregate and methods that can be invoked on instances of the user-defined aggregate. The class is then registered with the database system, which enforces a specific contract for user-defined aggregates 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 aggregate in a database store. Second, the class must comprise certain specified methods that can be invoked on an instance of the class. Once these requirements are satisfied, the database system enables instances of the user-defined aggregate to be created. Preferably, the database system stores metadata about the user-defined aggregate for subsequent use in creating instances of the aggregate.

    摘要翻译： 数据库系统和方法允许用户以高级编程语言编写程序代码，该语言实现定义用户定义聚合的结构的类，以及可以在用户定义聚合的实例上调用的方法。 该类然后向数据库系统注册，该数据库系统针对类强制执行用户定义的聚合的特定合同。 合同包括以下要求。 首先，类必须为数据库存储中用户定义聚合的持久化实例指定多种不同格式之一。 第二，类必须包含可以在类的实例上调用的某些指定方法。 一旦满足这些要求，数据库系统就可以创建用户定义聚合的实例。 优选地，数据库系统存储关于用户定义聚合的元数据，用于随后用于创建聚合的实例。

    System and method for providing user defined types in a database system
    6.
    发明申请
    System and method for providing user defined types in a database system 有权

    公开(公告)号：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.

    System and method for providing user defined types in a database system
    7.
    发明申请
    System and method for providing user defined types in a database system 有权

    公开(公告)号：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.

    SYSTEM AND METHOD FOR PROVIDING USER DEFINED TYPES IN A DATABASE SYSTEM
    8.
    发明申请
    SYSTEM AND METHOD FOR PROVIDING USER DEFINED TYPES IN A DATABASE SYSTEM 失效
    用于在数据库系统中提供用户定义类型的系统和方法

    公开(公告)号：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查询和更新中用户定义类型的表达式。 优选地，数据库系统存储关于用户定义类型的元数据，以便随后用于创建该类型的实例。

    Systems and methods for supporting inheritance for user-defined types
    10.
    发明授权
    Systems and methods for supporting inheritance for user-defined types 有权
    用于支持用户定义类型继承的系统和方法

    公开(公告)号：US07539688B2

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

    申请号：US10837929

    申请日：2004-05-03

    申请人： Beysim Sezgin ,  Denis Y. Altudov ,  Jose A. Blakeley ,  Ramachandran Venkatesh ,  Wei Yu

    发明人： Beysim Sezgin ,  Denis Y. Altudov ,  Jose A. Blakeley ,  Ramachandran Venkatesh ,  Wei Yu

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

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

    摘要： Various embodiments of the present invention are directed to a database with an extensible type system for at least one user-defined type that comprises information for describing its structure as well as information for describing an inheritance relationship between itself and another user-defined type (either a subtype or a supertype/base type). For certain embodiments, the user-defined type is defined in something other than Sequential Query Language (SQL) statement such as, for example, a Common Language Runtime (CLR) statement, a statement in C, C++, and C# (“C-sharp”), and/or a visual basic statement. In any event, several embodiments are further directed to a system wherein the database is aware of the inheritance relationship between two user-defined types by an explicit registration of the user-defined types with said database.

    摘要翻译： 本发明的各种实施例涉及具有用于至少一个用户定义类型的可扩展类型系统的数据库，其包括用于描述其结构的信息以及用于描述其自身与另一用户定义类型之间的继承关系的信息 子类型或超类型/基类型）。 对于某些实施例，用户定义的类型以顺序查询语言（SQL）语句（例如公共语言运行时（CLR））语句，C，C ++和C＃（“C- 锐利“）和/或视觉基本声明。 在任何情况下，几个实施例进一步涉及系统，其中数据库通过用户定义的类型与所述数据库的显式注册来了解两个用户定义类型之间的继承关系。