Vehicle state management method based on memory database

A vehicle status and management method technology, applied in data processing applications, electrical digital data processing, special data processing applications, etc., can solve problems such as inefficient management of vehicle status data, and achieve improved query processing efficiency, sufficient memory space, The effect of improving data processing speed

Active Publication Date: 2011-09-28
XIAMEN YAXON NETWORKS CO LTD
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] Aiming at the deficiencies in the existing technology, the problem that the vehicle state data cannot be efficiently managed, the present invention provides a new type of vehicle state management method based on the memory database, through the virtual memory hard disk technology, the system memory is mapped to the Virtual hard disk, create a vehicle state database under the database storage path, and transplant the vehicle state database to the memory virtual hard disk, create a vehicle state data table and create a stored procedure according to the actual business requirements in the GPS management system, for maintaining GPS management For the vehicle status data in the system, the complex logical relationship can be realized through the stored procedure algorithm, instead of converting the complex logical relationship into a one-to-one corresponding key and value relationship

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Vehicle state management method based on memory database
  • Vehicle state management method based on memory database
  • Vehicle state management method based on memory database

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0072] refer to figure 1 , figure 2 and image 3 As shown, a vehicle state management method based on an in-memory database of the present invention is applied to a GPS management system. The GPS management system includes a management host and other connected devices, and the management host includes a main service database TXServe, a vehicle status management service Resource library, vehicle status database and MYSQL database storage engine; other equipment includes network management server, business server, communication front-end computer, this GPS management system supports the high-level computer language Microsoft Visual C++ 6.0 for database development.

[0073] A vehicle state management method based on an in-memory database of the present invention includes the following processes:

[0074] Process 1: Using the memory hard disk tool of ramdisk5, virtualize a specific capacity of memory into a hard disk in the GPS management system, and create a virtual hard disk...

no. 2 example

[0120] In the second embodiment of the present invention, the vehicle state database Database is independently deployed on a server, and an in-memory virtual hard disk R disk is established, and the database file (including table structure and data) of the vehicle state database BaseData is placed in the virtual disk, And the MYSQL storage engine is also directly installed on the memory virtual disk. The process is as follows:

[0121]Process 1: Using the memory hard disk tool of ramdisk5, virtualize a specific capacity of memory into a hard disk in the GPS management system, and create a virtual hard disk R. The interface diagram for creating RamDisk is as follows figure 2 shown;

[0122] Process 2: Select the MYSQL database storage engine, directly install the MYSQL database storage engine in the R disk of the memory virtual hard disk, modify the MYSQL configuration file of my.ini, add the setting of innodb_file_per_table=1 under MYSQL, and restart the MYSQL service so as t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a novel vehicle state management method based on a memory database, comprising the steps of: mapping a system memory into a virtual disc in a system by using a virtual memory disc technology, establishing a vehicle state database under a database storage path, transplanting the vehicle state database to the virtual memory disc, and establishing a vehicle state data table and a storage process according to the actual service requirements in a GPS management system so as to maintain vehicle state data in the GPS management system, wherein complicated logic relations can be realized with a storage process algorithm, without converting the complicated logic relations into relation of key and value in one-to-one correspondence. By use of the vehicle state management method based on the memory database, million orders of magnitude vehicle state management requirements in the GPS management system can be satisfied.

Description

technical field [0001] The invention relates to the field of combining memory hard disk technology and relational database, in particular to a vehicle state management method based on the memory database. Background technique [0002] Since each vehicle basically actively reports location information at a frequency of one minute (some even only 10 seconds or 30 seconds), a vehicle needs to process more than 1,000 pieces of data a day, and each piece of GPS location information has to be sent to Authorized operator currently online. Therefore, an operator can issue commands such as monitoring and scheduling for which vehicles are authorized, and at the same time, he can receive the data actively reported by which vehicles; in turn, how to send the data reported by a vehicle to the current online who has authorization to him. These are all things to be dealt with by the vehicle status management, not only to manage and maintain the offline status of the vehicle and the operat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06Q50/00
Inventor 傅建记余建成黄奇峰
Owner XIAMEN YAXON NETWORKS CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products