CN113032470A - Method and system for counting equipment data of Internet of vehicles - Google Patents
Method and system for counting equipment data of Internet of vehicles Download PDFInfo
- Publication number
- CN113032470A CN113032470A CN202110279978.6A CN202110279978A CN113032470A CN 113032470 A CN113032470 A CN 113032470A CN 202110279978 A CN202110279978 A CN 202110279978A CN 113032470 A CN113032470 A CN 113032470A
- Authority
- CN
- China
- Prior art keywords
- imei
- equipment
- data
- login
- acquiring
- 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 39
- 238000007493 shaping process Methods 0.000 claims abstract description 16
- 230000006855 networking Effects 0.000 claims abstract description 5
- 238000004590 computer program Methods 0.000 claims description 15
- 230000001360 synchronised effect Effects 0.000 claims description 14
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 6
- 230000004931 aggregating effect Effects 0.000 claims description 5
- 238000012216 screening Methods 0.000 abstract description 5
- 230000008569 process Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000002354 daily effect Effects 0.000 description 4
- 230000003203 everyday effect Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000007619 statistical method Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000009825 accumulation Methods 0.000 description 1
- 230000004913 activation Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The embodiment of the invention discloses a method and a system for counting equipment data of a vehicle networking, wherein the method comprises the following steps: when detecting that the equipment is started and activated, acquiring an IMEI number of the equipment; converting the IMEI number of the equipment into a shaping number, and marking the shaping number as one byte; when a login instruction is detected, acquiring a login event number; and counting the equipment data of the Internet of vehicles by the login event number. The embodiment of the invention simplifies the logic of system realization by a bit mode, and mainly simplifies and removes the repeatedly logged equipment data; the resource consumption during operation is saved, the screening mode of the equipment is changed, and the equipment is screened through bit operation at a higher speed.
Description
Technical Field
The invention relates to the technical field of Internet of vehicles, in particular to a method and a system for counting equipment data of the Internet of vehicles.
Background
In the industry of the internet of vehicles, as the number of network access devices increases, the calculation method for directly performing data statistics becomes more resource-consuming and more time-consuming.
In the data which is increased at a high speed, various data errors are often hidden, for example, the disk remaining space reported to the server by the device is a negative number, which causes an abnormal error when the disk remaining space of the device is distributed; due to the fact that the same startup login information is reported twice when the network is in time-out, logic for counting the number of login devices every day is complex.
In the process of enterprise production analysis, various different device attributes are required, such as an access channel of the device, an application software version number on the device, and a firmware version number of the device. In the process of data statistics, data table synchronization is often needed, and data table contents in different databases are summarized to the same data warehouse by inquiring logs of a database binlog, so that correlation query and statistical analysis are facilitated. The statistical method can be adapted to most statistical requirements, but has the defects that when the daily produced data is gradually increased, the situation that the synchronization is difficult to realize can be generated, the influence of the daily produced data quantity is large, huge server IO resources are consumed during the synchronization, and the daily production load is equivalent; another drawback is that if the synchronization is wrong, only the synchronized data is cleared and the data synchronization is restarted, and the time cost for error processing is huge.
Since data synchronization is required and the synchronization duration is long, there is a large delay in performing real-time statistics. And the more unstable the real-time statistics become after the traffic grows.
In the login statistical service of the equipment every day, a startup event is generated when the equipment is started up every day, after the equipment is started up and networked, the startup event is sent to a server, the server writes the received events into service data records one by one, the information including the imei number, the startup time, the residual disk space of the equipment, the last login time and the like is recorded, and meanwhile, a data record table is gradually increased in a tail adding mode. And the data warehouse regularly carries out data synchronization operation, records the logged detailed records, rewrites the logged detailed records into the data warehouse and runs the statistical script. The server load in the process of duplicating is equivalent to the real-time service load, the delay is greatly influenced by the data volume, the actual needs of the service are not distinguished during synchronization, the full data synchronization is carried out, and some non-emergency resource loads are generated.
In the daily device statistics process, data subsection statistics is carried out according to the time and the date, logged devices need to be eliminated when repeated statistics is processed, data details of the previous section time need to be relied on, and business logic is complicated when repeated logged data is processed.
The prior art is therefore still subject to further development.
Disclosure of Invention
In view of the above technical problems, embodiments of the present invention provide a method and a system for counting device data of an internet of vehicles, which can solve the technical problems in the prior art that a device data counting method performs data segment counting on time and date, requires to eliminate logged devices when processing repeated counting, requires to rely on data details of previous time, and has complex processing logic.
The first aspect of the embodiment of the invention provides a method for counting device data of an internet of vehicles, which comprises the following steps:
when detecting that the equipment is started and activated, acquiring an IMEI number of the equipment;
converting the IMEI number of the equipment into a shaping number, and marking the shaping number as one byte;
when a login instruction is detected, acquiring a login event number;
and counting the equipment data of the Internet of vehicles by the login event number.
Optionally, when detecting that the device is powered on and activated, before acquiring the IMEI number of the device, the method includes:
establishing an IMEI bit definition table TBL _ A of a data table, wherein the data table comprises a field self-increment ID number, an IMEI number, a bit mask code, a channel number and an equipment type;
detects that IMEI _ a device is powered on and activated, does the lookup table TBL _ a already have IMEI _ a?
If the record of the IMEI _ A of the equipment already exists, acquiring the IMEI number of the equipment;
if the record of the IMEI _ A of the equipment does not exist, writing data into an IMEI number, a channel number and an equipment type; obtaining the recorded self-increment ID number, ID _ A, after the writing is finished; calculating a bit mask code meter of the IMEI _ A data record; and updating the bit mask code of the IMEI _ A of the equipment.
Optionally, the obtaining a login event number when the login instruction is detected includes:
detecting that equipment is started to log in and is connected to the network, and acquiring login data of the equipment, wherein the login data comprises an IMEI (international mobile equipment identity) and an event number E _ ID (identity);
identifying an IMEI number, and writing an event flow water meter of an equipment login event;
querying the IMEI bit definition table to determine if the IMEI exists?
If the IMEI does not exist, the acquisition of the login event number fails;
if the IMEI exists, acquiring a bit mask code MARK of the IMEI, and searching bit data at the current statistical time of the current day; and acquiring data.
Optionally, after the login instruction is detected and the login event number is obtained, the method further includes:
and if the synchronous request of the data warehouse is detected, acquiring the request time, searching the statistical data according to the request time and returning.
Optionally, the counting the device data of the internet of vehicles by the login event number includes:
sending a statistical request, wherein request parameters comprise channel id;
and calculating a bit mask of the channel, and aggregating the field bit mask through a bit definition table to obtain the hold _ mask.
Extracting statistical data of each minute, performing AND operation with hold _ mask, and acquiring statistical data hdata of a specified channel and the current minute;
obtaining the number of equipment logged in at the current minute by calculating the digit of 1 in the hdata;
generating registered device statistical data dataBeforen before N minutes by calculating the hdata of the previous N minutes and carrying out OR operation on the results;
obtaining the number of newly-added login equipment in the Nth minute by using a bit operation formula hdata and (not dataBeforen);
and circularly calculating each minute moment respectively to generate total equipment data of login statistics.
A second aspect of an embodiment of the present invention provides a system for performing statistics on device data in an internet of vehicles, where the system includes: a memory, a processor and a computer program stored on the memory and executable on the processor, the computer program when executed by the processor implementing the steps of:
when detecting that the equipment is started and activated, acquiring an IMEI number of the equipment;
converting the IMEI number of the equipment into a shaping number, and marking the shaping number as one byte;
when a login instruction is detected, acquiring a login event number;
and counting the equipment data of the Internet of vehicles by the login event number.
Optionally, the computer program when executed by the processor further implements the steps of:
establishing an IMEI bit definition table TBL _ A of a data table, wherein the data table comprises a field self-increment ID number, an IMEI number, a bit mask code, a channel number and an equipment type;
detects that IMEI _ a device is powered on and activated, does the lookup table TBL _ a already have IMEI _ a?
If the record of the IMEI _ A of the equipment already exists, acquiring the IMEI number of the equipment;
if the record of the IMEI _ A of the equipment does not exist, writing data into an IMEI number, a channel number and an equipment type; obtaining the recorded self-increment ID number, ID _ A, after the writing is finished; calculating a bit mask code meter of the IMEI _ A data record; and updating the bit mask code of the IMEI _ A of the equipment.
Optionally, the computer program when executed by the processor further implements the steps of:
detecting that equipment is started to log in and is connected to the network, and acquiring login data of the equipment, wherein the login data comprises an IMEI (international mobile equipment identity) and an event number E _ ID (identity);
identifying an IMEI number, and writing an event flow water meter of an equipment login event;
querying the IMEI bit definition table to determine if the IMEI exists?
If the IMEI does not exist, the acquisition of the login event number fails;
if the IMEI exists, acquiring a bit mask code MARK of the IMEI, and searching bit data at the current statistical time of the current day; and acquiring data.
And if the synchronous request of the data warehouse is detected, acquiring the request time, searching the statistical data according to the request time and returning.
A third aspect of the embodiments of the present invention provides a non-transitory computer-readable storage medium, where the non-transitory computer-readable storage medium stores computer-executable instructions, and when the computer-executable instructions are executed by one or more processors, the one or more processors may be configured to perform the above method for counting device data of a vehicle networking.
In the technical scheme provided by the embodiment of the invention, when the equipment is detected to be started and activated, the IMEI number of the equipment is acquired; converting the IMEI number of the equipment into a shaping number, and marking the shaping number as one byte; when a login instruction is detected, acquiring a login event number; and counting the equipment data of the Internet of vehicles by the login event number. Therefore, compared with the prior art, the embodiment of the invention simplifies the logic of system implementation by a bit-through mode, and mainly simplifies and removes the repeatedly logged-in equipment data; the method saves the resource consumption during operation, changes the screening mode of the equipment, screens the equipment through bit operation, configures page data at any place and time at a higher speed, performs judgment and analysis, and saves a large amount of labor and material cost consumption.
Drawings
Fig. 1 is a schematic flowchart of an embodiment of a method for performing statistics on device data of an internet of vehicles according to an embodiment of the present invention;
fig. 2 is a schematic hardware structure diagram of another embodiment of the system for counting device data of the internet of vehicles according to the embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The following detailed description of embodiments of the invention refers to the accompanying drawings.
Referring to fig. 1, fig. 1 is a schematic flowchart illustrating an embodiment of a method for counting device data of an internet of vehicles according to an embodiment of the present invention. As shown in fig. 1, includes:
step S100, when detecting that the equipment is started and activated, acquiring an IMEI number of the equipment;
step S200, converting the IMEI number of the equipment into a shaping number, and marking the shaping number as a byte;
step S300, when a login instruction is detected, acquiring a login event number;
and S400, counting the equipment data of the Internet of vehicles by the login event number.
In specific implementation, when the equipment is started and activated, the imei is converted into a unique integer number, the event is written and recorded only once for each equipment, and the imei number with 15 digits is converted into a mark with only one bit. The equipment directly lands on a data bit at each login time, and only the whole bit data needs to be synchronized when the data is synchronized. The problems that the login event data of the synchronous equipment is slow, the relevance of the service is insufficient and the performance is lost in the prior art are solved. Events must land on the data table before the data can be synchronized.
By converting the 15-bit imei number into a unique integer data, corresponding to one bit. Then the bit data will not change any more when the device repeatedly logs in, so the result of the bit operation itself is already deduplicated.
The embodiment of the invention can realize the write-in operation of the event and distinguish the event. The relatively urgent login statistical service is described, and the logged equipment number is counted in a data bit mode; the resource load of the data warehouse is reduced, and the data quantity of synchronization is greatly reduced by the data bits; through a bit mode, the logic of system realization is simplified, and the method is mainly used for simplifying and removing the repeatedly logged equipment data; the screening mode of the equipment is changed, the equipment is screened through bit operation, and the speed is higher.
Further, when detecting that the device is powered on and activated, before obtaining the IMEI number of the device, the method includes:
establishing an IMEI bit definition table TBL _ A of a data table, wherein the data table comprises a field self-increment ID number, an IMEI number, a bit mask code, a channel number and an equipment type;
detects that IMEI _ a device is powered on and activated, does the lookup table TBL _ a already have IMEI _ a?
If the record of the IMEI _ A of the equipment already exists, acquiring the IMEI number of the equipment;
if the record of the IMEI _ A of the equipment does not exist, writing data into an IMEI number, a channel number and an equipment type; obtaining the recorded self-increment ID number, ID _ A, after the writing is finished; calculating a bit mask code meter of the IMEI _ A data record; and updating the bit mask code of the IMEI _ A of the equipment.
Specifically, the processing flow of converting the imei number of 15 bits into bit integer data bits is as follows: establishing an IMEI bit definition table TBL _ A of a data table, wherein the data table comprises a field self-increment ID number, an IMEI number, a bit mask code, a channel number and an equipment type; equipment activation of IMEI _ a, if the lookup table TBL _ a already exists IMEI _ a?
If the record already exists, the process ends.
And if the record of the IMEI _ A of the equipment does not exist, writing the data into the IMEI number, the channel number and the equipment type. Obtaining the recorded self-increment ID number, ID _ A, after the writing is finished; calculating a bit mask code of the IMEI _ A data record, wherein the bit mask code is a digit 1 left movement (ID _ A-1); updating a bit mask code of the IMEI _ A; and (6) ending.
Further, when a login instruction is detected, acquiring a login event number, including:
detecting that equipment is started to log in and is connected to the network, and acquiring login data of the equipment, wherein the login data comprises an IMEI (international mobile equipment identity) and an event number E _ ID (identity);
identifying an IMEI number, and writing an event flow water meter of an equipment login event;
querying the IMEI bit definition table to determine if the IMEI exists?
If the IMEI does not exist, the acquisition of the login event number fails;
if the IMEI exists, acquiring a bit mask code MARK of the IMEI, and searching bit data at the current statistical time of the current day; and acquiring data.
In specific implementation, the equipment is started to log in, the equipment is networked, the equipment logs in an event to the server, and the data comprises an IMEI and an event number E _ ID.
The server receives the equipment login event E _ ID and identifies the IMEI number.
The server writes into the event stream meter of the device log-in event.
The server queries the IMEI bit definition table for the presence of the equipment IMEI?
If the IMEI does not exist, ending;
if the IMEI exists, acquiring a bit mask code MARK of the IMEI; searching bit data at the current statistical moment; if no data is present, data is initialized to 0, t is the current time point, one point every 2 minutes. Setting data.mask ═ data.mask | MARK; and (3) calculating the number of the equipment logged in the current data.mask by only calculating the number of 1-bit values.
And setting a code table to express the relation between the value and 1. For example, the number of values and 1 is as follows: number of 1 bits, 00, 11; 21; 32, a first step of removing the first layer; 41; 52; 62, a first step of mixing; 73; 81; 92; a 2; b 3; c 2; d 3; e 3; f 4.
Circularly processing each 4-bit data of the data.mask, finding the quantity a1 through the comparison value of the code table, and obtaining a2, a3.. aN in the same way;
the device number is a1+ a2+ a3+. + aN, calculation is accelerated through a code table, codes are readable, and expansibility is good. Supplementary explanation, further optimized mode: 1. and (3) increasing a code table, and 2. dividing the data into independent small blocks of data, and performing synchronous operation and final accumulation.
Further, when the login instruction is detected and the login event number is obtained, the method further comprises the following steps:
and if the synchronous request of the data warehouse is detected, acquiring the request time, searching the statistical data according to the request time and returning.
In specific implementation, the data warehouse initiates a synchronization request to request the parameter time terminal, t _ begin, and t _ end. And event statistics service, which is used for searching the statistical data, completed within the time t of the request parameter. The event statistic service returns the statistic data. Note that data is bit data, each bit identifying an IMEI.
Further, through to logging in the event number, carry out statistics to the equipment data of car networking, include:
sending a statistical request, wherein request parameters comprise channel id;
and calculating a bit mask of the channel, and aggregating the field bit mask through a bit definition table to obtain the hold _ mask.
Extracting statistical data of each minute, performing AND operation with hold _ mask, and acquiring statistical data hdata of a specified channel and the current minute;
obtaining the number of equipment logged in at the current minute by calculating the digit of 1 in the hdata;
generating registered device statistical data dataBeforen before N minutes by calculating the hdata of the previous N minutes and carrying out OR operation on the results;
obtaining the number of newly-added login equipment in the Nth minute by using a bit operation formula hdata and (not dataBeforen);
and circularly calculating each minute moment respectively to generate total equipment data of login statistics.
In specific implementation, Web statistics-request sending is carried out, and parameters comprise channel id.
Calculating a BIT mask code of a channel hold, and acquiring a hold _ mask BY aggregating a field mark BIT mask code through a BIT definition table imei _ bitmap, wherein the specific SQL writing method comprises the steps of selecting BIT _ OR (mark) FROM imei _ bitmap _01WHERE hold which is < hold _ id > GROUP BY hold, and acquiring hold _ mask _ 01; similarly, hold _ mask _02 and hold _ mask _03 can be obtained. Finally, hold _ mask _01+ hold _ mask _02+ hold _ mask _03+ -. + hold _ mask _ n;
extracting statistical data of each minute, and performing AND operation on the statistical data of each minute and the hold _ mask to obtain statistical data hdata of a specified channel and the current minute;
and calculating the digit of 1 in the hdata to obtain the number of devices logged in at the current minute.
The device statistical data databefore N minutes can be obtained by calculating hdata N minutes before and performing or operation on the result.
And obtaining the number of newly-added registered equipment in the Nth minute by using a bit operation formula hdata and (not dataBeforen).
In the same way, the data details of the login statistics can be obtained by calculating each minute time respectively in a loop.
The embodiment of the invention provides a method for counting equipment data of the Internet of vehicles, which can convert a 15-bit IMEI number into a bit integer data bit which is unique, so that efficient searching and screening operations can be realized through the bit.
After the IMEI number is simplified, the equipment is identified in a bit marking mode, the core real-time statistical service can be separately stripped, the emergency statistics and non-emergency logs are distinguished, high-efficiency data stream synchronization/storage is achieved, and synchronization to a system outside a data warehouse is facilitated. In addition, the synchronization of the binlog of the database is not needed, and the cost of the binlog error is reduced.
Channel shielding codes, equipment type shielding codes and the like can be calculated through the bit shielding codes of the equipment, so that the statistical screening method with high operation efficiency and low resource load is provided.
The writing complexity of the business logic is reduced, the repeated errors of the data are naturally solved by using bit operation, and the complexity of the logic code is reduced.
It should be noted that, a certain order does not necessarily exist between the above steps, and those skilled in the art can understand, according to the description of the embodiments of the present invention, that in different embodiments, the above steps may have different execution orders, that is, may be executed in parallel, may also be executed interchangeably, and the like.
In the foregoing, a method for performing statistics on device data of a network of vehicles in an embodiment of the present invention is described, and a system for performing statistics on device data of a network of vehicles in an embodiment of the present invention is described below, please refer to fig. 2, fig. 2 is a schematic hardware structure diagram of another embodiment of a system for performing statistics on device data of a network of vehicles in an embodiment of the present invention, and as shown in fig. 2, the system 10 includes: a memory 101, a processor 102 and a computer program stored on the memory and executable on the processor, the computer program realizing the following steps when executed by the processor 101:
when detecting that the equipment is started and activated, acquiring an IMEI number of the equipment;
converting the IMEI number of the equipment into a shaping number, and marking the shaping number as one byte;
when a login instruction is detected, acquiring a login event number;
and counting the equipment data of the Internet of vehicles by the login event number.
The specific implementation steps are the same as those of the method embodiments, and are not described herein again.
Optionally, the computer program when executed by the processor 101 further implements the steps of:
establishing an IMEI bit definition table TBL _ A of a data table, wherein the data table comprises a field self-increment ID number, an IMEI number, a bit mask code, a channel number and an equipment type;
detects that IMEI _ a device is powered on and activated, does the lookup table TBL _ a already have IMEI _ a?
If the record of the IMEI _ A of the equipment already exists, acquiring the IMEI number of the equipment;
if the record of the IMEI _ A of the equipment does not exist, writing data into an IMEI number, a channel number and an equipment type; obtaining the recorded self-increment ID number, ID _ A, after the writing is finished; calculating a bit mask code meter of the IMEI _ A data record; and updating the bit mask code of the IMEI _ A of the equipment.
The specific implementation steps are the same as those of the method embodiments, and are not described herein again.
Optionally, the computer program when executed by the processor 101 further implements the steps of:
detecting that equipment is started to log in and is connected to the network, and acquiring login data of the equipment, wherein the login data comprises an IMEI (international mobile equipment identity) and an event number E _ ID (identity);
identifying an IMEI number, and writing an event flow water meter of an equipment login event;
querying the IMEI bit definition table to determine if the IMEI exists?
If the IMEI does not exist, the acquisition of the login event number fails;
if the IMEI exists, acquiring a bit mask code MARK of the IMEI, and searching bit data at the current statistical time of the current day; and acquiring data.
The specific implementation steps are the same as those of the method embodiments, and are not described herein again.
Optionally, the computer program when executed by the processor 101 further implements the steps of:
and if the synchronous request of the data warehouse is detected, acquiring the request time, searching the statistical data according to the request time and returning.
The specific implementation steps are the same as those of the method embodiments, and are not described herein again.
Optionally, the computer program when executed by the processor 101 further implements the steps of:
through to logging on the event number, make statistics of the equipment data of car networking, include:
sending a statistical request, wherein request parameters comprise channel id;
and calculating a bit mask of the channel, and aggregating the field bit mask through a bit definition table to obtain the hold _ mask.
Extracting statistical data of each minute, performing AND operation with hold _ mask, and acquiring statistical data hdata of a specified channel and the current minute;
obtaining the number of equipment logged in at the current minute by calculating the digit of 1 in the hdata;
generating registered device statistical data dataBeforen before N minutes by calculating the hdata of the previous N minutes and carrying out OR operation on the results;
obtaining the number of newly-added login equipment in the Nth minute by using a bit operation formula hdata and (not dataBeforen);
and circularly calculating each minute moment respectively to generate total equipment data of login statistics.
The specific implementation steps are the same as those of the method embodiments, and are not described herein again.
Embodiments of the present invention provide a non-transitory computer-readable storage medium storing computer-executable instructions for execution by one or more processors, e.g., to perform method steps S100-S400 of fig. 1 described above.
By way of example, non-volatile storage media can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), electrically erasable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM), which acts as external cache memory. By way of illustration and not limitation, RAM is available in many forms such as Synchronous RAM (SRAM), dynamic RAM, (DRAM), Synchronous DRAM (SDRAM), double data rate SDRAM (DDR SDRAM), Enhanced SDRAM (ESDRAM), Synchlink DRAM (SLDRAM), and Direct Rambus RAM (DRRAM). The disclosed memory components or memory of the operating environment described in embodiments of the invention are intended to comprise one or more of these and/or any other suitable types of memory.
The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for counting device data of a vehicle networking system is characterized by comprising the following steps:
when detecting that the equipment is started and activated, acquiring an IMEI number of the equipment;
converting the IMEI number of the equipment into a shaping number, and marking the shaping number as one byte;
when a login instruction is detected, acquiring a login event number;
and counting the equipment data of the Internet of vehicles by the login event number.
2. The method for counting the data of the equipments in the internet of vehicles according to claim 1, wherein the step of obtaining the IMEI number of the equipment when the equipment is detected to be activated comprises:
establishing an IMEI bit definition table TBL _ A of a data table, wherein the data table comprises a field self-increment ID number, an IMEI number, a bit mask code, a channel number and an equipment type;
detects that IMEI _ a device is powered on and activated, does the lookup table TBL _ a already have IMEI _ a?
If the record of the IMEI _ A of the equipment already exists, acquiring the IMEI number of the equipment;
if the record of the IMEI _ A of the equipment does not exist, writing data into an IMEI number, a channel number and an equipment type; obtaining the recorded self-increment ID number, ID _ A, after the writing is finished; calculating a bit mask code meter of the IMEI _ A data record; and updating the bit mask code of the IMEI _ A of the equipment.
3. The method for counting device data of the internet of vehicles according to claim 2, wherein the obtaining the login event number when the login instruction is detected comprises:
detecting that equipment is started to log in and is connected to the network, and acquiring login data of the equipment, wherein the login data comprises an IMEI (international mobile equipment identity) and an event number E _ ID (identity);
identifying an IMEI number, and writing an event flow water meter of an equipment login event;
querying the IMEI bit definition table to determine if the IMEI exists?
If the IMEI does not exist, the acquisition of the login event number fails;
if the IMEI exists, acquiring a bit mask code MARK of the IMEI, and searching bit data at the current statistical time of the current day; and acquiring data.
4. The method for counting the device data of the internet of vehicles according to claim 3, wherein after the login instruction is detected and the login event number is obtained, the method further comprises:
and if the synchronous request of the data warehouse is detected, acquiring the request time, searching the statistical data according to the request time and returning.
5. The method for counting the device data of the internet of vehicles according to claim 4, wherein the counting the device data of the internet of vehicles by the login event number comprises:
sending a statistical request, wherein request parameters comprise channel id;
and calculating a bit mask of the channel, and aggregating the field bit mask through a bit definition table to obtain the hold _ mask.
Extracting statistical data of each minute, performing AND operation with hold _ mask, and acquiring statistical data hdata of a specified channel and the current minute;
obtaining the number of equipment logged in at the current minute by calculating the digit of 1 in the hdata;
generating registered device statistical data dataBeforen before N minutes by calculating the hdata of the previous N minutes and carrying out OR operation on the results;
obtaining the number of newly-added login equipment in the Nth minute by using a bit operation formula hdata and (not dataBeforen);
and circularly calculating each minute moment respectively to generate total equipment data of login statistics.
6. A system for performing statistics on device data of a network of vehicles, the system comprising: a memory, a processor and a computer program stored on the memory and executable on the processor, the computer program when executed by the processor implementing the steps of:
when detecting that the equipment is started and activated, acquiring an IMEI number of the equipment;
converting the IMEI number of the equipment into a shaping number, and marking the shaping number as one byte;
when a login instruction is detected, acquiring a login event number;
and counting the equipment data of the Internet of vehicles by the login event number.
7. The system for conducting statistics on device data of the internet of vehicles of claim 6, wherein the computer program when executed by the processor further implements the steps of:
establishing an IMEI bit definition table TBL _ A of a data table, wherein the data table comprises a field self-increment ID number, an IMEI number, a bit mask code, a channel number and an equipment type;
detects that IMEI _ a device is powered on and activated, does the lookup table TBL _ a already have IMEI _ a?
If the record of the IMEI _ A of the equipment already exists, acquiring the IMEI number of the equipment;
if the record of the IMEI _ A of the equipment does not exist, writing data into an IMEI number, a channel number and an equipment type; obtaining the recorded self-increment ID number, ID _ A, after the writing is finished; calculating a bit mask code meter of the IMEI _ A data record; and updating the bit mask code of the IMEI _ A of the equipment.
8. The system for conducting statistics on device data of the internet of vehicles of claim 7, wherein the computer program when executed by the processor further performs the steps of:
detecting that equipment is started to log in and is connected to the network, and acquiring login data of the equipment, wherein the login data comprises an IMEI (international mobile equipment identity) and an event number E _ ID (identity);
identifying an IMEI number, and writing an event flow water meter of an equipment login event;
querying the IMEI bit definition table to determine if the IMEI exists?
If the IMEI does not exist, the acquisition of the login event number fails;
if the IMEI exists, acquiring a bit mask code MARK of the IMEI, and searching bit data at the current statistical time of the current day; and acquiring data.
9. The system for conducting statistics on device data of the internet of vehicles of claim 8, wherein the computer program when executed by the processor further performs the steps of:
and if the synchronous request of the data warehouse is detected, acquiring the request time, searching the statistical data according to the request time and returning.
10. A non-transitory computer-readable storage medium storing computer-executable instructions that, when executed by one or more processors, cause the one or more processors to perform the method of accounting for device data of a network of vehicles of any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110279978.6A CN113032470A (en) | 2021-03-16 | 2021-03-16 | Method and system for counting equipment data of Internet of vehicles |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110279978.6A CN113032470A (en) | 2021-03-16 | 2021-03-16 | Method and system for counting equipment data of Internet of vehicles |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113032470A true CN113032470A (en) | 2021-06-25 |
Family
ID=76470727
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110279978.6A Pending CN113032470A (en) | 2021-03-16 | 2021-03-16 | Method and system for counting equipment data of Internet of vehicles |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113032470A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1291024A (en) * | 1999-09-06 | 2001-04-11 | 株式会社Ntt杜可莫 | Control method, movable station and mobile communication system for searching near district |
| CN1658702A (en) * | 2005-03-25 | 2005-08-24 | 北京北方烽火科技有限公司 | Quickly conversion algorithm of user key in GMLC |
| CN102077497A (en) * | 2008-04-25 | 2011-05-25 | 诺基亚公司 | System and methods for generating masking sequences |
| CN102236657A (en) * | 2010-04-28 | 2011-11-09 | 阿里巴巴集团控股有限公司 | Method and server for processing reported data |
| CN105516149A (en) * | 2015-12-14 | 2016-04-20 | 苏州天平先进数字科技有限公司 | Logging-in system and method based on IMEI (International Mobile Equipment Identity) number |
| CN105630972A (en) * | 2015-12-24 | 2016-06-01 | 网易（杭州）网络有限公司 | Data processing method and device |
| CN108762235A (en) * | 2018-06-12 | 2018-11-06 | 重庆穗通汽车工业发展有限公司 | Vehicle analyzes adjustment method, vehicle analysis debugging system and electric vehicle |
-
2021
- 2021-03-16 CN CN202110279978.6A patent/CN113032470A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1291024A (en) * | 1999-09-06 | 2001-04-11 | 株式会社Ntt杜可莫 | Control method, movable station and mobile communication system for searching near district |
| CN1658702A (en) * | 2005-03-25 | 2005-08-24 | 北京北方烽火科技有限公司 | Quickly conversion algorithm of user key in GMLC |
| CN102077497A (en) * | 2008-04-25 | 2011-05-25 | 诺基亚公司 | System and methods for generating masking sequences |
| CN102236657A (en) * | 2010-04-28 | 2011-11-09 | 阿里巴巴集团控股有限公司 | Method and server for processing reported data |
| CN105516149A (en) * | 2015-12-14 | 2016-04-20 | 苏州天平先进数字科技有限公司 | Logging-in system and method based on IMEI (International Mobile Equipment Identity) number |
| CN105630972A (en) * | 2015-12-24 | 2016-06-01 | 网易（杭州）网络有限公司 | Data processing method and device |
| CN108762235A (en) * | 2018-06-12 | 2018-11-06 | 重庆穗通汽车工业发展有限公司 | Vehicle analyzes adjustment method, vehicle analysis debugging system and electric vehicle |
Non-Patent Citations (2)
| Title |
|---|
| CHANG-HEON LEE 等: "on the study of noise allocation for speech signal in low bit-rate audio coding", 《IEEE SIGNAL PROCESSING LETTERS》, vol. 16, no. 10, pages 849 - 852, XP011269809, DOI: 10.1109/LSP.2009.2025982 * |
| 王怀光 等: "基于动态LZW与算术编码的缓变信号无损压缩", 《计算机应用研究》, vol. 32, no. 9, pages 5 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11301419B2 (en) | Data retention handling for data object stores | |
| CN107220142B (en) | Method and device for executing data recovery operation | |
| US11042427B2 (en) | Automated consolidation of API specifications | |
| US11429566B2 (en) | Approach for a controllable trade-off between cost and availability of indexed data in a cloud log aggregation solution such as splunk or sumo | |
| CN105512283A (en) | Data quality management and control method and device | |
| CN110018996B (en) | Snapshot rollback method and related device of distributed storage system | |
| CN110535928B (en) | Event pushing method for JAVA intelligent contract of block chain | |
| CN113946583A (en) | Primary key generation method and device | |
| CN113656503A (en) | Data synchronization method, device and system and computer readable storage medium | |
| CN110647423B (en) | Method, device and readable medium for creating storage volume mirror image based on application | |
| CN110019347B (en) | Data processing method and device of block chain and terminal equipment | |
| CN113032470A (en) | Method and system for counting equipment data of Internet of vehicles | |
| CN110188160B (en) | Data storage method and data reading method | |
| CN107168866B (en) | Parameter analysis method and device for configuration file | |
| CN112199344A (en) | Log classification method and device | |
| US20220350576A1 (en) | Compression Of Firmware Updates | |
| CN113436699A (en) | Method, system, electronic device and storage medium for generating new corona nucleic acid detection report | |
| CN113656474A (en) | Service data access method and device, electronic equipment and storage medium | |
| CN111538651A (en) | Interface testing method, device, server and storage medium | |
| CN111708795A (en) | Object identification generation method, object identification updating device, computer equipment and medium | |
| CN111580884B (en) | Configuration updating method, device, server and electronic equipment | |
| CN113722351B (en) | Parameter restoration method and device in Oracle database access flow | |
| CN111459411B (en) | Data migration method, device, equipment and storage medium | |
| CN112615869B (en) | Audio data processing method, device, equipment and storage medium | |
| CN117708175A (en) | File export method and device |
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 |