利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

22 条记录 (耗时 0.029 秒)

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

    公开(公告)号：US20050177579A1

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

    申请号：US10775982

    申请日：2004-02-10

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

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

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

    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 a first method that can be invoked to initialize the computation of an instance of the user-defined aggregate, a second method that can be invoked to accumulate a plurality of values to be aggregated with the user-defined aggregate, a third method that can be invoked to merge an instance of the user-defined aggregate with another partial aggregation, and a fourth method that can be invoked to compute a final result of an instance of the user-defined aggregate. 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
    2.
    发明申请
    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
    3.
    发明申请
    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
    4.
    发明申请
    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 hosting the common language runtime in a database management system
    6.
    发明申请
    Systems and methods for hosting the common language runtime in a database management system 审中-公开
    在数据库管理系统中托管公共语言运行库的系统和方法

    公开(公告)号：US20050187980A1

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

    申请号：US10776371

    申请日：2004-02-10

    申请人： Peter Carlin ,  Jose Blakeley ,  Balaji Rathakrishnan ,  Beysim Sezgin ,  Mason Bendixen ,  Xiaowei Jiang ,  Aakash Kambuj ,  Alazel Acheson

    发明人： Peter Carlin ,  Jose Blakeley ,  Balaji Rathakrishnan ,  Beysim Sezgin ,  Mason Bendixen ,  Xiaowei Jiang ,  Aakash Kambuj ,  Alazel Acheson

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

    CPC分类号： G06F16/252

    摘要： The present invention the is directed to systems and methods for hosting the CLR in a DBMS in order to achieve reliability, scalability, security, and robustness for enabled DBMS programming features. Integrating the CLR with a DBMS enables programming features in the database such as stored procedures, functions, triggers, types, and aggregates to be written in any of the programming languages that are compiled into IL code supported by the CLR. For the various embodiments of the present invention, the CLR is hosted inside the DBMS and, instead of making requests directly to the server operating system, the CLR instead interfaces with the DBMS via DBMS APIs for such requests, and only the DBMS directly interfaces with the server operating system to access the server.

    摘要翻译： 本发明涉及用于在DBMS中托管CLR以便实现启用的DBMS编程特征的可靠性，可扩展性，安全性和鲁棒性的系统和方法。 将CLR与DBMS集成，可以使数据库中的编程功能（例如存储过程，函数，触发器，类型和聚合）以任何编译为CLR支持的IL代码的编程语言编写。 对于本发明的各种实施例，CLR托管在DBMS内部，而不是直接向服务器操作系统提出请求，而是通过用于这种请求的DBMS API而与DBMS接口，而不是DBMS直接与 服务器操作系统访问服务器。

    Query optimizer using implied predicates
    7.
    发明申请
    Query optimizer using implied predicates 审中-公开
    查询优化器使用隐含谓词

    公开(公告)号：US20050210023A1

    公开(公告)日：2005-09-22

    申请号：US10803443

    申请日：2004-03-18

    申请人： Renato Barrera ,  Jose Blakeley ,  Cesar Galindo-Legaria ,  Balaji Rathakrishnan ,  Oliver Seeliger

    发明人： Renato Barrera ,  Jose Blakeley ,  Cesar Galindo-Legaria ,  Balaji Rathakrishnan ,  Oliver Seeliger

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

    CPC分类号： G06F16/24537 ,  G06F16/24542

    摘要： Improved query optimizer using implied predicates. The system facilitates allowing a query optimizing component to introduce into a query, extra predicates that facilitate the following: render the same results as the original query; are used as dictated by rules passed to the optimizing component—these rules specify whether the new predicate is an equivalence (that will substitute the old predicate) or an implication (in which the old predicate is preserved); are considered as cost-based alternatives, and discarded if not useful; are tied to index utilization; and can consider both standard and multi-valued indices.

    摘要翻译： 改进了使用隐含谓词的查询优化器。 该系统便于允许查询优化组件引入到查询中，另外的谓词便于执行以下操作：渲染与原始查询相同的结果; 根据传递给优化组件的规则使用这些规则 - 这些规则指定新谓词是否是等价性（将替代旧谓词）或暗示（其中保留旧谓词）; 被认为是基于成本的替代品，如果不是有用的话; 与指数利用挂钩; 并且可以考虑标准和多值指数。

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

    公开(公告)号：US20050177581A1

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

    申请号：US10837929

    申请日：2004-05-03

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

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

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

    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- 锐利“）和/或视觉基本声明。 在任何情况下，几个实施例进一步涉及系统，其中数据库通过用户定义的类型与所述数据库的显式注册来了解两个用户定义类型之间的继承关系。