Login Register Actian.com  

Actian Community Blogs

Old
Rating: 2 votes, 5.00 average.

Accomplishments in OpenROAD Sprint at the 2012 German IUA (GIUA)

Posted 2012-10-23 at 11:57 AM by teresa
Updated 2012-11-12 at 12:59 PM by teresa (Updated with reference to the one Sprint project that didn't have a project page when article was first written)

Members of the OpenROAD development team and customers participated in an OpenROAD Sprint October 9–11 in Langen, Germany. It was Actian's first ever Sprint in Germany, and from all reports it was very successful. Here's what we accomplished.

Joe Kronk, Teresa King, and Bodo Bergmann thoroughly reviewed the OpenROAD Enhancement queue prior to the event, looking for potential projects that could be completed in our time together. Participants also suggested projects that would...
teresa's Avatar
Ingres Community
Posted in Ingres, OpenROAD
Views 2257 Comments 0 teresa is offline Edit Tags
Old
Rating: 3 votes, 5.00 average.

Surrogate Keys: Part 5, Pitfalls, Booby-Traps and the 1970s Resurrected

Posted 2013-04-05 at 05:04 AM by rhann
Updated 2013-10-09 at 08:19 AM by rhann

I'm almost finished ranting. For now.

So far I've shown that being scared of natural keys is about as grown-up and professional as being scared of balloon animals. I still need to show why properly diligent database designers must actively shun surrogate keys until they are absolutely unavoidable.

If you skipped Part 2 of this series of postings to get to the "juicy bits" you should go back and read it now.

I've already established the very...
rhann's Avatar
Ingres Community
Posted in Ingres
Views 3424 Comments 4 rhann is offline Edit Tags
Old
Rating: 2 votes, 5.00 average.

Quick-n-Dirty Debugging of Session Temporary Tables

Posted 2014-03-18 at 02:35 PM by rhann
Updated 2014-03-19 at 05:07 AM by rhann (Added note about calling Run_Monitor() directly)

I use session temporary tables a lot and sometimes I over-reach and end up having to figure out where it all went wrong.

This time my task involved a complex series of operations on five temporary tables culminating in a relational DIVIDE (which is not intuitive at the best of times). Something was going wrong somewhere and none of my clever guesses were correct.

Ideally I'd like to run the application with gdb to allow me pause to query the tables at various points...
rhann's Avatar
Ingres Community
Posted in Ingres
Views 4649 Comments 2 rhann is offline Edit Tags
Old
Rating: 2 votes, 5.00 average.

New Concise QEP Display Format

Posted 2014-05-27 at 04:19 AM by rhann
Updated 2014-05-28 at 09:19 AM by rhann (Added the update about the new distinctive label in SC930 logs)

Seeing its query execution plan (QEP) is essential to anyone attempting to undestand and improve the performance of a slow query. Anyone who has used Ingres for a little while will have discovered how to display and read a query execution plan like this:

Code:
QUERY PLAN 3,1, no timeout, of main query

                        K Join(customernr)
                        Heap
                        Pages 2 Tups 9
                        D569 C1425
...
rhann's Avatar
Ingres Community
Posted in Ingres
Views 5859 Comments 1 rhann is offline Edit Tags
Old
Rating: 2 votes, 4.50 average.

Accomplishments in OpenROAD Sprint at the 2011 UK IUA

Posted 2011-06-15 at 03:34 PM by teresa
Updated 2012-06-27 at 09:52 AM by teresa (updated with wiki project page links)

Members of the OpenROAD development team, Bodo Bergman, Brigitte Duplenne, and Joe Kronk along with Kim Ginnerup, Matt Rendell, Roy Deal Simon, and Oliver Oyston participated in an OpenROAD Sprint June 4th, 5th, and half-day on June 6th in Slough, UK. Fun and good times ensued while accomplishing a lot.

The OpenROAD Enhancement queue was thoroughly reviewed looking for potential projects that could completed in two days. Joe, being his usually overly optimistic and enthusiastic...
teresa's Avatar
Ingres Community
Posted in OpenROAD
Views 4741 Comments 0 teresa is offline Edit Tags
© 2011 Actian Corporation. All Rights Reserved