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 >>
Lack of Interactive CapabilityInteractive query processing with procedural navigation is not reasonably possible except for very simple procedural queries. Global view support using nonprocedural
navigation-less processing makes unlimited interactive query processing possible since no procedural navigation is necessary and the user does not need to know the
structure. Interactive query support is useful for decision support which is possible because of multi-leg queries which dynamically increase the value of the data to
match the specific query. Interactive query support is also very helpful for significantly speeding the design and implementation stage of an XML application by
having the capability to immediately test out programming and access logic against the required XML data and structure during the design and implementation phases.
Unutilized Powerful Hierarchical Operations
|
Fast, reliable data access for ODBC, JDBC, ADO.NET and XML |
Powerful hierarchical processing operations such as joining full nonlinear hierarchical structures together are not reasonably possible with procedural navigation.
With nonprocedural navigationless processing, the most powerful and internally complex hierarchical operations can be specified easily and performed automatically.
For example a Department hierarchical structure can be hierarchically joined with an Employee hierarchical structure and processed using hierarchical views as in
SELECT Deptno, Empno FROM DeptView LEFT JOIN EmpView ON DeptID=EmpDeptID WHERE DeptNo=1204. This is a synergistic operation increasing the semantic value of the
combined queried structure beyond each structure queried separately and it can be processed interactively.
|
Limited Future ProofingLinear hierarchical processing with procedural navigation is limited in its capabilities to support future requirements, while nonprocedural navigation-less processing
goes a long way to being future proof for unpredictable new and needed capabilities coming down the road. The full power of the entire hierarchical structure is
available with automatic nonlinear hierarchical processing, so the difficulty level and size of the problem domain required is not a problem.
<< 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.
|
|
|