Welcome!

Microservices Expo Authors: Liz McMillan, Pat Romanski, Elizabeth White, Stackify Blog, Andreas Grabner

Related Topics: Microservices Expo, Industrial IoT

Microservices Expo: Article

A Complementary Query Language to Google’s Dart

Structured Data Query Languages

Dart is a new structured data programming language from Google. While unstructured data has become extremely useful, structured data is still extremely important because it keeps businesses running day in and day out. Programming languages still need to be coded by hand and most Google users are not programmers. To fill this large gap for most Google users who have no programming experience, a structured data query language would be very useful. Query languages operate by what data or information is wanted and not how to access or derive it. No programming is necessary to use. This is very similar to a standard Google request. This allows anyone to specify a powerful structured data query request.

How does a query request automatically operate without being instructed on how to perform the request? This is done by analyzing the semantics in the data structure. Since query languages have the ability to search out meaning, they can derive the most value out of the semantics in the data structure. The first and primary place to look for semantics is in the data structure and should not be ignored even if other types of semantics are available. This is because the data structure drives or guides the meaning of the query.

Structured data often involves hierarchical structures. Hierarchical data structures inherently have a significant amount of structure semantics. Besides having vertical semantics they have horizontal semantics where data across pathways are related. This produces very complex structures requiring complicated data structure user navigation for programming languages. Query languages on the other hand are free to perform the navigation internally without involving the user. In fact, some complex data structures are too complex to handle with user navigation within programming languages. This makes query languages indispensable in these complicated situations proving query languages unique usefulness in structured data processing. One such complex data structure processing requiring query processing are multipath queries. These require complicated coordination between multiple paths of a hierarchical data structure such as when a query selects data from one path based on data from another path.

An amazing thing happened unnoticed and unplanned in the ANSI SQL-92 standard. In this standard, the LEFT Outer Join was introduced along with other outer join capabilities. The LEFT Outer Join is a one-sided join that is hierarchical by nature. It always preserves the left side of the outer join operation allowing, for example, employee data that has no dependent data to always be preserved. A new ON clause operation allows specification of hierarchical join criteria at each join point to replace the single use SQL WHERE clause. This prevents any ambiguity in defining hierarchical data structures that occurred when using the older WHERE clause. This combination of new SQL features unexpectedly turned out to support complete hierarchical multipath data structure definition and hierarchical processing even though there was no prior design performed or coding added in ANSI SQL to support full hierarchical processing.

These powerful hierarchical data structures can also be naturally defined in SQL views which can be dynamically joined in multiple ways creating larger variable structures and perform their hierarchical processing on the fly. This concept for processing dynamically created structured data is new and opens up many powerful capabilities in structured data. It utilizes a new Dynamic Metadata Maintenance operation that allows the metadata to be transparently processed. This eliminates any metadata operation by the user to process dynamic structured data. The ANSI SQL query language is in a position to take advantage of these new dynamic structured data capabilities such as for use in peer-to-peer data collaboration.

As stated in the very beginning of this article, Dart is a programming language. This gives it great user control that requires the user to have programming experience and knowledge. But what is not generally recognized, is that some problems are just too complicated to solve under user control. They require automatic processing to handle. These can be performed by a query processor. This automatic processing also means that the user does not need programming experience to specify the query. ANSI SQL's natural hierarchical structured data processing described above places it in a good position to be a complementary language for Google's Dart processor because each has their strong and weak points. Documentation describing the technology used by ANSI SQL hierarchical structured data processing follows:

SQL Dynamic Structured Data Processing Collaboration Article at:
http://soa.sys-con.com/node/1875139

ANSI SQL Transparent Hierarchical Processing User Guide at: 
http://www.adatinc.com/images/Verifying_SQLfX_Current.pdf

ANSI SQL Transparent Hierarchical Processing Technology Slide Presentation at:
http://www.adatinc.com/images/Enterprise_Data_World_Presentation.pdf

Online Interactive ANSI SQL Transparent Hierarchical Processing Prototype at:
www.adatinc.com/demo.html

More Stories By Michael M David

Michael M. David is founder and CTO of Advanced Data Access Technologies, Inc. He has been a staff scientist and lead XML architect for NCR/Teradata and their representative to the SQLX Group. He has researched, designed and developed commercial query languages for heterogeneous hierarchical and relational databases for over twenty years. He has authored the book "Advanced ANSI SQL Data Modeling and Structure Processing" Published by Artech House Publishers and many papers and articles on database topics. His research and findings have shown that Hierarchical Data Processing is a subset of Relational Processing and how to utilize this advanced inherent capability in ANSI SQL. Additionally, his research has shown that advanced multipath (LCA) processing is also naturally supported and performed automatically in ANSI SQL, and advanced hierarchical processing operations are also possible. These advanced capabilities can be performed and explained in the ANSI SQL Transparent XML Hierarchical Processor at his site at: www.adatinc.com/demo.html.

Microservices Articles
Is advanced scheduling in Kubernetes achievable?Yes, however, how do you properly accommodate every real-life scenario that a Kubernetes user might encounter? How do you leverage advanced scheduling techniques to shape and describe each scenario in easy-to-use rules and configurations? In his session at @DevOpsSummit at 21st Cloud Expo, Oleg Chunikhin, CTO at Kublr, answered these questions and demonstrated techniques for implementing advanced scheduling. For example, using spot instances and co...
Skeuomorphism usually means retaining existing design cues in something new that doesn’t actually need them. However, the concept of skeuomorphism can be thought of as relating more broadly to applying existing patterns to new technologies that, in fact, cry out for new approaches. In his session at DevOps Summit, Gordon Haff, Senior Cloud Strategy Marketing and Evangelism Manager at Red Hat, discussed why containers should be paired with new architectural practices such as microservices rathe...
In his session at 20th Cloud Expo, Mike Johnston, an infrastructure engineer at Supergiant.io, will discuss how to use Kubernetes to setup a SaaS infrastructure for your business. Mike Johnston is an infrastructure engineer at Supergiant.io with over 12 years of experience designing, deploying, and maintaining server and workstation infrastructure at all scales. He has experience with brick and mortar data centers as well as cloud providers like Digital Ocean, Amazon Web Services, and Rackspace....
SYS-CON Events announced today the Kubernetes and Google Container Engine Workshop, being held November 3, 2016, in conjunction with @DevOpsSummit at 19th Cloud Expo at the Santa Clara Convention Center in Santa Clara, CA. This workshop led by Sebastian Scheele introduces participants to Kubernetes and Google Container Engine (GKE). Through a combination of instructor-led presentations, demonstrations, and hands-on labs, students learn the key concepts and practices for deploying and maintainin...
Docker is sweeping across startups and enterprises alike, changing the way we build and ship applications. It's the most prominent and widely known software container platform, and it's particularly useful for eliminating common challenges when collaborating on code (like the "it works on my machine" phenomenon that most devs know all too well). With Docker, you can run and manage apps side-by-side - in isolated containers - resulting in better compute density. It's something that many developer...
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is foundational - something customers routinely cite as a top pain point. In his session at @DevOpsSummit at 21st Cloud Expo, Bill Borsari, Head of Systems Engineering at Datera, explored how organizations can reap the bene...
As software becomes more and more complex, we, as software developers, have been splitting up our code into smaller and smaller components. This is also true for the environment in which we run our code: going from bare metal, to VMs to the modern-day Cloud Native world of containers, schedulers and micro services. While we have figured out how to run containerized applications in the cloud using schedulers, we've yet to come up with a good solution to bridge the gap between getting your contain...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...
DevOps is speeding towards the IT world like a freight train and the hype around it is deafening. There is no reason to be afraid of this change as it is the natural reaction to the agile movement that revolutionized development just a few years ago. By definition, DevOps is the natural alignment of IT performance to business profitability. The relevance of this has yet to be quantified but it has been suggested that the route to the CEO’s chair will come from the IT leaders that successfully ma...
Skeuomorphism usually means retaining existing design cues in something new that doesn’t actually need them. However, the concept of skeuomorphism can be thought of as relating more broadly to applying existing patterns to new technologies that, in fact, cry out for new approaches. In his session at DevOps Summit, Gordon Haff, Senior Cloud Strategy Marketing and Evangelism Manager at Red Hat, will discuss why containers should be paired with new architectural practices such as microservices ra...