Using QLDB for different groups

Question

I am planning to use QLDB as registries of data integrity and verifiability.

If I have 1 journal, and I am planning to use the journal for different groups, in which each group has its members.

Let say, I will have 2 groups:
•	Group 1: Financial services with 10 members
•	Group 2: Supply chain with 15 members

How can I identify each group and its members when I want to export to S3 storage, where I can sort and store transactions into each corresponding group. So, I can use it for further data queries, etc.

Thanks & regards,

Prajit

Giovanni Lauria · Accepted Answer

You can incorporate group and member information into your QLDB ledger data model. This way, when data is exported to S3, this information is included.

Once data is in S3, you can use AWS Glue for data processing and Amazon Athena for querying and you can specify a prefix for the S3 bucket to help organize data by group.

rePost-User-4757454 · Answer

OK, thanks for the answer.

Let's say group 1 has 4 tables.

When insert documents into each table, incorporate in EACH document name-value pairs (sort of like a header) of the group and member information.

For example: {GroupName : value1, GroupID : value2, MemberName : value3, MemberId : value2}.

Using QLDB for different groups

Add your answer

Relevant content