US5870746A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for segmenting a database based upon data attributes
Assignee: NCR Voyix Corp
•
Filing: 1996-10-31
•
Granted: 1999-02-09
•
Expires: 2016-10-31
Abstract
Abstract A system and method for allowing a user to segment and partition a database based upon attributes associated with the data in the database. Also, a system and method for generating a report for a user which allows the user to make decisions, without requiring the user to understand or interpret data itself. A database computer includes a database containing the data. The data includes a collection of information about an enterprise of the user. A server computer is coupled to the database computer and executes a database management program. A client computer is coupled to the server and executes an application program. The application program allows a user to define predetermined data types, to define relationships between the data types, to define parameters for the report, to define a method of analysis for the report, and to create the report. The report summarizes the data in terms of the data types, the data relationships, and the method of analysis.
Inventors
- 👤 James F. Knutson
- 👤 Tejwansh S. Anand
- 👤 Sheila Taheri
- 👤 Scott D. Coulter
- 👤 Kevin W. Copas
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 21:41
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/248; G06F16/90; G06F16/95; G06F16/958; G06F16/986; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99942
Claims Analysis
Total Claims: 13
Claim 1
Independent Claim
166 words
A system for managing a database hierarchy, comprising: (a) a database computer, including a data warehouse comprising data entities having associated attributes, wherein the data entities are arranged in a first hierarchy, each level of the first hierarchy being associated with at least one attribute; (b) a server computer coupled to the database computer, wherein the server computer includes a data abstraction intelligence subsystem and a data and schema manipulation subsystem having: (1) means for receiving an attribute restriction value for restricting a selected attribute; and (2) means for partitioning and segmenting the database, wherein a second hierarchy is created, the second hierarchy being associated with the attribute restriction value; and (c) a client computer coupled to the server computer, wherein the client computer includes: (1) means for inputting from a user of the client computer the attribute restriction value; and (2) means for transmitting the attribute restriction value to the receiving means of the data abstraction intelligence subsystem and the data and schema manipulation subsystem.
Claim 2
Independent Claim
166 words
A system for managing a database hierarchy, comprising: (a) a database computer, including a data warehouse comprising data entities having associated attributes, wherein the data entities are arranged in a first hierarchy, each level of the first hierarchy being associated with at least one attribute; (b) a server computer coupled to the database computer, wherein the server computer includes a data abstraction intelligence subsystem and a data and schema manipulation subsystem having: (1) means for receiving an attribute restriction value for restricting a selected attribute; and (2) means for partitioning and segmenting the database, wherein a second hierarchy is created, the second hierarchy being associated with the attribute restriction value; and (c) a client computer coupled to the server computer, wherein the client computer includes: (1) means for inputting from a user of the client computer the attribute restriction value; and (2) means for transmitting the attribute restriction value to the receiving means of the data abstraction intelligence subsystem and the data and schema manipulation subsystem.
Claim 3
Dependent Claim
67 words
The system of claim 1, wherein the data abstraction intelligence subsystem and the data and schema manipulation subsystem further include means for transmitting the second hierarchy to the client computer, and the client computer further includes means for receiving the second hierarchy from the data abstraction intelligence subsystem and the data and schema manipulation subsystem and displaying the second hierarchy to the user of the client computer.
Claim 4
Dependent Claim
33 words
The system of claim 1, wherein the data abstraction intelligence subsystem and the data and schema manipulation subsystem further include means for querying the data entities within the database having the first hierarchy.
Claim 5
Dependent Claim
33 words
The system of claim 1, wherein the data abstraction intelligence subsystem and the data and schema manipulation subsystem further include means for querying the data entities within the database having the second hierarchy.
Claim 6
Dependent Claim
25 words
The system of claim 1, wherein the data abstraction intelligence subsystem and the data and schema manipulation subsystem further include means for querying the database.
Claim 7
Dependent Claim
13 words
The system of claim 5, wherein the querying means comprises a SQL server.
Claim 8
Dependent Claim
21 words
The system of claim 5, wherein the client computer further includes means for transmitting a query request to the querying means.
Claim 9
Dependent Claim
157 words
In a computer system comprising a client computer, a server computer coupled to the client computer, and a database coupled to the server computer, wherein the database contains data entities, and wherein the server computer includes a data abstraction intelligence subsystem and a data and schema manipulation subsystem, a process for managing a hierarchy associated with the database, comprising the steps of: (a) associating attributes with the data entities; (b) arranging the data entities in a first hierarchy, wherein each level of the first hierarchy is associated with at least one attribute; (c) inputting from a user of the client computer an attribute restriction value; (d) transmitting the attribute restriction value from the client computer to the data abstraction intelligence subsystem and the data and schema manipulation subsystem, the attribute restriction value restricting a selected attribute; and (e) segmenting the database, wherein a second hierarchy is created, the second hierarchy being associated with the attribute restriction value.
Claim 10
Dependent Claim
157 words
In a computer system comprising a client computer, a server computer coupled to the client computer, and a database coupled to the server computer, wherein the database contains data entities, and wherein the server computer includes a data abstraction intelligence subsystem and a data and schema manipulation subsystem, a process for managing a hierarchy associated with the database, comprising the steps of: (a) associating attributes with the data entities; (b) arranging the data entities in a first hierarchy, wherein each level of the first hierarchy is associated with at least one attribute; (c) inputting from a user of the client computer an attribute restriction value; (d) transmitting the attribute restriction value from the client computer to the data abstraction intelligence subsystem and the data and schema manipulation subsystem, the attribute restriction value restricting a selected attribute; and (e) segmenting the database, wherein a second hierarchy is created, the second hierarchy being associated with the attribute restriction value.
Claim 11
Independent Claim
156 words
A system for managing a database, comprising: (a) a hierarchical database comprising data arranged in tables having columns; (b) a server computer coupled to the database, the server computer including a data abstraction intelligence subsystem and a data and schema manipulation subsystem; (c) a client computer coupled to the server computer, the client computer including means for receiving input from a user of the client computer, wherein the system creates metadata concerning a particular business for use in partitioning and segmenting the database, the metadata being created by the following method: (1) receiving as an input from the user a specified business concept; (2) receiving as an input from the user one or more attributes for the specified business concept; (3) providing to the user a list of columns of tables in the database; (4) receiving as an input from the user a mapping of each attribute to a column in a table in the database.
Claim 12
Independent Claim
156 words
A system for managing a database, comprising: (a) a hierarchical database comprising data arranged in tables having columns; (b) a server computer coupled to the database, the server computer including a data abstraction intelligence subsystem and a data and schema manipulation subsystem; (c) a client computer coupled to the server computer, the client computer including means for receiving input from a user of the client computer, wherein the system creates metadata concerning a particular business for use in partitioning and segmenting the database, the metadata being created by the following method: (1) receiving as an input from the user a specified business concept; (2) receiving as an input from the user one or more attributes for the specified business concept; (3) providing to the user a list of columns of tables in the database; (4) receiving as an input from the user a mapping of each attribute to a column in a table in the database.
Claim 13
Dependent Claim
121 words
A system according to the claim 9, wherein the method for creating metadata includes the following additional steps: (5) receiving as an input from the user one or more business indicators; (6) providing to the user a list of columns of table in the database; (7) receiving as an input from the user a mapping of each business indicator to a column in a table in the database; (8) receiving as an input from the user an aggregate method for the mapped business indicators; (9) receiving as an input from the user a selected unit of measurement for the mapped business indicators; (10) ensuring that tables having mapped business indicator columns can be joined with tables having mapped business attribute columns.
References Cited (Backward Citations)
US4318184A
Cited
US5404506A
Cited
US4868743A
Cited
US5088052A
Cited
US5471611A
Cited
US5414838A
Cited
US5644740A
Cited
US5544298A
Cited
US5455945A
Cited
US5537590A
Cited
US5546529A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-02-08 | 2002-08-10 | 2003-02-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-02-08 | 2006-08-10 | 2007-02-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-02-08 | 2010-08-10 | 2011-02-09 | $7700.00 | Window Closed / Lapsed |