Tuesday, October 13, 2009

Programming in PL/SQL and Java

For those of you who have worked with the TIA Solution in more details, you know that the programming language PL/SQL for many years has been a central tool in the making of it. This is the language our business logic is written in, and it continues to serve us well in terms of features, performance and productivity.
Sometimes we meet people who are not used to the Oracle technology stack including the PL/SQL language. A few of those find it intriguing that TIA relies on a language “invented” many years ago. What we usually do is to explain the benefits of PL/SQL which we believe by far outweigh the drawbacks. Usually PL/SQL is being compared to slightly newer languages like Java or C#. The benefit to TIA Technology by writing business logic in PL/SQL is centered on productivity and performance. The TIA solution is an extremely feature rich integrated solution capabæe of supporting thousands of users, where most of the business benefits are based upon data access and manipulation of the data. As such the TIA solution is a traditional database heavy solution with less emphasis on advanced graphical user interfaces. Furthermore, we have deliberately made a choice only to utilize the Oracle database. Because of this we can utilize PL/SQL with all of its most advanced features inside the Oracle database to quickly get to the most optimal and best performing business logic with the least effort for the developers. We basically do not have to write any “plumbing” code to get the desired results in terms of updating the database. Compared to Java and C#, these languages do not have any elegant built-in runtime support for accessing a database. SQL statements have to be embedded in the code as textual strings and there is usually a lot of plumbing code which has to be written and maintained when writing business logic. And since TIA does not have to deal with the complexity of being database agnostic there is really no gain – just pain, should we choose to write business logic in Java instead of PL/SQL.


More information on PL/SQL can be found through Wikipedia (http://en.wikipedia.org/wiki/PL/SQL). If anyone has a deeper interest in why PL/SQL is a good choice for an Oracle application like the TIA Solution, please check out http://www.developer.com/db/article.php/3308841/Sample-Chapter-Efficient-PLSQL.htm .


Now, the fact that most of the business logic resides inside the Oracle database and is written in PL/SQL does not mean that Java is out of the question. On the contrary, Java plays an increasingly important role for the TIA solution as a programming language. We have merely decided that we want to use Java where it is best, which we believe is for creating middle-tier components and user interface. To that end, TIA began the journey into Java land a few years ago, when programming for version 6.0 started. With the 6.0 release in March, the first real Java components were released, enabling TIA to fit into a modern service oriented architecture. We are now in the middle of releasing all of the services forming our service catalogue and of course Java plays a key role in that. This also means that our partners will have to look to Java to build up skills. Having Java knowledge and specifically experience with the Oracle SOA suite will become an important aspect of working with the TIA Solution in the future. And that will be amplified when we are gradually moving into utilizing the Oracle Application Development Framework to design and build the TIA solution.

We believe that it is wise for everybody to choose the optimal tool to get the work done. Do not use a hammer to drive in a screw.

When making the world’s best general insurance solution, we believe the right choice is PL/SQL for business logic and Java for the rest.

Friday, April 24, 2009

Version 6.0 released on March 31st!

As planned, we released the TIA solution version 6.0 on March 31st 2009. The software and other deliverables are ready for download through www.tia.dk for customers and partners.

This represents a significant milestone for us at TIA Technology and a leap ahead in terms of the Service Oriented Architecture we are introducing with version 6.

With the new release and subsequent releases 6.1 and 6.2, customers will benefit from a modern service oriented architecture which fit into a service infrastructure in order to simplify integration and customization of the TIA solution.

This will in turn lead to reduced cost for customers who want to plug TIA into an existing IT infrastructure and at the same time significantly reduce the time to market for new P & C business initiatives and products.

At TIA we are continuing to evolve the solution with new planned features for version 6.1 and 6.2 as well as the delivery of the entire service catalog, which is documented and described in detail with release of version 6.0.

At our upcoming customer seminar in Copenhagen, May 28-29, we will be presenting version 6.0 together with key messages about the future roadmap and plans. Included in that is several keynotes with focus on our customers and how they can expand through increased effectiveness and how we at TIA are dedicated to continued predicatability in or market offerings whilst maintaining agility to deliver immediate value in the current market conditions.

See you at the International User Group meeting, Copenhagen May 2009.

Wednesday, February 11, 2009

Version 6.0 progress report

With my first blogpost in 2009 I would like to send greetings to all my readers from a currently snow covered Copenhagen, Denmark. It's been a while since my last post, which primarily is caused by the fact that we are busy with the final stages of the upcoming version 6.0 as well as exciting new customer opportunities.

Currently the development team  at TIA is in the stabilization phase of version 6.0 which means we are system and integration testing the new features and the SOA arhitecture and completing the upcoming service catalog. We have completed the first test pass with succes and is currently fixing the remaining bugs found during this. Subsequently new test passes are planned before release currently slated for end of march.

Version 6.0 introduces a new Service Oriented Architecture as well as numerous application enhancements and features including a new module for complaints management. We are looking forward to presenting this and much more at our international user group conference - this time to be held in Copenhagen in May. 

In parallel with finalizing the new release, we have begun the envisioning phase for what comes next. With that, we are encouraging our customers and partners to provide feedback and ideas for new features, modules, enhancements etc. Let us know what you belive it's important we focus on through www.tia.dk, comment to my blog, by phone or mail.