Method and device for database design and creation

A database creation device for database design and creation, the database creation device comprising:

• a processor;
• and
• a memory communicatively coupled to the processor, wherein the memory stores processor instructions, which, on execution, causes the processor to:
• determine ranks for each of a plurality of variables in each of a plurality of databases based on at least one attribute associated with each of the plurality of variables;
• arrange each of the plurality of variables in a sequence of arrangement with respect to an associated database from the plurality of databases;
• compute a correlation coefficient between the plurality of variables across the plurality of databases based on the ranks and the sequence of arrangement, wherein computing the correlation coefficient comprises identifying difference between the ranks for each of the plurality of variables across the plurality of databases, when the plurality of variables of a database is arranged in a same sequence of arrangement as the plurality of variables in another database, wherein the correlation coefficient measures the strength of association between two variables;
• while the correlation coefficient is less than zero:
• iteratively perform the arranging and the computing until the correlation coefficient is equal to or greater than zero;
• determine when the correlation coefficient is positive, that a relationship exists between one or more of the plurality of variables across the plurality of databases;
• and
• create a database using the plurality of databases based on the relationship, when the relationship exists between the one or more of the plurality of variables.

A non-transitory computer-readable storage medium having stored thereon, a set of computer-executable instructions causing a computer comprising one or more processors to perform steps comprising:

• determining ranks for each of a plurality of variables in each of a plurality of databases based on at least one attribute associated with each of the plurality of variables;
• arranging each of the plurality of variables in a sequence of arrangement with respect to an associated database from the plurality of databases;
• computing a correlation coefficient between the plurality of variables across the plurality of databases based on the ranks and the sequence of arrangement, wherein computing the correlation coefficient comprises identifying difference between the ranks for each of the plurality of variables across the plurality of databases, when the plurality of variables of a database is arranged in a same sequence of arrangement as the plurality of variables in another database, wherein the correlation coefficient measures the strength of association between two variables;
• while the correlation coefficient is less than zero:
• iteratively performing the arranging and the computing until the correlation coefficient is equal to or greater than zero;
• determining, when the correlation coefficient is positive, that a relationship exists between one or more of the plurality of variables across the plurality of databases;
• and
• creating a database using the plurality of databases based on the relationship, when the relationship exists between the one or more of the plurality of variables.