Databases Archive

The newest version of MySQL AB's flagship open source database product includes new pluggable storage engines -- swappable components that offer the ability to add or remove storage engines from a live MySQL server. In this interview, MySQL expert Mike Hillyer gives a deeper explanation of this new feature and explains how it can benefit DBAs.

Oracle has just released the beta version of its free Express Edition database. This Oracle 10g Express Edition features a small download size, Windows and Linux native installers, and easy-to-use HTML DB interface to the database.

"MySQL 5.0.15, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages."

Is your IT team conducting an internal feud, with team members struggling against each other instead of fighting the real problems of limited time, money, and manpower to support your organization's technology needs? Buck Woody argues that you can't afford to become the Hatfields and McCoys. Also, both developers and DBAs have merit in the IT team. Although different, both jobs are crucial for a successful enterprise. However, conflicting responsibilities sometimes trigger members of the two related professions to face off. Baya Pavliashvili points out a few common situations that can cause tension between the two groups and provides some advice for working your way out of an argument before it leads to a war.

This article is for developers or testers interested in testing a database directly from their Rational Functional Tester scripts. The information is explained using examples and detailed instructions.

This chapter at InformIT covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing.

IBM DB2 Universal Database Enterprise Server Edition is designed to meet the relational database server needs of mid- to large-size businesses. It can be deployed on Linux, UNIX, or Windows servers of any size, from one CPU to hundreds of CPUs.

The Firebird Project is pleased to announce the release today of the second round of Firebird 2.0 public Alpha kits for immediate download and testing.

Two DB skills are better than one and can expand your potential compensation scale. If you've had experience with Oracle and now are starting or want to learn DB2 Universal Database, this article will help you leverage your previous experience and put you on the fast track for learning how to move data from one machine to another, or from one platform to another.

The mid-market is hot. It is forecasted to be the main growth segment in the IT market for the next few years. As such, it is fiercely contested by the major software makers. The BBC recently even called it a 60 billion dollar software battle. What exactly constitutes the mid-market is a bit vague, but some define it as businesses ranging from 50 to 1,000 employees.

The PostgreSQL project has been steadily clawing its way up the ladder in mindwidth since its inception almost ten years ago. Many say they've changed from MySQL to PostgreSQL and never looked back. OSDir recently had a chance to chat with a few of the project's dedicated developers.

Over the past several weeks, Tom Lane has been working on replacing our old Cache Management Alorithm (ARC) with a new, patent free one (2Q). In order to reduce the number of 8.x deployments out there that are using the old manager, they have just released 8.0.2, and encourage adminstrators to upgrade at their earliest convience.

This alpha release contains a large number of new features, including derived tables, support for Execute Block, increased table sizes, new improved index code (the 252-byte index length limit is no longer applicable), expression indices, numerous optimiser improvements, enhanced security features, support for on-line incremental backups along with many other improvements & bug fixes.

The PostgreSQL database project has recently released Version 8.0, which was received with quite some fanfare, mostly due to its first-ever Windows port. Mad Penguin talked with Josh Berkus, one of the core team members, to find out how 8.0 has fared since its official release on January 17, 2005.