Collaborative data mapping system
An example method for mapping data can include: generating a user interface configured to enable a user to create a data element of a mapping specification, wherein the mapping specification includes a spreadsheet having a plurality of data fields; allowing for dragging of the data element onto the user interface and multi-selection of the data element with other data elements; allowing for dropping of the data element into a desired location of the user interface and the multi-selection of the data element; storing the data element in a temporary schema independent from a database schema of the data warehouse; and enabling the user to associate the data element with one or more physical data elements in the database schema.
1. A method for mapping data, the method comprising:
generating a user interface configured to enable a user to create a data element of a mapping specification, wherein the mapping specification includes a spreadsheet having a plurality of data fields describing mapping of data from a source information system to a data warehouse;
allowing for dragging of the data element onto the user interface and multi-selection of the data element with other data elements;
allowing for dropping of the data element into a desired location of the user interface and the multi-selection of the data element with the other data elements, wherein the desired location is one of the plurality of data fields of the spreadsheet for the data element or a subset of the plurality of data fields of the spreadsheet for the multi-selection of the data element with the other data elements;
storing the data element in a temporary schema independent from a database schema of the data warehouse; and
enabling the user to associate the data element with one or more physical data elements in the database schema.
2. The method of claim 1 , further comprising:
creating one or more data fields in the database schema;
associating the data element with the one or more data fields in the database schema; and
removing the data element in the temporary schema.
3. The method of claim 1 , wherein the one or more physical data elements are stored in a database.
4. The method of claim 1 , further comprising replacing the data element with a resulting physical data element.
5. The method of claim 1 , further comprising:
allowing the data element to be associated with a resulting physical data element; and
removing the data element from the temporary schema.
6. The method of claim 1 , further comprising allowing the data element to be characterized as a logical data element.
7. The method of claim 6 , further comprising allowing the logical data element to be added to a column of a logical data table.
8. A method for mapping data, the method comprising:
generating a user interface configured to enable a user to create a data element of a mapping specification, wherein the mapping specification includes a spreadsheet having a plurality of data fields describing mapping of data from a source information system to a data warehouse;
allowing for dragging of the data element onto the user interface and multi-selection of the data element with other data elements;
allowing for dropping of the data element into a desired location of the user interface and the multi-selection of the data element with the other data elements, wherein the desired location is one of the plurality of data fields of the spreadsheet for the data element or a subset of the plurality of data fields of the spreadsheet for the multi-selection of the data element with the other data elements;
storing the data element in a temporary schema independent from a database schema of the data warehouse;
enabling the user to associate the data element with one or more physical data elements in the database schema, wherein the one or more physical data elements are stored in a database;
creating one or more data fields in the database schema;
associating the data element with the one or more data fields in the database schema; and
removing the data element in the temporary schema.
9. The method of claim 8 , further comprising replacing the data element with a resulting physical data element.
10. The method of claim 8 , further comprising:
allowing the data element to be associated with a resulting physical data element; and
removing the data element from the temporary schema.
11. The method of claim 8 , further comprising allowing the data element to be characterized as a logical data element.
12. The method of claim 11 , further comprising allowing the logical data element to be added to a column of a logical data table.