Methods and system for storing and accessing embedded informatio

Details Methods and system for storing and accessing embedded informatio Methods and system for storing and accessing embedded informatio

1997-12-24

2000-01-18

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 4, 707101, 707102, G06F 1730

Patent

active

060164972

ABSTRACT:
A system and computer-implemented methods for accessing and storing information embedded in a column of a database row, especially useful for complex data, that is, data which is logically multi-valued or hierarchical. Embedded data is not stored in a separate table but is stored directly in a complex column comprising embedded data a subtables. A row of data is physically stored in a tagged, variable-length object-relational format, which allows the data to be stored as atomic data values or embedded as collections of data values, data structures, or collections of data structures. The structures can have further levels of embedding, i.e. more collections and/or structures. Embedded data may further include typed data embedded in multiple tables and columns. The query language for accessing the data includes a series of extensions that provide additional access paths to the data. Searches can access data within tables and sub-tables, and can access data by user defined type (UDT) in a single table or across multiple tables.

REFERENCES:
patent: 5713020 (1998-01-01), Reiter et al.
patent: 5822747 (1998-10-01), Graefe et al.
patent: 5832481 (1998-11-01), Sheffield
patent: 5850544 (1998-12-01), Parvathaneny et al.
patent: 5873083 (1999-02-01), Jones et al.

Affiliated with

Also associated with

Rating

Methods and system for storing and accessing embedded informatio does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Methods and system for storing and accessing embedded informatio, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Methods and system for storing and accessing embedded informatio will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-569869