Data Structure

The data structured is a document-oriented structure (https://en.wikipedia.org/wiki/Document-oriented_database) with, for each data types, a fully JSONL compatible structure.

JSONL = Newline delimited JSON ( https://en.wikipedia.org/wiki/JSON_streaming )

The structure is based on a Google BigQuery representation of tables and the data types structure are provided in the BigQuery table formats.

The Boxalino Data Structure is composed of the following data types:

Data Type

Label

Description

Data Type

Label

Description

1

doc_product

Products data

All the data about products

2

doc_attribute

Attributes

List of attributes (for products and other entities)

3

doc_attribute_value

Values of attributes

Values of attributes (for products and other entities), like a category tree

4

doc_language

Languages

List of languages

5

doc_order

Orders (purchases)

Transactions made in the e-shop or offline

6

doc_user

Users (customers)

Customers data

7

doc_user_generated_content

User Contents (ratings, reviews, …)

Content generated by users (public or not)

8

doc_user_selection

User Selections (wish-list, baskets, …)

Selection customers have made of products or other entities (all types, including pinning and thumbs up/down, …)

9

doc_content

Headless content

All type of content (headless)

10

doc_bundle

Product bundles

Products groups within a bundle deal

11

doc_voucher

Vouchers / Coupons

Vouchers for customers

12

Omnichannel

 

 

13

communication_history

Omnichannel

History of Omnichannel Communications

14

communication_planning

Omnichannel

Planning of future Omnichannel Communications