![searchDatabase]() ![This Week]() |
![]() |
![]() |
|
|
In this Issue |
![]() |
![]()
![]()
|
|
From the Editor: |
![]() |
![]()
![]()
by Tim DiChiara, Editor
![]()
Your thoughts on the re-birth of Ingres continue to flow into my Inbox.
A few weeks ago, I asked for your thoughts about the newly open-sourced Ingres. The response was immediate and voluminous. Ingres fans came out of the virtual woodwork to voice their support for the venerable DBMS.
Here is some more of your feedback:
Erich S. writes: "I worked with Ingres from the late 80's to the
mid-90's, most of that time as a DBA. It was a wonderful
database and for the most part during that time light -- years
ahead of Oracle in terms of features and quality of platform.
In particular it had a cost-based optimizer years before
Oracle. On the other hand, it had page-level locking long
after Oracle had row-level locks; many folks believe this
was the downfall of Ingres. I doubt it is that simple, but
perhaps has more to do with good technology always losing
against good marketing, a theme demonstrated over in over in
the computer industry."
Gregory W. writes: "We have used Ingres on our 24/7 system for the last 6 years (running on Solaris) and in that time we have never had a downtime greater than 4 hours, using only a part time DBA (1 day a week) because the database is so robust."
Marc S. writes: "Ingres has good SQL support, a great B-tree table structure, and a good documentation set. It will certainly get a lot of interest among open source developers because it's a strong dbms, from the ground up...[However,] OpenROAD is far behind Java and C#...and it's IDE (aka the Workbench) is so contra-productive, you'd better hope that you never have to use it."
Jon G. writes: " If I was looking to install an enterprise level DBMS into a new environment, would I choose Ingres over Oracle? Yes, without hesitation, unless the business model demanded a particular feature that Oracle had an advantage. Ingres may have been left behind during its ASK ownership and the early years under CA but those that have stuck with it are about to reap the rewards - low cost ownership with high quality productivity! Oracle will have to watch Ingres carefully
over the next 2 years."
Chris W. writes: "To date, "open source" has largely been synonymous with "Linux". I believe CA's open sourcing of Ingres on any platform will enhance the open source movement, which will undoubtedly further raise the level of acceptance of open source in the boardrooms around the world."
Disk G. writes: "I must admit to not having the pleasure of working with Ingres in the past. On the other hand, if there's something that can give MySQL a spanking I'm all for it. It gets under my skin when someone puts a pile of trash on the table & tries to convince everyone that it's gold just because it slides easier."
There is little doubt that there is a wellspring of anti-Big 3 sentiment out there, waiting to be tapped by the likes of CA, Sybase, MySQL, PostgreSQL, Progress, and others. For more information, check our our Featured Topic this week, which lists some of the recent news, analyses, tips, and expert advice we've amassed on the "best of the rest."
Till next week, Tim
|
![]()
|
|
Featured Topic: |
![]() |
![]()
Beyond the Big 3
by Tim DiChiara, Senior Site Editor
![]()
There is life beyond the big three DBMS vendors! Sybase, MySQL,
and others have found significant niches in enterprise IT. Our
collection of news, tips, and expert advice has all the info you
need about the "best of the rest."
![]()
Read more about this topic
|
![]()
|
|
Expert Technical Advice: |
![]() |
![]()
![]()
Featured Expert Rudy Limeback, Web and SQL Design Consultant, r937.com
Category: SQL
Rudy has worked with commercial databases since the mid-1970's, starting with IDMS, a Codasyl network system, and progressing through IBM's DB2 and Microsoft's SQL Server relational databases. He has developed data warehouses and transactional databases, always with an emphasis on making them easy to use for developers and end users alike. He specializes in writing SQL statements that are simple and easy to maintain. Rudy now operates r937.com, developing databases for use with dynamic Web
sites. Ask him your tough SQL questions!
![]()
Ask Rudy a question
|
![]()
![]()
| Tip of the Week: |
DB2 database design and principles of peak performance
Many design decisions made early during the development process can have a significant influence on the performance of your DB2 applications and databases. This article provides some general guidelines and recommendations for achieving better DB2 performance in z/OS environments. |
| >> |
Read the full tip |
![]()
|
|
Site Highlights |
![]() |
![]()
![]() |
Download SearchDatabase.com's free chapter excerpts!
Check out chapters and tips written by leading industry
experts, including David Martineau, Steve Sanyal, Kevin Gashyna, and
Mike Kyprianou's "DB2 Programming Strategies", Ian Foster and Carl
Kesselman's "The Grid: Blueprint for a new computing infrastructure" and
more.
Visit the SearchDatabase.com Chapter Download Library
![]()
Sign up for the SQL Tips newsletter
Get expert advice on Microsoft SQL Server development,
management, migration and more. Log in to SearchDatabase.com and edit your newsletter subscriptions to sign up for our "SQL Sever Tips"
newsletter.
Activate your subscription now!
|
![]() |
![]() |
![]() |
Check out SearchDatabase.com's collection of Learning Guides
Browse our collection of learning guides
Get the help you need to solve all of your database problems. Browse our collection of learning guides and get answers to all of your DB2, SQL and Oracle problems.
|
![]() |
![]()
|
![]() |
![]()
![]() |
|
Resources for database pros
|
![]() |
| Select newsletters you would like to receive from the list below. |
![]() |
|
Small Business IT Tech Tip |
|
E-Business Suite Update |
|
DB2 Tips |
|
![]() |
E-mail
|
|
|
| Not a member? We'll activate your membership with your subscription. |
![]() |
|
|
![]()
| TDWI in Orlando |
| Attend TDWI World Conference in Orlando, Oct. 31-Nov. 5,
where you will have access to full-day BI/DW training, a special BI
Strategies program, our CBIP certification program and more. |
![]() Register today! |
|
![]()
![]()
| Security Checklists |
| Read Roberta Bragg's Windows Security Checklists on
SearchWindowsSecurity.com and get tips on setting up, hardening and
maintaining security in Windows environments. |
![]() View checklists |
|
![]()
| Data analysis & BI |
| Looking for white papers on data analysis and business intelligence? Check out SearchDatabase.com's White Paper Library and
download such titles as "Building the Adaptive Enterprise" and more. |
![]() Browse papers |
|
![]()
|
![]() |
![]() |
|
