Database Integration Better Late than Never

By Peter Coffee  |  Posted 2005-04-18 Print this article Print

Developers can expect another quantum leap in data-manipulation power with Microsoft's integration of its SQL Server engine with its CLR environment.

Microsoft Corp.s planned integration of database-oriented programming tools pays belated homage, one might say, to computer scientist Niklaus Wirths famous assertion that "Algorithms plus data structures equal programs."

Wirths 1975 book by that title immediately followed his invention of the Pascal programming language, which raised the bar for data-structure support in programmers tool sets. Developers can look forward to another quantum jump in data manipulation power as Microsoft Corp. unifies the mechanics and the semantics of its SQL Server database engine with its CLR (Common Language Runtime) environment.

The resulting union will coordinate resource use—with likely significant improvements in efficiency—and could evolve during the next several years to offer developers a powerful model for data manipulation.

Click here to read about Microsofts plans to integrate Visual Studio 2005 with SQL Server 2005. Programmers may find more freedom to choose between putting logic close to data, while retaining their familiar high-level languages, or keeping their logic located on middle tiers while retaining robust database protections.

Developers will also have more freedom to make the database itself a locus of events. "Its a service-oriented database architecture," said David Campbell, Microsofts general manager for SQL Server, discussing this massive integration effort with eWEEK Labs.

Campbell acknowledged, and promised to address, programmers perennial concern that higher-level language features will come at the expense of performance. That tension dates at least to 1982, when Ed Posts classic tongue-in-cheek essay "Real Programmers Dont Use Pascal" made the facetious assertion that "the only useful data structure is the Array. Strings, Lists, Structures, Sets—these are all special cases of arrays and can be treated that way just as easily without messing up your programming language with all sorts of complications."

In the absence of those "complications," what tended to get messed up—as Post knew perfectly well and as many others have since observed—was programmers understanding of one anothers (and often even their own) intentions. Theyve been forced to devise their own brittle and error-prone frameworks of containers, iterators, cursors and the like.

Lacking strong data type definitions and disciplines as built-in elements of their application programming kits, programmers have either confronted—or perhaps more often overlooked—the difficulties of dealing with null values, defining equality between multivalued entities and ensuring correctness in data structure formation and data use.

With database access as the dominant task of the vast majority of enterprise applications, its none too soon for developers to be offered something better than awkward mixed-language mongrelizations of procedural languages and embedded SQL code.

One can debate the question of how many years represent a generation of software development, but Wirths insights have arguably had about two generations to make themselves part of development DNA. Enterprise teams can hope to benefit from that breeding in forthcoming Microsoft tools.

Technology Editor Peter Coffee can be reached at

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, 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

Rocket Fuel