CLIAMS:We claim
1. A method for optimized implementation of a data warehouse on a cloud network, the method comprising:
receiving, by a processor of a cloud integrated data warehousing (CIDW) system, data from at least one data source;
processing, by the processor, the data to obtain structured data;
encrypting, by the processor, the structured data stored in the CIDW system;
decrypting, by the processor, load data, from amongst the structured data, to be loaded into a database;
loading, by the processor, the load data into the database through one of an extract transform load (ETL) process and an extract load transform (ELT) process; and
generating, by the processor, reports comprising encrypted load information for end users.

2. The method as claimed in claim 1 further comprises providing an encryption key to authorized end users to decrypt the encrypted load information in the reports.

3. The method as claimed in claim 1, wherein the at least one data source comprises structured data sources and unstructured data sources.

4. The method as claimed in claim 1, wherein processing the data further comprises converting unstructured data, received from unstructured data sources, into structured data.

5. The method as claimed in claim 1, wherein loading the load data further comprises identifying, by a master server, one of the ETL process and the ELT process to be performed.

6. The method as claimed in claim 5 further comprises performing the ETL process by an ETL server.

7. The method as claimed in claim 5 further comprises performing the ELT process by a database slave server.

8. A cloud integrated data warehousing (CIDW) system for optimized implementation of a data warehouse on a cloud network, comprising:
one or more processors;
a computer-readable medium storing instructions that, when executed by the one or more processors, cause the one or more processors to perform operations comprising:
receiving data from at least one data source;
processing the data to obtain structured data;
encrypting the structured data stored in the data warehouse;
decrypting load data, from amongst the structured data, to be loaded into a database;
loading the load data into the database through one of an extract transform load (ETL) process and an extract load transform (ELT) process; and
generating reports comprising encrypted load information for end users.

9. The CIDW system as claimed in claim 8, wherein the processor is further configured to provide an encryption key to authorized end users to decrypt the encrypted load information in the reports..

10. The CIDW system as claimed in claim 8, wherein the at least one data source comprises structured data sources and unstructured data sources.

11. The CIDW system as claimed in claim 8, wherein processing the data further comprises converting unstructured data, received from unstructured data sources, into structured data.

12. The CIDW system as claimed in claim 8, wherein loading the load data further comprises identifying, by a master server, one of the ETL process and the ELT process to be performed.

13. The CIDW system as claimed in claim 11, wherein operations further comprise performing the ETL process by an ETL server.

14. The CIDW system as claimed in claim 11, wherein operations further comprise performing the ELT process by a database slave server.

15. A non-transitory computer-readable medium storing instructions for optimized implementation of a data warehouse on a cloud network, wherein upon execution of the instructions by one or more processors, the processors perform operations comprising:
receiving data from at least one data source;
processing the data to obtain structured data;
encrypting the structured data stored in the CIDW system;
decrypting load data, from amongst the structured data, to be loaded into a database;
loading the load data into the database through one of an extract transform load (ETL) process and an extract load transform (ELT) process; and
generating reports comprising encrypted load information for end users.

Dated this 8th day of May, 2015

Shwetha A Chimalgi
Of K&S Partners
Agent for the Applicant
,TagSPECI:TECHNICAL FIELD
This disclosure relates generally to data warehouse systems and more particularly to systems and methods for optimized implementation of a data warehouse on a cloud network.