Technology
- Technology developed for eKool to make superquick web information systems. Algorithms to minimise highly loaded webserver traffic with the database. The system core is Database session pooling. It keeps 5 sessions in use. It can make up to 500 sessions if needed. Algorithm to keep connections active and reduce connections if needed.
- The second algorithm core is writing an effective cache system to minimise database system load during hard use (1000 to 5000 concurrent users). There has been developed a cache system with 10 different algorithms which also interacts with clustered servers. Cluster servers exchange information of change table changes every 10-1000 ms, on which cache system can determine cache objects expiration.
- Correctly written cache system with a proper cluster system can result in reducing database load up to 1000 times.
- Programming effective and user-friendly systems in Windows. Used are Delphi 7 and the best utilities of following component manufacturers: PostgreDAC, ReportBuilder, DevExpress, JV Components, TMS Components.
- Digital document archiving in databases, PDF, JPG, BMP, DOC. Image editing and PDF generating on demand. Searching within documents.
- Writing the information system according to client's wishes, adding all paper documents into the database and alligating the system with other software such as accounting programs.
- Real-time systems in Delphi. Leading outside sensor and low-circuit systems. Using computer directed systems putting up burglar alarms, measuring speeds on track, leading analog and digital devices and reading data from different gauges.
- Database engine optimising. Analysis and tuning of different parameters on demand.
- Analysing and optimising different indexes used in database. A 10 step index restructing algorithm has been developed which analyses existent indexes, SQL-s created on some period of time. Based on the gotten information: restructing complex indexes, adding new indexes if needed, deleting useless indexes.
- Optimising procedures, views and SQL-s in database. Rewriting SQL writing logic considering costbase optimiser hints. Minimising the use of SQL functions. Excluding for-cycles in stored procedures where declarative SQL can be used.
- Solving data mining tasks with Oracle Analytics SQL. Some complicated and expensive data mining softwares are used where necessary functions and data analysis could be realised with Oracle Analytics SQL.