System and method for storing and retrieving XML data encapsulated as an object in a database store
    1.
    发明申请
    System and method for storing and retrieving XML data encapsulated as an object in a database store 审中-公开
    用于存储和检索在数据库存储中封装为对象的XML数据的系统和方法

    公开(公告)号:US20050091231A1

    公开(公告)日:2005-04-28

    申请号:US10693158

    申请日:2003-10-24

    CPC分类号: G06F16/84 G06F16/93

    摘要: A system and method are provided for modeling structured, semi-structured, and unstructured data all within a single instance of a user defined type (UDT) within a database store. In particular, the XML data model is extended to fields of a UDT. As a result, the properties of the XML data model—such as document order and document structure—can be preserved within instances of a UDT. Moreover, code representing object behavior (i.e., methods that can be invoked on an object in managed code) can be added to the UDT to operate on an XML field, as well as non-XML fields of the UDT. This enables a framework for adding business logic to XML data. The content model of the XML data can be optionally described using XML schema documents associated with the XML fields of the UDT.

    摘要翻译: 提供了一种系统和方法,用于在数据库存储内的用户定义类型(UDT)的单个实例中对结构化,半结构化和非结构化数据进行建模。 特别地,XML数据模型扩展到UDT的字段。 因此,XML数据模型的属性(如文档顺序和文档结构)可以在UDT的实例中保留。 此外,可以将代表对象行为的代码(即,可以在托管代码中的对象上调用的方法)添加到UDT以对XML字段以及UDT的非XML字段进行操作。 这使得可以将业务逻辑添加到XML数据中。 可以使用与UDT的XML字段相关联的XML模式文档来可选地描述XML数据的内容模型。

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

    公开(公告)号:US20050177581A1

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

    申请号:US10837929

    申请日:2004-05-03

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

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

    System and method for relational representation of hierarchical data
    7.
    发明申请
    System and method for relational representation of hierarchical data 有权
    分层数据的关系表示的系统和方法

    公开(公告)号:US20050027743A1

    公开(公告)日:2005-02-03

    申请号:US10924704

    申请日:2004-08-24

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: A technique for representing the structure of hierarchically-organized data in a non-hierarchical data structure, such as a relation. The hierarchically-organized data is represented as a tree, and each node in the tree is assigned a position identifier that represents both the depth level of the node within the hierarchy, and its ancestor/descendant relationship to other nodes. The data represented by each node, as well as its position identifier, is stored in a row of a relational database, thereby capturing the hierarchical structure of the data in such relational database. A technique is provided for the compressed storage of position identifiers in a format that allows an efficient bytewise comparison of position identifiers to determine relative order and ancestry.

    摘要翻译: 用于表示非分层数据结构(例如关系)中的分层组织数据的结构的技术。 分层组织的数据被表示为树,并且树中的每个节点被分配一个位置标识符,其表示层次结构内的节点的深度级别,以及其与其他节点的祖先/后代关系。 由每个节点表示的数据及其位置标识符存储在关系数据库的一行中,从而捕获这种关系数据库中数据的层次结构。 提供了一种用于以允许位置标识符的有效从字面比较确定相对顺序和祖先的格式的位置标识符的压缩存储的技术。

    System and method for object persistence in a database store
    9.
    发明申请
    System and method for object persistence in a database store 有权
    数据库存储中对象持久化的系统和方法

    公开(公告)号:US20050091228A1

    公开(公告)日:2005-04-28

    申请号:US10692225

    申请日:2003-10-23

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: A new persistence format for storing objects of a user defined type in a database store enables information about the structure of the type to be communicated to the store. This information enables a number of store optimizations, including direct structural access to members of the type. Specifically, metadata is exchanged between the type implementer and the data store. The store uses the metadata to determine the storage layout for instances of the type. With this information, the store is able to detect access patterns that can be optimized to directly operate over the storage representation without hydration (deserialization) the object.

    摘要翻译: 用于将用户定义类型的对象存储在数据库存储中的新的持久性格式使得能够传送要传送到商店的类型的结构的信息。 此信息可实现多种存储优化,包括对类型成员的直接结构访问。 具体来说,在类型实现者和数据存储之间交换元数据。 商店使用元数据来确定该类型的实例的存储布局。 利用该信息,商店能够检测可优化的访问模式以直接在存储表示上操作而不对物体进行水化(反序列化)。

    Systems and methods for hosting the common language runtime in a database management system
    10.
    发明申请
    Systems and methods for hosting the common language runtime in a database management system 审中-公开
    在数据库管理系统中托管公共语言运行库的系统和方法

    公开(公告)号:US20050187980A1

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

    申请号:US10776371

    申请日:2004-02-10

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