Method and system for mapping between logical data and physical data
DCFirst Claim
Patent Images
1. A method in a computer system for providing a view of data, the method comprising:
- providing physical data having standard and custom data, the standard data having entries with data for standard fields, the custom data having data for custom fields, the custom fields being represented by pivot data;
providing a map between standard and custom fields and logical fields of logical data;
providing a result set containing physical data from a standard field and a custom field;
organizing the physical data of the result set into logical data using the provided map; and
storing the organized logical data as the view.
2 Assignments
Litigations
0 Petitions
Accused Products
Abstract
The mapping system maps a physical table of a database to a logical table representing a logical view of the database that integrates standard columns and custom columns. The physical table includes a standard table with standard columns and a custom table with custom columns. The custom table may be implemented as a pivot table. The mapping system provides a map between standard and custom columns and logical columns. The physical table may include multiple standard tables. The mapping system allows for individual standard tables to be updated, rather than updating all the columns across all the standard tables for a row.
51 Citations
27 Claims
-
1. A method in a computer system for providing a view of data, the method comprising:
-
providing physical data having standard and custom data, the standard data having entries with data for standard fields, the custom data having data for custom fields, the custom fields being represented by pivot data; providing a map between standard and custom fields and logical fields of logical data; providing a result set containing physical data from a standard field and a custom field; organizing the physical data of the result set into logical data using the provided map; and storing the organized logical data as the view. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer-readable storage medium containing a data structure for mapping between a logical table and a physical table, the physical table including a standard table and a custom table, the data structure comprising:
-
for each logical column of the logical table, when the logical column corresponds to a standard column of the standard table, mapping the logical column to the corresponding standard column; and when the logical column corresponds to a custom column of the custom table, mapping the logical column to the corresponding custom column, the custom table being represented by a pivot table; instructions for generating a logical view of physical data using the mapping; and instructions for storing the generated view. - View Dependent Claims (11, 12, 13)
-
-
14. A computer-readable storage medium containing instructions for controlling a computer system to update data, by a method comprising:
-
providing a map between standard and custom columns of a physical table and logical columns of a logical table, the custom columns being represented using a pivot table; providing an indication of an update to the logical table; using the map to determine the standard column or custom column to which an updated logical column corresponds; and effecting the update of the determined column of the physical table. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
-
21. A computer-readable storage medium containing instructions for controlling a computer system to update data, by a method comprising:
-
providing a map between physical columns of a physical table and logical columns of a logical table, the physical table being represented a multiple database tables within a database; providing a result set containing physical data derived from the multiple database tables; organizing the physical data of the result set into a logical table based on the provided map; providing an indication of an update to the logical table, the update updating logical columns corresponding to physical columns represented in different database tables; using the provided map to determine to which columns of which database tables the updated logical columns correspond; and effecting the update of the determined columns of the database tables. - View Dependent Claims (22, 23, 24, 25, 26, 27)
-
Specification