Whether a basic website or complex online applications such as CMS-based intranets, planning tools, websites and online shops – they all need a technical concept. CMS based websites especially, require prior database modeling, to do so, we first have to know which database system will be used.Performance and security for future online applications has to be of key importance.
The functionality, scope, performance and price-performance-ratio of online applications can all be weighted up and discussed – but on security there is no discussion and no concessions can be made. Possible databases include MySQL, PostgreSQL, OracleMS-SQL, etc. with MySQL databases being widely used, especially with a PHP programming and being technically proven.
After having decided on a database, modeling can now start. Generally, a database model can be designed by using various tools, e.g. MS Visio or Axure. In addition to the pure structure of the database tables, the various links between tables (normalization) and additional processes are illustrated.
After having structured the database, the database model can then be integrated into a technical programming concept and then developed further. Working closely with Web Developers is important here, especially to coordinate the functions to be programmed as well as the data storage within the database.
