Databases Archive
Submitted by MySQL 5.0: To Plug Or Not To Plug?
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: Free Express Edition Database Released in Beta
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 CEO: Partnerships Will Propel OSS Into Mainstream
In the business IT shop of the near future, open source software will gain equality with proprietary software, but it won't get there on its own power, said Marten Mickos, CEO of MySQL AB. "From the beginning, we have never been religious about open source. We think it's the most effective way to produce software, but we've always realized that there are vendors that will stay with closed source products. Our users live in the real world where both open source and closed source software have to work together."
MySQL 5.0.15 Released
"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."
DBAs vs. Developers: How to Collaborate
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.
Preview of the Firebird Conference 2005
In about six weeks time developers from all over the world will convene
in Prague for the 2005 edition of the
Firebird Conference. This year's conference has an even greater
abundance of speakers and topics than the previous editions of the event.
The various
tracks on the conference will cover Firebird itself, development
languages and solution stacks, development tools and issues and
applications. And, of course, it is a great opportunity to meet the
community.
Database Testing from Rational Scripts
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.
PostgreSQL SQL Syntax and Use
This chapter at InformIT covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing.
HSQLDB 1.8.0 Released
HSQLDB is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus SQL 99 and 2003 enhancements. It offers a small (less than 100k in one version for applets), fast database engine which offers both in-memory and disk-based tables and supports embedded and server modes.
Trial: DB2 Universal Database Enterprise Server Edition V8.2
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.
Firebird 2.0 Alpha 2 Released
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.
There is more to data access than SQL
The number and variety of computing devices in the environment are increasing rapidly. Real computers are no longer tethered to desktops or locked in server rooms. PDAs, highly mobile tablet and laptop devices, palmtop computers, and mobile telephony handsets now offer powerful platforms for the delivery of new applications and services. These devices are, however, only the tip of the iceberg. Hidden from sight are the many computing and network elements required to support the infrastructure that makes ubiquitous computing possible.
Easy DB2 skill building with Oracle experience
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.
Selecting a mid-market database
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.
MySQL for Linux on POWER and PowerPC servers
A Chat with PostgreSQL
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.
PostgreSQL 8.0.2 released with patent fix
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.
Sleepycat CEO Talks About Everything
SearchEnterpriseLinux.com recently caught up with Sleepycat Software Inc. CEO Mike Olson to find out what's new with open source Berkeley DB. In these excerpts from that conversation, Olsen talks about where Berkeley DB is positioned in the marketplace, and where it's going in terms of features and functionality. Also, Olson discusses why he thinks ever-evolving attitudes toward open source will make hybrid offerings lucrative. He then runs through an interesting "thought experimentation" to show what would happen if Microsoft ever decided to embrace open source.
Firebird SQL Server 2.0 Alpha-01 Release
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.