The literature about information retrieval, SQL, query languages and database technologies is extensive. Many documents are available on the Internet but finding useful information among billions of pages can be daunting. These selections include academic papers, white papers, specifications, briefings, conference presentations, and articles from journals, magazines and web sites:
Database Systems: The First Generation discusses the emergence of database systems and results of the CODASYL Systems Committee Database Systems survey of 1968.
, the keynote presentation at Enterprise Data Forum 2003, covered SQL databases, vector databases, grid computing, web services, data mining, ubiquitous connectivity, and bio-electrical links.
DSQL an SQL for structured documents
The authors introduce DSQL, an SQL language for querying structured documents. DSQL is declarative and does not require users to navigate through data. It is based on a theoretical foundation of a declarative language (document calculus) and an equivalent procedural language (document algebra).
What First Normal Form Really Means is a two-part article by C. J. Date.
Similarity Searching and Domain Vocabularies
Service Data Objects
ODBC, JDBC und die Suche nach der Black Box
What makes this paper of significant importance to the SQL/XML industry is it proves how standard ANSI SQL can perform full multi-leg hierarchical processing. It explains how the relational Cartesian processing engine automatically and inherently performs Lowest Common Ancestor (LCA) logic that's required to perform hierarchical processing.
Alternative Schemes for Mapping XML to Databases
There are a variety of solutions for mapping from documents to tables. This is an interesting paper about the comparative performance of several mapping schemes.
Automatically Utilizing XML's Untapped Semantic Goldmine
The author explores the benefit of exploiting XML's hierarchical semantics by modeling hierarchical structures in SQL. He explains that the Left Outer Join can preserve data hierarchies and SQL can model network type (multi-path) structures.
Clio: Mapping XML and Relational Schemas
Efficient XML-to-SQL Query Translation: Where to Add the Intelligence?
The authors present a translation algorithm for generating efficient SQL for path expressions over tree schemas.
SQL:2003 Has Been Published
Optimization Techniques for Mapping Documents to Databases
The authors discuss the statistical analysis of documents to optimize the storage of documents in object-relational databases.
Issues in Real-World Query Optimization and Processing
Notes from a guest lecture at Stanford University.
Data Mining, Web Farming
Iko Pramudiono, Takahiko Shintani, Takayuki Tamura, Masaru Kitsuregawa
Abstract: Data mining is becoming increasingly important since the size of databases grows even larger and the need to explore hidden rules from the databases becomes widely recognized. Currently database systems are dominated by relational database and the ability to perform data mining using standard SQL queries will definitely ease implementation of data mining. However the performance of SQL based data mining is known to fall behind specialized implementation. In this paper we present an evaluation of parallel SQL based data mining on large scale PC cluster.
Hierarchical Structures and 4GLs
This white paper discusses the processing of hierarchical data structures. It discusses entity relationships, recursive structures, hierarchical semantics and the use of SQL for processing queries over hierarchical data. It also discusses the application of Lowest Common Ancestor logic, XML joinless access and mapping network structures to hierarchical structures.
A Comparison of String Metrics for Matching Names and Records
© 2004-5, Ken North Computing, LLC. All rights reserved.
This page was last updated on 22-Aug-2007 .