Open Data Science Lab (B/C DSL)

Product / Content

product_datetime_properties

This table represents the content of the product properties with the format datetime. The product properties represent calculated data for each product which should be loaded in the Solr Index. By filling this table and declaring the properties in the product_properties_metada, the system will will automatically upload and create/update your product properties in the Solr Index.

origin,
product_id, property_name

product_localized_properties

This table represents the content of the product properties with the format localized text. The product properties represent calculated data for each product which should be loaded in the Solr Index. By filling this table and declaring the properties in the product_properties_metada, the system will will automatically upload and create/update your product properties in the Solr Index.

origin,
product_id, property_name

product_numeric_properties

This table represents the content of the product properties with the format numeric. The product properties represent calculated data for each product which should be loaded in the Solr Index. By filling this table and declaring the properties in the product_properties_metada, the system will will automatically upload and create/update your product properties in the Solr Index.

origin,
product_id, property_name

product_string_properties

This table represents the content of the product properties with the format string. The product properties represent calculated data for each product which should be loaded in the Solr Index. By filling this table and declaring the properties in the product_properties_metada, the system will will automatically upload and create/update your product properties in the Solr Index.

origin,
product_id, property_name

product_properties_metadata

This table represents the definition of product properties to be added to the SolrIndex. By filling this table (and optionally defining the data of these properties in the other product_properties tables of the lab datset, the system will will automatically upload and create/update your product properties in the Solr Index.

origin,
name

Customer

customer_properties

This table represents the content of the customer properties. The customer properties represent calculated data for each customer which should be loaded in the real-time database. By filling this table, the system will will automatically upload and create/update your customer properties in the real-time database.

origin,
customer_id, property_name

profile_properties

This table represents the content of the profile properties (the profile corresponds to a visitor of the web-site recognized by a long lasting cookie). The profile properties represent calculated data for each profile which should be loaded in the real-time database. By filling this table, the system will will automatically upload and create/update your customer properties in the real-time database

origin,
profile_id, property_name

Resources

correlations

This table represents the content of the real-time correlations The correlations represents data which are loaded based on a provided name (type) and key (source) which loads them a list of targets each of them with parameters. By filling this table, the system will automatically upload and create/update your correlations in the real-time database.

origin,
type,
source,
target

resources

This table represents the content of the real-time resources The resources represents data which are loaded based on a provided name (type) which loads them a list of parameters. By filling this table, the system will automatically upload and create/update your resources in the real-time database.

origin,
type,
id

pmml

This table represents the structure to store PMML files as strings.

origin,
name,
version

Search

autocomplete

This table represents the content of the autocomplete index. The autocomplete index represent the textual suggestions appearing while people are searching on your web-site before they press enter. By filling this table, the system will stop using the standard autocomplete index and use the content of this table instead.

origin,
id,
language,
textsuggest

compounds

This table represents the content of the compound index. The compound index represent the words used by Solr to split words in several pieces. By filling this table, the system will stop using the standard compound index and use the content of this table instead.

origin,
language,
compound

corpus

This table represents the content of the corpus index. The corpus index represent all the words which exists in the indexed records . By filling this table, the system will stop using the standard corpus index and use the content of this table instead.

origin,
id,
language,
textsuggest

properties

This table represents the content of the properties index. The properties index represent all the properties you would like to make searchable and completable (for example, the search for an author in a books store). By filling this table, the system will stop using the standard properties index and use the content of this table instead.

origin,
id,
language,
name

stopwords

This table represents the content of the stopwords index. The stopwords index represent all the words which should be removed from the search beavhiors. By filling this table, the system will stop using the standard stopwords index and use the content of this table instead.

origin,
language,
stopword

synonyms

generates a file like this: https://github.com/apache/lucene-solr/blob/master/solr/example/files/conf/synonyms.txt%5Cn%5Cnif bidirectional then:\n- source + coma + join(coma, targets)\nelse\n- source => targets[0]

origin,
source,
target