Embeddable Database

The Limitations of the Embeddable Database

In the past, developers creating applications requiring data access have had a choice between using a relational or an embeddable database. An RDBMS is normally more robust and can deliver greater functionality. But they require greater administration and therefore increase deployment costs. The traditional embeddable database, on the other hand, is designed to have an exceptionally small footprint and link directly into the application. Because their existence was completely transparent to the end user the primary advantage of these embeddable databases is the simplicity of administration. But with Progress Software, developers no longer need to choose. Combining the power of a relational database with the low maintenance of an embeddable database, Progress® OpenEdge® provides an innovative solution.

Progress Software Delivers Powerful Alternative to the Embeddable Database

Progress® OpenEdge® provides a robust platform for the efficient and effective development, deployment and management of business-critical applications. An innovative component of this Progress platform, OpenEdge® RDBMS is a highly available solution that delivers both the superior and highly-flexible data storage capabilities of a relational database, as well as the extremely low maintenance features of an embeddable database. Self-configuring and self-optimizing capabilities simplify administration and maintenance so that most sites deploying OpenEdge RDBMS do not need a single DBA – just like an embeddable solution. With industry-leading performance, reliability and scalability, OpenEdge allows multiple clients to access the same data, allowing easy integration with SQL and Java applications. With online administration and backup tools, OpenEdge helps minimize planned downtime. Higher availability can be achieved through automatic crash recovery, cluster failover, advanced backup recovery and data replication. And OpenEdge RDBMS can easily deal with high traffic loads, thousands of simultaneous users and large database sizes.

Advantages Over the Embeddable Database

While OpenEdge RDBMS offers the same low-maintenance features of an embeddable database, it also delivers features that offer far more functionality. Three versions of OpenEdge RDBMS address critical storage and management issues:

• OpenEdge Personal RDBMS is designed for the single user and is ideal for PC-based users.
• OpenEdge Workgroup RDBMS is designed for small business environments with up to 50 users. It delivers a full function server at a price point attractive to midsize installations.
• OpenEdge Enterprise TDBMS is designed for the needs of midsize to large organizations. Offering the enhanced database scalability and scalability features needed to service thousands of users with huge database storage needs -- OpenEdge RDBMS Enterprise edition provides the ideal foundation for creating transaction processing, packaged or Web-based applications.

Learn more about Progress OpenEdge.