Supporting long fields of recoverable database records in a computer system
Abstract
A long field file, managed using log-based recovery mechanisms, contains values associated with large data set items and contains allocation information controlling long field file space. Each long field has a compact descriptor pointing to associated multi-page block(s) of data in the long field file. The descriptor is in the database record which logically contains the long field. Long field data is shadowed in the long field file during updates and changes to the descriptor and long field file allocation information are logged. During long field data value deletion or replacement, the allocation information for the corresponding space in the long field file is marked free and locked until the deleting transaction completes, thereby insuring that deletes are undoable. Support for storage, access and maintenance of long fields as logically integral components of recoverable database records is provided as well as row-level concurrency in minimization of long field data in the recovery log. Duplication in storing before and after images of long field data in the log is avoided. More efficient management of memory space freed by deletion of long field records is provided. Long field data is transferable directly without intermediate buffering including entire multi-page blocks of data and such transfer is effected with a single access to the storage device containing the data.

Term
Term ended
Projected expiry passed 24 February 2009, 17.6 years ago.
- Priority
- Filed
- Published
- Projected expiry
- Today
1 sheet
Sheet 1
Every citation, both ways
| Document | Relation | Office | Category | Cited during |
|---|---|---|---|---|
| EP0202671A2 | Cites | European Patent Office (EPO) | A | Search report |
4 members in 3 offices
Priority claims3
| Document | Office | Kind | Date |
|---|---|---|---|
| 179469 | United States of America | – | |
| 17946988 | United States of America | A | |
| US19880179469 | – | – | – |
Members4
| Document | Office | Kind | |
|---|---|---|---|
| EP0336548A2 | European Patent Office (EPO) | A2 | |
| JPH01261745A | Japan | A | |
| BR8901640A | Brazil | A | |
| EP0336548A3This record | European Patent Office (EPO) | A3 |
8 legal events, as the office reported them to INPADOC
Over the term
Point at a mark for the eventEvents
| Event | Code | |
|---|---|---|
| Application withdrawnWithdrawn18W | 18W | |
| Information on the status of an ep patent application or granted ep patentGrantedSTATUS: THE APPLICATION HAS BEEN WITHDRAWNSTAA | STAA | |
| First examination report despatched17Q | 17Q | |
| Designated contracting statesAK | AK | |
| Search report despatchedORIGINAL CODE: 0009013PUAL | PUAL | |
| Request for examination filed17P | 17P | |
| Designated contracting statesAK | AK | |
| Public reference made under article 153(3) epc to a published international application that has entered the european phaseORIGINAL CODE: 0009012PUAI | PUAI |
Numbers
- Publication
- 0336548
- Publication, DOCDB
- 0336548
- Publication, EPODOC
- EP0336548
- Application
- 301836
- Application, DOCDB
- 89301836
- Application, EPODOC
- EP19890301836
Titles3
- English
- Supporting long fields of recoverable database records in a computer system
- German
- Unterstützung langer Felder zurückzugewinnender Datenbasisaufzeichnungen in einem Rechnersystem
- French
- Prise en charge de longs champs de fiches de base de données restaurables dans un système à calculateur
Classification
- CPC, 4
- G06F17/30377
- G06F16/2379
- G06F11/1471
- G06F2201/87
- IPC, 3
- G06F7 22
- G06F11 14
- G06F12 00
Designated states10
- Contracting states, 10
- Belgium
- Switzerland
- Germany
- Spain
- France
- United Kingdom
- Italy
- Liechtenstein
- Netherlands (Kingdom of the)
- Sweden