Database system with improved methods for storing free-form data

Details Database system with improved methods for storing free-form data Database system with improved methods for storing free-form data

1996-06-21

1999-11-23

Von Buhr, Maria N.

Data processing: database and file management or data structures

Database design

Data structure types

707100, G06F 1730

Patent

active

059917768

ABSTRACT:
A system of the present invention includes a relational database management system (RDBMS). Methods are described for maintaining integrity between "design documents," which may be creating under different operating systems, and one or more information tables of the system. The system provides each field of a table with a unique ID ("field ID") for tracking the field regardless of restructuring changes which may be made to the table by various clients. Corresponding field IDs are stored with the fields of design documents, thereby permitting the system to maintain a link between a design document and its table. Upon a restructure of a table, the dependent design documents may be appropriately updated by their respective clients. Methods are also described for improved storage of free-form or "memo" data. In a preferred embodiment, memo data are stored in a separate file comprised of variable-length storage blocks. Methods are described for allocating storage space in the blocks and sub-allocating storage space within a block. For increased efficiency, the system maintains a sorted "free list" of free storage blocks.

REFERENCES:
patent: 4429372 (1984-01-01), Berry et al.
patent: 4716404 (1987-12-01), Tabata et al.
patent: 4748678 (1988-05-01), Takeda et al.
patent: 4893232 (1990-01-01), Shimaoka et al.
patent: 4912640 (1990-03-01), Tsugei
patent: 5063501 (1991-11-01), Jordan, Jr.
patent: 5109336 (1992-04-01), Guenther et al.
patent: 5109508 (1992-04-01), Mitsumori et al.
patent: 5159678 (1992-10-01), Wengelski et al.
patent: 5214779 (1993-05-01), Barker et al.
patent: 5218539 (1993-06-01), Elphick et al.
patent: 5239466 (1993-08-01), Morgan et al.
patent: 5269019 (1993-12-01), Peterson et al.
patent: 5341466 (1994-08-01), Perlin et al.
patent: 5404435 (1995-04-01), Rosenbaum
patent: 5481645 (1996-01-01), Bertino et al.
patent: 5490260 (1996-02-01), Miller et al.
patent: 5546557 (1996-08-01), Allen et al.
patent: 5557794 (1996-09-01), Matsunaga et al.
patent: 5615367 (1997-03-01), Bennett et al.
dBase IV for Developers, Programming with dBase IV, Ashton-Tate Corporation, 1988, 1990, pp. 3-9 to 3-12.
Language Reference, Appendix E: Structure of a Database (.dbf) File, Ashton-Tate Corporation, 1988, 1990, pp. E-1 to E-4.
ReFlex User's Guide, Chapter 1: Creating and Modifying a Database, Borland International, Inc., 1984, 1989, pp. 7-36.
Townsend, C., Mastering dBase IV Programming, Chapter 20: Using Memo Fields, Sybex, Inc., 1989, pp. 331-342.
Lock Management Architecture, IBM Technical Disclosure Bulletin (1989) 31:125-128.
Conditional Locking of Nonroot Index Pages, IBM Technical Disclosure Bulletin (1989) 32:57-58.
Processor for Distributed Cross System Locks, IBM Technical Disclosure Bulletin (1978) 20:4760-4762.

Affiliated with

Also associated with

Rating

Database system with improved methods for storing free-form data does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database system with improved methods for storing free-form data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database system with improved methods for storing free-form data will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1234533