CN114118696A - Transportation index management system based on space dimensionality - Google Patents

Transportation index management system based on space dimensionality Download PDF

Info

Publication number
CN114118696A
CN114118696A CN202111253780.7A CN202111253780A CN114118696A CN 114118696 A CN114118696 A CN 114118696A CN 202111253780 A CN202111253780 A CN 202111253780A CN 114118696 A CN114118696 A CN 114118696A
Authority
CN
China
Prior art keywords
index
data
configuration
management
space
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111253780.7A
Other languages
Chinese (zh)
Inventor
杨金宇
马毕胜
方秀川
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Clp Tongtu Beijing Technology Co ltd
Original Assignee
Clp Tongtu Beijing Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Clp Tongtu Beijing Technology Co ltd filed Critical Clp Tongtu Beijing Technology Co ltd
Priority to CN202111253780.7A priority Critical patent/CN114118696A/en
Publication of CN114118696A publication Critical patent/CN114118696A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • G06Q10/06393Score-carding, benchmarking or key performance indicator [KPI] analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/10Services
    • G06Q50/26Government or public services

Landscapes

  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Development Economics (AREA)
  • Educational Administration (AREA)
  • Economics (AREA)
  • Tourism & Hospitality (AREA)
  • General Physics & Mathematics (AREA)
  • Marketing (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Theoretical Computer Science (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Game Theory and Decision Science (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a transportation index management system based on space dimensionality, which comprises an original data configuration module, a theme data configuration module, an index basic information management module, an index space dimensionality configuration module, an index calculation and plug-in management module and a characteristic value maintenance module. Configuring the data condition of the central data table according to the original data condition, and realizing the combing of the correlation between the existing data and the corresponding table; on the basis, the original data table is accessed into the subject data, so that the configuration of checking, modifying and the like of the subject data table information is realized; realizing configuration and management of index basic information in a visual graphic management interface mode based on the spatial dimension tree; configuring the space dimension of the index by importing or editing wkt files; managing a calculation method of the index, realizing the plug-in encapsulation of the general calculation component, and realizing the flexible configuration and combination of the algorithm; and performing daily index operation and maintenance work such as browsing, index tracing, characteristic value maintenance, abnormal explanation and the like on all indexes.

Description

Transportation index management system based on space dimensionality
Technical Field
The invention relates to the technical field of index management methods in the transportation industry, in particular to a transportation index management system based on space dimensionality.
Background
The transportation industry has the characteristics of multiple fields, wide range, multiple data types, large data quantity and the like, and in order to reasonably calculate and utilize the data and provide auxiliary basis for industry monitoring and decision making of transportation departments, an index system of the transportation industry becomes a standard configuration for comprehensive transportation operation monitoring application. The construction of an industry index system is based on the fusion of field data and data among fields, and visual icons such as numbers, thermodynamic diagrams, line graphs and the like are used as display forms, so that the operation conditions of all elements of the industry are visually reflected, and the complex phenomenon is more visual and clear; the operation condition of the transportation industry is quantified through various indexes, the real-time operation situation of the industry can be objectively displayed, a management department is assisted in analyzing the development law of the industry, the development situation and the historical process of the industry are reflected, and the quality of the development of the industry is macroscopically mastered.
Effective management of index data, algorithm and configuration is a premise of ensuring that the index data, the algorithm and the configuration play the greatest role, particularly, a large number of iteration, inclusion and causal relationships exist in the calculation of indexes in the existing index system, and the data errors and failures of a large number of related indexes are often caused by the abnormality of one index. And a correct and efficient index calculation and index management rule is formed, and systematic, unified and standardized management of indexes in various fields of the industry is facilitated.
Disclosure of Invention
The invention aims to provide a method which can maintain the generation, calculation and configuration processes of all industrial indexes in a mode of index space dimensionality and provide data guarantee for stable presentation of an index system.
In order to achieve the purpose, the invention adopts the following technical scheme: a transportation index management system based on space dimensionality comprises an original data configuration module, a theme data configuration module, an index basic information management module, an index space dimensionality configuration module, an index calculation and plug-in management module and a characteristic value maintenance module. The original data configuration is the basis of an index management system and provides industrial data for classification of index subject data and calculation of index data; the theme data is configured on the basis of original data configuration, different management theme bases facing the transportation industry are formed according to classification modes such as the industry field, the industry business management requirement, department authority and responsibility, management objects and the like, and all industry data are classified in coarse granularity; the index basic information management is based on a theme library, indexes representing different dimensionality operation characteristics of the theme under different themes and incidence relations of the indexes are deeply constructed, and the indexes formed by the configuration at the stage are objects of subsequent space dimensionality configuration and calculation; the index space dimension configuration takes a single index or an index set as a unit, the space range which can be represented by the index space dimension configuration is configured, and a specific index or index set only has significance in a specified space range; the index computer plug-in management associates the index with the data, digitalizes the meaning of the index according to an algorithm, makes the original data into business, and directly influences the effectiveness of the index by the correctness and the rationality of a calculation process model; the characteristic value maintenance takes the index calculation result as a management object, obtains the extreme value, the mean value and other values of the index number which can represent the particularity or the trend, and is an important step for providing a basis for research and judgment.
The six modules cover the visual management of the whole process of industrial indexes from the field attribute, the data source, the index attribute, the index space-time dimension, the index query and the index generation and the unified management and control function of the indexes, and the application requirements of the personalized configuration and the quick online application of the indexes are met.
The specific technical features of each functional module are described as follows:
the original data configuration is to configure the data condition of the central data table, and the configuration content comprises the original library data source, the data frequency of the corresponding data table, the data providing unit and the maintenance of the table field. The original data configuration is to configure the correlation between the existing data and the corresponding table. The division of the space dimension starts from original data, a field which represents a region to which the data belongs is arranged in a field structure of the original data, the space range of the data is described, and the space range of the data corresponds to the space dimension of the index.
And the theme data configuration is to access the original data table into the theme data and perform configuration operations such as checking, modifying and the like on the information of the theme data table on the basis of the configuration of the original library. The theme configuration classifies the original data according to industries or businesses, and the spatial attributes of the data cannot be changed. The access and stop access states of the data table, or access history data, can be controlled during this configuration process.
The index basic information management module is used for configuring and managing index basic information, the index basic information comprises indexes, business fields, different levels of units, index units, time dimensions, space dimensions, data sources and the like, and visual information configuration is realized in a visual graphic management interface mode. In order to provide larger index configuration freedom, the system provides a customization function of basic information items, and can also carry out operations such as modification, deletion, query and the like on the existing index basic information.
The index space dimension configuration module is used for configuring the space dimensions to which all indexes belong, managing the space range of the space dimensions, and performing management operations such as adding, editing, deleting and the like on the existing space dimensions. The spatial dimension represented by the index is divided by the wkt file, and the spatial range division at this stage is associated with the spatial range field of the original data. The calibration of the index space dimension determines the data called in the index calculation process, namely, when the index is calculated, the original data of which the space field is contained in the index space range is adopted for calculation.
The index calculation and plug-in management module is used for managing the index calculation method and packaging relatively universal calculation in the index calculation process into a plug-in for management. When the index items need to be configured, the configuration of the indexes can be flexibly realized only by extracting corresponding index basic information from the plug-in library for assembly.
And the index data browsing module is used for browsing the generated indexes, performing combined query according to multiple conditions, performing version management, index value maintenance and index tracing on the indexes, monitoring abnormal indexes in real time, checking abnormal details and rapidly processing the abnormal indexes.
The characteristic value maintenance module is used for maintaining information such as analysis names, characteristic value types, extreme value numbers, characteristic value names, monitoring indexes, time periods, date characteristics and the like of the characteristic values, and can also be used for newly adding, modifying and deleting the characteristic values.
Compared with the prior art, the index management based on the space dimensionality is adopted to divide the configuration and calculation of the index into the minimum administrative unit and the space range, and the administrative unit or the space range are mutually independent and have no intersection, so that the calculation result of each basic unit index is only related to the accessed data quality and the calculation process, and the effectiveness and the accuracy of the basic unit index are improved on the premise that the data and the model are correct.
Secondly, indexes have obvious hierarchy by a dividing mode based on a space range, a larger space range is composed of a smaller space range, and on the basis, the index with the larger space range is obtained by the index with the smaller space range through operations such as aggregation, summation and the like aiming at a certain index, so that the data consistency and the calculation consistency are ensured.
Drawings
FIG. 1 is a diagram of a raw database configuration.
FIG. 2 is a flow chart of monitoring indicator configuration.
Fig. 3 is an wkt string data pattern diagram.
FIG. 4 is a diagram of a monitoring metrics configuration interface.
Fig. 5 is an explanatory view of the reference numeral composition.
Detailed Description
A transportation index management system based on space dimensionality comprises an original data configuration module, a theme data configuration module, an index basic information management module, an index space dimensionality configuration module, an index calculation and plug-in management module, a data browsing module, a characteristic value maintenance module and the like.
The calculation and generation of the index depend on the collection and management of industrial data, and before the index is generated, the original data required by the calculation of the base table needs to be matched and corresponded. Because the key monitoring responsibilities of the departments at all levels are different, the monitoring granularity and the required data source of the same index are different, and the updating frequency of the index is also different.
As shown in fig. 1, a database and a data table are selected for a data source required by index calculation, the data source is defined, the data update frequency and the data providing unit are selected according to the requirement of monitoring the service precision, and an intuitive configuration mode is favorable for fast index backtracking or index calculation data verification in the future.
After the basic data configuration is finished, the configured data table needs to be matched with the subject data, so that a data source is provided for the calculation of the field index. In order to ensure normal calculation of index data, on-time extraction of the data is ensured. In order to better realize data acquisition and monitor abnormal acquisition and abnormal data conditions, delay time and alarm time setting of data acquisition are introduced. Setting a certain delay acquisition time within a data acquisition period, wherein the setting of the delay time needs to be less than the data acquisition period; the alarm time is that extra time is added on the basis of the delay time, data extraction is carried out at the time point, and if the data is not extracted after the time is exceeded, the alarm is carried out, so that the situations of data loss and acquisition failure caused by network delay, short-time faults of links and the like are reduced. In the data extraction process, in order to ensure the correctness and rationality of later-stage index calculation, abnormal data needs to be identified and alarmed, and therefore a 'checking plug-in' is introduced for checking abnormal data such as overlarge and undersize values in a data table and carrying out abnormal alarm.
After the data extraction configuration takes effect, the data of the data table updated after the current time can be extracted, the existing data at a certain time in history can also be extracted, and the integrity and the continuity of data access are kept to the maximum extent.
The configuration and calculation of the index are based on the compliant data access, and the main configuration flow is shown in fig. 2.
The classification and subordinate of the indexes are divided macroscopically by using fields, the fields establish different subjects and classes according to services or according to index features to form a space dimension tree of the indexes, and a space dimension menu is a basis for monitoring the generation of the indexes and is used for uniformly managing all the indexes. All dimension numbers are four and are in a level, which represents the specific position of the space dimension in the space dimension tree during establishment, and two space information maintenance modes are provided for each space dimension: 1) editing spatial dimensions by inputting spatial information; 2) the spatial dimensions are edited by uploading wkt data. The spatial dimension range is configured by uploading wkt strings, and the dimension number and the dimension name of the spatial dimension and all GIS data contained in the spatial dimension need to be determined in wkt strings. wkt string format and content examples are shown in FIG. 3. When the GIS range of a certain spatial dimension changes, the spatial range can be complemented and adjusted in the above two ways.
The monitoring indexes are used for describing different characteristic states of various kinds of operation element dynamic and static data in different space dimensions, and the defined directionality and the calculation accuracy determine the guiding effectiveness of the monitoring indexes on industry management. In the generation process of each index, a user needs to configure the spatial range, the index unit, the time range, the time characteristic, the date characteristic, the data source, the plug-in, the calculation method and the index description content of each index, and in order to ensure the fine management of the indexes and the certainty of later-stage complex index calling, the created index name must have uniqueness. The configuration process of the index is shown in fig. 4. The system generates a unique index number for each index, which is represented by a 32-bit number, wherein the first 16 bits are the spatial dimension of the index, and the last one represents the time range, date characteristic, time characteristic, index name, unit, and data source of the index, for example, as shown in fig. 5.
The calculation of the index data is realized by introducing a calculation plug-in, a few relatively common calculation methods are listed below, and the complicated model calculation can be realized by the superposition of simple calculation or the introduction of a new plug-in.
1. Data SQL plug-in (sqlColllectPlugin)
I.e. the value of an index, which must be of the numerical type, is obtained directly from the database.
The acquisition frequency of the subject library is the same as the time range of the monitoring index, and sql is configured as follows:
Selectvaluefromdb.tableNamewheredatatime='%date%'and batchid='%batchId%‘
value is a index value, can be a column name, and can also be used in combination with a statistical function (count/sum/avg/max/min) and a numerical function; tableName, topic library table name; batch subject library data batch number, corresponding to the batch field of the table.
When the collection frequency of the theme library is smaller than the time range of the monitoring index, the system can generate repeated calculation, and the calculation by using the plug-in is preferably reduced in order to reduce errors possibly caused by data of a plurality of batches.
2. Database batch plug-in (batch SqlColllectPlugin)
When the plurality of monitoring indexes have the same attribute except different spatial dimensions, the database batch plug-in unit can generate the plurality of monitoring indexes at the same time point, for example, the 15-minute traffic index of each district and county of a certain city is calculated,
when the batch of plug-ins are modified, only one plug-in needs to be edited, and other plug-ins can be updated synchronously, so that the editing efficiency of the algorithm is improved.
3. Single-index time range statistics plug-in
And counting the characteristic values of the indexes in a time period, such as the average value, the maximum value, the synthesis and the like, and calculating a new index value. In order to ensure the uniqueness and correctness of index calculation, when the monitoring indexes only have different time ranges, the indexes with small time ranges are usually used for calculating the indexes with large time ranges. For example, the daily peak road network speed is calculated by the statistical average road network speed of 15 minutes or the daily total traffic index is calculated by the hourly traffic index.
4. duration/Range plug-in (singleNormDurationPlugin)
Analyzing the index value in a time period, and calculating the total time and the time period of the index value being greater than, less than, greater than or equal to, less than or equal to the given value.
5. Operation plug-in (arithmeticCollectPluin)
And performing addition, subtraction, multiplication and division four fundamental operations on the plurality of data. In the operation process, the data in the formula are ensured to be the same in time range and can be captured normally, and when one or more index values are lacked in the formula, the calculation is not carried out.
At any stage in the application process, a user can modify and optimize the calculation mode of the existing index according to the requirement, the recalculation button is clicked after modification, the index is recalculated according to the new calculation mode, and all other indexes including the index can update data in the last calculation. When the index cannot be normally calculated due to special conditions such as data expiration, data access channel interruption and the like, the index can be set to be forbidden in the monitoring index browsing interface, and after the forbidden, all calculations related to the index are stopped, namely the calculation of the index is stopped, and the calculation of the index included in the index calculation formula is also stopped. When a certain index is deleted, indexes that have been referenced may not be deleted in order not to affect the normal calculation of the relevant index.
The characteristic value of the index is usually represented by a maximum value or a minimum value in the system, and is not only used for displaying the extreme value of the index in a certain period range, a certain time period and a certain period characteristic, but also put into a monitoring report at the later stage to provide reference for industry analysis.

Claims (8)

1. A transportation index management system based on space dimensionality comprises an original data configuration module, a theme data configuration module, an index basic information management module, an index space dimensionality configuration module, an index calculation and plug-in management module and a characteristic value maintenance module; the original data configuration is the basis of an index management system and provides industrial data for classification of index subject data and calculation of index data; the theme data is configured on the basis of original data configuration, different management theme bases facing the transportation industry are formed according to classification modes such as the industry field, the industry business management requirement, department authority and responsibility, management objects and the like, and all industry data are classified in coarse granularity; the index basic information management is based on a theme library, indexes representing different dimensionality operation characteristics of the theme under different themes and incidence relations of the indexes are deeply constructed, and the indexes formed by the configuration at the stage are objects of subsequent space dimensionality configuration and calculation; the index space dimension configuration takes a single index or an index set as a unit, the space range which can be represented by the index space dimension configuration is configured, and a specific index or index set only has significance in a specified space range; the index computer plug-in management associates the index with the data, digitalizes the meaning of the index according to an algorithm, makes the original data into business, and directly influences the effectiveness of the index by the correctness and the rationality of a calculation process model; the characteristic value maintenance takes the index calculation result as a management object, and obtains the extreme value and the average value of the index number, which can represent the value of specificity or trend.
2. The transportation index management system based on the space dimension according to claim 1, characterized in that: original data configuration, namely configuring the data condition of a central data table, wherein the configuration content comprises the maintenance of an original database data source, the data frequency of a corresponding data table, a data providing unit and a table field; the original data configuration is to configure the correlation between the existing data and the corresponding table.
3. The transportation index management system based on the space dimension according to claim 1, characterized in that: and (3) theme data configuration, namely, on the basis of the configuration of the original library, accessing the original data table into theme data, and checking and modifying configuration operation on the information of the theme data table, wherein the access and stop access states of the data table or access historical data can be controlled in the configuration process.
4. The transportation index management system based on the space dimension according to claim 1, characterized in that: the index basic information management module is used for configuring and managing index basic information, wherein the index basic information comprises indexes, business fields, different levels of units, index units, time dimensions, space dimensions, data sources and the like, and visual information configuration is realized in a visual graphic management interface mode; in order to provide larger index configuration freedom, the system provides a customization function of basic information items, and modifies, deletes and queries the existing index basic information.
5. The transportation index management system based on the space dimension according to claim 1, characterized in that: and the index space dimension configuration module is used for configuring the space dimensions to which all indexes belong, managing the space range of the space dimensions, and performing addition, edition and deletion management operations on the existing space dimensions.
6. The transportation index management system based on the space dimension according to claim 1, characterized in that: the index calculation and plug-in management module is used for managing the index calculation method and packaging relatively universal calculation in the index calculation process into a plug-in for management; when the index items need to be configured, the index configuration can be realized only by extracting corresponding index basic information from the plug-in library for assembly.
7. The transportation index management system based on the space dimension according to claim 1, characterized in that: and the index data browsing module browses the generated indexes, performs combined query according to multiple conditions, performs version management, index value maintenance and index tracing on the indexes, monitors abnormal indexes in real time, checks abnormal details and rapidly processes the abnormal indexes.
8. The transportation index management system based on the space dimension according to claim 1, characterized in that: and the characteristic value maintenance module is used for maintaining the characteristic information of the analysis name, the characteristic value type, the extreme value number, the characteristic value name, the monitoring index, the time period and the date of the characteristic value, or adding, modifying and deleting the characteristic value.
CN202111253780.7A 2021-10-27 2021-10-27 Transportation index management system based on space dimensionality Pending CN114118696A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111253780.7A CN114118696A (en) 2021-10-27 2021-10-27 Transportation index management system based on space dimensionality

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111253780.7A CN114118696A (en) 2021-10-27 2021-10-27 Transportation index management system based on space dimensionality

Publications (1)

Publication Number Publication Date
CN114118696A true CN114118696A (en) 2022-03-01

Family

ID=80376926

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111253780.7A Pending CN114118696A (en) 2021-10-27 2021-10-27 Transportation index management system based on space dimensionality

Country Status (1)

Country Link
CN (1) CN114118696A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117910850A (en) * 2023-12-18 2024-04-19 北京宇信科技集团股份有限公司 Index data analysis engine, index data calculation device and calculation method

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117910850A (en) * 2023-12-18 2024-04-19 北京宇信科技集团股份有限公司 Index data analysis engine, index data calculation device and calculation method

Similar Documents

Publication Publication Date Title
CN102279848B (en) Method and device for generating report template
CN113595761B (en) Micro-service component optimization method and medium of power system information communication integrated scheduling platform
CN109254901B (en) A kind of Monitoring Indexes method and system
CN114218218A (en) Data processing method, device and equipment based on data warehouse and storage medium
US20160342656A1 (en) Interactive Log File Visualization Tool
CN112052134A (en) Service data monitoring method and device
CN114880405A (en) Data lake-based data processing method and system
CN108694448A (en) PHM platforms
CN113642299A (en) One-key generation method based on power grid statistical form
CN111177227B (en) Power data self-service analysis system and decision application migration method
CN105335822A (en) Smart power grid unified data model modeling method for big data analysis
CN110837496A (en) Data quality management method and system based on dynamic sql
CN112347163A (en) High-dispersion SQL dynamic baseline warning method and system
CN114124743B (en) Method and system for executing full-link inspection rule of data application
CN114118696A (en) Transportation index management system based on space dimensionality
CN109768878A (en) A kind of network work order calculation method and device based on big data
CN114528270A (en) System and method for automatically associating real-time stream data with service dimension information in cloud environment
CN112416918A (en) Data management system and working method thereof
CN112001539A (en) High-precision passenger traffic prediction method and passenger traffic prediction system
CN116362443A (en) Data management method and device for enterprise information platform
CN107480364B (en) BIM (building information modeling) model dynamic organization method for engineering construction information management
CN114860759A (en) Data processing method, device and equipment and readable storage medium
CN114860851A (en) Data processing method, device, equipment and storage medium
CN114153914A (en) Power plant equipment defect visualization system, method, computer equipment and storage medium
CN114124977A (en) Cross-tenant data sharing method and device and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination