Contact Us | Site Map
Firebird is used by approximately 1 million of software developers worldwide. High compatibility with industry standards on many fronts makes Firebird the obvious choice for developing interoperable applications for homogeneous and hybrid environments.
MASA — Statistical analysis and plan optimization solution for industrial plants
Moderator contact: case@firebirdsql.org
View this Case Study in PDF format:  English | Čeština
About us

Elekt Labs is a Czech software company with an international scope. We develop and deploy systems for data collecting, planning and optimization in manufacturing since 2004.

Our customers include Kingspan a.s., global leader in design, development and delivery of advanced building envelopes, for which we have implemented automatized planning, operational control and manufacturing optimization. For manufacturers Ball Aerocan CZ s.r.o. and MORAVIA CANS a.s. we collect and evaluate data from manufacturing lines with connection to ERP and attendance systems. Our software is deployed in many other companies in Czech Republic, Poland and Hungary.

Business challenge

Our main goal is to develop the universal system with high degree of customization with these basic properties:
  • MES — connection between manufacturing technology and ERP
  • Quantification of manufacturing process parameters (OEE, SPC, Cp, Cpk, …)
  • Evidencing of the manufacturing process for audits and certification
  • Record of changes in machine setting to ensure technological discipline
  • Material flow management and traceability.
Solution

We have chosen the Firebird database for our new system MASA II for several reasons:
  • Commercial friendly open source license
  • Native support in Delphi
  • Native provider for Microsoft .NET
  • Easy installation and maintenance
We have developed a set of applications providing connection with technological units (DataCross, …) and diagnostic and maintenance tools (backup monitor, E-mail agent, database monitor, ...). For data presentation, we have chosen a web application technology, which is a visible part of the system. Special customer requirements are programmed as stand-alone modules.


Block diagram of a typical system MASA II installation

Technical details

Our largest installation of the Firebird SQL has these attributes:
  • Database size: ~70 GB
  • Average daily database increase: ~80 MB
  • Connection with economic systems (SAP, …)
  • Connection with attendance systems
  • Terminals connected in manufacture:
    • Number of terminals with text-mode emulation: 32
    • Number of graphical terminals: 8
  • Number of terminals in quality control centre: 12
  • Number of online connections with database: 43
  • Average number of transactions per second: ~3.4
  • Average number of transactions per day: ~290 thousand
  • Server: MS Windows Server 2008 R2 64 bit
  • Database engine: Firebird 2.5.2-64 in SuperClassic mode with UDF usage
  • Operating time: 24 x 7
Example of graphical preview of „Lis 3“ machine usage during 8 hour shift. Moreover, you can see a basic performance characteristic of the machine and its operators

Conclusion

We have a long experience with the Firebird database since version 1.0 and we currently work with version 2.5.3 (32 and 64 bit version).

Firebird provides comparable quality and performance in comparison with commercial databases. Its main advantage is commercial friendly open source license, which allows us to invest more to quality and complexity of our system and to keep high price-value ratio.

Contact

www.elektlabs.cz
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velký Týnec
Czech Republic

Ing. Milan Kluger
Project Manager of Elekt Labs s.r.o.
E-mail: klugerm@elektlabs.cz
Phone: +420 776 007 806
Home About Firebird Documentation Downloads Community Support Development Case Studies Back to Top
This site and the pages contained within are Copyright © 2000-2016, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated. Developed by DQ Team.