Structured large object (LOB) data
    12.
    发明授权
    Structured large object (LOB) data 有权
    结构化大对象(LOB)数据

    公开(公告)号:US08676788B2

    公开(公告)日:2014-03-18

    申请号:US13418771

    申请日:2012-03-13

    IPC分类号: G06F7/00 G06F17/30

    摘要: Provided are techniques for processing structured content within Large Object (LOB) data that is stored in a column of a database table. Structural metadata describing structures that each define a different format of the structured content is stored. A request for data in the database table is received. The structural metadata is used to create an empty result set with columns defined by at least two of the structures. For each row of data in the database table that includes LOB data, control data is used to identify one of the structures to be applied to the structured content within the LOB data stored in that row of data, and the structured content within the LOB data in that row of data is mapped to the columns in the result set based on the identified one of the structures. The result set is returned.

    摘要翻译: 提供了用于处理存储在数据库表的列中的大对象(LOB)数据内的结构化内容的技术。 描述每个定义结构化内容的不同格式的结构的结构元数据被存储。 接收到数据库表中的数据请求。 结构元数据用于创建一个空结果集,其中由至少两个结构定义的列。 对于包含LOB数据的数据库表中的每行数据,控制数据用于标识要应用于存储在该行数据中的LOB数据中的结构化内容的结构之一,以及LOB数据内的结构化内容 在该行的数据基于所识别的结构之一映射到结果集中的列。 结果集返回。

    Apparatus and system for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database
    13.
    发明授权
    Apparatus and system for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database 有权
    用于定义元数据模式以便于在可扩展标记语言文档和分层数据库之间传递数据的装置和系统

    公开(公告)号:US07912874B2

    公开(公告)日:2011-03-22

    申请号:US12116028

    申请日:2008-05-06

    IPC分类号: G06F17/30

    摘要: The apparatus and system are provided for defining a metadata schema to facilitate passing data between an XML document and a hierarchical database. The invention includes a database accessor, a document accessor, and an association module. The database accessor accesses a database schema indicative of database field names and a hierarchical structure for a hierarchical database. The document accessor accesses a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database. The document schema also includes at least one XML element name that maps to a corresponding database field name in the database schema. The association module associates the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database.

    摘要翻译: 提供了用于定义元数据模式以便于在XML文档和分层数据库之间传递数据的装置和系统。 本发明包括数据库访问器,文档存取器和关联模块。 数据库访问器访问指示分层数据库的数据库字段名称和分层结构的数据库模式。 文档访问器访问定义可以传入和传出分层数据库的有效,格式正确的XML文档的层次结构,内容数据语法和语义的文档模式。 文档模式还包括至少一个映射到数据库模式中对应的数据库字段名称的XML元素名称。 关联模块将数据库模式和文档模式相关联,以提供使数据可以在XML文档和分层数据库之间传递的元数据模式。