Free Sybase Enterprise Database

Blane Warrene
Blane Warrene

In the opening salvo of a competitive marketing campaign, Sybase announced last Wednesday the release of an Express Edition of its flagship enterprise database product, Adaptive Server Enterprise, for the Linux community.

This is great news for web developers of all stripes as it is the only free robust database on the marketplace with full support for ANSI compliance for SQL, full-featured stored procedures and triggers and hooks for Java, .Net and XML among other web services.

Clearly Sybase is not open source. However, many web professionals suffice with MySQL and PostgreSQL, which I endorse myself as excellent production tools. However, both have lagged in bringing features to the same level as proprietary competitors. Being that Sybase is offering the free database server for production — I would encourage developers to evaluate it (after all it does not cost you anything!). To our benefit, we may find that it raises the bar and encourages speedier development of these anticipated functions from MySQL and others on the open source side.

Sybase competitors Oracle and IBM offer developer licenses, however, none provide a production license without cost. Sybase’s Express Edition has a 2 GB RAM and 5 GB disk database storage limit though that should be plenty of room for many web applications.

David Jacobson, senior director of database and tools marketing at Sybase, said the goal is to entice people to try ASE.

“We see our market in three segments, those running open source solutions, those on IBM and Oracle databases and those running Microsoft SQL Server,” Jacobson said.

“This is a way to help customers get a single CPU development and production server running as pilots,” Jacobson said, which should also help those with needs that exceed the free license limits evaluate ASE without cost.

This also has positive implications for those running the Macintosh platform due to the intersection of Linux and the PowerPC architecture courtesy of Terra Soft Solutions, makers of Yellow Dog Linux (YDL). Terra Soft recently released YDL 4.0, supporting the latest G5 systems from Apple.

Although Sybase guidelines suggest the Adaptive Server Enterprise (ASE) Express Edition install is certified for Intel-based Linux distributions, both OS X and Yellow Dog Linux on Apple hardware have the capability of meeting minimum requirements. Sybase’s commercial versions of ASE natively support OS X.

Apple platform users may find the Sybase solution workable with the G5 Xserve, which comes optimized for data-driven solutions, especially those built for the Web architecture.

The Xserve comes ready-made with LDAP, the Apache Web server and a JBoss/Tomcat combo of Java application servers, all engines that can interact with ASE.

Growth Potential:
Gartner DataQuest statistics show that Sybase reaped $90 million in license revenues in each of the Windows and Unix marketplaces in 2003. In the Linux sector, the company was dwarfed by IBM and Oracle, who together accounted for more than 95 percent of Linux database license revenues in 2003.

According to Amit Satoor, senior group marketing manager at Sybase, his company is setting itself apart from other free offerings via the aforementioned ANSI compliance and a roadmap to high availability capabilities.

It must be noted that MySQL recently released clustering technology, though it is not yet been a year and may be considered unproven.

Jacobson said Sybase will go head to head against its core competitors, IBM and Oracle, with aggressive pricing.

Roadmap to Real Time Data Services:
The Express Edition does not include support. Customers can purchase a service package, if needed, with the download for just over $2,000. Additionally, the company hopes it will draw in users who might grow and migrate to multiple CPU and cluster deployments.

This would expand capabilities to include mirror activator for redundancy and dynamic archiving to ease data access and storage management that can come into play when using multiple database servers.

Pricing for additional licensing beyond the Express Edition, which has 2 GB of memory and a 5 GB storage limit, starts at $4,995 per CPU for small business and $24,995 for enterprise licenses.

Frequently Asked Questions (FAQs) about Sybase Enterprise Database

What is the Sybase Enterprise Database?

Sybase Enterprise Database is a high-performance relational database management system designed to handle large volumes of data and transactions in enterprise environments. It offers robust security, scalability, and reliability features, making it a preferred choice for businesses that require uninterrupted access to their data.

How does Sybase Enterprise Database compare to other databases?

Sybase Enterprise Database stands out for its high performance, scalability, and robust security features. It is designed to handle large volumes of data and transactions, making it ideal for businesses that require uninterrupted access to their data. Compared to other databases, Sybase offers advanced features like real-time operational analytics, advanced security, and high availability.

What are the key features of Sybase Enterprise Database?

Sybase Enterprise Database offers several key features including high availability, disaster recovery, real-time operational analytics, and advanced security. It also provides a scalable, high-performance platform for developing and deploying applications.

How does Sybase Enterprise Database ensure data security?

Sybase Enterprise Database offers advanced security features to protect your data. These include encryption, role-based access control, and auditing capabilities. These features help ensure that your data is secure, both at rest and in transit.

Can Sybase Enterprise Database handle big data?

Yes, Sybase Enterprise Database is designed to handle big data. It offers high scalability and performance, making it capable of managing large volumes of data and transactions.

How does Sybase Enterprise Database support real-time operational analytics?

Sybase Enterprise Database supports real-time operational analytics by providing a high-performance platform that can process large volumes of data in real-time. This allows businesses to gain insights from their data as it is being generated.

What is the role of Sybase Enterprise Database in disaster recovery?

Sybase Enterprise Database offers robust disaster recovery features. It provides high availability and failover capabilities, ensuring that your data is always accessible, even in the event of a system failure.

How does Sybase Enterprise Database support application development and deployment?

Sybase Enterprise Database provides a scalable, high-performance platform for developing and deploying applications. It supports a wide range of programming languages and frameworks, making it a versatile choice for application development.

Is Sybase Enterprise Database suitable for cloud environments?

Yes, Sybase Enterprise Database is suitable for cloud environments. It offers features like scalability, high availability, and robust security, making it a good choice for businesses looking to leverage the benefits of cloud computing.

How does Sybase Enterprise Database ensure high availability?

Sybase Enterprise Database ensures high availability through its robust failover capabilities. In the event of a system failure, it can automatically switch to a standby system, ensuring that your data is always accessible.