|
|
|
|
||
![]() The TCPOS architecture is conform to the Microsoft 'Smart Client' standard. It consists of three different levels: 1) Client The 'client' level is in turn divided in a series of sublevels that take care of the local database (Data Access Layer), the business logic (Business Logic layer), the applicative customizations (Plug-in Layer), the user interface (Presentation Layer) and the peripherals (Device Interface Layer) all under the Coordinator control. Graphic components (simple controls and grids) and the reporting engine are developed using libraries produced by the company DevExpress. Cash registry implements the SQLite embedded database, a third party module, which use is free and the sources are available without restrictions. Charts are built by using all integrity criteria made available by the database. A precise pattern is used for the primary keys, univocity bonds, reference integrity and e verification of the values granted in the fields (check constraint). It is possible to add new fields to existing tables and new charts to the database. The software supports the management of this data from the data entry to the memorization in the database after a sale transaction. Triggers are used to grant the 'cascade' propagation of various operations (e.g. update the balance of a customer card when a transaction is entered or deleted) in order to grant the data transactional integrity. Some triggers are also used to carry out checks that can't be performed through constraints standard of database engines. The client access to the data is mediated by a middle tier available in the same local network of the database server. No client has direct access to the database. TCPOS allows using a remote database through the middle tier, which can be on a machine different from the database. ADO.NET is the application access mode to the DB. |
||||
|
|
|
|||