Posted: April 22, 2014 Filed under: 1 TCSQL Basic Features | Tags: ontology, soft schema, TCSQL Leave a comment
Presentation Overview: TCSQL is a collection of SQL capabilities that enable support of object oriented programming directly in a relational database and some advanced capabilities that provide a foundation to support the Holy Grail of information technology… the ability to support Google-like queries on structured data.
Slide Presentation: TCSQL
Demonstration: Transforming an Information System into a Knowledge System
Posted: January 31, 2014 Filed under: 4.1 The Holy Grail of IT | Tags: computing interoperability, Divine Inspirations, EHR systems, Google, information system, knowledge system, Meaningful Use, natural language processing, NLP, ontology, quality measures, semantic interoperability, soft schema, sql, structured data, TCSQL, transitive closure, unstructured data, xml Leave a comment
Video Presentation Overview: This presentation gives a high-level overview of what is considered the “Holy Grail” of IT… the ability to provide Google-like query capability on structured data. This talk describes a collection of large information-technology challenges that must be solved in order to deliver the “Holy Grail”. Also, a high-level description of the technologies needed to deliver the Holy Grail are discussed.
Slide Presentation: The Holy Grail of IT
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Prerequisite Video Presentation: Processing XML in a RDBMS
Demonstration: Data Privacy, Security, and Consent
Demonstration: Correlating Healthcare Data
Demonstration: Clinical Trials
Demonstration: Transforming an Information System into a Knowledge System
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 21, 2014 Filed under: 4.2 Soft Star Schema Data Warehouse | Tags: business enterprise system, data, data warehouse, Divine Inspirations, ETL, graph theory, information, knowledge, ontological star schema data warehouse, ontology, pivoted ontological star schema data warehouse, soft star schema, sql, TCSQL, xml Leave a comment
Presentation Overview: This presentation describes the notion of a soft star schema data warehouse and a general ETL method applicable to any structured data. Having a soft star schema data warehouse enables the ability to write domain-independent queries.
Slide Presentation: Soft Star Schema Data Warehouse
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Prerequisite Video Presentation: Processing XML in a RDBMS
Demonstration: Transforming an Information System into a Knowledge System
Posted: January 19, 2014 Filed under: 4.3 Categorizing Structured Data | Tags: CDA, Clinical Trial, data, Divine Inspirations, graph theory, Hierarchy, HL7, information, knowledge, NLP, NQF Quality Measure, ontology, SNOMED, TCSQL, UMLS, vocabulary, xml Leave a comment
Presentation Overview: This presentation describes ways of categorizing structured data. The ability to categorize structured data is the key to enable writing powerful queries that cross domain boundaries. Many of the categorization examples are in the healthcare field.
Slide Presentation: Categorizing Structured Data
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Prerequisite Video Presentation: Processing XML in a RDBMS
Demonstration: Importing XML into TCSQL
Demonstration: Importing XSD into TCSQL
Demonstration: Instantiation of an XSD Class
Demonstration: Natural Language Processing
Demonstration: Social Network
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 15, 2014 Filed under: 2.1 Object Morphing | Tags: Divine Inspirations, object morphing, OOP, soft schema, TCSQL Leave a comment
Presentation Overview> This presentation describes the concept of object morphing. This powerful capability provides the ability to take object instances and automatically make appropriate property additions and deletions whenever the class of an object is changed to a different class.
Slide Presentation: Object Morphing
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Demonstration: Instantiation of a TCSQL Class
Posted: January 13, 2014 Filed under: 2.2 Soft Methods and Triggers | Tags: Divine Inspirations, soft methods, soft schema, soft triggers, TCSQL Leave a comment
Presentation Overview: This presentation describes the notion of soft methods and triggers. These advanced TCSQL features provide the ability to define semantic behavior associated with connection types. Whenever a property of an object is modified, the TCSQL framework checks to see if some other node(s) in the graph cares about that modification. If so, an appropriate soft trigger is executed.
Slide Presentation: Soft Methods and Triggers
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Divine Inspirations LLC 