Open Source Database Posted on: January 30, 2008 at 12:00 AM
To date, there has been no easy way to benchmark the performance of a database system.
Open Source Database
Open Source Database Benchmark To date, there has been no easy way to benchmark the performance of a database system. The choices were
1. Hire a consulting group specializing in benchmarks
2. Purchase the rights to one of the important SPEC or TPC benchmarks, and staff a group to implement and run the tests
3. Review the results of published benchmarks and extrapolate them to your situation
4. Create your own benchmark suite
The cost of the first two options is well-justified in some cases. If one is about to spend ten million dollars on computer infrastructure (in addition to the cost of staffing, developing, and maintaining the application for which the project is being undertaken), spending one million dollars to confirm that you are about to make the right choice is very sensible.
Database For New Millennium
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful langu
age support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981. Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000 under the InterBase Public License v.1.0.
An Open Source Java Database One$DB is an Open Source version of Daffodil DB, our commercial Java Database. One$DB is a standards based (JDBC 3.0 and SQL 99 compliant), platform independent, footprint size database that can be embedded into any application and requires zero or minimal administration. Daffodil DB is the first Java database that has shown the capability to take on enterprise databases with its high performance in real time environments, Compiere compatibility being the best example so far. One$DB is exactly the same as Daffodil DB barring a few features and has been made available in both Embedded and Network editions.
Open-Source Database Technologies Microsoft can snipe all it wants at the TCO and security of open source, but a flood of database-, BI- and data-center-related news coming out of LinuxWorld means one thing: Linux has drilled so far down into overall IT frameworks that it's simply another option on the short list. Commercialization of open source is one trend evident at LinuxWorld Conference & Expo, and it's being reflected big-time in database- centric offerings. We're seeing the notion that open-source products have a very, very viable business model and have established themselves as credible players," said Steve O'Grady, an analyst at RedMonk. "While they don't play in exactly the same markets and don't compete feature-to-feature with proprietary, there's a sizable market that's not interested in all the bells and whistles included with proprietary vendors.
Open source database projects together The OSDBC was formed at the first Open Source Database Conference (OpenDBCon) last year in Germany. According to Zak Greant, who was the lead organizer of OpenDBCon and who with Arjen Lenz of MySQL helped get the OSDBC off the ground, the idea behind the consortium is to share information between the various open source database projects that can help improve "the entire class of free software/open source database solutions. Historically, PostgreSQL and MySQL have been seen as rivals, but Josh Berkus, PostgreSQL Core Team member, says that the project developers are willing to set differences aside to deal with common problems. "Rivalry between projects isn't going to stand in the way of sharing important security information.
Open Source Database Program for PalmOS Pilot-DB is a freeware (OpenSource) database program for the Palm OS (any version and any hardware) and compares with the best commercial programs available. It supports the field types string, boolean, integer, float, calculated, date, time, note, list and link. Plug-Ins are available for Mobile-DB and JFile databases, for access to the built-in DateBook, for external memory card access and for customizable colours. Overlays are available for various occidental and oriental languages Download the latest versions of Pilot-DB here. All versions that have been available can be be found here. There are various third-party tools to create, edit, and export PilotDB-files or to import various formats such as CSV, Excel, ASCII files and Staroffice files on the desktop.
Oracle unveils open source database tool
Oracle and PHP tools maker Zend Technologies are working on an open source development tool for Oracle databases. Due in the third quarter, the free solution, called Zend Core for Oracle, will provide integration between the Oracle database and Zend's PHP (PHP Hypertext Preprocessor) environment. PHP is a scripting language that helps accelerate development on applications like databases. Zend had previously signed a similar agreement with IBM to support development in its database products. The latest offering will be available from the Oracle Technology Network and Zend will sell related support services.
OSD - Will Proprietary Databases Survive The recent announcement that Pervasive was throwing its weight behind PostgreSQL, as an open source offering, was interesting for two reasons. First of all, Pervasive already had a successful database product ? Pervasive SQL - which has strong traction among ISVs.The Open Source database market appears to be getting crowded. This is a new phenomenon for Open Source. Usually there is only one product in play from the Open Source community. Admittedly there are exceptions ? the most obvious being the existence of two desktop GUIs, Gnome and KDE, but in general you'd think that the nature of Open Source itself would naturally lead to products coalescing rather than competing. This hasn't happened with database and there is a good reason for it. Databases are fundamentally data retrieval engines and the value of any given product lies to some degree in the architecture of its engine.
EnterpriseDB upgrades open-source database EnterpriseDB has released an upgrade to its open-source database that comes with a newer code base and an open-source reporting tool called Jasper Reports. EnterpriseDB 2005 Release 2 is based on PostgreSQL Version 8.0.4, the most recent version of the open-source code upon which EnterpriseDB is built. It also comes with a new cursor structure that more closely resembles that of Oracle (Profile, Products, Articles), EnterpriseDB said. Like its open-source rival MySQL, EnterpriseDB tries to make its database appear like Oracle's to administrators in the hope of encouraging migrations. Other changes include faster bulk data loading capabilities and several bug fixes and performance tweaks, said EnterpriseDB, of Edison, New Jersey.
Open-source database over Oracle Sony Online Entertainment Inc. is starting to move away from the Oracle databases that are the foundation of its online games, opting instead for a 2-year-old commercial open-source database based on PostgreSQL. San Diego-based Sony Online offers a number of popular Massively Multiplayer Online Role-Playing Games, or MMORPGs, including EverQuest, EverQuest 2, Star Wars Galaxies and others. They have "hundreds of thousands" of subscribers, said Rick Herman, vice president of business and legal affairs at Sony Online Entertainment. The databases store terabytes of data about the "worlds" in which game characters live. Sony Online now operates more than 150 Oracle 9i databases around the world. But by midyear, Sony Online expects to have three services moved to EnterpriseDB?s Advanced Server 8.1 database, according to Chris Yates, the company?s vice president of technology.
Open source database firm gets webMethods infusion The ex-webMethods crew at PostgreSQL database start-up EnterpriseDB has added to their numbers with a fresh board appointment. WebMethods board member Jack Lewis has been elected to the EnterpriseDB board to bring 35-years' experience in legal and business development to the young company. Lewis joins webMethods founder and former chief executive Phillip Merrick on the EnterpriseDB board, along with former webMethods vice president Andy Astor who is EnterpriseDB's founder and CEO. The appointment is designed to enhance EnterpriseDB's future prospects and comes as competition in the open source database market picks up. EnterpriseDB joins MySQL from the open source end of the spectrum.