(Kevin Williams) This article is the first in a series that looks at the steps involved in modeling relational data in XML. We look at the three major components of a relational database—tables, columns, and the key relationships among them—and see how to best model each in XML.
Author: SSWUG Research
Oracle: Deleting Duplicate Rows Efficiently
(Tim Procter) If you’ve made the mistake of forgetting a primary key on your table, it can be frustrating to find a way to delete all of the duplicate rows without deleting the initial instances.
Oracle 10G Development: Oracle-MS SQL Server Integration Tips
(Boris Makushkin) Two Worlds, two different ideologies, two constant rivals – is it possible to give more precise description for two RDBMS World giants – Oracle Database and MS SQL Server? Mountains of TPC tests, proving superiority of one or the other side. Legions of supporters for one product
Build a Menu Framework
(Tony Jedlinski) Developers often use Oracle Application Express (formerly Oracle HTML DB) to rapidly develop simple, non-business-critical applications—to replace spreadsheet-based applications, for example, or to automate paper-based or other manual systems. Given Oracle Application Express’ s
Asked & Answered
(Robert Catterall) We’re implementing a Web services-based application that uses the Distributed Data Facility (DDF). Initial monitoring analysis shows very high CPU enclave consumption, which limits the number of users we can support without degrading the performance of other critical online applic
Using the system function fn_listextendedproperty of SQL Server 2005 for .NET applications: Part II
(Michael Livshitz) In Part 1 of this article we compared the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, wrote a few queries for SQL Server 2005 to test the function. In part 2, I am going to describe using the function for .NET applicatio
Data Modeling,Breaking & Fixing 1NF
(James F. Koopmann) It has been my observation that a lot of us lack the basic skills required to model the simplest of database objects. This article will explore some of the common mistakes and fixes to the breaking of 1NF.
Introducing DB2 Viper, Part 2: Table partitioning in DB2 Viper
(Rav Ahuja) Management of large databases and tables has its own challenges. As tables grow in size, it sometimes becomes easier to manage their data in chunks or by limited ranges, rather than operate on all of the data in those large tables in their entirety. This methodology of managing data is a
Update XForms using XForms
(Steve K Speicher, Jan J. Kratky and Kevin E. Kelly) With XForms technology, you can provide a lightweight editor for an existing collection of XForms. Explore an approach to form authoring for simple, quick changes that improve the effectiveness of data collected. Typical form editing requires a se
Performance (Sample Chapter)
(Harrison Fisk and Alex Davies) Performance is a very important topic when dealing with any database setup. One of the main reasons to use a cluster over a nonclustered database is the ability to get better performance and scalability compared to using a database that is confined to a single host. T