(Peter Zaitsev) Where does real power of MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines and we can see solutions as Solid and PBXT . Plus there is Falcon storage engine being developed
Author: SSWUG Research
Back to basics: Equi and non-equijoins
(Eddie Awad) The join condition determines whether a join is an equijoin or a non-equijoin. An equijoin is a join with a join condition containing an equality operator. An equijoin combines rows that have equivalent values for the specified columns. When a join condition relates two tables by an ope
Oracle RAC Administration – Part 16: Balancing act between Server and Client
(Tarry Singh) We will take a little detour from our regular path of following the manual, some would say, to more practical path. One topic that most intrigues both an Oracle DBA and their clients (in their own way) is connectivity. DBAs are sometimes puzzled with the load balancing and failover par
XML for PHP developers, Part 2: Advanced XML parsing techniques
(Cliff Morgan)This second article in a three-part series will discuss XML parsing techniques of PHP5, focusing on parsing large or complex XML documents. It will offer some background about parsing extensions and, specifically, what parsing methods are best suited to what types of XML documents and
Object-Level Backups
(Phil Factor) It was last year that I was forcefully reminded that regular backups are not always enough. I was working on the database of a live website. I had attached to it remotely across the internet via Query analyser, and was deleting a customer. It was after midnight at the end of a long wor
Business Intelligence as a Driver for Business Transformation
(Robert Muller) By recognizing business intelligence (BI) as a transformative inflection point, Intel Corporation made global procurement reporting (GPR) a major contributor to the $300 million business value of the company’s e-procurement program. Formalizing the design approach utilized by GPR and
Introducing the Composite Pattern in PHP 5
(Alejandro Gervasio) The composite pattern is one of the less commonly used patterns in PHP 5. Nevertheless, in certain situations, it is very helpful. This article, the first one in a two-part series, will introduce you to the basic concepts of the composite pattern.
Use the .NET FileSystemWatcher object to monitor directory changes in C#
(Zach Smith) There are many instances that require systems to perform certain tasks when files or directories are created or modified. One example of this is an import system that pulls flat files into a database. In this instance, a program must monitor a directory for newly created files. When a f
Exploring Secrets of Persistent Application Settings
(Michael Sorens) The MSDN documentation includes a lot of material on persisting application settings in a Windows application (see Application Settings for Windows Forms ). But like much documentation, it’s primarily a reference rather than a practical implementation guide, giving the complex and i
Enterprise SOA the Apache Way
(Kyle Gabhart) Apache.org has been buzzing with Service-Oriented Architecture (SOA) and Web Services activity for the last several years. If you browse to the Apache Web Services Project, you’ll find a list of more than 20 SOA and Web Services projects with another handful currently housed in the Ap