Generation of technical description of report from functional description of report

A computer-readable data storage medium storing a computer program executable by a processor of a computing device to perform a method comprising:

• extracting report keywords and relationships among the report keywords from a functional description of a report to be formulated and then run against a database containing data and stored on a data storage device, using an ontology related to the data contained in the database;
• performing a predetermined text mining algorithm in relation to the report keywords, the relationships among the report keywords, and a data dictionary of the database to profile the functional description of the report against the data dictionary, the data dictionary stored on the data storage device, performance of the predetermined text mining algorithm identifying particular tables and columns of the database that contain the data needed for the report;
• and
• generating a technical description of the report that includes the tables and the columns that have been identified, to facilitate formulation of the report.

A system comprising:

• a storage device to store a database containing data in relation to which a report is to be run after being formulated, and to store a data dictionary of the database;
• and
• a computing device storing and to execute computer-executable code comprising:
• first code to extract report keywords and relationships among the report keywords from the functional description of the report, using an ontology related to the data contained in the database;
• and
• second code to identify particular tables and columns of the database that contain the data needed for the report to generate a technical description of the report that includes the particular tables and columns that have been identified, to facilitate formulation of the report, by profiling the report keywords and the relationships among the report keywords that have been extracted against the data dictionary of the database.