Database table format conversion based on user data access patterns in a networked computing environment

1. A computer-implemented method for converting database formats based on user data access patterns in a cloud computing environment, comprising:

identifying a first set of database tables based on a set of access patterns stored in a computer storage device, the first set of database tables having a first format, wherein the first format is a relational database format and the set of access patterns indicate at least one of: a set of user data queries, insertions, updates or deletions to data stored in the first set of database tables;

augmenting at least one table of the first set of database tables to generate a second set of database tables having a second format and stored in a cloud data repository, the second set of database tables being a set of de-normalized tables;

creating a mapping between the first set of database tables and the second set of database tables;

generating a column set based on the at least one condition of the set of access patterns;

using the column set as a key for the second set of database tables; and

propagating at least one data operation to the second set of database tables based on the key.

2. The computer-implemented method of claim 1 , the first format being a relational database format, and the second format being a hash table format.

3. The computer-implemented method of claim 1 , the propagating further based on the mapping or the at least one condition.

4. The computer-implemented method of claim 1 , the at least one data operation being at least one of: a data query operation, a data update operation, a data deletion operation, or a data insertion operation.

5. The computer-implemented method of claim 1 , wherein a solution service provider provides a computer infrastructure operable to perform the method.

6. A system for converting database formats based on user data access patterns in a cloud computing environment, comprising:

a memory medium comprising instructions;

a bus coupled to the memory medium; and

a processor coupled to the bus that when executing the instructions causes the system to:

identify a first set of database tables based on a set of access patterns stored in a computer storage device, the first set of database tables having a first format, wherein the first format is a relational database format and the set of access patterns indicate at least one of: a set of user data queries, insertions, updates or deletions to data stored in the first set of database tables;

augment at least one table of the first set of database tables to generate a second set of database tables having a second format and stored in a cloud data repository, the second set of database tables being a set of de-normalized tables;

create a mapping between the first set of database tables and the second set of database tables;

generate a column set based on the at least one condition of the set of access patterns;

use the column set as a key for the second set of database tables; and

propagate at least one data operation to the second set of database tables based on the key.

7. The system of claim 6 , the first format being a relational database format, and the second format being a hash table format.

8. The system of claim 6 , wherein the propagating is further based on the mapping or the at least one condition.

9. The system of claim 6 , the at least one data operation being at least one of: a data query operation, a data update operation, a data deletion operation, or a data insertion operation.

10. A computer program product for converting database formats based on user data access patterns in a cloud computing environment, the computer program product comprising a computer readable hardware storage device, and program instructions stored on the computer readable hardware storage device, to:

identify a first set of database tables based on a set of access patterns stored in a computer storage device, the first set of database tables having a first format, wherein the first format is a relational database format and the set of access patterns indicate at least one of: a set of user data queries, insertions, updates or deletions to data stored in the first set of database tables;

augment at least one table of the first set of database tables to generate a second set of database tables having a second format and stored in a cloud data repository, the second set of database tables being a set of de-normalized tables;

create a mapping between the first set of database tables and the second set of database tables;

generate a column set based on the at least one condition of the set of access patterns;

use the column set as a key for the second set of database tables; and

propagate at least one data operation to the second set of database tables based on the key.

11. The computer program product of claim 10 , the first format being a relational database format, and the second format being a big table format.

12. The computer program product of claim 10 , the computer readable hardware storage device further comprising instructions to generate the set of de-normalized tables from the first set of database tables.

13. The computer program product of claim 10 , wherein the propagation is further based on the mapping or the at least one condition.