TechNotes
Logic in DB
Beyond Java
Data Access
SOX
SQL/XML
Restructuring
Trees
Open Source
BizIntel
MySQL
Drivers
ODBC
JDBC
OLE DB
.NET
Podcast
SQL:2003
MS SQL 2005
XML DBs
XQuery
Webcast
XQuery
SQL:2003
MS SQL 2005
|
|
<<Prev 1 2 3
4 5 6 7 8
9 Next >>
No True Nonprocedural Processing Being Used
Nonprocedural database processing implies there is no procedural navigation being performed. Procedural navigation is a procedural process requiring knowledge of
the structure and how to access it step-by-step. A common misconception with procedural processing is the belief that it is always more effective than nonprocedural
processing for complex problems. This is not the case with algorithmic and semantic driven processing of complex database structures like nonlinear hierarchical
structures. What happens is that the required combination and nesting of algorithmic procedures becomes too complex and time consuming to procedurally perform
practically. What is needed is the already proven automatic way to process these complex nonlinear hierarchical structures so they can be processed with simple
nonprocedural query requests that do not require procedural processing and navigation.
Hierarchical Processing Principles Not Enforced
|
 Fast, reliable data access for ODBC, JDBC, ADO.NET and XML |
In partial defense of XML’s limited hierarchical database processing today, XML was not designed for database processing; it was designed for markup use as mentioned
previously. Database use in XML was actually an afterthought. This is why there is no XML specification for its more precise hierarchically principled database
processing. This presents a major problem today because every XML hierarchical processing vendor tool is using their own proprietary or on-the-fly hierarchical
processing logic which can produce inaccurate hierarchical results. Fortunately, there is no need for a hierarchical processing standard because there are already proven
natural hierarchical principles that must be followed in order to produce correct results. This level of accurate full nonlinear hierarchical processing requires
nonprocedural navigationless processing to perform complex, accurate, and consistent processing.
|
Hierarchical Semantics Not Used to Increase Data ValueNonlinear hierarchical structures automatically contain a goldmine of valuable semantics that also exists between every leg in the
structure. Today’s linear limited hierarchical XML processing does not utilize this semantic goldmine. This abundance of semantics enables every node to be related
to every other node. This valuable fact is being ignored today. Multi-leg queries controlled by nonprocedural navigationless processing can utilize this semantic
information to automatically process the nonlinear hierarchical query. This in turn increases the value of the customer’s hierarchical data by locating and
determining the qualified data semantically.
Determining qualified data requires real-time hierarchical coordination logic known as LCA (Lowest Common Ancestor) processing to establish the context between the
different referenced legs of the structure in order to process only meaningful relationships. A simple example is selecting data from one leg of the structure based
on data from another leg of the structure coordinated by the LCA node. This query greatly increases the value and use of the data by dynamically enhancing the query
context along with the capability to automatically support the multitude of different single and multi-leg queries made possible by the full processing of nonlinear
structures.
<<Prev 1 2 3
4 5 6 7 8
9 Next >>
Database Server Watch
SQL Summit Home
Page Articles
© 2008, Ken North Computing LLC, All rights
reserved.
|
|
|
