(Qiang Lin) Enterprises realize that sole reliance on generic security mechanisms does not provide the protection they need for their business operations. More than just their employees need access to data in the database. Their partners and customers have access to these data as well. Therefore, th
Other News
Oracle Shoots For Database Lead
(Rick Whiting and Charles Babcock) As horror stories about lost or stolen data abound, Oracle is gearing up to debut Oracle 10g Release 2.0, the latest version of its flagship database with improved data-management and backup capabilities. Some of the new features are also designed to help companies
The DB2 SYSIBM.USERNAMES encryption stored procedure – DSNLEUSR
To better protect the authentication information stored in the SYSIBM.USERNAMES table, a new DB2-supplied stored procedure, SYSPROC.DSNLEUSR is introduced in Version 8. This stored procedure stores the authorization ID and password in encrypted form in the SYSIBM.USERNAMES table. After this info
XML in the Crystal Ball: Overview
(Kurt Cagle) In roughly a month, XML will officially be seven years old. On February 2, 1998, XML was approved as a recommendation, though work on the specification had been ongoing since 1996. Even by the more normal pace of things outside of the Internet, seven years is a fairly hefty chunk of tim
Introduction to XMLDataSource control in ASP.NET 2.0
(Keyvan Nayyeri) Nowadays XML is one of important formats to store and retrieve data on the web. And the most important reason is because it can be moved beetween firewalls. We can see many websites with RSS and XML output. Also many visitors use them to save their time and increase their speed in
Database Interaction with PL/SQL: User defined Exceptions, Nested Blocks
(Jagadish Chatarji) This is part 7 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I gave an introduction to exception handling and went through some predefined exceptions. In this article, we will focus on user defined exceptions in PL/SQL and s
Using Triggers to track database action history – Introduction
(Tal Kelley) Several State and Federal contracts that I have worked on in the past have wanted to keep track of all changes to a particular record, such as who modified the record, what kind of modification took place, and when the record modification occurred. I decided to solve this problem wi
Try New Linux Clusters
(David Baum) As more and more companies weave business intelligence into the operational fabric of their businesses, they are looking at low-cost options for deploying their ever-growing data warehouses. Traditionally, large data warehouses were deployed on high-end symmetric multiprocessing (SM
Understanding the sample search application for WebSphere Information Integrator OmniFind Edition
(Dana Morris) Organizations can use WebSphere Information Integrator OmniFind Edition to develop highly customized search applications to best fit their unique needs, requirements and mix of information sources. This article provides a technical overview of the WebSphere Information Integrator O
SQL Server 2005: The Replication GUI
(Paul Ibison) This article describes the changes to replication from the point of view of the SQL Server 2005 GUI. In case you haven’t already been checking out the new version, ‘Microsoft SQL Server Management Studio’ is the new graphical replacement for ‘Enterprise Manager’. It’s probably true