Login Register Actian.com  

Actian Community Blogs

Old

UK IUA 2011 Ingres Products Future Features Agenda Topic Was a Success

Posted 2011-06-10 at 01:18 PM by teresa
Updated 2011-06-10 at 04:43 PM by teresa

An exciting new agenda topic was added to the 2011 UK IUA this year allowing attendees to suggest and vote on features to add to the Ingres family of products. The Ingres family of products include but not limited to Ingres, OpenROAD, and VectorWise. This new informal gathering was very well received with so many suggestions that we ran out of time to discuss. Even if you were not able to bring your proposed feature before the group the ability to get your feature added to the list was still possible...
Ingres
Views 1429 Comments 0 teresa is offline Edit Tags
Old

Friday came early this week

Posted 2011-04-13 at 07:26 AM by rhann
Tags vectorwise


[Thanks to http://atom.smasher.org/highway/]
Attached Thumbnails
Click image for larger version

Name:	vw.JPG
Views:	914
Size:	60.8 KB
ID:	8  
rhann's Avatar
Ingres Community
Posted in VectorWise
Views 1407 Comments 2 rhann is online now Edit Tags
Old

Unleashing VectorWise on High-Performance Hardware

Posted 2010-07-03 at 02:49 AM by rhann

It's been about a month since I last posted anything about VectorWise. I have been rather distracted by the UK IUA conference on June 8, normal everyday work, life, but mostly by the project that I am writing about today.

This project started after I (frankly) hit the wall with the machine I've been writing about in my earlier postings. It was nice and fast for what it was, but some off-line emails made it clear people were less interested in breathing new life into systems assembled...
rhann's Avatar
Ingres Community
Posted in VectorWise
Views 15355 Comments 1 rhann is online now Edit Tags
Old

Flattening a query

Posted 2010-03-30 at 04:20 AM by rhann

So far, out of the 20 or 30 significantly complicated SELECT statements I've thrown at VectorWise, it has simply executed them. The most I've had to change is non-standard syntax like "LIMIT 50" at the end of the query to "FIRST 50" at the start.

Only one of the queries (originally intended for MySQL) has caused it to complain:
Code:
SELECT pj.project
FROM projects pj
     LEFT OUTER JOIN (SELECT DISTINCT ps.project_id AS pid
     FROM
...
rhann's Avatar
Ingres Community
Posted in VectorWise
Views 17514 Comments 4 rhann is online now Edit Tags
Old

Upgrade Day, and Creating Sample Datasets

Posted 2010-03-26 at 02:24 AM by rhann
Updated 2010-03-26 at 04:10 AM by rhann (improved clarity)

I've not posted anything for a few days, and it looks like today is going to be spent unloading my database so I can install VectorWise 1.0. As much as I've enjoyed playing with the 0.8 release, the extra features in 1.0 are too inviting to ignore, and besides, what would be the point of familiarizing myself with the features (and limitations) of a stale version?

I'm using unloaddb in the usual way. Most of the most frequently used utilities work with VectorWise, with only a few...
rhann's Avatar
Ingres Community
Posted in VectorWise
Views 18188 Comments 4 rhann is online now Edit Tags
© 2011 Actian Corporation. All Rights Reserved