Schema evolution via transition information
View Patent ↗Disclosed herein are system, method, and computer program product embodiments for transforming data from a first version, for example an initial version of a database, to a second version, for example a subsequent version of a database. An embodiment operates by modifying the metadata of the data to include transformational clauses, each of which describes how a portion of the data in the first version is transformed to data required by the second version.
1. A computer implemented method for validating database metadata, comprising:
receiving, by at least one processor, a database metadata version that includes a transformation clause and a confirmation key word;
identifying, by the at least one processor, the transformation clause;
determining, by the at least one processor, the transformation clause converts data in a column of a database from one type to another and the conversion may cause a loss of data; and
determining, by the at least one processor, whether the transformation clause includes an error based at least in part on the confirmation key word,
wherein if the error is determined, modifying, by the at least one processor, the transformation clause in the database metadata version to indicate there is an error in response to determining the transformation clause converts data from one type to another and the conversion may cause the loss of data, wherein the modifying comprises inserting a comment into the database metadata version that specifies the error in the transformation clause.
2. The method of claim 1 , wherein the modifying further comprises indicating an error in response to determining the transformation clause has not been flagged as acceptable.
3. The method of claim 1 , wherein the modifying further comprises indicating an error in response to determining the transformation clause does not include an indication of how to handle the loss of data.
4. The method of claim 1 , further comprising:
identifying, by the at least one processor, anew column; and
determining, by the at least one processor, whether the new column has an initial value.
5. The method of claim 4 , wherein the modifying further comprises indicating there is an error in response to determining the new column does not have the initial value.
6. The method of claim 4 , wherein in the initial value comprises a value based on an existing column.
7. A system, comprising:
a memory; and
at least one processor coupled to the memory and configured to:
receive a first version that includes a transformation clause and a confirmation key word;
identify the transformation clause;
determine the transformation clause converts data from one type to another and the conversion may cause a loss of data; and
determine, by the at least one processor, whether the transformation clause in an error based at least in part on the confirmation key word,
wherein if the error is determined, modify the transformation clause to indicate there is an error in response to determining the transformational clause converts data from one type to another and the conversion may cause the loss of data, wherein the modifying comprises inserting a comment into the database metadata version that specifies the error in the transformation clause.
8. The system of claim 7 , wherein
the first version comprises a first database metadata; and
the data comprises data in a column of a database.
9. The system of claim 8 , the at least one processor is further configured to execute a compiler that analyses the transformation clause, wherein the compiler is configured to modify the transformation clause.
10. The system of claim 8 , wherein to modify the transformation clause the at least one processor is configured to indicate an error in response to determining the transformation clause has not been flagged as acceptable.
11. The system of claim 8 , wherein to modify the transformation clause the at least one processor is configured to indicate an error in response to determining the transformation clause does not include an indication of how to handle the loss of data.
12. The system of claim 8 , the at least one processor is further configured to:
identify a new column; and
determine whether the new column has an initial value.
13. The system of claim 12 , wherein to modify the transformation clause the at least one processor is configured to indicate that there is an error in response to determining the new column does not have an initial value.
14. A tangible computer-readable device having instructions stored thereon that, when executed by at least one computing device, causes the at least one computing device to perform operations comprising:
receiving a first database metadata version that includes a transformation clause and a confirmation key word;
identifying the transformation clause;
determining the transformation clause converts data in a column of a database from one type to another and the conversion may cause a loss of data; and
determining, by the at least one processor, whether the transformation clause includes an error based at least in tart on e confirmation key word,
wherein if the error is determined, modifying the transformation clause to indicate there is an error in response to determining the transformational clause converts data from one type to another and that the conversion may cause the loss of data, wherein the modifying comprises inserting a comment into the database metadata version that specifies the error in the transformation clause.
15. The computer-readable device of claim 14 , wherein the modifying comprises:
indicating an error in response to determining the transformation clause has not been flagged as acceptable.
16. The computer-readable device of claim 14 , wherein the modifying comprises:
indicating an error in response to determining the transformation clause does not include an indication of how to handle the loss of data.
17. The computer-readable device of claim 14 , the operations further comprising:
identifying a new column; and
determining whether the new column has an initial value.
18. The computer-readable device of claim 17 , the modifying comprising:
indicating there is an error in response to determining the new column does not have the initial value.
19. The computer-readable device of claim 17 , wherein the initial value comprises a value based on an existing column.
20. The computer-readable device of claim 14 , the operations further comprising:
indicating the first database metadata version is correct in response to determining there is no error in any of a one or more transformation clauses in the first database metadata version.