Posted: January 21, 2014 | Author: | Filed under: 4.2 Soft Star Schema Data Warehouse | Tags: , , , , , , , , , , , , , , | 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 | Author: | Filed under: 4.3 Categorizing Structured Data | Tags: , , , , , , , , , , , , , , , , | 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 | Author: | Filed under: 4.5 An Architecture to Deliver the Holy Grail of IT | Tags: , , , , , , , , , , , , , , , , , , , | 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 1, 2014 | Author: | Filed under: 3.4 Data Privacy, Security, and Consent Management | Tags: , , , , , , , , , , , , , | Leave a comment

Presentation Overview: This presentation describes how to manage data privacy, security, and consent. Determining who has access to data and what data they can access is an enormous industry-wide problem. This presentation demonstrates a clever use of ontologies in providing an elegant solution to this problem.

Slide Presentation: Data Privacy, Security, and Consent Management

Prerequisite Video Presentation: Support of OOP Directly in a RDBMS

Demonstration: Data Privacy, Security, and Consent
Demonstration: Social Network