SQL Anywhere Beta Advances on Four Fronts

 
 
By Peter Coffee  |  Posted 2006-04-17 Email Print this article Print
 
 
 
 
 
 
 

Opinion: Across-the-board technical improvements outpace rickety business processes.

With todays release of the beta code of SQL Anywhere 10, Sybases iAnywhere subsidiary doesnt send one message. It sends four—and with the sun soon to set on tax season 2005, Id like to add one of my own.

Message 1: Progress is parallel. Version 10 acknowledges the multi-CPU power thats now found in laptops as well as in desktop and server machines, and takes advantage of multiple processor cores. Both query and database maintenance tasks should exploit parallelism, which represents the most cost-effective growth path for system price/performance: I look forward to finding out how well thats being done here.

Message 2: Accessibility, yes; vulnerability, no. Database lookups are no longer like trips to the library, something that you do when you have a specific piece of research to perform—and that you could probably do a few minutes later if needed. Databases are increasingly involved in short-term tasks: Theyre becoming more like the piece of your brain that remembers the layout of a room where the lights have just gone out, helping the enterprise find the best path through the space of immediate options instead of just providing long-range hindsight. Without a prefrontal cortex, your head would have a decidedly Neanderthal shape: Your data center likewise looks better with a more intellectual profile.

This means that databases must be built for high availability—but at the same time for robust security that goes all the way down to the stored bits. For too long, database security has been like the security that your skull gives your brain: a hard shell of firewalls and other perimeter defenses surrounding a soft mushy lump that readily yields its secrets to anyone who can reach it. Database security needs to defend in more depth than Nature does.

Message 3: What developers cant exploit might just as well not be there. The number of people who use databases directly, composing SQL queries on the fly at an interactive prompt, may actually be shrinking even as the number of indirect database users explodes. Developer productivity is the key to reconciling those opposing trends, requiring transparent connections from the interactive and analytic parts of an application to the database foundations. Im mildly disappointed that iAnywhere chose to place its bets entirely on Microsofts Visual Studio as the high-level development environment to be enhanced with Version 10 capabilities, but Im confident that the Eclipse and perhaps also the NetBeans communities will make their interests known.

Message 4: There is no hub. No database should be envisioned today as the single center of all related things. Any given database must be able to take part in the give and take of many data sources and collections, updated in different ways at different times, needing to keep each other informed of relevant state.

Im pleased to see the emphasis thats being placed on all four of these areas of improvement by iAnywhere, but ...

Message 5: No one should expect that even the complete fulfillment of these promises will make business processes work as well as they should.

Tax season is a perfect time to get an annual update of how much progress has been made in one ubiquitous business processs improvement, and also to shed a harsh spotlight on where progress is still sorely needed. As my familys tax preparer, with returns to file every year for five entities in several states as well as for federal taxes, I can tell you that the federal agency gets better every year in making its online offerings work smoothly and making its overall data flows and instructions more understandable. Some state agencies are likewise progressing, although typically lagging about a year behind their federal counterparts, but some states are simply not working hard enough to make their processes clear instead of just accumulating a thickening tangle of complexity.

With the frustration of your own tax filings perhaps in your own prefrontal cortex at this moment, this would be a good time to ask yourself if people who deal with your company—as customers trying to place orders, or as suppliers trying to be good partners—are finding that process as irritating as a tax day that comes five days a week.

Tell me what youre finding taxing at peter_coffee@ziffdavis.com. Check out eWEEK.coms for the latest news, reviews and analysis in programming environments and developer tools.
 
 
 
 
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.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...
 
Manage your Newsletters: Login   Register My Newsletters























 
 
 
 
 
 
 
 
 
 
 
Close
Thanks for your registration, follow us on our social networks to keep up-to-date
Rocket Fuel