KScope13 Day Three: Crossing Over in New Orleans

Well Tuesday was another fun and fact filled day at the annual ODTUG KScope conference in New Orleans.

As we do each morning, the first event is Morning Chi Gung. This morning the group grew again to 22 participants who met at 6:45 AM (yes it is early) to walk down the street a few blocks to get in some morning moving meditation. Today we even picked up a few “strays” who joined us (folks not part of the KScope event).

Only in New Orleans would people wander by and join an Ad Hoc exercise and meditation class.

I consider that a sign of success. 🙂

After that is was back to the hotel, breakfast, a quick shower, then my first session.

Hands-on Lab

To start off I went to the SQL Developer Hands-on Lab run by Oracle Product Managers Jeff Smith and Ashley Chen. We had a very nice lab (downloadable from OTN) on how to use SQL Developer for Tuning database queries.

It was very education and useful for me. I even learned a few new options in the tool I had not seen before.

Lunch and Learn

Next, after writing yesterday’s blog post, I got to participate it an ODTUG annual session – the BI Panel Lunch and Learn.

This year they improved it by allowing 30 minutes first for everyone to eat before we started the discussions and questions. Much better (at least for us panelists!).

We had a great and interactive session with lots of give and take and a few somewhat controversial comments from Dan Vlamis to liven things up a bit. Our esteemed moderator, Mark Rittman, did an excellent job of prompting us with relevant questions and controlling the flow of the conversation so everyone had their say. Rounding out the panel was Gurcan Orchan, our resident ODI expert (amoung many other things)

Data modeling sessions

After the panel I went on to see my friend Ashely Chen introduce people to SQL Developer Data Modeler in her Data Modeling 101 session.

Ashley dd a great job setting the stage by showing people what is meant by data modeling and how it fits in the life cycle of developing a database. She then showed many of the basic features of Oracle Data modeling tool.

After Ashley’s session then I had my final presentation on my Top 10 Cool Features in SQL Developer Data Modeler. Ashley and Jeff Smith both attended along with 20-30 other folks as I ran down my list of things I use and like in the tool.

The talk went well with some good questions about the product and how to use it (except for the fact I kinda ran out of time and had to rush the last 3 features). I got some great feedback from Jeff and Ashley on the talk and an excellent suggestion for my next talk. 😉

The Hyperion Crossover Session

This was a KScope first -sessions about topics aimed at people on the other side of the fence. So this session was for database people who know nothing about the Hyperion and Essbase products that Oracle acquired a few years back.

It was an excellent session, even if not highly attended (something about being after the happy hour in the exhibit hall perhaps?).

I learned that they are solving many of the same problems as we database people do but just with a different technology. Some of the terms are used a little differently. For example what they label as BI is much broader than I tend to think of – to them it is basic reporting against an ERP. I tend to associate BI with a data warehouse or a data mart (but the data comes from an ERP or operational system originally).

We also got a full list of some of the pre-packased applications that Oracle provides in this space. Very focused on financial solutions.

The really cool thing I learned was what Essbase stands for:

Extended SpreadSheet dataBASE

Very telling!

After that it was off to another fine dining experience in the French Quarter.

Probably not going to lose weight on this trip!

C’ya! Tomorrow I should be reporting on our big event!

Kent