CLIAMS:We claim:
1. A method for optimizing storage of multi-dimensional data in a data storage, said method comprising:
analyzing, by an optimization system, a plurality of queries received over a period of time from one or more client machines;
determining, by the optimization system, a query pattern from the plurality of queries;
identifying, by the optimization system, dimensionality of data based on the query pattern for determining data storage strategy, wherein the dimensionality is characterized into 11 dimensions comprising 4 standard level dimensions and 7 higher level dimensions; and
performing, based on determined storage strategy, by the optimization system at least one of:
segmenting at least one of the data and columns of a table stored in the data storage based on the identified dimensionality of data;
storing the data in remote data storage when the data is an element of a last higher level dimension; and
fragmenting the higher level dimensions into one or more smaller level dimensions when the data is an element greater than the 11dimensions, wherein at least one of the analyzing, the determining, and the identifying, and performing is performed by a processor.

2. The method as claimed in claim 1, wherein the plurality of queries is at least one of a Structured Query Language (SQL) based queries and Not Only Structured Query Language (NoSQL) based queries.

3. The method as claimed in claim 1, wherein the query pattern from the plurality of queries is determined by parameters selected from a group comprising, type of queries, location from where the queries are initiated, time at which queries are received, frequency of the queries, correlation between the columns of the queries, correlation between the constraints of the queries, volume of data retrieved on each of the queries, frequency of data usage, complexity of the join queries, keys used in the queries and dataset retrieved from demography of the queries.

4. The method as claimed in claim 1 further comprising combining the columns of one or more tables into a table upon determining correlation between columns of the one or more tables of the data storage based on the query pattern.

5. The method as claimed in claim 1 further comprising storing metadata of the data, the table, and the dimensionality of the data in a master table.

6. The method as claimed in claim 1 further comprising providing alerts based on at least one of failure of the optimization system and the at least one secondary optimization system, syntax error in defining the queries, unavailability of space for storing the data, unavailable of data for the query and increase of query volume more than a predefined volume.

7. The method as claimed in claim 1 further comprising archiving the data based on a lifespan of the data, wherein the lifespan of the data is determined from the query pattern.

8. An optimization system for optimizing storage of multi-dimensional data in a data storage, said optimization system comprising:
a processor;
a memory communicatively coupled to the processor, wherein the memory stores processor-executable instructions, which, on execution, cause the processor to:
analyze a plurality of queries received over a period of time from one or more client machines communicatively connected to the optimization system over a network;
determine a query pattern from the plurality of queries;
identify dimensionality of data based on the query pattern for determining data storage strategy, wherein the dimensionality is characterized into 11 dimensions comprising 4 standard level dimensions and 7 higher level dimensions; and
perform, based on determined storage strategy, at least one of:
segment at least one of the data and columns of a table stored in the data storage based on the identified dimensionality of data;
store the data in remote data storage when the data is an element of a last higher level dimension; and
fragment the higher level dimensions into one or more smaller level dimensions when the data is an element greater than the 11dimensions.

9. The optimization system as claimed in claim 8, wherein the data storage is selected from at least one of Structured Query Language (SQL) database and Not Only Structured Query Language (NoSQL) database.

10. The optimization system as claimed in claim 8, wherein the memory comprises a master table to store metadata of the data, the table, and the dimensionality of the data.

11. The optimization system as claimed in claim 8 comprises one or more alerting units to provide alerts based on at least one of failure of the optimization system and at least one secondary optimization, syntax error in defining the queries, unavailability of space for storing the data, unavailable of data for the query and increase of query volume more than a predefined volume.

12. A non-transitory computer readable medium including instructions stored thereon that when processed by a processor cause an optimization system to perform acts of:
analyzing a plurality of queries received over a period of time from one or more client machines;
determining a query pattern from the plurality of queries;
identifying dimensionality of data based on the query pattern for determining data storage strategy, wherein the dimensionality is characterized into 11 dimensions comprising 4 standard level dimensions and 7 higher level dimensions; and
performing, based on determined storage strategy, at least one of:
segmenting at least one of the data and columns of a table stored in the data storage based on the identified dimensionality of data;
storing the data in remote data storage when the data is an element of a last higher level dimension; and
fragmenting the higher level dimensions into one or more smaller level dimensions when the data is an element greater than the 11dimensions.

Dated this 18th day of April, 2014

SHWETHA A CHIMALGI
OF K & S PARTNERS
AGENT FOR THE APPLICANT
,TagSPECI:TECHNICAL FIELD
The present subject matter is related, in general to multidimensional data storage and more particularly, but not exclusively to a method and an optimization system for optimizing storage of multidimensional data in data storage.