Sybase Updates SQL Anywhere Database
The beta release of Version 10 promises better performance, new backup features
Computerworld - The iAnywhere Solutions Inc. unit of Sybase Inc. today starts shipping a beta release of Version 10 of its SQL Anywhere embeddable database, which promises improved performance and new backup features.
The SQL Anywhere beta comes nearly three years after SQL Anywhere 9 became available, said Breck Carter, a database consultant at Rising-Road Professional Services in Toronto and author of a SQL Anywhere manual.
The typical gap between releases of the database has been 18 months, he said.
Uno Money Transfers runs SQL Anywhere as its corporate database on Microsoft Corp.'s Windows Server 2003 operating system. SQL Anywhere manages the Miami-based financial services firm's 40GB database, which handles all of its international money transfers, according to Luiz Paulo, vice president of technology at the company.
Paulo said he plans to upgrade to the new version to use its new data-mirroring capabilities for safe backups and for its intraquery parallel-computing feature, which will speed transactions on Uno's four-way Xeon server.
The new version of the data-base also adds encryption capabilities, support for materialized views for faster access, new performance-analysis tools for developers and the ability to split up large queries among multiple proc-essors, said Chris Kleiseth, iAnywhere's senior director of engineering. Version 10 also adds integration with Microsoft's Visual Studio .Net 2.0 environment and support for the Symbian operating system, Kleiseth said.
SQL Anywhere has so far been deployed 10 million times, according to Dublin, Calif.-based Sybase.
Intuit Inc., which embeds SQL Anywhere 8 in its QuickBooks 2006 accounting software, expects to use the revised database in a future version of its software, said Tim Child, director of engineering at Intuit.
Child said he is impressed with Version 10's database- encryption feature and its snapshot-isolation feature, which he says allows for high-speed reporting.
The beta of SQL Anywhere 10 runs on Windows and Linux. Sybase plans to ship a final version for those two operating systems in the third quarter. Final versions for Solaris and the Macintosh will ship in the following quarter, said Kleiseth.
Wayne Kernochan, an analyst with Lexington, Mass.-based Infostructure Associates, called the new features in the beta release "quite sophisticated, many of them worthy of the major enterprise databases.... I would view this as a sign that Sybase has figured out how versions of those features can aid mobile workers, and the Sybase iAnywhere folks continue to be innovative -- as they have many times before."
In the mobile database arena, SQL Anywhere remains ahead of its equivalents from the big database vendors such as Microsoft Corp., Oracle Corp. and even IBM, Kernochan said, because Sybase "has been able to show that 'one database vendor per organization' costs more in these markets, and because these markets care less about standardization than cost."
Read more about Hardware in Computerworld's Hardware Topic Center.
- Path Selection Infographic Path Selection Infographic
- Hyperconvergence Infographic A wide range of observers agree that data centers are now entering an era of "hyperconvergence" that will raise network traffic levels faster...
- Preparing Your Infrastructure for the Hyperconvergence Era From cloud computing and virtualization to mobility and unified communications, an array of innovative technologies is transforming today's data centers.
- How WAN Optimization Helps Enterprises Reduce Costs If you wanted to break down innovation into a tidy equation, it might go something like this: Technology + Connectivity = Productivity. Productivity...
- Redefine Your IT Operations: Remote Office IT Has Never Been Simpler Join us to see why PC Pro named Dell PowerEdge VRTX the "2013 Server of the Year." PowerEdge VRTX may be just what...
- LIVE EVENT: 5/7, The End of Data Protection As We Know It. Introducing a Next Generation Data Protection Architecture. Traditional backup is going away, but where does this leave end-users? All Hardware White Papers | Webcasts
Our new weekly Consumerization of IT newsletter covers a wide range of trends including BYOD, smartphones, tablets, MDM, cloud, social and what it all means for IT. Subscribe now and stay up to date!