• DB Geek says: Twitter Weekly Updates for 2009-05-24 http://tinyurl.com/p6md6s #
• Blog Talk: Comment by “Yasser Mohd” on Learn PL/SQL: Procedures and Functions http://tinyurl.com/qvvw75 #
• Blog Talk: Comment by Yasser Mohd on Learn PL/SQL: Procedures and Functions http://tinyurl.com/qguv8l #
• Cloud Post: Using and Managing AWS – Part 6: SSH Key Pairs: http://tinyurl.com/poffz3 #
• Blog Talk: Comment by kaleesh on What is the difference between Oracle, SQL and PL/SQL? http://tinyurl.com/phfpnr #
• Blog Comments: Comment on Ora_Tweet – Tweet From Oracle, A PL/SQL Twitter API by Barry Cooper: Hi .. http://tinyurl.com/mr5z75 #
• Blogged “Part 2 of Data Mart Design” http://it.toolbox.com/trd/46/2/31935/3/ #
• Blogged “PL/JSON v0.6.2 on SourceForge” http://it.toolbox.com/trd/46/2/31936/3/ #
• Blogged “PuTTY and SSH for Newbies” http://it.toolbox.com/trd/46/2/31937/3/ #
• @oraclenerd Can’t do rac in aws.

• DB Geek says: Twitter Weekly Updates for 2009-05-17 http://tinyurl.com/ogkrhx #
• RT @msutic Public Oracle Yum server http://public-yum.oracle.com/ works great. Finally I don’t have to bother searching for various packages #
• Cloud Comments: Comment on Amazon Web Services – Amazon DevPay by Gary: “billed desperately”
  Don.. http://tinyurl.com/p75mqj #
• Cloud Comments: Comment on Amazon Web Services – Amazon DevPay by Lew: heh. I guess sometimes it’.. http://tinyurl.com/pn2tl4 #
• DB Geek says: Designing the Data Mart – Part 2 http://tinyurl.com/oenjj5 #
• Blog Comments: Comment on Designing the Data Mart – Part 1 by Designing the Data Mart – Part 2 | D..

Continuing from Part 1.

So now we have our transactional model and a basic user story:

Our first request from the business for our data mart is that they want to be able to query all of the orders by date, by customer and/or by region (state, city or country). They want to be able to aggregate (sum and average) across those items.

The first thing we need to do is talk to the business and find out exactly what that request means. Do the users want to see information about daily orders in general?

• DB Geek says: Twitter Weekly Updates for 2009-05-10 http://tinyurl.com/otrppu #
• Playing with FreeNAS and iSCSI today. Very nice! #
• My life is now complete. @evernote The 3 words you’ve wanted to hear us say: Evernote…for…BlackBerry http://twurl.nl/0vtn6a #
• @oraclenerd Yep, That’s me, Eddie Awad, Arup Nanda, Mark Rittman, Tim Hall and Brad Brown. We did a BOF at OOW’08. in reply to oraclenerd #
• @oraclenerd Birds of a feather. in reply to oraclenerd #
• I played Men At Work:Who can it be now for my 6 year old. He now has it stuck in his head and can’t stop singing it.

As I mentioned a while back (a loooong while back), I have been thinking about writing up how I design data marts. The problem with that is that it is a huge topic. Even converting an existing schema (which doesn’t always exist) to a data mart (star schema style), still takes plenty of behind the scenes data analysis and prepwork. Still, I am not going to take a shot at it.

I could start with a laundry list of requirements but I don’t think that would be interesting to very many people.

• DB Geek says: Twitter Weekly Updates for 2009-05-03 http://tinyurl.com/cg2ew3 #
• This week is a week of documentation and data analysis. #
• @dannorris Hey, congrats! I tried to post a congrats on your blog but my corporate firewall blocks disqus. #
• RT @TheOnion Nation Ready To Be Lied To About Economy Again http://bit.ly/wV7Zh #
• If you’re not getting enough swine flu info via @cdcflu, the news, radio, etc, you can get it on your mobile: http://m.cdc.gov #
• @topperge A 2 hour lunch every day? I went into the wrong business. in reply to topperge #
• Another day of data analysis and documentation. I’ve already been crazy productive today!

It was pointed out to me that I had a few errors in the previous release.  Those have been fixed and the install should go a lot smoother now.  No additional functionality here, just bug fixes.  If you tweaked the previous release to install it, you don’t need this one.

As always, you can download the new code directly from the PL/JSON SourceForge page.

Change Log:

Version: 0.6.2
Fixed exit commands in various code files
Removed the “CREATE OR REPLACE” on the string_handler.printf function

Version: 0.6.1
Added missing string_handler package

Version: 0.6
Added support for creating JSON from text input

Version 0.5
Initial release
Includes a JSON data type
Can create tables and columns of JSON
Supports API creation of JSON data type

LewisC

• DB Geek says: Twitter Weekly Updates for 2009-04-26 http://tinyurl.com/d8c5od #
• Blog Talk: Comment by garcia phillip on 10 Things About Telecommuting Everyone Should Know http://tinyurl.com/cgg7yn #
• Blog Talk: Comment by “Brian Tkatch” on What is the difference between Oracle, SQL and PL/SQL? http://tinyurl.com/cv9v9f #
• Gave my son his netbook yesterday (for b-day). Totally unimpressed. Said he wanted a toy instead. ;-( #
• @jfroebe The wife claimed it. in reply to jfroebe #
• @jpiwowar He’ll start the next pirate bay. heh in reply to jpiwowar #
• @oraclenerd No he’s spolied. Just kidding. I hope they grow out of it. Very frustrating. in reply to oraclenerd #
• Awful but funny.