Research on Database Layer in CNC Machine Tools

The digital static architecture system is divided into three layers in the static architecture design: database layer, middle layer and user layer. The database uses Oracle 9i, the database model uses EDM. The middle layer uses Sun V890 as the Tomcat and Apache application server. At the same time, there is one server with the same configuration as the backup server. When the main server fails, it can guarantee the application. Intermittent. All applications are connected to the TWS, and TWS provides user authentication, access control, entry, processing, reporting, and management navigation. The user layer uses the browser of IE6.0 or higher to apply the system through TWS user authentication.

From bottom to top, the entire system is designed in four layers: database storage layer, data persistence layer, business logic layer and Web presentation layer. The database storage layer stores the real Oracle database. In the data persistence layer, the Java object and the database relationship are mapped one by one. During the execution of the system, the user operates the database by manipulating the corresponding object of the data persistence layer. The business logic layer is used to complete the user's business logic.

This is consistent with traditional programming ideas. At the Web presentation level is mainly the user interface, which provides direct interaction between the user and the system. The four levels of the system are interconnected and coordinated through the Spring container. In the Spring configuration file, the relationship between the database and the data persistence layer is configured; the relationship between the persistence layer and the business logic layer is configured; and the relationship between the business logic layer and the Web presentation layer is configured. In this system, the Web presentation layer is first managed through the Struts framework, and then Spring connects Struts as a Web framework to the Spring-based business persistence layer.

(Finish)