Terminology

CYPEX terminology and samples

This section will describe the most important aspects of CYPEX terminology.

CYPEX “entities”

In CYPEX you use existing SQL models to build new and powerful applications. The first term we need to discuss is the idea of an “entity”. We use the same semantics as in a standard relational model: an entity is a table which is tracked by CYPEX. All tracked entities will be part of the GUI prediction which is made based on the data structure. If an entity isn’t tracked by CYPEX, it won’t be included in that prediction.

Read full post

CYPEX internals

In this section, you’ll be guided through the internals of CYPEX. You’ll get to know the basic architecture of the solution and gain some insights into how things work. It helps to understand some basic concepts, in order to use CYPEX even more efficiently.

CYPEX software architecture

Before you look at the architecture of a CYPEX app from an end user perspective, you’ll first want to understand the overall software layout:

Read full post

Glossary

>Abstraction layer	software that translates higher-level requests into lower-level commands the computer can use (for example, an API, or Application Programming Interface, is an abstraction layer which communicates between an application and the operating system.)
FDW	Foreign Data Wrapper: “a library that can communicate with an external data source, hiding the details of connecting to the data source and obtaining data from it.” source: PostgreSQL Documentation
GUI	Graphical User Interface: the software which allows users to visually control an underlying data structure, as opposed to a command-line interface, which requires the user to memorize text-based commands.
JSON	JavaScript Object Notation is a common data format used to exchange data, i.e. between web applications and servers. JSON is a language-independent data format. JSON file names use the extension .json. source: Wikipedia
relational model	“The relational model (RM) for database management is an approach to managing data using a structure… where all data is represented in terms of tuples, grouped into relations… Users directly state what information the database contains and what information they want from it, and let the database management system software take care of describing data structures for storing the data and retrieval procedures for answering queries.” source: Wikipedia