Posted: January 25, 2014 Filed under: 1.3 Graph Queries in a RDBMS | Tags: Divine Inspirations, EHR systems, graph queries, graph theory, inference query, multi-dimensional relationship query, NLP, ontology, path query, polymorphic query, RDBMS, SNOMED, subsumption, TCSQL, transitive closure Leave a comment
Presentation Overview: This presentation describes a variety of graph queries in a relational database. Query types include subsumption, path, inference, and polymorphism. These query types are based upon the use of transitive closure.
Slide Presentation: Graph Queries in a RDBMS
Demonstration: Path Query
Demonstration: Querying Cyclic Graphs
Demonstration: Related Concepts Query
Demonstration: Multidimensional Relationship Query
Posted: January 23, 2014 Filed under: 1.4 Processing XML in a RDBMS | Tags: computing interoperability, Divine Inspirations, polymorphic query, RDBMS, semantic interoperability, soft schema, soft star schema, sql, TCSQL, xml, XPath, XSD Leave a comment
Presentation Overview: This presentation describes 3 options for deserializing XML into a relational database. These options include deserializing into database table columns of data type XML, deserializing into conventional relational tables, and deserializing into a soft schema. In the latter approach, XML and corresponding XSD documents are treated as object graphs and class graphs respectively. Treating XSD documents as class graphs enables a clever use of XSD documents in support of a very powerful class of queries called polymorphic queries. Polymorphic queries provide the ability to write queries over collections of heterogeneous XML documents without having to hard-code knowledge accounting for the structural differences between the various XML documents. This presentation also includes a description of how to apply natural language processing (NLP) to the names or values of object graph nodes in order to associate object graph nodes with industry-standard ontology nodes.
Slide Presentation: Processing XML in a RDBMS
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Demonstration: Importing XML into TCSQL
Demonstration: Importing XSD into TCSQL
Demonstration: Instantiation of an XSD Class
Posted: January 17, 2014 Filed under: 4.5 An Architecture to Deliver the Holy Grail of IT | Tags: CCD, computing interoperability, data, Divine Inspirations, EHR systems, information, knowledge, NLM, NLP, ontology, polymorphic query, semantic interoperability, soft schema, soft star schema, sql, structured data, TCSQL, UMLS, unstructured data, xml Leave a comment
Presentation Overview: This presentation describes an architecture to deliver the Holy Grail of IT. This architecture is predicated on transforming an information system into a knowledge system via the use of ontologies, natural language processing (NLP), and the use of a technology called TCSQL.
Slide Presentation: An Architecture to Deliver the Holy Grail of IT
Prerequisite Video Presentation: Search Engine Technology
Prerequisite Video Presentation: The Holy Grail of IT
Prerequisite Video Presentation: Graph Navigation in a RDBMS
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Prerequisite Video Presentation: Graph Queries in a RDBMS
Prerequisite Video Presentation: Processing XML in a RDBMS
Prerequisite Video Presentation: Soft Star Schema Data Warehouse
Prerequisite Video Presentation: Categorizing Structured Data
Demonstration: Importing XML into TCSQL
Demonstration: Importing XSD into TCSQL
Demonstration: Instantiation of an XSD Class
Demonstration: Natural Language Processing
Posted: January 3, 2014 Filed under: 3.3 Project Management | Tags: critical path, Divine Inspirations, OOP, path query, polymorphic query, project management, soft schema, TCSQL Leave a comment
Presentation Overview: This presentation describes use of TCSQL for project management. Powerful path queries are shown in deriving the critical path of a project. The use of polymorphic queries demonstrate the ability to write queries that never break and never need modification despite process and project modifications.
Slide Presentation: Project Management
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Demonstration: Path Query
Divine Inspirations LLC 