(Simon Sprott) XML Data Binding allows you to manipulate an XML document via a set of simple objects. The rules defining the ‘shape’ of the XML document are described in an XML schema. Typically, it is possible to read an XML document into an XML binding library and manipulate it programmatically vi
Author: SSWUG Research
XML Parser Benchmarks: Part 2
(Matthias Farwick and Michael Hafner) In part 1 of this series we showed you the results of our event-driven parser benchmarks. The outcome of these benchmarks showed that the LIBXML2 SAX-like parser in C is superior over the other tested parsers. In second place followed the two Java pull-parser im
Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
(Dmitry Tsuranoff) There are three major theoretical differences between temporary tables: create table #T (…) And table variables: declare @T table (…)
What’s swimming in your bufferpool?
(Tony Voellm and Gaurav Bindlish) When doing a performance investigation a useful thing to do is look at what data is present in the buffer pool. This can be used to analyze impact of running a query on the state of data pages in buffer pool. By collecting the pre and post picture of buffer pool, y
Oracle Session Tracing Part I
(James F. Koopmann) This is the first in a series to introduce some of the new tracing concepts and options within Oracle.
Custom schemas revisited
(Doug Mahugh) I’ve seen some signs of confusion about custom schema support lately. For example, I’ve seen a vendor claim that Open XML’s support for custom schemas is “essentially inherent in XML itself” and that “there is nothing that OOXML supports via custom schemas that ODF 1.0 does not already
Parallelism and zIIP specialty engines – it just keeps getting better
(Willie Favero) Yes, I know you have heard all this stuff already about which workloads are eligible to run on a zIIP specialty engine. Although I am going to rehash some of that old news, I do have what I think is a piece of up-to-the-minute zIIP details that you might find mildly interesting, espe
Sending E-mails with ASP.NET 2.0 using C#
(Anand Narayanaswamy) Nowadays, web masters prefer to receive information from their users or customers through a contact or feedback form placed on the website. ASP.NET 2.0 provides a simplified approach to achieve the task as compared to ASP.NET 1.1. In this part of the series, we will examine how
Oracle to DB2 Conversion Guide – Converting to DB2 for Linux, UNIX, and Windows
(Whei-Jen Chen, AnNa Choi, Arthur V Sammartino, Carlos Eduardo Abramo Pinto, Fraser McArthur, Marina Greenstein, Nora Sokolof and Scott J. Martin) This redbook will provide guidelines for migrating existing Oracle 10g database and applications to DB2 9. (pdf)
Security guru blasts Oracle’s patching policies
(Mark Brunelli) Oracle could issue a million new security features when it debuts Oracle Database 11g later this year, but it wouldn’t change the fact that Oracle’s patching problems still need to be addressed, according to Oracle Security Handbook author Aaron Newman. (R)