The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the tag “agile development”

Live from the 1st Annual World Wide Data Vault Consortium: Day 3

Well it was the last day of the 1st annual WWDVC. What an event is has been. (See recap of Day 1 and Day 2, here and here)

The sign outside the meeting room

The sign outside the meeting room

Don’t forget you can see all the action by searching on #WWDVC on twitter.

Agility and Data Vault

Long time data vault advocate Tom Breur opened our closing day with a talk about how we should strive to build the right product and build it right without creating more technical debt in the process.

He said agile is about taking small steps not about being faster. If we do this right, the solution we deliver should generate more legitimate business requirements.

He encouraged us all to read the Theory of Constraints and The Goal (I have), and to learn about lean delivery. Our goal should be to deliver continuously and consistently. The shorter the sprint, the better.

Next he went on to tell us his conclusion that while building a Kimball based solution may appear to deliver more value to the business, it takes too long. And in the end it is a fragile and rigid solution subject to major re-work when requirements change after deployment.

We can deliver value, quicker, using the data vault method. And what we deliver can be done incrementally and more easily added to without re-work.

Tom drew this to show how much quicker we can deliver some value sooner

Tom drew this to show how much quicker we can deliver some value sooner

Data Vault Case Studies

John Sells and Josh Bartells from Data Blueprint shared with us their experiences implementing data vault solutions for their clients.

John and Josh several successful DV projects

John and Josh share several successful DV projects

Why Data Blueprint decided to use DV as their consulting

Why Data Blueprint decided to use DV as their consulting

The gujys from DataBlueprint discuss hurdles and objections they encountered selling DV to clients

The guys from DataBlueprint discuss hurdles and objections they encountered selling DV to clients

It was great to hear about their success stories from the field and see how they addressed the challenges many of us have faced.

Data Vault Modeling Tool

MID GmbH from Germany has a pretty nice modeling tool with built in capabilities to support modeling a data vault solution from stage tables through reporting (including using the new DV icons).

Nice ability to visually show relationships across diagram types

Nice ability to visually show relationships across diagram types

MID's modeler has nice diagram to show all sorts of metadata relationships

MID’s modeler has nice diagram to show all sorts of metadata relationships

This is a tool worth checking out if you are doing a lot of data vault modeling.

Concluding Remarks

Dan closed out this inaugural event with a few remarks, some memories, thanks, and talk about plans for doing this again next year.

Dan closes out the 1st Annual WWDVC and asks about next year - where and when?

Dan closes out the 1st Annual WWDVC and asks about next year – where and when?

Guess I need to be careful what I say! :-)

Guess I need to be careful what I say! 🙂

One last time I have to say I am glad I came and can’t wait to do it again next year!

Snowy St Albans

Snowy St Albans

So long for now from Vermont.

Don’t forget to check out LearnDataVault.com and get ready to join us next year!

Kent

KScope13 Day Five: C’est Fini!

Yes, the last day of the conference arrived. Many folks got a bit of a slow start as they recovered from the prior evenings festivities (but that is true almost any day in the French Quarter!).

Morning Chi Gung was smaller but still a respectable turnout of 14 people. Some of my participants had already started their trek home, others just could not quite get up… c’est la vie.

Morning Chi Gung participants practicing a  still stance meditation and breathing exercise.

Morning Chi Gung participants practicing a still stance meditation and breathing exercise.

The KScope Social Network

My first session on this final day was Charles Elliott from Rittman Mead, discussing how to do Social Network Analysis with Oracle Tools. He discussion centered around using R and a graphing tool called D2 (www.d3js.org).

Network analysis of KScope contributors and influencers across two tracks.

Network analysis of KScope contributors and influencers across two tracks.

Charles had mined some data (from twitter I think) and then charted some of the connections to determine who were the major influencers related to KScope13 and several of our tracks. My name is up there, but I am a very small dot. You might be able to see in the picture a pretty big dot which is Gwen Shapira, who was not even at the conference this year!

Looks like very cool tech. Not sure where I would use it (yet).

Agile Case Study?

One session I was not too happy with was this one. It was titled as an agile implementation success story but it was (IMO) a veiled pitch for a free addin to SQL Developer.

The entire presentation was a statement of issues in trying to do version control of database objects. And they were all legitimate issues. But there was no case study of a specific project and how they tried to solve the problem. The solution was a product from the speaker’s company that they have developed as an add in to SQL Developer to allow you to control database object check in and check out at the database level.

Nice idea. Looks like it will work.

But, the product is not even available today! It will be release later this summer and is free for up to five users (then I assume it will cost $$).

My beef is that this should have been clearly labeled as a vendor presentation not as a “success” story.

More Crossover

For my last session I went to Stewart Bryson and Edward Roske’s presentation on Innovation in BI: Oracle Business Intelligence Against Essbase & Relational.

This was a great collaborative effort between these two guys who work for companies that might be considered competitors. I am pretty sure this is a KScope first (in many ways).

A KScope 1st: Stewart Bryson and Edward Roske do a joint presentation on using OBIEE against both Essbase and a relation data warehouse at the same time.

A KScope 1st: Stewart Bryson and Edward Roske do a joint presentation on using OBIEE against both Essbase and a relation data warehouse at the same time.

In the end, after some demonstrations of how to do this, they guys left us with a really nice comparison chart on when to use which tool and its relative effectiveness in solving specific problems.

Edward and Stewart came up with this nice chart trying to compare the two technologies on a number of features and functions.

Edward and Stewart came up with this nice chart trying to compare the two technologies on a number of features and functions.

Nice job guys!

C’est Fini

A relatively new KScope tradition is to hold a final closing general session. Here we say farewell to the event and the city with some slides and humorous videos from the week.

We also get to learn who the top five speakers were for the event (as ranked by session evaluations) and who the speaker of the year winner is.

This year the Best Speaker Award went to Edward (don’t call me Ed!) Roske from InterRel.

There was also an award for the best Kscope Ambassador (the one who helped with the most sessions). This went to Mark Becerra.

Congratulations to both!

Attendees at the KScope13 closing session with their KScope14 travel mugs

Attendees at the KScope13 closing session with their KScope14 travel mugs

As a final note we got a great little video welcoming KScope14 to Seattle.

The even bigger news was that we already have sponsors for the 2014 event! Platinum, gold, and sliver level sponsors have already signed! Plus a boat load of exhibitors.

We must be doing something right that they have secured their spot a year in advance.

We have come a long way baby!

The website for Kscope14 is up and running. You can register, submit an abstract, and make your hotel reservation for next year.

So head on over there now while you are thinking of it!  KScope14.com

One Last Shot

I can’t end this series without at least one picture of the great food here in New Orleans. I did eat well!

Ending the conference on a high note with blueberry upside down cake at celebrity chef Emeril Lagasse's restaurant NOLA in the French Quarter.

Ending the conference on a high note with blueberry upside down cake at celebrity chef Emeril Lagasse’s restaurant NOLA in the French Quarter.

See you in Seattle (if not sooner)!

Kent

The Oracle Data Warrior

Oracle Designer Lives!

Amazing as it seems, I picked this article up on Twitter today.

An up to date, current, and NEW article about automating builds of applications from the Oracle Designer repository.

How very agile…

Thanks to all the gang over at AMIS (http://technology.amis.nl/) for keeping the technology alive and for being innovative enough to adapt it for the modern agile development world.

Running Oracle Designer Generation from Ant and Hudson

Introduction

Oracle Designer is a windows client-server development tool that is meant to be manually operated by a developer. Anyone trying to integrate Designer with an automatic build environment will find that it does not provide an API or a commandline version to kick-off any generation automatically.

There is however a hook that can be exploited by generating so-called GBU files directly from the Designer Repository. These GBU files are then fed to an executable called dwzrun61.exe that executes the actual generation of DDL scripts and forms.

This article describes how this can be done using examples from a real world situation. It shows how to generate the GBU files, the different strategies that can be followed and some of the pitfalls you might run into trying to pull this off yourself.

The code of the program we wrote can be found on here and is free to be adjusted to fit any other situation than ours.

via Running Oracle Designer Generation from Ant and Hudson.

If you want to meet some of the guys from AMIS and pick their brains, be sure to sign up for KScope13 and come meet them live in person.

See you there.

Kent

Post Navigation

%d bloggers like this: