Login Register Actian.com  

Actian Community Blogs

Old

Want to learn more about OpenROAD and see what the team is up to?

Posted 4 Weeks Ago at 08:13 AM by teresa
Updated 4 Weeks Ago at 10:30 AM by teresa

Several members of the OpenROAD Engineering team will be running a code Sprint at the Thistle City Barbican hotel in London on June 8th, 9th, and half day on the 10th followed by the UK AUA 1-daytechnical conference on June 11th, at which there will be several OpenROAD Specific presentations.

Join the OpenROAD Sprint June 8th - 10th in London
Sprint projects tend to be 4GL projects as they can be implemented quickly. How do we determine the projects implemented at a sprint?...
teresa's Avatar
Ingres
Views 272 Comments 0 teresa is offline Edit Tags
Old

On Terminate event block in field scripts

Posted 2013-04-12 at 10:57 AM by teresa
Updated 2013-04-15 at 02:08 PM by teresa

On Terminate event is currently valid only in frame scripts. An enhancement request, SIR 122582, for this event to be valid in field scripts is under review for possible inclusion in a future release. In the meantime, an alternative solution is to write a facility in 4GL code that provides equivalent results to this proposed feature, one that even offers a more flexible and complete solution. This article describes alternative ways to implement this solution.

Problem

...
teresa's Avatar
Ingres
Posted in Ingres, OpenROAD
Views 403 Comments 0 teresa is offline Edit Tags
Old

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

Posted 2013-04-05 at 04:04 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 615 Comments 0 rhann is offline Edit Tags
Old

Surrogate Keys: Part 4, In Search of a Niche

Posted 2013-04-04 at 02:35 PM by rhann
Updated 2013-04-17 at 03:35 AM by rhann (Re-drew graphs and changed the descriptions accordingly.)

In the previous section I showed that natural keys—including composite natural keys—can perform fine. In my extensive experience they usually do.

There are exceptional cases when they don't do so well though, and so a surrogate key is justified.

A big VARCHAR key can be a problem when we try to use it as a physical key. For instance the biggest VARCHAR that can be used as a physical key in an Ingres B-tree is 1,000 characters. If your key is longer than...
rhann's Avatar
Ingres Community
Posted in Ingres
Views 350 Comments 0 rhann is offline Edit Tags
Old

Surrogate Keys: Part 3, Surrogates for Composites

Posted 2013-04-03 at 08:04 AM by rhann
Updated 2013-04-03 at 03:57 AM by rhann

If you made the effort to wade through part 2 of this series you have seen my claim that keys should be simple. Who could argue?

A simple key is one which is easy to use. It is easy to use if it is easy to think about and it performs well in the physical database. If the conceptual model leads naturally to a certain physical key in the database, and if the end-users who own the data are familiar and comfortable with it, and if it performs adequately, there is no reason not to use...
rhann's Avatar
Ingres Community
Posted in Ingres
Views 270 Comments 0 rhann is offline Edit Tags
© 2011 Actian Corporation. All Rights Reserved