(K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Özcan, H. Pirahesh, N. Seemann, A. Singh, T. Truong, R. C. Van der Linden, B. Vickery, C. Zhang and G. Zhang) Comprehensive and efficient support for XML data management is a rapidly increasin
Other News
Frictionless data: let it flow
(Joab Jackson) Think information sharing at your agency is difficult? It took an order from the president to get intelligence agencies to start to pool their resources.
Adding MDC to DPF and Partitioned Tables
(Chris Eaton) In my last posting I talked about combining table partitioning and DPF to get very high levels of parallelism, scalability and simplified roll-in and roll-out. DB2 also has a technology called Multi Dimensional Clustering (MDC – available since 2002) which provides a great performance
What Business Can Learn from Open Source
(Paul Graham) Lately companies have been paying more attention to open source. Ten years ago there seemed a real danger Microsoft would extend its monopoly to servers. It seems safe to say now that open source has prevented that. A recent survey found 52% of companies are replacing Windows servers w
Making the Case for an Enterprise-Wide BI and DW Capability
(Robert Farris) This column explores the major challenges companies face and suggests actions to build an effective business intelligence (BI) and data warehouse (DW) capability and its primary drivers.
Generate XML Schemas for your Data
(Lewis R Cunningham) A reader recently asked: Hi, We are using Oracle eBS and 9i (XML DB not installed), and need to generate XSDs from the client site using SQLPlus. DTDs are currently generated from the client: the SQLPlus script calls a database package that creates a bunch of DTDs from a t
How to Detect Table Fragmentation in SQL Server 2000 and 2005
(Satya Jayanty) How do you know when a table is fragmented? –Poor query performance over time. –More disk activity. –Poor cache utilization. –Verify the I/O of a query. –Verify scan density in SQL 2000 using DBCC SHOWCONTIG and in SQL 2005 using the dynamic management view sys.dm_db_
Easing the Cost of Compliance
(James Pickel) The Sarbanes-Oxley Act and other regulations require corporate executives to provide and ensure increased levels of financial and operational discipline. To help comply with this law, most enterprises are now implementing measures that cross financial reporting and processes that impa
Generation of efficient parsers through direct compilation of XML Schema grammars
(E. Perkins, M. Matsa, M. G. Kostoulas, A. Heifets and N. Mendelsohn) With the widespread adoption of SOAP and Web services, XML-based processing, and parsing of XML documents in particular, is becoming a performance-critical aspect of business computing. In such scenarios, XML is often constrained
Refactoring MySQL to Support Materialized Views
(Steve Hanov, Andrew Roth and Hobbe Smit) In this paper, we try to determine the refactoring necessary to implement a new feature in MySQL, a popular open source database system. The first step is to obtain the conceptual and concrete architectures. We find the conceptual architecture by examin