Method and device for database design and creation

1. A method of database design and creation, the method comprising:

determining, by a database creation device, 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, by the database creation device, each of the plurality of variables in a sequence of arrangement with respect to an associated database from the plurality of databases;

computing, by the database creation device, 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, by the database creation device, 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, by the database creation device, 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.

2. The method of claim 1 , wherein determining that a relationship exists comprise identifying a key across the plurality of databases.

3. The method of claim 2 , wherein creating the database comprises utilizing the key to extract content from the plurality of databases.

4. The method of claim 1 further comprising creating entity relationship models and extended entity relationship models based on the relationship determined using the correlation coefficient.

5. The method of claim 4 further comprising performing normalization of

the entity relationship models and the extended entity relationship models.

6. The method of claim 1 , further comprising determining when the correlation coefficient is equal to zero, that none of the plurality of variables across the plurality of databases are related.

7. 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.

8. The database creation device of claim 7 , wherein to determine that a relationship exists the processor instructions cause the processor to identify a key across the plurality of databases.

9. The database creation device of claim 8 , wherein to create the database the processor instructions further cause the processor to utilize the key to extract content from the plurality of databases.

10. The database creation device of claim 7 , wherein the processor instructions further cause the processor to create entity relationship models and extended entity relationship models based on the relationship determined using the correlation coefficient.

11. 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.