Date -2007-10-03
Finds “Crucial Middle Ground” between MySQL and Oracle; Improves Overall Performance by 80%; Ends Price and Performance Tradeoffs
EDISON, N.J. Oct. 3, 2007 — EnterpriseDB announced today that its award-winning database powers GeoCommons, a popular destination Website that enables anyone to explore, create, and share geographic data and intelligent maps. GeoCommons was developed by FortiusOne, an emerging leader in next-generation intelligent mapping solutions.
FortiusOne migrated GeoCommons from MySQL to EnterpriseDB Advanced Server and improved overall system performance by 80%. EnterpriseDB Advanced Server is an enterprise-class relational database management system (RDBMS) that is based on PostgreSQL, the world’s most advanced open source database. EnterpriseDB Advanced Server provides the world-class data integrity, security, and performance necessary for enterprise environments at a small fraction of the cost of traditional enterprise databases.
GeoCommons houses a large geospatial database with more than two billion attributes, 35,000 variables, and 1,500 datasets. As a fast-growing startup, FortiusOne required a low-cost, powerful database solution to run GeoCommons. Originally, FortiusOne selected MySQL; however, when FortiusOne was preparing to deploy the first public beta of GeoCommons, they encountered major performance roadblocks.
“We slammed into a brick wall with MySQL,” said Chris Ingrassia, chief technology officer, FortiusOne. “As an example, MySQL’s rather limited and incomplete spatial support dramatically impacted performance. We were looking for an affordable database solution, but we required enterprise-class features and performance that MySQL simply couldn’t deliver. Plus, philosophically we want to support open source-based technologies like EnterpriseDB.”
PostGIS Geospatial Extensions Dramatically Improve Performance
The PostGIS geospatial extensions to PostgreSQL played a key role in FortiusOne’s selection of EnterpriseDB Advanced Server, a PostgreSQL-based solution, and dramatically improved performance. FortiusOne needed to run complex spatial queries against large datasets quickly and efficiently, and found the MySQL spatial extensions to be far less complete and comprehensive than PostGIS. EnterpriseDB Advanced Server processes some of GeoCommons’ database-intensive rendering requests in one-thirtieth of the time required by MySQL. During peak loads, GeoCommons processes more than one hundred thousand complex requests per hour, requiring true enterprise-class performance and scalability.
Another major factor in FortiusOne’s replacement of MySQL with EnterpriseDB Advanced Server was the company’s need for advanced partitioning, custom triggers, and functional indexing. EnterpriseDB’s advanced partitioning capabilities instantly enabled linear performance, even with tables having billions of rows.
“EnterpriseDB occupies that crucial middle ground between MySQL and Oracle,” continued Ingrassia. “EnterpriseDB is priced competitively with MySQL, but provides significantly better performance and advanced features you just don’t find in most open source databases.”
About EnterpriseDB Corporation
EnterpriseDB develops and supports EnterpriseDB Advanced Server, the world’s leading Oracle-compatible relational database management system (RDBMS). EnterpriseDB Advanced Server runs most applications written for Oracle unchanged and at a small fraction of Oracle’s cost. Built on PostgreSQL, the world’s most advanced open source database, EnterpriseDB Advanced Server has the reliability and scalability necessary for high-volume, mission-critical enterprise use. The company is also the world’s leading provider of enterprise-class, PostgreSQL-based products and services, including the EnterpriseDB Postgres distribution. EnterpriseDB has offices throughout North America, Europe, and Asia. The company was founded in March 2004 and is headquartered in Edison, N.J. For more information, please contact +1-732-331-1300 or visit https://www.enterprisedb.com.
# # #
EnterpriseDB is a trademark of EnterpriseDB Corporation. Other names may be trademarks of their respective owners.
Media Contacts :
Christian Danella
Prequent, Inc. (for EnterpriseDB Corporation)
christian@prequent.com
+1-415-441-6639 office
+1-415-350-4830 mobile