Where is the data stored?

To store information in a method that allows easy and fast retrieval, a relational database is required.   The management of a relation database requires an individual with a strong background in SQL.   ProTracSys's software Silo performs the required database management functions to store and retrieve data.   Thus, eliminates the need for a database expert.

Silo will store incoming data from the RCU into the corrsponding Data Container in the database.   It is important for a customer to maintain access to their data.   Silo provides standard methods to access the data.   If one of the standard methods does not meet the customer's needs, an ODBC connection is provided that gives full open access to the data. This allows the customer to create a method to move data to another system or process.  

SQL (usually pronounced either "see-kwell" or as separate letters) is a computer language designed for the retrieval of data in relational database management systems (RDBMS) and the management of the database schema creation. SQL is an acronym for Structured Query Language. [Wikipedia: SQL]

A Data Container is where the plant floor data is stored in the database. Several database items are required to store data in an efficient manor. The database items includes tables, indexes, joining tables, security, and queries to access the data. A Data Container differs between recording a serial number versus recording a measure. Silo manages the database by creating the required Data Container structure based on what needs to be recorded.

PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. [postgresql.org]

Open Database Connectivity (ODBC) is a standard software API specification for using database management systems (DBMS). ODBC is independent of programming language, database system and operating system. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC achieves this by inserting a middle layer called a database driver between an application (ex: spreadsheet) and the DBMS. [Wikipedia: ODBC]