IT Employment

General discussion


Enterprise application development tools

By guru ·

I am interested to find out what type of development tools are used by enterprise application development vendors to make the application work with different databases. Native code for the database would be the stored procedures to get the best performance with most databases. We can argue that it is not possible to get the kind of performance that you get out of stored procedures using conventional languages like Cobol or C or VB. However stored procedures are native to the database andrequire maintenance of different code base for each database separately even if you use ANSI set. Would appreciate if some one can throw some light on this issue.
I have seen Lawson software using CASE tool (COBOL based), JD Edwards using C for their development. My question is
1. "Is it possible to write an enterprise application that handles huge amount of data with conventional languages instead of using database procedures".
2. Need some examples to prove the point.

- Guru

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Enterprise application development tools

by Joe Kowalski In reply to Enterprise application de ...

Question: Define ?huge?. ?

I have no information on the specifics of your project however there are three methods I can think of which are typically employed.

The first depends on your definition of ?huge?. The real question here is why. Business needs will drive this answer. If you can develop software architecture where data is pushed or pulled on demand, then standard enterprise development tools should be fine, even up to displaying a few thousand records. While it is true that stored procedures can increases your query efficacy up to 25% (this is doe due to fact that stored procedures are cached in memory and route the best path) in the old days, stored procedures where problematic, being single threaded. Data was typically loaded when the user requests it, not before.

These systems however usually ran all their application processing on the server. Enter the second method, server side components. If the data needs to be processed prior to displaying or sending to thedatabase, or you have a large amount of activity (memory use) it may be beneficial to create a set of server side components which handle this and place them on an application server. Again standard enterprise development tools would be perfect.

If neither of these methods fits the business need and you have a qualified developer, then you may consider dynamic stored procedure creation. Basically the developer would create a piece of code which would poll database information and dynamicallycreate the necessary stored procedures on installation or configuration. If the method is implemented correctly, this would not only give you the necessary performance gain but would also increase scalability. Essentiality you could add any databasewhich conforms or your communication method with minimal or no coding changes.

Hope this helps.

Collapse -

Enterprise application development tools

by guru In reply to Enterprise application de ...

Poster rated this answer

Related Discussions

Related Forums