;) |
|
|
In this Issue |
|
|
|
From the Editor: |
|
by Tim DiChiara, Site Editor
There is indeed life beyond the big three DBMS vendors.
Last week, I asked users of legacy and niche database management systems to answer one question: why? Why do you forsake the big three? Is it just too expensive or complex to migrate legacy data? Do small niche products better serve your specific industry than Oracle, DB2, or SQL Server? Are you planning on migrating to one of the big three, or are you satisfied with what you have?
Apparently, many of you are indeed satisfied. Here's a sampling of your thoughts:
- Gary Hyla is a happy customer of the venerable mainframe DBMS CCA Model 204, which has been around for an amazing thirty years. He writes: "CCA has kept pace with current technology, allowing their high transaction processing capabilities to be enhanced with products and new paradigms as they became available...including XML. Overall, our needs are met sufficiently."
- "Big L" was happy, but now is being forced to upgrade: "We are abandoning perfectly good systems and spending millions to get everything in our company over to Oracle. We have existing systems using AS/400 DB2 and Sybase that are being scrapped because the hype has convinced our management that Oracle is going to rule the world and if we aren't using Oracle we're doomed!"
- "Devbravo" notes that "legacy systems" are really just "systems that exhibit 99.9 % uptime and have well thought out backup and recovery support systems." IBM's IMS database is still around, he notes, because "it's just a whole hell of a lot faster that DB2 or Oracle."
- Others, like member "Chillout," are using niche products and want to convert to Oracle, but can't: "We are running Peregrine P4 for our HelpDesk. It is easier for reporting than Oracle but it seems to be impossible to do the conversion."
- Member "Bill" has used Sybase and Oracle and prefers the latter, with one caveat: "The utilities that come with Oracle are much more advanced and flexible than Sybase but they may not be worth the extra you have to pay!"
- "PHoran" begs to differ: "Don't ignore Sybase... SQL Anywhere has the best price/performance curve of any of the "departmental" size databases, and it totally dominates the mobile/embedded space. They really have some impressive products, top to bottom."
Thanks again to all those who sent me their thoughts. If you'd still like to offer your two cents about using, integrating, or updating legacy/niche databases, email me at: [EMAIL PROTECTED]
Cheers, Tim
|
|
|
Featured Topic: |
|
Data quality
by Tim DiChiara, Site Editor
Clean, useful, and accurate data translate directly to the bottom line for most companies. It makes the life of the DBA easier too. Our collection of news and analysis has all you need to know about data quality and cleansing...
Read more about this topic
|
|
|
Expert Technical Advice: |
|
Featured Expert Ian Abramson, CTO, Ian Abramson Systems Inc.
Categories:Data warehousing
Ian is the founder of IAS, Inc, which has built
a fourteen year reputation for delivering high quality Data
Warehouse and Oracle systems to clients around the world.
Ian is also the co-author of several Oracle books, is
currently the Director of Education Programming for the
International Oracle User Group, and is well-known for his
seminars and technical training classes. Ask Ian your tough
Data Warehousing questions!
View all Ian's answers
|
|
This Week: In the forums
|
| >> |
Export MySQL data
Member "Sam" is wondering if anybody knows how
to export all the data (records) of MySQL to a text file in
Linux system by using the xterminal window? Go to our "DBA
Water Cooler" forum if you can help Sam figure out the
problem.
|
| >> |
What have you done about data quality?
We're putting together an article here on SearchDatabase about how different companies are approaching the issue of data quality. Are you wasting lots of time and money trying to fix your bad data? Have you gone to a data
quality company for help? We want to hear your stories! Go
to our "DBA Water Cooler" forum if you have any opinions and
experiences. |
| Tip of the Week: |
| This Oracle tip, along with another recent
submission "Optimal size of rollback segments," generated a
lot of feedback--mostly negative! You rated them poorly, and
your modifications exceeded the value of the original tips.
Check out what your peers had to say, and send in your own
constuctive criticism! |
| >> |
Tuning the database cache hit ratio |
|
|
Site Highlights |
|
|
|
| SearchSecurity News |
| To be uninformed of IT Security issues is not an option. Subscribe to the SearchSecurity Daily News for a comprehensive daily report on the news you need to know. |
|
Subscription
|
|
| Exclusive Download |
| Gain insight from Bill Inmon in his SearchDatabase exclusive white paper, "Analytics: Ten Critical Success Factors." |
|
Check it out
|
|
| SQL Server Tips |
| Receive helpful SQL Server Tips directly to your inbox. Why spend time looking for a tip? Subscribe today and save time. |
|
Subscribe Here
|
|
|
|
