(Blair Ireland) If you are new to the TheScripts.com series of tutorials on PHP and MySQL tutorials, I will restate a few things…
Author: SSWUG Research
XML Schema Regular Expressions
(Cliff Binstock) While the built-in datatypes and constraining facets are a great start, they are often insufficient, especially for string values. Regular expressions provide a powerful mechanism for restricting data values in XML.
Take a Leap Forward with ADO.NET vNext (Part 1)
(Thiru Thangarathinam) ADO.NET provides many rich features that you can use to retrieve data from data sources in a number of ways, but with that flexibility developers sometimes end up tightly coupling their client applications to data sources such as relational databases. This can happen even when
Running totals in SQL Server queries
(Arthur Fuller) The requirement is to create a SQL Server query containing running totals based on the moment of the event. The classic example is a bank account because you make deposits and withdrawals, each at a different moment in time. For any given account, one sums the debits (deposits) and c
Simple Xalan extension functions
(Elliotte Rusty Harold) The Xalan XSLT processor can invoke almost any method in almost any Java™ class in the classpath. Doing so can improve performance, provide features like trigonometric functions that aren’t available in XSLT, perform file I/O, talk to databases and network servers, or impleme
Unpivot Query
(Chris Eaton) In my last posting I posted a query to pivot rows into columns. In this posting I’ll show you how to do the reverse. That is, take a set of columns and convert them into a series of rows.
Reading data across sessions using DBMS_PIPE package
(Ayan Mitra) In this article, the author explains how to make use of DBMS_PIPE package to allow for access to the value of a variable across different sessions. This useful feature has been exemplified with the help of a practical example.
Design And Implementation Of Temporal Triggers For MySQL RDBMS
(Andrey Jordanov Hristov) There exist on the market dozens of relational database management systems (RBDMS) and every organization that creates such a product tries to add more and more features to provide a superior product. Having more features brings more customers and therefore allows the compa
Shrink your database using DB2 9 for Linux, UNIX, and Windows row compression
(Paul Read and Michel Steinhauer) IBM DB2 9 for Linux, UNIX, and Windows includes a new dictionary-based row compression feature you can use to compress data objects. When you compress data, you achieve disk storage space savings by representing the same data using fewer database pages. Large tables
Leverage your Oracle 10g skills to learn DB2 9.1 for Linux, UNIX and Windows
(Suita Gupta, Allan Tham and Raul Chong) If you’re a database specialist interested in growing your DB2 9 skills, there’s a good chance that you’ve already developed database skills with another relational database product somewhere along the way. Recently updated for the latest versions of DB2 and