| 发明名称 |
MANAGING DATA WITH FLEXIBLE SCHEMA |
| 摘要 |
The subject matter described herein relates to managing data with flexible schema. A method, computer storage medium, and system are provided for managing data with flexible schema. In one embodiment, the method comprises providing a logical view for logical tables of a database; and managing mappings between the logical tables and a physical table according to predefined mapping constraints, each of the logical tables mapped as a part of the physical table. The mapping constraints at least specify that (i) a logical column in the logical tables is mapped to at least one physical column in the physical table, and (ii) distinct logical columns in one of the logical tables are mapped to distinct physical columns in the physical table. As a result, schema evolution may be done with minimized data migration. |
| 申请公布号 |
US2015379058(A1) |
申请公布日期 |
2015.12.31 |
| 申请号 |
US201414488204 |
申请日期 |
2014.09.16 |
| 申请人 |
Microsoft Corporation |
发明人 |
Chen Liang;Bernstein Philip A. |
| 分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A method implemented at least in part by a computer comprising:
providing a logical view for logical tables of a database; and managing a mapping between the logical tables and a physical table according to predefined mapping constraints, each of the logical tables mapped to a part of the physical table, the mapping constraints at least specifying that (i) a logical column in the logical tables is mapped to at least one physical column in the physical table, and (ii) distinct logical columns in one of the logical tables are mapped to distinct physical columns in the physical table. |
| 地址 |
Redmond WA US |
