(Sergey Savouchkine) The relational database management system (RDBMS) is based on the relational model, which is simply represented through the relations of rows and columns in two-dimensional tables. Meanwhile, the object-oriented DBMS (ODBMS or OODBMS) offers everything needed for object represen
Author: SSWUG Research
DOM for Web Services, Part 2
(Faheem Khan) In the first article of this series, I discussed web service usage models and described XML processing requirements in web services. I also introduced W3C Document Object Model (DOM) and two of its popular implementations, MSXML and Xerces. This second article discusses MSXML in de
The Trigger-Happy DBA
(Steve Callan) Who is the trigger-happy DBA? No, I do not mean the DBA who is pulling his hair out over a developer’s mistake (“I truncated all my tables. Why can’t you simply do a rollback for me?”), or the DBA fighting management’s insistence on using export as the primary backup and recovery stra
MQSeries for OS/390 V5.2: CF and DB2 issues, part 1
(Ruud van Zundert) Although IBM strives to make the whole product family look and feel the same, there are always going to be differences due to the underlying operating systems. This article concentrates on the differences on the OS/390 side of MQSeries, and in particular on the Coupling Facility (
Sample Asynchronous Oracle to DB2 Data Replication–Needs description
Extnsive fast tips and ER diagram on how to set up replication between DB2 and Oracle.
Debugging Java Stored Procedures on DB2 UDB for z/OS
(Peggy Rader) The IBM Distributed Debugger provides a GUI interface for debugging Java stored procedures on DB2 Universal Database for Linux, UNIX, and Windows. This option is not available for debugging DB2 interpreted Java stored procedures on DB2 for z/OS. There are two alternatives that you can
Microsoft Windows Code Name
Well here we are, the moment we have all been waiting for. The PDC has finally [come and gone], and with it so has Longhorn Pre-Beta build 4051. There are many new things in this build that are worth checking out as well as a few disappointments we’d like to express. The main goal of this tweak guid
Integration Models
(Brian Travis and Mae Ozkan) The integration models we have today are either loosely coupled or tightly coupled. They are message-based or method-based. They are synchronous or asynchronous. Putting these things together in an intelligent way is essential if you are going to archive the promise of w
Fine-Grained Auditing in the Real World
(Arup Nanda) Traditional Oracle Database auditing options let you track the actions users perform on objects at the macro level—for example, if you audit for SELECT statements on a table, you can track who selected data from the table. However, you don’t know what they selected. With data-manipu
Compare Oracle and SQL Server Dates
Oracle and SQL Server databases use different date/time resolutions, which poses a problem when you compare times from the two databases: The times will rarely be equal. Solve this problem by allowing for a margin of error. Treat the dates and times as floating-point numbers and remember that each d