IQTek software believes that, no commercial enterprises application can
be designed & implemented properly without knowing the database.
We have worked extensively on PL/SQL (oracle 8i to 10g) &
T-SQL (Microsoft SQL server 2000 to 2005, Sybase SQL server).
We have delivered complete ERP size application, having full
business layer code at backend. This sets up apart from the other .net & java
developers, for whom database is just a connection where they can execute SQLs.
Our method of working is recommended practice by all database vendors & has
following advantages :-
| Customer Advantage |
|---|
| 1. | Code inside the database can be easily tuned for performance |
| 2. | Easy maintenance, where even person without technical knowledge can understand
the logical flow of the system. |
| 3. | Easy deployment, where compilation of stored procedure code
leads to change in all connected clients |
| 4. | Less experienced programmers, without domain knowledge,
do not touch database code & hence leads to application reliability. |
| 5. | Building scalable application in terms of database load, we have implemented a
solution having 8 million rows in transaction table, which performs without
any outage for 40 connect users at a time. |
| 6. | Suitability in WAN environment, where code inside the database cuts down
on network traffic between client & server |
| 7. | Scalable in terms of number of users |