(Akram Hussein) Microsoft SQL Server 2005 introduces a new distributed messaging framework that allows for asynchronous programming support. The Service Broker is a new platform for building asynchronous – distributed database applications. In this article I will give a brief overview of the def
Other News
Best Practices Guide: Mercury and Oracle 11i E-Business Applications
This Guide discusses best practices for using Mercury products and services when developing, deploying, and maintaining Oracle 11i E-Business Applications. It is intended for organizations that want to ensure their Oracle 11i deployment meets the performance, functional, and reliability demands of u
Data federation with WebSphere Business Integration Message Broker and WebSphere Information Integrator
(Bill Matthews) This article shows you how to implement data federation using WebSphere Business Integration Message Broker (WebSphere BI MB) with WebSphere Information Integrator (WebSphere II) or WebSphere Information Integrator Classic Federation (WebSphere II CF). (pdf)
MySQL update beckons big business
(James Niccolai) A new version of open-source database MySQL will be released next month, aimed at attracting more businesses.
Business Integration — Information Conformance Statements (BI-ICS)
(Scott Hinkelman) Industry trends within the XML-oriented business space indicate that regardless of the advancements in technology that XML brings, challenges in business information modeling that have existed for decades continue. A predominant problem area is centered on the real-world need t
Caching Result Sets in PHP: The Barebones of a Caching Class
(Alejandro Gervasio) While procedural caching may be well-suited for small and even medium-sized applications, the picture changes for large projects. That’s when object-oriented approaches come into their own. This article focuses on developing an object-based extensible caching solution.
Dynamic ‘Sales by Week’ Procedure in SQL Server
(Mike Ellison) Presented in this article is an approach for creating a categorized “Sales by Week” report in SQL Server, in which weeks are represented as columns, categories as rows, with values totaled by those categories. Before describing the stored procedure, where we’ll parameterize this d
An XML Guru’s Guide to BizTalk Server 2004, Part I
(Aaron Skonnard) Who would have believed that XML, such a seemingly trivial technology, could revolutionize an industry? It may have seemed like a long shot in the beginning, but the XML aficionados saw something special and pragmatic right away—a sort of duct tape for the world’s information sy
Oracle Performance Tuning – Part 3
(Steve Callan) As mentioned in Parts 1 and 2, there are several relatively easy steps you can take to improve performance. One of those steps involves using an automated tool to “guide” you in writing SQL statements. There are several vendors who manufacture analysis or performance tuning tools,
New MySQL database aims for enterprise customers
(James Niccolai) MySQL AB is eyeing a November release for Version 5 of its open-source database, a major upgrade that the company hopes will make it a bigger player among enterprise customers.