batype

Guangdong Dynamic Monitoring Platform - June 2020 - July 2021 Responsibilities: Primarily responsible for project development, technical support, framework services, deployment, and handling urgent program issues. Content: This project also adopts a fully backend-separated architecture. The difference lies in the changes made to the architecture, including the addition of interface-based data acquisition and dynamic data source switching. Project Architecture: Composed of a frontend + display service backend + data crawling server + timer-based data processing server + interface-based data acquisition server + third-party data acquisition server. In front-end development, the project uses a 4-layer process page processing architecture. Temporary data storage uses sessions, ensuring page independence, reducing dependencies, increasing project scalability, and facilitating development by using effective page data transmission. The timer data processing server differs in that it needs to be compatible with multiple different data sources, primarily Oracle, DB2 (and its AS400 version), and MySQL. It handles their different syntaxes, connection tool classes, connection initialization, and other issues. Backend data message transmission uses a specific encryption method. The third-party interface program mainly provides data for third parties to interface with, aggregate and return data, perform data statistics, and complete the display. Technologies: React, Ant Design, Spring, Spring Boot, MyBatis, Spring Security, OAuth2, SQLite, MySQL, Redis, etc. Housing Provident Fund Supervision and Management Cloud Platform - August 2019 - May 2020 Responsibilities: Primarily responsible for project development, technical support, framework services, deployment, and handling urgent program issues. Content: The Housing Provident Fund Supervision and Management Cloud Platform development utilizes a front-end/back-end separation architecture. Project Architecture: Composed of a front-end + display service back-end + data scraping server-end + timer-based data processing server-end. Front-end development utilizes the React framework, supplemented by Ant Design, Amap, ECharts, MobX, and Axios, leveraging Webpack for file bundling and compression. Back-end technical support utilizes the Spring Boot microservice framework for writing the data display layer server-side program. In terms of data acquisition, all data comes from various on-site databases. A timer server program is written, using a method strategy with a frequency ranging from 5 minutes to 1 hour, applicable to various core version libraries. Data is temporarily stored using the lightweight SQLite database, awaiting data retrieval from the company's client server. Due to company restrictions, this method strategy is used. In terms of program implementation, MyBatis is used to parse SQL statements, and XML configuration files are used for SQL configuration. Dao4j is used to parse the XML to obtain the corresponding SQL. XMLScriptBuilder is used to process the obtained SQL and generate SQLSource resources. Based on the SQLSource, a boundSql object is obtained to obtain compiled resource objects with placeholders. The placeholder information data is obtained, and the corresponding parameters are replaced to complete the executable SQL. The data scraping client updates data every 5 minutes, allowing for real-time data comparison and updates. A micro-frontend service framework is used for integration, loading third-party service programs. Technologies: React, Ant Design, Spring, Spring Boot, MyBatis, SQLite, MySQL, Redis, etc.