OpenOffice Packs a Powerful New Database Punch

 
 
By Lisa Vaas  |  Posted 2005-10-21 Email Print this article Print
 
 
 
 
 
 
 

The stand-alone database in OpenOffice.org's latest update is powerful enough to be compared to Microsoft's popular Access database.

OpenOffice.orgs latest update includes a database that matches Microsofts popular and competing Access database, experts say. "Its definitely a big deal," said Stephen OGrady, an analyst at the IT analysis firm RedMonk. "Now with the [OpenOffice.org Base], although I have not evaluated it to the extent that I can call it 100 percent at functional parity with Access, the interface is just as usable as Access. Its quite nice." The first office application suite to feature native support for the OASIS-approved OpenDocument file format was released Thursday morning, one week following the projects fifth anniversary of its founding and after a delay caused by "show-stopping" software bugs.
Specifically, the database power within RC3 is OpenOffice.org Base, the first version of a stand-alone database to debut in the open-source office suite.
Click here to read more about why OpenOffice.org 2.0 may be ready to take on Microsoft Office. OpenOffice.org has been focused on developing other components of its suite to compete with proprietary offerings from Microsoft Corp. et al., such as its word processor, spreadsheet and presentation manager programs. The stand-alone database rounds out the offering by bringing long-missing, important database power to users. Users will be able to create stand-alone databases, associated forms, reports and queries, much as with Microsofts extremely popular and widely used Access database.
According to documentation on Version 2.0s new features found on OpenOffice.orgs site, users have long been pestering the community for database support. "One of the most annoying things is that people ask on the OpenOffice.org lists, Does OpenOffice.org also support databases?" according to the site. "This has been the case since the first release." The problem wasnt that OpenOffice.org lacked a database. In fact, OpenOffice.org 1.1 supported dBASE (.dbf) databases without no additional software required. For more advanced requirements, OpenOffice.org 1.1 supported the MySQL database natively, or any database, for that matter, through ODBC and JDBC drivers. Read details here about OASIS approval of OpendDocument, the OpenOffice.org file format. "Weve always had a database element and were always surprised people didnt know it," said Louis Suarez-Potts, an OpenOffice.org community manager. The community saw that there was a need for a more prominent module, as well as a need to hook up with a specific database that could meet most peoples needs, Suarez-Potts said. "The problem is that the database part of OpenOffice.org was not that intuitive to find and the approach of data sources was hard to understand," according to the OpenOffice.orgs new features documentation. "Another point is that the current implementation is too development-specific, resulting in the normal user not recognizing the intention of the links in a data source. This has to be changed." RedMonks OGrady concurred. "The database capabilities they had before were not the equivalent of a Microsoft Office," he said. The lack, he said, was mostly "from an interface and front-end perspective." Next Page: OpenOffice.orgs new database capabilities.



 
 
 
 
Lisa Vaas is News Editor/Operations for eWEEK.com 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 eWEEK.com, 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























 
 
 
 
 
 
 
 
 
 
 
Thanks for your registration, follow us on our social networks to keep up-to-date
Rocket Fuel