System and methods for data field management in a computer datab

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

3642821, 364DIG1, 395149, G06F 1730

Patent

active

055617930

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: 5063501 (1991-11-01), Jordan, Jr.
patent: 5321610 (1994-06-01), Breslin
patent: 5339424 (1994-08-01), Fushimi
patent: 5353401 (1994-10-01), Iizawa et al.
patent: 5369778 (1994-11-01), San Soucie et al.
patent: 5392390 (1995-02-01), Crozier
patent: 5396613 (1995-03-01), Hollaar
patent: 5404294 (1995-04-01), Karnik
patent: 5404488 (1995-04-01), Kerrigan et al.
patent: 5414809 (1995-05-01), Hogan et al.
"Lock Management Architecture," IBM Technical Disclosure Bulletin (1988) 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.
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.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

System and methods for data field management in a computer datab does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and methods for data field management in a computer datab, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and methods for data field management in a computer datab will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-1509382

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.