we need that all this need to be somehow generated dynamically by the admin user of the application who will have the capability to iinput all the details (formulas, calulations) etc by himself. Also how
could we achive the db design for this approach.
What type of architecture is best suitable for such a requirement where the screen itself can be added by the admin user of the aplication . The biggest challenge i think to how do we create such screens dynamically using some meta data approach and how do we represent such data
Each screen denotes one table is not a good idea, but it is a time-saving idea.
The db design solution depends on much more investigation from business level.
And important part is DB designing is the first step to do this task.
Joined: Jul 05, 2005
yooon chin wrote:Each screen denotes one table is not a good idea, but it is a time-saving idea.
In most applications it's not a good idea, but in specific area of applications it's good. For example, DBMS front-end applications can generate screen to edit data dynamically based on the table schema. It's all right because the users of the application are technical users.
But for an application that its users don't have technical perspective doing this might save time at first, but it'll consume more time later in struggling to make the UI richer or make some screens differ from other screens. UI generator is best if all screens look the same, but if each screen can be different it would be difficult to make the UI generator flexible enough and the code will be much more complicated that it's needed to be.