(Russ Miles) First things first, my apologies but I am not talking about an existing technology in this blog. I am not even talking about a complete concept for a future technology. This blog is just about an idea only. An idea for applying aspect orientation to XML, nothing more and nothing les
Other News
Methods of Storing SAS Data into Oracle Tables
(Lois Levin) There are several ways to create a DBMS table from a SAS dataset. This paper will discuss the SAS methods that may be used to perform loads or updates, a comparison of times elapsed, and the INSERTBUFF option and the BULKLOAD option that can be used to perform multiple row inserts and
INSTEAD OF Triggers – All Views are Updatable!
(Serge Rielau) Views are commonly used to separate the logical DB2 schema from the physical schema. This article assesses which views are updatable on their own, and then introduces a feature new with DB2 UDB V8.1 called INSTEAD OF triggers which makes all views updatable.
New Life for Old Microsoft Access Data
(Marcel Gagné) One of the sad facts about our relentless journey forward in the world of computers and software is that we sometimes find ourselves abandoning old data. We move from one word processing office package to another, only to discover that our old documents can no longer be opened. Th
Tutorial Series: RowSet Implementations
RowSets, represented by the javax.sql.RowSet interface, is a JavaBean compliant component that encapsulates database access including the result, or in short an object which encapsulates a set of rows. Outside of encapsulation, a RowSet object can also be used for the following: –As a JavaBean c
Cleaning Up XML
(Adam Kolawa) Garbage in, garbage out – it’s an axiom that applies to many aspects of enterprise development, but none more so than building reliable and robust Web applications and integration projects with XML. Since its inception, XML has been seen as the cure-all for every problem related to Web
How to add an article to an existing snapshot or to a transactional publication by using system stored procedures
There are two ways to add an unpublished article to an existing snapshot, to a transactional publication, or to merge publication. You can either use SQL Server Enterprise Manager to add an unpublished article, or you can use the replication system stored procedures that are provided with SQL Server
Creating User-Defined Data Types in Yukon
(Ron Paddock) The next version of SQL Server (code name Yukon) has extensive support for the Common Language Runtime (CLR). Previous versions of SQL Server (2000 and earlier) had a mechanism for creating custom data types. These data types were nothing more than aliases to system data types. In Y
Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Basic Usage Analysis
(William E. Pearson III) This is the second article of the series, Optimizing Microsoft SQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for Microsoft SQL Server Analysis Services (“MSAS”). The series is designed to provide hands-o
Accelerate your e-business capabilities – Explore solutions for web-enabling your IMS and DB2 data
How do you ensure simple yet secure access to your organization’s applications and data? The answer is Web enablement, which provides a common infrastructure for building integrated solutions. The result: You can pull together data from across your enterprise, and also integrate data from suppliers