Database

RDBMS – Relational database management system is used for the last decades as the main data platform to store the company’s critical operational, business, and transaction data.

Relational databases are known for their safe transaction mechanism as data is saved persistently when it’s being saved/committed. Data is being saved in  tables with a predefined structured schema containing columns from different data types. The table presents a business entity like Orders, Order Items, Items, etc. The idea of relational databases is that every piece of data must be stored once to avoid conflicts between other data tables. When a user/application needs the data he can run  SQL Query on several tables using  join to link between the data tables to bring one logical record. The table must have a  primary key containing one or more columns that define the record’s uniqueness. Primary keys are used to prevent duplicate data in the table and a way to join between tables (entities). A relational database is also known for its data integrity so data will be stored clean, according to business rules and without duplication. To do that every relational database must  have the following constraints to keep the data integrity :

• Primary Key – Define the record uniqueness 
• Unique Key – define column uniqueness but can contain nulls
• Foreign Key – column or column values must exist in related tables.
  For example: in orderItems, the orderID must exist in Orders Table
• Check constraints – available values the column can have 

To enable queries to run fast on large tables databases are using indexes that are created on one or more columns with high cardinality where users can filter or sort by. 

Relational databases also use  stored procedures and functions to enable running database routines from the database itself. These objects are used to run heavy transactional operations inside the database to avoid large network traffic latency between clients and servers and run the operations close to the data inside a strong database server. Stored procedures are also used as the single point of business logic that all application components can use.

Triggers can also be used on tables to trigger another action when data is changed on the table. 

SeaData specializes in open source and cloud databases and provides consulting services and projects in the worlds of DBA and Data Engineering to the leading companies in Israel and the world.

Our great expertise is reflected in large databases as well as a large number of transactions and high data volumes

The databases in which we are experts: