Method and apparatus for dynamic database creation and interactive analysis

A method for creating a data model comprising:

• creating an attribute category in a database in response to a request by a user;
• displaying a data model schema with information associated with the attribute category;
• modifying the attribute category in the database in response to a request by the user;
• displaying the data model schema with information associated with the modified attribute category;
• moving the attribute category in the database to a new location within the data model in response to a request by the user;
• displaying the data model schema with information associated with the moved attribute category;
• deleting the attribute category in the database in response to a request by the user;
• displaying the data model schema with information associated with the deleted attribute category;
• creating an attribute super category in a database for aggregating attribute categories in response to a request by a user;
• and
• displaying a data model schema with information associated with the attribute super category.

An apparatus for performing a database query, comprising:

• a processing unit;
• and
• a storage medium coupled to the processing unit, the storage medium storing program code implemented by the processing unit for executing the database query comprising:
• requesting, from the data base, data base values for a first data category in response to a first selection by a user of the first data category;
• selecting an attribute value from among the data base values for the first data category;
• requesting, from the data base, data base values for a second data category in response to a second selection by a user of the second data category;
• storing the first selection and the second selection in the database;
• and
• requesting, from the data base and in response to a user request, the stored first selection, the stored second selection and the data base values associated with the first selection and the second selection.

An apparatus for performing data model creation, comprising:

• a processing unit;
• and
• a storage medium coupled to the processing unit, the storage medium storing program code implemented by the processing unit for executing creating the data model comprising:
• creating an attribute category in a database in response to a request by a user;
• displaying a data model schema with information associated with the attribute category;
• modifying the attribute category in the database in response to a request by the user;
• displaying the data model schema with information associated with the modified attribute category:
• moving the attribute category in the database to a new location within the data model in response to a request by the user;
• displaying the data model schema with information associated with the moved attribute category;
• deleting the attribute category in the database in response to a request by the user;
• displaying the data model schema with information associated with the deleted attribute category;
• creating an attribute super category in a database for aggregating attribute categories in response to a request by a user;
• and
• displaying a data model schema with information associated with the attribute super category.