# US 2003/0204523 A1 · Database management system

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2003/0204523 A1
- Document ID: US20030204523A1
- Status: Published application
- Kind: A1
- Application number: 10/153,187
- Filed: 2002-05-20
- Published: 2003-10-30
- Earliest claimed: 2001-05-18
- Inventors: Nigel Leck
- Web page: https://patentgrep.com/patent/US20030204523A1

## CPC

- G06F 16/244: {Grouping and aggregation}
- G06F 16/252: {between a Database Management System and a front-end application}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A database for use by a plurality of user groups, the database including: designation means for designating data into one of the following sets, a general set for data of potential general applicability to all user groups, the data within the general set being customizable only by one or more system administrators, and a specific set for each individual user group for data of potential applicability to only that user group, the data within the specific set being customizable only by the user group, whereby the information as presented to any selected user group is the result of aggregation of the data from the general set and the specific set for the selected group. Preferably the sets into which the designation means is capable of designating data further includes one or more intermediate sets for data of potential applicability to one or more sub-sets of user groups respectively.

## Claims

### Claim 1

A database for use by a plurality of user groups, the database including: designation means for designating data into one of the following sets:
a general set for data of potential general applicability to all user groups, the data within the general set being customizable only by one or more system administrators; and
a specific set for each individual user group for data of potential applicability to only that user group, the data within the specific set being customizable only by the user group;
whereby the information as presented to any selected user group is the result of aggregation of the data from the general set and the specific set for the selected group.

### Claim 2 (depends on 1)

The database of claim 1 wherein the sets into which the designation means is capable of designating data further includes one or more intermediate sets for data of potential applicability to one or more sub-sets of user groups respectively.

### Claim 3 (depends on 2)

The database of claim 2 wherein data within the intermediate sets is customizable only by one or more system administrators.

### Claim 4 (depends on 1)

The database of claim 1 wherein the data stored in each of the sets is stored in a uniform format.

### Claim 5 (depends on 4)

The database of claim 4 wherein the uniform format comprises three tables.

### Claim 6 (depends on 5)

The database of claim 5, wherein the three tables comprise a row table, a field table and a global key table.

### Claim 7

An integrated database system comprised of a plurality of independent databases conceptually arranged in a hierarchy.

### Claim 8 (depends on 7)

The system of claim 7 wherein each of the databases is graded to a given level of specificity.

### Claim 9 (depends on 8)

The system of claim 8 wherein the system includes a database interpreter which filters data derived from adjacent ones of the layers so as to produce a logical view for a user of the database system.

### Claim 10

A data structure for a database system, the database system comprising a plurality of independent databases conceptually arranged in a hierarchy, wherein data is defined in rows and fields as a many to one mapping of fields to rows.

### Claim 11 (depends on 10)

The data structure of claim 10 wherein the data structure incorporating a common architecture to store classes and fields and to store data and thereby to provide an available audit trail to the field structure and the data.
