3.x Glossary
From Fabrik
The Fabrik interface and tooltips contain references to many terms that cover a variety of languages and applications as well as internal Fabrik references.
This page serves as a glossary for all terms that exist within the Fabrik interface.
Columns are sortable by clicking on the 'sort' icon next to the column heading.
| Term | Context | Language | Description | More |
|---|---|---|---|---|
| Eval
| Eval () is used to evaluate the input string as PHP. It is like using the Echo () function in the sense that it outputs everything, except instead of outputting it as text, it outputs it as PHP code to be executed. One use of this is to store code in a database to execute later - source
| |||
| Concat
| The CONCAT () function is used to concatenate two strings to form a single string - source
| |||
| Concat WS
| CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The separator can be a string, as can the rest of the arguments - source
| |||
| RDBMS
| N/A,
| General
| Stands for 'Relational Database Management System'.
| |
| Calc
| ,
| ,
| -
| ,
, , |
| Functions
| Functions are programs which when called return a single value, they must always return a value and will always return just one value. They can be relatively simple or a little more complex including multiple lines of code or just a single line - source
| |||
| Database Join (aka Joins)
| ,
| ,
, , | ||
| Primary Key
| ,
| Every database table has its own unique identifier, ie that which makes each row unique - for example an order number or an application number. In a table of hundreds of records if the primary key was 'order_id', you could easily find order number 5, as this would be the only record with an 'order_id' of 5 - after source
| ||
| Foreign Key
| The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. For example if you had two tables CUSTOMERS and ORDERS, the primary id of CUSTOMERS could be customer_id, and you could record which customer made orders by having a customer_id field in the orders table, the latter being the foreign key - after source
| |||
| One to one relationship
| ,
| One-to-one relationships occur when there is exactly one record in TableA that corresponds to exactly one record in TableB - source
| ||
| One to many relationship
| ,
| One-to-many relationships occur when each record in TableA may have many linked records in TableB but each record in TableB may have only one corresponding record in TableA - source
| ||
| Many to many relationship
| ,
| Many-to-many relationships occur when each record in TableA may have many linked records in TableB and vice-versa - source
| ||
| Loop
| ,
| ,
| ||
| Normalization
| All
| Relational Databases
| Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships - source
|
To add a new entry to the 'Fabrik Glossary' in 'Rich Editor > Wikitext' mode add the following block directly before the |} which marks the end of the table:
|- | style="background-color:#ffd9f7; vertical-align: top;" | <div style="padding: 15px 10px 20px 10px;">Term</div> | style="background-color:#ffd9f7; vertical-align: top;" | <div style="padding: 15px 10px 20px 10px;"> [[3.x Elements|FabrikAreaLink]],<br> [[3.x Elements|FabrikAreaLink]]</div> | style="background-color:#ffd9f7; vertical-align: top;" | <div style="padding: 15px 10px 20px 10px;">[http://www.google.com Language]</div> | style="background-color:#ffd9f7; vertical-align: top;" | <div style="padding: 15px 10px 20px 10px;">Description here, 3-4 lines. - [http://www.google.com source]</div> | style="background-color:#ffd9f7; vertical-align: top;" | <div style="padding: 15px 10px 20px 10px;"> [http://www.google.com link1.com],<br> [http://www.google.com link2.com],<br> [http://www.google.com link3.com],<br> [http://www.google.com link4.com]</div>
