Page History

Nearly any application developed on the SimpleOne platform involves platform involves:

• The information exchange between users, third-party

• services and the application itself

• .
• The data processing.

• It means that the application receives the information, processes, and stores it

• . Then the information is consumed by the user and third-party services.

It (systems). Therefore it is important to approach the design and preparation of the data structure that will be used to store and process information based on the business task an for which the application is designed to performimplemented.

Despite the fact that Although data and information are similar in meaning, there is a significant difference between them. Information is precise accurate and structured data. In other words, before the data becomes information, they it must be structured. To build a data structure, a data model is used.

Data model

A data model is an abstract description of a the data structure, which determines interrelations between the data, methods of their processing as well as how one item of data relates that defines the relationships between data, how data is processed, and how one data element is related to another.

There are various data models, which that differ in their approach to description of describing data organizationstructure. For example an , a hierarchy model describes the data as a tree structure, consisting that consists of objects of different levels. In the SimpleOne system uses the relation relational data model is used, based on relations and operations with these relationsthem. The  The main notions concepts of the relation relational data model are relation, attribute, tuple,and primary key. In the SimpleOne data structure these correspond , they correspond to the table, column, table row, which has a unique identifier within the table.

Tables

The SimpleOne platform stores all its data and business logic settings of the configuration as records in specific tables.

From In this set of articles you will , learn about the role of tables in the SimpleOne system, and their properties , relevant to the development of the that are important for designing a data structure. A separate article is dedicated to describes the classification of tables.

Columns

Tables consist of columns each of which . Each column corresponds to a specific attribute of the information object and has its own data type.

From In this set of articles you will , learn about properties and attributes of columns relevant to the development of the that are important for designing a data structure, using dot-walking in scripts as well as , how to change the column name and column types type in certain specific cases.  

Records

A The record (is represented as a row in a relation table) relational table row. It is a set collection of logically related fields corresponding that corresponds to a specific particular instance of an information object. Each record in the system has a unique identifier.

From In this article you will , learn about the record attributes and operations with them.

Extending the Data Model

In cases when creating Instead of creating a data structure model from scratch is not practical, the SimpleOne system allows you to adapt previously prepared the "out-of-the-box" data structures to suit the requirements of the business solution. From

In this article you will learn about the data model extension methods available in the SimpleOne system, each of which has its uses, strength and weaknessesSimpleOne. Each method has its own scope, advantages, and disadvantages.

Version Control of Data Structure Changes

All changes of to the data model, irrespective regardless of its methods, are collected into configuration packs in configuration packages and applications.

This article provides general recommendations on for creating configuration packs packages and applications.