Establishment of Color Matching Database Based on MySQL

摘要

Color matching system is a specialized software solution geared towards spot color matching. It contains spectral reflectance import, data calculation, and formula export. In virtue of a generic open data base connectivity (ODBC) interface, data analysis is performed by statistics and analysis software connecting to a database. The color matching database (CMD) application is developed in ink formulation studies, and is established including four modules: primary ink information database, substrate information database, spot color database (target color), and ink formula database. This paper describes the design and establishing of CMD. The database is built on MySQL. Formula ink can be selected by searching target color number. The results show that the adoption of MySQL program application is feasible, flexible, low-cost and user-friendly way of managing research data in color matching system.