|
|
|
|
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 Technology Trends, 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 Data AccessService
Data Objects
ModelingUsing ANSI SQL as a Conceptual Hierarchical Data Modeling and Processing Language for
XML 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. SQL/XMLAlternative
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? SQL:2003 Has Been Published  Standard
SQL 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. Query OptimizationIssues in Real-World Query Optimization and Processing Notes from a guest lecture at Stanford University. More links for query optimization Data Mining, Web FarmingParallel SQL Based Association Rule Mining on Large Scale PC Cluster: Performance Comparison with Directly Coded C Implementation 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. More links for data mining and web farming Information Retrieval
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 . |
|
discusses the emergence of
database systems and results of the CODASYL Systems Committee Database Systems survey of 1968. 
