CN103514262A

CN103514262A - Method for designing and querying FlexRay bus database

Info

Publication number: CN103514262A
Application number: CN201310355032.9A
Authority: CN
Inventors: 刘矗; 莫莽; 吴宝红
Original assignee: SHANGHAI GUTAI TECHNOLOGY Co Ltd
Current assignee: SHANGHAI GUTAI TECHNOLOGY Co Ltd
Priority date: 2013-08-14
Filing date: 2013-08-14
Publication date: 2014-01-15

Abstract

The invention relates to a database system based on a FlexRay bus. The database system is formed by three data tables including a signal table, a message table and a node table, the signal table comprises all signal definitions in the network, the message table comprises all message definitions in the network, each message internally comprises a signal defined in the signal table, the node table comprises all node definitions in the network, each node internally comprises sent messages, the messages are defined in the message table, meanwhile, each node comprises the signals received by the node, and the signals are defined in the signal table.

Description

Design and the querying method in FlexRay bus data storehouse

Technical field

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

Background technology

FlexRay is a kind of high speed confirmability for automobile, the bus system that possesses failure tolerant, FlexRay is by transmission of information in definite time slot, and the failure tolerant on two passages and the transmission of redundant information, met the ever-increasing demand to the rate of information throughput especially failure tolerant and time determinability of new x-by-wire system thought.In the formulation of automobile FlexRay bus protocol and implementation process, the signal defining in FlexRay network, message and node need to be encapsulated in a database file, the data access of realization based on symbol, thereby simplification workflow, for the monitoring of FlexRay bus, emulation and test builds basis.

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

Summary of the invention

Object of the present invention, exactly in order to overcome the problem of preserving and accessing based on FlexRay bus data, build a distinct FlexRay bus data storehouse framework, relevant FlexRay 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 FlexRay bus.

Concrete technical scheme provided by the invention is as follows:

Design and the querying method in FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay bus data storehouse, it is advantageous that, architecture definition clear and rational can automatically preserve by machine, be written into FlexRay database file, thereby inquire about and control based on symbol.

Accompanying drawing explanation

Fig. 1 is total Organization Chart in FlexRay 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), FlexRay 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 FlexRay 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.FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay 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 FlexRay bus data according to claim 6 storehouse, it is characterized in that, all message lists that node by appointment can find it to send, can find its all signal lists that receive simultaneously, thus the list of constructing its all messages that receive.