There is a number of development principles but we will focus on 5 main associated with the development.
Single Database
There is a tendency to use multiple databases in the organisation like Oracle, SQL Server, PostgreSQL and others. This becomes impossible to manage as we require a skill set for all of the databases. With small, medium or even large organisation it's not possible to maintain a multitude of databases. It is best to focus on one built expertise on it.
All the critical data static or dynamic should be stored on one centralized database and replicated or mirrored to various places to avoid a single point of failure.
Correct backup and replication policy must be maintained to ensure in case of failure or issues data can be retrieved with ease and in time.
Most tasks and developers are very keen to cache data. which leads to a number of issue in the distributed environment. If all apps try to have a local cache and persist at the same time. There may be race issues and last apps wins, which means other apps will lose cache changes and other apps when replicated will be in the indeterminate state.
Distributed caching is very complex requires due diligence and synchronization. One should avoid writing their own distributed cache and use or recommended from the vendor.
The care must be taken to read and write strategy, in some application, there are millions of reads but only 100s of writes. It will require some internal caching of SQL queries to avoid SQLQuery all the time and use the cached query.
One needs to see if the same query is multiple times with the different parameters then parametric query or a prepared statement with placeholder should be used, it will give you performance improvement and consistency.
Triggers are often used to audit and record usages of it. This is one of the culprits for performance. One must religiously check the impact the trigger and use with care.
Thereof number of techniques to isolate transaction. Which can lead to severe performance degradation, which in all circumstances should be avoided?
The number of database patterns exists and one must see how optimistic locking works and make use of it.
The database is very complex subject SQL and NOSQL both have their advantage and disadvantage. One must explore both for their merit and choose the correct one for development.
One of the development principles is that it must meet the business requirement. ANy chosen database must be very close to the business for effectiveness.
Please visit Business Integration Software to see various products using development principles.
Assessment Management Software
Multiple Choice Question Software
