tag:blogger.com,1999:blog-126093372024-03-18T13:10:56.595+08:00Umesh Kakkad's BlogUmesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.comBlogger53125tag:blogger.com,1999:blog-12609337.post-30734498470712972052007-05-20T16:53:00.000+08:002007-05-20T16:54:29.247+08:00Jaiku.comWas following thru some of the post at <a title="http://tardate.blogspot.com/" href="http://tardate.blogspot.com/">Paul's blog</a> and came to know of <a title="Jaiku.com" href="http://jaiku.com/">Jaiku.com</a>. Looks like a cool conecpt to link all your online activities (blogs, forums, bookmarkts, photos) to one-stop page which your friends can follow to know what you upto. To top this you can put quick notes (mini blog entries) directly into the Jaiku (similar to http://twitter.com/. It took me time to digout the link 5 mins ;). You kindda forget the names of cool new webservices you read about and tried a bit but don't use it then on.). I have put up my jaiku page here http://ukakkad.jaiku.com/ linked to my blog and deli.cio.us. Forums, guess I need to use the nifty script <a title="from Paul" href="http://tardate.blogspot.com/2007/05/getting-your-oracle-forum-posts-as-rss.html">from Paul</a> to pull my forum posts on OTN if I do some. I hardly manage to go thru the feeds of OWB and OLAP forum's and post some replies.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com4tag:blogger.com,1999:blog-12609337.post-65808990890829693312007-05-06T13:44:00.000+08:002007-05-06T13:48:43.564+08:00Neat...Ran in to Laurent Schneider's blog at <a style="font-size: 8.88889px;" title="http://laurentschneider.com/" href="http://laurentschneider.com/">http://laurentschneider.com/</a> and found tons of nifty neat tricks. One of <a style="font-size: 8.88889px;" title="this" href="http://laurentschneider.com/wordpress/2007/04/how-do-i-store-the-counts-of-all-tables.html">this</a> using dbms_xml package neatly to achive things like getting the number of rows in all the tables in a schema. And <a style="font-size: 8.88889px;" title="this" href="http://laurentschneider.com/wordpress/2007/05/csv-format-with-select.html">this</a> which neatly throws out a table in a csv file without needing much due.. Just a sql, xmlsequence (a table function) and reg exp. Quite neat. There were few more good post of what I scanned thru, like <a style="font-size: 8.88889px;" title="this one" href="http://laurentschneider.com/wordpress/2007/04/updatable-views-and-instead-of-triggers.html">this one</a> talking about a modelling technique of abstracting all the common attributes across the entities under one table/view and <a style="font-size: 8.88889px;" title="this" href="http://laurentschneider.com/wordpress/2007/05/vsql-and-bind-variable.html">this</a> which has a neat way to extract the sql with the values for bind variables. Its always great to pick up good handy tricks from the folks around and apply them in the day-to-day work. And there are many which are becoming accessible thru things like blogs, forums and all this web 2.0 phenomenon.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com2tag:blogger.com,1999:blog-12609337.post-53320921439096001492007-04-21T14:24:00.000+08:002007-04-22T11:43:15.267+08:00Hard-coding vs Soft-coding and Misc<p class="MsoNormal"> </p><p></p><br />Stumble up on <a title="this" href="http://worsethanfailure.com/Articles/Soft_Coding.aspx">this</a>. Talks about hard-coding vs soft-ccoding, rules engines, config files and all that. Even I have got into few of the assignments which leads to similar decisions. It does stimulate ones software engineering senses. Are Enterprise Rule Engines (aka Business Rule Engines) really have a fit in every enterprise applications. Or Languages like Java, C++ are the Business rules languages and their compilers are the very engines we are talking about.<p></p><br /><p class="MsoNormal">Agile software and likes are mantra of the day. Everything needs to be decoupled. SOA (Service Oriented Architectures) is driving it in some form. But whats' the optima? Where's the nirvana? Does too much of agility leads to fragility? Too much of integration points makes it slow or increases the chances of failures? Does all this still needs time to get mature enough and weed out hype and husk? Business is changing in the lightning speed and so should the IT systems. And what makes it happen is IN.<br /></p><p class="MsoNormal"><br /></p><p class="MsoNormal">All the above and the ones following are some of my random thoughts. Some think-food. I dont' advocate anything. There are some architectures which fits better than other in particular situation. Everything has a reference, everything has a context. This post does not have one though ;).<br /></p><br /><p class="MsoNormal">Configuration files vs UI's to configures business rules/parameters vs Hard Coding in the source code vs Rule Engines vs.. Ain't hardcoding same as config files.. just the protocol changes or the environment where you plumb them changes or DEPLOYMENT changes. And ain't config files are nightmare to maintain as article says when you have piles of such kind. Isn't it better to keep them in the source code? Probably its not. High time to bring in Open source here... You get the source of MySql..change it to suit your needs.. you don't need my.cfg file to change the MySQL engine. Get into code.. and change. <span style="">Grueling ?</span>.. Works? You need the whole set of libraries, compilers at your disposal and sound knowledge of the source tree to do that. This I guess is the other extreme. We don't want that.. We want other wise.. Everything decoupled.. all the parameters are open for one to configure ..and in very friendly manner.. With out much effort.. without much implications.. Easy to maintain..Easy to Extend..<br /></p><p class="MsoNormal"><br /></p><p class="MsoNormal">I am mixing system parameters with business rules/business logic (which the original post talks about). But to some extent they are part of same breed.. We have gone through many iterations of software development methodologies.. we talked about OOP, then AOP .. Component Oriented programming, Container Programming and what not. The mantra that time was "Just focus on business logic..". Now even that we are moving out to rule engines which business Analysts or Users can modify and maintain.. So what will be there for developer? Just to dvelop the glue between DAO (Data Acess Objects), Rule engines, other or even that would come from Application containers. A couple of years back there was talks about modeling the software rather than coding. Specially the Business Apps.. It seems that we have climbed the ladder from Assembly programming, C, Java, Workflow, business process management and modelling tools, etc. Isn't this the high time to sit down and think about all this and really decide on what fits for what needs?<br /></p><p class="MsoNormal"><br /></p><p class="MsoNormal">All these configs, system parameters, rules are at different level in the software. If we ramify them in proper way the better of we are in taking a decision on where they should go. Some are meant to control the system parameters (server IP, memory parameters etc.) Typically all this goes to a config file or System Config UI. There are things which are to do with Applications. Good example of this is the tons of setups which goes in implementing ERP modules like GL, Inventory etc. Things like Currency Type, Conversion rules in GL and Costing Type (Average or Standard) in Inventory are very application specific. On top of systems and application configs are the Rules which should govern business process or some decision in the business process flows. Probably all this needs to go into Rule engines. Is it so trivial to decide all this?<br /></p><p class="MsoNormal"><br /></p>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.comtag:blogger.com,1999:blog-12609337.post-9537039041924547342007-04-06T17:19:00.000+08:002007-04-06T17:20:32.572+08:00Random thoughts and some Oracle E-Business suite learnings<p class="western" style="margin-bottom: 0in;"></p><p class="western" style="margin-bottom: 0in;">Chilling out on this Friday afternoon of Singapore. A bright sunny day. Weather has been so for last few weeks with some shower now and then. Guess the Easter long weekend has come at the right time for me. Its been long I have catch up with whats happening around and the feeds from my favorite blogs. Its even longer I have posted last on this space.</p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;">Last few months were busy at social front. At work its usual stuff. Though I have started with new project since last few weeks and things are getting busier.</p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;">Off late I have been doing assignments in Oracle Applications aka E-Business Suite(mainly in the capacity of technical consultant) and it has been a rich experience. Though I have been working with Oracle Apps for some time, it was more with the perspective of extracting data for reporting and data warehouse applications. But This time it involved working head on with some of the core modules of E-Business suite including OM, Inventory, Financials etc. Technology has always fascinated me and tech stack of Oracle Apps was no exception. Lot of interesting learnings.</p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;">ERP are huge apps with so much to explore in terms of functionality, business process, technology components, software architecture and organization dynamics. Working in implementation project Oracle Apps really brings you close to all this aspects. I do prepare some random notes of the interesting things I come across about any software product. Some of the key things I discovered/learned about E-Business suite in the last few months of engagements:</p> <ul> <li><p class="western" style="margin-bottom: 0in;">Ad-Utilities for managing middle tier components. </p> </li><li><p class="western" style="margin-bottom: 0in;">Integrated data model. Example: there’s one entity hosting customer data which is referred by all the module ranging from Customer Management, Order Management, Advance Shipping</p> </li><li><p class="western" style="margin-bottom: 0in;">Open Interface tables to flow in or out the transactions from one module to other. The same interfaced tables could be used to bring the data from other not E-Business suite systems</p> </li><li><p class="western" style="margin-bottom: 0in;">APIs corresponding to virtually all the online functionality. The is key for any ERP application. Integration needs always requires creating master data and transactions from the scripts or programs. APIs make this simpler to approach since it will be impossible for any way to go and update all the underlying base entities without breaking the integrity. APIs have always been powerful since they centralize the business logic and all sort of integrity checks at one place. I will stop on API here. Every one knows about the advantage reusability, modularity, refactoring, OO and other core aspects of software designing.</p> </li><li><p class="western" style="margin-bottom: 0in;">Approaching integration with third party applications. This really requires proper planning for developing the custom scripts, testing and rolling out the customization. </p> </li><li><p class="western" style="margin-bottom: 0in;">Consistent UI. Consistent usability and user interactivity. </p> </li><li><p class="western" style="margin-bottom: 0in;">Power of Concurrent request manager. </p> </li><li><p class="western" style="margin-bottom: 0in;">I came to learn about CUSTOM.pll, which allows in non-invasive manner you put the custom hooks in the standard forms. </p> </li><li><p class="western" style="margin-bottom: 0in;">There were lots of learning on how to go abound customizing E-Business suite apps. CUSTOM.pll, database triggers, modifying standard reports (though not recommended), defining custom Application, DFF and KFF, lookups etc.</p> </li><li><p class="western" style="margin-bottom: 0in;">Coding standards. E-Business suite taught me some of the nifty coding practices. </p> </li><li><p class="western" style="margin-bottom: 0in;">One of the big learning was the philosophy and thinking that goes behind designing and developing packaged applications. The E-Business suite apps are perfect for business needs across industries and wide range of business requirements from different organization. This is achieved by the flexibility, setups and configurations provided by E-Business suite applications. On top of theses, there are avenues to do additional customization to achieve very specific business need. Sometime back I did <span style="color:#0000ff;"><u><a href="http://umeshkakkad.blogspot.com/2006_10_01_archive.html#115967646536666409">post</a></u></span> on how the development of software product differs from the custom solution, but Oracle E-Business Suite holds a special place. Lot of expertise, effort, planning and experience goes in developing products like E-Business suite.</p> </li></ul> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;">There were many more though. E-Business Suite is huge and the above list in no way wants to undermine the complete set of functionality that it offers. These are just my personal learnings. One should check out E-Business suite Documentation to appreciate the sheer size and richness of E-Business suite applications at <span style="color:#0000ff;"><u><a href="http://www.oracle.com/technology/documentation/applications.html">http://www.oracle.com/technology/documentation/applications.html</a></u></span>. In process I also came across few of the blogs on E-Business suite including Oracle’s Steven Chan’s blog on <span style="color:#0000ff;"><u><a href="http://blogs.oracle.com/schan/">E-Business suite technology</a></u></span>, Chris Muir’s <span style="color:#0000ff;"><u><a href="http://one-size-doesnt-fit-all.blogspot.com/index.html">One Size doesn’t fit all</a></u></span> and many more.</p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;"><br /></p> <p class="western" style="margin-bottom: 0in;"><br /></p>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com2tag:blogger.com,1999:blog-12609337.post-64556697187367426582007-01-26T18:38:00.000+08:002007-01-26T18:39:05.876+08:00Good Blogs on Oracle technologies<p class="MsoNormal">Came across a very good weblog on Oracle and Java technologies at http://www.it-eye.nl/weblog/. The blog entries are contributed by the consultants of IT-eye, an IT services company based out of Netherlands.</p> <p class="MsoNormal"><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></p> <p class="MsoNormal">They seem to be covering quite a number of Oracle technologies ranging from BI, SOA Suite, JDeveloper, Database, and others. Some of the posts on OWB had really good practical insights and <a href="http://www.it-eye.nl/weblog/2006/04/13/ombplus-create-tables-based-on-source-tables/">this</a> one gives a handy OMB script for creating tables in target module corresponding to every source tables. Probably the script could be extended to create a default mapping to load the data from source to target tables. </p> <p class="MsoNormal"><!--[if !supportEmptyParas]--> <!--[endif]--><o:p></o:p></p> <p class="MsoNormal">One more blog, again from the Netherlands, which I have been following for quite some time now is <a href="http://technology.amis.nl/blog/">http://technology.amis.nl/blog/</a>. The folks here share great project experiences on using Oracle technology and Applications offerings. Apart from Oracle technologies, there are often posts on projects executed using Oracle and open source technologies specially those related to Java. </p>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com6tag:blogger.com,1999:blog-12609337.post-1165120838483268232006-12-03T12:40:00.000+08:002006-12-03T12:40:38.540+08:00Good One..Stumble upon <a href="http://www.boreme.com/boreme/funny-2006/principle-90-10-p1.php">this</a> while browsing through the feeds from <a href="http://tkyte.blogspot.com/">Tom Kyte’s</a> blog. The post presents a very good principle of 90-10, on why we just have 10 percent control on our life and 90 percent is just the reaction of what’s happening to us. Depending on how we react on a situation decides how the 90 percent of our days going to be. I have tried to practice restraint while reacting on a situation, all that consciously for last many years. One needs to be restraint before reacting or over reacting on any situation. If something has happened, it has happened. You don’t have any control on reversing it or undoing it. All you can control is how you are going to react on it. If you’re fired, you missed a whole big scenario while programming some module and realized it only after the system is closing to UAT completion, you went overboard criticizing a proposal put forward by your colleague in a team meeting without thinking through all the benefits it might have, and accidentally a coffee cup knocked off on your new cloths by your colleague or even an oversight from you self. All this is bound to happen however careful you are. All you have control on is how you react and move forward from there. Just take things at ease and think in lines of how to mend what has happened without bothering yourself much on what has already happened. For those who find it difficult at first, things do get easy and into your sub-conscious as you move along. Like all the things you want to achieve, even this requires commitment and a streak of conscious attempts to practice this for some time before it gets in your blood.<br/><br/>I value the thoughts put forward by the author. Who does not know that over reacting or being short tampered is bad? However at times we loose our head and end up inflicting worst to ourselves. The post in some sense also touches the very old thought of “being positive”. As some one has said, “B+ is not just a blood group”. How true. What ever situation you are in, contemplate it properly before reacting on it. Showering anger on your family members, friends or colleagues or stressing up one self would ultimately affect your own physical, spiritual and social wellbeing.<br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com2tag:blogger.com,1999:blog-12609337.post-1162626000155310882006-11-04T15:40:00.000+08:002006-11-04T15:40:00.213+08:00Practice makes a man GreatPractice makes man perfect. Quite true. But does practice makes a man successful. Or to that matter, does practice makes someone “Great”. I ran into <a href="http://money.cnn.com/magazines/fortune/fortune_archive/2006/10/30/8391794/index.htm">this article</a> on Fortune. According to the article, researches have shown that natural gifts or natural talents are irrelevant to great success. What is important is the intense and deliberate practice of ones job. As it mentions: <br/><em>“The evidence, scientific as well as anecdotal, seems overwhelmingly in favor of deliberate practice as the source of great performance.”</em><br/><br/>The arguments in the article are quite true. In retrospect, if I look back to the days in school, university and last few years as Software professional, I have developed certain strong skills in programming and software development. And all the credit goes to diligent practice, lateral thinking, open to different ideas and ability to relate various topics to core fundamentals.<br/><br/>As article mentions “<em>The good news is that your lack of a natural gift is irrelevant - talent has little or nothing to do with greatness.</em>” I do quite agree with it. There are some things which one person does better than other. And if he goes on improvising them, he achieves emphatic success in that field. Elements like passion and strong interest are vital for any successful individual or business. However just having strong passion and lack of practice does not lead you to anywhere and everyone knows that. All in all the article gives insight on what is the simple formula of being successful.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com4tag:blogger.com,1999:blog-12609337.post-1162529457154596152006-11-03T12:50:00.000+08:002006-11-03T12:55:09.450+08:00Were the days spend in the Engineering School worth it?That is what Kathy Sierra is addressing in her latest post titled <a href="http://headrush.typepad.com/creating_passionate_users/2006/11/why_does_engine.html">Why does engineering/math/science education in the US suck?</a> on her blog <a href="http://headrush.typepad.com/creating_passionate_users/">Creating Passionate Users</a>. Probably I didn’t mention about Passionate Users on this blog, but that’s one more place I visit regularly. Tons of learnings for any software professionals. Heading on to the post from Kathy Sierra, she rants about the how useless and obsolete the engineering and science education is in US. I did my engineering in India and the engineering education system is quite influenced by west and most of what Kathy says does apply to engineering education system in India also. If I look back to the days I spend in the engineering school, I feel the experience was quite fulfilling and enriching. No doubt there were elements of cramming, exam oriented, problem solving by recipe however I never practiced them except “problem solving by recipe”. <br/><br/>Most of the India still lives with middle class mentality. The idea the prevails there is to get good grades in high-school, get admission in the best engineering school in the course which has best job prospects, and finally settle down with the “job for life” without even giving a damn thought of what are you interests, do you really want to do Computers or are you really destine to be theater artist. All that because there is lot of competition, a never-ending fight for survival and no room to introspect and think about what one wants. All that aside. Coming back to the engineering education system in India. I didn’t go to best engineering school but the one I joined had decent reputation at the state level. I joined Information Technology course without knowing a bit about what it means. Just knew that it’s to do with computer, is an upcoming field and has lot of job prospects. The college I went has a decent line up of the subjects. I learned courses ranging from Civil Engineering to Engineering Drawing to Simulation and Modeling to Compiler design. Honestly it was a good mix and I am realizing some value of all I studied back then. Seeing the other side of the coin, that is the teaching methods and how stimulating the environment was etc. Teaching methods were in someway exam oriented or rather to get things done or to just complete the course. But that said, the faculties were open for the discussion and ready to help one in pursuing his/her ideas or thoughts. What I feel is that lot depends on the individual rather than the system. System does play a great role but it is meant for masses and evolves over the period and influenced by lot socio-economical factors. The engineering education system in India calls for a revamp, however we don’t see it happening any time soon. The 50 years of legacy and the mindset would take time to change.<br/><br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1162101298065339712006-10-29T13:54:00.000+08:002006-10-29T13:58:50.776+08:00Oracle Open World coverage by Mark Rittman<a href="http://www.rittman.net/">Mark Rittman’s Blog</a> is always a great read for knowing the day-to-day happenings at Oracle BI space. This time around, he has put together a bunch of posts from the Oracle Open World happening in San Francisco. There are number of posts covering the events specifically on the upcoming releases of Oracle Business Intelligence Enterprise Edition (Siebel Analytic platform), Oracle Business Intelligence Standard Edition (very own Discoverer) and Oracle Database 11g.<br/><br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1160363976067003832006-10-09T11:19:00.000+08:002006-10-09T11:20:24.336+08:00Google Code SearchGoogle in its never-ending streak of launching new services/product released one more offering <a href="http://www.google.com/codesearch">Google Code Search</a>. <a href="http://news.com.com/Google+crawls+into+source+code+search/2100-1024_3-6122819.html?tag=nefd.top">Here</a> is the news coverage. I did give a quick try. It seems that the search relies on the comments, which are embedded in the code or the code itself. If you fire a very plain English query like <a href="http://www.google.com/codesearch?q=how+to+read+a+file+in+PHP&btnG=Search+Code">how to read a file in PHP</a>, it does not lead much useful search results. It seems very much key word based rather than heuristics or context based like the general search engines are. Perhaps it could be useful for those who want to look for the usage of particular function or particular class in various code snippets spread in open source code bases or sample codes hosted in various sites. Firing a query for <a href="http://www.google.com/codesearch?hl=en&lr=&q=PreparedStatment+lang%3Ajava&btnG=Search">PreparedStatment</a> does give some useful results when you click some of the programs listed in the search results.<br/><br/>So don’t count much on the Google Code search for the solution of any programming problem you have. I think it will take some more time when we have the search engines, which will take a problem definition something like “Write a program in PHP to convert degree Celsius to Fahrenheit” and give you a ready made or close to ready made code. Still a handy utility.<br/><br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1159677286889881152006-10-01T12:34:00.000+08:002006-10-01T12:34:46.933+08:00Working at Oracle India Ptv. Ltd..This is kind of a follow up to <a href="http://umeshkakkad.blogspot.com/2006_08_01_umeshkakkad_archive.html">Elitecore and me</a> post which I made couple of weeks back. I am thinking of doing this as a series on sharing the experiences I had with the various organizations I worked with. This is the second one and all these posts are NOT in the chorological order. <br/><br/><strong>Why I joined Oracle India Pvt Ltd?</strong><br/>I joined Oracle India Pvt Ltd in Dec,2003 and worked there till Jan,2005. I was part of internal IT team over there. So after spending close to one year in small startups, this was the first time I started working for a big corporate. And working with big software companies is some thing all of us in software field dream of. There is always this curiosity to know how big this companies are, what is the culture out there, the systems they use, the processes they have, the methodologies they follow for there product developments, how does their sales work, how do they support their products, the benefits they have for their employees, the campus and at last but not the least, the people they have. My reason for joining Oracle India was to gain some insights on how a big corporate works and to be part of their culture, the team, and to groom both my technical and soft skills.<br/><br/><strong>My Experience at Oracle India</strong><br/>First and foremost thing, which I gained at Oracle India, was to develop strong interest in Data Warehouse and BI technologies from Oracle. After a comprehensive boot camp for one month, I was put into Business Intelligence team of Apps IT. Apps IT is the group within Oracle which looks after internal implementations of Oracle tools and Applications which it uses to support its one business functions. BI team was supporting wide range of BI and data warehousing applications, which were used by the global user community. I was mainly part of Analyzer implementation (both OFA and OSA). Working at Oracle was an enriching experience. There were great bunch of people around you, ranging from the ones with strong technical skills, to the ones who are sage advisors to the ones who are extremely good project managers to the full time party animals. <br/><br/><br/><strong>Learnings at Oracle India</strong><br/><br/>There were strong technical learnings. On job, I learned Oracle Express and Analyzer product families. I developed strong fundamentals of this tools and how to best use these products for a particular business needs. Being part of BI team, I also got to learn other products like Discoverer, Oracle Warehouse Builder and EPB (Enterprise Planning and Budgeting, a next generation product which would replace OFA). I had significant exposure to Oracle database, PL/SQL, SQL and SQL tuning. Best place to learn any Oracle tools and Applications is Oracle itself. And that’s what I realized when I joined Oracle. It’s not just the resources like documents, webinars, product demos etc. to which you have access to, but the best part is the people around you who are always there to help you. Apart from BI tools and Oracle database, I had a significant exposure to Oracle eBusiness suite. Thanks to the boot camp, which covered things like Oracle Forms, Oracle Reports and AOL (foundation technology of Oracle Applications.) <br/><br/>Above to the technical skills there were loads of learnings at soft skill front. Over the period, I gained great amount of confidence both in the written and verbal communication. Honing my interpersonal skills was one more advantage of working with Oracle. Apart from this, <br/><br/><strong>Why I left Oracle India</strong><br/>After saying all the above and ushering lot of praises about Oracle, its very difficult to justify why I left Oracle. And that too, just after 14 months! My work at Oracle involved both supporting the existing application and enhancing them and also rolling out new applications. Though rolling out new applications was 25% of what I was doing, but that was what I enjoyed most. Most of my work involved supporting and enhancing the existing implementations. However, I was looking for an opportunity where I was part of end-to-end implementation of some BI or data warehouse solution from scratch. That’s something I was not seeing in the horizon over there. Also the work at Oracle was not that intense. It was too chill-pill. I was looking for more challenging, more customer facing, more intense profile, a bit more pressure and a bit more ownership. All this culminated into leaving Oracle India and joining Ness Technologies at Singapore. More on my experience at Ness Technologies some time latter.<br/><br/>I am writing this post almost two years after leaving Oracle India. All what I have said here could have been influenced by the time I have spent in Singapore and at Ness Technologies. However I have tried my best to put the thoughts as accurate as what they were at the point of time when I joined Oracle and left it.<br/><br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com6tag:blogger.com,1999:blog-12609337.post-1159676465366664092006-10-01T12:21:00.000+08:002006-10-01T12:21:05.436+08:00Developing Software Product vs Custom solution.. some random thoughts<br/>Of late I have been thinking about this a lot. How is developing a software product different from building a custom solution. And quite often indulge into casual discussions with some of my friends out here in Singapore. I was thinking of putting together a well-structured elaborate post on this topic, but seems that it would take a while for me to sit down and collate all my learnings, discussions and thoughts on this. For now just thought of putting up random thoughts on this topic.<br/><br/>First of all let me put on the table, what I mean by Software product and custom solution. By software product I mean those set of software, which are build to sell off the shelf. These are the software, which are NOT developed for any specific customer, but for general use. Of course this software comes with various features and functionalities out of box and there are some points of extension and customization. The software product is installed or setup or implemented by the customer to address their specific business or personal need. There are tons of ways to classify the software product but the details are outside the scope of this post. But the basic principle of software product or to that matter any product is that it is meant for a particular community and not a specific customer. Needless to give the examples but nevertheless here are few: Microsoft Office, Acrobat Reader, Oracle database 10g etc <br/><br/>The other category is what I call custom solutions or custom software solution to be precise. By this I mean the software build to address a custom need. This solution is targeted for one particular customer or a particular requirement or a specific business processes. The software (or the solution) is not build to sell of-the-shelf. Even maintaining existing enterprise applications and enhancing them falls under custom solutions. A custom solution could be one build from scratch like a Web Based Budgeting and Reporting solution build using Java and HTML technology. Or it could be extending the functionality of standard applications by adding necessary customization. <br/><br/>I do acknowledge that there is no easy way to classify all that is happening in the software world into these two categories. There are some things, which are in the boundary and don’t really fall straight in to one of this category. We keep hearing things like frameworks or blue prints, which are sold commercially these days. These frameworks are in turn used to develop custom solutions around it. So where do they fall? Similarly there are offerings forms Google like Gmail, or Clendar or to that matter any web service, which is out there in Internet. Should we call it a software product or a custom solution? Lets us keep ourselves away for all these debates.<br/><br/>Getting back to the main idea of the post: how does developing a software product differ from a custom solution. <br/><br/>Developing a software product according to me is:<br/><ul><li>More organized and planned engagement. </li><br/><li>Lot of planning goes before embarking the actual development. </li><br/><li>There is lot study done in terms of gathering the requirement. </li><br/><li>Things like Focus group and user community are foundation for this product</li><br/><li>Involves Studying features and functionalities of other competitive products in market.</li><br/><li>Most of the time, a prototype or a proof of concept precedes the actual development </li><br/><li>There is lot of flexibility while developing the software product it terms of choosing the technology, etc.</li><br/><li>The teams are relatively bigger. Flexibility for the a developer to be focused on particular module or set of module</li><br/><li>The quality process is more elaborate. Lot of testing both internal and external is done</li><br/><li>API and maintaining reusable components libraries is critical</li><br/><li>Wide adoption of software best practices and better design principles</li><br/><li>Bug fixing and support is more comprehensive</li><br/><li>Licensing and software delivery are important consideration</li><br/><li>Software packaging and installation mechanism are important component</li><br/><li>Change control is ubiquitous </li><br/><li>System design documents are user manuals are of good quality. Also the documents are constantly maintained with the new release of software product.</li></ul><br/>On the other side developing a custom solution is:<br/><ul><li>Planning process is not very elaborate</li><br/><li>Studying of requirement is not very comprehensive. At times requirement gathering processes continues long after the actual software development has started.</li><br/><li>The scope of the solution at times is not well defined</li><br/><li>Prototypes or proof of concepts is not that frequent. </li><br/><li>In terms of choosing the technology or tools the decision has already been taken by the customer or the during the presales exercise</li><br/><li>The teams are relatively smaller with one person playing multiple roles at times.</li><br/><li>API and maintaining reusable components is not that critical if the custom solution is relatively small. </li><br/><li>In larger solutions there is proper bug fixing setup. However for the smaller solution the bug fixing and patching is very adhoc</li><br/><li>Licensing is not of that grave importance. However there is lot to deal with in terms of SLA (Service level Agreement) while delivering a custom solution.</li><br/><li>Software packaging and installation mechanism are not of significant unless the solution is build for large user base, which needs to install the software on their PC. </li><br/><li>Change control in place for most medium and large-scale custom solution.</li><br/><li>Design documents are part of any custom solution project however at times these documents are not maintained with the new releases or the changes in the existing release.</li></ul><br/>All said, the above does not always stand true. With the smaller software product developed with Agile methodologies do forego some of the items mentioned in the software product development. Similarly with the large custom solution developed under a strict quality process does follow lot of the items in the software product development<br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com51tag:blogger.com,1999:blog-12609337.post-1159591239620762212006-09-30T12:40:00.000+08:002006-09-30T12:40:39.660+08:00New Google ReaderFor all those out there who are passionate about RSS aggregator and are looking for the best offering out there which helps them best track what they are following on web on day today basis, there is something to cheer about. Google has released a completely revamped <a href="http://reader.google.com/">Google Reader</a> . As always, they were very modest while releasing this completely new RSS aggregator. The philosophy for the new UI is simple: <strong>Your inbox for the web. </strong>And they have done this is most elegant way. I have been trying quite a few web based RSS aggregator. Yahoo along with its <a href="http://umeshkakkad.blogspot.com/2006_09_01_umeshkakkad_archive.html">new Yahoo! Mail </a>also released a completely new RSS aggregator, which is quite similar to new Google Reader. However the service has bit of glitches. It does not show you how many of the feeds are still unread. Also at times the RSS feeds do not come through properly. Its bit slow when you browser through the long stories. But Google reader comes with superior "Google User Interface" and unprecedented usability. So intuitive. So cool. Yahoo! made a great point with their new Yahoo Mail by integrating your email inbox and web inbox in one service. Probably even Google would eventually integrate their Gmail and Reader to one interface. Lets see.<br/><br/><a href="http://en.wikipedia.org/wiki/RSS_%28file_format%29/">RSS feeds</a> have been one of the great revolutionary things of Web 2.0. I think after Email, IM, the RSS is next great thing, which happened in Internet. Sometime back I attended the presentation at a conference talking about shift in the way we deal with Internet. Instead of pulling the information out from Internet, we would be pushed with the latest information, which are of our interest. That was 2003. And within few months of that conference, technologies like RSS and ATOM came into existence. And within few months they have became so prevalent or pervasive. RSS is getting applied everywhere. <br/><br/>Talking about the ways RSS technologies is being applied. News Sites, Blogs, Forums, Corporate websites are few examples of where RSS is being applied. Now a days even all the social networking sites like Flickr, MySpace and email services have RSS feeds. With RSS, you can create one dashboard which you go every day for monitoring the new content or activities at different blogs, forums, news, any new photo getting uploaded at Flickr by your friends or any new job that got posted on the a particular job portal matching your criteria. In some places RSS feeds are taking over the old Email alerts, which of late has got bad reputation of spamming your mailbox. RSS is a new way to market the new features or inform the users of the new launches. <br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1158566096023436342006-09-18T15:44:00.000+08:002006-09-18T15:54:56.046+08:00Yahoo! Mail betaIf you haven't heard of the new Yahoo! Mail, do check out <a href="http://new.mail.yahoo.com">new.mail.yahoo.com.</a> The interface is close to Microsoft Outlook. Some of the features which stands out among the tonnes Yahoo! has put together for this beta:<br /><ul><li>Tabbed mail browsing</li><li>Right click menu shows the custom menuitem from Yahoo! and not the default browser context menu</li><li>Split view of message list and the message content. Similar to any desktop mail client</li><li>Compose window is quite similar to Outlook</li><li>One can view RSS feeds subscribed in My Yahoo.</li></ul><br />Of there are some in Gmail which are quite handy and not yet in Yahoo! mail beta:<br /><ul><li>Attachment is not that seamless like Gmail</li><li>Messages are organized in conversations which is till not the case in Yahoo mail</li></ul>There should be many more. However, Yahoo! has done a great job with this beta. Earlier they released the new Mail search which was again quite outstanding.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com3tag:blogger.com,1999:blog-12609337.post-1157891547239675762006-09-10T20:32:00.000+08:002006-09-10T20:36:13.996+08:00Startup SchoolHarvard University seems to be organizing <a title=""Startup School"" href="http://startupschool.org/">"Startup School"</a> annually since 2005. I stumble upon the notes from the 2005 event over <a title="here" href="http://rallenhome.com/startupschool2005.html">here</a> and for 2006 over <a title="here" href="http://www.brendonwilson.com/blog/2006/04/30/startup-school-2006-notes/">here</a> . The conference deals with various learnings and experiences around how to go about starting a company of your own. I am yet to go through all of these but bet that it would be interesting read. Its for sure that there are great learning in store for some one who wants to venture in to start something of his own or for those who have just got started with there small shop in software. I have been following quite a number of sites which collate and bring in experiences and war stories from those who are successful entrepreneur. <a title="Venture Voice " href="http://www.venturevoice.com/">Venture Voice </a> is one of them. Venture voice posts interviews with some of the successful entrepreneur both in software and non-software field. Sometime back they had organized "Venture Voice Startup Workshop" a similar event like Startup School. You can check out the coverage of Venture Voice workshop over <a title="here" href="http://www.venturevoice.com/2006/07/vv_show_36_venture_voice_start.html">here</a>. The pod cast has great set of learnings on what are the factors influencing the success of a startup.<br><br>I always have a thought of doing something of my own at some point of my career. But for now, would continue working with the corporates, garner some experiences and then would see.<br><br><br><br><br><br><br>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1157256057010997682006-09-03T12:00:00.000+08:002006-09-03T12:00:57.016+08:00Whats the better language for my application?What’s the better language for my application? Whether I should be using PHP, or Java or .Net? Or how about Python, Ruby on Rail (RoR) or our very own C language? Now that’s the question most of the system architect or sometime even the programmer would have come across at some point of time. <a href="http://www.joelonsoftware.com/">Joel Spolsky</a> of Joel on Software fame ran the story titled <a href="http://www.joelonsoftware.com/items/2006/09/01.html">“Lanuguage Wars”</a> on his blog addressing exactly the same. Of course there is no straight formula or a matrix out there, which helps you decide which is the better tool for my application. All this programming worlds have their own pros and cons. They have large ecosystems build around them. There is lot of talent pool available for this skill sets. <br/><br/>According to the article an important thing, which helps you decide is the skill set you have at your disposable. Apart from this the specific needs of the applications like the application should run on Unix and Windows platform or likes. Apart from all this, the one thing, which I would consider, is the application frameworks and reusable components or libraries available out there in the community of these programming worlds. If there are some frameworks or the set of libraries, which would fit in readily in your application, then it’s a big advantage.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1157254754122278942006-09-03T11:39:00.000+08:002006-09-03T11:39:14.130+08:00Writing HacksGetting started with writing is something real difficult. Whether its writing a blog entry, or an essay, or an article or some time even a elaborate email explaining some specific scenario of a project and the implication due to same. Speaking and writing are two different skills. A guy who speaks well need not be a good writer always. Writing has its own hacks. Scott Berkun has posted a very good essay titled <a href="http://www.scottberkun.com/essays/essay54.htm">Writing Hacks – Part 1</a>. The essay brings out good insights on how to get started with writing something. The essay teaches good hacks such as starting with single word, then a sentence and then the whole thing. Overcoming psychological barrier of getting started with writing is something every one has to deal with in their life at some point of time. Even for me, I had hard time putting together my first posting on this blog. Even though it was just an introduction but still you write something then erase it and then write something else and on and on.<br/><br/><a href="http://www.scottberkun.com/blog/">Scott Berkun</a> is always a good read. He has a unique and intriguing style of writing. And when he shares the tips on how to get started with writing and how to write better, then it should be great. Whether its writing something or doing a painting, or designing a UI for an application or sometime even writing a piece of code, for all of this you have to break a similar kind of barrier. How to get started? And once you get going it becomes easier. For me writing a piece of code appears to be easy now then what it was before 3 years. All this because I have been doing it for quite sometime. Same would be the case with writing. Once you get going for sometime, you become more comfortable. Another thing, which I felt was a major barrier for writing something, is the concern for quality of content. You read lot stuff here and there and you feel that you should be writing of the same quality. I overcame this by thinking as of I writing for my self. It does help in getting started. Once you have confidence you can expose your writings on the blogs, etc.<br/><br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1157095465857035992006-09-01T15:24:00.000+08:002006-09-01T15:26:46.200+08:00Web ArchiveThis is cool. Have you ever wondered what was the home page of Yahoo! 10 years ago? You can do this. I ran into <a href="http://www.archive.org/web/web.php">this</a> site which allows you to see how a particular website or a webpage looked way back in past. Pretty cool. This is how yahoo looked on <a href="http://web.archive.org/web/19961017235908/http://www2.yahoo.com/">Oct 17, 1996</a> and on <a href="http://web.archive.org/web/20010405120452/http://www.yahoo.com/">Apr 05, 2001</a>. And this is what Google looked like on <a href="http://web.archive.org/web/19981202230410/http://www.google.com/">Dec 02, 1998</a>. Quite good if you want to see what was the retrospectively what was registration page for Yahoo mail and how it has evolved over the time. Of course there are some broken links here and there when you open the archive version of this sites. But all and all nice, handy utility to give a peek on the state of Internet 10 years ago. Good for those who are writing essays on evolution on Internet or evolution of Google and their home page.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com1tag:blogger.com,1999:blog-12609337.post-1156775342519536212006-08-28T22:29:00.000+08:002006-08-28T22:29:02.566+08:00Duplicating the data in a MOLAP application - Does it always hold good?Continuing with the discussion on whether duplicating the data in data warehouse applications is always good or not. Today I would be talking about MOLAP application. By MOLAP application, I refer to the reporting application, which use multi dimensional storage (not relational table) to organize and store the data. Also these are the tools, which typical use multi dimensional query language like MDX, SPL (for Oracle Express) and not SQL for querying. Hyperion Essbase, Oracle Express (now Analytical Workspace and part of Oracle RDBMS), Microsoft Analytical Services etc. are some of the well-known MOLAP platforms. Niegle Pendse’s OLAP Report is best place to understand various OLAP products in the market. Like relational data warehouse and reporting applications, there are instances of duplicating the data in the MOLAP applications too. In my previous experiences with Essbase and Oralce Express, I have seen some occurrence of data being duplicated with slight modification or transformation in multiple variables or cubes. <br/><br/>MOLAP applications are meant to be lighting fast. So there is lot of summarization and aggregation done in the application. Most of the calculations are part of data load and aggregation batch process. Very little gets calculated while querying the data. However there are quite a number of calculations, which are made part of formula (in Oracle Express) or dynamic calc (in case of Hyperion Essbase). Often these calculations are moving total, ranking, calculating Year to date, rolling quarter, variance etc. And ideally these calculations should be part of formula and or dynamic calc, because:<br/><ul><li>Because this calculations are very simple and does not involve many data values to operate on</li><br/><li>Sometime this calculations involve applying some formula with different weight:</li></ul>Example: ( 20 * Advertising Expenditure + 80 * Other Expenditure ) /100<br/>Now this weight could change over the period as the organization tactics change. And this formula could evolve. So it’s better to keep them on the fly.<br/><br/>Even though there are things which best fit in as on-the-fly calculation, I bet there would be many implementations out there calculating them in the load scripts and storing. So all the disadvantage I mentioned for duplicating relational tables holds for MOLAP too. The extra logic needs to be written, tested and maintained. Any debugging would have to check the base data, and the intermediate data. If there are any bugs in the loading script, the data needs to be cleaned up, reloaded and re-aggregated. Would it be dynamic calculation and if there is any bug, only the formula needs to be changed no reloading of data is required.<br/><br/>At times there are scenarios were you want to expose a cube with the respect to fewer dimensions and not all. In OFA (Oracle Financial Analyzer, a Financial reporting application using Express as backend) there are times when FDI (Financial data item a.k.a. variable or cube in Express) are required to be exposed with fewer dimension and not all. So for this scenario also, one should avoid creating a stored FDI and replicating the data in it. Better approach would be to have the data rolled up in the base FDI using hierarchies and creating a formula FDI on top of base FDI with limiting the dimensions to “Total” for those which are not to be exposed for analysis for that FDI.<br/><br/><br/>Lets take an example where dynamic calc could enable you to achive reporting the aggregated data. You have a following data model: <br/><br/><strong>Dimensions:</strong><br/>Market (with hierarchy All Market -> Region -> Country)<br/>Years (with members like 2006, 2005 etc. No hierarchy)<br/>Product (with members P1, P2, etc. No hierarchy)<br/><br/><strong>Cubes:</strong><br/>Gross Sales <Year, Product and Market><br/>Tax Rate <Year, Market><br/><br/>How could we dynamically calculate Net Sales <Year, Product and Market> from the above? <br/><br/>Net Sales = Gross Sales * (100/ (100 + Tax Rate))<br/><br/>Lets see what’s wrong with this formula? Tax Rate is something you can’t aggregate on Market. Tax of India + Japan + China + Singapore etc. would not give you the tax rate for Asia. Neither would the average of this give you. So you don’t have tax rate for “Asia” and hence above formula would not return you the Net Sales for “Asia”. All you might need is another stored cube called “Net Sales” which you can use to store the “Gross Sales” less “Tax”. The cube can then be aggregated to return the numbers at Asia or All Market. <br/><br/>Not trying to contradict what I mentioned earlier. For this scenario and similarly many others, there is no direct way to achieve using the dynamic calc. In Oracle Express you can end up writing a SPL code which can do so dynamically, however in nutshell it would be adding the net figure of India, Japan and so on and returning the result dynamically. This could slow down the performance depending on the number of members you have. If you have 220 markets, the All Market level calculation would take quite long to come through. <br/><br/>To recap what I said in this and last post, is that there are different scenarios where one gets inclined to replicate the data either with minor transformation or aggregate. However one should consider doing this only if the on-the-fly calculation can not achieve the said results with permissible performance.<br/><br/><br/><br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1156653385477516662006-08-27T12:36:00.000+08:002006-09-01T13:34:29.500+08:00Some Web 2.0 stuff..<p class="MsoNormal">Few Web 2.0 things, which I started following in last few weeks. <a href="http://www.techcrunch.com/" title="Techcrunch">Techcrunch</a> is one of the best tech news site I have found in the recent times. It is sort of one stop shop for all the tech and web 2.0 related news. The content is very concise and complete. It’s always good to browse through happenings around in the tech industry. <a href="http://www.digg.com/" title="Digg">Digg</a> is another news site. Though I heard of it few years back, but newer used to follow things over there. In the last few weeks I have started reading through the stories at Digg. Like Tech crunch, even this is sort of one stop shop for tech news. Most of the times, the stories in Techcrunch and Digg do overlap. But Digg gives a different taste. The commentary going around is good to read.<br /><br />Few more handy Web 2.0 utilities which I started using in the last few weeks. Guess what? All are from Google. <a href="http://calendar.google.com/" title="Calendar">Calendar</a> , <a href="http://reader.google.com/" title="Reader ">Reader </a>and <a href="http://www.writely.com/" title="Writely">Writely</a>. The altruistic Google has been generous as like ever before. As I always write, they are showering best of the collaboration and personal management utilities, all as <a href="http://umeshkakkad.blogspot.com/2006_07_01_umeshkakkad_archive.html#115329779448380402" title="SaaS ">SaaS</a><u> </u>and for free. The usability, the UI, the features and the functionalities, all unmatched compare to any commercial desktop tools. Of course there are quite a number of limitations compare to desktop tool some because this tools run from browser. But the best all this tools have is the Web 2.0 community related features. You can share the calendar, you can view others calendar across the globe, you can create the documents in writely, share them, co-author the a document by multiple people, maintain versions, blog them, publish them as HTML and PDF and what not. The Google Reader is an excellent RSS feed aggregator. Initially I was big fan of My Yahoo. It was very easy to subscribe the feeds and collate them at one place. Easy one page snapshot of all the feeds. Easy to customize the interface. However, you cannot read the original stories for this feeds in the same page. Got to open it in the new window or so. With Google Reader its damn easy to read through the whole feed. At least for those who publish the whole story or article in the feeds. TechCrunch is one and most of the blogs at Blogger do publish the whole article in the feed. So its quick to scan through the whole story without switching the tabs. However what I miss in Google Reader is to see all the feeds in one page, in one view something like My Yahoo. Probably there is a way you can do it. Let me explore in the coming days. For time being I am using both My Yahoo and Reader. Of Course one can look for the elaborate reviews of these tools on Internet and blogsphere.<o:p></o:p></p>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1156579889241814842006-08-26T16:11:00.000+08:002006-08-28T12:19:29.423+08:00Duplicating the data in a data warehouse - Does it always hold good?<p class="MsoNormal">Duplicating the data in an applications. Does it hold good always? I won't be talking about the whole range of application but focusing on data warehouse and reporting applications. If we go by some of the definition and design principles of data warehouse, they mention about redundancy in the data model. One of the golden rule for designing a typical data warehouse is to have the data model as a simple star schema. Star schema with denormalized or redundant dimension tables. The technique is also referred as Dimensional modeling. There has been a long running debate on what is the better approach for designing a data warehouse: Dimensional modeling or ER (traditional 3NF) modeling. Let us keep ourselves away for this for now.<br /><br />So what I want to cover here are:<br /><b>1.</b> <b>Duplicating fact tables or dimensional in the same data model with some calculation or some minor transformation</b>.<br />I have seen this quite a times in my previous experiences. Duplication has all inherent disadvantage like duplicating in the efforts to write the loading program to populate this extra tables. This new program comes with its on effort to debug and test them. Extra space for these tables is one more thing. However the storage has negligible impact since the ever storage cost is ever decreasing and improvements in the RDBMS technologies. The most important thing, which I hate about the duplication, is the maintenance. Every load, if you encounter an issue in particular report, you have to trace down from the report to the intermediate fact table to the base fact table and source. Having these extra tables would always keep you giving and giving in terms of troubleshooting and debugging them.<br /><br /><b>2. Summary tables</b><br />There is always tendency to convert a long running query to a summary table which can then be directly used by report instead of querying on the base tables. What you end up doing is writing a PL/SQL routine or ETL mapping to populate this. All right. It does solve the problem. The performance would better up. After all summarizing the data and giving the aggregate picture is one of the important principles under pinning data warehouse philosophy. However the problem it brings along with it are same as point 1. You need to develop, test, and maintain this extra logic.<br /><br />So how to remediate this? Possible ways:</p> <ul type="disc"><li class="MsoNormal" style="">Make the reporting tool use the base fact with the necessary transformation and calculation be part of report query.</li><li class="MsoNormal" style="">If the reporting tool does not support some transformation functions whic are available in the database or you would like to keep report query simple, encapsulate the transformation or calculation logic in database view. Database views are most handy feature I have used in my last project.</li><li class="MsoNormal" style="">If the transformation or calculation logic is very complex and simple SQL is not sufficient to achieve it. Use features like table functions. Table functions allow you to encapsulate a complex PL/SQL logic in a function, which returns a table (or collection of rows). On top of this table function you can create relational views, which in turn could be used for reporting.</li><li class="MsoNormal" style="">Materialize view is another way to tackle this kind of situation. All the above 3 approaches are the on-the-fly approach and can lead to performance issues. Materialize views could be another option to consider if there are such issues.</li></ul> <p class="MsoNormal"><br /><br />As mentioned reporting aggregating and summarizing the data to have high level picture and then able to drill down to the transactions is the one of the core principle of data warehouse philosophy. Most of the design principles and technologies are how to make this more efficient. There has been range of new technologies catering this particular directly or indirectly. The new products are being churned out from both traditional data warehouse vendors like Oracle (Oracle 10g OLAP option, Materialized view), IBM and MS (SQL Server 2005). Also there are new offerings from pure play BI software vendors like Hyperion, BO, Cognos. Above all there are firms like <a href="http://www.hyperroll.com/" title="Hyperoll ">Hyperoll </a>etc. are just catering things particular thing. The details of this offering are outside the scope of this post.<br /><br />All I covered in here is about relation data warehouse. I would cover similar caveats in MOLAP applications in one of a subsequent post.</p>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1156563861692858842006-08-26T11:44:00.000+08:002006-08-28T12:19:48.946+08:00eLitecore and me<p class="MsoNormal">Today, I stumble upon <a href="http://www.ameinfo.com/93348.html" title="this">this</a> news story is about eLitecore's expansion in middle-east. Ofcz thats a good news for eLitecore. They are a great company with the great bunch of products and great people.<br /><br /><a href="http://www.elitecore.com/" title=" eLitecore">eLitecore</a> is a mid-size Software development house based in Ahmedabad, India. The company has a long and vibrant history. I know fairly good about them since I worked with them for couple of months and reading the news story took me back to good olds days at eLite. Couple of months, huh.. was it a consulting assignment? No. Actually I joined them on permanent rolls but just 2 months down the line, got an offer from Oracle India Ptv. Ltd. Since it was early days of my carrier and probably thought that working for a bigbrand would add lot of weight to my resume. And thats it, I quit. That was the end of my spree of working with startup. In 2003, I worked for <a href="http://www.rightwaysolution.com/" title="Rightway Solution">Rightway Solution</a> and <a href="http://www.elitecore.com/" title=" eLitecore">eLitecore</a>. And the learnings were one of the best, a rookie in IT field can get. In Dec,2003 I joined Oracle and since then have been with big corporates. So kindda have a flavour of both startup and biggies and how different its working with them. Ofcz it goes for another post. Probably in the comings weeks would write on this, since there are lot of things to share over here.<br /><br />All that aside, lets come back to eLitecore. eLitecore has its genesis from <a href="http://www.icenet.net/" title="Icenet">IceNet</a> one of the first ISPs in India during the early days of Internet in mid nineties. eLitecore started with developing network management and billingsoftware for Icenet and latter went to become a leading product development and services company. There are quite a few successful product based company in India (most of them are into services) and eLitecore is one of them. Part of eLitecore's business was services but product development has been their focus all along. Their primary product lines deals with network management, network security tools and billing software for small and large scale ISP. Their flagship product <a href="http://www.cyberoam.com/" title="Cyberoam ">Cyberoam </a>now branded as UTM has large install base in both domestic and international market. The product comes with tonnes of features like configuring Internet access policies, bandwidth sharing among the application, security features against attacks like Phising and Pharming, loads of reporting to get better insight in the Internet access patterns, VPN and the list goes on and on.<br /><br /><br />Coming to my stint at eLitecore, I would say those were one of the best days in my IT carrier. I got to learn lot of the insights about developing a product. eLite follows Agile methodologies for product development. The team size is usually small so there is lot of things on your plate to do. There were earnings on how to</p> <ul type="disc"><li class="MsoNormal" style="">architect products</li><li class="MsoNormal" style="">creating the library and reusable code base</li><li class="MsoNormal" style="">how to leverage on open source</li><li class="MsoNormal" style="">how to make best use existing libraries out there</li><li class="MsoNormal" style="">integration</li><li class="MsoNormal" style="">designing data models</li><li class="MsoNormal" style="">Usability design of the systems</li><li class="MsoNormal" style="">developing a tool typically for network access management</li></ul> <p class="MsoNormal">Of course I didn't gain mastery in all the above. The learnings were not that intense for some of the above items, but I did get good starting point on the considerations for developing a software product.<br /><br />Though after eLitecore, I never worked in network management tools, or Linux or even in Product development of late. All I am doing is technical consulting and implementation of BI and DW products. However the learnings from eLitecore are instrumental in my day to day working.</p>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com1tag:blogger.com,1999:blog-12609337.post-1156239543991425732006-08-22T17:39:00.000+08:002006-08-22T17:42:53.873+08:00Hitec Ecosystems and IndiaYesterday was listening through a keynote address by Dr. C. K. Prahalad titled <a href="http://www.itconversations.com/shows/detail1030.html">“Emerging Hi-Tech Ecosystems”</a> from the <a href="http://www.sandhill.com/conferences/sw2006.php">Software 2006</a> conference. Speaker starts with defining what is a ecosystem and what are the major ecosystems which have drawn considerable attention in recent past. The talk is packed with lot of stats and some are really surprising like the way software exports grew in India from mere few millions in the start of 90s to 10 billion by 2005. The talk revolves around economics at India and US. The speaker mentions that India is no more an outsourcing partner but innovation partner for US.<br/><br/>One great point which the speaker brings up is how India can help reduce down the cost of innovation and diffusing the innovation by its large pool of skilled labor and booming manufacturing and other sectors like pharma, services etc. He mentions on how ecosystems can interact with each other by complementing and contributing to each other. An example he gave was that IT and Automotive industry in India are concentrated in 3 parts of India that is Delhi-Noida, Mumbai-Pune and Chennai. The point he makes is how should the automotive industry leverage on the software sector for innovating new technology know-how of doing the things in better and efficient way.<br/><br/>The talk also brings up a great thought of making IT and software affordable for the 80% of underprivileged population of the world. He gives an example of a village from central Madhya Pradesh were the farmers have started using computers and Internet to keep them updated about the weather or using the latest technology and novel farming practices or the latest prices of commodity goods at Chicago Trade Exchange which in turn would help them get the better prices for there goods. This particular thought is close to what Vinod Khosla said in <a href="http://www.itconversations.com/shows/detail796.html">a conversation at Web 2.0 2005</a> conference held in Sept,2005 where he mentioned of using Internet to deliver the high end education to all the underprivileged people in the remote corners of the world. An striking example he gave was to have a sort of remote Harvard university where 400,000 are listening to a lecture from a eminent scholar from remote corners of the world.<br/><br/>Overall the keynote bundles great thoughts. Must listen.<br/><br/><br/><br/>Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0tag:blogger.com,1999:blog-12609337.post-1155035099578971292006-08-08T19:04:00.000+08:002006-08-08T19:06:52.573+08:00SAP NetWeaver BI and SAP BI AcceleratorIf you see the BI market, and to that matter any market to say, it is getting crowded like never before. Today we have large number of players catering both to both BI Applications and BI platform market place. Apart from this, there are niche players like whose focus is only performance boosting, data quality and so forth.<br /><br />For me, I just follow Oracle BI tools and these days Siebel Analytics and some of the related offering. Also had spend some time with Hyperion product line in my previous assignment. But it always good to know some bits and pieces about offerings form other vendors.<br /><br />Today I ran into <a href="http://searchsap.techtarget.com/searchSAP/downloads/BI_Accelerator.pdf">this whitepaper</a> describing SAP BI Accelerator. The whitepaper focuses on how does BIA fits in the typical SAP BI implementation. I had hardly followed SAP BI offerings in past, except that I read some news group discussion on SAP BW vs other data warehouse technologies and stuff. However this article did give me some insight on what is SAP NetWeaver BI and how a typical implementation of SAP BI works. Sort of high-level view of what could be the architecture of SAP BI. To me, SAP BI closely resembles to Siebel Analytics. Setting up SAP BI would consist of defining the data model, which could consist of either relation tables (ODS) or dimension data model (Infocubes).<br /><br />Like any other relational OLAP implementation, SAP BI allows you to create Aggregates and define the metadata for the same. This will allow the query to be redirected to them instead of base tables. However, this aggregates like any in Siebel Analytics needs to be maintained outside the SAP BI purview. Also these aggregates are pre-defined and can cater to limited set of queries. So here comes BI Accelerator for the rescue. With BIA setup, you no more need to set up the aggregates. The BIA would in turn use the inbuilt proprietary technology to aggregate the data and cache it for subsequent hits. The concept behind BI Accelerator is close to HOLAP as author Naeem Hashmi from Information Frameworks says<br /><em>“<span style="font-family:Garamond;">For Data Warehouse pros, the concept of BI accelerator is similar to good old HOLAP, although the technology and approach is radically different. Meaning, the content is transformed into proprietary structures in another layer on top of Relational-OLAP implementation. User access layer sends incoming queries to HOLAP for quick access/navigation instead of Relational-OLAP. The only difference here is that BI accelerator uses powerful search engine technology, transparent to traditional data warehouse end users.”</span></em><br /><br />The white paper is a good read and gives some fundamental insights of BI Accelerator.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com2tag:blogger.com,1999:blog-12609337.post-1153982783209866262006-07-27T14:46:00.000+08:002006-07-27T15:02:16.796+08:00General Availability of Oracle(R) Warehouse Builder 10g Release 2Oracle has announced general availability of Oracle Warehouse Builder 10g Release 2. The press release can be found <a href="http://biz.yahoo.com/prnews/060726/sfw071.html?.v=65">here</a>. OWB 10g2 is significant release of OWB after almost 3 years of waiting. The new release has tons of new features like better support for MOLAP (Analytical Workspace), data quality (data profiling), scheduling, data mining and many more. There are some good entries at <a href="http://www.rittman.net/">www.rittman.net</a> and <a href="http://www.bayontechnologies.com/">http://www.bayontechnologies.com/</a> detailing various new features in OWB 10g2.Umesh Kakkadhttp://www.blogger.com/profile/00278171445172655086noreply@blogger.com0