Method and system for supporting batch TBOX basic data storage

Abstract

The invention provides a method for supporting batch TBOX basic data storage. The method comprises the following steps: verifying input TBOX basic data; after the verification of the TBOX basic data is successful, importing the TBOX basic data into a database; and obtaining a storage result of the TBOX basic data, and performing corresponding processing based on the storage result. According to the invention, through integration of each interface such as each part and vehicle binding relationship, the adaptation problem of different supplier brands is solved, and the warehousing efficiency is greatly improved on the premise of conforming to logic.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of terminal data loading, and in particular to a method and system for supporting batch TBOX basic data loading. BACKGROUND

[0002] With the rapid development of Internet of Vehicles technology, the number of TBOX installed in vehicles has increased dramatically. As the core device of Internet of Vehicles, TBOX is responsible for collecting various data of vehicles and uploading them to the cloud server, while receiving control instructions issued by the server. In order to effectively manage and monitor these TBOX devices, their basic data needs to be stored in the database.

[0003] The current TBOX basic data loading method is mainly completed through interface calling. The complete implementation process is to first complete the code writing, then package the service on the designated server, and the demand personnel can call the interface through the network gateway using the http request method to complete the TBOX basic data loading work.

[0004] However, the existing TBOX basic data loading method mostly adopts the way of inserting single data one by one. When facing a large number of TBOX devices, the efficiency of this method is extremely low, which consumes a lot of time and system resources, seriously affecting the overall performance and response speed of the Internet of Vehicles system. In addition, the traditional method lacks effective error handling and checking mechanism in the data loading process, which easily leads to data loss or error storage, reducing the accuracy and reliability of the data. Therefore, it is urgent to develop a method and system for supporting batch TBOX basic data loading to solve the existing technical problems. SUMMARY

[0005] The present application aims to solve at least one of the technical problems in the prior art, and proposes a method for supporting batch TBOX basic data loading.

[0006] In a first aspect, the embodiments of the present application provide a method for supporting batch TBOX basic data loading, comprising:

[0007] verifying the input TBOX basic data;

[0008] When the TBOX basic data verification is successful, the TBOX basic data is imported into the database;

[0009] Obtaining the TBOX basic data loading result, and performing corresponding processing based on the loading result.

[0010] Further, the TBOX basic data at least includes a TBOX serial number, a TBOX hardware version number, a TBOX software version number, a mobile user identification code, a mobile device identification code, an integrated circuit card identification code, a vehicle networking card belonging to an operator, a production line off-line date, a TBOX delivery destination, a Bluetooth module supplier number, a security chip ID and a Bluetooth key MAC.

[0011] Further, the input TBOX basic data is checked, and the specific method includes: performing integrity checking on the input TBOX basic data, and the data for integrity checking at least includes a TBOX serial number, a TBOX hardware version, a TBOX software version, a mobile user identification code, an integrated circuit card identification, a vehicle networking card belonging to an operator and a Bluetooth key MAC; and performing checking on the data repetition to determine whether the TBOX serial number, the mobile user identification code and the Bluetooth key MAC already exist in a database.

[0012] Further, when the input TBOX basic data is checked, the TBOX basic data is also written into a target file, the target file is used for writing the TBOX basic data according to a preset rule, and after the target file is written, the target file is uploaded to a cloud platform.

[0013] Further, the TBOX basic data is imported into a database, and the specific method includes:

[0014] It is judged whether the TBOX basic data is abnormal, if not, a TBOX object is created, the TBOX basic data is imported into the database, and a TBOX basic information table is obtained;

[0015] A first relationship table is created, the first relationship table is used for recording a part binding relationship, and after vehicle information is completely recorded, relevant information of another part can be obtained from one part through the part relationship table;

[0016] A sim card information table is created, binding information of the sim card information table and the TBOX basic information table is obtained, and the binding information is recorded in a second relationship table.

[0017] Further, the TBOX basic data is imported into a database, and the specific method further includes:

[0018] A brand authorization table is created, the brand authorization table is used for distinguishing the permissions of different background management personnel, and the background management personnel with different permissions can only find brand vehicles and part data with the permissions in the background management system.

[0019] Further, the TBOX basic data warehousing result is acquired, and corresponding processing is performed based on the warehousing result, and the specific method comprises the following steps: if the TBOX basic data warehousing result fails, the warehousing failure reason is acquired, and the warehousing failure reason is sent to the corresponding administrator.

[0020] In a second aspect, the embodiment of the present application provides a system supporting batch TBOX basic data warehousing, adopts the data warehousing method, and comprises the following steps:

[0021] The TBOX basic data verification unit is used for verifying the input TBOX basic data.

[0022] The TBOX basic data import unit is used for importing the TBOX basic data into the database when the TBOX basic data verification succeeds.

[0023] The TBOX basic data warehousing result processing unit is used for acquiring the TBOX basic data warehousing result and performing corresponding processing based on the warehousing result.

[0024] Further, the TBOX basic data verification unit verifies the input TBOX basic data, and the specific method comprises the following steps: the integrity of the input TBOX basic data is verified, and the data for integrity verification at least comprises a TBOX serial number, a TBOX hardware version, a TBOX software version, a mobile user identification code, an integrated circuit card identification, a vehicle internet card operator and a Bluetooth key MAC; and the data is verified for repeatability, and it is judged whether the TBOX serial number, the mobile user identification code and the Bluetooth key MAC exist in the database.

[0025] Further, the TBOX basic data is imported into the database, and the specific method comprises the following steps:

[0026] It is judged whether the TBOX basic data is abnormal, if not, a TBOX object is created, the TBOX basic data is imported into the database, and a TBOX basic information table is obtained.

[0027] A first relationship table is created, the first relationship table is used for recording part binding relationship, and after vehicle information is completely recorded, relevant information of another part can be obtained from one part through the part relationship table.

[0028] A sim card information table is created, binding information of the sim card information table and the TBOX basic information table is acquired, and the binding information is recorded in a second relationship table created in advance.

[0029] A brand authorization table is created, the brand authorization table is used for distinguishing the permissions of different background management personnel, and the background management personnel with different permissions can only find brand vehicles and part data with their permissions in the background management system.

[0030] In a third aspect, an electronic device is provided, comprising:

[0031] one or more processors;

[0032] a memory storing one or more programs;

[0033] When the one or more programs are executed by the one or more processors, the one or more processors implement the method for data warehousing.

[0034] In a fourth aspect, a computer readable medium is provided, and the computer readable medium stores a computer program, and the computer program is executed by a processor to implement steps in the method for data warehousing.

[0035] The method for supporting batch TBOX basic data warehousing provided by the present application comprises the following steps: checking input TBOX basic data; when the TBOX basic data is successfully checked, importing the TBOX basic data into a database; obtaining a TBOX basic data warehousing result, and performing corresponding processing based on the warehousing result. Through the integration of various interfaces such as the binding relationship between each part and a vehicle, the present application not only solves the adaptation problem of different supply brands, but also greatly improves the warehousing efficiency under the premise of meeting the logic. The present application improves the warehousing efficiency, and when multiple TBOXs are warehoused, it is not necessary to request an interface to enter relevant information one by one, but only to write all the information into a file and then enter all the information into the database. The present application facilitates the related work of the supplier. Different parts of different vehicles correspond to different suppliers, and different suppliers only need to transmit the part information produced by themselves into the cloud platform, without considering other part information, only to confirm that the part information is correct, thereby reducing the communication cost. BRIEF DESCRIPTION OF DRAWINGS

[0036] Figure 1 A flowchart of the method for supporting batch TBOX basic data warehousing provided by the present application is shown.

[0037] Figure 2 A flowchart of the method for importing TBOX basic data into a database provided by the present application is shown.

[0038] Figure 3 A structure block diagram of the system for supporting batch TBOX basic data warehousing provided by the present application is shown.

[0039] Figure 4 A structure block diagram of the electronic device provided by the present application is shown. DETAILED DESCRIPTION

[0040] In order for those skilled in the art to better understand the technical solutions of the present application, the exemplary embodiments of the present application are described below in conjunction with the drawings, which include various details of the embodiments of the present application to help understanding, and should be considered as merely exemplary. Therefore, those of ordinary skill in the art should recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of the present application. Also, for the sake of clarity and conciseness, the description below omits the description of well-known functions and structures.

[0041] In the case of no conflict, each embodiment of the present application and each feature in the embodiments can be combined with each other.

[0042] As used herein, the term "and / or" includes any and all combinations of one or more of the associated listed items.

[0043] The terms used herein are only used to describe specific embodiments and are not intended to limit the present application. As used herein, the singular forms "a" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will also be understood that the terms "comprise" and / or "consist of, when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and / or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and / or groups thereof. The terms "connected" or "coupled" and / or similar terms are not limited to a physical or mechanical connection, but can include an electrical connection, whether direct or indirect.

[0044] Unless otherwise defined, all terms used herein, including technical and scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art. It will also be understood that terms such as those defined in commonly used dictionaries should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and the present application, and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.

[0045] In the technical solutions of the present application, the collection, storage, use, processing, transmission, provision, and disclosure of user personal information comply with relevant laws and regulations and do not violate public order and good customs. The use of user data in the technical solutions complies with relevant national laws and regulations (e.g., "Information Security Technology Personal Information Security Specification"). For example, appropriate measures are taken for personal information access control; restrictions are given for the display of personal information; the use of personal information does not exceed the direct or reasonably related scope; the use of personal information eliminates explicit identity pointing and avoids precise positioning to a specific individual.

[0046] In the related art, the TBOX basic data warehousing method mainly completes the warehousing of the basic information of the tbox through the interface calling mode. The complete implementation process is that the code writing work is completed first, then the service is packaged on the designated server, and the demand personnel can call the interface through the network gateway using the http request mode to complete the warehousing of the basic data of the tbox. When there is a demand for batch warehousing of suppliers, if the basic information of the tbox is still warehoused one by one as before, it may cause the problem of too long time consumption.

[0047] To solve at least one of the technical problems existing in the related art, the embodiments of the present application provide a method and system for supporting batch TBOX basic data warehousing.

[0048] In the present embodiment, a method for supporting batch TBOX basic data warehousing is provided, which comprises: Figure 1

[0049] S100. Verify the input TBOX basic data; by verifying the input TBOX basic data, it is judged whether the data in the database conflicts with the transmitted data, for example, whether the transmitted sim card information has been bound, whether the tbox basic information has been warehoused, etc.

[0050] In the present embodiment, as shown in Table 1, the TBOX basic data at least includes TBOX serial number, TBOX hardware version number, TBOX software version number, mobile user identification code, mobile device identification code, integrated circuit card identification code, car networking card belonging to operator, production line off-line date, TBOX delivery destination, Bluetooth module supplier number, security chip ID and Bluetooth key MAC.

[0051] Table 1 TBOX basic data

[0052] Parameter Type Remark tboxPdsn String TBOX serial number TboxHardware String TBOX hardware version number tobSoftware String TBOX software version number imsi String Mobile user identification code Imei String Mobile device identification code Iccid String Integrated circuit card identification code Suppler String Operator of the Internet of Vehicles card eolDate String Production line off-line date Destination String Tbox delivery destination bleProviderNo String Bluetooth module supplier number Seid String Security chip ID TboxMac String Bluetooth key mac

[0053] In the present embodiment, the input TBOX basic data is verified, and the specific method comprises: firstly, the integrity of the input TBOX basic data is verified, and the data of the integrity verification at least includes TBOX serial number, TBOX hardware version, TBOX software version, mobile user identification code, integrated circuit card identification, car networking card belonging to operator and Bluetooth key MAC, if these information is missing, then directly return error; then the repeatability of the data is verified, it is judged whether the TBOX serial number, mobile user identification code and Bluetooth key MAC exist in the database, if these information is repeated, it will also return error.

[0054] ​S200. When the TBOX basic data verification succeeds, the TBOX basic data is imported into a database; in the embodiment, the TBOX basic data is imported into a database, as shown in Figure 2 The specific method comprises the following steps:

[0055] S201. It is judged whether the TBOX basic data is abnormal, if not, a TBOX object is created, the TBOX basic data is imported into a database, and a TBOX basic information table is obtained;

[0056] S202. A first relationship table is created, the first relationship table is used for recording a part binding relationship, after vehicle information is completely recorded, relevant information of another part can be obtained from one part through the part relationship table, for example, relevant information of a car machine can be found through a TBOX;

[0057] S203. A sim card information table is created, binding information of the sim card information table and the TBOX basic information table is obtained, and the binding information is recorded in a second relationship table created in advance. The reason why the sim card table does not create data information in the first relationship table is that the sim card and the TBOX are a strong binding relationship, other parts in the first relationship table can be replaced, that is, after a part information on a vehicle is modified, a background interface is triggered to complete a change of background information relationship, but the sim information cannot be replaced alone, only when the TBOX is replaced, the information will change, so the binding information of the TBOX and the sim is recorded in the second relationship table, and after the sim card information is created, the binding relationship between the sim card and the TBOX is recorded in the second relationship table.

[0058] In some preferred embodiments, the TBOX basic data is imported into a database, and the specific method further comprises the following step: S204. A brand authorization table is created, the brand authorization table is used for distinguishing permissions of different background management personnel, and the background management personnel with different permissions can only find brand vehicles and part data with permissions in the background management system.

[0059] The TBOX basic data is imported into a database through the method disclosed in the application, the efficiency of warehousing is improved, when multiple TBOXs are warehoused, it is not necessary to request an interface to record relevant information one by one, but only to write all information into a file, and record all information into a database. It is also convenient for relevant work of a supplier, parts corresponding to different vehicles correspond to different suppliers, different suppliers only need to transmit part information produced by the supplier into a cloud platform, without considering other part information, only to confirm that the part information of the supplier is correct, and the communication cost is reduced.

[0060] S300. Obtain the TBOX basic data warehousing result, and perform corresponding processing based on the warehousing result. In this embodiment, corresponding processing is performed based on the warehousing result, and the specific method includes: if the TBOX basic data warehousing result fails, obtaining a warehousing failure reason, and sending the warehousing failure reason to a corresponding administrator.

[0061] Specifically, in the case of a successful entire warehousing process, there is no stage of abnormal processing. If some abnormal conditions occur in the warehousing process, such as incomplete information entry, non-standard field filling, and the like, in this process, the program will capture the corresponding exception, and send the detailed error place to the corresponding administrator in the form of an email, so that the administrator can discover and solve the corresponding problem in the first time when the problem occurs.

[0062] The method provided by the embodiment supports batch TBOX basic data warehousing, includes: checking input TBOX basic data; when the TBOX basic data is checked successfully, importing the TBOX basic data into a database; obtaining a TBOX basic data warehousing result, and performing corresponding processing based on the warehousing result. Through integration of various interfaces such as the binding relationship between each part and a vehicle, the method solves the adaptation problem of different supply brands, greatly improves the warehousing efficiency under the premise of meeting the logic, and improves the warehousing efficiency. When multiple TBOXs are warehoused, it is not necessary to request an interface to enter related information one by one, but only to write all information into a file and enter all information into the database. The method facilitates the related work of a supplier, different parts of different vehicles correspond to different suppliers, different suppliers only need to input part information produced by themselves into a cloud platform, do not need to consider other part information, only need to confirm that the part information is correct, and the communication cost is reduced.

[0063] Based on the same inventive concept, the embodiment of the present application also provides a system for supporting batch TBOX basic data warehousing, as shown in Figure 3 , which includes:

[0064] The TBOX basic data checking unit is configured to check the input TBOX basic data; in this embodiment, the TBOX basic data checking unit checks the input TBOX basic data, and the specific method comprises: firstly, checking the integrity of the input TBOX basic data, and the data for integrity checking at least includes the TBOX serial number, the TBOX hardware version, the TBOX software version, the mobile user identification code, the integrated circuit card identification, the operator to which the Internet of Vehicles card belongs, and the Bluetooth key MAC, and if any of these information is missing, an error is returned; then, checking the data for repetition, and judging whether the TBOX serial number, the mobile user identification code and the Bluetooth key MAC exist in the database, and if any of these information is repeated, an error is returned.

[0065] The TBOX basic data importing unit is configured to import the TBOX basic data into the database when the TBOX basic data checking succeeds.

[0066] In this embodiment, the TBOX basic data importing unit imports the TBOX basic data into the database, and the specific method comprises:

[0067] S201. judging whether the TBOX basic data is abnormal, and if not, creating a TBOX object, importing the TBOX basic data into the database, and obtaining a TBOX basic information table;

[0068] S202. creating a first relationship table, and the first relationship table is configured to record the binding relationship of parts, and after the vehicle information is completely input, the relevant information of another part can be obtained from one part through the part relationship table, for example, the relevant information of the car machine can be obtained through the TBOX;

[0069] S203. creating a sim card information table, obtaining the binding information of the sim card information table and the TBOX basic information table, and recording the binding information in a second relationship table created in advance. The reason why the sim card table does not create data information in the first relationship table is that the sim card and the TBOX are in a strong binding relationship, and other parts in the first relationship table can be replaced, that is, after the information of one part on the vehicle is modified, the background interface is triggered to complete the change of the background information relationship, but the sim information cannot be replaced alone, and only when the TBOX is replaced, the information will change, so the binding information of the TBOX and the sim is recorded in the second relationship table, and after the sim card information is created, the binding relationship between the sim card and the TBOX is recorded in the second relationship table.

[0070] S204. A brand authorization table is created to distinguish the permissions of different background managers, and the background managers with different permissions can only check the brand vehicles and part data with their permissions in the background management system.

[0071] A TBOX basic data warehousing result processing unit is configured to obtain the TBOX basic data warehousing result and perform corresponding processing based on the warehousing result. In this embodiment, the TBOX basic data warehousing result processing unit performs corresponding processing based on the warehousing result, and the specific method includes: if the TBOX basic data warehousing result fails, obtaining the warehousing failure reason and sending the warehousing failure reason to the corresponding administrator.

[0072] Based on the same inventive concept, the embodiment of the present application also provides an electronic device. Figure 4 A structural block diagram of an electronic device provided by the embodiment of the present application is shown in FIG. 1. As shown in FIG. 1, the embodiment of the present application provides an electronic device including one or more processors 101, a memory 102, and one or more I / O interfaces 103. The memory 102 stores one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors implement the method of data warehousing in any of the above embodiments; the one or more I / O interfaces 103 are connected between the processor and the memory and are configured to realize the information interaction between the processor and the memory. Figure 4

[0073] The processor 101 is a device with data processing capability, including but not limited to a central processing unit (CPU) and the like; the memory 102 is a device with data storage capability, including but not limited to a random access memory (RAM, more specifically SDRAM, DDR, etc.), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), and a flash memory (FLASH); the I / O interface (read-write interface) 103 is connected between the processor 101 and the memory 102 and can realize the information interaction between the processor 101 and the memory 102, including but not limited to a data bus (Bus) and the like.

[0074] In some embodiments, the processor 101, the memory 102, and the I / O interface 103 are connected to each other through a bus 104 and further connected to other components of the computing device.

[0075] In some embodiments, the one or more processors 101 include a field programmable gate array.

[0076] ​The embodiment of the present application also provides a computer readable medium. The computer readable medium stores a computer program, wherein the program is executed by a processor to implement the steps in the data warehousing method in any of the above embodiments. The computer readable storage medium can be a volatile or non-volatile computer readable storage medium.

[0077] The embodiment of the present application also provides a computer program product, comprising computer readable code or a non-volatile computer readable storage medium carrying computer readable code, when the computer readable code is run in a processor of an electronic device, the processor in the electronic device executes the data warehousing method.

[0078] Those skilled in the art can understand that all or some of the steps in the above disclosed method, the functions of the modules / units in the system and the device can be implemented as software, firmware, hardware and appropriate combinations thereof. In the hardware implementation, the division between the functional modules / units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component can have multiple functions, or one function or step can be performed by several physical components in cooperation. Some or all of the physical components can be implemented as software executed by a processor, such as a central processing unit, a digital signal processor or a microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software can be distributed on a computer readable storage medium, which can include computer storage media (or non-transitory media) and communication media (or transitory media).

[0079] As known to those skilled in the art, the term computer storage media includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable program instructions, data structures, program modules or other data. Computer storage media includes, but is not limited to, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM), static random access memory (SRAM), flash memory or other memory technology, portable compact disc read only memory (CD-ROM), digital versatile disc (DVD) or other optical disk storage, magnetic cassettes, magnetic tapes, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and can be accessed by a computer. In addition, it is known to those skilled in the art that communication media typically includes computer readable program instructions, data structures, program modules or other data in modulated data signals such as carrier waves or other transport mechanisms, and can include any information delivery medium.

[0080] The computer readable program instructions described herein can be downloaded to respective computing / processing devices from a computer readable storage medium or to an external computer or external storage device via a network, for example, the Internet, a local area network, a wide area network and / or a wireless network. The network can comprise copper transmission cables, optical transmission fibers, wireless transmission, routers, firewalls, switches, gateway computers and / or edge servers. A network adapter card or network interface in each computing / processing device receives computer readable program instructions from the network and forwards the computer readable program instructions for storage in a computer readable storage medium within the respective computing / processing device.

[0081] Computer readable program instructions for carrying out operations of the present application can be assembler instructions, instruction-set-architecture (ISA) instructions, machine instructions, machine dependent instructions, microcode, firmware instructions, state-setting data, or either source code or object code written in any combination of one or more programming languages, including an object oriented programming language such as Smalltalk, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The computer readable program instructions can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider). In some embodiments, electronic circuitry including, for example, programmable logic circuitry, field-programmable gate array (FPGA), or programmable logic array (PLA) can execute the computer readable program instructions by utilizing state information of the computer readable program instructions to personalize the electronic circuitry, in order to perform aspects of the present application.

[0082] The computer program product described herein can be embodied specifically by hardware, software or a combination thereof. In an alternative embodiment, the computer program product is embodied specifically as a computer storage medium, and in another alternative embodiment, the computer program product is embodied specifically as a software product, such as a software development kit (SDK) or the like.

[0083] The computer program product described herein can be embodied specifically by hardware, software or a combination thereof. In an alternative embodiment, the computer program product is embodied specifically as a computer storage medium, and in another alternative embodiment, the computer program product is embodied specifically as a software product, such as a software development kit (SDK) or the like.

[0084] These computer readable program instructions can be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks. These computer readable program instructions can also be stored in a computer readable storage medium that can include a non-transitory computer readable storage medium that can be a computer- readable storage medium having no data storage cycles that change state. The instructions can be executed by one or more processors of a computer, other programmable data processing apparatus, or other devices to produce a computer-implemented process such that the instructions which execute via the one or more processors of the computer or other programmable data processing devices create means for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks. The computer program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0085] The computer readable program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0086] The flow diagrams and the block diagrams in the drawings are presented to illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to the present application. In this regard, each block in the flow diagrams and the block diagrams can represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical functions ("instructions"). In some alternative implementations, the functions noted in the blocks can occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks can sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and / or flow diagrams, and combinations thereof, can be implemented by special purpose hardware-based systems that perform the specified functions or acts, or combinations of special purpose hardware and

[0087] Example embodiments have been disclosed herein and, although specific terms are employed, they are used in a generic and descriptive sense only and not for purposes of limitation. In some instances, it will be apparent to those skilled in the art that features, characteristics or aspects described in relation to one embodiment can be applied to other embodiments, unless otherwise clearly stated. It will also be apparent to one skilled in the art that various modifications, changes, additions and omissions can be made without departing from the scope of the present application as set forth in the claims.

Claims

1. A method for supporting batch import of basic data into a database using TBOX, characterized in that, include: Validate the input TBOX basic data; Once the TBOX basic data is successfully verified, the TBOX basic data is imported into the database. Obtain the TBOX basic data entry result and perform corresponding processing based on the entry result.

2. The data import method as described in claim 1, characterized in that, The basic data of the TBOX includes at least the TBOX serial number, TBOX hardware version number, TBOX software version number, mobile user identification code, mobile device identification code, integrated circuit card identification code, vehicle network card operator, production line decommissioning date, TBOX shipping destination, Bluetooth module supplier number, security chip ID, and Bluetooth key MAC.

3. The data import method as described in claim 2, characterized in that, The input TBOX basic data is validated, specifically by: verifying the integrity of the input TBOX basic data, which includes at least the TBOX serial number, TBOX hardware version, TBOX software version, mobile subscriber identification code, integrated circuit card identification, vehicle network card operator, and Bluetooth key MAC address; and verifying the data repeatability to determine whether the TBOX serial number, mobile subscriber identification code, and Bluetooth key MAC address already exist in the database.

4. The data import method as described in claim 1, characterized in that, Before validating the input TBOX basic data, the TBOX basic data is written to a target file. The target file is used to write the TBOX basic data according to preset rules. After the target file is written, it is uploaded to the cloud platform.

5. The data import method as described in claim 1, characterized in that, Importing the TBOX basic data into the database, specifically, includes the following methods: Determine if the TBOX basic data is abnormal. If there is no abnormality, create a TBOX object, import the TBOX basic data into the database, and obtain the TBOX basic information table. Create a first relationship table, which is used to record the binding relationship between parts. After all vehicle information has been entered, the relevant information of one part can be obtained from another part through the part relationship table. Create a SIM card information table, obtain the binding information between the SIM card information table and the TBOX basic information table, and record the binding information in a pre-created second relationship table.

6. The data import method as described in claim 5, characterized in that, Importing the TBOX basic data into the database also includes the following specific methods: Create a brand authorization table, which is used to distinguish the permissions of different back-end administrators. Back-end administrators with different permissions can only find the brand vehicles and parts data of the brands they have permission to access in the back-end management system.

7. The data import method as described in claim 1, characterized in that, Obtain the TBOX basic data entry result and perform corresponding processing based on the entry result. The specific method includes: if the TBOX basic data entry result fails, obtain the entry failure reason and send the entry failure reason to the corresponding administrator.

8. A system that supports batch import of basic data into a database (TBOX), characterized in that, include: The TBOX basic data verification unit is used to verify the input TBOX basic data. The TBOX basic data import unit is used to import the TBOX basic data into the database after the TBOX basic data verification is successful. The TBOX basic data entry result processing unit is used to obtain the TBOX basic data entry result and perform corresponding processing based on the entry result.

9. A system supporting batch import of basic data into a database (TBOX), characterized in that, The TBOX basic data verification unit verifies the input TBOX basic data. The specific methods include: verifying the integrity of the input TBOX basic data, which includes at least the TBOX serial number, TBOX hardware version, TBOX software version, mobile subscriber identification code, integrated circuit card identification, vehicle network card operator, and Bluetooth key MAC address; and verifying the data repeatability to determine whether the TBOX serial number, mobile subscriber identification code, and Bluetooth key MAC address already exist in the database.

10. A system supporting batch import of basic data into a database (TBOX), characterized in that, Importing the TBOX basic data into the database, specifically, includes the following methods: Determine if the TBOX basic data is abnormal. If there is no abnormality, create a TBOX object, import the TBOX basic data into the database, and obtain the TBOX basic information table. Create a first relationship table, which is used to record the binding relationship between parts. After all vehicle information has been entered, the relevant information of one part can be obtained from another part through the part relationship table. Create a SIM card information table, obtain the binding information between the SIM card information table and the TBOX basic information table, and record the binding information in a pre-created second relationship table; Create a brand authorization table, which is used to distinguish the permissions of different back-end administrators. Back-end administrators with different permissions can only find the brand vehicles and parts data of the brands they have permission to access in the back-end management system.

11. An electronic device, characterized in that, include: One or more processors; Memory, used to store one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the data storage method as described in any one of claims 1 to 7.

12. A computer-readable medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the data storage method as described in any one of claims 1 to 7.

Images