|
|
|
|
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 , 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
ModelingMichael David 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? The authors present a translation algorithm for generating efficient SQL for path expressions over tree schemas. 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 FarmingIko 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. More links for data mining and web farming Information RetrievalHierarchical 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.
ODBC, JDBC and the Search for a Black Box