G - Physics – 06 – Q
Patent
G - Physics
06
Q
354/33
G06Q 40/00 (2006.01) G06Q 10/00 (2006.01)
Patent
CA 2035953
An apparatus and a method for creating a database wherein the data entry, such as a journal entry in accounting, is the canonical record can be implemented utilizing a microcomputer. A plurality of data entries to be classified are separate records each comprised of one or more items having associated quantities ant an entry number serving as a pointer to the record. Each item contains information including at least an item number or label and a quantity. At least two item indicators are then generated for each of the item numbers. A mapping function is applied to each data entry to assign the item indicators for the item numbers based upon the associated quantities. The item indicators for the data entry are sorted into ascending numerical sequence and an n-dimension sparse matrix is selected where "n" is the number of items in the data entry. If the present combination of item indicators is new, a design record is created for the database based upon the sparse matrix and including the item indicators, the associated quantity sums, the total number of data entries summarized in the design record and a pointer (a chain of entry numbers) to the records of the data entry detail. The quantities for the present data entry are added to the quantity sums and the entry number is stored in the pointer chain. After all the data entries have been processed, a search routine can be utilized to review the various design records as desired.
Olan Michael J.
Sampson Wesley C.
Borden Ladner Gervais Llp
Olan Michael J.
Sampson Wesley C.
LandOfFree
Method and apparatus for the classification of 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 Method and apparatus for the classification of data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for the classification of data will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1368595