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 27, 2014 Filed under: 1.2 Support of OOP Directly in a RDBMS | Tags: Chris Date, Divine Inspirations, graph theory, Larry Ellison, Marten Mickos, MySQL, Nancy Li, object oriented programming, OOP, Oracle, Rich McGinn, soft schema, transitive closure Leave a comment
Presentation Overview: This presentation describes how to support object oriented programming (OOP) directly in a relational database. This includes support for the notion of classes, objects, single/multiple inheritance, polymorphism, etc… all using standard SQL. Support of OOP is achieved by treating OOP as a graph problem, utilizing 3 tables to represent class information and 3 tables to represent object information. Collectively, these 6 tables comprise the notion of a soft schema.
Slide Presentation: Support of OOP Directly in a RDBMS
Demonstration: Instantiation of a TCSQL Class
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 18, 2014 Filed under: 4.4 Search Engine Technology | Tags: Divine Inspirations, LinkedIn, structured data, unstructured data Leave a comment
Presentation Overview: This presentation describes the difference between unstructured data search and structured data search. Also presented are a number of “just imagine” application scenarios if there existed the ability to perform Google-like queries on structured data.
Demonstration: Data Privacy, Security, and Consent
Demonstration: Correlating Healthcare Data
Demonstration: Clinical Trials
Demonstration: Transforming an Information System into a Knowledge System
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
Divine Inspirations LLC 