Databases Target Enterprises

By Lisa Vaas  |  Posted 2002-12-02 Print this article Print

MySQL, PostgreSQL upgrade open-source products.

Two open-source database developers are upgrading their respective software in an effort to make them more attractive to the enterprise. Open-source database leader MySQL AB, of Uppsala, Sweden, this week will announce Version 4.0.5 of its namesake database with support for IBMs zSeries servers running the Linux and AIX operating systems.

While such support is already available elsewhere from individuals who took advantage of MySQLs open source code, the formal support will reassure conservative enterprise users who want to know that they have a professional service department to turn to for help if problems with the database arise, officials said.

Even though MySQL user CoreSense Inc. is not running the database on IBM servers, CEO Jason Jacobs welcomes the new support because it expands the pool of users contributing to open-source enhancements.

"The larger the user group, the better for all of us," said Jacobs, in New York. "[Enterprises are] going to look for something to be supported in order to bet their business on it."

Meanwhile, PostgreSQL Inc. last week rolled out PostgreSQL 7.3 with new features to appeal to enterprise users. New support for SQL schemata allows users to create objects in separate namespaces so that multiple people can have tables with the same names in a database.

This facilitates mobile users working in the same database, said company officials, in Wolfville, Nova Scotia.

Also new in Version 7.3 is a public schema for shared tables, which lets database administrators more easily restrict permissions for creating tables and indexes.

Use of table functions that return multiple rows or multiple columns was enhanced so that database administrators can call a table function in the "select from" clause, treating its output like a table.

PostgreSQL 7.3 adds the capability to return record sets and prepared queries—features that appeal to power users. This is a good way to get open-source software accepted in the enterprise, said PostgreSQL user Christopher Kings-Lynne, lead programmer for Family Health Network Pty Ltd.

"More and more enterprises will see PostgreSQL as a viable back end for their operation," said Kings-Lynne, in Perth, Australia.

Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel