Relational Database Design and Performance Tuning for DB2 Database Servers
White Papers Relational Database systems are no different. While it is possible to perform some amount of tuning of Relational Database Systems after the fact, the more attention paid to the overall design of the entire system up front will generally yield the...
[February 19, 2007, 0:00]
Java Database Best Practices: Relational Data Architecture
White Papers Relational data architecture is the discipline of structuring databases to serve application needs while remaining scalable to future demands and usage patterns. This paper focuses instead on the core data architecture needs of Java applications...
[October 10, 2007, 1:00]
Relational Modeling with UML
White Papers The paper also explains the basic concepts behind relational modeling, how it applies to databases, and how it is implemented using UML. In addition, it identifies differences between ER modeling and relational modeling
[April 23, 2008, 14:56]
Dealing With (Un)Structuredness in XML Data and Queries Using Relational Databases
White Papers Relational databases are widely used to store and query XML data and various schemes have been proposed to this end. The paper also shows how the interaction between the amount of schema information available and the query workload plays an...
[December 24, 2008, 0:00]
Speeding Up Multi-Relational Data Mining
White Papers This paper presents a general approach to speeding up a family of multi-relational data mining algorithms that construct and use selection graphs to obtain the information needed for building predictive models (e.g.decision tree classifiers) from...
[October 1, 2008, 1:01]
On the Difficulty of Finding Optimal Relational Decompositions for XML Workloads: A Complexity Theoretic Perspective
White Papers A key problem that arises in the context of storing XML documents in relational databases is that of finding an optimal relational decomposition for a given set of XML documents and a given set of XML queries over those documents.
[December 24, 2008, 0:00]
Proven Strategies for Archiving Complex Relational Data
White Papers Yet, archiving complex relational data poses many challenges. IBM's Optim Data Growth Solution provides proven technology and comprehensive capabilities that make archiving complex relational data practical and desirable.
[July 1, 2009, 16:51]
Applied Relational Technology: Sun Ray Ultra-Thin Client Success Story
White Papers Application and software developer Applied Relational Technology (ART) recently implemented new systems at WestQuay, Southampton and Livingston, Scotland. Sun Microsystems' Sun Ray 100 and Sun Ray 150 ultra-thin clients are being used in a new...
[January 10, 2005, 23:00]
Recursive XML Schemas, Recursive XML Queries, and Relational Storage: XML-to-SQL Query Translation
White Papers This paper considers the problem of translating XML queries into SQL when XML documents have been stored in an RDBMS using a schema-based relational decomposition. This algorithm handles a general class of XML-to-Relational mappings, which includes...
[December 24, 2008, 0:00]
Data Mining Using Relational Database Management Systems
White Papers This paper uses a relational database as secondary storage in order to eliminate this limitation. Software packages providing a whole set of data mining and machine learning algorithms are attractive because they allow experimentation with many...
[October 1, 2008, 1:01]
Multi-Relational Data Mining: An Introduction
White Papers While most existing data mining approaches look for patterns in a single data table, Multi-Relational Data Mining (MRDM) approaches look for patterns that involve multiple tables (relations) from a relational database.
[September 20, 2008, 0:00]
Multi-Relational Data Mining, Using UML for ILP
White Papers Although there is a growing need for multi-relational data mining solutions in KDD, the use of obvious candidates from the field of Inductive Logic Programming (ILP) has been limited. In one's view this is mainly due to the variation in ILP engines...
[October 1, 2008, 1:01]
MSDN Webcast: Using the .NET Language Itegrated Query (LINQ) Framework With Relational Data (Level 300)
White Papers This webcast introduces LINQ to SQL, a component of the LINQ project designed to help integrate relational data and queries with Microsoft Visual C# and Microsoft Visual Basic .NET. Database-centric applications have traditionally had to rely on...
[August 28, 2007, 1:00]
Linux biggest gainer in relational database market
News The Relational Database Management System (RDBMS) market grew by more than 5 percent in 2003 after suffering a 6 percent fall in the previous year, according to new revenue figures published by Gartner on Friday -- although much of that apparent...
[May 28, 2004, 16:30]
Because Not All Data Is Flat: IBM's U2 Extended Relational DBMSs
White Papers This white paper compares the strengths of the extended relational approach with the more commonly used pure relational approach and highlights various ways in which the extended relational approach provides an advantage over the pure relational...
[April 21, 2007, 1:00]
Comparing XML and Relational Storage: A Best Practices Guide
White Papers While there have been years of research into physical and logical database design in purely relational systems, little definitive work has been done on the influence of XML on the logical and physical database design of unified XML/relational...
[October 25, 2005, 3:00]
Is Column-based Relational Analytics a Database Cash Cow?
Blog He also said that column-based relational analytics has gained wider recognition as a process for managing data, especially if it is subsequently fed into business intelligence applications. I spent last Thursday night getting a pre-briefing on the...
[February 23, 2009, 8:34]
Dynamic XML-Based Exchange of Relational Data: Application to the Human Brain Project
White Papers This paper discusses an approach to exporting relational data in XML format for data exchange over the web. They describe the first real-world application of SilkRoute, a middleware program that dynamically converts existing relational data to a...
[November 25, 2008, 23:00]
Biological Applications of Multi-Relational Data Mining
White Papers Biological databases contain a wide variety of data types, often with rich relational structure. Consequently multi-relational data mining techniques frequently are applied to biological data. This white paper presents several applications of multi...
[October 1, 2008, 1:01]
IBM brings relational XML tools to mainframes
News According to IBM, z/OS has added a bunch of new features to Viper, including better security data-storage compression and, IBM believes, allows easy management, for the first time, of relational and XML data in the same database.
[March 8, 2007, 10:08]



