By Philip J. GIll – Application developers need more than just an application server; they need an application platform. Oracle9iAS and J2EE combine to form just such a platform.
Author: SSWUG Research
OLAP and Data Warehousing – Data Warehousing Solution Architecture (Part 2)
By Alexzander Nepomnjashiy – Analysis is usually accomplished with tools that are built on the base of attendant technologies. Let’s briefly describe two of the most popular technologies – Online Analysis Processing (OLAP – the online operating analysis) and Data Mining (mining for hidden informatio
How to create views in SQL Server 7.0/2000
By Dan Seewer – Think of a view as another table within the database. Views are often referred to as virtual tables since no physical table exists in the database: A view is merely a “stored query” that returns a result set that can be used in SQL. The view can then be used as part of other SQL quer
Database Horizons
By GARY H. ANTHES – The modern database era began in 1970, when E.F. Codd published his paper “A Relational Model of Data for Large Shared Data Banks.” His ideas enabled the logical manipulation of data to be independent of its physical location, greatly simplifying the work of application developer
XSLT Processing in .NET
by Joe Feser – This article is meant to help XML developers understand the different ways XSLT transformations can be performed using the .NET framework. It alsos describe how to use various input sources for an XSLT transformation. In .NET, the System.Xml.Xsl.XslTransform class is used for transfor
Simple Dom Access Source Code
By David Nishimoto – The Simple DOM Access (SDA) provide a very abstract perspective for interacting with an xml structure. The xml structure only contains elements named “node”. Creating an xml structure with only node elements provides for easy search capabilities when using the selectSingleN
Abstracting Event Context for Reusability
by Claude Duguay – Using a stack to manage context is common in SAX because it saves so much time. Create an event-driven mechanism that abstracts basic SAX events through an XMLEventDispatcher class.
Guaranteeing a single row SELECT
By Kanan Mamedli – Here is how to guarantee that a SELECT is a single row SELECT. This is done in two steps: 1) find out if there is a record satisfied by this condition, and 2) select from the appropriate table or make a cursor variable and then fetch it.
Introduction to SQL-DMO
Most SQL Server administrative tasks are programmable thanks to a set of objects known as SQL-DMO. This article introduces the concepts of programming DMO, and steps you through some basic, and commonly requested examples.
Readers Respond to Software Bug Topic
By Brian Moran – The software-bug accountability debate continues as readers share their responses and suggestions for solving this lack of quality control.