# US 2009/0276447 A1 · Formats for database template files shared between client and server environments

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

- Number: US 2009/0276447 A1
- Document ID: US20090276447A1
- Status: Published application
- Kind: A1
- Application number: 12/115,528
- Filed: 2008-05-05
- Published: 2009-11-05
- Earliest claimed: 2008-05-05
- Assignees: Microsoft Corporation
- Inventors: Michael J. McCormack; Jason Alan Bould; Scott Timothy Gardner; Andrew Robert Miller; Timothy Ervin Getsch; Jonathan Aaron McPherson; Geoffrey L. Griffith
- Web page: https://patentgrep.com/patent/US20090276447A1

## CPC

- G06F 16/58: Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Tools and techniques are described for formats for database template files shared between client and server environments. Systems provided by these tools may include client subsystems that include client-side database management applications that instantiate tables within a database, and instantiate client-specific database template files corresponding respectively to the tables. These database management applications may also instantiate server-specific database template files that correspond to the client-specific template files, and may enable servers to access the server-specific template file. These systems may also include server subsystems that further include server-side database management services that access the server-specific template files, and instantiate server-side template files based thereon. In turn, the database management services may create database applications from the server-side template files.

## Claims

### Claim 1

A system comprising:
at least one client subsystem that includes a client-side database management application for:
instantiating a plurality of tables within a database;
instantiating a plurality of client-specific database template files corresponding respectively to the tables;
instantiating at least one server-specific database template file corresponding to at least one of the client-specific template files; and
enabling at least one server to access the server-specific template file; and
at least one server subsystem that includes a server-side database management service for:
accessing the server-specific template file;
instantiating at least one server-side template file based on the server-specific template file; and
creating at least one database application from the server-side template file.

### Claim 2 (depends on 1)

The system of claim 1, wherein the database includes at least one resource table that further includes at least one image or at least one theme.

### Claim 3 (depends on 2)

The system of claim 2, further comprising a resource directory that includes at least one template file representation corresponds to the image or to the theme.

### Claim 4 (depends on 2)

The system of claim 2, wherein the client subsystem is adapted to combine a plurality of images into a composite image, and to provide the composite image to the server subsystem.

### Claim 5 (depends on 4)

The system of claim 4, wherein the server subsystem is adapted to partition a composite image and extract individual images upon request.

### Claim 6 (depends on 1)

The system of claim 1, wherein the server-side database management service is for rendering the database application on at least one client subsystem.

### Claim 7 (depends on 1)

The system of claim 1, wherein the client subsystem includes a template file that further includes at least one view template that expresses a visualization associated with at least one table within the database.

### Claim 8 (depends on 5)

The system of claim 5, wherein the server subsystem is adapted to import the visualization expressed in the view template, and to create the database application to incorporate the visualization.

### Claim 9 (depends on 1)

The system of claim 1, wherein the database application is a hybrid database application that includes at least one client-specific object instantiated from the client-specific template file, at least one server-specific object instantiated from the server-specific template file.

### Claim 10

At least one computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to perform a method comprising:
instantiating a plurality of tables within at least one database;
instantiating a plurality of client-specific database template files corresponding respectively to the tables;
instantiating at least one server-specific database template file corresponding to at least one of the client-specific template files; and
enabling at least one server to access the server-specific template file.

### Claim 11 (depends on 10)

The storage medium of claim 10, further comprising instructions for defining at least one type property associated with at least one of the tables, and for incorporating the type property into a database template file corresponding to the at least one table.

### Claim 12 (depends on 10)

The storage medium of claim 10, further comprising instructions for defining a name mapping table that maps a name of at least a first one of the tables to at least a second name.

### Claim 13 (depends on 12)

The storage medium of claim 12, further comprising instructions for storing name metadata that is associated with the name mapping table.

### Claim 14

At least one computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to perform a method comprising:
accessing a server-specific template file that is instantiated based on at least one client-specific template file;
instantiating at least one server-side template file based on the server-specific template file; and
creating at least one database application from the server-side template file.

### Claim 15 (depends on 14)

The storage medium of claim 14, wherein the instructions for accessing a server-specific template file include instructions for accessing a template file that includes at least one type property corresponding to a client database table represented within the client-specific template file.

### Claim 16 (depends on 15)

The storage medium of claim 15, further comprising instructions for joining at least part of a client database into a server database, based on the type property.

### Claim 17 (depends on 15)

The storage medium of claim 15, further comprising instructions for identifying, based on the type property, at least one column of a client database for joining with a corresponding column in the server database.

### Claim 18 (depends on 16)

The storage medium of claim 16 further comprising instructions for determining whether the server database includes a context table.

### Claim 19 (depends on 16)

The storage medium of claim 16, further comprising instructions for joining at least part of the client database into the server database using a context table.

### Claim 20 (depends on 16)

The storage medium of claim 16, further comprising instructions for conducting a dialogue with at least one user to associate at least part of the client database with at least part of the server database.
