Datasets: the expandable data model

Zenario comes with a range of module-based "data managers" for a range of tasks: Users/Contacts; Companies; Locations; Documents; and more. These data managers give your administrator access to create, update and delete records. More data managers can be created.

While all of these data managers come with a minimal set of "system" fields, the key thing is they can easily be expanded so that you can store additional fields, as you may require for your sites application.

This is the idea of datasets: a dataset is the basis of one of the above data types, which is designed in a flexible way, so as to adapt as your site grows.

Here for example is a screenshot of a user front-end (a hotel search system) in which a plugin is drawing data from a location dataset-based system. The various facilities of the hotels (star rating, wifi access and so on) are all custom dataset fields that the site owner has added to the Location data model:

Google ChromeScreenSnapz002.png

                                Location datasets used in a custom module to provide search
                                                           functionality for a hotel website 

Control your data model

There are several types of dataset fields available to use when modelling your data, they consist of select lists, date selectors, multiple radio buttons, countries, centralised lists, groups, URLs and text areas.

Some dataset fields are automatically generated by some modules, and these are the module's "system fields". For example, for the Users module, the Email, First Name and Last Name fields are system fields. System fields are inherently protected from accidental removal by administrators, as other plugins and modules rely on them.

You can extend many Zenario data managers, including: Users & Contacts; Documents; Confidential Documents; Locations; Companies; Countries; and Regions.

Datasets are fast

When a data manager is based on datasets, it consists of two MySQL database tables:

  • the basic table, containing all of the "system" fields
  • an extra-data table, to which new columns are added when dataset fields are created.

For checkbox- and list-type fields (checkboxes etc.) there may be additional tables employed to store the related data. There is considerable control over which fields are given MySQL indexes, and which are searchable and sortable in Organizer.

With this data model, the experience of managing data in Organizer is fast, and we have experience of managing dataset-based information with 250,000 records and more.

Users & Contacts

A company such as a mediation service may need to hold a lot of data about different types of mediators and their positions and be able to see this data on Zenario. The table below shows how adding in certain dataset fields can extend the data being stored.

Dataset Field   
Example 

Multiple radio-buttons

"Mediator Status"
(Using the values: Qualified, Applied, Approved, Suspended.
Each user can be assigned a status.)

Multiple Checkboxes
(Selection of languages)

The language or languages that a Mediator can speak
can be selected.
This information can then be used as part of a
Mediator search on the front end of your web site. 

 

Documents and Confidential User Documents

A Document's data can also be extended. For example if a car manufacturer had a list of car manuals that they wanted to make searchable, some extra dataset fields can be added to the document metadata in order to further define what each document relates to.

Dataset Field
Example
Select List "Car Manufacturer" 
(E.g. Ford, Toyota, Mercedes etc.)
Text "Volume", "Month" or "Year" could be added.

 

Locations

A booking site for hotels could use datasets to extend the pre existing data model by being able to categorise the types of hotel that are on the site.

Dataset Field
Example
Single Checkbox List of accommodation types
(Hotel, Guest House, B&B)
Group Group hotels into star rating groups

 

Companies

The Companies dataset is linked with the "Company Locations Manager" module and extends the "Location Manager" module. It gives you the ability to create customers and under that enter locations for each customer. For example a furniture maker may have their furniture sold by many different customers, that have many different stores around the country and they want to know. 

Dataset Field
Example
Date "Start/end date of contract"
URL "Customer Website"

 

Note that there is also an option to activate an industry code box which has all of the codes that can be assigned to the different types of industry your customers are in.

Centralised List

One of the types of field that can be used in your dataset is a Centralised List. This type of field is beneficial when there is a long list for lookups, such as countries, where the values will always stay the same. New centralised lists can also be created by developers, which in turn can be chosen as a dataset field.

Show new fields in Organizer

Dataset fields can be shown in the Organizer panel and also be made searchable and sortable for easy display in the back-end. They can also be protected from deletion, by simply ticking an option when creating. This means that other administrators of the system (without the right permission) will not be able to delete or modify this field.