CN115525681A - Vehicle condition data processing method and system, electronic equipment and vehicle - Google Patents

Vehicle condition data processing method and system, electronic equipment and vehicle Download PDF

Info

Publication number
CN115525681A
CN115525681A CN202211169611.XA CN202211169611A CN115525681A CN 115525681 A CN115525681 A CN 115525681A CN 202211169611 A CN202211169611 A CN 202211169611A CN 115525681 A CN115525681 A CN 115525681A
Authority
CN
China
Prior art keywords
data
vehicle condition
domain
service
data stream
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
CN202211169611.XA
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.)
Great Wall Motor Co Ltd
Original Assignee
Great Wall Motor 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 Great Wall Motor Co Ltd filed Critical Great Wall Motor Co Ltd
Priority to CN202211169611.XA priority Critical patent/CN115525681A/en
Publication of CN115525681A publication Critical patent/CN115525681A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24568Data stream processing; Continuous queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/254Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The disclosure provides a method and a system for processing vehicle condition data, an electronic device and a vehicle, belonging to the technical field of vehicle-mounted machine data processing, wherein the method for processing the vehicle condition data comprises the following steps: acquiring a vehicle condition signal of a vehicle; converting the vehicle condition signal to generate a data stream of a specified type; mapping data streams of specified types corresponding to different vehicle condition signals to a structural database; and displaying the data streams of different specified types in the structure database. The processing method of the vehicle condition data can match the vehicle condition signals to the data streams of the corresponding types, so that the characteristics of the vehicle condition signals can be adapted, and the unification and the standardized management of the vehicle condition signals are facilitated.

Description

Vehicle condition data processing method and system, electronic equipment and vehicle
Technical Field
The invention relates to the technical field of vehicle networking, in particular to a method and a system for processing vehicle condition data, electronic equipment and a vehicle.
Background
The vehicle networking data needs to be uploaded, collected and stored in batch aiming at a large amount of generated vehicle condition signals, and the collected vehicle condition signals are different due to different vehicle type configurations, so that the management of the vehicle condition signal data is complex; in addition, the accuracy of the vehicle condition signals is extremely high, the magnitude of the overall signal data is large, and the complex vehicle condition signal data is difficult to manage, maintain and inquire.
Therefore, it is urgently needed to solve the problem of difficult classification management of different vehicle condition signals in the existing vehicle networking data.
Disclosure of Invention
In view of the above, the present invention provides a method, a system, an electronic device and a vehicle for processing vehicle condition data, so as to solve the problems in the background art.
Based on the above purpose, the present invention provides a method for processing vehicle condition data, comprising the following steps:
acquiring a vehicle condition signal of a vehicle;
converting the vehicle condition signal to generate a data stream of a specified type;
mapping data streams of specified types corresponding to different vehicle condition signals into a structural database;
and displaying the data streams of different specified types in the structure database.
Further, the mapping the data streams of the specified types corresponding to the different vehicle condition signals into the structure database includes:
dividing the data stream of the specified type into domains, and constructing a plurality of corresponding functional data units according to the data streams of the specified types of different domains;
respectively mapping the data streams of the designated types corresponding to different vehicle condition signals to corresponding functional data units;
and integrating the plurality of functional data units to obtain a structure database.
Further, the domain division of the data stream of the specified type, and the construction of a plurality of corresponding functional data units according to the data streams of the specified type of different domains, includes:
determining development data and service data in a data stream of a specified type as a technical domain, and constructing a technical metadata unit according to the development data and the service data corresponding to the technical domain;
determining a service attribute domain of the data stream service attribute of the specified type, and constructing a service metadata unit according to the service attribute in the service attribute domain;
and determining the data management and maintenance information in the data stream of the specified type as a management domain, and constructing a management metadata unit according to the data management and maintenance information corresponding to the management domain.
Further, the acquisition parameters of the vehicle condition signals at least comprise: electronic and electrical network, communication protocol, association and data related processing program;
the method for determining development data and service data in the data stream of the specified type as a technical domain and constructing a technical metadata unit according to the development data and the service data corresponding to the technical domain includes:
mapping a specified type of data stream generated by the electronic-electrical network into a base table structure of the technical metadata unit;
mapping the data stream of the specified type generated by the communication protocol to a field constraint and comment part of the technical metadata unit;
mapping the data stream of the specified type generated by the association item into the data model and the blood relationship of the technical metadata unit;
mapping the data stream of the specified type generated by the data-related processing program to a data warehouse of a technical metadata unit;
and integrating the base table structure, the field constraint and annotation part, the data model, the blood relationship and the data warehouse to obtain the technical metadata unit.
Further, the converting the vehicle condition signal to generate a data stream of a specified type further includes:
dividing the vehicle condition signal into a plurality of service attributes according to service fields or purposes, and dividing the plurality of service attributes into a plurality of layers according to the attribution relationship of the service attributes, wherein the plurality of layers comprise: at least one parent node attribute and at least one child node attribute corresponding to each parent node attribute;
converting the vehicle condition signals of the service attributes of each layer into corresponding data streams of specified types;
the method for determining the service attribute domain of the data stream service attribute of the specified type and constructing the service metadata unit according to the service attribute in the service attribute domain comprises the following steps:
taking the data stream of the designated type corresponding to the father node attribute as a father node domain, taking the data stream of the designated type corresponding to the child node attribute as a child node domain, and integrating each father node domain and each child node domain according to the attribution relationship to obtain an integrated tree-like relationship graph;
and constructing the service metadata unit according to the integrated tree-like relational graph.
Further, the acquisition parameters of the vehicle condition signals at least comprise: data owner, data quality rules and data security level;
the determining the data management and maintenance information in the data stream of the specified type as a management domain, and constructing a management metadata unit according to the data management and maintenance information corresponding to the management domain includes:
mapping the data stream of the specified type generated by the data owner to the data user information of the management metadata unit;
mapping the data stream of the specified type generated by the data quality rule into the data rule of the management metadata unit;
mapping the data stream of the specified type generated by the data security level into the data security level information of the management metadata unit;
and integrating the data user information, the data rule and the data security level information to obtain the management metadata unit.
Further, the displaying the data streams of different specified types in the structure database includes:
dividing the vehicle condition signals of different categories into different areas according to the subject areas to which the vehicle condition signals belong;
and displaying the data streams of the specified types corresponding to the vehicle condition signals of different subject domains according to the tree structure catalog in a subordinate manner.
In a second aspect, the present application also provides a vehicle condition data processing system, including:
the acquisition module is used for acquiring vehicle condition signals of the vehicle;
the read-write module is used for converting the vehicle condition signals into data streams of specified types;
the processing module is used for mapping the data streams of the specified types corresponding to the different vehicle condition signals into the structure database;
and the display module is used for displaying the data streams of different specified types in the structure database.
In a third aspect, the present application further provides an electronic device, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method as described in any one of the above when executing the program.
In a fourth aspect, the present application further provides a vehicle including the electronic device as described above, and the vehicle condition data processing system as described above.
As can be seen from the foregoing, the processing method of vehicle condition data provided by the present invention generates the data stream of the specified type by converting the vehicle condition signals, and maps the data stream of the specified type corresponding to different vehicle condition signals into the structure database, so as to ensure accurate matching, and facilitate quick retrieval of relevant vehicle condition signals from the structure database, and these large batches of vehicle condition signals are managed by referring to the management method of the data table of the corresponding structure database as a management object, which is favorable for achieving unified and standardized management of the vehicle condition signals and the data table.
In addition, the data streams of different specified types in the structure database can be displayed, and the vehicle condition signals can be displayed outwards according to the related data mapping relation, so that a user can observe the related vehicle condition signals in real time, and the timeliness of the data is ensured.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1A is a flowchart of a vehicle condition data processing method in an embodiment of the present application;
FIG. 1B is a flow chart of a vehicle condition data processing method in another embodiment of the present application;
FIG. 1C is a flow chart of a vehicle condition data processing method in another embodiment of the present application;
FIG. 1D is a flow chart of a vehicle condition data processing method in yet another embodiment of the present application;
fig. 1E is a flowchart of a vehicle condition data processing method in another embodiment of the present application;
FIG. 1F is a flow chart of a vehicle condition data processing method in another embodiment of the present application;
FIG. 1G is a flow chart of a vehicle condition data processing method in another embodiment of the present application;
FIG. 1H is a schematic diagram of a tree structure in an embodiment of the present application;
FIG. 2A is a block diagram of a vehicle condition processing system according to an embodiment of the present invention;
FIG. 2B is a block diagram of a processing module according to an embodiment of the present disclosure;
fig. 3 is a schematic structural diagram of an electronic device in an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to specific embodiments and the accompanying drawings.
It is to be noted that technical terms or scientific terms used in the embodiments of the present invention should have the ordinary meanings as understood by those having ordinary skill in the art to which the present disclosure belongs, unless otherwise defined. The use of "first," "second," and similar terms in this disclosure is not intended to indicate any order, quantity, or importance, but rather is used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that the element or item listed before the word covers the element or item listed after the word and its equivalents, but does not exclude other elements or items. The terms "connected" or "coupled" and the like are not restricted to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "upper", "lower", "left", "right", and the like are used merely to indicate relative positional relationships, and when the absolute position of the object being described is changed, the relative positional relationships may also be changed accordingly.
The terms referred to in this application are explained as follows:
SQL (Structured Query Language), a special-purpose programming Language, is a database Query and programming Language for accessing data and querying, updating, and managing relational database systems, and is also an extension of database script files.
At present, a large amount of vehicle condition signals, such as vehicle identification codes, running speed, engine speed, temperature in a vehicle and the like, are reported at regular time in the running process of the vehicle. In service, the user can implement vehicle behavior analysis, driving state monitoring, trajectory analysis, vehicle state retrieval, and the like based on these vehicle condition signals. Meanwhile, the technician also needs to determine and analyze a vehicle failure, an abnormality in the overall traveling state of the vehicle, or the like based on these vehicle condition signals.
During the use of the vehicle, a large number of different types of vehicle condition signals are uploaded to a TSP (Telematics Service Provider) through a T-Box (electronic Box). However, different vehicle models are configured differently, the acquired signals are also different, and the magnitude of vehicle condition signal data is large (the real-time transmission of the vehicle condition signals can be accurate to millisecond level), so that the complex vehicle condition signal data also needs to be managed as a management object, and the complex and huge vehicle condition signal data has large management difficulty and large subsequent maintenance and query difficulty.
In order to overcome the above problems and manage and maintain the vehicle condition signals more conveniently and efficiently, the embodiment provides a vehicle condition data processing method, which is applied to a vehicle networking platform, wherein a data interaction mode between a vehicle and a cloud can refer to the existing mature vehicle-machine interaction technology.
Referring to fig. 1A, the method for processing vehicle condition data according to this embodiment includes the following steps:
s11, acquiring a vehicle condition signal of the vehicle.
And S12, converting the vehicle condition signals to generate data streams of specified types.
And S13, mapping the data streams of the specified types corresponding to the different vehicle condition signals into a structure database.
S14, displaying the data streams of different specified types in the structure database.
As can be seen from the above description, in the processing method of vehicle condition data provided in this embodiment, the vehicle condition signals are converted to generate the data stream of the specified type, and the data stream of the specified type corresponding to different vehicle condition signals is mapped into the structural database, so that the vehicle condition signals can be applied to the structural database, thereby ensuring accurate matching, and facilitating fast retrieval of relevant vehicle condition signals from the structural database, and these large batches of vehicle condition signals are managed as management objects by referring to the management method of the data table, which is beneficial to achieving unification and standardized management of the vehicle condition signals and the data table; due to the fact that the data streams of different specified types in the structure database can be displayed, the vehicle condition signals can be displayed outwards according to the data mapping relation, a user can observe related vehicle condition signals in real time, and timeliness of the data is guaranteed.
It should be noted that, for convenience of understanding, in this embodiment, a data stream of an SQL type is used for example, and a structure database corresponding to the data stream of the SQL type is an SQL structure database, which is not described in detail herein; as an alternative, the specified type of data stream may take other forms, such as an Oracle data stream.
In some embodiments, in the step S11, the vehicle condition signal of the vehicle is obtained, which generally includes CAN Data (Controller Area Network) generated during the operation of the vehicle, DLT Data (Data Link Terminal), DTC Data (Diagnostic Trouble Code), DID Data (Data Identifier), and the like.
For example, for an air conditioning compartment temperature in a vehicle, the vehicle condition signals obtained may be: the instruction type: VALUE; electronic-electrical architecture (ECU unit of the same): AC; signal english name: cbnTemp; signal english description: air Conditioning bin Temperature; minimum value: -40; maximum value: 86.5; unit: DEG C; precision: 0.5; the values describe: 0x 00-0xFD; 0 xFE; 0 xFF. In this embodiment, the vehicle condition signals are only illustrated, and the specific content of the vehicle condition signals for different electrical and electronic architectures or different vehicle body areas is different.
Here, when acquiring a vehicle condition signal of a vehicle, a connection line of an electronic unit corresponding to the vehicle is shown in fig. 1A, where the connection structure of the electronic unit is an EE structure of the vehicle. And after the vehicle condition signals generated by the electronic units are acquired, the vehicle condition signals are converted into SQL type data streams, so that the SQL type data streams are conveniently mapped to an SQL structure database.
In some embodiments, in step S12, the generation of the SQL-type data stream by the conversion of the vehicle condition signals may be implemented by writing SQL statements corresponding to the vehicle condition signals, and since the corresponding functions, uses, and use positions of the vehicle condition signals are different, the corresponding SQL statements are written differently.
Further, as shown in fig. 1B, when the vehicle condition signal is converted to generate the SQL-type data stream, the method further includes the following steps:
s121, dividing the vehicle condition signal into a plurality of service attributes according to service fields or purposes, and dividing the plurality of service attributes into a plurality of layers according to the attribution relationship of the service attributes, wherein the plurality of layers comprise: at least one parent node attribute and at least one child node attribute corresponding to each parent node attribute.
And S122, converting the vehicle condition signals of the service attributes of each layer into corresponding SQL type data streams.
In the above step S121, since the sources and locations of the vehicle condition models are different, the respective service areas and applications are different, and when the plurality of layers are divided, the division may be performed in the form of a tree structure diagram, for example, the vehicle condition signal is divided into a plurality of parent node attributes such as a whole vehicle domain and a user behavior domain, and each child node attribute such as a vehicle condition domain and a fault code domain is included in the corresponding parent node attribute of the whole vehicle domain, and each related child node is sequentially arranged according to the attribution relationship. Here, since the number of divided domains is different, the number of parent nodes and child nodes actually provided is also different.
In some embodiments, as shown in fig. 1C, in step S13, the method further includes:
s131, performing domain division on the SQL type data stream, and constructing a plurality of corresponding functional data units according to the SQL type data streams of different domains.
S132, mapping the SQL type data streams corresponding to different vehicle condition signals to corresponding functional data units respectively.
And S133, integrating the plurality of functional data units to obtain an SQL structure database.
By the scheme, the data streams of the designated type are divided into different domains, and the classification management can be further performed on large batches of vehicle condition signals, so that the integrated structure database is simpler and clearer, and operators with different identities can conveniently acquire the type data in the corresponding direction.
In the above steps, in step S131, the SQL-type data stream is subjected to domain division, and the final division forms domains that are different because the domain classification rules are different, specifically, as shown in fig. 1D, step S131 includes:
s131a, determining development data and service data in the SQL type data stream as a technical domain, and constructing a technical metadata unit according to the development data and the service data corresponding to the technical domain.
And S131b, determining a service attribute domain according to the SQL type data stream service attribute, and constructing a service metadata unit according to the service attribute in the service attribute domain.
And S131c, determining data management and maintenance information in the SQL type data stream as a management domain, and constructing a management metadata unit according to the data management and maintenance information corresponding to the management domain.
According to the scheme, the data stream of the designated type is divided into the technical metadata unit, the service metadata unit and the management metadata unit according to different data information and attributes, and the data table of the metadata is generally divided into the technical metadata unit, the service metadata unit and the management metadata unit, so that the data integrity of the whole structure database can be ensured by dividing the data stream of the designated type into the three types of metadata units, and the technical metadata unit, the service metadata unit or the management metadata unit can be conveniently checked by corresponding to different identity personnel.
Furthermore, the vehicle condition signal carries relevant parameters such as an electronic and electrical network, a communication protocol, a related item, a data related processing program and the like, when the relevant parameters are converted to generate an SQL-type data stream, the SQL-type data stream is development data and service data in the SQL-type data stream, the development data and the service data are divided into technical domains, and a technical metadata unit is constructed according to the development data and the service data corresponding to the technical domains.
Specifically, as shown in fig. 1E, in step S131a, the method further includes:
s131a1, mapping the SQL-type data stream generated by the electronic and electrical network into a base table structure of the technical metadata unit.
S131a2, mapping the SQL type data stream generated by the communication protocol to a field constraint and comment part of the technical metadata unit.
S131a3, mapping the SQL-type data stream generated by the association item to the data model and the blood relationship of the technical metadata unit.
S131a4, mapping the SQL type data stream generated by the data related processing program to a data warehouse of a technical metadata unit.
S131a5, integrating the base table structure, the field constraint and annotation part, the data model, the blood relationship and the data warehouse to obtain the technical metadata unit.
In the above steps S131a1 to S131a4, the electronic electrical network, i.e. the source, the position, and other relevant parameters of the vehicle condition signal; the communication protocol is the related parameters of the vehicle condition signal, such as the transfer rule used for transmitting the vehicle condition signal; the association item is the association relation between the vehicle condition signal and other vehicle condition signals; the data-related processing program is related process parameters of data acquisition, analysis, distribution and the like of the vehicle condition signals.
The technical metadata unit is used for structuring data, and is convenient for a computer or a database to identify, store, transmit and exchange the data. The technical metadata can serve developers, so that the developers can more clearly determine the storage and structure of the data, and a foundation is laid for application development and system integration.
Because the composition architecture of the technical metadata unit generally includes a base table structure, a field constraint and annotation part, a data model, a blood-related relationship and an ETL program (Extract-Transform-Load, which extracts, transforms, loads data to a destination), after the related parameters of the vehicle condition signal are transformed to generate SQL-type data streams, the various components of the technical metadata unit can be mapped one by one according to the function and the related relation of the SQL-type data streams, and the mapped data streams are used as a new base table structure, a field constraint and annotation part, a data model, a blood-related relationship and an ETL program, and the technical metadata unit is obtained after being integrated.
It should be noted that, the relevant parameters in the vehicle condition signal may include other contents besides the above-mentioned electronic and electrical network, communication protocol, related items, data-related processing procedures, etc., and when the other contents are included, the other contents of the vehicle condition signal may be converted to generate a data stream of a specified type and then mapped against the components of the technical metadata unit.
In some embodiments, as shown in fig. 1F, in step S131b, the method further includes:
s131b1, using the SQL type data stream corresponding to the father node attribute as a father node domain, using the SQL type data stream corresponding to the child node attribute as a child node domain, and integrating each father node domain and each child node domain according to the attribution relationship to obtain an integrated tree-like relational graph.
And S131b2, constructing the service metadata unit according to the integrated tree relation diagram.
Here, the above steps S131b1 and S131b2 may refer to the assignment arrangement of the vehicle condition signals in step S121, that is, as shown in fig. 1H, the parent node domain is a data stream of SQL type generated by the parent node conversion corresponding to the vehicle condition signal, and the child node domain is a data stream of SQL type generated by the child node conversion corresponding to the vehicle condition signal. The service metadata unit is constructed and formed by the integrated tree-like relational graph, so that the whole service metadata is clearer, and workers can conveniently operate and call SQL (structured query language) type data streams of related vehicle condition signals, and further, target vehicle condition data can be conveniently positioned.
Still as shown in fig. 1H, the tree relationship diagram is a specific implementation of the car networking data after dividing each parent node domain and child node domain, wherein the car networking data is divided into 1.1 whole car domains; 1.2 user behavior field; 1.3;1.4, and the like, wherein in the parent node domain corresponding to the 1.1 whole vehicle domain, the parent node domain comprises a plurality of child node domains belonging to the 1.1 whole vehicle domain, for example, a 1.1.1 vehicle condition domain; 1.1.2 fault code domains, etc., the division of each parent-child node domain is only illustrated in this embodiment, and in the actual car networking data, other related parent node domains and child node domains should be provided.
It should be noted that, in the acquired vehicle condition signal, the acquired vehicle condition signal itself has relevant parameters such as a data owner, a data quality rule, a data security level, and the like, and when the relevant parameters are converted to generate an SQL-type data stream, that is, the SQL-type data stream belongs to data management and maintenance information in the SQL-type data stream, the data management and maintenance information is divided into a management domain, and the metadata unit is managed according to a data management and maintenance information component corresponding to the management domain.
Specifically, as shown in fig. 1G, in step S131c, the method further includes:
s131c1, mapping the SQL type data stream generated by the data owner to the data user information of the management metadata unit.
S131c2, mapping the SQL type data stream generated by the data quality rule to the data rule of the management metadata unit.
S131c3, mapping the SQL-type data streams generated by the data security levels to the data security level information of the management metadata unit.
S131c4, integrating the data user information, the data rules and the data security level information to obtain the management metadata unit.
In the above steps S131c1 to S131c3, the data owner is the data maintainer of the vehicle condition signal; data quality rules, namely parameters such as quality specifications and relevant requirements of the vehicle condition signals; the data safety level is the safety level requirement parameter corresponding to the vehicle condition signal.
Because the composition architecture of the management metadata unit generally comprises data user information, data rules, data security level information and the like, after the related parameters of the vehicle condition signals are converted into SQL-type data streams, the SQL-type data streams can be mapped one by one according to the related management object classification, and the mapped data streams are used as new data user information, data rules and data security level information and then integrated to obtain the management metadata unit.
It should be noted that, the relevant parameters in the vehicle condition signal may include other contents in addition to the data owner, the data quality rule, the data security level, and the like, and when the other contents are included, the other contents of the vehicle condition signal may be converted into an SQL-type data stream and then mapped against the components of the management metadata unit.
As shown in table 1 below, table 1 is a mapping relationship between the vehicle condition signal related parameters and each functional data unit in the SQL structure database table. After the data flow of SQL type is generated by conversion, the relevant parameters of the vehicle condition signal can be mapped according to the mapping relation classification by comparing each component of each functional data unit.
TABLE 1
Figure BDA0003862128840000101
Figure BDA0003862128840000111
It should be noted that, when the same vehicle condition signal is converted to generate an SQL-type data stream, it may be allocated to different functional data units according to different allocation rules, for example, the vehicle condition signals located in the security domain and the chassis domain may be mapped to the same service metadata unit after the SQL-type data stream is converted to be generated; or according to the use function or the related parameter, the vehicle condition signal of the security domain is converted to generate an SQL-type data stream and then mapped to the technical metadata unit, and the vehicle condition signal of the chassis domain is converted to generate an SQL-type data stream and then mapped to the service domain data unit.
In some embodiments, as shown in fig. 1H, in step S14, when displaying data streams of different SQL types in the SQL structure database, the data streams of the SQL types corresponding to the vehicle condition signals of different subject domains may be displayed according to tree structure categories, which further facilitates workers with different identities to search for the vehicle condition signals of the corresponding subject domains, and the operation process is more convenient and efficient.
Based on the same inventive concept, as shown in fig. 2A, the present application also provides a vehicle condition data processing system corresponding to the vehicle condition data processing method of any of the above embodiments, including:
the acquisition module 11 is used for acquiring vehicle condition signals of the vehicle;
the read-write module 12 is used for converting the vehicle condition signals to generate data streams of specified types;
the processing module 13 is configured to map data streams of specified types corresponding to different vehicle condition signals into a structure database;
and the display module is used for displaying the data streams of different specified types in the structure database.
For convenience of understanding, in this embodiment, a data stream of an SQL type is used for illustration, and a structure database corresponding to the data stream of the SQL type is a structure database of the SQL; as an alternative, the specified type of data stream may take other forms, such as an Oracle data stream.
In some embodiments, the processing module 13 is further configured to:
carrying out domain division on the SQL type data stream, and constructing a plurality of corresponding functional data units according to the SQL type data streams of different domains;
respectively mapping the SQL type data streams corresponding to different vehicle condition signals to corresponding functional data units;
and integrating the plurality of functional data units to obtain the SQL structure database.
In some embodiments, as shown in fig. 2B, the processing module 13 further comprises a metadata processing unit configured to:
determining development data and service data in the SQL type data stream as a technical domain, and constructing a technical metadata unit according to the development data and the service data corresponding to the technical domain;
determining a business attribute domain of the SQL type data stream business attribute, and constructing a business metadata unit according to the business attribute in the business attribute domain;
determining data management and maintenance information in the SQL type data stream as a management domain, and constructing a management metadata unit according to the data management and maintenance information corresponding to the management domain.
In some embodiments, the metadata processing unit comprises a technical metadata processing subunit and is configured to:
mapping the SQL type data stream generated by the electronic and electric network into a base table structure of the technical metadata unit;
mapping the SQL type data stream generated by the communication protocol to a field constraint and comment part of the technical metadata unit;
mapping the SQL type data flow generated by the association item into the data model and the blood relationship of the technical metadata unit;
mapping the SQL type data stream generated by the data-related processing program to a data warehouse of a technical metadata unit;
and integrating the base table structure, the field constraint and annotation part, the data model, the blood relationship and the data warehouse to obtain the technical metadata unit.
In some embodiments, the metadata processing unit comprises a business metadata processing subunit and is configured to:
taking the SQL type data flow corresponding to the father node attribute as a father node domain, taking the SQL type data flow corresponding to the child node attribute as a child node domain, and integrating each father node domain and each child node domain according to the attribution relationship to obtain an integrated tree-like relational graph;
and constructing the service metadata unit according to the integrated tree relation graph.
In some embodiments, the metadata processing unit comprises a management metadata processing subunit and is configured to:
mapping the SQL type data stream generated by the data owner to the data user information of the management metadata unit;
mapping the SQL type data stream generated by the data quality rule to the data rule of the management metadata unit;
mapping the SQL type data stream generated by the data security level to the data security level information of the management metadata unit;
and integrating the data user information, the data rules and the data security level information to obtain the management metadata unit.
In some embodiments, the display effect of the display module can be displayed outwards in a manner of referring to the tree structure diagram of fig. 1H.
For convenience of description, the above system is described with the functions divided into various modules, which are described separately. Of course, the functionality of the various modules may be implemented in the same one or more pieces of software and/or hardware in the practice of the present application.
The vehicle condition data processing system of the foregoing embodiment is used to implement the corresponding vehicle condition data processing method in the foregoing corresponding embodiment, and has the beneficial effects of the corresponding method embodiment, which are not described herein again.
Based on the same inventive concept, as shown in fig. 3, corresponding to the vehicle condition data processing method of any of the above embodiments, the present application further provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and running on the processor, and when the processor executes the program, the method of any of the above embodiments is implemented.
Fig. 3 is a schematic diagram illustrating a more specific hardware structure of an electronic device according to this embodiment, where the electronic device may include: a processor 1010, a memory 1020, an input/output interface 1030, a communication interface 1040, and a bus 1050. Wherein the processor 1010, memory 1020, input/output interface 1030, and communication interface 1040 are communicatively coupled to each other within the device via bus 1050.
The processor 1010 may be implemented by a general-purpose CPU (Central Processing Unit), a microprocessor, an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits, and is configured to execute related programs to implement the technical solutions provided in the embodiments of the present disclosure.
The Memory 1020 may be implemented in the form of a ROM (Read Only Memory), a RAM (Random Access Memory), a static storage device, a dynamic storage device, or the like. The memory 1020 may store an operating system and other application programs, and when the technical solution provided by the embodiments of the present specification is implemented by software or firmware, the relevant program codes are stored in the memory 1020 and called to be executed by the processor 1010.
The input/output interface 1030 is used for connecting an input/output module to input and output information. The i/o module may be configured as a component within the device (not shown) or may be external to the device to provide corresponding functionality. The input devices may include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc., and the output devices may include a display, a speaker, a vibrator, an indicator light, etc.
The communication interface 1040 is used for connecting a communication module (not shown in the drawings) to implement communication interaction between the present apparatus and other apparatuses. The communication module can realize communication in a wired mode (such as USB, network cable and the like) and also can realize communication in a wireless mode (such as mobile network, WIFI, bluetooth and the like).
Bus 1050 includes a path that transfers information between various components of the device, such as processor 1010, memory 1020, input/output interface 1030, and communication interface 1040.
It should be noted that although the above-mentioned device only shows the processor 1010, the memory 1020, the input/output interface 1030, the communication interface 1040 and the bus 1050, in a specific implementation, the device may also include other components necessary for normal operation. In addition, those skilled in the art will appreciate that the above-described apparatus may also include only those components necessary to implement the embodiments of the present description, and not necessarily all of the components shown in the figures.
The electronic device of the above embodiment is used to implement the corresponding method in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiment, which are not described herein again.
On the basis of the same inventive concept, corresponding to any of the above-described embodiment methods, the present application also provides a vehicle including the electronic device as described above, and the vehicle condition data processing system as described above.
Those of ordinary skill in the art will understand that: the discussion of any embodiment above is meant to be exemplary only, and is not intended to intimate that the scope of the disclosure, including the claims, is limited to these examples; within the idea of the invention, also features in the above embodiments or in different embodiments may be combined, steps may be implemented in any order, and there are many other variations of the different aspects of the invention as described above, which are not provided in detail for the sake of brevity.
The embodiments of the invention are intended to embrace all such alternatives, modifications and variances which fall within the broad scope of the appended claims. Therefore, any omissions, modifications, substitutions, improvements and the like that may be made without departing from the spirit and principles of the invention are intended to be included within the scope of the invention.

Claims (10)

1. A processing method of vehicle condition data is characterized by comprising the following steps:
acquiring a vehicle condition signal of a vehicle;
converting the vehicle condition signal to generate a data stream of a specified type;
mapping data streams of specified types corresponding to different vehicle condition signals to a structural database;
and displaying the data streams of different specified types in the structure database.
2. The method for processing vehicle condition data according to claim 1, wherein the mapping specified types of data streams corresponding to different vehicle condition signals into a structural database comprises:
carrying out domain division on the data stream of the specified type, and constructing a plurality of corresponding functional data units according to the data streams of the specified type of different domains;
respectively mapping the data streams of the designated types corresponding to different vehicle condition signals to corresponding functional data units;
and integrating the plurality of functional data units to obtain a structure database.
3. The method for processing vehicle condition data according to claim 2, wherein the domain division of the data stream of the specified type and the construction of a plurality of corresponding functional data units according to the data streams of the specified type of different domains comprises:
determining development data and service data in a data stream of a specified type as a technical domain, and constructing a technical metadata unit according to the development data and the service data corresponding to the technical domain;
determining a service attribute domain of the data stream service attribute of the specified type, and constructing a service metadata unit according to the service attribute in the service attribute domain;
and determining the data management and maintenance information in the data stream of the specified type as a management domain, and constructing a management metadata unit according to the data management and maintenance information corresponding to the management domain.
4. The method for processing vehicle condition data according to claim 3, wherein the acquisition parameters of the vehicle condition signals at least comprise: electronic and electrical network, communication protocol, association and data related processing program;
the method for determining development data and service data in the data stream of the specified type as a technical domain and constructing a technical metadata unit according to the development data and the service data corresponding to the technical domain includes:
mapping a specified type of data stream generated by the electronic-electrical network into a base table structure of the technical metadata unit;
mapping the data stream of the specified type generated by the communication protocol to a field constraint and comment part of the technical metadata unit;
mapping the data stream of the specified type generated by the association item into the data model and the blood relationship of the technical metadata unit;
mapping the data stream of the specified type generated by the data-related processing program to a data warehouse of a technical metadata unit;
and integrating the base table structure, the field constraint and annotation part, the data model, the blood relationship and the data warehouse to obtain the technical metadata unit.
5. The method of processing vehicle condition data according to claim 3, wherein the converting the vehicle condition signal to generate a data stream of a specified type further comprises:
dividing the vehicle condition signal into a plurality of service attributes according to service fields or purposes, and dividing the plurality of service attributes into a plurality of layers according to the attribution relationship of the service attributes, wherein the plurality of layers comprise: at least one parent node attribute and at least one child node attribute corresponding to each parent node attribute;
converting the vehicle condition signals of the service attributes of each layer into corresponding data streams of specified types;
the method for determining the service attribute domain of the data stream service attribute of the specified type and constructing the service metadata unit according to the service attribute in the service attribute domain comprises the following steps:
taking the data stream of the specified type corresponding to the father node attribute as a father node domain, taking the data stream of the specified type corresponding to the child node attribute as a child node domain, and integrating each father node domain and each child node domain according to the attribution relationship to obtain an integrated tree-like relation graph;
and constructing the service metadata unit according to the integrated tree-like relational graph.
6. The method for processing vehicle condition data according to claim 3, wherein the acquisition parameters of the vehicle condition signals at least comprise: data owner, data quality rules and data security level;
the determining the data management and maintenance information in the data stream of the specified type as a management domain, and constructing a management metadata unit according to the data management and maintenance information corresponding to the management domain includes:
mapping the data stream of the specified type generated by the data owner to the data user information of the management metadata unit;
mapping the data stream of the specified type generated by the data quality rule into the data rule of the management metadata unit;
mapping the data stream of the specified type generated by the data security level into the data security level information of the management metadata unit;
and integrating the data user information, the data rule and the data security level information to obtain the management metadata unit.
7. The method for processing vehicle condition data according to claim 1, wherein the displaying the data streams of different specified types in the structure database comprises:
dividing the vehicle condition signals of different categories into different areas according to the subject areas to which the vehicle condition signals belong;
and displaying the data streams of the specified types corresponding to the vehicle condition signals of different subject domains according to the tree structure catalog in a subordinate manner.
8. A vehicle condition data processing system characterized by comprising:
the acquisition module is used for acquiring vehicle condition signals of the vehicle;
the read-write module is used for converting the vehicle condition signals to generate data streams of specified types;
the processing module is used for mapping the data streams of the specified types corresponding to the different vehicle condition signals into the structure database;
and the display module is used for displaying the data streams of different specified types in the structure database.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 7 when executing the program.
10. A vehicle characterized by comprising the vehicle condition data processing system according to claim 8, and the electronic device according to claim 9.
CN202211169611.XA 2022-09-23 2022-09-23 Vehicle condition data processing method and system, electronic equipment and vehicle Pending CN115525681A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211169611.XA CN115525681A (en) 2022-09-23 2022-09-23 Vehicle condition data processing method and system, electronic equipment and vehicle

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211169611.XA CN115525681A (en) 2022-09-23 2022-09-23 Vehicle condition data processing method and system, electronic equipment and vehicle

Publications (1)

Publication Number Publication Date
CN115525681A true CN115525681A (en) 2022-12-27

Family

ID=84700378

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211169611.XA Pending CN115525681A (en) 2022-09-23 2022-09-23 Vehicle condition data processing method and system, electronic equipment and vehicle

Country Status (1)

Country Link
CN (1) CN115525681A (en)

Similar Documents

Publication Publication Date Title
US11250344B2 (en) Machine learning based analytics platform
CN106980560B (en) ICD database based multi-bus protocol testing and simulating method and platform
CN112180776B (en) OPC UA information modeling method and device based on equipment component module
WO2013008476A1 (en) Dynamic infrastructure administration system
CN111625964B (en) Method, system and equipment for constructing transformer substation graph model based on logical relationship
CN110990447A (en) Data probing method, device, equipment and storage medium
CN110995639A (en) Data transmission method
CN113393211A (en) Method and system for intelligently improving automatic production efficiency
CN100382075C (en) Hardware-level based test script automatic generating system and method
CN115525681A (en) Vehicle condition data processing method and system, electronic equipment and vehicle
Hoos et al. Context-aware decision information packages: an approach to human-centric smart factories
CN115617623A (en) Performance index data visualization method and device, electronic equipment and storage medium
CN114329090A (en) Path reference searching method and device, electronic equipment and storage medium
US11210267B2 (en) Electronic control unit comparison
CN111930097B (en) Vehicle diagnostic data analysis method, device, equipment and storage medium
CN114282029A (en) Primitive management method and device, electronic equipment and storage medium
CN109918353B (en) Method for automatically processing information and terminal equipment
CN112784434A (en) Model-based avionics design method
CN116976006A (en) Automatic modeling method, system, equipment and storage medium for center of mass of whole vehicle
CN112463551B (en) Configurable alarm standardization method
CN115357657B (en) Data processing method and device, computer equipment and storage medium
CN114416080A (en) Customized page configuration method, device, equipment and storage medium
US11734024B2 (en) Device for managing digital twins
KR102243708B1 (en) Editing tool update method of the HMI system
CN118093672A (en) Data processing method, device and storage medium

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