(Scott Stephens) Oracle’s Heterogeneous Services layer is a way for an Oracle database server to access data on external, non-Oracle databases transparently using Oracle. For example, you can configure Heterogeneous Services and SQL*Net to access a Microsoft Access database through ODBC or OLE DB.
Community
Apache and the Internet (Sample Chapter)
(Peter Wainwright) This chapter is an introduction to both Apache and the concepts that underlie it; that is, the Hypertext Transfer Protocol (HTTP) and the basics of networking and the Internet. It’s aimed at those totally new to Apache and Web servers in general. This chapter is introductory in na
How To Ensure the CEO & PHP Enjoy Love at First Sight
(Robert Peake) I firmly believe that the biggest obstacle to PHP becoming widely accepted in the Enterprise is not a lack of useful features, obscure faults within the PHP4 parser, or any other esoteric technical detail. One of the main reasons PHP projects get a bad repuation is that often PHP proj
RACF, Started Tasks and System Privileges
(Michael Cairns) As a Resource Access Control Facility (RACF) security administrator and occasional systems programmer, I’m often asked why a job, started task, or user ID has lost access, stopped working or won’t start when it was “working perfectly yesterday” and the customer “changed nothing.”
Prevent Twinkling Measures via Single Grain Fact Tables
(Todd Schraml) When creating a star schema, the most important concept is fashioning each fact to contain a single grain. Without an enforced single grain, the fact will need to support measures that twinkle in and out of existence as data from the fact is summarized to varying levels. The grain
Trace Messages Part III: Ending Sessions and Adding Metrics
(Andrew Novick) The current theme is about application trace messages. The previous two articles (Part I and Part II) described the AppSession and the AppSessionTrace tables and the stored procedures that insert and update their rows.
Using 64-Bit Virtual Storage and Large Real Storage to Improve Performance and Availability in DB2 for z/OS
(Jeffrey Berger) Version 8 of DB2 for z/OS now supports 64-bit storage in the DBM1 address space in order to provide some virtual storage constraint relief (VSCR). Likewise the IRLM address space now supports 64-bit storage. The 64-bit storage exploitation in Version 8 provides for performance a
Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!
(Mat Stephen) There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005. Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the box’ features. There is one that is wh
Using SQL-DMO To Backup and Verify a Database – Overview
(Carvin Wilson) The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. The first article in this series entitled “Using the SQL Distributed Management Objects”, provi
IBM Launching Search Tools For XML Documents
(Clint Boulton) IBM has improved the ability of its content management software to handle XML-based documents, broadening the scope of data types the products can capture, manage and search.