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 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
Divine Inspirations LLC 