Helpful Links on Data Warehousing Fundamentals

These might not all be 'fundamentals' but the articles at this link are solid. Many may not apply to you since they are great when applied to very specific situations (such as modeling multiple employee dimensions).

In general though, I think many people can learn something here. Kimball and sometimes Margy Ross here share good insight. They're not going to give you the gold nuggets that you'll likely get from their paid training, but the articles will get you thinking about your design.

HERE

I have been AFK! - away from the keyboard

Well not actually. I have been in front of a computer or using a keyboard every single day practically since my last post in April! Work has been extraordinarily stressful and busy. You know...when you have 10 tasks and 2 people? :) Yes, THAT busy. In a way I suppose that's a good thing. We've had a global meltdown since the end of 2008 in the economy. Things picked up a bit since their March lows...up a good 20-30% depending on the index you measure.

There's never a shortage of work for people that really know how to do it. So, as I said...maybe the mind-numbing heaps of work is a good thing in this economic storm.

I want to apologize for not posting more regularly! I used to take it upon myself to blog while waiting for things, sitting in an airport, having a spare 30 minutes to share interesting observations on Oracle. I just haven't had that time recently :(

One link I would like to provide is courtesy of slashdot. I read there regularly. This article and the following comments (warning, MANY comments) are mostly about IT in healthcare, and why it is SO behind. It follows up a bit on my last post in April about Healthcare and Medical Informatics.

Another posting I have decided to link to simply burns me up. Very Angry! Here
Read on if you dare! I whole-heartedly disagree with this analysis, and I have many years of firshand experience!

I also wanted to mention (Sept 4 2009) that I received this very interesting comment. I didn't know what language it was, but I assumed arabic, hebrew, russian...I was not sure. So Google's translator was VERY handy! it detected the comment attached to this post was in Russian and tried to give a best translation to English. Here it is:

Если врач знает название вашей болезни, это еще не значит, что он знает что это такое. Никогда не приписывай человеческой зловредности того, что можно объяснить обыкновенной глупостью. Человек может долго жить на деньги которые он ждет. Реальность это иллюзия вызываемая отсутствием алкоголя. Женщины едят за разговорами, мужчины едят заедой

This, according to Google is suppsoed to mean:

"If the physician knows the name of your illness, it does not mean that he knows what it is. Never ascribe to human malignancy that can be explained by ordinary stupidity. A man may live long on the money that he waits. Reality is an illusion caused by lack of alcohol. Women eat for talking, men shall go eat."

Interesting. Confusing but interesting. A bit abstract!

The Wide World of Medical Informatics

I got thinking the other day (and have thought this for quite a long time- as far back as 1999) that if there was one niche or sub-field that really falls right into my interests and background it is medical informatics. I have degrees in cell and molecular biology, as well as computer science. I have been fortunate to work in hospitals, medical research facilities, and in medical schools at various levels. Not to mention my career as an Oracle consultant.

I have been very very busy recently, and have decided to try and post regularly again. This particular subject motivated me to do so! To start with, the subject "The WIDE World of..." is misleading. It is true that Medical Informatics requires a very wide skill set as opposed to what most strong oracle developers individually, or most medical practitioners individually have. Each of these are very deep careers in themselves! However, we can also say the subject itself, as opposed to the knowledge needed to DO the work is not particularly wide. Nor is it very established and mature! Schools only recently in the last decade have even developed patchwork curriculum studies to earn certificates or master's degrees in bioinformatics, or medical informatics, or medical analytics.

To top it off, I have noted that such top schools including Northwestern University, right here in Chicago, Illinois, USA, don't have anywhere near the strict admissions standards applied to these newer programs in their infancy. You don't even have to take the GMAT or GRE (graduate admissions exam) to matriculate! It is recommended, but not required. Admissions In most cases, this indicates a program or field of study still in it's infancy and looking to establish itself as a solid undeniable mainstream option.

I do believe that as of now, it is undeniably necessary and important. However, most medical institutions are in the stone-age. Any very solid technical person that steps into hospitals or even doctor's offices will see some systems that are VERY complicated and state of the art. Other systems, such as records systems and software programs are buggy, poorly laid out, or cause the practitioners (nurses, doctors, executives) headaches when trying to enter data, or more importantly...retrieve data that is accurate, up to date, and understandable! The real focus...informatics...is important. The analytics and informatics methodologies in a business intelligence lifecycle simply are lacking in major healthcare organizations. I am not just talking about hospitals, but health insurance companies too!

I have personally sat in doctor's offices where multiple doctors and even medical execs can't stress enough how much they hate having to use EPIC Systems software, or Cerner Software.
I don't know enough about them to explain the issues, but I have seen the pained expression too many times. I have plenty of friends that worked from a technical or manager perspective for major healthcare insurance companies that ALL complain about the same thing: old and not too sharp technology OR sharp technology being used the wrong way which costs even more $$.

I've read it and heard it in person so many times that I've decided to try and write a few blog posts on this topic. The field is ripe. The education is now available. The technologists (Oracle BI and DW folks) are very much present and ready. The doctors know just enough of what they want but VERY few have the skills that we Oracle BIDW developers and managers have.

I want to provide a link for readers to pursue:
Saving Lives With Oracle

What might a VERY general role of the Oracle scientist, or informatics individual be?

Medical Informaticists fill a vital role in health care systems management, verifying and certifying critical computer system components:

• Certifying medical systems for accuracy and completeness

• Validating medical decision support systems and expert systems for clinical diagnosis and treatment

• Verifying the accuracy of Oracle database output results and reports
  

Is it necessary to have a M.D.? I do not think so. However, this is not like ANY other consulting or business engagement. The doctor or the healthcare organization has a lot of knowledge and very detailed ideas of how things need to work. This is just not something the average consultant can pick up in a few meetings! Unless you have some experience in scientific industries, or have worked in a medical or healthcare settings, or have an actual M.D., you'll likely need to work with a person or small team from the organization that knows all the ins and outs of healthcare, diagnoses, patient records, records management, prescription management, insurance, and core hospital measures and operating practices!

Do not be held back by that though! The reason I believe this field has been too slow to advance, is lack of education, and extremely high amounts of knowledge necessary. I will continue writing on this topic. I'd like to disuss things such as data mining, analytics, and other topics that are relevant!

Oracle Warehouse Builder and SAP Sources

I saw a nifty link that Antonio Romero, one of Oracle's OWB product managers, gave out. When I sat in the Publisher's and Author's round table event at the last Open World, I was lucky to sit with the head of Oracle's documentation and discuss a bit on the online documentation structure, and changes coming. As well, I heard from OWB PMs that the OWB docs would be filled out more. Here is the start of that effort, in chapter 7 - Retrieving Data From SAP Sources.
Antonio kindly brought this to attention recently.

Paper accepted for ODTUG Kaleidoscope 2009

Someone out there likes me, and I'll need to find out who. But the good news is that I get to share with the community some 'lessons learned' and case studies related to OWB. My paper was an early accptance to the ODTUG 2009 Kaleidoscope conference, and I am grateful for that. The list of people already accepted is quite an accomplished group. I sincerely hope that OWB 11gR2 is released and available by that point in time, as I will then get to discuss those new features along with 11gR1/1ogR2. Although the case study aspect will not be possible for 11gR2 since it is only in beta.

So come on out to ODTUG's 2009 confernece and find out how OWB can be put to some serious use...after all, we won the 2008 Oracle Partner of the Year Titan Award in Business Intelligence and OWB was a HUGE part of that.