US6023699A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method for organizing a relational database used for storing data related to the configuration and placement of equipment in field sites
Assignee: Verizon Patent and Licensing Inc
•
Filing: 1997-03-25
•
Granted: 2000-02-08
•
Expires: 2017-03-25
Abstract
Abstract A method and program product for organizing a relational database used for the storage of data related to the configuration and placement of equipment in field sites. The method includes recording, maintaining, and viewing placement and configuration of equipment in remote field sites. Additionally, the method includes defining equipment in terms of components, such as modules, shelves, and racks. Once components are defined and stored in the database, they are configured by specifying interrelationships between components. The program product includes a computer useable medium having computer program logic stored therein for enabling a computer to store data associated with the configuration and placement of equipment in field sites, the equipment includes rails, shelves, and modules. The computer program logic includes a relational database organization having a product catalog for storing data associated with the components, a configuration library for storing data associated with the equipment, a site hierarchy repository for storing data associated with the field sites, and an equipment placement library for storing data associated with a location of said equipment within the field sites.
Inventors
- 👤 Terry Knoblock
- 👤 Gregory G. Carlson
- 👤 Paul Michael Golobay
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-06 17:17
CPC Classifications
G; G06; G06Q; G06Q10/00; G06Q10/06
Claims Analysis
Total Claims: 21
Claim 1
Independent Claim
213 words
A method for creating and organizing a relational database used for storing data associated with the configuration and placement of equipment in field sites, said equipment comprising one or more components, wherein said components comprise rails, shelves and modules said method comprising the steps of: creating a product catalog for storing data associated with the components; creating a configuration library for storing data associated with the equipment, wherein said step of creating a configuration library comprises: creating a configured racks table, directly related to said product catalog, for storing data associated with configured racks; creating a configured racks item table, directly related to said configured racks table, for storing data associated with specific rack positions within said configured racks used to support configured shelves; creating a configured shelves table, directly related to said product catalog and said configured racks item table, for storing data related to said configured shelves; and creating a configured shelves item table, directly related to said configured shelves table and said product catalog, for storing data associated with specific shelf positions used to support said modules; creating a site hierarchy repository for storing data associated with the field sites; and creating an equipment placement library for storing data associated with a location of said equipment within the field sites.
Claim 2
Independent Claim
213 words
A method for creating and organizing a relational database used for storing data associated with the configuration and placement of equipment in field sites, said equipment comprising one or more components, wherein said components comprise rails, shelves and modules said method comprising the steps of: creating a product catalog for storing data associated with the components; creating a configuration library for storing data associated with the equipment, wherein said step of creating a configuration library comprises: creating a configured racks table, directly related to said product catalog, for storing data associated with configured racks; creating a configured racks item table, directly related to said configured racks table, for storing data associated with specific rack positions within said configured racks used to support configured shelves; creating a configured shelves table, directly related to said product catalog and said configured racks item table, for storing data related to said configured shelves; and creating a configured shelves item table, directly related to said configured shelves table and said product catalog, for storing data associated with specific shelf positions used to support said modules; creating a site hierarchy repository for storing data associated with the field sites; and creating an equipment placement library for storing data associated with a location of said equipment within the field sites.
Claim 3
Dependent Claim
89 words
The method of claim 1, wherein said step of creating a product catalog, comprises the steps of: creating a product catalog table for storing data common to all of the components; creating a module table, directly related to said product catalog table, for storing data specifically associated with the modules; creating a shelf table, directly related to said product catalog table, for storing data specifically associated with the shelves; and creating a rack table, directly related to said product catalog table, for storing data specifically associated with the rails.
Claim 4
Dependent Claim
156 words
The method of claim 1, wherein said step of creating a site hierarchy repository, comprises the steps of: creating a site table for storing data associated with the field sites; creating a structure table, directly related to said site table, for storing data associated with structures within each field site; creating a floor table, directly related to said structure table, for storing data associated with floors within each said structure; creating a zone table, directly related to said floor table, for storing data associated with zones within each said floor; creating a zone points table, directly related to said zone table, for storing data associated with graphical representations of said zones; creating a planning unit table, directly related to said zone table, for storing data associated with planning units within each said floors; and creating a row table, directly related to said planning unit table, for storing data associated with rows within each said planning units.
Claim 5
Dependent Claim
86 words
The method of claim 3, wherein said step of creating a site hierarchy repository, further comprises the steps of: creating a floor points table, directly related to said floor table, for storing data associated with graphical representations of said floors; creating a planning unit points table, directly related to said planning unit table, for storing data associated with graphical representations of said planning units; and creating a row segments table, directly related to said row table, for storing data associated with graphical representations of said rows.
Claim 6
Dependent Claim
49 words
The method of claim 4, wherein said step of creating a placement library, comprises the steps of: creating a placement data for racks table, directly related to said configured racks table and said row segments table, for defining a location and installation and removal dates for said configured racks.
Claim 7
Dependent Claim
82 words
The method of claim 5, wherein said step of creating a placement library further comprises the steps of: creating a placement data for shelves table, directly related to said configured rack item table and said placement data for racks table, for storing installation and removal dates for the shelves; and creating a placement data for cards table, directly related to said configured shelf item table and said placement data for shelves table, for storing data installation and removal dates for the modules.
Claim 8
Dependent Claim
213 words
A computer program product, comprising a computer useable medium having computer program logic stored therein for enabling a computer to store data associated with the configuration and placement of equipment in field sites the equipment comprising one or more components and the components comprising rails, shelves and modules, wherein said computer program logic includes a relational database organization comprising: a product catalog for storing data associated with the components; a configuration library storing data associated with the equipment, wherein said configuration library comprises: configured racks table, directly related to said product catalog, for storing data associated with configured racks; a configured racks item table, directly related to said configured racks table, for storing data associated with specific rack positions within said configured racks used to support configured shelves; a configured shelves table, directly related to said product catalog and said configured racks item table, for storing data related to said configured shelves; and a configured shelves item table, directly related to said configured shelves table and said product catalog, for storing data associated with specific shelf positions used to support said modules; a site hierarchy repository for storing data associated with the field sites; and an equipment placement library for storing data associated with a location of said equipment within the field sites.
Claim 9
Dependent Claim
213 words
A computer program product, comprising a computer useable medium having computer program logic stored therein for enabling a computer to store data associated with the configuration and placement of equipment in field sites the equipment comprising one or more components and the components comprising rails, shelves and modules, wherein said computer program logic includes a relational database organization comprising: a product catalog for storing data associated with the components; a configuration library storing data associated with the equipment, wherein said configuration library comprises: configured racks table, directly related to said product catalog, for storing data associated with configured racks; a configured racks item table, directly related to said configured racks table, for storing data associated with specific rack positions within said configured racks used to support configured shelves; a configured shelves table, directly related to said product catalog and said configured racks item table, for storing data related to said configured shelves; and a configured shelves item table, directly related to said configured shelves table and said product catalog, for storing data associated with specific shelf positions used to support said modules; a site hierarchy repository for storing data associated with the field sites; and an equipment placement library for storing data associated with a location of said equipment within the field sites.
Claim 10
Dependent Claim
80 words
The computer program product of claim 7, wherein said product catalog comprises: a product catalog table for storing data common to all of the components; a module table, directly related to said product catalog table, for storing data specifically associated with the modules; a shelf table, directly related to said product catalog table, for storing data specifically associated with the shelves; and a rack table, directly related to said product catalog table, for storing data specifically associated with the rails.
Claim 11
Dependent Claim
144 words
The computer program product of claim 7, wherein said site hierarchy repository comprises: a site table for storing data associated with the field sites; a structure table, directly related to said site table, for storing data associated with structures within each field site; a floor table, directly related to said structure table, for storing data associated with floors within each said structure; a zone table, directly related to said floor table, for storing data associated with zones within each said floor; a zone points table, directly related to said zone table, for storing data associated with graphical representations of said zones; a planning unit table, directly related to said zone table, for storing data associated with planning units within each said floors; and a row table, directly related to said planning unit table, for storing data associated with rows within each said planning units.
Claim 12
Dependent Claim
78 words
The computer program product of claim 9, wherein said site hierarchy repository further comprises: a floor points table, directly related to said floor table, for storing data associated with graphical representations of said floors; a planning unit points table, directly related to said planning unit table, for storing data associated with graphical representations of said planning units; and a row segments table, directly related to said row table, for storing data associated with graphical representations of said rows.
Claim 13
Dependent Claim
43 words
The computer program product of claim 10, wherein said placement library comprises: a placement data for racks table, directly related to said configured racks table and said row segments table, for defining a location and installation and removal dates for said configured racks.
Claim 14
Dependent Claim
75 words
The computer program product of claim 11, wherein said placement library further comprises: a placement data for shelves table, directly related to said configured rack item table and said placement data for racks table, for storing installation and removal dates for the shelves; and a placement data for cards table, directly related to said configured shelf item table and said placement data for shelves table, for storing data installation and removal dates for the modules.
Claim 15
Independent Claim
217 words
A method for using a databse, for accessing and storing data associated with the configuration and placement of equipment in field sites, said equipment comprising one or more components, wherein said components comprise rails, shelves and modules, said database being constructed by a method comprising the steps of: creating a product catalog for storing data associated with the components; creating a configuration library for storing data associated with the equipment, wherein the step of creating a configuration library comprises: creating a configured racks table, directly related to said product catalog, for storing data associated with configured racks; creating a configured racks item table, directly related to said configured racks table, for storing data associated with specific rack positions within said configured racks used to support configured shelves; creating a configured shelves table, directly related to said product catalog and said configured racks item table, for storing data related to said configured shelves, and creating a configured shelves item table, directly related to said configured shelves table and said product catalog, for storing data associated with specific shelf positions used to support said modules; p1 creating a site hierarchy repository for storing data associated with the field sites; and creating an equipment placement library for storing data associated with a location of said equipment within the field sites.
Claim 16
Independent Claim
217 words
A method for using a databse, for accessing and storing data associated with the configuration and placement of equipment in field sites, said equipment comprising one or more components, wherein said components comprise rails, shelves and modules, said database being constructed by a method comprising the steps of: creating a product catalog for storing data associated with the components; creating a configuration library for storing data associated with the equipment, wherein the step of creating a configuration library comprises: creating a configured racks table, directly related to said product catalog, for storing data associated with configured racks; creating a configured racks item table, directly related to said configured racks table, for storing data associated with specific rack positions within said configured racks used to support configured shelves; creating a configured shelves table, directly related to said product catalog and said configured racks item table, for storing data related to said configured shelves, and creating a configured shelves item table, directly related to said configured shelves table and said product catalog, for storing data associated with specific shelf positions used to support said modules; p1 creating a site hierarchy repository for storing data associated with the field sites; and creating an equipment placement library for storing data associated with a location of said equipment within the field sites.
Claim 17
Dependent Claim
94 words
The method for using a database according to claim 13, wherein said step of creating a product catalog, comprises the steps of: creating a product catalog table for storing data common to all of the components; creating a module table, directly related to said product catalog table, for storing data specifically associated with the modules; creating a shelf table, directly related to said product catalog table, for storing data specifically associated with the shelves; and creating a rack table, directly related to said product catalog table, for storing data specifically associated with the rails.
Claim 18
Dependent Claim
161 words
The method for using a database according to claim 13, wherein said step of creating a site hierarchy repository, comprises the steps of: creating a site table for storing data associated with the field sites; creating a structure table, directly related to said site table, for storing data associated with structures within each field site; creating a floor table, directly related to said structure table, for storing data associated with floors within each said structure; creating a zone table, directly related to said floor table, for storing data associated with zones within each said floor; creating a zone points table, directly related to said zone table, for storing data associated with graphical representations of said zones; creating a planning unit table, directly related to said zone table, for storing data associated with planning units within each said floors; and creating a row table, directly related to said planning unit table, for storing data associated with rows within each said planning units.
Claim 19
Dependent Claim
91 words
The method for using a database according to claim 15, wherein said step of creating a site hierarchy repository, further comprises the steps of: creating a floor points table, directly related to said floor table, for storing data associated with graphical representations of said floors; creating a planning unit points table, directly related to said planning unit table, for storing data associated with graphical representations of said planning units; and creating a row segments table, directly related to said row table, for storing data associated with graphical representations of said rows.
Claim 20
Dependent Claim
54 words
The method for using a database according to claim 16, wherein said step of creating a placement library, comprises the steps of: creating a placement data for racks table, directly related to said configured racks table and said row segments table, for defining a location and installation and removal dates for said configured racks.
Claim 21
Dependent Claim
87 words
The method for using a database according to claim 17, wherein said step of creating a placement library further comprises the steps of: creating a placement data for shelves table, directly related to said configured rack item table and said placement data for racks table, for storing installation and removal dates for the shelves; and creating a placement data for cards table, directly related to said configured shelf item table and said placement data for shelves table, for storing data installation and removal dates for the modules.
References Cited (Backward Citations)
US5426674A
Cited
US5664170A
Cited
US5515524A
Cited
US5630025A
Cited
US5630072A
Cited
US5774689A
Cited
US5764955A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-02-07 | 2003-08-09 | 2004-02-08 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-02-07 | 2007-08-09 | 2008-02-08 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-02-07 | 2011-08-09 | 2012-02-08 | $7700.00 | Window Closed / Lapsed |