CN103559186A

CN103559186A - Design and query method of CAN bus database

Info

Publication number: CN103559186A
Application number: CN201310354765.0A
Authority: CN
Inventors: 刘矗; 莫莽; 吴宝红
Original assignee: SHANGHAI GUTAI TECHNOLOGY Co Ltd
Current assignee: SHANGHAI GUTAI TECHNOLOGY Co Ltd
Priority date: 2013-08-15
Filing date: 2013-08-15
Publication date: 2014-02-05

Abstract

The invention relates to a design and query method of a CAN bus database. The design of the CAN bus database is composed of three data tables, namely a signal table, a message table and a node table. The signal table includes all signal definitions in a network. The message table includes all message definitions in the network. Each message contains a signal which can be found in the signal table. The node table includes all node definitions in the network. Each node contains a message which is sent by the node and which can be found in the message table, and meanwhile, each node contains a signal which is received by the node and which can be found in the signal table.

Description

Design and the querying method in CAN bus data storehouse

Technical field

The present invention relates to the software systems of computer realm, particularly a kind of Database Systems based on CAN bus.

Background technology

CAN bus, as the communication interface between each microcontroller, has a wide range of applications in automobile and industry; In the formulation of automobile CAN-bus agreement and implementation process, the signal defining in CAN network, message and node need to be encapsulated in a database file, realize the data access based on symbol, thereby simplify workflow, for the monitoring of CAN bus, emulation and test builds basis.

The CAN bus data storehouse of Ge great automobile vendor does not have unified standard at present, is much to manage based on excel spreadsheet lattice or even Word document the data that CAN is relevant, and the problem of bringing is like this: 1, search and revise corresponding data and seem very difficult; 2, the machine that cannot realize CAN associated data files reads and analytical capabilities, is difficult to guarantee the robotization control based on CAN bus.

Summary of the invention

Object of the present invention, exactly in order to overcome the problem of preserving and accessing based on CAN bus data, build a distinct CAN bus data storehouse framework, relevant CAN data can be managed efficiently, simultaneously can be so that machine can automatically read this database file and carry out the robotization control based on CAN bus.

Concrete technical scheme provided by the invention is as follows:

Design and the querying method in CAN bus data storehouse, defined three kinds of tables of data at a lane database, is respectively signal list, message table and node table.

Design and the querying method in CAN bus data storehouse, the definition that described signal list has comprised all signals that may occur in whole network, comprises signal name, signal length, syllable sequence, minimax value, amplification factor, side-play amount, unit, signal annotation etc.

Design and the querying method in CAN bus data storehouse, the definition that described message table has comprised all messages that may occur in whole network, comprises message name, message identifier, message data length, message annotation etc.

Design and the querying method in CAN bus data storehouse, the definition that described node table has comprised all nodes that may occur in whole network, comprises nodename, node annotation etc.

Design and the querying method in CAN bus data storehouse, each message in described message table has all comprised and has contained signal within it, and all signals all can find definition in signal list.

Design and the querying method in CAN bus data storehouse, each node of described node table has all comprised the message of its transmission, with and the signal that receives, all signals and message all can find its definition in signal list and message table.

Design and the querying method in CAN bus data storehouse, the message identifier by appointment can find message to define in message table, thus each signal definition that finds message to contain.

Design and the querying method in CAN bus data storehouse, the node by appointment can find its all message lists that send, and can find its all signal lists that receive simultaneously, thus the list of constructing its all messages that receive.

Design and the querying method in CAN bus data storehouse, it is advantageous that, architecture definition clear and rational can automatically preserve by machine, be written into CAN database file, thereby inquire about and control based on symbol.

Accompanying drawing explanation

Fig. 1 is total Organization Chart in CAN bus data storehouse in the invention process method

Fig. 2 is the Organization Chart of signal list in the invention process method

Fig. 3 is the Organization Chart of message table in the invention process method

Fig. 4 is the Organization Chart of node table in the invention process method

In Fig. 1, signal list (101), message table (102), node table (103), CAN bus data library file (104)

In Fig. 2, independent signal (201)-(207), can define an independent signal arbitrarily in signal list (101)

In Fig. 3, independent message (301)-(302), can define an independent message arbitrarily in message table (102)

In Fig. 4, isolated node (401)-(402), can define an isolated node arbitrarily in node table (103)

Embodiment

In Fig. 1, create CAN bus data library file (104), in it, comprise signal list (101), message table (102) and node table (103).

In Fig. 2, in signal list (101), can define independent signal (201)-(207) arbitrarily.

In Fig. 3, in message table (102), can define independent message (301)-(302) arbitrarily, each message inside comprises the independent signal that it loads, such as independent message (301) has loaded independent signal (201)-(203); Independent message (302) has loaded independent signal (204)-(205).

In Fig. 4, in node table (103), can define isolated node (401)-(402) arbitrarily, each intra-node comprises its message list sending, and for example isolated node (401) sends independent message (301) and independent message (302); Isolated node (402) is containing sending message.

In Fig. 4, each intra-node also comprises the signal list that this node receives, and for example isolated node (401) inside is not containing received signal; Isolated node (402) inside comprises independent signal (206) and (207).

Claims

Design and the querying method in 1.CAN bus data storehouse, is characterized in that, at a lane database, defined three kinds of tables of data, is respectively signal list, message table and node table; The definition that signal list comprises signal in network, the definition that message table comprises message in network, message inside comprises signal, the definition of signal can be found from signal list, the definition that node table comprises network node, intra-node comprises its all messages that send, and the definition of message can be found from message table, intra-node comprises all signals that it receives simultaneously, and the definition of signal can be found from signal list.
2. design and the querying method in CAN bus data according to claim 1 storehouse, it is characterized in that, the definition that described signal list has comprised all signals that may occur in whole network, comprises signal name, signal length, syllable sequence, minimax value, amplification factor, side-play amount, unit, signal annotation.
3. design and the querying method in CAN bus data according to claim 1 storehouse, it is characterized in that, the definition that described message table has comprised all messages that may occur in whole network, comprises message name, message identifier, message data length, message annotation.
4. design and the querying method in CAN bus data according to claim 1 storehouse, is characterized in that, the definition that described node table has comprised all nodes that may occur in whole network comprises nodename, node annotation.
5. design and the querying method in CAN bus data according to claim 3 storehouse, is characterized in that, each message in described message table has all comprised and contained signal within it, and all signals all can find definition in signal list.
6. design and the querying method in CAN bus data according to claim 4 storehouse, it is characterized in that, each node of described node table has all comprised the message of its transmission, with and the signal that receives, all signals and message all can find its definition in signal list and message table.
7. design and the querying method in CAN bus data according to claim 5 storehouse, is characterized in that, the message identifier by appointment can find message to define in message table, thus each signal definition that finds message to contain.
8. design and the querying method in CAN bus data according to claim 6 storehouse, it is characterized in that, node by appointment can find its all message lists that send, and can find its all signal lists that receive simultaneously, thus the list of constructing its all messages that receive.