Problem tracking platform based on SKYWALKING technology and tracking method thereof

Abstract

The invention belongs to the technical field of application performance management, and discloses a SKYWALKING technology-based problem tracking platform and a SKYWALKING technology-based problem tracking method, which comprise system structure design, function module design, user interface design, safety and performance optimization, test and deployment, the system structure design comprises a front end, a rear end, a database and a monitor, the function module design comprises a user management module, a problem management module, a communication and cooperation module, a data analysis module and a monitoring and alarm module. And through a comment system and a file sharing function, rapid solving of problems is promoted. And the data analysis module provides detailed data support for managers by using statistical reports and processing aging analysis, so that decision optimization and process improvement are facilitated. The functional modules jointly form an efficient and flexible problem tracking and management system, and the agility and reliability of software development, operation and maintenance are greatly improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of application performance management, and in particular relates to a problem tracking platform and a tracking method thereof based on SKYWALKING technology. Background Art

[0002] The problem tracking platform is a software tool designed for recording, tracking and managing various problems. It aims to assist enterprises and teams in building efficient problem handling processes, effectively manage various problems, and carefully record the progress of each problem. SkyWalking is an open source, observability platform that focuses on providing comprehensive application performance monitoring (APM) capabilities. It helps developers and operation and maintenance personnel fully understand the operation status of applications through distributed tracing, application performance monitoring, metric aggregation and alarm functions. SkyWalking is designed for microservices, cloud native and containerized architectures, and supports multiple languages ​​and frameworks, such as Java, .NET, Node.js, etc.

[0003] Although conventional issue tracking platforms can record, track and manage issues, they often have difficulty coping with the cross-platform and cross-language development environment that is prevalent in modern software development. With the widespread application of microservice architecture, containerization and cloud-native technologies, enterprises usually build services on different platforms (such as Docker, Kubernetes, etc.) and using different programming languages ​​(such as Java, Python, Go, etc.). In this case, traditional tracking platforms are prone to data fragmentation and incomplete monitoring, because different platforms and technology stacks require different monitoring tools, which not only increases management costs, but may also lead to inconsistency and difficulty in integrating monitoring data.

[0004] At the same time, as the scale of distributed systems continues to expand, traditional problem tracking platforms may encounter performance bottlenecks. In high-concurrency, low-latency scenarios, traditional monitoring tools may not be able to collect and analyze system monitoring data in a timely and accurate manner, resulting in lags and missing monitoring data. This directly affects the timely discovery and resolution of problems, and may even cover up potential problems in the system. Summary of the invention

[0005] The purpose of the present invention is to provide a problem tracking platform and a tracking method thereof based on SKYWALKING technology to solve the problems raised in the above background technology.

[0006] In order to achieve the above-mentioned purpose, the present invention provides the following technical solutions: a problem tracking platform based on SKYWALKING technology, including system structure design, functional module design, user interface design, security and performance optimization, testing and deployment, the system structure design includes front-end, back-end, database, and monitoring, the functional module design includes user management module, problem management module, communication and collaboration module, data analysis module, monitoring and alarm module, the user interface design includes dashboard design, problem list page, problem details page, the security and performance optimization includes safety measures and performance optimization, and the testing and deployment includes testing strategy and deployment plan.

[0007] As a further technical solution of the present invention, the front-end uses React and Vue.js to build the user interface, the back-end provides a RESTful API through Java / Spring Boot, the database uses MySQL / PostgreSQL to store user and problem data, and the monitoring uses SkyWalking as an APM tool to collect performance data and display the call chain diagram.

[0008] As a further technical solution of the present invention, the functions of the user management module include user registration / login, role management (administrator, developer, tester), and authority allocation, and the APIs correspond to POST / api / users / register, POST / api / users / login, and GET / api / users / {id} (query user information), respectively. The functions of the problem management module include creating problems, updating problem status (pending, in progress, resolved, closed), and problem priority setting (low, medium, high, urgent), respectively, and the APIs correspond to POST / api / issues (create problems), PATCH / api / issues / {id} (update problems), and GET / api / issues (get problem list).

[0009] As a further technical solution of the present invention, the functions of the communication and collaboration module include a comment system, file upload and sharing, and the corresponding APIs are POST / api / issues / {id} / comments (add comments) and POST / api / issues / {id} / attachments (upload files). The functions of the data analysis module include generating problem statistical reports and problem processing time analysis. The API for statistical reports is GET / api / reports / issues / statistics (get statistical reports), and the API for processing time is GET / api / reports / issues / {id} / timing (get processing time). The functions of the monitoring and alarm module include real-time monitoring of problem processing and setting alarm rules. The corresponding APIs are POST / api / alerts (set alarm rules) and GET / api / alerts (get alarm list).

[0010] As a further technical solution of the present invention, the dashboard design includes displaying key indicators, namely the number of pending issues, active users, and average processing time, and uses Chart.js and Echarts to display visual charts. The issue list page includes a table that supports sorting, filtering, and paging, and each issue row supports quick viewing of details. The issue details page includes all information about the issue, including comments and attachments, as well as a status update button and a priority adjustment drop-down box.

[0011] As a further technical solution of the present invention, the security measures include that all API interfaces must verify user identity through JWT and perform secondary confirmation of sensitive operations. The performance optimization includes using cache, i.e. Redis, to store commonly used data, reducing database access, and separating the front-end and back-end to ensure front-end loading speed and optimize resource loading through lazy loading.

[0012] As a further technical solution of the present invention, the testing strategy includes unit testing and integration testing, wherein the unit testing uses JUnit and Mockito, the integration testing includes API testing using Postman / Newman, and the deployment solution includes using Docker containerized applications to simplify the deployment process and CI / CD integrating Jenkins or GitHubActions to achieve automated building and deployment.

[0013] The tracking method of the issue tracking platform based on SKYWALKING technology includes the following steps:

[0014] S1: Goal and demand analysis, determine the core functions and user roles of the tracking platform, and clarify the functional modules to meet user needs;

[0015] S2: System architecture design, select the appropriate technical framework and microservice architecture to ensure that the system has high concurrent processing capabilities and flexibility;

[0016] S3: Module division, which divides functional modules, including problem management, tracking and feedback, to facilitate the organization and management of the system;

[0017] S4: Function refinement, refine the user operation process, and ensure a closed loop of problem submission, status checking and feedback collection;

[0018] S5: API interface design, design RESTful API interface, and provide standardized data access and operation methods;

[0019] S6: Database design, formulate the database table structure, and clearly organize the data for storing problem information, status change history, and user feedback;

[0020] S7: User interface design, design a simple user interface to ensure that users can operate it easily on different devices;

[0021] S8: Security design, implement user authentication and permission control to ensure secure and compliant access to system data;

[0022] S9: Performance optimization, introducing cache mechanism and load balancing to improve the system's response speed and stability;

[0023] S10: Test plan, develop a comprehensive test plan covering unit testing, integration testing and user acceptance testing to ensure functional stability;

[0024] S11: Deployment strategy, using containerized deployment and CI / CD processes to simplify environment configuration and version management and improve launch efficiency;

[0025] S12: Maintenance and iteration, establish user feedback mechanism and system monitoring, and continuously optimize functions and performance to meet changing needs.

[0026] The beneficial effects of the present invention are as follows:

[0027] 1. By applying the APM tool SkyWalking, the present invention enables the platform to comprehensively monitor the application performance under microservices, cloud native and containerized architectures, effectively solving the problems of data fragmentation and incomplete monitoring faced by traditional tracking platforms in complex technology stacks. Whether it is a service built in languages ​​such as Java, Python or Go, the platform can provide a unified monitoring perspective to ensure the consistency and integrity of monitoring data. At the functional level, the user management module ensures the security and compliance of system access through refined role division and authority control. The problem management module provides a complete process from problem creation, status update to priority setting, supporting efficient problem tracking and processing. The communication and collaboration module further strengthens the information exchange between team members, and promotes the rapid resolution of problems through the comment system and file sharing function. The data analysis module uses statistical reports and processing time analysis to provide managers with detailed data support, which is convenient for decision optimization and process improvement. These functional modules together constitute an efficient and flexible problem tracking and management system, which greatly improves the agility and reliability of software development and operation and maintenance.

[0028] 2. By introducing the Redis cache mechanism, the platform can effectively reduce the number of database accesses, reduce system load, and improve response speed. At the same time, the design of front-end and back-end separation ensures the rapid loading of the front-end page, and further optimizes the resource loading efficiency in combination with lazy loading technology, thereby improving the user experience. In addition, the platform also uses the JWT verification mechanism to protect the API interface, ensure the security of sensitive operations, and prevent unauthorized access. In terms of testing and deployment, the platform has formulated a comprehensive testing strategy, including unit testing and integration testing, using JUnit and Mockito for unit testing to ensure code quality; using Postman / Newman for API integration testing to verify the interaction and collaboration between the components of the system. The deployment solution uses Docker containerized applications, combined with CI / CD processes (such as Jenkins or GitHub Actions), to achieve automated construction and deployment, simplify environmental configuration and version management, and improve online efficiency. This series of measures not only improves the stability and reliability of the system, but also accelerates the software iteration cycle, meeting the needs of modern software development and operation and maintenance for efficiency and flexibility. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 It is a block diagram of the overall system structure of the present invention;

[0030] Figure 2 Design a block diagram for the system architecture of the present invention;

[0031] Figure 3 Design a block diagram for the functional modules of the present invention;

[0032] Figure 4 Design a block diagram for the user interface of the present invention;

[0033] Figure 5 This is a safety and performance optimization block diagram of the present invention;

[0034] Figure 6 This is a test and deployment diagram of the present invention. DETAILED DESCRIPTION

[0035] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0036] like Figures 1 to 6 As shown, in the embodiment of the present invention, the problem tracking platform based on SKYWALKING technology includes system structure design, functional module design, user interface design, security and performance optimization, testing and deployment. The system structure design includes front-end, back-end, database, and monitoring. The functional module design includes user management module, problem management module, communication and collaboration module, data analysis module, monitoring and alarm module. The user interface design includes dashboard design, problem list page, problem details page, security and performance optimization includes safety measures and performance optimization. Testing and deployment includes testing strategy and deployment plan.

[0037] Through systematic structural design, functional module division, user-friendly interface design, strict security and performance optimization measures, and comprehensive testing and deployment strategies, efficient problem tracking, management, communication and collaboration are achieved. The platform not only improves the efficiency of problem response and resolution in the process of software development and operation and maintenance, but also enhances team collaboration capabilities, and ensures the stability and efficient operation of the system through data analysis and monitoring alarm functions.

[0038] like Figure 2 As shown, the front-end uses React and Vue.js to build the user interface, the back-end provides RESTful API through Java / Spring Boot, the database uses MySQL / PostgreSQL to store user and problem data, and SkyWalking is used as the APM tool for monitoring to collect performance data and display the call chain diagram.

[0039] The front-end interface is built with React and Vue.js, combined with the RESTful API back-end service provided by Java / Spring Boot, and the MySQL / PostgreSQL database to store user and problem data. This platform builds an efficient and flexible problem tracking system. As an APM tool, SkyWalking deeply monitors and displays system performance data and call chain diagrams to ensure that problems are quickly located and solved. This design not only improves the user experience, but also enhances the maintainability and scalability of the system, providing a solid guarantee for team collaboration and software development quality.

[0040] like Figure 3 As shown, the functions of the user management module include user registration / login, role management (administrator, developer, tester), and permission allocation, and the corresponding APIs are POST / api / users / register, POST / api / users / login, and GET / api / users / {id} (query user information). The functions of the issue management module include creating issues, updating issue status (pending, in progress, resolved, closed), and issue priority setting (low, medium, high, urgent), and the corresponding APIs are POST / api / issues (create issues), PATCH / api / issues / {id} (update issues), and GET / api / issues (get issue list).

[0041] The user management module ensures platform user identity authentication, role differentiation and permission control through registration / login, role management and permission allocation functions, thus ensuring system security. The issue management module supports creation, status update and priority setting. Through the RESTful API (such as POST / api / issues to create issues, PATCH / api / issues / {id} to update status), it realizes the full life cycle management of issues, improves the efficiency and accuracy of problem tracking and resolution, and provides strong support for team collaboration and software development process optimization.

[0042] like Figure 3As shown in the figure, the functions of the communication and collaboration module include comment system, file upload and sharing, and the corresponding APIs are POST / api / issues / {id} / comments (add comments) and POST / api / issues / {id} / attachments (upload files). The functions of the data analysis module include generating problem statistical reports and problem processing time analysis. The API for statistical reports is GET / api / reports / issues / statistics (get statistical reports), and the API for processing time is GET / api / reports / issues / {id} / timing (get processing time). The functions of the monitoring and alarm module include real-time monitoring of problem processing and setting alarm rules. The corresponding APIs are POST / api / alerts (set alarm rules) and GET / api / alerts (get alarm list).

[0043] The communication and collaboration module enhances the information exchange and collaboration capabilities among team members and improves the efficiency of problem solving through the comment system and file upload and sharing functions. The data analysis module provides managers with detailed problem handling data support through statistical reports and processing time analysis, which facilitates decision optimization. The monitoring and alarm module monitors the problem handling status in real time and allows the setting of alarm rules to ensure that problems are handled in a timely manner, improving the response speed and stability of the system. These functions jointly promote the improvement of team collaboration efficiency and system operation and maintenance level.

[0044] like Figure 4 As shown, the dashboard design includes displaying key indicators, namely the number of pending issues, active users, and average processing time, and uses Chart.js and Echarts to display visual charts. The issue list page includes a table that supports sorting, filtering, and paging, and each issue row supports quick viewing of details. The issue details page includes all information about the issue, including comments and attachments, as well as a status update button and a priority adjustment drop-down box.

[0045] The dashboard design provides managers with a quick overview of the system status by intuitively displaying key indicators such as the number of pending issues, active users, and average processing time, combined with visualization charts of Chart.js and Echarts. The issue list page supports sorting, filtering, and paging, making it easier for users to browse and locate issues efficiently. The issue details page displays all information about the issue in detail, including comments, attachments, status updates, and priority adjustment functions, providing users with a comprehensive problem handling and collaboration environment, and promoting the efficiency and accuracy of problem solving.

[0046] like Figure 5As shown, security measures include that all API interfaces must verify user identity through JWT and perform secondary confirmation for sensitive operations. Performance optimization includes using cache, i.e. Redis, to store commonly used data, reduce database access, separate the front-end and back-end to ensure front-end loading speed, and optimize resource loading through lazy loading.

[0047] Security measures ensure the security of user identities of all API interfaces through JWT verification, and require secondary confirmation for sensitive operations, effectively preventing unauthorized access and misoperation, and enhancing the security of the system. In terms of performance optimization, Redis is used to cache commonly used data, significantly reducing database access pressure and improving response speed; at the same time, the front-end and back-end separation architecture ensures the front-end loading speed, and combines lazy loading technology to optimize resource loading, further improving user experience and overall system performance. These measures together provide a solid guarantee for the stable operation and efficient service of the system.

[0048] like Figure 6 As shown, the testing strategy includes unit testing and integration testing. Unit testing uses JUnit and Mockito, and integration testing includes API testing using Postman / Newman. The deployment solution includes using Docker containerized applications to simplify the deployment process and CI / CD integrating Jenkins or GitHub Actions to achieve automated building and deployment.

[0049] The testing strategy ensures software quality through unit testing and integration testing. JUnit and Mockito are used for unit testing to ensure the correctness of code modules; Postman / Newman is used for API integration testing to verify the interaction and collaboration between system components. The deployment solution uses Docker containerized applications to simplify the deployment process and improve environmental consistency; combined with CI / CD, Jenkins or GitHub Actions are integrated to achieve automated building and deployment, accelerate software iteration cycles, and improve team efficiency and delivery quality. These measures together provide strong support for the agility and reliability of software development and operation and maintenance.

[0050] The tracking method of the issue tracking platform based on SKYWALKING technology includes the following steps:

[0051] S1: Goal and demand analysis, determine the core functions and user roles of the tracking platform, and clarify the functional modules to meet user needs;

[0052] S2: System architecture design, select the appropriate technical framework and microservice architecture to ensure that the system has high concurrent processing capabilities and flexibility;

[0053] S3: Module division, which divides functional modules, including problem management, tracking and feedback, to facilitate the organization and management of the system;

[0054] S4: Function refinement, refine the user operation process, and ensure a closed loop of problem submission, status checking and feedback collection;

[0055] S5: API interface design, design RESTful API interface, and provide standardized data access and operation methods;

[0056] S6: Database design, formulate the database table structure, and clearly organize the data for storing problem information, status change history, and user feedback;

[0057] S7: User interface design, design a simple user interface to ensure that users can operate it easily on different devices;

[0058] S8: Security design, implement user authentication and permission control to ensure secure and compliant access to system data;

[0059] S9: Performance optimization, introducing cache mechanism and load balancing to improve the system's response speed and stability;

[0060] S10: Test plan, develop a comprehensive test plan covering unit testing, integration testing and user acceptance testing to ensure functional stability;

[0061] S11: Deployment strategy, using containerized deployment and CI / CD processes to simplify environment configuration and version management and improve launch efficiency;

[0062] S12: Maintenance and iteration, establish user feedback mechanism and system monitoring, and continuously optimize functions and performance to meet changing needs.

[0063] Through SkyWalking, a powerful APM tool, the platform can fully monitor the performance of applications under microservices, cloud native and containerized architectures, effectively solving the problems of data fragmentation and incomplete monitoring faced by traditional tracking platforms in complex technology stacks. Whether it is a service built in languages ​​such as Java, Python or Go, the platform can provide a unified monitoring perspective to ensure the consistency and integrity of monitoring data. At the functional level, the user management module ensures the security and compliance of system access through refined role division and permission control. The problem management module provides a complete process from problem creation, status update to priority setting, supporting efficient problem tracking and handling. The communication and collaboration module further strengthens the information exchange between team members, and promotes the rapid resolution of problems through the comment system and file sharing functions. The data analysis module uses statistical reports and processing time analysis to provide managers with detailed data support, which facilitates decision optimization and process improvement. These functional modules together constitute an efficient and flexible problem tracking and management system, which greatly improves the agility and reliability of software development and operation and maintenance.

[0064] By introducing the Redis cache mechanism, the platform can effectively reduce the number of database accesses, reduce system load, and improve response speed. At the same time, the design of front-end and back-end separation ensures the fast loading of the front-end page, and the lazy loading technology further optimizes the resource loading efficiency and improves the user experience. In addition, the platform also uses the JWT verification mechanism to protect the API interface, ensure the security of sensitive operations, and prevent unauthorized access. In terms of testing and deployment, the platform has formulated a comprehensive testing strategy, including unit testing and integration testing, using JUnit and Mockito for unit testing to ensure code quality; using Postman / Newman for API integration testing to verify the interaction and collaboration between system components. The deployment solution uses Docker containerized applications, combined with CI / CD processes (such as Jenkins or GitHub Actions), to achieve automated construction and deployment, simplify environmental configuration and version management, and improve online efficiency. This series of measures not only improves the stability and reliability of the system, but also accelerates the software iteration cycle, meeting the needs of modern software development and operation for efficiency and flexibility.

[0065] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. The problem tracking platform based on SKYWALKING technology includes system structure design, functional module design, user interface design, security and performance optimization, testing and deployment. The system structure design includes front-end, back-end, database, and monitoring. The functional module design includes user management module, problem management module, communication and collaboration module, data analysis module, monitoring and alarm module. The user interface design includes dashboard design, problem list page, problem details page. The security and performance optimization includes safety measures and performance optimization. The testing and deployment includes testing strategy and deployment plan.

2. The problem tracking platform based on SKYWALKING technology according to claim 1, characterized in that: The front end uses React and Vue.js to build the user interface, the back end provides RESTful API through Java / Spring Boot, the database uses MySQL / PostgreSQL to store user and problem data, and the monitoring uses SkyWalking as an APM tool to collect performance data and display call chain diagrams.

3. The problem tracking platform based on SKYWALKING technology according to claim 1, characterized in that: The functions of the user management module include user registration / login, role management (administrator, developer, tester), and authority allocation, and the corresponding APIs are POST / api / users / register, POST / api / users / login, and GET / api / users / {id} (query user information). The functions of the issue management module include creating issues, updating issue status (pending, in progress, resolved, closed), and issue priority setting (low, medium, high, urgent), and the corresponding APIs are POST / api / issues (create issues), PATCH / api / issues / {id} (update issues), and GET / api / issues (get issue list).

4. The problem tracking platform based on SKYWALKING technology according to claim 1, characterized in that: The functions of the communication and collaboration module include comment system, file upload and sharing, and the corresponding APIs are POST / api / issues / {id} / comments (add comments) and POST / api / issues / {id} / attachments (upload files). The functions of the data analysis module include generating problem statistical reports and problem processing time analysis. The API for statistical reports is GET / api / reports / issues / statistics (get statistical reports), and the API for processing time is GET / api / reports / issues / {id} / timing (get processing time). The functions of the monitoring and alarm module include real-time monitoring of problem processing and setting alarm rules. The corresponding APIs are POST / api / alerts (set alarm rules) and GET / api / alerts (get alarm list).

5. The problem tracking platform based on SKYWALKING technology according to claim 1, characterized in that: The dashboard design includes displaying key indicators, namely the number of pending issues, active users, and average processing time, and uses Chart.js and Echarts to display visual charts. The issue list page includes a table that supports sorting, filtering, and paging, and each issue row supports quick viewing of details. The issue details page includes all information about the issue, including comments and attachments, as well as a status update button and a priority adjustment drop-down box.

6. The problem tracking platform based on SKYWALKING technology according to claim 1, characterized in that: The security measures include that all API interfaces must verify user identity through JWT and perform secondary confirmation for sensitive operations. The performance optimization includes using cache, i.e. Redis, to store commonly used data, reduce database access, separate the front-end and back-end to ensure front-end loading speed, and optimize resource loading through lazy loading.

7. The problem tracking platform based on SKYWALKING technology according to claim 1, characterized in that: The testing strategy includes unit testing and integration testing, where JUnit and Mockito are used for unit testing, and Postman / Newman is used for API testing. The deployment solution includes using Docker containerized applications to simplify the deployment process and integrating Jenkins or GitHub Actions with CI / CD to achieve automated building and deployment.

8. The tracking method of the problem tracking platform based on SKYWALKING technology according to claim 1, characterized in that: It includes the following steps: S1: Goal and demand analysis, determine the core functions and user roles of the tracking platform, and clarify the functional modules to meet user needs; S2: System architecture design, select the appropriate technical framework and microservice architecture to ensure that the system has high concurrent processing capabilities and flexibility; S3: Module division, which divides functional modules, including problem management, tracking and feedback, to facilitate the organization and management of the system; S4: Function refinement, refine the user operation process, and ensure a closed loop of problem submission, status checking and feedback collection; S5: API interface design, design RESTful API interface, and provide standardized data access and operation methods; S6: Database design, formulate the database table structure, and clearly organize the data for storing problem information, status change history, and user feedback; S7: User interface design, design a simple user interface to ensure that users can operate it easily on different devices; S8: Security design, implement user authentication and permission control to ensure secure and compliant access to system data; S9: Performance optimization, introducing cache mechanism and load balancing to improve the response speed and stability of the system; S10: Test plan, develop a comprehensive test plan covering unit testing, integration testing and user acceptance testing to ensure functional stability; S11: Deployment strategy, using containerized deployment and CI / CD processes to simplify environment configuration and version management and improve launch efficiency; S12: Maintenance and iteration, establish user feedback mechanism and system monitoring, and continuously optimize functions and performance to meet changing needs.

Images