Michael M. David, Author at Database Journal

Michael M. David is the founder of Advanced Data Access Technologies, Inc. Previously, he was the lead XML architect for NCR/Teradata, and served as their representative to the ANSI SQLX Group. Before that he was a staff scientist for Teradata and designed high level multi-featured SQL utilities. He has more than 25 years of experience researching and designing commercial nonprocedural heterogeneous database hierarchical query processing products using flat, relational and hierarchical data. From this experience, he authored the book Advanced ANSI SQL Data Modeling and Structure Processing, as well as numerous papers and articles on this subject.

Features

ANSI SQL Can Combine Advantages and Principles of Relational and Hierarchical Data Processing

Michael M. David describes how relational and hierarchical data processing can be seamlessly combined in a way that supports and preserves both

Jan 20, 2011

Features

Top 10 SQL Hierarchical Data Processing Capabilities

Michael M. David reviews the top 10 new capabilities presented by ANSI SQL Transparent XML Hierarchical Processing, including Inherent hierarchical

Dec 8, 2010

Features

Extending SQL’s Inherent Hierarchical Processing Operation

This article covers multipath operations that require a different hierarchical logic than SQL naturally produced hierarchical processing. These include

Nov 18, 2010

Features

Hierarchical Data Structure Virtualization in SQL

Data structure virtualization is the constructing of a data structure utilizing pieces or fragments from other data structures. This article demonstrates

Oct 21, 2010

Features

A YesSQL Cloud Alternative

A lot has been written about the "NoSQL" alternative as an alternative to SQL and other large database systems for a lighter, faster, cheaper alternative

Sep 16, 2010

Features

Hierarchical Data Structure Transformation in SQL

The two basic types of data structure transformation terms, Restructuring and Reshaping, are used interchangeably with data structure transformations.

Aug 19, 2010

Features

Dynamic Data Driven Variable Hierarchical Structures in SQL

SQL can support the creation of variable hierarchical structures in a number of differently controlled operations that can be combined. Michael M. David

Jul 16, 2010

Features

Extending Hierarchical Data Modeling Demonstrated in SQL

The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a

Jun 17, 2010

Features

The Power Behind SQL’s Inherent Multipath LCA Hierarchical Processing

My previous article, SQL's Optimized Hierarchical Data Processing Driven by its Data Structure, covered global views, schema–free navigationless

May 20, 2010

Features

SQL’s Optimized Hierarchical Data Processing Driven by its Data Structure

Learn how hierarchical data processing can be optimally driven automatically by its hierarchical structure semantics. When applied to SQL hierarchical

Apr 21, 2010

Features

ANSI SQL Hierarchical Data Processing Basics

The SQL-92 standard unknowingly and without planning introduced the capability to perform full hierarchical data processing with its introduction of the

Mar 17, 2010

Features

Ten Problems with XQuery and the SQL/XML Standard

XQuery and SQL/XML standard are processors for XML. SQL/XML was designed to try to match the capabilities of XQuery as closely as possible and XQuery was

Feb 17, 2010

Latest Articles

SQL SORT BY Statement Features

Working with NULL Values in SQL Features

Working with SQL AND, OR, and NOT Operators Features

Michael M. David

Company

Categories