GRID FORMAT DATA VIEWING AND EDITING ENVIRONMENT

摘要

A data profiling server extracts data from multiple data sources and stores the extracted data in a target data store. Validation functions are performed on the extracted to determine whether the data conforms to validation rules associated with the target data store and/or business logic definitions. For data that does not conform to the validation rules, the data profiling server identifies recommended transformations to be applied to the data to correct any errors that cause the data to not conform with the validation rules. A data profiling application presents to a user the data extracted from the multiple data sources in a grid structure. The grid structure also includes error indicators identifying the data that does not conform to the validation rules and specifies the recommended transformations identified by the data profiling server.

主权项

1. A grid-based user interface for viewing and editing data extracted from multiple data sources, comprising:
a primary grid interface corresponding to a database table that stores data extracted from one or more data sources, the primary grid interface comprising:
grid columns corresponding to data columns of the table,grid rows corresponding to data rows of the table,an error indicator associated with each grid column that indicates whether data in the grid column includes errors, anda transformation indicator associated with each grid column that indicates whether any transformations have been applied to the grid column; a column summary interface that identifies errors included in the data of at least one grid column and specifies one or more recommended transformations applicable to the at least one grid column to correct the identified errors; and a transformation control configured to receive transformation specifications associated with one or more grid columns, a transformation specification identifying how data in the one or more grid columns is to be modified to correct at least one error.