David Gornshtein and Boris Tamarkin of WisdomForce Technologies, Inc have written a very current technical white paper providing a comparison between MSSQL 2005 and Oracle 10g. It also discusses new features developed by Microsoft in order to compete with the Oracle database, and considers factors from the DBA’s perspective.
A new version of OPR (Oracle Password Repository) is out on beta. OPR is a Unix based secure tool for storage and retrieval of Oracle database passwords that replaces hardcoded passwords in scripts with a call to OPR. It is designed to keep your Oracle environment secure and easier to maintain.
Hot on the heels of Fyracle, Oracle-mode Firebird, there’s now a similar project for PostgreSQL. EnterpriseDB 2005 (EDB2005) is now available in beta. Compatible with many Oracle database applications, EDB2005 is an enterprise-class relational database management system that supports update-intensive high-volume applications.
According to Gartner, Inc., worldwide new license sales for relational database management systems (RDBMS) grew 10.3 percent in 2004 for a total of $7.8 billion. As far as new license revenue, Oracle and IBM landed in a virtual tie. IBM’s DB2 had nearly 9 percent growth in sales on the Z Series and Unix platforms, whereas Oracle saw nearly 15 percent growth, largely due to its performance on the Linux platform
Although database vendors have claimed for years that their relational offering supports unstructured XML data, IBM’s upcoming Viper release of DB2 may be the first to truly allow structured and unstructured data to maintain their respective native formats and be queried using SQL or XQuery statements.
According to analysts at Gartner Symposium ITxpo 2005, Oracle remains the dominant database vendor, but will face challenges as it tries to expand its middleware and applications sales. The slightest misstep when trying to merge its recent acquisitions will only serve to benefit its key competitor, SAP. Gartner analysts also predict that Oracle’s Fusion framework will be ready a year later than promised, which won’t help the company’s disjointed image.
Although many are eagerly anticipating Oracle Database 10g release 2, some pros feel the new automated features will only create more work in the long run. A group of DBAs got a preview of the new 10g release 2 at the IOUG conference in Orlando. Reponses ranged from excitement to trepidation. Also at IOUG and prompted by the ever-increasing automation, DBAs participated in a debate over the question: Are DBAs needed anymore?
Doug Burns has written a great paper on parallel execution and posted it in his weblog.
New York-based research firm Vault, who conducts employee surveys designed to provide investors and job seekers insight in to a company’s business operations, has received mixed reviews from Oracle employees on the company’s future. One employee called the amount of money spent on the applications division “a waste of resources”, while another says the business applications “kill a great deal of productivity.” Vault’s .
Oracle has licensed the Xythos Drive from Xythos Software to improve integration between the Windows Desktop and Oracle Server products, specifically Oracle Files 10g and Oracle Portal.