Creating Expert System for Database Application Development

 

In the year 2016, my friend show me he create a desktop application using Delphi that he create very fast. I think I cannot compete with him with that software development skill. I am thinking what if I create an expert system to help create desktop application for me. Then I create this application and name it Gampang Builder.

The design of Gampang Builder is very simple, it get input from the user about the application design and generate softwaer project for it, not a complete software but only:

1. Main form and main menu of the application.
2. Navigation system to access facilities in the application and limiting access by application user. 
3. Data service for create, edit and delete for entities and relations.
4. Editing form for the entites and relations.
5. Printable report for the entities.

 

When we create an application first we have to define the backgroud of the problem to solve and the target to be achieved by the application.

Then we choose the technology for the to be generated application.

To make our code more reusable I split the code into few modules.

In each module we can define the class name for the data service and access right than can be used to limit user access because not every user will have the same access level.

After we define the modules we can define the entities by the data table and relations between entities in the applications.

 

In the data tabel we can define field name, data type, its characteristic, and relation with other table such as look up or master-detail.

If we need the printed design for documentation, Gampang Builder can print it.

The last thing to do is generate the application but because this application is too old and many changes to the library change the package file reader, I will repair the code and update when it completed. I created a few application with this program, one of the application is a medical laboratory database application and is still running today from 2016. I dont have time yet to improve this program but maybe someday.

 That's all in this article, I hope it's usefull.