Cto
CurrentR&D of the next generation SQL processor that naturally combines SQL and NoSQL technologies. Operating hierarchically, it solves the Relational/XML data integration problem and utilizes new hierarchical processing discovered occurring in relational processing. This supports powerful concurrent multipath hierarchical processing capabilities supporting powerful network processing. This is capable of relating every related node to each other. Powerful new SQL semantic hierarchical optimizations were developed supporting a new Semantic SQL. These capabilities are possible in standard ANSI SQL-92. The hierarchical optimization enables flexible global hierarchical SQL views which require no overhead. These are controlled by SQL's flexible variable SELECT list requiring no knowledge of the data structure. Dynamically selected output data fields also using the SQL SELECT operation control the processing and automatically formatted XML output. My discovery of inherent Lowest Common Ancestor (LCA) processing occurring naturally on multipath structures insures results are meaningful and correct by concurrently processing the multiple paths until the LCA is reached. All of these capabilities work together to allow the user to dynamically locate only desired documents and hierarchically process and collect only the desired data. Another discovery is new hierarchical data modeling allowing linking below the lower level structure's root to anywhere in lower structure which inherently and semantically works in ANSI SQL.