Performance tuning
Distinct Software are highly experienced at identifying the root cause of poorly performing
database applciations. The greatest gains in performance come not from tweaking database
parameters, but from identifying why a particular database access is inefficient. Our experience
and knowledge means we can ask the right questions and look in the right places for the
cause of the problem.
Schema design
Application developers can define entities and attributes without difficulty, but expressing
these in a database schema requires consideration of the special operational and performance requirements
of a database.
Planning for the future is essential - a backup, fail-over and archive methodology may need to be
established, and the future growth of the data must be properly considered. Distinct software
have experience of working with systems that have been designed to run efficiently with 100 or 1000000
rows in a table and remain compatible with operational requirements.
Standards development
Developing and documenting standard methods for accessing the database and making changes
to the schema are essential for creating a reliable and maintainable application. Building
on experience of developing and working with effective procedures that provide effective
control without introducing unnecessary bureaucracy, Distinct Software can help introduce
processes and procedures which allow quality to be controlled.
Deployment process management
Deployment of an application database should be carefully controlled to ensure the optimium
effective execution of your application on the client's site, or in a live environment.
Distinct Software has experience of deployment of both new database schemas, and upgrades
into sizeable systems.
|
|