Archive for the ‘Ingres Database’ Category

Ingres Engineering Summit - From the user side ….

Wednesday, April 30th, 2008

I saw this post on one of the Ingres mailing list and thought others might be interested in hearing what Roy Hann (UK IUA President)  had to say about the recent Ingres Engineering Summit .—-Original Message—–From: Roy Hann

Sent: Wednesday, 30 April 2008 2:51 AM

Subject: [Info-Ingres] Ingres Engineering Summit

Nobody has yet posted any report of the Ingres Engineering Summit anywhere, so I thought I’d report a few bits and pieces that captured my attention.

First of all, it was an open event, as befits an open source company.

Anyone was welcome to attend and a great many partners (and others) did. I don’t know the total headcount but considering it was a moderately expensive week and a long time out of the office, it was very well attended. I’d guess there were well over 100 people there.

The amount of openness demonstrated was impressive. It wasn’t just about exposing the code, it was also about exposing the thinking, the working practices, the people, and–yes–the tensions. With the exception of a one-hour slot that was employees-only, everything was out in the open.

Anyone who didn’t attend has missed out on a lot. Plan to attend next year.

Just running through the agenda from top to bottom, and focussing just on Ingres rather than OpenROAD, here are some highlights:

Andrew Ross did a one hour presentation that covered a lot of ground on the general theme of “community development”, and more precisely, the barriers to community development and what has to change to make it easier/possible.

As we all know, there was a lot standing in our way, and there is a long way to go still. However the need for a properly open process was as taken as given. As well as reporting a lot of progress with things like http://code.ingres.com (Subversion code repository), http://lxr.ingres.com (code cross-referencer), and http://bugs.ingres.com (bug tracking), Andrew also outlined a number of as-yet unresolved problems. I think I’ll leave it to Andrew to elaborate on those, but the big one (IMO) is the communication channels. Mike Sale, Mike Leo and I have been discussing this too. One thing we agree on is that the current phpBB-based Ingres forums are an embarrassment and have to go (real soon if I have my way). Mike Leo’s suggestion of using vBulletin turns out to be top of the list at Ingres too, so that could happen fairly quickly. There are several benefits to vBulletin but the big one is that it will allow us to have a single community delivered via web pages, e-mail, or NNTP, so that we can accommodate everyone’s way of working. IRC will of course remain separate.Another big item from Andrew’s presentation is that there are actually two fairly successful virtual development systems about ready for delivery. We should be able to get our hands on these within a week or so.I won’t dwell on the rest of the presentations in such detail. You can infer the significance of these topics appearing on the agenda as well as I can.We had a number of demos of things like Ingres Café and some OpenGIS software. There was a presentation from Gordon Thorpe on the formidable challenge of re-architecting GCA. Hugh Darwen spoke about Project D (an implementation of Tutorial D on top of Ingres) and earned himself the second prize for Best Presentation. We had two presentations on column stores, one of which went on to win the first prize Best Presentation (Marcin Zukowski on Monet/x100). Karl spoke fluently about something or other for an hour and many of us marvelled. Mike Touloumtzis led a discussion about how to implement column encryption; nothing was decided but a lot of ground was explored. Steve Ball and Alison Stillway led another discussion on how to implement MVCC and which model of MVCC to adopt; nothing was decided except that a design document will be drafted for public comment. (To my mind this may be the most immediately and widely useful enhancement that popped up on the new-features radar.) Emma McGrattan picked up where Andrew Ross left off. The big thing in her presentation was the carefully expressed and several-times repeated instruction that Ingres Corp requires all its personnel to devote 10% of their time to community projects (i.e. 1/2 day per week). That is a lot of effort folk! After Emma, Kai-Uwe Sattler talked about some research into making Ingres more autonomous and self-tuning (including the ability to recommend secondary indices and statistics). There were two presentations on two different replicators from partner companies. Roger Whitcomb told us about the work he’s been doing on Ingres Management Tools, which was really good stuff. (I was present at the meeting where VDBA was first unveiled back circa 1995 and it was greeted with horror and revulsion then, and nothing has changed. Roger’s work is definitely going in the right direction this time.) After this I stepped out of server-land and saw Daryl Monge discussing Ruby on Rails. For some reason every head in the room turned to look at me when he reminded us that RoR requires every table to have a synthetic integer key. Evidently everyone understands this is wicked and wrong and that they should feel guilty about it, but equally evidently people are just going to go on doing it anyway. That was enough for me, so I retreated back to server-land again after that.

So there you are. I saw fewer than half the presentations, so perhaps someone else will comment on the others.

Finally , I am hoping to get at least a couple of these repeated at the IUA conference on June 17 in London. Please let me know if there is anything above that particularly takes your fancy and I will see what I can do.

Roy

Inside the Community - Ingres style….

Tuesday, April 22nd, 2008

Today is day one at the Ingres Engineering Summit being held in Punta Cana (Dominican Republic) with a  cross section of folks from across the Ingres engineering, support/ service, Product Management teams as well as a number of contributors from the Ingres open source community.  Amazing the number of people here and the tenure they have around Ingres - I think the winner from the community has 24 years using Ingres ( he started using Ingres on VAX - wow!!) . We also have a number of newbies to Ingres from various universities and it’s great to have them here as well.

The agenda is loaded with pretty cool topics that range from demos from DMSolutions (GIS) and Ingres CAFE,  application development using Ingres CAFE and OpenROAD,  Google Summer of code work, Datallegro contributions,  open sessions with Ingres Janitor’s Project just to name a few. Lots of good debate on code repositories and various new ideas to get engaged with. I was talking with one of partners here at the Summit - Karl from Datallegro and he is speaking later and has several hundred submissions in queue.. Great job Karl. Great seeing the blog from Datallegro on line as well.

 Later this week we have a codefest planned, lots of after hours activities and yes you can’t go to Punta Cana with out some team building event - rumor is it is building a sand castle and best design wins not sure what …. That ought to be loads of fun with a bunch of really technical dbms guys.  Any hardware design guys in the house????

/deb woods

OpenVMS Cluster Beta Now Available!

Wednesday, April 16th, 2008

Great news from our engineering teams!  We have just posted a Beta release of Ingres 2006 Release 2 SP1 for OpenVMS Clusters.  This is a completely re-architected cluster solution for OpenVMS Alpha Clusters that provides significantly higher scalability than earlier versions of Ingres.  This version of Ingres runs on OpenVMS 8.2 and 8.3. 

Our OpenVMS engineering team  has done a terrific job implementing a new Distributed Lock Manager and putting this new release through it’s paces.  Along with providing our OpenVMS customers with this long awaited release, the team has also helped drive significant quality improvement across all our platforms with this effort.

To test drive this new beta release for OpenVMS clusters, download it at:

http://www.ingres.com/downloads/community-editions.php  

 If you have any questions, please feel free to contact me at: christine.normile@ingres.com

Establishing trust with your open source community

Wednesday, April 16th, 2008

Yesterday was kind of a bummer for open source communities everywhere. We saw an open source company (MySQL) compromising the trust they have with their community. MySQL announced that they will only offer certain features to paying customers. Take a look at Jeremy’s blog for more commentary. They have forked their community release and one must now wonder what goes next. Building creditability is always a difficult task for one to achieve. It takes hard work every day, building innovative, robust products, adding value in everything you do, responding to customer queries, and doing what you say you will do. The latter being most important - open source is about open code. It is about sharing your work so others can contribute, use, provide feedback, etc.

At Ingres, we are working very hard to grow and build our community. We are always looking for guidance and new ideas on how to build a robust community. We have a number of activities underway with various universities, partners, customers, users and are looking for more each day. I worked at Red Hat for years where knowledge was always plentiful and we never compromised our creditability with our community. This is a trait we are building at Ingres as well. The industry has responded over the years with a strong vote of support for the open source model and it is surprising and sad to see MySQL take such a turn.

/deb woods

Ingres puts on a Red Hat..

Monday, April 14th, 2008

There have been quite a few changes over at the Red Hat Exchange and in keeping up with some old friends we decided it was time to join the Exchange. Red Hat Exchange is a great place for open source companies to share information and to ‘mingle’ with other open source solutions. Customers can visit the site and get some good information about the various players in the open source space and see the solutions that are available. The Exchange first started out as a web only support offering with no Enterprise support - it just didn’t fit our model. We have worked with Red Hat on a number of key projects like building high available solutions using  the GFS clustering product as well as robust application development platforms with  JBoss, it is only natural that we sign up to the Exchange. Hope to see you guys there..

/deb woods

Ingres Support for Internet Protocol Version 6 (IPv6)

Wednesday, April 2nd, 2008

IPv6 is the “next generation” protocol designed by the IETF to replace the current version Internet Protocol, IP Version 4 (”IPv4″).   While IPv6 is “next generation”, for many Ingres customers, it needs to be addressed today.  One of our customers recently sent us some questions that many others may have as well.  So I decided to post my answers here as well.  If you have any additional questions or comments, please feel free to post a comment here or to send me an e-mail at Christine.Normile@ingres.com

  1. Will Ingres Database support IPv6? (Y/N) If so, what product version is required? Ingres 2006 Release 2 and higher support IPv6.  IPv6 is not supported with earlier versions of the Ingres database such as version 2.6  
  2. Does Ingres Database run under an OS which supports IPv6 (if applicable)? Ingres 2006 Release 2 and higher is available for a wide array of hardware and operating system platforms.  Many of these have already been IPv6 enabled.  The table below lists the platforms Ingres 2006 runs on.

cert-table.gif

  1. Does Ingres Database support services or features that collect, handle, process, store, display (e.g., screen pages, printouts) any IPv4 address today (from customer, from network, from anywhere)?

·       Does Ingres Database store or forward any IP address information? Ingres stores IP information only for the duration of a session to facilitate communication between our processes and the IP address.  IP information is neither stored or forwarded by Ingres for any purpose other than support of the communications protocol.

·       Does Ingres Database have any hard-coded IPv4 addresses (e.g., for system calls)? No.

  1. Is IPv6 required for Ingres Database’s network communications protocol? i.e., does the computer machine(s) hosting Ingres Database require IPv6 to communicate with customers/services/CPE machines (that will use only IPv6 addresses), or may the host machines continue to exclusively use their IPv4 addresses? (You may assume the IT network and computer machines will continue to support IPv4 within the company for a long time.)   Ingres 2006 Release 2 and higher handle mixed IPv6/IPv4 networks transparently.  Host machines can continue to exclusively use their IPv4 addresses to allow for a staged implementation of IPv6.
  2. Is Ingres Database used to manage or collect data from network elements that carry IP-based traffic? Ingres 2006 can be used to manage and collect data from network elements that carry IP-based traffic.  It is, however, a general purpose relational database management system and any such use of Ingres Database would be as a result of the application using Ingres 2006.
  3. Is Ingres Database impacted due to changes in devices that will only run IPv6 (e.g., CPE, Mobility devices)?  No, Ingres 2006 Release 2 and higher can support IPv6 only devices, IPv4 only devices, devices that support either IPv4 or IPv6 or any combination thereof.

For more information on IPv6 and Ingres 2006, check out Bruce Lunford’s VIP Webinar in the VIP Webinar Archive (http://www.ingres.com/customers/vip-archive.php) under Connecting with Ingres.

Ingres Open Source Style

Monday, March 31st, 2008

In case you missed Andrew Ross’ presentation on how to get started contributing to Ingres, I wanted to share the link to the webinar. You can find it in the Ingres DBMS section entitled Ingres Open Source Community. The VIP archive page has a wealth of information on how to get started with Ingres, upcoming release information and future direction. Sign up to get invites to future sessions.

Andrew does a great job walking through some of the tools that Ingres is now using to help users i.e.

  • view source (LXR)

http://lxr.ingres.com

  • How to create a  work area

svn co http://code.ingres.com/ingres/main~/ingres-main

  • To raise a bug to the Ingres community

http://bugs.ingres.com

  • Looking for more on Ingres

http://groups.google.com/group/comp.databases.ingres/topics

deb woods

Ingres CAFE - Writing web applications w/ Eclipse

Tuesday, March 18th, 2008

Over the past year we have had quite a bit of interest in the Eclipse dtp bundle and this has spurred interest in building an integrated developer’s stack. Ingres CAFE is such a project that was spearheaded by Samrat Dhillon, a graduate student at Carleton University in Ottawa.


Ingres CAFE bundles the Eclipse IDE, Ingres Database, Apache Tomcat, Hibernate Libraries, and JSF libraries into a single installable package complete with documentation and integrated maintenance. There is also a demo included to help developers get started with the tool.

Check out Ingres CAFE and let us know what you think and future developer tools you would like to see working with Ingres.

Great job to the students at Carleton University in Ottawa, Canada.

deb woods

ANSI Date Type in latest Ingres Release

Saturday, September 8th, 2007

There was a new date type introduced in Ingres 2006 update release 2 that brings Ingres date types into alignment with the ANSI standard. As noted in a previous blog entry, you can definitely search our docs to get all the info you need, but I also found this nice hands on blog entry.

Ingres Documentation Best Practices

Tuesday, September 4th, 2007

A number of months ago we moved did a bit of work to take our latest documentation for the Ingres database and make it more accessible. At first we were just going to take the direct output of the documentation tool we use, but we wanted to make it dead simple to find and bookmark the docs without having to deal with frames and computer generated file names. To accomplish this feat, Andy took the XML output from the tool and threw some python at it and we’ve ended up with http://docs.ingres.com. As Ingres releases new documentation, we’ll be pushing it all out to this site for your easy access.

One of the really nice side benefits of putting out documentation out this way is the capability to use search to find just what you’re looking for. I’ll show you how to search our documentation using our own site, using google along with some tricks and tips for using google, and using our new Ingres Service Network platform currently available to our customers.

The first way to search is to use the search integrated with our web site found in the upper right corner embedded in the header. In particular, you’ll find a way to integrate this search engine right into your browser. I’ve included a short screencast to demonstrate this feature here (no audio).

While you will usually find that the search function on the Ingres web site is more then sufficient, I thought I would share with you a few tips and tricks I use with Google and the Ingres doc set.

(more…)


Close
E-mail It