Blog
What does it mean to be a MarkLogic DBA?
- 28 August, 2022
- By Dave Cassel
- No Comments
The responsibilities of a DBA are different for MarkLogic than for a traditional relational database. While the line of responsibility...
Read More
Blog
MarkLogic index data types
- 28 July, 2022
- By Dave Cassel
- No Comments
MarkLogic offers several types of indexes: Universal, range, triples. These indexes provide fast access to your content and can be...
Read More
Blog
Scoping queries in the Optic API
- 28 July, 2022
- By Dave Cassel
- No Comments
Every now and then I write an Optic query that has parts that look redundant. In the example below, assume...
Read More
Blog
Binding multiple values
- 28 July, 2022
- By Dave Cassel
- No Comments
With MarkLogic’s SPARQL queries, we can bind a value to constrain the query. Using this capability, we can gather information...
Read More
Blog
SPARQL update with multiple targets
- 28 July, 2022
- By Dave Cassel
- No Comments
In my last post, I talked about using the bindings parameter of MarkLogic’s sem.sparql function to look for multiple values in a SPARQL query....
Read More
Blog
TDE Template – Unknown Table
- 28 November, 2021
- By Dave Cassel
- No Comments
MarkLogic’s Data Hub Central offers an easy way to create entities. As a bonus, it automatically creates a TDE Template...
Read More
Blog
Populating an array from numbered fields
- 28 November, 2021
- By Dave Cassel
- No Comments
As we move data from other sources (often relational databases) into MarkLogic JSON, we have the opportunity to change the...
Read More
Blog
SPARQL Update and locks
- 28 October, 2021
- By Dave Cassel
- No Comments
I just learned something the hard way, so I thought I’d share. The tl;dr is that sem.sparqlUpdate runs in a separate transaction by default,...
Read More
Blog
Making updates safe for parallel processing
- 28 May, 2021
- By Dave Cassel
- No Comments
I’ve seen a couple cases recently where we were making modifications to a document in MarkLogic and the process was...
Read More
Blog
Peer reviewing a NiFi flow
- 21 May, 2021
- By Dave Cassel
- No Comments
We’re used to doing reviews for source code. NiFi flows look different, but when they are part of your application’s...
Read More
Blog
Setting an attribute with a dynamic property name
- 28 April, 2021
- By Dave Cassel
- No Comments
The NiFi EvaluateJsonPath processor lets you specify a JSON path, which will be applied to the content of a flow...
Read More
Blog
Comparing xs.dateTime values
- 20 February, 2021
- By Dave Cassel
- No Comments
5 o’clock is 5 o’clock, right? Well, not once we start thinking about time zones. 17:00:00-05:00 (5pm here on the...
Read More
Blog
Processing upstream deletes
- 28 January, 2021
- By Dave Cassel
- No Comments
We can load data into a data hub from a variety of upstream data sources. What if we want to...
Read More
Blog
Working with JSON in XQuery
- 6 October, 2020
- By Dave Cassel
- No Comments
MarkLogic supports XQuery and JavaScript as native languages. XQuery is a very natural way to work with XML, just as...
Read More
Blog
Searching for one result
- 28 September, 2020
- By Dave Cassel
- No Comments
MarkLogic is both a database and a search engine. Sometimes, you know you only want one result from your search....