# US 2011/0238711 A1 · Method and module for creating a relational database schema from an ontology

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

- Number: US 2011/0238711 A1
- Document ID: US20110238711A1
- Status: Published application
- Kind: A1
- Application number: 13/132,948
- Filed: 2009-12-07
- Published: 2011-09-29
- Earliest claimed: 2008-12-12
- Assignees: Koninklijke Philips Electronics N.V.
- Inventors: Anke Schmeink; Sandra Geisler; Andreas Brauers; Christoph Josef Quix
- Web page: https://patentgrep.com/patent/US20110238711A1

## CPC

- G06F 16/22: Indexing; Data structures therefor; Storage structures
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method for creating a relational database schema is provided. The method comprises accessing (110, 210) a reference ontology (101) comprising a first number of concepts and a second number of properties, selecting (120, 220) a first set of concepts from the reference ontology, determining (130, 230) a first set of properties from said second number of properties, associated with the selected first set of concepts, determining (140, 240) a second set of concepts associated with the determined first set of properties, and generating (150, 250) a relational database schema comprising a number of tables, of which at least one table pertains to a concept of said second set of concepts. Further, a module (300) for creating a relational database schema is provided.

## Claims

### Claim 1

A method for creating a relational database schema, comprising
accessing (110, 210) a reference ontology (101) comprising a first number of concepts and a second number of properties,
selecting (120, 220) a first set of concepts from the reference ontology (101),
determining (130, 230) a first set of properties from said second number of properties, associated with the selected first set of concepts,
determining (140, 240) a second set of concepts associated with the determined first set of properties, and
generating (150, 250) a relational database schema comprising a number of tables, of which at least one table pertains to a concept of said second set of concepts.

### Claim 2 (depends on 1)

The method according to claim 1, wherein at least one table of said number of tables of said relational database schema pertains to a concept of said first set of concepts.

### Claim 3 (depends on 1)

The method according to claim 1, wherein at least one table of said number of tables of said relational database schema pertains to a property of the determined first set of properties.

### Claim 4 (depends on 1)

The method according to claim 1, further comprising the step of creating (160,251) a meta representation comprising transformations between the reference ontology (101) and the generated relational database schema.

### Claim 5 (depends on 1)

The method according to claim 1, further comprising
determining (130, 230) a second set of properties from said second number of properties, associated with the determined second set of concepts,
determining (140, 240) a third set of concepts associated with the determined second set of properties, and wherein
the relational database schema comprises at least one table pertaining to a concept of the third set of concepts.

### Claim 6 (depends on 1)

The method according to claim 1, further comprising creating (290) a relational database by means of the created relational database schema.

### Claim 7 (depends on 1)

Use of the method according to claim 1 for creating relational databases for clinical trial data management.

### Claim 8 (depends on 1)

A computer program product stored on a computer-readable medium comprising software code adapted to perform the steps of the method according to claim 1 when executed on a data-processing apparatus.

### Claim 9

A module for creating a relational database schema, comprising
a unit (310) for accessing a reference ontology (101) comprising a first number of concepts and a second number of properties,
a user interface (320) for enabling a user to select a first set of concepts from the reference ontology (101) and adapt the relational database schema,
a unit (330) for determining a first set of properties from said second number of properties, associated with the selected first set of concepts,
a unit (340) for determining a second set of concepts associated with the determined first set of properties, and
a unit (350) for generating a relational database schema comprising a number of tables, of which at least one table pertains to a concept of said second set of concepts.

### Claim 10 (depends on 9)

The module according to claim 9, further comprising a unit (355) for creating a meta representation comprising transformations between the reference ontology (101) and the generated relational schema.

### Claim 11 (depends on 9)

The module according to claim 9, further comprising
a unit (360) for converting the selected first set of concepts, the determined second set of concepts, and the determined first set of properties in to at least one Data Definition Language script file.

### Claim 12 (depends on 9)

The module according to claim 9, further comprising a unit (370) for generating a relational database by means of the created relational database schema.

### Claim 13 (depends on 12)

The module according to claim 12, further comprising a unit for connecting with a remote database server, said relational database is created on said remote database server.

### Claim 14 (depends on 9)

The module according to claim 9, wherein said user interface (320) is configured to display a preview of the relational database schema.

### Claim 15 (depends on 14)

The module according to claim 14, wherein said user interface (320) is configured to adapt the relational database schema.
