CN107679137A - Automobile Service data record method based on Version Control - Google Patents
Automobile Service data record method based on Version Control Download PDFInfo
- Publication number
- CN107679137A CN107679137A CN201710866285.0A CN201710866285A CN107679137A CN 107679137 A CN107679137 A CN 107679137A CN 201710866285 A CN201710866285 A CN 201710866285A CN 107679137 A CN107679137 A CN 107679137A
- Authority
- CN
- China
- Prior art keywords
- maintenance
- record
- data
- information
- maintenance objects
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000012423 maintenance Methods 0.000 claims abstract description 133
- 230000000875 corresponding effect Effects 0.000 claims description 36
- 230000001174 ascending effect Effects 0.000 claims description 2
- 238000013500 data storage Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 6
- 238000007726 management method Methods 0.000 description 5
- 230000001276 controlling effect Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 230000008439 repair process Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000035800 maturation Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/20—Administration of product repair or maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Vehicle Cleaning, Maintenance, Repair, Refitting, And Outriggers (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to Automobile Service technical field of data processing, specifically, is related to a kind of Automobile Service data record method based on Version Control.Maintenance objects information corresponding with maintenance objects is stored in the first tables of data by it, and service record information corresponding with maintenance record is stored in the second tables of data；For any maintenance objects, by with any maintenance objects corresponding to all service record informations of maintenance objects information and corresponding any all maintenance records of maintenance objects establish one-to-many incidence relation；For all previous service record information of the corresponding same all previous maintenance record of maintenance objects, sequentially foundation order incidence relation.Simple easily realization of the invention, can not only significantly save data storage space, and also assures that the integrality and continuity of data.
Description
Technical field
The present invention relates to Automobile Service technical field of data processing, specifically, is related to a kind of Automobile Service number based on Version Control
According to recording method.
Background technology
Motor vehicle repair maintenance service (hereinafter referred to as Automobile Service) is a more special process, different from other service business
, Automobile Service is one repeated in certain certain period of time a process, but caused by each process repeats
Data have very close contact both with former difference.Such as, for same car, its maintenance objects information is substantially not
Change can be produced, but each service record information is different.
A variety of management softwares for automobile maintenance industry are currently, there are, the main purpose of this kind of software is exactly to manage Automobile Service
Data.Generally, motor vehicle repair safeguards that manufacturer needs to retain all Automobile Service data, for inquiring about in the future.But due to Automobile Service data
Particularity, how effectively to manage the data of Automobile Service, be a comparison stubborn problem for each software developer.So far
Untill the present, method that most Software for Design developers use to automobile maintenance industry data management be establish it is one very big with more
The Database Lists of attribute, stored using each Automobile Service data as independent a line of Database Lists.
Using it is existing it is such a tiling (flat) Database Lists a largest benefit be exactly the construction of table very
Simply, the operation of data access is easier.But its shortcomings that is also obviously, to be in particular in the following aspects：
1st, substantial amounts of Data duplication storage；2nd, the correlation degree between data is poor；3rd, dependence is not in time, operation order for data
It is simple and clear.
The content of the invention
Present disclosure is to provide a kind of Automobile Service data record method based on Version Control, and it can overcome existing skill
Certain or some defects of art.
According to the Automobile Service data record method based on Version Control of the present invention, it will maintenance pair corresponding with maintenance objects
Image information is stored in the first tables of data, and service record information corresponding with maintenance record is stored in the second tables of data；
For any maintenance objects, will with maintenance objects information corresponding to any maintenance objects with it is corresponding described any
All service record informations of all maintenance records of maintenance objects establish one-to-many incidence relation；
For all previous service record information of the corresponding same all previous maintenance record of maintenance objects, sequentially foundation order
Incidence relation.
For automobile maintenance industry, a vehicle maintenance maintenance data includes numerous information, mainly have including information of vehicles,
Maintenance objects information and service record information including Customer Information etc..For a fixed car, in its whole life
In cycle, it is necessary to by multiple maintenance, and maintenance data can be produced every time by maintaining.Under normal circumstances,
For a certain maintenance objects, comparatively its maintenance objects information is that comparison is fixed, but each service record information
All it is different.
The present invention Automobile Service data record method, can individually by maintenance objects information record in the first tables of data,
And service record information is stored in the second tables of data, meanwhile, for all service record information energy of same maintenance objects
It is enough to establish one-to-many association with corresponding maintenance objects information, for all service record information energy of same maintenance objects
Enough sequentially foundation order incidence relations.This is allowed for, and for same maintenance objects, its maintenance objects information only needs to deposit
Once, its each service record information can individually be stored and established with maintenance objects information and be associated according to priority for storage,
So as to preferably avoid the repetition of same section data in Automobile Service data from storing, and because it can establish its same maintenance
The association of the related data of object consequently facilitating the inquiry of data, and due to its service record information define order association so as to
It is easy to the typing of data.
Preferably, to realize the maintenance objects information of corresponding any maintenance objects and its corresponding all maintenance record
All service record informations between one-to-many incidence relation foundation, a primary key attribute UID is added at the first tables of data, it is right
Answering the maintenance objects information of different maintenance objects has different Major keys；An attribute Tag is added at the second tables of data, it is corresponding
All service record informations of same all maintenance records of maintenance objects pass through Major key corresponding to the sensing of corresponding property value.
Primary key attribute UID at first tables of data is pointed to by the attribute Tag at the second tables of data, realizes service record information and dimension
The one-to-many association between object information is repaiied, so as to preferably ensure that associating between service record information and maintenance objects
Property.
Preferably, to realize that the order of all previous service record information of the corresponding same all previous maintenance record of maintenance objects is closed
The foundation of connection relation, an operation order controlled attribute (Rev), all previous maintenance of same maintenance objects are added at the second tables of data
Record information is by adding the carry out order association of operation order controlling value.
Preferably, operation order controlling value can be the ascending series of alphabetical order or array order.
And then the record of data is optimized, it is easy to management of the user to data.
Preferably, maintenance objects information is shown with service record information with dendrogram.So as to more simple and clear,
It is easy to management of the user to data.
Brief description of the drawings
Fig. 1 is the schematic diagram of the first tables of data in embodiment 1；
Fig. 2 is the schematic diagram of the second tables of data in embodiment 1；
Fig. 3 is the actual effect schematic diagram of the first tables of data in embodiment 1 and the second tables of data；
Fig. 4 is the storage area saving rate using the Automobile Service data in embodiment 1 during Automobile Service data record method with vehicle
Relation schematic diagram between maintenance frequency.
Embodiment
To further appreciate that present disclosure, the present invention is described in detail in conjunction with the accompanying drawings and embodiments.It should be understood that
, embodiment be only the present invention is explained and and it is non-limiting.
Embodiment 1
A kind of Automobile Service data record method based on Version Control is present embodiments provided, it will be corresponding with maintenance objects
Maintenance objects information is stored in the first tables of data, and service record information corresponding with maintenance record is stored in into the second data
In table；
For any maintenance objects, will with maintenance objects information corresponding to any maintenance objects with it is corresponding described any
All service record informations of all maintenance records of maintenance objects establish one-to-many incidence relation；
For all previous service record information of the corresponding same all previous maintenance record of maintenance objects, sequentially foundation order
Incidence relation.
For automobile maintenance industry, a vehicle maintenance maintenance data includes numerous information, mainly have including information of vehicles,
Maintenance objects information and service record information including Customer Information etc..For a fixed car, in its whole life
In cycle, it is necessary to by multiple maintenance, and maintenance data can be produced every time by maintaining.Under normal circumstances,
For a certain maintenance objects, comparatively its maintenance objects information is that comparison is fixed, but each service record information
All it is different.
The Automobile Service data record method of the present embodiment, can be individually by maintenance objects information record in the first tables of data
In, and service record information is stored in the second tables of data, meanwhile, for all service record informations of same maintenance objects
One-to-many association can be established with corresponding maintenance objects information, for all service record informations of same maintenance objects
Being capable of sequentially foundation order incidence relation.This is allowed for, and for same maintenance objects, its maintenance objects information only needs
Once, its each service record information can individually be stored and established with maintenance objects information and be closed according to priority for storage
Connection, so as to preferably avoid the repetition of same section data in Automobile Service data from storing, and can to establish its same due to it
The association of the related data of maintenance objects is associated because its service record information defines order consequently facilitating the inquiry of data
Consequently facilitating the typing of data.
With reference to shown in Fig. 1 and 2, to realize the maintenance objects information of corresponding any maintenance objects and its corresponding all dimension
The foundation of one-to-many incidence relation between all service record informations of record is repaiied, a primary key attribute is added at the first tables of data
UID, the maintenance objects information of corresponding different maintenance objects have different Major keys；An attribute is added at the second tables of data
Tag, all service record informations of corresponding same all maintenance records of maintenance objects are pointed to by corresponding property value to be corresponded to
Major key.
Fig. 1 is the schematic diagram of the first tables of data, and its each blank line can be used in typing maintenance objects information, for not
With maintenance objects can define different Major keys primary key attribute UID at, the attribute 1~4 in Fig. 1, can be " client's letter
The information such as breath ", " information of vehicles ", " telephone number ", " license plate number ".
Fig. 2 is the schematic diagram of the second tables of data, and its each blank line can be used in typing service record information, for certain
The service record information of one maintenance objects can at its attribute Tag the typing category related to the Major key of its maintenance objects information
Property value, so that the service record information of same maintenance objects can be associated with maintenance objects information.Attribute in Fig. 2
4~6, can be such as " maintenance items ", " maintenance time ", " maintenance cost ".
It is that primary key attribute UID at the first tables of data is pointed to by attribute Tag at the second tables of data in the present embodiment,
And realize between service record information and maintenance objects information it is one-to-many associate, so as to preferably ensure that maintenance record is believed
Relevance between breath and maintenance objects.
With reference to shown in 2, to realize the order of all previous service record information of the corresponding same all previous maintenance record of maintenance objects
The foundation of incidence relation, an operation order controlled attribute Rev, all previous maintenance of same maintenance objects are added at the second tables of data
Record information is by adding the carry out order association of operation order controlling value.
In the present embodiment, operation order controlling value can be the incremental number of alphabetical order or array order
Row.If alphabetical ordered series of numbers can be A, B, C, D......, digital ordered series of numbers can be 1,2,3.......So as to it is preferable that same
Each service record information of one maintenance objects can be arranged in chronological order, and then optimize the record of data, be easy to
Management of the user to data.
With reference to shown in Fig. 3, maintenance objects information is shown with service record information with dendrogram.So as to more directly perceived bright
, it is easy to management of the user to data.
In addition, the Automobile Service data record method for passing through the present embodiment, additionally it is possible to greatly save the memory space of data.
For a certain fixed maintenance objects, the storage area saving rate (f) of its Automobile Service data is with vehicle maintenance number
(n) relation between can be calculated with below equation：
In above-mentioned formula, n represents the maintenance frequency of the maintenance objects, nSIRepresent the length of maintenance objects information, nSR nSI
Represent the length of service record information, nSI/(nSI+nSR) represent occupation rate of the maintenance objects information to memory space.
With reference to shown in Fig. 4, wherein lines 1,2,3 and 4 represent n respectivelySI/(nSI+nSR) it is 30%, 40%, 50% and 70%
When storage area saving rate (f) with the relation between vehicle maintenance number (n).
As seen in Figure 4, memory space can be greatlyd save by the method for the present embodiment.Such as a nSI/
(nSI+nSR) for 50% Automobile Service data for, when vehicle maintenance number (n) be more than 5 times when, it becomes possible to save 40% storage
Space.
The Automobile Service data record method of the present embodiment is simply easily realized, can not only significantly save data storage space, and
And it also assures that the integrality and continuity of data.And due also to introduce the more maturation used in the prior art
Version control attribute so that simpler, clear when managing the operation order and relevance of Automobile Service data.
Schematically the present invention and embodiments thereof are described above, this describes no restricted, institute in accompanying drawing
What is shown is also one of embodiments of the present invention, and actual structure is not limited thereto.So if common skill of this area
Art personnel are enlightened by it, without departing from the spirit of the invention, without designing and the technical scheme for creativeness
Similar frame mode and embodiment, protection scope of the present invention all should be belonged to.
Claims (5)
1. the Automobile Service data record method based on Version Control, maintenance objects information corresponding with maintenance objects is stored in by it
In one tables of data, and service record information corresponding with maintenance record is stored in the second tables of data；
, will be with maintenance objects information corresponding to any maintenance objects and corresponding any maintenance for any maintenance objects
All service record informations of all maintenance records of object establish one-to-many incidence relation；
For all previous service record information of the corresponding same all previous maintenance record of maintenance objects, sequentially foundation order association
Relation.
2. the Automobile Service data record method according to claim 1 based on Version Control, it is characterised in that：It is corresponding to realize
It is one-to-many between the maintenance objects information of any maintenance objects and all service record informations of its corresponding all maintenance record
Incidence relation foundation, a primary key attribute (UID), the maintenance objects of corresponding different maintenance objects are added at the first tables of data
Information has different Major keys；An attribute (Tag), corresponding same all maintenance notes of maintenance objects are added at the second tables of data
All service record informations of record pass through Major key corresponding to the sensing of corresponding property value.
3. the Automobile Service data record method according to claim 2 based on Version Control, it is characterised in that：It is corresponding to realize
The foundation of the order incidence relation of all previous service record information of the same all previous maintenance record of maintenance objects, at the second tables of data
An operation order controlled attribute (Rev) is added, all previous service record information of same maintenance objects is by adding operation order control
Value carry out order association processed.
4. the Automobile Service data record method according to claim 3 based on Version Control, it is characterised in that：Operation order control
Value processed can be the ascending series of alphabetical order or array order.
5. the Automobile Service data record method according to claim 4 based on Version Control, it is characterised in that：Maintenance objects are believed
Breath is shown with service record information with dendrogram.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710866285.0A CN107679137A (en) | 2017-09-22 | 2017-09-22 | Automobile Service data record method based on Version Control |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710866285.0A CN107679137A (en) | 2017-09-22 | 2017-09-22 | Automobile Service data record method based on Version Control |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107679137A true CN107679137A (en) | 2018-02-09 |
Family
ID=61137828
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710866285.0A Pending CN107679137A (en) | 2017-09-22 | 2017-09-22 | Automobile Service data record method based on Version Control |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107679137A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120131004A1 (en) * | 2008-08-11 | 2012-05-24 | Mcdermott Matt | Method for enhanced vehicle service |
| CN103646304A (en) * | 2013-11-21 | 2014-03-19 | 桂林福冈新材料有限公司 | A automobile fitting data management system based on a Delphi |
| CN106709577A (en) * | 2016-12-13 | 2017-05-24 | 深圳市元征科技股份有限公司 | Vehicle maintenance record tracking method and apparatus thereof |
-
2017
- 2017-09-22 CN CN201710866285.0A patent/CN107679137A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120131004A1 (en) * | 2008-08-11 | 2012-05-24 | Mcdermott Matt | Method for enhanced vehicle service |
| CN103646304A (en) * | 2013-11-21 | 2014-03-19 | 桂林福冈新材料有限公司 | A automobile fitting data management system based on a Delphi |
| CN106709577A (en) * | 2016-12-13 | 2017-05-24 | 深圳市元征科技股份有限公司 | Vehicle maintenance record tracking method and apparatus thereof |
Non-Patent Citations (2)
| Title |
|---|
| MATTHEW B. MILES 等: "《质性资料的分析：方法与实践 第2版》", 31 August 2008, 重庆大学出版社 * |
| 肖勇波 等: "《用Access 2000和Visual FoxPro 6.0管理公司和个人数据》", 30 June 2001, 清华大学出版社 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8484157B2 (en) | Compensating for unbalanced hierarchies when generating OLAP queries from report specifications | |
| CN101448002A (en) | Method and device for accessing digital resources | |
| CN101866360A (en) | Data warehouse authentication method and system based on object multidimensional property space | |
| MXPA03004370A (en) | Contact user interface. | |
| CN1963851A (en) | System for managing knowledge facing cooperated work | |
| CN104636338B (en) | A kind of data cleansing storage method for the monitoring of value-added tax negative and positive ticket | |
| US8296650B2 (en) | Technique to improve data entry efficiency in a user interface | |
| CN105335822B (en) | Big data analysis-oriented unified data model modeling method for smart power grid | |
| Avlonitis et al. | Some Dangerous Axioms of Production Elimination Decision‐making | |
| CN109739957A (en) | Document information input method, device, equipment and storage medium based on data processing | |
| CN110096509A (en) | Realize that historical data draws the system and method for storage of linked list modeling processing under big data environment | |
| CN101770469A (en) | Page based data query method and system thereof | |
| CN103744943A (en) | Data inputting method applied to position evaluation system | |
| CN107679137A (en) | Automobile Service data record method based on Version Control | |
| CN102479205B (en) | Generation method and system of change order | |
| JP2020064552A (en) | Vehicle management system, vehicle management apparatus, and vehicle management method | |
| US8473375B2 (en) | Utilizing supporting dimensions to further define transaction entities in a computerized financial/accounting system | |
| CN109992980A (en) | A kind of user right multi-model management method | |
| CN109359132A (en) | A kind of method of data processing, device and system | |
| CN109918875A (en) | Right management method, device, system and the storage medium of assembled design document | |
| Sweeney et al. | Teradata Data Mart Consolidation Return on Investment at GST | |
| JPH11265410A (en) | Vehicle sharing system having vehicle allocation means for inspection waiting vehicle and vehicle allocation method | |
| CN101944127B (en) | Method and device for controlling data permission | |
| CN113157692A (en) | Relational memory database system | |
| Forst | Overburdened Courts and Underutilized Information Technology: A Modern Prescription for a Chronic Disorder |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180209 |