The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 12, 2002
Filed:
Jun. 07, 2001
David Chandler, Cedar Rapids, IA (US);
Other;
Abstract
A relational database is provided with a plurality of data entries stored in the database. The data entries have a hierarchical relationship. The data entries are assigned an item identifier that uniquely identifies each of the data items. A multiple digit outline number is assigned to each of the data entries wherein the digits of the outline number correspond to the hierarchical levels of the data entries. A hierarchical level identifier is assigned to each of the data entries wherein the hierarchical level identifier equal the number of non-zero digits in the outline number. An organizational table is created wherein the table includes a row for each of the data entries and the table includes multiple columns. The columns comprise a column for the item identifier, a plurality of outline number columns where each outline number column comprises one digit of the outline number such that each of the digits is stored in a separate column, and a hierarchical level column comprising the level identifier.