z/OS DFSMS

z/OS DFSMS

z/OS DFSMS

z/OS Data Subsystem that delivers core Data, Data Resiliency and Data Lifecycle Management Solutions for your Enterprise.

 View Only

EZ Ordered Indexing!

By Alexis Kapica posted Tue February 13, 2024 10:30 AM

  

Please check out our No SQL for z/OS? So EZ! blog post for a high-level background on EZNoSQL. 

We are still enthusiastic about EzNoSQL and even more excited to announce this new functionality!

EzNoSQL now offers you two choices for your primary index: Ordered and Unordered. Let’s talk about each option and what it means for you with EzNoSQL:

Unordered Index:

Unordered Index randomizes the key-values to store the documents in the database. Using unordered index means that the keys cannot be searched sequentially and that the key-values will not be returned in order of insertion. Unordered index does not introduce any performance concerns when inserting the keys because of the randomization.

Unordered Index does have the ability to allow for an ordered search. Alternate keys are stored in order so to manually create an ordered search, users must define and add a secondary index. Please note that creating the alternate key will inherently require more space in the database.

Ordered Index:

Ordered Index is a completely new functionality for EzNoSQL that stores key-values in a manner that allows them to be searched sequentially forward or backward. Ordered index will also allow key-values to be returned in order of insertion.

Ordered Index may introduce some performance impacts when inserting many documents from multiple instances because the inserts will contend for the end of the database. However, this performance hit can be balanced when reading data as sequential ordered indexes allow for a speedy search and return.

 

What do you think about Ordered Index and Unordered Index? Does your shop have a use case for either option that you might be interested in pursuing? We would love to hear feedback from you in the comments on this blog post, the discussion section of the community page, LinkedIn, or now even on the System Z Enthusiasts Discord!

Come talk to us on Thursday, 3/7/24, at SHARE Orlando in our session "Accessing a NoSQL database on z/OS is Ez" where you can learn more about EzNoSQL and hear from an actual EzNoSQL user!

Learn more about EzNoSQL on our content solution page and get involved on our DFSMS Community to stay updated on any new announcements or blog posts from z/OS DFSMS on EzNoSQL!

Authors:

0 comments
26 views

Permalink