WO2021073260A1 - Object management method and apparatus, computer device, and storage medium - Google Patents

Abstract

An object management method and apparatus, a computer device, and a storage medium. When the number of objects to be outputted/inputted/deleted within a time period (t1, t2) needs to be queried, it is only necessary to query a second database for an accumulative change record corresponding to a sampling time [t1] that is before t1 and closest to t1 and an accumulative change record corresponding to a sampling time [t2] that is before t2 and closest to t2, to query a first database for change records between two intervals (t1, [t1]) and (t2, [t2]), and then to perform small amount of calculation, so as to obtain the number of objects to be queried. In this way, no matter how large the change record is, the query result can be obtained merely by performing an accurate query in the second database twice, performing an interval query in the first database twice, and then performing a small amount of computation. In the whole query process, there is no need to analyze all the data, thereby having small amount of computation and small memory consumption, and greatly shortening the query time.

Description

Object management method, device, computer equipment and storage medium

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on October 17, 2019, the application number is 201910986607.4, and the invention title is "object management methods, devices, computer equipment and storage media", the entire contents of which are incorporated by reference In this application.

Technical field

This application relates to the field of data processing technology, in particular to an object management method, device, computer equipment and storage medium.

Background technique

The video image information database is the core part of video analysis, and is responsible for providing data aggregation access, data processing, data resource storage, data services, data cascading, data opening capabilities, and video library software applications.

Video image information database (hereinafter referred to as the video library) The objects managed by the video library include at least but not limited to video clip objects, image objects, file objects, human objects, face objects, motor vehicle objects, non-motor vehicle objects, object objects, and scenes There are 11 categories of objects, video case event objects, and video image tag objects. When the video library manages all objects, it includes operations such as warehousing (the process of uploading image data from the collection device/collection platform to the video library), out of the library (the process of uploading the video library to the external system), deletion, and modification.

However, the prior art has the problem that it takes a long time to query the object statistical result from the view library.

Summary of the invention

Based on this, it is necessary to provide an object management method, device, computer equipment, and storage medium in response to the above-mentioned technical problem of time-consuming when querying the object statistical results from the visual library.

In the first aspect, an embodiment of the present application provides an object management method, which includes:

Receive a query request of the object; the query request means a request to query at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried, and the time period to be queried includes the start time and the end time;

Acquire in the first database the first change quantity corresponding to the first change moment between the first sampling time and the end time, and the second change quantity corresponding to the second change time between the second sampling time and the start time, Obtain the first cumulative change quantity between the first sampling time and the end time according to the first change quantity, and obtain the second cumulative change quantity between the second sampling time and the start time according to the second change quantity; the first database includes objects The change record of the object, the change record of the object includes the change time when the number of objects changes and the corresponding change amount; the first sampling time is the sampling time before the end time and the closest interval to the end time, and the second sampling time is at the start time The sampling time before and closest to the end time;

Obtain the third cumulative change quantity from the initial time of the system to the first sampling time in the second database, and obtain the fourth cumulative change quantity from the initial time of the system to the second sampling time; the second database includes the cumulative change records of the object, and the cumulative change The record includes the cumulative change number of the object from the initial time of the system to each sampling time;

According to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity, at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried is obtained.

In one of the embodiments, if the duration of the time period to be queried is less than the first preset duration threshold, the number of changes corresponding to the change time from the start time to the end time is obtained from the first database, and the cumulative change is determined according to the number of changes At least one of quantity, total change quantity, and total quantity.

In one of the embodiments, the cumulative change quantity includes one of the cumulative storage quantity, the cumulative storage quantity, and the cumulative deletion quantity; the change record and the cumulative change record include the change type, and the change type includes at least one of storage, delivery, and deletion. One kind.

In one of the embodiments, the total number of changes in the object during the time period to be queried represents the cumulative number of objects in the inventory during the time period to be queried minus the cumulative number of outgoing objects; or, the total number of changes in the object during the time period to be queried represents Query the cumulative inbound quantity of objects within the query period minus the cumulative outbound quantity and the cumulative deleted quantity;

The total number of objects in the time period to be queried represents at least one of the number of objects at the initial time of the system plus the total number of changes in the objects in the time period to be queried.

In one of the embodiments, the method further includes:

Obtain change information of the object; the change information includes at least one of inbound information, outbound information, and deletion information;

The first database and the second database are updated according to the change information.

In one of the embodiments, the above-mentioned updating the first database according to the change information includes:

When the preset condition is met, the change record corresponding to the change information is stored in the first database; the preset condition includes that the storage time since the last change record reaches the second preset duration threshold, or the preset condition includes the first change information The number reaches the preset number threshold, and the first change information is change information corresponding to the change record that is not stored in the first database.

In one of the embodiments, the above-mentioned updating the second database according to the operation change information includes:

Acquire the fifth cumulative change quantity from the initial time of the system to the third sampling time from the second database, where the third sampling time is the previous sampling time of the current sampling time;

Obtain the third change quantity corresponding to the third change time between the third sampling time and the current sampling time from the first database, and obtain the sixth cumulative change quantity according to the third change quantity;

According to the fifth cumulative change quantity and the sixth cumulative change quantity, the cumulative change quantity from the initial time of the system to the current sampling time is obtained, and the cumulative change record containing the cumulative change quantity from the initial time of the system to the current sampling time is stored in the second database.

In one of the embodiments, the above-mentioned change record and cumulative change record also include the object's generating device ID and the object category.

In one of the embodiments, the above-mentioned cumulative number of changes, total number of changes, and total number include the cumulative number of changes, total number of changes, and total number of objects in the specific ID generating device; and/or, the number of cumulative changes, total number of changes, The total quantity includes the cumulative change quantity, total change quantity, and total quantity of objects of a specific category.

In a second aspect, an embodiment of the present application provides an object management device, the device includes:

The receiving module is used to receive the query request of the object; the query request indicates a request to query at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried, and the time period to be queried includes the start time and the end time;

The first acquisition module is configured to acquire, in the first database, the first change quantity corresponding to the first change time between the first sampling time and the end time, and the second change time between the second sampling time and the start time The corresponding second change quantity, the first cumulative change quantity between the first sampling time and the end time is obtained according to the first change quantity, and the second cumulative change quantity between the second sampling time and the start time is obtained according to the second change quantity ; The first database includes the change record of the object, the change record of the object includes the change time at which the number of objects changes and the corresponding change number; the first sampling time is the sampling time before the end time and the closest interval to the end time, the first 2. The sampling time is the sampling time before the start time and closest to the end time;

The second acquiring module is used to acquire the third cumulative change quantity from the initial time of the system to the first sampling time and the fourth cumulative change quantity from the initial time of the system to the second sampling time in the second database; the second database includes objects The cumulative change record of the, the cumulative change record includes the cumulative change number of the object from the initial time of the system to each sampling time;

The determination module is used to obtain the cumulative change number, total change number, and total number of the object in the time period to be queried according to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity. At least one.

In a third aspect, an embodiment of the present application provides a computer device, including a memory and a processor, the memory stores a computer program, and the processor implements the steps of any one of the methods provided in the embodiments of the first aspect when the processor executes the computer program.

In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the steps of any one of the methods provided in the embodiments of the first aspect are implemented.

The object management method, device, computer equipment, and storage medium provided by the embodiments of the present application, when it is necessary to query the outbound/inbound/deleted quantity of objects in the time period (t1, t2), because the first database stores The change record of the object, the change record of the object includes the change time of the change in the number of objects and the corresponding change amount. The cumulative change record of the object is stored in the second database. The cumulative change record includes the object from the initial time of the system to each sampling time. For the cumulative change amount between time, you only need to query the cumulative change record corresponding to the sampling time [t1] before t1 and the closest to t1 and the cumulative change record corresponding to the sampling time [t2] before t2 and the closest to t2 in the second database, Query the change records between the two communities (t1,[t1]) and (t2,[t2]) in the first database, and then calculate the number of objects to be queried through a small amount of calculation, so that no matter how large the change records are , You only need to perform two precise queries in the second database, two inter-cell queries in the first database, and then a small amount of calculations to obtain the query results. The entire query process does not need to analyze all the data, with less calculations and less memory. It consumes less and greatly shortens the query time.

The above description is only an overview of the technical solution of the present invention. In order to understand the technical means of the present invention more clearly, it can be implemented in accordance with the content of the specification, and in order to make the above and other objectives, features and advantages of the present invention more obvious and understandable. In the following, specific embodiments of the present invention will be cited.

Description of the drawings

In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the drawings in the following description These are some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative work.

FIG. 1 is an application environment diagram of an object management method provided by an embodiment;

FIG. 2 is a schematic flowchart of an object management method provided by an embodiment;

FIG. 3 is a schematic flowchart of an object management method provided by an embodiment;

FIG. 4 is a schematic flowchart of an object management method provided by an embodiment;

FIG. 5 is a structural block diagram of an object management device provided by an embodiment;

FIG. 6 is a structural block diagram of an object management apparatus provided by an embodiment;

FIG. 7 is a structural block diagram of an object management apparatus provided by an embodiment;

Fig. 8 schematically shows a block diagram of a computing processing device for executing the method according to the present invention;

Fig. 9 schematically shows a storage unit for holding or carrying program codes for implementing the method according to the present invention.

Specific embodiment

In order to make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments These are a part of the embodiments of the present invention, but not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

In order to make the purpose, technical solutions, and advantages of this application clearer, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not used to limit the present application.

The object management method provided by the present application can be applied to an application environment as shown in FIG. 1, in which a processor of a computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used to store the data of the object management method. The network interface of the computer device is used to communicate with other external devices through a network connection. The computer program is executed by the processor to realize an object management method.

In practical applications, counting objects in the time domain is a frequently faced problem. Generally, there are four types of object operations, including addition, deletion, modification, and checking. When the object increases, the statistical value of the object increases, when the object is deleted, the statistical value of the object decreases, and when the object is modified, the statistical value of the object remains unchanged.

For example, the objects managed by the public security video image information database (referred to as the video library) include at least video clip objects, image objects, file objects, personnel objects, face objects, motor vehicle objects, non-motor vehicle objects, object objects, scene objects, and videos. 11 categories such as case event objects and video image tag objects. Among them, these objects are uploaded by the collection equipment/collection platform (called warehousing) to the visual library, and the uploaded category, warehousing mark, number, time stamp and other information are recorded by the log system; in addition, these objects can also be used by other objects. System subscription, upload from the visual library to the external (called making library) system, at this time, the log system will also record the category, entry and exit tags, number, timestamp and other information of the objects out of the library. Moreover, the stored object can also have a life cycle, that is, it will be deleted when it expires. Assuming that each collection device is calculated based on 5000 records stored in the warehouse every day, 150,000 records in a month can be generated, and 1.8 million records in a year can be generated. At this time, it may be easy to query the data within a few days. If you query the total amount of storage in the past year, directly accumulating these records is quite resource-consuming, and the time consumed is uncontrollable. Therefore, the embodiments of the present application provide an object management method, device, computer equipment, and storage medium, which are intended to solve the technical problem of long time-consuming when querying object statistical results from the view library.

Hereinafter, the technical solution of the present application and how the technical solution of the present application solves the above-mentioned technical problems will be described in detail through the embodiments and the accompanying drawings. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. It should be noted that, in an object management method provided by this application, the execution subject of Figures 2 to 4 is a computer device, where the execution subject can also be an object management device, where the device can be implemented through software, hardware, or software and hardware. The combination is realized as part or all of the computer equipment.

In order to make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be described clearly and completely in conjunction with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of the present application, but not all of the embodiments.

In one embodiment, FIG. 2 provides an object management method. This embodiment relates to a computer device according to a query request to query the database for the cumulative number of changes, the total number of changes, and the total number of changes in the database during the time period to be queried. The specific process of at least one of, as shown in Figure 2, the method includes:

S101: Receive a query request of an object; the query request indicates a request to query at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried. The time period to be queried includes the start time and the end time.

In this embodiment, the object represents any object that needs to be managed, and the object here may be an object to be queried or an object to be updated. Among them, the query request means a request for querying the cumulative change quantity, total change quantity, or total quantity of an object. Optionally, the query request may include the change type, device ID and/or object category. The types of changes include outbound, inbound, or deleted. Correspondingly, the cumulative amount of change includes the accumulated inbound quantity, the accumulated outbound quantity, or the accumulated deleted quantity. The accumulated storage quantity represents the sum of the object storage quantity in a time period, the accumulated storage quantity represents the sum of the object storage quantity in a time period, and the cumulative deletion quantity represents the sum of the object deletion quantity in a time period. Optionally, the total number of changes represents the cumulative number of objects in the inventory during the time period to be queried minus the cumulative number of objects out of the library; when the object contains a life cycle, the expired objects will be deleted, and the total number of changes represents the time period to be queried The accumulated inbound quantity of the object minus the accumulated outbound quantity and the accumulated deleted quantity. Among them, the total number represents the total number at time T, that is, the number at the initial time of the system plus the total number of changes in the time period 0-T. It should be noted that when the query request is to query the total number of time periods to be queried, only the end time (time T) needs to be given, and the start time defaults to the initial time of the system.

Object categories include, but are not limited to, video clip objects, image objects, file objects, human objects, face objects, motor vehicle objects, non-motor vehicle objects, article objects, scene objects, video case event objects, video image tag objects, etc. A query request may be, for example, to query the number of face objects from the device with ID X1 between 14:00 on October 1st and 15:00 on October 2nd.

The way for the computer equipment to receive the query request can be to receive the request directly input by the user through the input device, it can also be to receive the request sent by other devices, or it can be to receive the voice request, etc. This embodiment does not limit the way of receiving the query request. . It should be noted that the object management method provided in this application is a method used in an information database, for example, a public security video image information database, hereinafter referred to as a video library system.

S102. Acquire, in the first database, the first change quantity corresponding to the first change time between the first sampling time and the end time, and the second change corresponding to the second change time between the second sampling time and the start time. Quantity, obtain the first cumulative change quantity between the first sampling time and the end time according to the first change quantity, obtain the second cumulative change quantity between the second sampling time and the start time according to the second change quantity; in the first database Including the change record of the object, the change record of the object includes the change time when the number of objects changes and the corresponding change quantity; the first sampling time is the sampling time before the end time and the closest interval to the end time, and the second sampling time is at The sampling time before the start time and closest to the end time.

Among them, the sampling time represents the preset time for calculating the cumulative change quantity, for example, it can be 23:59:59 every day, that is, the cumulative change quantity of the object is recorded once every day at 23:59:59, for example, the first At 23:59:59 of the day, the cumulative number of changes in the object from the initial time of the system to the sampling time of the first day is recorded. At 23:59:59 of the second day, the number of changes from the initial time of the system to the sampling time of the next day is recorded once. The accumulative number of changes in the object between the two, and so on. At 23:59:59 on the nth day, the cumulative number of changes in the object between the initial time of the system and the sampling time on the nth day is recorded.

The interval between the sampling moments can be fixed or non-fixed, which is not limited here. The sampling time at a fixed interval, for example, 23:59:59 every day, is used as the sampling time, and the non-fixed sampling time, for example, when the change record reaches a certain number, the cumulative change amount is calculated, and the time when the cumulative change number is calculated is the sampling time.

Among them, the first database and the following second database in this step are two databases established in the search server in advance, where the search server means a full-text search engine, such as elasticSearch. This embodiment does not limit the type of search server. As long as it is an engine that can quickly store, search and analyze massive amounts of data. Taking the index in elasticSearch as an example, two indexes statics and days can be created in elasticSearc, corresponding to two databases, the first database is statics, and the second database is days.

The first database includes the change record of the object, and the change record of the object includes the change time when the number of the object changes and the corresponding change amount. In one example, the change records in the first database are shown in Table 1.

Table 1

To continue the previous example, query the number of face objects from the device with ID X1 between 14:00 on October 1st and 15:00 on October 2nd. The sampling time is 23:59 every day. ：59 o’clock, start time is 14:00 on October 1st, end time is 15:00 pm on October 2nd, first sampling time is 23:59:59 on October 1st, second sampling time It is 23:59:59 on September 30. There is no change record between the first sampling time and the end time, and the second change time is 3:00 on October 1st and 13:00 on October 1st. When the device ID is X1, the object category is face, and the change type is warehousing, the change records corresponding to the second change moment are the following two, and the number of changes corresponding to the second change moment is 5 and 3, as shown in Table 2 below.

Table 2

Correspondingly, the first cumulative change quantity is 0, and the second cumulative change quantity is 8.

S103: Acquire the third cumulative change quantity from the initial time of the system to the first sampling time and the fourth cumulative change quantity from the initial time of the system to the second sampling time in the second database; the second database includes the cumulative change record of the object, The cumulative change record includes the cumulative change number of the object from the initial time of the system to each sampling time.

In one example, the cumulative change records in the second database are shown in Table 3.

table 3

To continue the previous example, when the query request is to query the number of face objects from the device with ID X1 between 14:00 on October 1st and 15:00 on October 2nd, the device ID Is X1, the object category is human face, the change type is storage, the third cumulative change quantity is 10, and the fourth cumulative change quantity is 2.

S104, according to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity, obtain at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried .

To continue the previous example, when the query request is to query the number of face objects from the device with ID X1 between 14:00 on October 1st and 15:00 on October 2nd, the device ID Is X1, the object category is face, and the change type is warehousing. It can be obtained by using the third cumulative change quantity + the first cumulative change quantity-the fourth cumulative change quantity-the second cumulative change quantity (10+0-2-8) The number of face objects from the device with ID X1 between 14:00 on October 1st and 15:00 on October 2 is zero.

For example, taking the cumulative storage quantity that needs to be queried as an example, when the computer device queries the cumulative storage quantity of objects in the time period to be queried according to the query request, it can directly query the end time of the time period to be queried from the second database The accumulated storage quantity recorded at the previous sampling time and the accumulated storage quantity recorded at the sampling time before the start time. The accumulated storage quantity from the sampling time point before the end time to the end time, and the sampling time point before the start time to the start time can be based on The change records in the first database are analyzed and calculated in real time. The whole process is equivalent to dividing the query time period (t1, t2) with the sampling time as the node as (0, [t1]), ([t1], t1), ( 0,[t2]),([t2],t2) four time periods, for the time period (0,[t1]),(0,[t2]) where the cumulative change number has been recorded in the second database, from The cumulative change quantity is directly obtained in the second database. For the time period ([t1],t1),([t2],t2) in the second database that the cumulative change quantity is not recorded, then according to the objects stored in the first database Calculate the cumulative change amount in real time for the change record, and finally make the total. In this way, in the query process, the cumulative change amount for most of the time periods does not need to be calculated in real time, only the precise search is performed from the second database, and a small amount of calculations are performed in real time in the first database for a small time period, which can realize fast calculation , Which makes the whole query process less memory consumption and shorter query time.

In the object management method provided in this embodiment, when it is necessary to query the number of outbound/inbound/deleted objects in the time period (t1, t2), since the change record of the object is stored in the first database, the change record of the object includes the object The number of changes at the time of change and the corresponding number of changes. The second database stores the cumulative change record of the object. The cumulative change record includes the cumulative change number of the object from the initial time of the system to each sampling time. It only needs to be in the second Query the database for the cumulative change record corresponding to the sampling time [t1] before t1 and the closest to t1 and the cumulative change record corresponding to the sampling time [t2] before t2 and the closest to t2, query in the first database (t1,[t1 ]) and (t2,[t2]), the change records between the two cells, and then through a small amount of calculation, the number of objects to be queried can be obtained. In this way, no matter how large the change records are, it only needs to be performed twice in the second database. Precise query, two inter-community queries in the first database, and then a small amount of calculations to get the query results. The entire query process does not need to analyze all the data, with less calculations and less memory consumption, which greatly shortens the query time.

In some scenarios, if the time period to be queried is very short, there is no need to query in two databases, and the calculation can be performed directly in the first database. In one embodiment, if the time period to be queried is less than the first predetermined time period. If the duration threshold is set, the change quantity corresponding to the change time from the start time to the end time is obtained from the first database, and at least one of the cumulative change quantity, the total change quantity, and the total quantity is determined according to the change quantity.

Specifically, the computer device compares the duration of the time period to be queried with the first preset duration threshold, and if the duration of the time period to be queried is less than the first preset duration threshold, the computer device obtains from the first database from the start time to the end The amount of change corresponding to the changing moment between moments in time is determined according to the amount of change, at least one of the cumulative amount of change, the total amount of change, and the total amount. Wherein, the first preset duration threshold is a preset value, for example, it may be 24 hours, 48 hours, etc., which is not limited in this embodiment. In this way, when the time period to be queried is short, real-time analysis and calculation directly through the first database will not consume too much computing resources, so there is no need to perform the step of obtaining data from the second database.

On the basis of the above embodiment, the embodiment of the present application also provides an object management method, which relates to the specific process of updating the first database and the second database by a computer device. As shown in FIG. 3, the method also include:

S201: Obtain change information of the object; the change information includes at least one of inbound information, outbound information, and deletion information.

In this embodiment, the computer device obtains the change information of the object, where the change information includes at least one of warehouse-in information, warehouse-out information, and deletion information. The manner in which the computer device obtains the change information may be determined by receiving the input information of the external device, which is not limited in this embodiment.

S202: Update the first database and the second database according to the change information.

Based on the change information obtained in step S201 above, the computer device performs different updates according to the change information, for example, updates the inbound record of the object according to the inbound information, adds the outbound record to the object based on the outbound information, and updates according to the deletion. The information deletes the object and updates the record.

In the object management method provided in this embodiment, the computer device updates the data in the first database and the second database according to the change information of the object, which can ensure the validity, accuracy and timeliness of the data in the first database and the second database Further, the accuracy of the query results in the first database and the second database is ensured.

The following describes the update process corresponding to different change information, and provides a process for updating the first database. In one embodiment, when a preset condition is met, the change record corresponding to the change information is stored in the first database. Database; the preset condition includes the storage time since the last change record reaches the second preset duration threshold, or the preset condition includes the quantity of the first change information reaches the preset quantity threshold, where the first change information corresponds to the change The information change records the change information that is not stored in the first database.

Specifically, when the computer device updates the change record in the first database, it is subject to the preset condition, that is, if the storage time from the last change record at the current time reaches the second preset duration threshold, the computer device will update the current time Record all the change information between the time when the last change record was stored; or, if the quantity of the first change information reaches the preset quantity threshold, where the first change information is that the change record corresponding to the change information has not been stored in the first A database of change information, the computer device stores the first change information in the first database. In this way, when the preset conditions are met, the immediacy of the data is guaranteed.

In another embodiment, as shown in FIG. 4, a process of updating the second database is provided, and the process includes:

S301: Obtain a fifth cumulative change quantity at a third sampling time from the second database, where the third sampling time is a sampling time before the current sampling time.

The computer device obtains the last accumulated change amount stored in the second database, and the sampling time corresponding to the last accumulated change amount stored in the second database is the third sampling time, that is, the third sampling time is the previous sampling time of the current sampling time .

S302: Acquire a third change quantity corresponding to a third change time between the third sampling time and the current sampling time from the first database, and obtain a sixth cumulative change quantity according to the third change quantity.

The computer device obtains the amount of change between the third sampling moment and the current sampling moment from the first database, that is, the third amount of change, and the computer analyzes and calculates the sixth cumulative amount of change according to the third amount of change. It can be understood that the sixth cumulative change quantity represents the change from the third sampling moment to the current sampling moment.

S303: Obtain the cumulative change quantity at the current sampling time according to the fifth cumulative change quantity and the sixth cumulative change quantity, and store the cumulative change record including the cumulative change quantity at the current sampling time in the second database.

In this step, the computer device determines the sum of the fifth cumulative change quantity and the sixth cumulative change quantity as the current cumulative change quantity, and stores the cumulative change record of the current sampling time cumulative change quantity in the second database.

To continue the previous example, the sampling time is 23:59:59 every day, and the current sampling time is 23:59:59 on October 2nd. When updating the second database, you need to get 23:59 on October 1st from the second database: The fifth cumulative change quantity of 59 is obtained from the first database from October 2 0:0:0 to October 2 23:59:59, and October 2 0 is obtained from the displayed change quantity: The sixth cumulative change quantity from 0:0 to October 2nd at 23:59:59, and then the cumulative change quantity from the initial time of the system to the current sampling time is obtained from the fifth cumulative change quantity and the sixth cumulative change quantity.

It should be noted that when the computer device updates the first database and the second database, the cumulative change quantity corresponding to each type is updated according to different change types. In this embodiment, by updating the data in the first database and the second database, the accuracy and timeliness of the data in the first database and the second data are ensured.

In one embodiment, the change record and the cumulative change record also include the object’s generating device ID and the object category; optionally, the cumulative change quantity, total change quantity, and total quantity include the cumulative change of the object in the generating device with a specific ID. Quantity, total change quantity, total quantity; and/or, cumulative change quantity, total change quantity, and total quantity include the cumulative change quantity, total change quantity, and total quantity of a specific type of object.

Wherein, the object's generating device ID represents the ID of the device that generated the object. For example, if it is a face object, the device that generated the image is the ID of the collection device that captured the image. In this way, the change record and the cumulative change record also include the object's generating device ID to facilitate the identification of the source of the object. The types of objects include human faces, people, and so on. Correspondingly, when querying the number of objects, you can query the cumulative number of changes, the total number of changes, and the total number of objects in the device that generates the specific ID. You can also query the cumulative number of changes, the total number of changes, and the total number of changes for a specific type of object. The total quantity can also be queried for the specific ID generating device, the cumulative change quantity, total change quantity, and total quantity of a specific type of object, which is not limited in this embodiment. Dividing objects according to specific IDs and specific types can adapt to different query needs of users.

In some scenarios, during the process of updating the data in the first database and the second database, if there are no operations such as leaving, warehousing, or deleting information in the visual library system on a certain day, then the sampling time of the day (for example, 23:59: 59) The cumulative change quantity is the same as the cumulative change quantity at the sampling time of the previous day. In this case, the cumulative change quantity in the second database may not be recorded, or the cumulative change quantity of the previous day can be directly used as the record. The embodiment does not limit this.

Based on all the above embodiments, this application provides a complete embodiment of the process of data storage, update, and query:

For the visual library system, suppose it manages 11 types of objects. The statistics of the 11 types of objects can be regarded as operations on a ^{vector in an R 11} space with 11 statistical dimensions. In practical applications, these The object always originates from a uniquely identified collection device/collection platform/external system (referred to by X below), so the vector is identified by the device ID, and written down when writing the log, indicating that the record belongs to device X . Set the search server as elasticSearch, the first database (hereinafter referred to as the first index in this embodiment) is statics, and the second database (hereinafter referred to as the second index in this embodiment) is days;

Take warehousing as an example, f(t) represents the warehousing number of equipment X at time t, the warehousing information of the equipment X at time t is stored in the first index statics, and the function f(t) is used to represent the number of warehousing , Then the function f(t) is a vector with multiple dimensions f(t)=[f ₁ (t), f ₂ (t),..., f _n (t)], for example, the first dimension f ₁ (t) represents the number of faces, and the second dimension f ₂ (t) represents the number of vehicles, etc. S(t) is used to represent the total amount of storage of equipment X from the initial state of the original image system (time 0) to time t, where time 0 is the moment when the view library is deployed and just started, which can be UTC (Uniform Universal Time) The start time (1970-1-100:00:00) of the time can also be the actual project deployment completion time, which is not limited in this embodiment. among them

Specifically, if the module that executes this method is set as the log module, the process of periodically generating original warehouse records and storing them in statics includes: whenever the device/platform uploads the above 11 types of objects to the visual library system, the log module is called in the log It is recorded in the module memory, and the log module records the instantaneous quantity f(t): collect instantaneous storage, storage, and deletion information, and write records to statics. Here "instantaneous" refers to a short period of time, such as 5s, 10s, 15s, etc., the log module will periodically (for example, 10 seconds or the number of records in the log memory reaches a certain threshold), and this instantaneous storage Information summary writes records to statics. If there are other objects, they also need to be written.

On the other hand, when an object is out of the library every day, or the object is deleted when it expires, the log module will also periodically write records to statics. The following table 4 shows the change records in the first database, which means that within 10s of 1561368429-1561368439, there are 5 faces of device X1 entering the library (here, the change time in a change record is recorded as the time in a short period of time. At the last point in time), there are 3 people leaving the library; within 10s of 1561368439-1561368449, device X1 deletes 1 face and X2 deletes 1 scene.

Table 4

Serial number	Device ID	Object type	Variation type	Moment of change	Number of changes
1	X1	human face	"Warehousing"	1561368439	5
2	X1	personnel	"Out of the library"	1561368439	3
3	X1	human face	"delete"	1561368449	1
4	X2	Scenes	"delete"	1561368449	1

Among them, the process of periodically analyzing the original inbound and outbound records to obtain the cumulative change records in the second database includes: the statistics module is responsible for recording the cumulative change number s(t): calculating the two sampling points t _i , t _i+1 , Cumulative warehousing quantity, cumulative warehousing quantity, or cumulative deletion quantity generated, taking the cumulative warehousing quantity as an example, as an increment

Wherein, _{the interval between ti} and ti ₊₁ may be every fixed time, for example, 23:59:59 every day, or it may be an irregular time.

For example, every day at 23:59:59, group all the original warehousing records from 00:00:00 to 23:59:59 that day by device ID, and then perform statistics on the 11 types of objects in each group, and get each change according to the type of change The cumulative number of changes for the type. For the data in Table 4 above, the processing results: X1 inbound = [0,0,0,0,5,0,0,0,0,0,0], the fifth dimension represents the number of faces, and X1 out Library=[0,0,0,3,0,0,0,0,0,0,0], the fourth dimension represents the number of personnel, X1 delete=[0,0,0,0,1,0 ,0,0,0,0,0], the fifth dimension represents the number of faces. X2 delete=[0,0,0,0,0,0,0,0,1,0,0], the 9th dimension represents the number of scenes. Each dimension of the vector represents the statistical value of the number of objects in a category.

Among them, the process of updating the accumulated value table days includes:

The statistics module is also responsible for writing the cumulative change amount S(t _{i ) at the end of t i} plus the increment S _inc into days, that is,

The result of is written into days, and for each device X, a cumulative change quantity of inbound, outbound, and deleted is written separately. Take warehousing as an example, the writing method is: query the cumulative warehousing quantity written last time by X (match the device ID and change type, take the record with the longest time), record it as S _old =S(t _i ), Add this record to the previously calculated cumulative storage quantity S _inc of X: S _new =S(t _i+1 )=S _old +S _inc , and write the addition result S _new to the accumulation of the second database Change record, _{the sampling time corresponding to S new} is 23:59:59 of the current day. Of course, if the device X does not have a record of inbound/outbound/deleted on that day, the cumulative change quantity of the previous day can be used as the cumulative amount of the day The number of changes, or the cumulative change records of the day are not stored in the second database.

Among them, the process of the quick query method includes: taking the cumulative storage quantity generated by the query device X in the time period [a, b] as an example. Cumulative warehousing quantity

_{(i) Query the cumulative storage quantity S [a]} and S _[b] at the time [a], [b] from the second database days respectively. For obtaining the cumulative storage quantity S [a] at time _[a] , the query condition is to match the device ID and the change type as "warehousing", and take the cumulative change quantity corresponding to the closest cumulative change record with the sampling time less than or equal to a ; The same is true for obtaining the cumulative change amount at time [b]. If there is no result, it means that since the initial time of the system, there has not been a storage record.

(ii) From the first database, query the number of warehouse receipts generated by the time period [[a],a] and [[b],b] of the device X in the cell, that is, match the device ID from statics and change the type to "inbound Query database" and time zone, summarize the query results, and get the cumulative change of the two time intervals [[a],a] and [[b],b]

with

Combining the above two parts (i) and (ii) results according to the formula

The operation can get the final result. It can be understood that step (ii) can be performed before step (i), and the order of steps (i) and (ii) is not limited.

Generally, when the span of [a,b] is more than 3 days, the above query method is used. Otherwise, if the time period of [a,b] is very short, query statics directly and accumulate the results. The same is true for the query of outbound and deleted information, so I won't repeat it here.

According to the completion management process provided by this embodiment, it can be seen that for querying the total amount of outbound/inbound/deleted generated by the specified device X in any time interval [a,b], no matter how large the number of records is, it only needs to be performed from days Accurate query of the historical cumulative change quantity, query the change quantity in a small time interval (within one day) from statics, and finally complete the accumulation, which greatly improves the query efficiency.

It should be understood that although the various steps in the flowcharts of FIGS. 2-4 are displayed in sequence as indicated by the arrows, these steps are not necessarily performed in sequence in the order indicated by the arrows. Unless there is a clear description in this article, there is no strict order for the execution of these steps, and these steps can be executed in other orders. Moreover, at least part of the steps in Figures 2-4 may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times. These sub-steps or stages The execution order of is not necessarily performed sequentially, but may be performed alternately or alternately with at least a part of other steps or sub-steps or stages of other steps.

In one embodiment, as shown in FIG. 5, an object management device is provided, which includes: a receiving module 10, a first acquiring module 11, a second acquiring module 12, and a determining module 13, wherein:

The receiving module 10 is used to receive the query request of the object; the query request means to request at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried. The time period to be queried includes the start time and the end time ；

The first acquisition module 11 is configured to acquire, in the first database, the first change quantity corresponding to the first change time between the first sampling time and the end time, and the second change between the second sampling time and the start time The second change quantity corresponding to the time, the first cumulative change quantity between the first sampling time and the end time is obtained according to the first change quantity, and the second cumulative change between the second sampling time and the start time is obtained according to the second change quantity Quantity; the first database includes the change record of the object, the change record of the object includes the change time when the number of the object changes and the corresponding change quantity; the first sampling time is the sampling time before the end time and the closest interval to the end time, The second sampling time is the sampling time before the start time and closest to the end time;

The second acquiring module 12 is configured to acquire the third cumulative change quantity from the initial time of the system to the first sampling time and the fourth cumulative change quantity from the initial time of the system to the second sampling time in the second database; the second database includes The cumulative change record of the object, which includes the cumulative change amount of the object from the initial time of the system to each sampling time;

The determination module 13 is used to obtain the cumulative change number, total change number, and total number of objects in the time period to be queried according to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity. At least one of.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

In one embodiment, if the duration of the time period to be queried is less than the first preset duration threshold, the change quantity corresponding to the change time from the start time to the end time is obtained from the first database, and the cumulative change quantity is determined according to the change quantity , At least one of the total number of changes and the total number.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

In one embodiment, the cumulative change quantity includes one of the cumulative warehousing quantity, the cumulative exit quantity, and the cumulative deletion quantity; the change record and the cumulative change record include a change type, and the change type includes at least one of warehousing, outgoing, and deletion. Kind.

The implementation principle and technical effect of an object management device provided by the foregoing embodiment are similar to those of the foregoing method embodiment, and will not be repeated here.

In one embodiment, the total number of changes of objects in the time period to be queried represents the cumulative number of objects in the inventory during the time period to be queried minus the cumulative number of outgoing objects; or, the total number of changes in the objects during the time period to be queried represents the number of objects to be queried The accumulated inbound quantity of the object within the time period minus the accumulated outbound quantity and the accumulated deleted quantity;

The total number of objects in the time period to be queried represents the number of objects at the initial time of the system plus the total number of changes in the objects in the time period to be queried.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

In an embodiment, as shown in FIG. 6, an object management apparatus is provided, the apparatus further includes: an acquisition module 14 and an update module 15, wherein,

The obtaining module 14 is used to obtain change information of the object; the change information includes at least one of inbound information, outbound information, and deletion information;

The update module 15 is used to update the first database and the second database according to the change information.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

In one embodiment, the above-mentioned update module 15 is used to store the change record corresponding to the change information in the first database when the preset condition is met; the preset condition includes the storage time since the last change record reaches the second preset duration The threshold value, or the preset condition includes that the quantity of the first change information reaches the preset quantity threshold value, and the first change information is change information corresponding to the change information that is not stored in the first database.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

In one embodiment, as shown in FIG. 7, an object management apparatus is provided, and the above-mentioned update module 15 includes: a first obtaining unit 151, a second obtaining unit 152, and a storage unit 153, wherein:

The first acquiring unit 151 is configured to acquire the fifth cumulative change quantity from the initial time of the system to the third sampling time from the second database, and the third sampling time is the previous sampling time of the current sampling time;

The second acquiring unit 152 is configured to acquire the third change quantity corresponding to the third change time between the third sampling time and the current sampling time from the first database, and obtain the sixth cumulative change quantity according to the third change quantity;

The storage unit 153 is configured to obtain the cumulative change quantity from the initial time of the system to the current sampling time according to the fifth cumulative change quantity and the sixth cumulative change quantity, and store the cumulative change record containing the cumulative change quantity from the system initial time to the current sampling time To the second database.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

In an embodiment, the above-mentioned change record and cumulative change record further include the object's generating device ID and the object category.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

In one embodiment, the above-mentioned cumulative change number, total change number, and total number include the cumulative change number, total change number, and total number of objects in the specific ID generating device; and/or, the cumulative change number, total change number, and total The quantity includes the cumulative change quantity, the total change quantity, and the total quantity of a specific category of objects.

The object management device provided in the foregoing embodiment has an implementation principle and technical effect similar to the foregoing method embodiment, and will not be repeated here.

For the specific limitation of the object management device, please refer to the above limitation of the object management method, which will not be repeated here. Each module in the above-mentioned object management device can be implemented in whole or in part by software, hardware, and a combination thereof. The above-mentioned modules may be embedded in the form of hardware or independent of the processor in the computer equipment, or may be stored in the memory of the computer equipment in the form of software, so that the processor can call and execute the operations corresponding to the above-mentioned modules.

In one embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. 1. The computer equipment includes a processor, a memory, a network interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide calculation and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external terminal through a network connection. The computer program is executed by the processor to realize an object management method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, or it can be a button, a trackball or a touchpad set on the housing of the computer equipment , It can also be an external keyboard, touchpad, or mouse.

Those skilled in the art can understand that the structure shown in FIG. 1 is only a block diagram of part of the structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied. The specific computer equipment It may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

In one embodiment, a computer device is provided, including a memory and a processor, and a computer program is stored in the memory, and the processor implements the following steps when the processor executes the computer program:

Receive a query request of the object; the query request means a request to query at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried, and the time period to be queried includes the start time and the end time;

Acquire in the first database the first change quantity corresponding to the first change moment between the first sampling time and the end time, and the second change quantity corresponding to the second change time between the second sampling time and the start time, Obtain the first cumulative change quantity between the first sampling time and the end time according to the first change quantity, and obtain the second cumulative change quantity between the second sampling time and the start time according to the second change quantity; the first database includes objects The change record of the object, the change record of the object includes the change time when the number of objects changes and the corresponding change amount; the first sampling time is the sampling time before the end time and the closest interval to the end time, and the second sampling time is at the start time The sampling time before and closest to the end time;

Obtain the third cumulative change quantity from the initial time of the system to the first sampling time in the second database, and obtain the fourth cumulative change quantity from the initial time of the system to the second sampling time; the second database includes the cumulative change records of the object, and the cumulative change The record includes the cumulative change number of the object from the initial time of the system to each sampling time;

According to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity, at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried is obtained.

The implementation principle and technical effect of a computer device provided by the foregoing embodiment are similar to those of the foregoing method embodiment, and will not be repeated here.

In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

Receive a query request of the object; the query request means a request to query at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried, and the time period to be queried includes the start time and the end time;

Acquire in the first database the first change quantity corresponding to the first change moment between the first sampling time and the end time, and the second change quantity corresponding to the second change time between the second sampling time and the start time, Obtain the first cumulative change quantity between the first sampling time and the end time according to the first change quantity, and obtain the second cumulative change quantity between the second sampling time and the start time according to the second change quantity; the first database includes objects The change record of the object, the change record of the object includes the change time when the number of objects changes and the corresponding change amount; the first sampling time is the sampling time before the end time and the closest interval to the end time, and the second sampling time is at the start time The sampling time before and closest to the end time;

Obtain the third cumulative change quantity from the initial time of the system to the first sampling time in the second database, and obtain the fourth cumulative change quantity from the initial time of the system to the second sampling time; the second database includes the cumulative change records of the object, and the cumulative change The record includes the cumulative change number of the object from the initial time of the system to each sampling time;

According to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity, at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried is obtained.

The foregoing embodiment provides a computer-readable storage medium, and its implementation principle and technical effect are similar to those of the foregoing method embodiment, and details are not described herein again.

The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in One place, or it can be distributed to multiple network units. Some or all of the modules can be selected according to actual needs to achieve the objectives of the solutions of the embodiments. Those of ordinary skill in the art can understand and implement without creative work.

The various component embodiments of the present invention may be implemented by hardware, or by software modules running on one or more processors, or by a combination of them. Those skilled in the art should understand that a microprocessor or a digital signal processor (DSP) may be used in practice to implement some or all of the functions of some or all of the components in the computing processing device according to the embodiments of the present invention. The present invention can also be implemented as a device or device program (for example, a computer program and a computer program product) for executing part or all of the methods described herein. Such a program for realizing the present invention may be stored on a computer-readable medium, or may have the form of one or more signals. Such a signal can be downloaded from an Internet website, or provided on a carrier signal, or provided in any other form.

For example, FIG. 8 shows a computing processing device that can implement the method according to the present invention. The computing processing device traditionally includes a processor 1010 and a computer program product in the form of a memory 1020 or a computer readable medium. The memory 1020 may be an electronic memory such as flash memory, EEPROM (Electrically Erasable Programmable Read Only Memory), EPROM, hard disk, or ROM. The memory 1020 has a storage space 1030 for executing the program code 1031 of any method step in the above method. For example, the storage space 1030 for program codes may include various program codes 1031 respectively used to implement various steps in the above method. These program codes can be read from or written into one or more computer program products. These computer program products include program code carriers such as hard disks, compact disks (CDs), memory cards, or floppy disks. Such a computer program product is usually a portable or fixed storage unit as described with reference to FIG. 9. The storage unit may have storage segments, storage spaces, etc. arranged similarly to the memory 1020 in the computing processing device of FIG. 8. The program code can be compressed in an appropriate form, for example. Generally, the storage unit includes computer-readable code 1031', that is, code that can be read by a processor such as 1010, which, when run by a computing processing device, causes the computing processing device to execute the method described above. The various steps.

In addition, in the description of the embodiments of the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, they may be fixed connections or detachable connections. , Or integrally connected; it can be a mechanical connection or an electrical connection; it can be directly connected or indirectly connected through an intermediate medium, and it can be the internal communication between two components. For those of ordinary skill in the art, the specific meanings of the above-mentioned terms in the present invention can be understood in specific situations.

In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc. The indicated orientation or positional relationship is based on the orientation or positional relationship shown in the drawings, and is only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the pointed device or element must have a specific orientation or a specific orientation. The structure and operation cannot therefore be understood as a limitation of the present invention. In addition, the terms "first", "second", and "third" are only used for descriptive purposes, and cannot be understood as indicating or implying relative importance.

Those skilled in the art can clearly understand that, for the convenience and conciseness of description, the specific working process of the system, device and unit described above can refer to the corresponding process in the foregoing method embodiment, which will not be repeated here.

In the several embodiments provided in this application, it should be understood that the disclosed system, device, and method may be implemented in other ways. The device embodiments described above are merely illustrative. For example, the division of the units is only a logical function division, and there may be other divisions in actual implementation. For example, multiple units or components may be combined or It can be integrated into another system, or some features can be ignored or not implemented. In addition, the displayed or discussed mutual coupling or direct coupling or communication connection may be through some communication interfaces, indirect coupling or communication connection of devices or units, and may be in electrical, mechanical or other forms.

The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the objectives of the solutions of the embodiments.

In addition, the functional units in the various embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units may be integrated into one unit.

If the function is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a non-volatile computer readable storage medium executable by a processor. Based on this understanding, the technical solution of the present invention essentially or the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including Several instructions are used to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage media include: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic disks or optical disks and other media that can store program codes. .

Finally, it should be noted that the above-mentioned embodiments are only specific implementations of the present invention, which are used to illustrate the technical solutions of the present invention, but not to limit them. The protection scope of the present invention is not limited thereto, although referring to the foregoing The embodiments describe the present invention in detail, and those skilled in the art should understand that any person skilled in the art can still modify the technical solutions described in the foregoing embodiments within the technical scope disclosed in the present invention. Or it can be easily conceived of changes, or equivalent replacements of some of the technical features; and these modifications, changes or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should be covered by the present invention Within the scope of protection. Therefore, the protection scope of the present invention should be subject to the protection scope of the claims.

The “one embodiment”, “an embodiment” or “one or more embodiments” referred to herein means that a specific feature, structure, or characteristic described in combination with the embodiment is included in at least one embodiment of the present invention. In addition, please note that the word examples "in one embodiment" here do not necessarily all refer to the same embodiment.

In the instructions provided here, a lot of specific details are explained. However, it can be understood that the embodiments of the present invention can be practiced without these specific details. In some instances, well-known methods, structures, and technologies are not shown in detail, so as not to obscure the understanding of this specification.

In the claims, any reference signs placed between parentheses should not be constructed as a limitation to the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "a" or "an" preceding an element does not exclude the presence of multiple such elements. The invention can be implemented by means of hardware comprising several different elements and by means of a suitably programmed computer. In the unit claims that list several devices, several of these devices may be embodied in the same hardware item. The use of the words first, second, and third, etc. do not indicate any order. These words can be interpreted as names.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: The technical solutions recorded in the foregoing embodiments are modified, or some of the technical features thereof are equivalently replaced; these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims (12)

1. An object management method, characterized in that the method includes:

   Receive a query request of an object; the query request represents a request to query at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object during the time period to be queried, and the time period to be queried includes a start time and an end time ；

   Acquire in the first database the first change quantity corresponding to the first change time between the first sampling time and the end time, and the first change number corresponding to the second change time between the second sampling time and the start time 2. The amount of change, the first cumulative change amount between the first sampling time and the end time is obtained according to the first change amount, and the second sampling time and the start time are obtained according to the second change amount The second cumulative change quantity between time; the first database includes the change record of the object, and the change record of the object includes the change time at which the number of objects changes and the corresponding change quantity; the first sampling time is A sampling time before the end time and the closest interval to the end time, and the second sampling time is a sampling time before the start time and closest to the end time interval;

   The third cumulative change quantity from the initial time of the system to the first sampling time and the fourth cumulative change quantity from the initial time of the system to the second sampling time are acquired in the second database; the second database includes A cumulative change record of the object, where the cumulative change record includes the cumulative change number of the object from the initial time of the system to each sampling time;

   According to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity, the cumulative change quantity, the total change quantity, and the total quantity of the object in the time period to be queried are obtained At least one of.
2. The method according to claim 1, wherein if the duration of the time period to be queried is less than a first preset duration threshold, the period from the start time to the end time is obtained from the first database. At least one of the cumulative change quantity, the total change quantity, and the total quantity is determined according to the change quantity corresponding to the change time of the change quantity.
3. The method according to claim 1 or 2, wherein the cumulative change quantity includes one of a cumulative warehouse-in quantity, a cumulative warehouse-out quantity, and a cumulative deletion quantity; the change record and the cumulative change record include change types , The change type includes at least one of warehousing, warehousing, and deletion.
4. The method according to claim 3, wherein the total number of changes of the objects in the time period to be queried represents the cumulative quantity of the objects in the inventory during the time period to be queried minus the cumulative number of outgoing objects; Or, the total number of changes of the object in the time period to be queried represents the cumulative amount of storage of the object in the time period to be queried minus the cumulative number of outbounds and the cumulative number of deletions;

   The total number of the objects in the time period to be queried represents the number of objects at the initial time of the system plus the total number of changes of the objects in the time period to be queried.
5. The method according to claim 1 or 2, wherein the method further comprises:

   Acquiring change information of the object; the change information includes at least one of inbound information, outbound information, and deletion information;

   The first database and the second database are updated according to the change information.
6. The method according to claim 5, wherein said updating said first database according to said change information comprises:

   When a preset condition is met, the change record corresponding to the change information is stored in the first database; the preset condition includes that the storage time from the last change record reaches a second preset duration threshold, or The preset condition includes that the quantity of the first change information reaches a preset quantity threshold, and the first change information is change information corresponding to a change record of the change information that is not stored in the first database.
7. The method according to claim 6, wherein said updating said second database according to said change information comprises:

   Acquiring, from the second database, the fifth cumulative change quantity from the initial time of the system to the third sampling time, where the third sampling time is the previous sampling time of the current sampling time;

   Acquiring, from the first database, a third change quantity corresponding to a third change time between the third sampling time and the current sampling time, and obtaining a sixth cumulative change quantity according to the third change quantity;

   According to the fifth cumulative change quantity and the sixth cumulative change quantity, the cumulative change quantity from the initial time of the system to the current sampling time is obtained, which will include the cumulative change from the initial time of the system to the current sampling time The cumulative change record of the quantity is stored in the second database.
8. The method according to claim 1, wherein the change record and the cumulative change record further include the device ID of the object and the category of the object.
9. The method according to claim 8, wherein the cumulative number of changes, the total number of changes, and the total number include the cumulative number of changes, the total number of changes, and the total number of objects in a specific ID generating device; and/or, The cumulative number of changes, total number of changes, and total number include the cumulative number of changes, total number of changes, and total number of objects in a specific category.
10. An object management device, characterized in that the device includes:

    The receiving module is configured to receive a query request of an object; the query request represents a request to query at least one of the cumulative change quantity, the total change quantity, and the total quantity of the object during the time period to be queried, and the time period to be queried includes Start time and end time;

    The first acquisition module is configured to acquire, in the first database, the first change quantity corresponding to the first change time between the first sampling time and the end time, and the difference between the second sampling time and the start time The second change quantity corresponding to the second change time, the first cumulative change quantity between the first sampling time and the end time is obtained according to the first change quantity, and the first change quantity is obtained according to the second change quantity. 2. The second cumulative change quantity between the sampling time and the start time; the first database includes the change record of the object, and the change record of the object includes the change time at which the number of objects changes and the corresponding change quantity; The first sampling time is a sampling time before the end time and the closest interval to the end time, and the second sampling time is a sampling time before the start time and closest to the end time interval;

    The second acquiring module is configured to acquire the third cumulative change quantity from the initial time of the system to the first sampling time and the fourth cumulative change quantity from the initial time of the system to the second sampling time in the second database The second database includes a cumulative change record of the object, and the cumulative change record includes the cumulative change number of the object from the initial time of the system to each sampling time;

    The determining module is used to obtain the cumulative change quantity and total change of the object in the time period to be queried according to the first cumulative change quantity, the second cumulative change quantity, the third cumulative change quantity, and the fourth cumulative change quantity At least one of quantity and total quantity.
11. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method according to any one of claims 1 to 9 when the computer program is executed by the processor.
12. A computer-readable storage medium with a computer program stored thereon, wherein the computer program implements the steps of the method according to any one of claims 1 to 9 when the computer program is executed by a processor.

Images