Queensland Ingres User Group Events 2003

The Queensland Ingres User Group Inc meets the last Tuesday of each ‘odd’ numbered month.

All are welcome, however because we are a self-funded group, non-members will be encouraged to join.

The QIUG Management Committee tabled the following events for the 2003 calendar year:

25 November 2003	November Meeting Agenda Date: Wed 25th November 2003 Time: 3:30pm for a 3:45pm start Venue: Conference Room Level 5, AXA Building 144 Edward Street, Brisbane Agenda: SONAR - Auto-Discovery and Management of Business Processes by Stephen Wells of Computer Associates Sonar has been launched as a revolutionary new technology to discover and manage business processes. Sonar watches and analyses traffic on the network, and understands more than 1,700 protocols and information sources. It builds accurate maps and keeps those maps updated as resource allocations change. Using advanced analytics, Sonar also automatically detects inappropriate network traffic and usage. QIUG Annual General Meeting Business. Presentation of Annual Report Election of Office Bearers President Vice President Secretary Treasurer Members at Large (2) Drawing and presentation of Prizes. Lucky Door Prizes courtesy of CA Most meetings attended draw User presentations draw Questions and Answers CHRISTMAS PARTY! Networking and refreshments sponsored by your Computer Associates and your User Group.
29 September 2003	September Meeting Agenda Date: Wed 29th September 2003 Time: 3:30pm for a 3:45pm start Venue: Conference Room Level 5, AXA Building 144 Edward Street, Brisbane Agenda: SONAR - CA All Fusion: ERWin and INGRES by Dennis Doolette of Computer Associates The presentation will provide and overview of the CA AllFusion Application Life Cycle Management suite, and look in particular at the ErWin Schema Management Tools with respect to their use with Ingres. BUT WAIT, THERE'S MORE !!! - For those who attended, an ErWin / CA Fusion Resource Development Kit was provided for attendees to take home and try!!! CA World 2003 and the CARE Conference by Tony Shellshear of Software Design Consultants A brief overview of the highlights of the 2003 CARE Conference and CA World. What I Do? (15 mins) In this segment we invite members to tell us a little of what they do, and how they utilise the Ingres database in their work environment. This month's presentation will be - My Role in IT Services Keith Corlett - Natural Resources and Minerals. Keith will provide a brief rundown on his role at Natural Resources and Minerals and his involvement with the Ingres database in IT Services. Questions and Answers Networking and refreshments sponsored by Computer Associates and your User Group.
29 July 2003	July Meeting Agenda Date: Wed 29 July 2003 Time: 3:30pm for a 3:45pm start Venue: Conference Room Level 5, AXA Building 144 Edward Street, Brisbane Agenda: Very Large Database Management by Trevor Hames of Lower Case and Bob Logan of XSI Technologies The presentation will look at both the database management and hardware aspects of managing very large databases; data by the 'terabyte' and concurrent users by the thousands!  Trevor looked at the INGRES aspects, drawing on his experiences with Northern Telephone in the UK over the last few years. These will include:  § Overview; INGRES' ability to host VLDB's § Design and implementation issues § Storage architecture and layout § Loading and unloading data § DBA Issues § Performance issues § Concurrency Issues § Security Issues Bob will provide an insight into the new hardware technologies, particularly in the storage area, that have evolved to meet these large database demands; including -  § Current technologies available to host VLDB's and large data stores § An overview of how these work § Performance § Capacity  § Integrity  § Stability and Recovery  What I Do (10 mins) This segment introduced a new regular session we ran for several meetings, in which we invited members to tell us a little of what they do and how they used the INGRES database in their work environment. Teachers Registration Board Database Jason Rees - Queensland Teachers Registration Board. Jason shared with us his involvement in the INGRES database used to manage the registration details of teachers in Queensland. Questions and Answers Networking and refreshments sponsored by Computer Associates.
10 June 2003	June Meeting Agenda Date: Wed 10 June 2003 Time: 3:30pm for a 3:45pm start Venue: Conference Room Level 5, AXA Building 144 Edward Street, Brisbane Agenda: Spatial Data in a Corporate Database by Rod Thompson - NR&M With the major database vendors offering spatial data types and indexing techniques, the inclusion of spatial data in corporate databases is greatly simplified. However, the situation is not without its difficulties. The data types offered are by different vendors quite varied, and their behaviours even more so. In this talk, I will be discussing some of the traps and pitfalls that arise when attempting to store and retrieve geo-spatial data, with reference to the spatial data types offered by the major database vendors, and how they interact. Questions and Answer Session  (10 mins) Approaches to Crosstab Queries in Ingres Tony Shellshear - Software Design Consultants. Crosstab or Pivot Table queries involve essentially grouping the data in a column of a table based on its value, and then using these values to form new columns, under which the data from the other original columns in the first table is rolled, folded, summed and generally distorted to suit some particular objective. While tools like Access and Excel provide tools to do this, there is no 'TRANSFORM' function in 'real' SQL. Apart from making use of Reporting Tools such as Crystal Reports, how are users doing this with INGRES? Temporary tables? Nuclear proton reverberation gravimetrics? .... Sucking data into Access? Networking and refreshments sponsored by Computer Associates. Tips and Tricks As the Tips and Tricks presentations in 2002 proved very successful we continued with these in 2003.
25 March 2003	March Meeting Agenda Date: Wed 25th March 2003 Time: 3:30pm for a 3:45pm start Venue: Conference Room Level 5, AXA Building 144 Edward Street, Brisbane Agenda: New Support Initiatives for INGRES by Diane Allan - Computer Associates Diane Allan is the Manager - Support for CA's Advantage, Allfusion, Cleverpath and Unicenter Service Plus solutions.  Ingres and OpenROAD come under the Advantage brand. Diane will talk about the CA Technical Response Centre, the support organisation and new procedures. Also, Diane will introduce an exciting initiative from CA called 'SupportConnect' which will benefit all users. Findings of the QIUG User Survey Tony Shellshear - Software Design Consultants The QIUG User Group Committee have recently sent out (attached with this newsletter most likely!) a brief survey designed to determine what areas could be targeted for User Presentations during the coming year. This session will firstly present the results of this survey, and summarise the areas indicated as being of interest, and then encourage input from the floor in terms of comment and further suggestions as to subjects for technical presentations.

Meeting agendas of other years:

2008 Meetings

2007 Meetings

2006 Meetings

2005 Meetings

2004 Meetings

2002 Meetings

A Notice of Meeting is mailed to our members prior to each meeting. Click here for more information on membership.