(Jim Czuprynski) Oracle Database Resource Management (DRM) provides tools that allow any Oracle DBA to manage a database server’s CPU resources effectively for application user groups and during different resource demand periods. This article provides a brief overview of how DRM works and then delve
Other News
The DB2 Framework for Business Intelligence
(Jon Rubin) The IT community is by now well acquainted with the value proposition of the data warehouse—indeed, the focus of most discussions has shifted beyond the warehouse itself to the larger issues surrounding an overall enterprise architecture for business intelligence and realtime analytics.
XML-RPC in Java programming
(Roy Miller) Interapplication communication can be a nasty problem for programmers. Many of the available options, such as JNI, can be difficult to use. XML-RPC provides a much easier solution. It’s clean, simple to implement, and well supported by open source libraries for most popular programming
Managed UDTs Let You Extend the SQL Server Type System
(Peter W. DeBetta) The next version of SQL Server, code-named “Yukon,” will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UD
DB2 and Java: The Big Picture
IBM DB2 Universal Database (UDB) supports all the key Internet standards, making it an ideal database for use on the Web. It has in-memory speed to facilitate Internet searches and complex text matching combined with the scalability and availability characteristics of a relational database. DB2 UDB
Using PHP 5’s SimpleXML
(Adam Trachtenberg) XML is great, but I’ve constantly wondered why it’s so difficult to parse. Most languages provide you with three options: SAX, DOM, and XSLT. Each has its own problems: –SAX’s event-based design forces you to track elements manually, by pushing and popping them on and off of
Microsoft Getting a Bigger Slice of Database Pie
(Brian Fonseca) As the absolute size of corporate and government databases continues to swell, more users are turning to technology they previously didn’t consider for very large databases: Microsoft Corp. and its DBMS and Windows. A study by the Winter Corp., released last month, identifies the
Update on OCFS
(Wim Coekaerts) Version 1 was released about a year ago and is still the current major release number. The main goal of OCFS was to provide a replacement for raw devices. It was not designed as a general-purpose cluster filesystem, nor was it designed to store nondatabase files. By database files, I
In T-SQL, use CASE…WHEN in place of IF…THEN
(Susan Harkins and Mike Gunderloy) Developers who are new to Transact-SQL (T-SQL) sometimes discover one part of the language and use it doggedly, even when there are better alternatives. An example is using the classic IF…THEN statement for controlling program flow. This is usually the first, and
DB2 Development Add-In Technical Preview
(Abdul Al-Azzawe) The DB2 Development Add-In for Visual Studio .NET Stinger Technical Preview is a monumental achievement that builds upon a robust and functionally rich product. It’s a preview of technologies designed to enhance productivity for .NET and Java application programmers. The sheer numb