专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20050177585A1 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.

2. 发明申请

US20050177583A1 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.

3. 发明申请

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

4. 发明申请

US20050177579A1 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.
摘要翻译：数据库系统和方法允许用户以高级编程语言编写程序代码，该语言实现定义用户定义聚合的结构的类，以及可以在用户定义聚合的实例上调用的方法。该类然后向数据库系统注册，该数据库系统针对类强制执行用户定义的聚合的特定合同。合同包括以下要求。首先，类必须为数据库存储中用户定义聚合的持久化实例指定多种不同格式之一。第二，类必须包括可被调用以初始化用户定义聚合的实例的计算的第一方法，可以被调用以累积要与用户定义的聚合聚合的多个值的第二方法，可以调用以将用户定义聚合的实例与另一部分聚合合并的第三种方法，以及可以调用以计算用户定义聚合的实例的最终结果的第四种方法。一旦满足这些要求，数据库系统就可以创建用户定义聚合的实例。优选地，数据库系统存储关于用户定义聚合的元数据，用于随后用于创建聚合的实例。

5. 发明申请

US20050187980A1 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直接与服务器操作系统访问服务器。

6. 发明申请

US20050187893A1 Systems and methods for a large object infrastructure in a database system 有权
标题翻译：数据库系统中大对象基础架构的系统和方法
公开(公告)号：US20050187893A1
公开(公告)日：2005-08-25
申请号：US10776664
申请日：2004-02-10
申请人： Shrinivas Ashwin , Jose Blakeley , Peter Carlin , Jun Fang , Ajay Kalhan , Christian Kleinerman , Stefano Stefani , Aleksandras Surna , Honggang Zhang
发明人： Shrinivas Ashwin , Jose 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。

7. 发明申请

US20050187944A1 Systems and methods for a database engine in-process data provider 有权
标题翻译：数据库引擎进程内数据提供者的系统和方法
公开(公告)号：US20050187944A1
公开(公告)日：2005-08-25
申请号：US10776370
申请日：2004-02-10
申请人： Alazel Acheson , Shrinivas Ashwin , Jose Blakeley , Peter Carlin , Erik Ismert , Christian Kleinerman , Ganapathy Krishnamoorthy , Girikumar Nair
发明人： Alazel Acheson , Shrinivas Ashwin , Jose Blakeley , Peter Carlin , Erik Ismert , Christian Kleinerman , Ganapathy Krishnamoorthy , Girikumar Nair
IPC分类号： G06F7/00
CPC分类号： G06F17/30595 , G06F17/3041
摘要： Various embodiments of the present invention enable functions, procedures, and triggers to be written in any of the .NET languages and executed by the RDBMS. User code can access data from the local or other SQL servers using the SQL Programming Model and both the SqlServer or SqlClient implementations respectively. Moreover, to improve upon the previous extensibility mechanism, a set of APIs (commonly known as “the in-process provider” or “inproc provider”) is utilized to provide efficient and easy to use data access while running inproc, a data access API that is an implementation of the ADO.net programming model.
摘要翻译：本发明的各种实施例使功能，过程和触发器能够以任何.NET语言编写并由RDBMS执行。用户代码可以分别使用SQL编程模型和SqlServer或SqlClient实现访问来自本地或其他SQL服务器的数据。此外，为了改进以前的可扩展性机制，使用一组API（通常称为“进程内提供程序”或“inproc提供程序”）来在运行inproc时提供高效且易于使用的数据访问，数据访问API 这是ADO.net编程模型的实现。

8. 发明授权

US07155442B2 Compressed normalized character comparison with inversion 有权
标题翻译：压缩归一化字符与反演比较
公开(公告)号：US07155442B2
公开(公告)日：2006-12-26
申请号：US10185525
申请日：2002-06-28
申请人： Peter Carlin , Jun Fang , Elizabeth Jean O'Neil , Patrick Eugene O'Neil
发明人： Peter Carlin , Jun Fang , Elizabeth Jean O'Neil , Patrick Eugene O'Neil
IPC分类号： G06F7/08
CPC分类号： G06F17/30985 , G06F17/22 , H03M7/30 , Y10S707/99931 , Y10S707/99932 , Y10S707/99942
摘要： Any string in any character set with an arbitrary-leveled weight-based comparison system is transformed into a bitstring in such a way that two transformed strings can be compared byte-by-byte. The resulting bit string has the minimum possible maximum length. The transformed bit strings can be inverted—meaning the original string can be recovered from the transformed string.
摘要翻译：任何具有任意级别的基于权重的比较系统的字符集中的任何字符串被转换成位串，使得可以逐字节比较两个变换的字符串。所得到的位串具有最小可能的最大长度。转换的位串可以被反转，这意味着可以从转换的字符串中恢复原始字符串。

9. 发明授权

US07437346B2 Systems and methods for a large object infrastructure in a database system 有权
标题翻译：数据库系统中大对象基础架构的系统和方法
公开(公告)号：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。

10. 发明申请

US20050177556A1 Systems and methods for transforming SQL syntax trees into relational algebra representations 审中-公开
标题翻译：将SQL语法树转换为关系代数表示的系统和方法
公开(公告)号：US20050177556A1
公开(公告)日：2005-08-11
申请号：US10776895
申请日：2004-02-10
申请人： Jun Fang , Aakash Kambuj , Evgueni Zabokritski , Honggang Zhang , Peter Carlin
发明人： Jun Fang , Aakash Kambuj , Evgueni Zabokritski , Honggang Zhang , Peter Carlin
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F16/24526
摘要： The SQL Algebrizer of the present invention comprises a plurality of algorithms to “algebrize” SQL Trees to QP Algebra using an approach that is more consistent and much more efficient than typical algebrizers. More specifically, the Algebrizer of the present invention processes a SQL Tree using a reduced number of recursive depth-first passes by performing multiple operations in a single pass. Furthermore, the Algebrizer of the present invention also performs the operation of constant folding in this single, multi-operation pass so that the QP, upon receiving the QP Algebra, needs not perform this operation at all.
摘要翻译：本发明的SQL代理器包括使用比典型的代数器更一致和更有效的方法来将“SQL树”组合到QP代数的多种算法。更具体地说，本发明的代理者通过在单程中执行多个操作，使用减少数量的递归深度优先遍历来处理SQL树。此外，本发明的代理还在该单次多操作遍中进行恒定折叠的操作，使得在接收到QP代数时，QP根本不需要执行该操作。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式