Knowledgebase:
Semantics, SQL, TDE, and Optic Primer
22 April 2021 07:17 PM

Introduction

MarkLogic's semantic stack is both powerful and feature rich. This knowledgebase article is a curated collection of links to all our best semantic stack related materials.

Data models

All of the features in MarkLogic’s semantic stack (SPARQL, SQL, TDE, Optic API, etc.) are based on semantic triples. Be aware that triples in MarkLogic Server can be either unmanaged triples contained in a document (aka “embedded” triples) or managed triples, which are not embedded in any document. Most use cases would be best served by using unmanaged or embedded triples. You can learn more about data models in the MarkLogic semantic stack and the benefits of the embedded triples approach at:

When to use which semantic interface?

See our knowledgebase article - Optic, Search, SQL, or SPARQL - when should I use which interface?

Common issues

When people run into trouble with MarkLogic’s semantic stack, it’s almost always related to performance. The very best way to improve your performance is to constrain the amount of work and scope of your requests - but there are other common best practices as well. You can find those best practices in our Best Practices for Using MarkLogic Semantics at Scale knowledgebase article.

Can’t miss debugging tools

See our knowledgebase article - What debugging tools are available for Optic, SQL, or SPARQL code in MarkLogic Server?

Maintenance tips

Your initial TDE views are unlikely to be your final TDE views - you'll likely need to change or update them as your database and application requirements mature. You can find best practices around updating TDE views at our knowledgebase article - Updating a TDE View 

Tips for users of BI Tools

For critical tips and best practices around how to best use MarkLogic Server with your favorite BI Tools, please consult our knowledgebase article - Best Practices for Using BI Tools with MarkLogic

(14 vote(s))
Helpful
Not helpful

Comments (0)