[Info-Ingres] Ammunition for managers. Previously RTF fields

[Database Administrator]

Robert writes...

Can anyone on the forum suggest some ammunition for managers who say we
must phase out ingres and openroad because they are not mainstream. Is
this happening elsewhere too.?

See full discussion here
http://groups.google.com/group/openr...d/thread/fa9c0
4c0a76edd9d
http://groups.google.com/group/openr...owse_thread/th
read/fa9c04c0a76edd9d>

Or navigate to
http://groups.google.com/group/openroad-users
and search for
RTF fields



Hi Robert,
Here is a little thing I put together some time ago for some of our IT
aware customers. The info is based on several articles published on the
internet. My thanks to previous writers too many to acknowledge here.
Acknowledgements also to Wikipedia org



Why Peercore prefers Ingres




By Paul White - Senior something or other




Introduction


This is not going to be a Ingres vs OtherDB discussion. For me it is an
easy choice. I currently maintain 5 different types of database systems
and I have lost count of how many types I've been involved with over the
last 25 years. Ingres is by far the best DBMS I have worked with.




Advantages


Here is what I perceive as Ingres advantages.



Ingres has been around since the 70s. Ingres is the father of databases
such as Sybase , Microsoft SQL
Server , NonStop SQL
Postgres and a number of
others. Incidentally, Sybase was rebranded in the 90s as "Microsoft SQL
Server".



It is OpenSource. Full source for the enterprise functionality is
available for download. The code includes the DBMS server, utilities and
the character based front-end and application development tools.
OpenROAD has also been released OpenSource "empire project"



We have one ingres DBA maintaining over 100 databases across around 10
sites and providing 2nd level support for another 50 sites. Ingres
databases just keep going and going.



Longest uptime I recorded was on Solaris 2.6 with 80+ users 24x7
manufacturing operation was over 400 days.



Flexible cheap licensing - real per machine license. No extra costs for
vmware installations, Or you can license per user or for a site. No
CALs required.



Ingres / OpenROAD have never been infected by a virus. We do see regular
security alerts / patches being issued which discuss potential flaws or
buffer overflow issues.



Easy to install and configure. You can be up and running in less than 5
min.



Multi platform Ingres runs on most types of Linux, Unix, VMS and
Windows. The full Enterprise functionality is available on all
platforms. Also take note that OpenROAD applications can run on
Microsoft and Unix/Linux platforms and, using Ingres technology, can run
over Ingres, Oracle, SQL Server or DB2 without changing code or
recompiling.



Ingres Support is world class. They use 24x7 follow the sun. It is all
packaged as part of the licence/ maintenance fee. They have experts in
Australia who speak English. The off shore support is not bad.



Ingres functionality is enterprise class, very mature and robust. You
get access to all the functions straight out of the box. You are not
limited to by number of connections, number of CPUs or database size.
There are no Developer or Demo versions. For an opensource product I
think that is pretty impressive.



The feature list is huge. I'm not going to cut/paste it here. Please go
check out ingres.com for the marketing blurb and feature comparisons.



>From my experience the most useful features are:



* Ability to rollback a database to a particular point in time.
This can be for the whole database, a table, or just an individual
transaction. The backup options are fully customiseable.
* Performance is superior. Ingres tables and indexes can be stored
as HEAP, BTREE, ISAM and HASH giving you detailed control over storage
parameters. This allows you to optimise DB operations.
* Low memory requirements. In my experience, Ingres uses a small
fraction compared to other DBMSs. You can control how much memory to
throw at each of the components such as DB Cache, Query storeage
facility, Relation Definition cache etc. At one site, an Ingres server
supporting Peercore Financials required less than 100Mb RAM was
converted to MSSQL where the memory requirements were nearly 1GB for
similar performance.

Currently, Ingres has more than 10,000 customers including 136 of the
Fortune 500 companies, 375 of the Global 2000 companies and a number of
public sector entities worldwide, including 3M, BAE Systems, Cypress
Semi-Conductor, Fujitsu, Lufthansa, and National Center for Missing &
Exploited Children.



Large and active user community around the world. Ingres Corp actively
encourages input and participation by its users. At the user forums,
there are often postings by the original architects of Ingres. Below are
some of the Ingres/OpenROAD users who have been active on the userlist.



eden.com.au Defence Force software suppliers

infor.com Huge erp software supplier with 70,000
clients

lotterywest.wa.gov.au

npower.com

bluescopesteel.com BHP

cevalogistics.com Formerly TNT logistics

usa.dupont.com

dhs.vic.gov.au Dept Human Services

revenue.ie Ireland revenue

vivista.co.uk

ing.com.au Bank

atosorigin.com

eds.com Consulting company (one of the largest in
the world)

ca.com Software giant

aeroint.com

barclays.co.uk

bt.com BT Global Services

ibm.com

its.unimelb.edu.au Student management system

lochard.com Aero industry

motorola.com

siemens.com

psd.defra.gsi.gov.uk

westernpower.com.au

catholic.edu.au

luminarysolutions.co.uk Software supplier

uk.atex.com

esprit-it.com.au Software supplier

fintechnix.com Software supplier

telstra.com



And Peercore customers:



peerlessfoods.com.au

iasbet.com

myworkplace.com.au

auspinners.com.au

CMCA

Egans Plant Hire

EA Hire

Delta Group

Canbet.com

Sporting Bet

Equiprent

And several new implementations underway.





Web References



http://en.wikipedia.org/wiki/Berkeley_Ingres_QUEL



http://en.wikipedia.org/wiki/Compari...base_managemen
t_systems



http://en.wikipedia.org/wiki/OpenROAD



http://en.allexperts.com/q/Ingres-33...-Vs-oracle.htm



http://searchoracle.techtarget.com/n...id41_gci102158
4,00.html#
<http://searchoracle.techtarget.com/n...sid41_gci10215
84,00.html>



http://broadspire-sjca.navisite.net/...IngresWhyUpgra
de2006Features-PS.pdf



http://www.ingres.com/products/ingres-database.php



http://www.qiug.org.au/






Recommended viewing


These presentations take from 60 minutes to 90 minutes and give you a
good introduction to our technology. For these and other interesting
presentations check out



http://www.ingres.com/customers/vip-archive.php





Hello OpenROAD!
<http://downloads.ingres.com/media/AV...0Hello%20OpenR
OAD!%20An%20Introduction%20to%20Rapid%20Applicatio n%20Development%20for%
20Ingres-20070419%200001.arf>
An Introduction to Rapid Application Development for Ingres Join Ingres
Architect David Tondreau as he explores the high-productivity world of
rapid application development in OpenROAD 2006. In this session, you'll
participate in an overview of OpenROAD to include an introduction to the
interactive development environment (IDE), forms development, the
object-oriented 4GL language, the debugger, build and deployment tools
and the OpenROAD Server.

Hello World!
<http://downloads.ingres.com/media/AV...llo%20World!%2
0Taking%20Ingres%20Data%20to%20the%20Web-20070426%200001.arf>
Taking Ingres Data to the Web Join Ingres Architect David Tondreau as he
provides the basics of getting Ingres data in the hands of the end-users
where it makes a difference. In this session, you'll learn the basics of
interacting with Ingres using common web scripting languages such as
ASP.NET, JavaScript and PHP.

Hello Ingres!
<http://downloads.ingres.com/media/AV...0Hello%20Ingre
s!%20%20A%20Multi-language%20Introduction%20to%20Ingres%20Applicatio n%20
Development-20070411%202359.arf>
A Multi-language Introduction to Ingres Application Development Join
Ingres Architect David Tondreau as he provides an interactive "Getting
Started" guide to application development using the Ingres stack. In
this session you'll learn everything you need to know to get started
building applications on the world's preeminant open source database.
David will cover the basics of installing Ingres and the Ingres tools,
creating a database and tables and writing small applets in Java, C#,
ABF and OpenROAD that interact with the database.