Patent ID: 8122340
Filing Date: 2012-02-21
Classification: G06F

Abstract:
1. A system for management of common decentralized applications data and logic comprising: a file-system repository that lists each file of interest and describes design and intent information for each at least one spreadsheet and at least one desktop/departmental database hosted in an enterprise network comprising one or more computers; a spreadsheet meta-model repository configured to hold meta-data for each of the at least one spreadsheet; a database meta-model repository configured to hold meta-data for each of the at least one desktop/departmental database; a simplified enterprise application repository configured to store descriptions of simple enterprise applications; an enterprise development repository configured to hold enterprise database meta-data; said file-system repository, said spreadsheet meta-model repository, said database meta-model repository, said simplified enterprise application repository and said enterprise development repository configured to execute on at least one computer configured to be coupled with said enterprise network; a repository application configured to manage at least the file-system repository and simplified enterprise application repository; a crawler module configured to search directories on said enterprise network for new, changed and deleted/erased files of interest and keep the file-system repository complete and up to date; a spreadsheet analyzer module configured to obtain new, changed or erased spreadsheets from the crawler module and read semantic details from the spreadsheets and store changes into the spreadsheet meta-model repository; a spreadsheet synthesis module configured to analyze on demand a spreadsheet in the spreadsheet meta-model repository and restate each spreadsheet as a simple enterprise application in the simplified enterprise application repository; a database analyzer module configured to obtain new, changed or erased databases from the crawler module and read semantic details from the databases and store changes into the database meta-model repository; a database synthesis module configured to analyze on demand a desktop/departmental database in the database meta-model repository and restate each desktop/departmental database as a simple enterprise application in the simplified enterprise application repository; an email module configured to send an email to a file owner and query the file owner about the at least one spreadsheet and/or at least one desktop/departmental database purpose and store an answer to the query in the file-system repository; an enterprise database upload module configured to read the enterprise development database and store the enterprise database meta-data in the simplified enterprise application repository; an enterprise application generator module configured to generate, in at least one development technology stack, well-programmed enterprise relational databases and applications in the enterprise development repository based on descriptions of the simple enterprise applications in the simplified enterprise application repository; and, wherein said repository application, said crawler module, said spreadsheet analyzer module, said spreadsheet synthesis module, said database analyzer module, said database synthesis module, said email module, said enterprise database upload module and said enterprise application generator module are configured to execute on the at least one computer configured to be coupled with said enterprise network.