Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-12-30
2000-05-16
Amsbury, Wayne
Data processing: database and file management or data structures
Database design
Data structure types
707101, G06F 1730
Patent
active
060650044
ABSTRACT:
In a database having date fields, years past 1999 are written in a format such as binary integer format or binary-coded decimal format, either of which can be signed or unsigned. In the binary-coded decimal format, two bytes generally used to indicate the last two digits of the year can instead be used to indicate a sign and three digits. If the number of years elapsed since 1900 is used, the positive numbers from zero to 999 represent the years 1900-2899, while negative numbers represent years before 1900. Year data written in either of these formats can coexist with year data written in legacy formats, in which case the legacy and enterprise formats are distinguished by comparison of the binary integer value of a year datum or a portion thereof with a predetermined range or by checking one or more bits. The legacy format can be a format such as ASCII, EBCDIC or BCD Julian.
REFERENCES:
patent: 3996450 (1976-12-01), Kerkhoff
patent: 4044347 (1977-08-01), Van Voorhis
patent: 4486857 (1984-12-01), Heckel
patent: 4500955 (1985-02-01), Chang
patent: 4654633 (1987-03-01), Tonomura
patent: 4752765 (1988-06-01), Larson
patent: 4947163 (1990-08-01), Henderson et al.
patent: 5119465 (1992-06-01), Jack et al.
patent: 5293355 (1994-03-01), Widen et al.
patent: 5319779 (1994-06-01), Chang et al.
patent: 5444820 (1995-08-01), Tzes et al.
patent: 5473327 (1995-12-01), Ray et al.
patent: 5600836 (1997-02-01), Alter
patent: 5630118 (1997-05-01), Shaughnessy
patent: 5644762 (1997-07-01), Soeder
patent: 5668989 (1997-09-01), Mao
patent: 5737735 (1998-04-01), Soder
patent: 5740442 (1998-04-01), Cox et al.
patent: 5812841 (1998-09-01), Soeder
patent: 5903895 (1999-05-01), Hoffman et al.
Hart et al, A Scaleable, Automated Process for Year 2000 System Correction, PROC 18th International Conference on Software Engineering, Mar. 25-30, 1996, pp. 475-84 .
Amsbury Wayne
RMM, Inc.
LandOfFree
Method and apparatus for recording and reading date data having does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for recording and reading date data having , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for recording and reading date data having will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-268004