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 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 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
Posted: January 7, 2014 Filed under: 3.1 Personnel Management | Tags: Divine Inspirations, personnel management, soft schema, TCSQL Leave a comment
Presentation Overview: This presentation describes use of TCSQL for personnel management. Through the use of ontologies and transitive closure, this presentation demonstrates the power of inference queries over a skills database in determining the best candidate for a given task.
Slide Presentation: Personnel Management
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Demonstration: Instantiation of a TCSQL Class
Posted: January 5, 2014 Filed under: 3.2 Process Management | Tags: Divine Inspirations, OOP, process definition, process management, project plan, soft schema, task network, TCSQL, WBS, work breakdown structure Leave a comment
Presentation Overview: This presentation describes use of TCSQL for process management. Using an example of building a house, this presentation shows how to use the soft schema capabilities of TCSQL to define a process template and to instantiate this process template in the creation of a project plan.
Slide Presentation: Process Management
Prerequisite Video Presentation: Support of OOP Directly in a RDBMS
Demonstration: Instantiation of a TCSQL Class
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 