多级转发数据采集任务的关系数据存储方案设计OA

In response to the need to collect dynamic and diverse data for universal data collection,the collection task requires multi-level forwarding,and the collected data needs to be reviewed and summarized level by level.At the same time,it is necessary to ensure the security isolation between different user data,and other issues.A relational data storage scheme that supports multi-level forwarding data collection tasks has been designed.By dynamically constructing data fields for data collection tasks and using serialized LOBs,unified relational data storage for universal data collection tasks has been achieved.By using the"self association table",the data collection task can be forwarded,tracked,and reviewed at any level in two types of data collection methods:filling in tables and adding tables.The state linkage transition of parent-child tasks further reduces the complexity of state management in multi-level data collection.