(Brian Moran) The Transaction Processing Performance Council’s (TPC’s) TPC-C benchmark is the most common way of comparing performance in the database space—and a favorite tool in vendor marketing wars. You might find publicized TPC-C scores valuable in evaluating and enhancing your database environ
Community
Order By Clause – insiders perspective
(Vinod Kumar) In this article I will walk through some of the aspects in using Order by from a developers stand point. There are tons of pitfals and advantages in optimizing queries. And more often than not we say the query has got Order by hence cannot be optimized much. Here let me walk through so
Introduction to MSSQL Server 2000 Analysis Services: Introduction to Local Cubes
(William Pearson) In this article, we will look beyond the confines of Analysis Manager to introduce the creation and use of local cubes with Microsoft Office 2003 (“MS Office”). In conjunction with MSAS, we will overview the concepts involved with our topic, and then we will “drill down” into t
Using SQL Server’s XML Support
(Ken Henderson) SQL Server is an XML-enabled DBMS, which can read and write XML data, return data from databases in XML format, and read and update data stored in XML documents. In fact, SQL Server has eight different ways to use XML. Learn how each of them works, and how they interoperate.
J2EE and IBM object-relational databases
(Jacques Roy) WebSphere’s growing successes demonstrate the increased use of the J2EE environment for business application deployment. Technical people everywhere must familiarize themselves with this environment. This article provides an overview of the J2EE environment. It then discusses objec
Use RDDL with your XML and Web services namespaces
(Uche Ogbuji) The spaghetti of namespaces in, say, a WSDL file can lead to a lot of confusion. Resource Directory Description Language (RDDL) packages information on a namespace. If you use URLs for namespaces, use RDDL as described in this article to provide useful guides to users of your XML d
Document-Centric .NET
(Eric Gropp) The principle “program to an interface, not an implementation” helps control the complexity and enhance the flexibility of systems. XML interfaces are a natural extension of this principle that bring a number of new benefits in terms of flexibility, reusability, simplified code, and rea
Managing Web Services
(Mike Lehmann) If you think the term Web services is loosely defined in the industry, try looking for a clear definition of Web services management. Some think it is as simple as Web service configuration, monitoring, auditing, and logging. Others speak more abstractly, using terms such as service v
Coping with Challenging Documents
(Bernard Chester) For document life-cycle management, greener pastures are on the horizon. If you’ve read my past DB2 Magazine columns, you know I’m a fan of DB2 Content Manager v.8 for its rich, flexible, and extensible data model. The standard out-of-the-box version, though, doesn’t begin to ex
Do You Know MySQL?
(Brian Moran) I’m undertaking a research project. I want to understand the effects that MySQL and other open-source databases are having and might have in the future on the mainstream database market–SQL Server in particular. I’ve been cynical about the idea that MySQL can aggressively compete with