Supercharge Your Innovation With Domain-Expert AI Agents!

Structured large object (lob) data

A structured, large object technology, applied in the direction of structured data retrieval, object-oriented database, database model, etc., can solve problems such as LOB data interaction and complex interpretation

Active Publication Date: 2014-11-19
IBM CORP
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the interaction and interpretation of LOB data can be complex if the LOB has a limited number of structured formats

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Structured large object (lob) data
  • Structured large object (lob) data
  • Structured large object (lob) data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] The descriptions of different embodiments of the present invention are given for illustrative purposes, but the descriptions are not intended to be exhaustive or limited to the disclosed embodiments. Without departing from the scope of the embodiments, many modifications and changes are obvious to those of ordinary skill in the art. The choice of terms used herein is intended to best explain the principles of the embodiments, practical applications, or technical improvements to technologies in the market, or to enable other ordinary skilled in the art to understand the embodiments disclosed herein.

[0040] figure 1 A computing environment according to certain embodiments is shown as a block diagram. The computing device includes a DBMS 110, and the DBMS 110 includes a structured LOB system 120 and a directory 130. The catalog 130 includes structural metadata 140. In some embodiments, the structure metadata 140 includes the offset and length of the structured content (eg...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

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.

Description

Technical field [0001] Embodiments of the present invention involve creating, searching, retrieving, and invalidating structured LOB data. Background technique [0002] Database management system (DBMS) software can use database query language to store and retrieve data in the database. The database query language can be, but is not limited to, a structured query language (SQL) interface. Organize the database into tables that include rows and columns of data. Rows can be called tuples or records or rows. [0003] You can use indexes to access tables in the database. An index is an ordered set of references (for example, pointers) to records in a table. An index is used to access each record in the table using a key (ie, a field or attribute of the record, which corresponds to a column). The term "key" can also be referred to as "index key". The index is based on one or more columns of the table. [0004] A query can be described as a request for information in the database ba...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30607G06F16/2219G06F16/258G06F16/289
Inventor K·D·海特K·J·夏勒特N·D·丘奇R·V·特兰C·霍尔茨
Owner IBM CORP
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com