Analysis: eWEEK Labs' test out SQL Anywhere 10 in the form that buyers will see in Septemberand it shows the results of the three-year effort that's gone into updating iAnywhere Solutions' flagship product.
SQL Anywhere 10, whose Beta code eWEEK Labs looked at this past April, is now on my test bench in the form that buyers will see in Septemberand it shows the results of the three-year effort thats gone into updating iAnywhere Solutions flagship product.
My review of SQL Anywhere 10 will appear at about the same time that iAnywhere ships the bits. My findings should be of interest to enterprise architects and application developers who are looking for a portfolio of database technologies that combine ample capacity, intelligent performance optimization, granular security and ease of administration.
I asked iAnywhere team members if there were any database domains that they did not have in mind as targets. They acknowledged that their largest installations arent yet in the multiterabyte realm of the very largest database tasks.
Theyd like to dispel, though, any impression that SQL Anywhere is only an embeddable database for small-scale use within applications. (We learned during our tests that SQL Anywhere is the engine of the hosted service offering of CRM technology provider RightNow Technologies.)
Big-database features such as intraquery parallelism, an agent for Symantecs Veritas Cluster Server and "materialized views" for precomputing large-table-join results extend SQL Anywheres utility at the high end, while Symbian OS support and a broadened array of mobile-device synchronization options stretch the lower end as well.
Check out eWEEK.coms for the latest database news, reviews and analysis.
Peter Coffee is Director of Platform Research at salesforce.com, where he serves as a liaison with the developer community to define the opportunity and clarify developers' technical requirements on the company's evolving Apex Platform. Peter previously spent 18 years with eWEEK (formerly PC Week), the national news magazine of enterprise technology practice, where he reviewed software development tools and methods and wrote regular columns on emerging technologies and professional community issues.Before he began writing full-time in 1989, Peter spent eleven years in technical and management positions at Exxon and The Aerospace Corporation, including management of the latter company's first desktop computing planning team and applied research in applications of artificial intelligence techniques. He holds an engineering degree from MIT and an MBA from Pepperdine University, he has held teaching appointments in computer science, business analytics and information systems management at Pepperdine, UCLA, and Chapman College.