# US 8,280,924 B2 · Object-relational mapping with dynamic relational schemas

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

- Number: US 8,280,924 B2
- Document ID: US8280924B2
- Status: Granted
- Kind: B2
- Application number: 12/412,135
- Filed: 2009-03-26
- Published: 2010-09-30
- Granted: 2012-10-02
- Earliest claimed: 2009-03-26
- Assignees: Microsoft Corporation
- Inventors: Brad Mark Olenick; Gregory Lawrence Hughes; Siddharth Jayadevan; Carll Bennett Hoffman; Clemens Kerer
- Web page: https://patentgrep.com/patent/US8280924B2

## CPC

- G06F 16/289: {Object oriented databases}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

In an embodiment, a generic database application of a computer system receives a portion of input data from a database. The generic database application can communicate with the database using a variety of different database schemas. The generic database application of the computer system infers a portion of ORM metadata associated with the received input data. The computer system accesses a generic ORM query where the ORM query is configured to provide mapping information to map the input data into a graph of objects according to the database object properties included in the ORM metadata. The computer system maps the input data into a graph of objects using the database object properties included in the ORM metadata and displays an ORM object view which includes the graph of objects.

## Claims

### Claim 1

In a computing network at which data is made available from a variety of different sources and in a variety of different data types and formats, a computer-implemented method for use at a computer system having a processor and memory, and which is running a database application configured to communicate with a database using at least one of a variety of different database schemas, the computer-implemented method facilitating the ability of the database application to more easily use the data from the variety of different sources, and comprising:
receiving at the database application input data from a database;
instantiating at the database application a metadata inferring module that infers object relational mapping (ORM) metadata for one or more database objects of the received input data, the ORM metadata inferred from at least one of the database schemas that the database application is configured to use, the inferred ORM metadata including an indication of database object properties and database schema settings associated with one or more database objects of the received input data, thereby allowing the database application to implement ORM capabilities to retrieve and access information from the database;
instantiating at the database application an object relational mapping (ORM) query module configured to use ORM metadata to generate information that is used to generate an object graph, the ORM query module processing the ORM metadata for the one or more database objects of the received input data;
instantiating an object graph generator and, using the information derived by the ORM query module after processing the ORM metadata, the object graph generator then mapping the one or more database objects of the input data into a graph of objects which enables the mapped one or more database objects to be sent to another application or to be subsequently displayed in an ORM object view.

### Claim 2 (depends on 1)

The method of claim 1, wherein the ORM query module is configured to handle relational schema changes without restarting or recompiling the database application.

### Claim 3 (depends on 1)

The method of claim 1, wherein the input data received from the database includes a sequence of tables with one or more rows of information in each table.

### Claim 4 (depends on 3)

The method of claim 3, wherein the ORM metadata indicates how to map a given row of a table to a certain class or object type.

### Claim 5 (depends on 1)

The method of claim 1, further comprising an act of tracking one or more input data dependencies in the ORM query module.

### Claim 6 (depends on 1)

The method of claim 1, further comprising:
an act of determining that at least a portion of input data being displayed in an ORM object view has been updated; and
an act of automatically and dynamically updating the existing object view based on the updated input data.

### Claim 7 (depends on 6)

The method of claim 6, wherein the updates to the input data are tracked using the ORM query module.

### Claim 8 (depends on 1)

The method of claim 1, further comprising:
an act of determining that at least a portion of schema settings in the database have been updated; and
an act of invalidating a displayed ORM object view based on the determination that schema settings in the database have been updated.

### Claim 9 (depends on 8)

The method of claim 8, wherein invalidating the displayed ORM object view comprises adding or removing one or more columns of a table corresponding to the input data being represented on the displayed ORM object view.

### Claim 10 (depends on 9)

The method of claim 9, wherein the one or more corresponding columns is added or removed automatically without any user intervention and dynamically without restarting the database application.

### Claim 11

In a computing network at which data is made available from a variety of different sources and in a variety of different data types and formats, a physical storage media having stored thereon computer-executable instructions for implementing a method for use at a computer system having a processor and memory, and which is running a database application configured to communicate with a database using at least one of a variety of different database schemas, the computer-implemented method facilitating the ability of the database application to more easily use the data from the variety of different sources, and comprising:
receiving at the database application input data from a database;
instantiating at the database application a metadata inferring module that infers object relational mapping (ORM) metadata for one or more database objects of the received input data, the ORM metadata inferred from at least one of the database schemas that the database application is configured to use, the inferred ORM metadata including an indication of database object properties and database schema settings associated with one or more database objects of the received input data, thereby allowing the database application to implement ORM capabilities to retrieve and access information from the database;
instantiating at the database application an object relational mapping (ORM) query module configured to use ORM metadata to generate information that is used to generate an object graph, the ORM query module processing the ORM metadata for the one or more database objects of the received input data;
instantiating an object graph generator and, using the information derived by the ORM query module after processing the ORM metadata, the object graph generator then mapping the one or more database objects of the input data into a graph of objects which enables the mapped one or more database objects to be sent to another application or to be subsequently displayed in an ORM object view.

### Claim 12 (depends on 11)

The physical storage media of claim 11, wherein the ORM query module is configured to handle relational schema changes without restarting or recompiling the database application.

### Claim 13 (depends on 11)

The physical storage media of claim 11, wherein the input data received from the database includes a sequence of tables with one or more rows of information in each table.

### Claim 14 (depends on 13)

The physical storage media of claim 13, wherein the ORM metadata indicates how to map a given row of a table to a certain class or object type.

### Claim 15 (depends on 11)

The physical storage media of claim 11, further comprising an act of tracking one or more input data dependencies in the ORM query module.

### Claim 16 (depends on 11)

The physical storage media of claim 11, further comprising:
an act of determining that at least a portion of input data being displayed in an ORM object view has been updated; and
an act of automatically and dynamically updating the existing object view based on the updated input data.

### Claim 17 (depends on 16)

The physical storage media of claim 16, wherein the updates to the input data are tracked using the ORM query module.

### Claim 18 (depends on 11)

The physical storage media of claim 11, further comprising:
an act of determining that at least a portion of schema settings in the database have been updated; and
an act of invalidating a displayed ORM object view based on the determination that schema settings in the database have been updated.

### Claim 19 (depends on 18)

The physical storage media of claim 18, wherein invalidating the displayed ORM object view comprises adding or removing one or more columns of a table corresponding to the input data being represented on the displayed ORM object view.

### Claim 20 (depends on 19)

The physical storage media of claim 19, wherein the one or more corresponding columns is added or removed automatically without any user intervention and dynamically without restarting the database application.
