Patent US6397221B1 successfully refreshed from Google Patents.
← Back to Patent Explorer
US6397221B1 Expired / Lapsed US ⏱️ 0.0 years remaining

Method for creating and maintaining a frame-based hierarchically organized databases with tabularly organized data

Assignee: International Business Machines Corp
•
Filing: 1998-12-31
•
Granted: 2002-05-28
•
Expires: 2018-12-31
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract The method includes steps for creating and or modifying the organizational structure and data content of a frame-based, hierarchical product database with the use of tabularly arranged product data. The method features steps for enabling determination of a hierarchical database organizational structure capable of accommodating importation of tabular product data. Additionally, the method feature steps for facilitating either modification of an existing organizational structure where the database already exists, or, creation of a new frame-based, hierarchical organizational structure suitable for receiving the tabular data by generating an entirely new, original structure where none is available. In a first preferred form, the method is implemented in computer software and features program steps for enabling a database administrator, or the like, to determine what frame-based, hierarchical organizational structure would be needed to enable importation of tabular product data, the term “product” embracing both goods and or services. The method features steps for displaying to the database administrator the tabularly organized product data, and, where available, the organizational structure of an existing frame-based, hierarchical database. In a second preferred form, the method features software steps for automatically generating the required frame-based, hierarchical organizational structure where the tabular data includes the product record category and subcategory information necessary to define the organizational structure required to accommodate importation of the tabular data. Further, the method includes software steps for automatically associating the tabular product record information at the lowest level of the frame-based, organizational structure generated.

Inventors

  • 👤 Arthur R. Greef
  • 👤 Martin F. Maldonado
  • 👤 Steffen M. Fohn

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-08 12:13
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/90; G06F16/901; G06F16/9027; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945

Claims Analysis

Total Claims: 21
Claim 1
Independent Claim 151 words
A method for managing a computerized database having a frame-based hierarchical data organizational structure with the use of data having a tabular organizational structure, the method comprising the steps of: a. Providing a data organizational structure including two or more levels of hierarchical relationships, each level having one or more frames, each frame having one or more hierarchical attributes, b. Providing tabular data, the tabular data having an organizational structure including one or more rows and one or more columns which establish one or more data records having one or more record attributes, the tabular data being arranged in accordance with the respective records; c. Comparing the tabular data with the hierarchical data organizational structure; d. Modifying the hierarchical organizational structure to accommodate the tabular data based on the comparison of the tabular data with the hierarchical organizational structure; and e. Merging the tabular data into the organization structure as modified.
Claim 2
Independent Claim 151 words
A method for managing a computerized database having a frame-based hierarchical data organizational structure with the use of data having a tabular organizational structure, the method comprising the steps of: a. Providing a data organizational structure including two or more levels of hierarchical relationships, each level having one or more frames, each frame having one or more hierarchical attributes, b. Providing tabular data, the tabular data having an organizational structure including one or more rows and one or more columns which establish one or more data records having one or more record attributes, the tabular data being arranged in accordance with the respective records; c. Comparing the tabular data with the hierarchical data organizational structure; d. Modifying the hierarchical organizational structure to accommodate the tabular data based on the comparison of the tabular data with the hierarchical organizational structure; and e. Merging the tabular data into the organization structure as modified.
Claim 3
Dependent Claim 30 words
The method of claim 1 wherein comparing of tabular data with the hierarchical organizational structure and modifying the hierarchical organizational structure is interactively supervised by a user of the method.
Claim 4
Dependent Claim 39 words
The method of claim 2 wherein modifying the hierarchical organizational structure includes changing the hierarchical structure to accommodate tabular record attributes not found represented in the hierarchical attributes when the tabular data is compared with the hierarchical organizational structure.
Claim 5
Dependent Claim 48 words
The method of claim 3 wherein changing the hierarchical structure to accommodate tabular record attributes not found represented in the hierarchical attributes includes associating the not-found tabular record attributes with the highest level frame of the modified hierarchical structural to which the not-found tabular record attributes are common.
Claim 6
Dependent Claim 47 words
The method of claim 4 wherein modifying the hierarchical data structure includes changing the hierarchical data structure to accommodate hierarchical organizational structure suggested in the tabular data, but, not found in the hierarchical data organizational structure when the tabular data is compared with the hierarchical organizational structure.
Claim 7
Dependent Claim 49 words
The method of claim 5 wherein changing the hierarchical data structure to accommodate hierarchical organizational structure suggested in the tabular data includes adding frames to the hierarchical organizational structure based on suggestions for frames contained in the tabular data, but which are not found in the hierarchical data structure.
Claim 8
Dependent Claim 18 words
The method of claim 6 wherein the user of the method is an administrator of the hierarchical database.
Claim 9
Dependent Claim 15 words
The method of claim 6 wherein the user of the method manages a personal database.
Claim 10
Dependent Claim 31 words
The method of claim 6 wherein following modification of the hierarchical data organizational structure, the tabular record attributes are mapped to the hierarchical attributes of the modified hierarchical data organizational structure.
Claim 11
Dependent Claim 43 words
The method of claim 9 wherein following the mapping of the tabular record attributes to the hierarchical attributes of the modified hierarchical organizational structure, the mapping information is saved to a mapping specification which is stored for use in merging additional tabular data.
Claim 12
Dependent Claim 34 words
The method of claim 10 wherein following mapping of the tabular record attributes to the hierarchical attributes of the modified hierarchical organizational structure, the tabular records are mapped to the modified hierarchical organizational structure.
Claim 13
Dependent Claim 51 words
The method of claim 2 wherein comparing the tabular data includes analyzing the tabular data to identify hierarchical levels, frames and frame attributes suggested in the tabular data, and, modifying the hierarchical data structure includes originally creating the hierarchical organizational structure from levels, frames and attributes suggested in the tabular data.
Claim 14
Dependent Claim 39 words
The method of claim 12 wherein creating the hierarchical data organizational structure includes creating hierarchical frames and frame attributes to accommodate tabular record attributes represented in the tabular data and the hierarchical frame relationships suggested in the tabular data.
Claim 15
Dependent Claim 26 words
The method of claim 13 wherein creating the hierarchical structure includes creating the hierarchical data structure to accommodate hierarchical organizational structure suggested in the tabular data.
Claim 16
Dependent Claim 33 words
The method of claim 14 wherein creating the hierarchical organizational structure includes associating tabular record attributes with the highest frame of the created hierarchical structural to which the tabular record attributes are common.
Claim 17
Independent Claim 20 words
The method of claims 1 wherein the tabular data includes record attribute information that defines the frame-based, hierarchical organizational structure.
Claim 18
Dependent Claim 28 words
The method of claim 16 wherein the tabular, record attribute information for defining the hierarchical data organizational structure includes category and subcategory information for the respective tabular records.
Claim 19
Dependent Claim 38 words
The method of claim 17 wherein the frame-based, hierarchical organization structure can be automatically generated from the tabular record attribute information so as to include resolution of frame names which avoid naming ambiguities in the hierarchical organizational structure.
Claim 20
Dependent Claim 44 words
The method of claim 18 wherein the levels of hierarchical relationship and the frames of the respective hierarchical levels are automatically generated from the tabular record attribute information, and wherein tabular record frames are provided at the lowest level of the hierarchical organizational structure.
Claim 21
Dependent Claim 39 words
The method of claim 19 wherein the hierarchical frame attributes are generated from the tabular record information by automatically promoting tabular record attribute information from the respective record frames to the highest common level of the hierarchical organizational structure.

References Cited (Backward Citations)

US4930071A Cited
US5832495A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2005-05-27 2005-11-26 2006-05-28 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2009-05-27 2009-11-26 2010-05-28 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2013-05-27 2013-11-26 2014-05-28 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag