CN111125436B - Data management method, device and system - Google Patents

Data management method, device and system Download PDF

Info

Publication number
CN111125436B
CN111125436B CN201811289487.4A CN201811289487A CN111125436B CN 111125436 B CN111125436 B CN 111125436B CN 201811289487 A CN201811289487 A CN 201811289487A CN 111125436 B CN111125436 B CN 111125436B
Authority
CN
China
Prior art keywords
time
data
ending
end equipment
starting
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.)
Active
Application number
CN201811289487.4A
Other languages
Chinese (zh)
Other versions
CN111125436A (en
Inventor
许爱秋
刘锋
李海燕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Hikvision System Technology Co Ltd
Original Assignee
Hangzhou Hikvision System Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Hangzhou Hikvision System Technology Co Ltd filed Critical Hangzhou Hikvision System Technology Co Ltd
Priority to CN201811289487.4A priority Critical patent/CN111125436B/en
Priority to PCT/CN2019/114426 priority patent/WO2020088542A1/en
Publication of CN111125436A publication Critical patent/CN111125436A/en
Application granted granted Critical
Publication of CN111125436B publication Critical patent/CN111125436B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/70Information retrieval; Database structures therefor; File system structures therefor of video data
    • G06F16/73Querying
    • G06F16/732Query formulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/70Information retrieval; Database structures therefor; File system structures therefor of video data
    • G06F16/78Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually

Abstract

The invention discloses a data management method, device and system, and belongs to the field of data processing. The method comprises the following steps: receiving a data query request of a terminal, wherein the data query request carries an identifier of front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of data storage of a server; acquiring target data acquired by front-end equipment, first time difference information, and starting time and ending time of the target data according to the identification of the front-end equipment, the first starting time and the first ending time, wherein the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time; and transmitting the target data, the first time difference information and the starting time and the ending time of the target data to the terminal. The invention can meet the data management requirements of the front-end equipment in a plurality of time zones.

Description

Data management method, device and system
Technical Field
The present invention relates to the field of data processing, and in particular, to a data management method, device, and system.
Background
In the video monitoring and storage fields, a multi-time zone scenario may occur, such as a terminal used by a user, a server for providing a storage service, or a front-end device for collecting video data in a plurality of time zones, in which a data management requirement in the multi-time zone scenario may occur.
Currently, in the related art, a standard time, i.e., UTC (Coordinated Universal Time ) time or Unix time stamp, is used as a time for a server to store video data. When the front-end equipment and the server are in the same time zone and the terminal performs query operation on video data acquired by the front-end equipment, a user can input the start time and the end time of query on the terminal, and the time types of the start time and the end time are the time zone time of the server. The terminal converts the starting time and the ending time into standard time according to the time zone time of the server, and sends a data query request to the server, so that the server returns the queried data to the terminal.
In the above scheme, the front-end device needs to be in the same time zone as the server, and the data management requirement of the front-end device in a plurality of time zones cannot be met.
Disclosure of Invention
The embodiment of the invention provides a data management method, a device and a system, which can solve the problem that the related technology cannot meet the data management requirements of front-end equipment in a plurality of time zones. The technical scheme is as follows:
in a first aspect, a data management method is provided, the method comprising:
receiving a data query request of a terminal, wherein the data query request carries an identifier of front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of the data stored by the server;
acquiring target data, first time difference information, and starting time and ending time of the target data acquired by the front-end equipment according to the identification of the front-end equipment, the first starting time and the first ending time, wherein a time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time;
And transmitting the target data, the first time difference information and the starting time and the ending time of the target data to the terminal.
In one possible implementation manner, according to the identifier of the front-end device, the first start time and the first end time, acquiring the target data collected by the front-end device, the first time difference information, and the start time and the end time of the target data includes:
inquiring stored data segments, time difference information corresponding to each data segment, and starting time and ending time of each data segment according to the identification of the front-end equipment, the first starting time and the first ending time;
when the time period between the starting time and the ending time of any data segment is inquired to be included in the time period between the first starting time and the first ending time, the inquired data segment is used as the target data, the time difference information corresponding to the inquired data segment is used as the first time difference information, and the starting time and the ending time of the inquired data segment are used as the starting time and the ending time of the target data.
In one possible implementation manner, before the receiving the data query request of the terminal, the method further includes:
Receiving a time difference inquiry request of the terminal, wherein the time difference inquiry request carries an identifier of the front-end equipment, a third starting time and a third ending time, and the time types of the third starting time and the third ending time are time zone time of the front-end equipment;
acquiring second time difference information of the front-end equipment in a second time period, wherein the second time period is a time period between the third starting time and the third ending time, and the second time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the second time period and the standard time;
and sending the second time difference information to the terminal.
In one possible implementation manner, the acquiring the time difference information of the front-end device in the second time period includes:
and according to the third starting time and the third ending time, inquiring a time zone information table to obtain the time difference information, wherein the time zone information table is used for recording the time difference information of the front-end equipment in at least one time period.
In one possible implementation manner, before the receiving the data query request of the terminal, the method further includes:
and acquiring and storing the data acquired by the front-end equipment according to a data acquisition plan, wherein the data acquisition plan comprises the identification of the front-end equipment, a data acquisition time template and the identification of a time zone strategy, the data acquisition time template is used for indicating the time period of the front-end equipment for data acquisition, and the time zone strategy comprises the time zone information of the front-end equipment.
In one possible implementation, the method further includes:
obtaining a time zone policy table, wherein the time zone policy table comprises time zone policies of the server and the front-end equipment and corresponding policy identifications, each time zone policy comprises a policy type, a time zone, time entering into summer time, time exiting from summer time and time difference between the summer time and winter time, and the policy type comprises the time zone policies of the server and the time zone policies of the front-end equipment.
In one possible implementation manner, the acquiring, according to a data acquisition plan, the data acquired by the front-end device for storage includes:
acquiring a time zone strategy of the front-end equipment according to the identification of the time zone strategy of the front-end equipment in the data acquisition plan;
and according to the time zone strategy of the front-end equipment, the data acquired by the front-end equipment are stored in a segmented mode to obtain multiple segments of data, the multiple segments of data are acquired by the front-end equipment in multiple time zones, the multiple segments of data correspond to multiple pieces of time difference information, and the time difference information corresponding to each segment of data is used for indicating the time difference between the time zone time of the front-end equipment for acquiring each segment of data and the standard time.
In a second aspect, there is provided a data management method, the method comprising:
sending a data query request to a server, wherein the data query request carries an identifier of front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard times, and the standard times are the time types of the starting time and the ending time of the data stored in the server;
receiving target data, first time difference information and starting time and ending time of the target data, wherein the time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time;
according to the first time difference information, converting the starting time and the ending time of the target data into a second starting time and a second ending time, wherein the time types of the second starting time and the second ending time are time zone time of the front-end equipment;
Displaying the target data and the second start time and the second end time.
In one possible implementation manner, the sending the data query request to the server includes:
when the input identification, start time and end time of the front-end equipment are acquired and the time types of the input start time and end time are the standard time, the input start time and end time are taken as the first start time and the first end time, and the data query request is sent to the server.
In one possible implementation manner, before the sending the data query request to the server, the method further includes:
when the input identification, third starting time and third ending time of the front-end equipment are acquired, sending the time difference inquiry request to a server, wherein the time types of the third starting time and the third ending time are the time zone time of the front-end equipment, and the time difference inquiry request carries the identification, the third starting time and the third ending time of the front-end equipment;
receiving second time difference information sent by a server, wherein the second time difference information is used for indicating the time difference between the time zone time of the front-end equipment in a second time period and the standard time, and the second time period is a time period between the third starting time and the third ending time;
And converting the third starting time and the third ending time into the first starting time and the first ending time according to the time difference information.
In a third aspect, there is provided a data management apparatus, the apparatus comprising:
the receiving module is used for receiving a data query request of the terminal, wherein the data query request carries an identifier of front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of the data stored by the server;
the acquisition module is used for acquiring target data, first time difference information, and starting time and ending time of the target data acquired by the front-end equipment according to the identification of the front-end equipment, the first starting time and the first ending time, wherein a time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time;
And the sending module is used for sending the target data, the first time difference information and the starting time and the ending time of the target data to the terminal.
In one possible implementation manner, the acquiring module is configured to:
inquiring stored data segments, time difference information corresponding to each data segment, and starting time and ending time of each data segment according to the identification of the front-end equipment, the first starting time and the first ending time;
when the time period between the starting time and the ending time of any data segment is inquired to be included in the time period between the first starting time and the first ending time, the inquired data segment is used as the target data, the time difference information corresponding to the inquired data segment is used as the first time difference information, and the starting time and the ending time of the inquired data segment are used as the starting time and the ending time of the target data.
In one possible implementation manner, the receiving module is further configured to receive a time difference query request of the terminal, where the time difference query request carries an identifier of the front-end device, a third start time, and a third end time, and a time type of the third start time and the third end time is a time zone time of the front-end device;
The acquisition module is further configured to acquire second time difference information of the front-end device in a second time period, where the second time period is a time period between the third start time and the third end time, and the second time difference information is used to indicate a time difference between a time zone time of the front-end device in the second time period and the standard time;
the sending module is further configured to send the second time difference information to the terminal.
In one possible implementation manner, the obtaining module is configured to query a time zone information table according to the third start time and the third end time to obtain the time difference information, where the time zone information table is used to record the time difference information of the front-end device in at least one time period.
In one possible implementation manner, the obtaining module is further configured to obtain, according to a data collection plan, data collected by the front-end device to store, where the data collection plan includes an identifier of the front-end device, a data collection time template, and an identifier of a time zone policy, where the data collection time template is used to indicate a time period for the front-end device to collect data, and the time zone policy includes time zone information of the front-end device.
In one possible implementation manner, the obtaining module is further configured to obtain a time zone policy table, where the time zone policy table includes time zone policies of the server and the front-end device and corresponding policy identifiers, each time zone policy includes a policy type, a time zone, a time of entering daylight savings time, a time of exiting daylight savings time, and a time difference between daylight savings time and winter time, and the policy type includes the time zone policies of the server and the time zone policies of the front-end device.
In one possible implementation manner, the acquiring module is configured to:
acquiring a time zone strategy of the front-end equipment according to the identification of the time zone strategy of the front-end equipment in the data acquisition plan;
and according to the time zone strategy of the front-end equipment, the data acquired by the front-end equipment are stored in a segmented mode to obtain multiple segments of data, the multiple segments of data are acquired by the front-end equipment in multiple time zones, the multiple segments of data correspond to multiple pieces of time difference information, and the time difference information corresponding to each segment of data is used for indicating the time difference between the time zone time of the front-end equipment for acquiring each segment of data and the standard time.
In a fourth aspect, there is provided a data management apparatus, the apparatus comprising:
The data query module is used for sending a data query request to a server, wherein the data query request carries an identifier of front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of the data stored in the server;
the receiving module is used for receiving target data, first time difference information and starting time and ending time of the target data, wherein the time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time;
the conversion module is used for converting the starting time and the ending time of the target data into second starting time and second ending time according to the first time difference information, and the time types of the second starting time and the second ending time are time zone time of the front-end equipment;
And the display module is used for displaying the target data, the second starting time and the second ending time.
In one possible implementation manner, the sending module is configured to send the data query request to the server with the input start time and end time as the first start time and the first end time when the input identification, start time, and end time of the front-end device are acquired and the time type of the input start time and end time is the standard time.
In one possible implementation manner, the sending module is further configured to send, when the input identifier of the front-end device, a third start time, and a third end time are acquired, the time difference query request to a server, where the time types of the third start time and the third end time are time zone times of the front-end device, and the time difference query request carries the identifier of the front-end device, the third start time, and the third end time;
the receiving module is further configured to receive second time difference information sent by the server, where the second time difference information is used to indicate a time difference between a time zone time of the front end device in a second time period and the standard time, and the second time period is a time period between the third start time and the third end time;
And the conversion module is used for converting the third starting time and the third ending time into the first starting time and the first ending time according to the time difference information.
In a fifth aspect, a data management system is provided, the system comprising a head-end, a server and a terminal,
the front-end equipment is used for collecting data and sending the collected data to the server;
the server is used for storing the data acquired by the front-end equipment by adopting standard time;
the terminal is used for sending a data query request to a server, wherein the data query request carries an identifier of front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of the data stored in the server;
the server is further configured to, when receiving a data query request of a terminal, obtain, according to an identifier of the front-end device, the first start time and the first end time, target data acquired by the front-end device, first time difference information, and start time and end time of the target data, and send the target data to the terminal, where a time period between the start time and the end time of the target data is a first time period, and the first time period is included in a time period between the first start time and the first end time, and the first time difference information is used to indicate a time difference between a time zone time of the front-end device in the first time period and the standard time;
The terminal is further configured to, when receiving the target data, the first time difference information, and the start time and the end time of the target data sent by the server, convert the start time and the end time of the target data into a second start time and a second end time according to the first time difference information, where the time types of the second start time and the second end time are time zone times of the front-end device, and display the target data and the second start time and the second end time.
In a sixth aspect, a server is provided, comprising a processor and a memory; the memory is used for storing at least one instruction; the processor is configured to execute at least one instruction stored on the memory, to implement a method step according to any implementation manner of the first aspect.
In a seventh aspect, a terminal is provided, comprising a processor and a memory; the memory is used for storing at least one instruction; the processor is configured to execute at least one instruction stored on the memory, and implement a method step according to any implementation manner of the second aspect.
In an eighth aspect, there is provided a computer readable storage medium having stored therein at least one instruction which when executed by a processor implements the method steps of any of the implementations of any of the preceding aspects.
The technical scheme provided by the embodiment of the invention has the beneficial effects that at least:
when a data query request of a terminal is received, according to the identification, the first starting time and the first ending time of front-end equipment carried in the data query request, acquiring target data acquired by the front-end equipment, first time difference information, and the starting time and the ending time of the target data, and then returning the target data, the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment when the target data are acquired and the standard time, so that the terminal can convert the starting time and the ending time of the target data into the time zone time of the front-end equipment according to the first time difference information and display the time zone time of the front-end equipment. The scheme supports that the front-end equipment in different time zones is accessed to the server, the front-end equipment can be in different time zones with the server, different front-end equipment can be in different time zones, the same front-end equipment can be in different time zones in different time periods, and the data management requirement of the front-end equipment in a plurality of time zones can be met.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic diagram of a data management system according to an embodiment of the present invention.
Fig. 2 is a flowchart of a data management method according to an embodiment of the present invention.
Fig. 3 is a flowchart of a data management method according to an embodiment of the present invention.
Fig. 4 is a flowchart of a data management method according to an embodiment of the present invention.
FIG. 5 is a flow chart of a configuration time zone policy provided by an embodiment of the present invention.
Fig. 6 is a flowchart of acquiring data according to an embodiment of the present invention.
Fig. 7 is a block diagram of a data store according to an embodiment of the present invention.
Fig. 8 is a flowchart of a data management method according to an embodiment of the present invention.
FIG. 9 is a flow chart of a data query provided by an embodiment of the present invention.
Fig. 10 is a schematic structural diagram of a data management device according to an embodiment of the present invention.
Fig. 11 is a schematic structural diagram of a data management device according to an embodiment of the present invention.
Fig. 12 is a schematic structural diagram of a terminal 1200 according to an embodiment of the present invention.
Fig. 13 is a schematic structural diagram of a server 1300 according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the embodiments of the present invention will be described in further detail with reference to the accompanying drawings.
Before explaining the embodiments of the present invention in detail, some key terms related to the embodiments of the present invention are explained:
unix timestamp (Unix timestamp): the term Unix time (Unix time) and POSIX time (POSIX time) is a time expression, and is defined as the total number of seconds from Greenwich mean time 1980, 01, and 00 minutes and 00 seconds at 01, and day 01.
Summer time: the summer time is called summer time system, sunlight saving time system and summer time, which are local summer time and winter time which are different by one hour because the time is manually shortened by one hour in summer with early day time in order to save energy. Different specific regulations are imposed in countries that adopt the summer system, and currently, approximately 110 countries worldwide are subjected to summer time each year.
UTC time: world time, also known as world universal time, world standard time, and international coordination time. Due to the different abbreviations for English (CUT) and French (TUC), UTC is abbreviated as a compromise. Coordinated universal time is a time metering system that is as close to universal time as possible in time on the basis of atomic time seconds.
Fig. 1 is a schematic diagram of a data management system according to an embodiment of the present invention, where the data management system may include a front end device 101, a server 102, and a terminal 103.
The front-end device 101 is configured to collect data, such as video data, and send the collected data to the server 102 for storage. The front-end device 101 may be an IPC (IP Camera) or other devices having a data acquisition function.
The server 102 is configured to store data collected by the front-end device 101 using standard time. The server 102 is further configured to, when receiving a data query request from the terminal 103, acquire corresponding data, and send the acquired data to the terminal 103.
It should be noted that, the server 102 may refer to one server, or may refer to a server cluster formed by a plurality of servers, where the plurality of servers may include a data management server, a data acquisition plan management server, a video access server, and a video storage server, for example. Server 102 may be a server in a cloud storage system.
The terminal 103 is configured to send a time difference query request to the server 102, and after receiving the time difference information sent by the server 102, the terminal 103 is further configured to send a data query request to the server 102, where the data query request is used to obtain data collected by the front end device 101. The terminal 103 may be a user device such as a smart phone, tablet computer, notebook computer or desktop computer.
Fig. 2 is a flowchart of a data management method according to an embodiment of the present invention. Referring to fig. 2, the method includes:
201. and receiving a data query request of the terminal, wherein the data query request carries an identifier of the front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of the data storage of the server.
202. And acquiring target data acquired by the front-end equipment, first time difference information, and starting time and ending time of the target data according to the identification of the front-end equipment, the first starting time and the first ending time, wherein a time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time.
203. And transmitting the target data, the first time difference information and the starting time and ending time of the target data to the terminal.
According to the method provided by the embodiment of the invention, when the data query request of the terminal is received, the target data, the first time difference information, and the starting time and the ending time of the target data acquired by the front-end equipment are acquired according to the identification, the first starting time and the first ending time of the front-end equipment carried in the data query request, and then returned to the terminal, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment when the target data are acquired and the standard time, so that the terminal can convert the starting time and the ending time of the target data into the time zone time of the front-end equipment according to the first time difference information and then display the time zone time of the front-end equipment. The scheme supports that the front-end equipment in different time zones is accessed to the server, the front-end equipment can be in different time zones with the server, different front-end equipment can be in different time zones, the same front-end equipment can be in different time zones in different time periods, and the data management requirement of the front-end equipment in a plurality of time zones can be met.
Fig. 3 is a flowchart of a data management method according to an embodiment of the present invention. Referring to fig. 3, the method includes:
301. sending a data query request to a server, wherein the data query request carries an identifier of front-end equipment, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of the data stored in the server;
302. Receiving target data, first time difference information and starting time and ending time of the target data, wherein the time period between the starting time and the ending time of the target data is a first time period, the first time period is contained in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time;
303. converting the start time and the end time of the target data into a second start time and a second end time according to the first time difference information, wherein the time types of the second start time and the second end time are the time zone time of the front-end equipment;
304. displaying the target data and the second start time and the second end time.
According to the method provided by the embodiment of the invention, the data query request is sent to the server, and when the target data, the first time difference information, and the starting time and the ending time of the target data returned by the server are received, the starting time and the ending time of the target data are converted into the time zone time of the front-end equipment according to the first time difference information and then displayed. The scheme supports that the front-end equipment in different time zones is accessed to the server, the front-end equipment can be in different time zones with the server, different front-end equipment can be in different time zones, the same front-end equipment can be in different time zones in different time periods, and the data management requirement of the front-end equipment in a plurality of time zones can be met.
Fig. 4 is a flowchart of a data management method according to an embodiment of the present invention. Referring to fig. 4, the method includes:
401. the server obtains the time zone policy of the server and the time zone policy of the front-end device.
In the embodiment of the invention, a plurality of time zone policies can be configured in the server, and the time zone policies can be divided into two types, namely, the time zone policies of the server and the time zone policies of the front-end equipment. The time zone policy includes a policy type, a time zone, a time to enter daylight savings time, a time to exit daylight savings time, and a time difference between daylight savings time and winter time, the policy type being used to distinguish between the time zone policies of the head-end equipment and the server. For example, the time zone may be Dong's second zone, dong's eighth zone, etc., and if the time zone in which the device is located is daylight savings time at 3 months 1 day 13:00 to 10 months 1 day 15:00 each year, then the time to enter daylight savings time is 3 months 1 day 13:00 and the time to exit daylight savings time is 10 months 1 day 15:00.
In one possible implementation, the time zone policy configuration may be configured through a WEB page (WEB page), or may be configured through an SDK (Software Development Kit ) interface. In one possible implementation, the specific implementation procedure for configuring the time zone policy may include the following three steps a to c:
And a time zone strategy of the server is configured through the webpage.
For example, a user may log in a configuration WEB page of a time zone policy on a terminal, and the user may input and submit the time zone policy of a server on the WEB page, trigger the terminal to send the time zone policy of the server to the server, and the server stores the time zone policy, thereby completing configuration of the time zone policy of the server. The time zone policy of the server is a default time zone policy, and if the front-end device does not specify the time zone policy it uses, the server may default the front-end device to employ the server's time zone policy.
And b, configuring a time zone strategy of the front-end equipment through the SDK interface.
The terminal can call a server SDK interface (cloud storage SDK interface) to connect with the server, add the time zone policy of the front-end equipment, and after the operation is successful, the SDK interface can return a unique policy ID (Identification) to the terminal, wherein the policy ID refers to the Identification of the time zone policy.
It should be noted that, in this step b, the server may access one or more front-end devices, and accordingly, a time zone policy of at least one front-end device may be configured through the SDK interface.
And c, the server acquires and stores the time zone policy table.
The time zone policy table comprises time zone policies of the server and the front-end equipment and corresponding policy identifications. Each time zone policy comprises a policy ID, a policy type, a time zone, time for entering daylight savings time, time for exiting daylight savings time and time difference between daylight savings time and winter time, wherein the policy ID is used for distinguishing different time zone policies, and the policy type comprises the time zone policy of the server and the time zone policy of the front-end device.
After the server obtains the time zone policies of the server and each front-end device through the steps a and b, an identifier of each time zone policy can be generated; and generating the time zone policy table according to the identification of each time zone policy and the time zone policies of the server and the front-end equipment.
The time zone strategy of the server and the time zone strategy of each front-end device are configured in the server, so that the server can store collected data according to the time zone strategy of each front-end device and provide the collected data for the terminal to perform data query.
It should be noted that, the above manner is only described by using a time zone policy of the server configured through a web page and configuring a time zone policy of the front-end device through the SDK interface as an example, and it is understood that the time zone policy of the server may also be configured through the SDK interface and the time zone policy of the front-end device may also be configured through a web page, which is not limited in the embodiment of the present invention.
Referring to fig. 5, fig. 5 is a flowchart of a time zone policy configuration, where, as shown in fig. 5, taking data as video data as an example, a server may include a video management service module, a data acquisition plan management service module, a video access service module, and a video storage service module. The video management service module is used for managing the configuration of the time zone strategy and the storage of video data; the data acquisition plan management service module is used for configuring a data acquisition plan (video recording plan); the video access service module is used for receiving video data sent by the front-end equipment; the video storage service module is used for storing video data.
The data collection plan management service module can synchronize a time zone policy table from the video management service module in time, including a time zone policy of the server and a time zone policy of the front-end device. For example, the video management service module may send the time zone policy table to the data collection plan management service module at regular or real-time. In addition, the data acquisition plan management service module may synchronize the time zone policy table to the video access service module in time, e.g., the data acquisition plan management service module may send the time zone policy table to the video access service module at regular or real-time.
It should be noted that, fig. 5 illustrates that functions of four modules, such as a video management service module, a data acquisition plan management service module, a video access service module, and a video storage service module, are integrated on one server, and an interaction process of the four modules is an interaction process between each module in the same server. It will be appreciated that the functions of each module may be provided by one server, that is, the interaction between the four modules is actually an interaction between the four servers, which is not limited by the embodiment of the present invention.
402. The server acquires data from the front-end equipment and stores the data.
In the embodiment of the invention, the server can acquire the data acquired by the front-end equipment according to the data acquisition plan and store the data. The data acquisition plan comprises an identifier of the front-end equipment, a data acquisition time template and an identifier of a time zone strategy, wherein the data acquisition time template is used for indicating a time period for the front-end equipment to acquire data, and the time zone strategy comprises time zone information of the front-end equipment. The configuration process of the data acquisition plan is the same as the configuration process of the time zone policy, and the terminal can configure the data acquisition plan to the server through the SDK interface, however, the data acquisition plan can also be configured through a WEB page, which is not limited in the embodiment of the present invention.
In one possible implementation, the manner in which the server stores the data of any front-end device may be: acquiring a time zone strategy of the front-end equipment according to the identification of the time zone strategy of the front-end equipment in the data acquisition plan; and according to the time zone strategy of the front-end equipment, the data acquired by the front-end equipment are stored in a segmented mode to obtain multiple pieces of data, the multiple pieces of data are acquired by the front-end equipment in multiple time zones, the multiple pieces of data correspond to multiple pieces of time difference information, and the time difference information corresponding to each piece of data is used for indicating the time difference between the time zone time of the front-end equipment for acquiring each piece of data and the standard time.
When the server receives data collected by any front-end equipment, the time zone policy table can be queried according to the time zone policy identification of the front-end equipment, and the time zone policy of the front-end equipment is determined, so that the time difference information of the front-end equipment in each time period is known, the server can store the data in a segmented mode according to the time difference information of the front-end equipment in each time period, and the data collected in the same time zone is divided into one segment, so that one segment of data corresponds to one time difference information.
The data collected by the front-end equipment are stored in a segmented mode, so that the data collected by the front-end equipment in each time zone in each time period can be better distinguished, and a user can conveniently inquire.
Referring to fig. 6, fig. 6 is a flowchart of acquiring data according to an embodiment of the present invention. As shown in fig. 6, the terminal may configure a data acquisition plan to a data acquisition plan management service module through an SDK interface, where the data acquisition plan management service module is configured to issue the data acquisition plan to a video access service module, and the video access service module performs a task of acquiring a real-time data stream from a front-end device according to information in the data acquisition plan.
After the video access service module obtains the data, the data can be written into the video storage service module, and the video access service module needs to communicate with the video management service module first to apply for storage resources, for example, the video access service module can send an application resource protocol to the video management service module, where the application resource protocol includes an encoder ID of the front end device, a start time of the video data, and time difference information (time difference between time zone time of the front end device and standard time) of the front end device. After receiving the resource application protocol, the video management service module can return the applied storage resource to the video access service module according to the resource allocation strategy (load balancing strategy), and meanwhile, the video management service module can record the time zone information of the front-end equipment. For example, the video management service module may record time zone information of the head-end device in a time zone information table. Referring to table 1, there is provided a time zone information table in which encoder IDs of the head-end apparatuses, time difference information of the head-end apparatuses in at least one time period can be recorded as shown in table 1.
TABLE 1
If the time zone policy of the front-end equipment is changed, so that the time difference between the time zone time of the front-end equipment and the standard time is changed, the video management service module can add a record in the time zone information table every time the time difference is changed. As shown in table 1, the front-end device with the encoder ID Test1 has a time zone of 3 hours (hours) in the east 3 region in the period from 23:00 in 2018, 01, 12, and 23:00 in 2018, 04, 12, and a time difference of 3 hours (hours), the front-end device changes the time zone from 3 hours in the east to two hours in 2018, 12, 23:00, and the time difference changes to 2 hours, so that the server can add a record in the video management service module. Since the time difference changes from 3 hours to 2 hours, 23:00 in 12 months in 2018 04 month changes to 22:00 in 12 months in 2018 month, if the time zone policy of the front-end device changes from the change to the current time, the start time of the newly added record is 22:00 in 12 months in 2018 month, and the end time is current.
Of course, besides that the time zone policy of the front-end device is changed, the time difference information of the front-end device is changed, and the reason for the time difference change may be that the front-end device enters the daylight saving time from the daylight saving time or the front-end device enters the daylight saving time from the daylight saving time.
When the video access service module writes video data into the video storage service module, the video access service module can provide time difference information of the video data (time difference information of front-end equipment sending the video data) for the video storage service module, and the video storage service module can store the information into the storage block equipment for backup.
Video data is written into the underlying block device by the video storage service module for storage. Referring to fig. 7, fig. 7 is a block diagram of a data storage according to an embodiment of the present invention, and as shown in fig. 7, when video data is stored, a video storage service module may divide the video data into a plurality of video segments, such as video segment 1 and video segment 2. The segment information corresponding to each video segment includes a start time, an end time, and a time difference from the UTC time, and the video management service module may use standard time to store data.
403. The terminal sends a data query request to a server, wherein the data query request carries an identifier of a front-end device, a first starting time and a first ending time, the time types of the first starting time and the first ending time are standard time, and the standard time is the time type of the starting time and the ending time of the data stored by the server.
In the embodiment of the invention, after the server acquires the data from the front-end equipment and stores the data, a user can perform operations such as inquiring, downloading or playing back the data acquired by a certain front-end equipment, wherein the inquiring operation is required before downloading and playing back, that is, the data acquired by the front-end equipment is required to be inquired first. Specifically, the user may input, on the terminal, the identification of the front-end device to be queried and a query time period, including a start time and an end time. Because the time of the server underlying data storage is the standard time, in one possible implementation manner, when the terminal obtains the identifier, the start time and the end time of the front-end device input by the user and the time types of the input start time and end time are the standard time, the terminal may send the data query request to the server with the input start time and end time as the first start time and the first end time.
It should be noted that, there may be two metering methods for standard time, one is UTC time, the other is UNIX timestamp, and the time of use of the terminal is X years, X months, X days, X minutes, X seconds. If the time type of the start time and the end time of the server storage data is UTC time and the time type of the start time and the end time input by the user on the terminal is UTC time, the terminal may directly use the start time and the end time input by the user as the first start time and the first end time, so that the time type of the first start time and the first end time is UTC time.
If the time type of the start time and the end time of the server storage data is a UNIX timestamp, and the time type of the start time and the end time input by the user on the terminal is a UTC time, the terminal needs to convert the start time and the end time input by the user into the UNIX timestamp first, for example, the terminal can convert the UTC time into the UNIX timestamp through the SDK interface, and the converted start time and end time are taken as a first start time and a first end time, so that the time type of the first start time and the first end time is the UNIX timestamp.
Compared with the prior art, the method for inquiring the data only supports the time zone time of the front-end equipment input by the user, the method for inquiring the data by providing the standard time input by the user improves the flexibility of inquiring the data.
404. When a data query request of a terminal is received, the server acquires target data acquired by the front-end equipment, first time difference information, and start time and end time of the target data according to the identification of the front-end equipment, the first start time and the first end time.
The time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end device in the first time period and the standard time.
In the embodiment of the invention, when the server receives the data query request of the terminal, the stored data can be queried according to the first starting time and the first ending time carried in the data query request. Since the time type of the start time and the end time of the server storage data is the standard time, and the time type of the first start time and the first end time is also the standard time, in one possible implementation, the process of the server obtaining the target data, the first time difference information, and the start time and the end time of the target data includes:
inquiring the stored data segments, time difference information corresponding to each data segment, and the starting time and the ending time of each data segment according to the identification of the front-end equipment, the first starting time and the first ending time;
when the time period between the starting time and the ending time of any data segment is inquired to be included in the time period between the first starting time and the first ending time, the inquired data segment is used as the target data, the time difference information corresponding to the inquired data segment is used as the first time difference information, and the starting time and the ending time of the inquired data segment are used as the starting time and the ending time of the target data.
For the server to store the data segment collected by the front-end device in step 402, when the time period between the start time and the end time of any data segment is included in the time period between the first start time and the first end time during the query of the target data, the server may return the data as a query result to the terminal. In addition, when the server queries the target data, the server may also query the start time, the end time and the first time difference information recorded in the information of the target data.
405. The server transmits the target data, the first time difference information, and a start time and an end time of the target data to the terminal.
In the embodiment of the invention, when the server returns the target data to the terminal as the query result, the server can also return the starting time and the ending time of the target data and the corresponding first time difference information to the terminal.
406. When receiving the target data, the first time difference information and the starting time and the ending time of the target data, the terminal converts the starting time and the ending time of the target data into second starting time and second ending time according to the first time difference information, wherein the time types of the second starting time and the second ending time are the time zone time of the front-end equipment.
The second start time is a time when the front-end equipment starts to collect the target data, and the second end time is a time when the front-end equipment ends to collect the target data.
In the embodiment of the invention, when a user inquires data, the data collected by the front-end equipment in the local time zone time is expected to be seen, so that the events of different time zones in a certain time period can be known. Because the time types of the start time and the end time of the target data returned by the server are standard time, in order to inform the user of the local time zone time of the front-end equipment when the target data is collected, the terminal can also determine the local time zone time when the front-end equipment collects the target data after receiving the target data returned by the server. And the first time difference information indicates a time difference between the time zone time when the front-end device acquired the target data and the standard time. Therefore, the terminal can convert the starting time and the ending time of the target data into the local time zone time of the front-end equipment according to the first time difference information corresponding to the target data.
If the time type of the start time and the end time of the server storage data is UTC time, that is, the start time and the end time of the target data are UTC time, the terminal needs to convert the UTC time into the time zone time of the front-end device, for example, the terminal may convert the UTC time into the time zone time of the front-end device through the SDK interface, thereby obtaining the second start time and the second end time.
If the time type of the start time and the end time of the server storage data is a UNIX time stamp, that is, the start time and the end time of the target data are UNIX time stamps, the terminal needs to convert the UNIX time stamp into the time zone time of the front-end device, for example, the terminal may convert the UNIX time stamp into the time zone time of the front-end device through the SDK interface, thereby obtaining the second start time and the second end time.
407. The terminal displays the target data and the second start time and the second end time.
In the embodiment of the invention, after receiving the target data sent by the server, the terminal can display the target data. In addition, the terminal can display the local time zone time, namely the second starting time and the second ending time, when the front-end equipment collects the target data, so that the user can know the starting time and the ending time of the front-end equipment for collecting the data, and further know the event occurring in the collecting range of the front-end equipment in the time period.
Optionally, when the terminal displays the target data and the second start time and the second end time, the terminal may also display first time difference information corresponding to the target data, so that the user may learn a time difference between a time zone time of the front-end device when the front-end device collects the target data and a standard time.
The technical scheme provided by the embodiment of the invention simultaneously supports the data management of the terminal, the server and the front-end equipment under different time zone strategies. In particular, the front-end device access supporting multiple time zones, such as the encoder 1 of the front-end device 1 in the east two zone and the encoder 2 of the front-end device 2 in the east eight zone. When the data control operation is performed, the system automatically recognizes that the local time of the east two area is adopted for the front-end equipment 1 to perform the query, playback and download operation, and the local time of the east eight area is adopted for the front-end equipment 2 to perform the query, playback and download operation.
In addition, the technical scheme also supports a data management method of multiple time zone strategies of the same front-end equipment. For example, if the time zone of the encoder 1 of the front-end device 1 in 1 month is the east two zone, and the time zone is changed into the east three zone in 2 months due to human factors, when the data control operation is performed, the time zone difference of different time periods is automatically identified in the system, and corresponding inquiry, playback and downloading results are returned.
The technical scheme supports a mode of inquiring data according to standard time, and the server returns time zone information corresponding to the data in addition to the data.
According to the method provided by the embodiment of the invention, when the data query request of the terminal is received, the target data, the first time difference information, and the starting time and the ending time of the target data acquired by the front-end equipment are acquired according to the identification, the first starting time and the first ending time of the front-end equipment carried in the data query request, and then returned to the terminal, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment when the target data are acquired and the standard time, so that the terminal can convert the starting time and the ending time of the target data into the time zone time of the front-end equipment according to the first time difference information and then display the time zone time of the front-end equipment. The scheme supports that the front-end equipment in different time zones is accessed to the server, the front-end equipment can be in different time zones with the server, different front-end equipment can be in different time zones, the same front-end equipment can be in different time zones in different time periods, and the data management requirement of the front-end equipment in a plurality of time zones can be met.
The embodiment corresponding to fig. 4 is a data query process for the case where the input query time is the standard time (UTC time), and the query time input by the user on the terminal may also be the time zone time of the front-end device, and the data query process in this case will be described in the embodiment corresponding to fig. 8.
Fig. 8 is a flowchart of a data management method according to an embodiment of the present invention. Referring to fig. 8, the method includes:
801. the server obtains the time zone policy of the server and the time zone policy of the front-end device.
802. The server acquires data from the front-end equipment and stores the data.
Steps 801 to 802 are the same as steps 401 to 402, and are not described here.
803. When the input identification of the front-end equipment, the third starting time and the third ending time are acquired, the terminal sends a time difference inquiry request to the server, and the time types of the third starting time and the third ending time are the time zone time of the front-end equipment.
The time difference inquiry request carries an identifier of the front-end equipment, the third starting time and the third ending time, and is used for acquiring time difference information of the front-end equipment in a time period corresponding to the third starting time and the third ending time, wherein the time difference information is used for indicating a time difference between time zone time of the front-end equipment in the time period and standard time.
In the embodiment of the invention, the user can input the identification of the front-end equipment to be queried and the query time period on the terminal, wherein the starting time and the ending time of the query time period adopt the local time zone time of the front-end equipment, namely, the third starting time and the third ending time. Because the time of the server bottom layer data is the standard time, the terminal needs to perform time conversion according to the time difference between the time zone time of the front-end device and the standard time, and performs the data query operation after converting the starting time and the ending time of the query time period into the standard time. For this reason, the terminal may carry the identifier of the front-end device, the third start time and the third end time in the time difference query request, and send the identifiers, the third start time and the third end time to the server, so that the server may return the time difference information of the front-end device to be queried in the query time period. For example, the terminal may invoke the SDK interface to communicate with the server, and send a time difference query request to the server.
804. When receiving the time difference inquiry request of the terminal, the server acquires second time difference information of the front-end equipment in a second time period, and sends the second time difference information to the terminal, wherein the second time period is a time period between the third starting time and the third ending time, and the second time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the second time period and the standard time.
In one possible implementation, the process of obtaining the second time difference information by the server may include: and according to the third starting time and the third ending time, inquiring a time zone information table to obtain the time difference information, wherein the time zone information table is used for recording the time difference information of the front-end equipment in at least one time period.
The time zone information table refers to table 1 in step 402, and after the server obtains the time difference information in the second time period by querying the time zone information table, the server may return the obtained time difference information to the terminal.
805. When receiving the second time difference information sent by the server, the terminal converts the third starting time and the third ending time into the first starting time and the first ending time according to the time difference information, and then sends a data query request to the server.
The data query request carries an identifier of a front-end device, a first start time and a first end time, wherein the time types of the first start time and the first end time are standard times, and the standard times are the time types of the start time and the end time of the data stored by the server.
In one possible implementation manner, after the terminal receives the time difference information returned by the server, the third start time and the third end time may be converted into standard times, that is, the first start time and the first end time according to the time difference information.
If the time type of the start time and the end time of the server storage data is UTC time, since the time type of the third start time and the third end time is time zone time of the front end device, the terminal needs to convert the start time and the end time input by the user into UTC time, for example, the terminal may convert the time zone time of the front end device into UTC time through the SDK interface, and the converted time is taken as the first start time and the first end time.
If the time type of the start time and the end time of the server storage data is a UNIX timestamp, since the time type of the third start time and the third end time is a time zone time of the front end device, the terminal needs to convert the start time and the end time input by the user into a UNIX timestamp, for example, the terminal may convert the time zone time of the front end device into a UNIX timestamp through the SDK interface, and the converted time is taken as the first start time and the first end time.
Further, in the same manner as step 403, since the first start time and the first end time are standard times, which are the same as the type of time when the server stores data, the terminal may carry the identifier of the front-end device, the first start time and the first end time in the data query request and send the data query request to the server to perform data query.
806. When a data query request of a terminal is received, the server acquires target data acquired by the front-end equipment, first time difference information, and start time and end time of the target data according to the identification of the front-end equipment, the first start time and the first end time.
807. The server transmits the target data, the first time difference information, and a start time and an end time of the target data to the terminal.
808. When receiving the target data, the first time difference information and the starting time and the ending time of the target data, the terminal converts the starting time and the ending time of the target data into second starting time and second ending time according to the first time difference information, wherein the time types of the second starting time and the second ending time are the time zone time of the front-end equipment.
809. The terminal displays the target data and the second start time and the second end time.
Steps 806 to 809 are similar to steps 404 to 407, and are not described herein.
The above steps 803 to 809 are data query processes for the case where the input query time is the time zone time of the front-end device. Referring to fig. 9, fig. 9 is a flowchart of data query provided in an embodiment of the present invention, as shown in fig. 9, a terminal first obtains time difference information of a front-end device in a query time period from a server, and after the server returns the time difference information to the terminal, the terminal performs a data query operation, and the server returns a data query result to the terminal.
In the technical scheme provided by the embodiment of the invention, the server can support the access of a plurality of front-end devices, the plurality of front-end devices can be in different time zones, and the time zones of the same front-end device in different time periods can also be different. The time difference information of each front-end device in each time period is stored in the server in advance, so that when the terminal needs to inquire the data of any front-end device, the time difference information of the front-end device in the time period input by a user can be obtained from the server, and further, the time zone time of the front-end device is converted into standard time according to the time difference information returned by the server, and then the data inquiry operation is performed.
The technical scheme simultaneously supports the data management of the terminal, the server and the front-end equipment under different time zone strategies. In particular, the front-end device access supporting multiple time zones, such as the encoder 1 of the front-end device 1 in the east two zone and the encoder 2 of the front-end device 2 in the east eight zone. When the data control operation is performed, the system automatically recognizes that the local time of the east two area is adopted for the front-end equipment 1 to perform the query, playback and download operation, and the local time of the east eight area is adopted for the front-end equipment 2 to perform the query, playback and download operation.
In addition, the technical scheme also supports a data management method of multiple time zone strategies of the same front-end equipment. For example, if the time zone of the encoder 1 of the front-end device 1 in 1 month is the east two zone, and the time zone is changed into the east three zone in 2 months due to human factors, when the data control operation is performed, the time zone difference of different time periods is automatically identified in the system, and corresponding inquiry, playback and downloading results are returned.
It can be seen that the server may support two data query modes, one is that the user inputs standard time (UTC time) on the terminal, and the time of the data returned by the query result is the time zone time of the front-end device, and the specific process is shown in the embodiment corresponding to fig. 4. The other is that the user inputs the time zone time of the front-end equipment on the terminal, the time of the data returned by the query result is the time zone time of the front-end equipment, and the specific process is shown in the embodiment corresponding to fig. 8.
According to the method provided by the embodiment of the invention, when the data query request of the terminal is received, the target data, the first time difference information, and the starting time and the ending time of the target data acquired by the front-end equipment are acquired according to the identification, the first starting time and the first ending time of the front-end equipment carried in the data query request, and then returned to the terminal, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment when the target data are acquired and the standard time, so that the terminal can convert the starting time and the ending time of the target data into the time zone time of the front-end equipment according to the first time difference information and then display the time zone time of the front-end equipment. The scheme supports that the front-end equipment in different time zones is accessed to the server, the front-end equipment can be in different time zones with the server, different front-end equipment can be in different time zones, the same front-end equipment can be in different time zones in different time periods, and the data management requirement of the front-end equipment in a plurality of time zones can be met.
Fig. 10 is a schematic structural diagram of a data management device according to an embodiment of the present invention. Referring to fig. 10, the apparatus includes:
a receiving module 1001, configured to receive a data query request of a terminal, where the data query request carries an identifier of a front-end device, a first start time, and a first end time, and time types of the first start time and the first end time are standard times, and the standard times are time types of a start time and an end time of data stored in the server;
an obtaining module 1002, configured to obtain, according to the identifier of the front-end device, the first start time and the first end time, target data collected by the front-end device, first time difference information, and start time and end time of the target data, where a time period between the start time and the end time of the target data is a first time period, the first time period is included in a time period between the first start time and the first end time, and the first time difference information is used to indicate a time difference between a time zone time of the front-end device in the first time period and the standard time;
and a transmitting module 1003 configured to transmit the target data, the first time difference information, and a start time and an end time of the target data to the terminal.
In one possible implementation, the obtaining module 1002 is configured to:
inquiring the stored data segments, time difference information corresponding to each data segment, and the starting time and the ending time of each data segment according to the identification of the front-end equipment, the first starting time and the first ending time;
when the time period between the starting time and the ending time of any data segment is inquired to be included in the time period between the first starting time and the first ending time, the inquired data segment is used as the target data, the time difference information corresponding to the inquired data segment is used as the first time difference information, and the starting time and the ending time of the inquired data segment are used as the starting time and the ending time of the target data.
In one possible implementation manner, the receiving module 1001 is further configured to receive a time difference query request of the terminal, where the time difference query request carries an identifier of the front-end device, a third start time, and a third end time, and a time type of the third start time and the third end time is a time zone time of the front-end device;
the obtaining module 1002 is further configured to obtain second time difference information of the front-end device in a second time period, where the second time period is a time period between the third start time and the third end time, and the second time difference information is used to indicate a time difference between a time zone time of the front-end device in the second time period and the standard time;
The sending module 1003 is further configured to send the second time difference information to the terminal.
In one possible implementation manner, the obtaining module 1002 is configured to query a time zone information table according to the third start time and the third end time to obtain the time difference information, where the time zone information table is used to record the time difference information of the front-end device in at least one time period.
In one possible implementation, the obtaining module 1002 is further configured to obtain, for storage, data collected by the front-end device according to a data collection plan, where the data collection plan includes an identifier of the front-end device, a data collection time template, and an identifier of a time zone policy, where the data collection time template is used to indicate a time period for the front-end device to collect data, and the time zone policy includes time zone information of the front-end device.
In one possible implementation, the obtaining module 1002 is further configured to obtain a time zone policy table, where the time zone policy table includes time zone policies of the server and the front-end device and corresponding policy identifications, and each time zone policy includes a policy type, a time zone, a time of entering daylight savings time, a time of exiting daylight savings time, and a time difference between daylight savings time and winter time, where the policy type includes the time zone policy of the server and the time zone policy of the front-end device.
In one possible implementation, the obtaining module 1002 is configured to:
acquiring a time zone strategy of the front-end equipment according to the identification of the time zone strategy of the front-end equipment in the data acquisition plan;
and according to the time zone strategy of the front-end equipment, the data acquired by the front-end equipment are stored in a segmented mode to obtain multiple pieces of data, the multiple pieces of data are acquired by the front-end equipment in multiple time zones, the multiple pieces of data correspond to multiple pieces of time difference information, and the time difference information corresponding to each piece of data is used for indicating the time difference between the time zone time of the front-end equipment for acquiring each piece of data and the standard time.
According to the device provided by the embodiment of the invention, when the data query request of the terminal is received, the target data, the first time difference information, and the starting time and the ending time of the target data acquired by the front-end equipment are acquired according to the identification, the first starting time and the first ending time of the front-end equipment carried in the data query request, and then returned to the terminal, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment when the target data are acquired and the standard time, so that the terminal can convert the starting time and the ending time of the target data into the time zone time of the front-end equipment according to the first time difference information and then display the time zone time of the front-end equipment. The scheme supports that the front-end equipment in different time zones is accessed to the server, the front-end equipment can be in different time zones with the server, different front-end equipment can be in different time zones, the same front-end equipment can be in different time zones in different time periods, and the data management requirement of the front-end equipment in a plurality of time zones can be met.
Fig. 11 is a schematic structural diagram of a data management device according to an embodiment of the present invention. Referring to fig. 11, the apparatus includes:
a sending module 1101, configured to send a data query request to a server, where the data query request carries an identifier of a front-end device, a first start time, and a first end time, and time types of the first start time and the first end time are standard times, and the standard times are time types of a start time and an end time of data stored by the server;
a receiving module 1102, configured to receive target data, first time difference information, and a start time and an end time of the target data, where a time period between the start time and the end time of the target data is a first time period, and the first time period is included in a time period between the first start time and the first end time, and the first time difference information is used to indicate a time difference between a time zone time of the front-end device in the first time period and the standard time;
a conversion module 1103, configured to convert, according to the first time difference information, a start time and an end time of the target data into a second start time and a second end time, where a time type of the second start time and the second end time is a time zone time of the front-end device;
A display module 1104 for displaying the target data and the second start time and the second end time.
In one possible implementation, the sending module 1101 is configured to send the data query request to the server with the input start time and end time as the first start time and the first end time when the input identification, start time, and end time of the front-end device are acquired and the time type of the input start time and end time is the standard time.
In one possible implementation manner, the sending module 1101 is further configured to send, when the input identifier of the front end device, a third start time and a third end time are acquired, the time type of the third start time and the third end time is the time zone time of the front end device, and the time difference query request carries the identifier of the front end device, the third start time and the third end time;
the receiving module 1102 is further configured to receive second time difference information sent by the server, where the second time difference information is used to indicate a time difference between a time zone time of the front end device in a second time period and the standard time, and the second time period is a time period between the third start time and the third end time;
The converting module 1103 is further configured to convert the third start time and the third end time into the first start time and the first end time according to the time difference information.
According to the device provided by the embodiment of the invention, when the data query request of the terminal is received, the target data, the first time difference information, and the starting time and the ending time of the target data acquired by the front-end equipment are acquired according to the identification, the first starting time and the first ending time of the front-end equipment carried in the data query request, and then returned to the terminal, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment when the target data are acquired and the standard time, so that the terminal can convert the starting time and the ending time of the target data into the time zone time of the front-end equipment according to the first time difference information and then display the time zone time of the front-end equipment. The scheme supports that the front-end equipment in different time zones is accessed to the server, the front-end equipment can be in different time zones with the server, different front-end equipment can be in different time zones, the same front-end equipment can be in different time zones in different time periods, and the data management requirement of the front-end equipment in a plurality of time zones can be met.
It should be noted that: in the data management device provided in the above embodiment, only the division of the above functional modules is used for illustration, and in practical application, the above functional allocation may be performed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules, so as to complete all or part of the functions described above. In addition, the data management device and the data management method provided in the foregoing embodiments belong to the same concept, and specific implementation processes of the data management device and the data management method are detailed in the method embodiments and are not repeated herein.
Fig. 12 is a schematic structural diagram of a terminal 1200 according to an embodiment of the present invention. The terminal 1200 may be: a smart phone, a tablet computer, an MP3 player (Moving Picture Experts Group Audio Layer III, motion picture expert compression standard audio plane 3), an MP4 (Moving Picture Experts Group Audio Layer IV, motion picture expert compression standard audio plane 4) player, a notebook computer, or a desktop computer. Terminal 1200 may also be referred to as a user device, portable terminal, laptop terminal, desktop terminal, etc.
In general, the terminal 1200 includes: a processor 1201 and a memory 1202.
Processor 1201 may include one or more processing cores, such as a 4-core processor, an 8-core processor, or the like. The processor 1201 may be implemented in at least one hardware form of DSP (Digital Signal Processing ), FPGA (Field-Programmable Gate Array, field programmable gate array), PLA (Programmable Logic Array ). The processor 1201 may also include a main processor, which is a processor for processing data in an awake state, also called a CPU (Central Processing Unit ), and a coprocessor; a coprocessor is a low-power processor for processing data in a standby state. In some embodiments, the processor 1201 may integrate a GPU (Graphics Processing Unit, image processor) for rendering and rendering of content required to be displayed by the display screen. In some embodiments, the processor 1201 may also include an AI (Artificial Intelligence ) processor for processing computing operations related to machine learning.
Memory 1202 may include one or more computer-readable storage media, which may be non-transitory. Memory 1202 may also include high-speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In some embodiments, a non-transitory computer readable storage medium in memory 1202 is used to store at least one instruction for execution by processor 1201 to implement the data management methods provided by the method embodiments herein.
In some embodiments, the terminal 1200 may further optionally include: a peripheral interface 1203, and at least one peripheral. The processor 1201, the memory 1202, and the peripheral interface 1203 may be connected by a bus or signal lines. The individual peripheral devices may be connected to the peripheral device interface 1203 via buses, signal lines, or a circuit board. Specifically, the peripheral device includes: at least one of radio frequency circuitry 1204, a display 1205, a camera 1206, audio circuitry 1207, a positioning assembly 1208, and a power supply 1209.
The peripheral interface 1203 may be used to connect at least one peripheral device associated with an I/O (Input/Output) to the processor 1201 and the memory 1202. In some embodiments, the processor 1201, the memory 1202, and the peripheral interface 1203 are integrated on the same chip or circuit board; in some other embodiments, either or both of the processor 1201, the memory 1202, and the peripheral interface 1203 may be implemented on separate chips or circuit boards, which is not limited in this embodiment.
The Radio Frequency circuit 1204 is used for receiving and transmitting RF (Radio Frequency) signals, also called electromagnetic signals. The radio frequency circuit 1204 communicates with a communication network and other communication devices via electromagnetic signals. The radio frequency circuit 1204 converts an electrical signal into an electromagnetic signal for transmission, or converts a received electromagnetic signal into an electrical signal. Optionally, the radio frequency circuit 1204 includes: antenna systems, RF transceivers, one or more amplifiers, tuners, oscillators, digital signal processors, codec chipsets, subscriber identity module cards, and so forth. The radio frequency circuit 1204 may communicate with other terminals via at least one wireless communication protocol. The wireless communication protocol includes, but is not limited to: metropolitan area networks, various generations of mobile communication networks (2G, 3G, 4G, and 5G), wireless local area networks, and/or WiFi (Wireless Fidelity ) networks. In some embodiments, the radio frequency circuit 1204 may also include NFC (Near Field Communication ) related circuits, which are not limited in this application.
The display 1205 is used to display a UI (User Interface). The UI may include graphics, text, icons, video, and any combination thereof. When the display 1205 is a touch display, the display 1205 also has the ability to collect touch signals at or above the surface of the display 1205. The touch signal may be input as a control signal to the processor 1201 for processing. At this time, the display 1205 may also be used to provide virtual buttons and/or a virtual keyboard, also referred to as soft buttons and/or a soft keyboard. In some embodiments, the display 1205 may be one, providing a front panel of the terminal 1200; in other embodiments, the display 1205 may be at least two, respectively disposed on different surfaces of the terminal 1200 or in a folded design; in still other embodiments, the display 1205 may be a flexible display disposed on a curved surface or a folded surface of the terminal 1200. Even more, the display 1205 may be arranged in an irregular pattern that is not rectangular, i.e., a shaped screen. The display 1205 can be made of LCD (Liquid Crystal Display ), OLED (Organic Light-Emitting Diode) or other materials.
The camera assembly 1206 is used to capture images or video. Optionally, camera assembly 1206 includes a front camera and a rear camera. Typically, the front camera is disposed on the front panel of the terminal and the rear camera is disposed on the rear surface of the terminal. In some embodiments, the at least two rear cameras are any one of a main camera, a depth camera, a wide-angle camera and a tele camera, so as to realize that the main camera and the depth camera are fused to realize a background blurring function, and the main camera and the wide-angle camera are fused to realize a panoramic shooting and Virtual Reality (VR) shooting function or other fusion shooting functions. In some embodiments, camera assembly 1206 may also include a flash. The flash lamp can be a single-color temperature flash lamp or a double-color temperature flash lamp. The dual-color temperature flash lamp refers to a combination of a warm light flash lamp and a cold light flash lamp, and can be used for light compensation under different color temperatures.
The audio circuitry 1207 may include a microphone and a speaker. The microphone is used for collecting sound waves of a user and the environment, converting the sound waves into electric signals, and inputting the electric signals to the processor 1201 for processing, or inputting the electric signals to the radio frequency circuit 1204 for voice communication. For purposes of stereo acquisition or noise reduction, a plurality of microphones may be respectively disposed at different portions of the terminal 1200. The microphone may also be an array microphone or an omni-directional pickup microphone. The speaker is used to convert electrical signals from the processor 1201 or the radio frequency circuit 1204 into sound waves. The speaker may be a conventional thin film speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, not only the electric signal can be converted into a sound wave audible to humans, but also the electric signal can be converted into a sound wave inaudible to humans for ranging and other purposes. In some embodiments, the audio circuitry 1207 may also include a headphone jack.
The positioning component 1208 is used to position the current geographic location of the terminal 1200 to enable navigation or LBS (Location Based Service, location-based services). The positioning component 1208 may be a positioning component based on the united states GPS (Global Positioning System ), the beidou system of china, the grainer system of russia, or the galileo system of the european union.
The power supply 1209 is used to power the various components in the terminal 1200. The power source 1209 may be an alternating current, a direct current, a disposable battery, or a rechargeable battery. When the power source 1209 includes a rechargeable battery, the rechargeable battery may support wired or wireless charging. The rechargeable battery may also be used to support fast charge technology.
In some embodiments, terminal 1200 also includes one or more sensors 1210. The one or more sensors 1210 include, but are not limited to: acceleration sensor 1211, gyroscope sensor 1212, pressure sensor 1213, fingerprint sensor 1214, optical sensor 1215, and proximity sensor 1216.
The acceleration sensor 1211 may detect the magnitudes of accelerations on three coordinate axes of the coordinate system established with the terminal 1200. For example, the acceleration sensor 1211 may be used to detect components of gravitational acceleration in three coordinate axes. The processor 1201 may control the touch display 1205 to display a user interface in a landscape view or a portrait view based on the gravitational acceleration signal acquired by the acceleration sensor 1211. The acceleration sensor 1211 may also be used for the acquisition of motion data of a game or a user.
The gyro sensor 1212 may detect a body direction and a rotation angle of the terminal 1200, and the gyro sensor 1212 may collect a 3D motion of the user on the terminal 1200 in cooperation with the acceleration sensor 1211. The processor 1201 may implement the following functions based on the data collected by the gyro sensor 1212: motion sensing (e.g., changing UI according to a tilting operation by a user), image stabilization at shooting, game control, and inertial navigation.
The pressure sensor 1213 may be disposed at a side frame of the terminal 1200 and/or at a lower layer of the touch display 1205. When the pressure sensor 1213 is provided at a side frame of the terminal 1200, a grip signal of the terminal 1200 by a user may be detected, and the processor 1201 performs a left-right hand recognition or a shortcut operation according to the grip signal collected by the pressure sensor 1213. When the pressure sensor 1213 is disposed at the lower layer of the touch display 1205, the processor 1201 performs control of the operability control on the UI interface according to the pressure operation of the user on the touch display 1205. The operability controls include at least one of a button control, a scroll bar control, an icon control, and a menu control.
The fingerprint sensor 1214 is used to collect a fingerprint of the user, and the processor 1201 identifies the identity of the user based on the fingerprint collected by the fingerprint sensor 1214, or the fingerprint sensor 1214 identifies the identity of the user based on the fingerprint collected. Upon recognizing that the user's identity is a trusted identity, the processor 1201 authorizes the user to perform relevant sensitive operations including unlocking the screen, viewing encrypted information, downloading software, paying for and changing settings, etc. The fingerprint sensor 1214 may be provided on the front, back or side of the terminal 1200. When a physical key or a vendor Logo is provided on the terminal 1200, the fingerprint sensor 1214 may be integrated with the physical key or the vendor Logo.
The optical sensor 1215 is used to collect the ambient light intensity. In one embodiment, the processor 1201 may control the display brightness of the touch display 1205 based on the ambient light intensity collected by the optical sensor 1215. Specifically, when the intensity of the ambient light is high, the display brightness of the touch display screen 1205 is turned up; when the ambient light intensity is low, the display brightness of the touch display screen 1205 is turned down. In another embodiment, processor 1201 may also dynamically adjust the shooting parameters of camera assembly 1206 based on the intensity of ambient light collected by optical sensor 1215.
A proximity sensor 1216, also referred to as a distance sensor, is typically provided on the front panel of the terminal 1200. The proximity sensor 1216 is used to collect the distance between the user and the front of the terminal 1200. In one embodiment, when the proximity sensor 1216 detects that the distance between the user and the front face of the terminal 1200 gradually decreases, the processor 1201 controls the touch display 1205 to switch from the bright screen state to the off screen state; when the proximity sensor 1216 detects that the distance between the user and the front surface of the terminal 1200 gradually increases, the touch display 1205 is controlled by the processor 1201 to switch from the off-screen state to the on-screen state.
It will be appreciated by those skilled in the art that the structure shown in fig. 12 is not limiting and that more or fewer components than shown may be included or certain components may be combined or a different arrangement of components may be employed.
Fig. 13 is a schematic structural diagram of a server 1300 according to an embodiment of the present invention, where the server 1300 may have a relatively large difference due to different configurations or performances, and may include one or more processors (Central Processing Units, CPU) 1301 and one or more memories 1302, where the memories 1302 store at least one instruction, and the at least one instruction is loaded and executed by the processor 1301 to implement the methods provided in the foregoing method embodiments. Of course, the server may also have a wired or wireless network interface, a keyboard, an input/output interface, and other components for implementing the functions of the device, which are not described herein.
In an exemplary embodiment, a computer readable storage medium storing at least one instruction, such as a memory storing at least one instruction, that when executed by a processor implements the data management method of the above embodiment is also provided. For example, the computer readable storage medium may be Read-Only Memory (ROM), random access Memory (Random Access Memory, RAM), compact disk Read-Only Memory (CD-ROM), magnetic tape, floppy disk, optical data storage device, etc.
Those of ordinary skill in the art will appreciate that all or a portion of the steps implementing the above embodiments may be implemented by hardware, or may be implemented by a program to instruct related hardware, where the program may be stored in a computer readable storage medium, where the storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.
The foregoing description of the preferred embodiments of the invention is not intended to be limiting, but rather is intended to cover all modifications, equivalents, alternatives, and improvements that fall within the spirit and scope of the invention.

Claims (18)

1. A data management method, applied to a server, the method comprising:
receiving a time difference inquiry request of a terminal, wherein the time difference inquiry request is sent by the terminal when the terminal acquires an input identifier of front-end equipment, a third starting time and a third ending time, and the time types of the third starting time and the third ending time are time zone time of the front-end equipment;
inquiring a time zone information table according to the third starting time and the third ending time to obtain second time difference information of the front-end equipment in a second time period; the time zone information table is used for recording time difference information of the front-end equipment in at least one time period, and when the time zone strategy of the front-end equipment is changed, a change record of the front-end equipment is added in the time zone information table, wherein the change record comprises the changed time period and corresponding time difference information; the second time period is a time period between the third starting time and the third ending time, the second time difference information is used for indicating a time difference between the time zone time of the front-end equipment in the second time period and a standard time, and the standard time is a time type of the starting time and the ending time of the data stored by the server;
Transmitting the second time difference information to the terminal; the terminal is used for converting the third starting time and the third ending time into first starting time and first ending time according to the second time difference information, and sending a data query request to the server;
receiving a data query request of the terminal, wherein the data query request carries an identifier of the front-end equipment, the first starting time and the first ending time, and the time types of the first starting time and the first ending time are the standard time;
acquiring target data, first time difference information, and starting time and ending time of the target data acquired by the front-end equipment according to the identification of the front-end equipment, the first starting time and the first ending time, wherein a time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time;
Transmitting the target data, the first time difference information and the start time and the end time of the target data to the terminal; the terminal is used for converting the starting time and the ending time of the target data into second starting time and second ending time according to the first time difference information, and the time types of the second starting time and the second ending time are time zone time of the front-end equipment.
2. The method according to claim 1, wherein the obtaining the target data collected by the front-end device, the first time difference information, and the start time and the end time of the target data according to the identification of the front-end device, the first start time, and the first end time includes:
inquiring stored data segments, time difference information corresponding to each data segment, and starting time and ending time of each data segment according to the identification of the front-end equipment, the first starting time and the first ending time;
when the time period between the starting time and the ending time of any data segment is inquired to be included in the time period between the first starting time and the first ending time, the inquired data segment is used as the target data, the time difference information corresponding to the inquired data segment is used as the first time difference information, and the starting time and the ending time of the inquired data segment are used as the starting time and the ending time of the target data.
3. The method of claim 1, wherein prior to receiving the data query request from the terminal, the method further comprises:
and acquiring and storing the data acquired by the front-end equipment according to a data acquisition plan, wherein the data acquisition plan comprises an identifier of the front-end equipment, a data acquisition time template and an identifier of a time zone strategy, the data acquisition time template is used for indicating a time period for the front-end equipment to acquire data, and the time zone strategy comprises time zone information of the front-end equipment.
4. A method according to claim 3, wherein the method further comprises, prior to acquiring the data collected by the head-end equipment for storage according to a data collection plan:
obtaining a time zone policy table, wherein the time zone policy table comprises time zone policies of the server and the front-end equipment and corresponding policy identifications, each time zone policy comprises a policy type, a time zone, time entering into summer time, time exiting from summer time and time difference between the summer time and winter time, and the policy type comprises the time zone policies of the server and the time zone policies of the front-end equipment.
5. The method of claim 4, wherein the acquiring the data collected by the front-end device for storage according to a data collection plan comprises:
acquiring a time zone strategy of the front-end equipment according to the identification of the time zone strategy of the front-end equipment in the data acquisition plan;
and according to the time zone strategy of the front-end equipment, the data acquired by the front-end equipment are stored in a segmented mode to obtain multiple segments of data, the multiple segments of data are acquired by the front-end equipment in multiple time zones, the multiple segments of data correspond to multiple pieces of time difference information, and the time difference information corresponding to each segment of data is used for indicating the time difference between the time zone time of the front-end equipment for acquiring each segment of data and the standard time.
6. A data management method, applied to a terminal, the method comprising:
when the input identification, the third starting time and the third ending time of the front-end equipment are acquired, sending a time difference inquiry request to a server, wherein the time types of the third starting time and the third ending time are the time zone time of the front-end equipment; the server is used for inquiring a time zone information table according to the third starting time and the third ending time to obtain second time difference information of the front-end equipment in a second time period; when the time zone policy of the front-end equipment is changed, adding a change record of the front-end equipment in the time zone information table; the time zone information table is used for recording time difference information of the front-end equipment in at least one time period, and the change record comprises a changed time period and corresponding time difference information; the second time period is a time period between the third starting time and the third ending time, the second time difference information is used for indicating a time difference between the time zone time of the front-end equipment in the second time period and a standard time, and the standard time is a time type of the starting time and the ending time of the data stored by the server;
Receiving second time difference information sent by the server, and converting the third starting time and the third ending time into first starting time and first ending time according to the second time difference information;
sending a data query request to the server, wherein the data query request carries the identifier of the front-end equipment, the first starting time and the first ending time, and the time types of the first starting time and the first ending time are the standard time;
receiving target data, first time difference information and starting time and ending time of the target data, wherein the time period between the starting time and the ending time of the target data is a first time period, the first time period is included in the time period between the first starting time and the first ending time, and the first time difference information is used for indicating the time difference between the time zone time of the front-end equipment in the first time period and the standard time;
according to the first time difference information, converting the starting time and the ending time of the target data into a second starting time and a second ending time, wherein the time types of the second starting time and the second ending time are time zone time of the front-end equipment;
Displaying the target data and the second start time and the second end time.
7. The method of claim 6, wherein the sending a data query request to the server comprises:
when the input identification, start time and end time of the front-end equipment are acquired and the time types of the input start time and end time are the standard time, the input start time and end time are taken as the first start time and the first end time, and the data query request is sent to the server.
8. A data management apparatus for use with a server, the apparatus comprising:
the receiving module is used for receiving a time difference inquiry request of a terminal, wherein the time difference inquiry request is sent by the terminal when the terminal acquires the input identification of the front-end equipment, a third starting time and a third ending time, and the time types of the third starting time and the third ending time are the time zone time of the front-end equipment;
the acquisition module is used for inquiring a time zone information table according to the third starting time and the third ending time to acquire second time difference information of the front-end equipment in a second time period; the time zone information table is used for recording time difference information of the front-end equipment in at least one time period, and when the time zone strategy of the front-end equipment is changed, a change record of the front-end equipment is added in the time zone information table, wherein the change record comprises the changed time period and corresponding time difference information; the second time period is a time period between the third starting time and the third ending time, the second time difference information is used for indicating a time difference between the time zone time of the front-end equipment in the second time period and a standard time, and the standard time is a time type of the starting time and the ending time of the data stored by the server;
The sending module is used for sending the second time difference information to the terminal; the terminal is used for converting the third starting time and the third ending time into first starting time and first ending time according to the second time difference information, and sending a data query request to the server;
the receiving module is further configured to receive a data query request of the terminal, where the data query request carries an identifier of the front-end device, the first start time and the first end time, and time types of the first start time and the first end time are the standard time;
the acquiring module is further configured to acquire, according to the identifier of the front-end device, the first start time and the first end time, target data acquired by the front-end device, first time difference information, and start time and end time of the target data, where a time period between the start time and the end time of the target data is a first time period, the first time period is included in a time period between the first start time and the first end time, and the first time difference information is used to indicate a time zone time of the front-end device in the first time period and a time difference between the standard time;
The sending module is further configured to send the target data, the first time difference information, and a start time and an end time of the target data to the terminal; the terminal is used for converting the starting time and the ending time of the target data into second starting time and second ending time according to the first time difference information, and the time types of the second starting time and the second ending time are time zone time of the front-end equipment.
9. The apparatus of claim 8, wherein the acquisition module is configured to:
inquiring stored data segments, time difference information corresponding to each data segment, and starting time and ending time of each data segment according to the identification of the front-end equipment, the first starting time and the first ending time;
when the time period between the starting time and the ending time of any data segment is inquired to be included in the time period between the first starting time and the first ending time, the inquired data segment is used as the target data, the time difference information corresponding to the inquired data segment is used as the first time difference information, and the starting time and the ending time of the inquired data segment are used as the starting time and the ending time of the target data.
10. The apparatus of claim 8, wherein the acquisition module is further configured to acquire the data acquired by the front-end device for storage according to a data acquisition plan, the data acquisition plan including an identification of the front-end device, a data acquisition time template, and an identification of a time zone policy, the data acquisition time template being used to indicate a time period for the front-end device to acquire data, the time zone policy including time zone information for the front-end device.
11. The apparatus of claim 10, wherein the obtaining module is further configured to obtain a time zone policy table, the time zone policy table comprising time zone policies of the server and the front-end device and corresponding policy identifications, each time zone policy comprising a policy type, a time zone, a time to enter daylight savings time, a time to exit daylight savings time, and a time difference between daylight savings time and winter time, the policy type comprising the time zone policies of the server and the time zone policies of the front-end device.
12. The apparatus of claim 11, wherein the acquisition module is configured to:
acquiring a time zone strategy of the front-end equipment according to the identification of the time zone strategy of the front-end equipment in the data acquisition plan;
And according to the time zone strategy of the front-end equipment, the data acquired by the front-end equipment are stored in a segmented mode to obtain multiple segments of data, the multiple segments of data are acquired by the front-end equipment in multiple time zones, the multiple segments of data correspond to multiple pieces of time difference information, and the time difference information corresponding to each segment of data is used for indicating the time difference between the time zone time of the front-end equipment for acquiring each segment of data and the standard time.
13. A data management apparatus for use in a terminal, the apparatus comprising:
the sending module is used for sending a time difference inquiry request to the server when the input identification, the third starting time and the third ending time of the front-end equipment are acquired, wherein the time types of the third starting time and the third ending time are the time zone time of the front-end equipment; the server is used for inquiring a time zone information table according to the third starting time and the third ending time to obtain second time difference information of the front-end equipment in a second time period; when the time zone policy of the front-end equipment is changed, adding a change record of the front-end equipment in the time zone information table; the time zone information table is used for recording time difference information of the front-end equipment in at least one time period, and the change record comprises a changed time period and corresponding time difference information; the second time period is a time period between the third starting time and the third ending time, the second time difference information is used for indicating a time difference between the time zone time of the front-end equipment in the second time period and a standard time, and the standard time is a time type of the starting time and the ending time of the data stored by the server;
The receiving module is used for receiving second time difference information sent by the server and converting the third starting time and the third ending time into first starting time and first ending time according to the second time difference information;
the sending module is further configured to send a data query request to the server, where the data query request carries an identifier of the front-end device, the first start time and the first end time, and time types of the first start time and the first end time are the standard time;
the receiving module is further configured to receive target data, first time difference information, and start time and end time of the target data, where a time period between the start time and the end time of the target data is a first time period, the first time period is included in a time period between the first start time and the first end time, and the first time difference information is used to indicate a time difference between a time zone time of the front-end device in the first time period and the standard time;
the conversion module is used for converting the starting time and the ending time of the target data into second starting time and second ending time according to the first time difference information, and the time types of the second starting time and the second ending time are time zone time of the front-end equipment;
And the display module is used for displaying the target data, the second starting time and the second ending time.
14. The apparatus of claim 13, wherein the sending module is configured to send the data query request to the server with the input start time and end time as the first start time and the first end time when the input identification, start time, and end time of the front-end device are obtained and the time type of the input start time and end time is the standard time.
15. A data management system is characterized in that the system comprises a front-end device, a server and a terminal,
the front-end equipment is used for collecting data and sending the collected data to the server;
the server is used for storing the data acquired by the front-end equipment by adopting standard time, wherein the standard time is the time type of the starting time and the ending time of the data stored by the server;
the terminal is used for sending a time difference inquiry request to the server when the input identification, third starting time and third ending time of the front-end equipment are acquired, wherein the time types of the third starting time and the third ending time are the time zone time of the front-end equipment;
The server is further configured to query a time zone information table according to the third start time and the third end time, and obtain second time difference information of the front-end device in a second time period; when the time zone policy of the front-end equipment is changed, adding a change record of the front-end equipment in the time zone information table; the time zone information table is used for recording time difference information of the front-end equipment in at least one time period, and the change record comprises a changed time period and corresponding time difference information; the second time period is a time period between the third starting time and the third ending time, and the second time difference information is used for indicating a time difference between the time zone time of the front-end equipment in the second time period and the standard time;
the server is further configured to send the second time difference information to the terminal;
the terminal is further configured to convert the third start time and the third end time into a first start time and a first end time according to the second time difference information;
the terminal is further configured to send a data query request to the server, where the data query request carries an identifier of the front-end device, the first start time and the first end time, and time types of the first start time and the first end time are the standard time;
The server is further configured to, when receiving a data query request of the terminal, obtain, according to the identifier of the front-end device, the first start time and the first end time, target data acquired by the front-end device, first time difference information, and start time and end time of the target data, and send the target data to the terminal, where a time period between the start time and the end time of the target data is a first time period, and the first time period is included in a time period between the first start time and the first end time, and the first time difference information is used to indicate a time difference between a time zone time of the front-end device in the first time period and the standard time;
the terminal is further configured to, when receiving the target data, the first time difference information, and the start time and the end time of the target data sent by the server, convert the start time and the end time of the target data into a second start time and a second end time according to the first time difference information, where the time types of the second start time and the second end time are time zone times of the front-end device, and display the target data and the second start time and the second end time.
16. A server comprising a processor and a memory; the memory is used for storing at least one instruction; the processor being configured to execute at least one instruction stored on the memory to perform the method steps of any one of claims 1-5.
17. A terminal comprising a processor and a memory; the memory is used for storing at least one instruction; the processor being adapted to execute at least one instruction stored on the memory to perform the method steps of any one of claims 6-7.
18. A computer readable storage medium, characterized in that at least one instruction is stored in the computer readable storage medium, which at least one instruction, when executed by a processor, implements the method steps of any of claims 1-7.
CN201811289487.4A 2018-10-31 2018-10-31 Data management method, device and system Active CN111125436B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201811289487.4A CN111125436B (en) 2018-10-31 2018-10-31 Data management method, device and system
PCT/CN2019/114426 WO2020088542A1 (en) 2018-10-31 2019-10-30 Data management method, apparatus and system, and server, terminal and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811289487.4A CN111125436B (en) 2018-10-31 2018-10-31 Data management method, device and system

Publications (2)

Publication Number Publication Date
CN111125436A CN111125436A (en) 2020-05-08
CN111125436B true CN111125436B (en) 2023-08-08

Family

ID=70462990

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811289487.4A Active CN111125436B (en) 2018-10-31 2018-10-31 Data management method, device and system

Country Status (2)

Country Link
CN (1) CN111125436B (en)
WO (1) WO2020088542A1 (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111683215B (en) * 2020-06-05 2023-03-24 杭州海康威视数字技术股份有限公司 Video playback method and device, electronic equipment and computer readable storage medium
CN112818029A (en) * 2021-01-13 2021-05-18 远景智能国际私人投资有限公司 Method, device and equipment for querying time sequence data and readable storage medium
WO2023024073A1 (en) * 2021-08-27 2023-03-02 Oppo广东移动通信有限公司 Wireless communication method, terminal device and network device
CN115174292B (en) * 2022-05-25 2024-03-22 青岛海尔科技有限公司 Equipment data management platform

Citations (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101174982A (en) * 2007-11-16 2008-05-07 华为技术有限公司 Method, device and system for implementing multi-time zone data information unification
CN101630426A (en) * 2008-07-18 2010-01-20 株式会社山武 Process monitoring system and method
JP2010230341A (en) * 2009-03-26 2010-10-14 Mizuho Information & Research Institute Inc Information processing system, method of control and program, and global cash management system
CN101873456A (en) * 2009-04-24 2010-10-27 上海乐金广电电子有限公司 Video recording data reproduction device on digital video recorder and method thereof
CN102244758A (en) * 2011-07-08 2011-11-16 杭州华三通信技术有限公司 Video-recording-file-based data acquisition method and equipment
CN102982226A (en) * 2007-08-10 2013-03-20 施曼信医疗Asd公司 Method and system of communication between server and a plurality of medical devices
CN103092959A (en) * 2013-01-18 2013-05-08 中兴通讯股份有限公司 Processing method and device for task time zone
CN103986944A (en) * 2014-06-05 2014-08-13 西安诺瓦电子科技有限公司 Display terminal cluster broadcast control method, display terminal and display terminal cluster management end
JP2015014515A (en) * 2013-07-05 2015-01-22 キヤノン株式会社 Cycle time zone setting method when site cycle time is acquired from user
CN105338297A (en) * 2014-08-11 2016-02-17 杭州海康威视系统技术有限公司 Video data storage and playback system, device and method
CN105989048A (en) * 2015-02-05 2016-10-05 浙江大华技术股份有限公司 Data record processing method, equipment and system
CN106487895A (en) * 2016-10-14 2017-03-08 深圳市欧瑞博电子有限公司 Time control method and device
CN107657058A (en) * 2017-10-19 2018-02-02 上海大汉三通数据通信有限公司 The querying method and relevant apparatus of a kind of data
CN107919933A (en) * 2017-11-17 2018-04-17 深圳市泉眼网络科技有限公司 A kind of method, apparatus, mobile terminal and the storage medium of time renewal
CN108206933A (en) * 2016-12-16 2018-06-26 杭州海康威视数字技术股份有限公司 A kind of video data acquisition methods and device based on video cloud storage system
CN108495183A (en) * 2018-04-09 2018-09-04 广州酷狗计算机科技有限公司 The method and apparatus for showing album information

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7676288B2 (en) * 2006-06-23 2010-03-09 Invensys Systems, Inc. Presenting continuous timestamped time-series data values for observed supervisory control and manufacturing/production parameters
US9361594B2 (en) * 2012-09-24 2016-06-07 Sap Se Generating time slot for managing time across multiple time zones
WO2016065617A1 (en) * 2014-10-31 2016-05-06 Splunk Inc. Automatically adjusting timestamps from remote systems based on time zone differences

Patent Citations (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102982226A (en) * 2007-08-10 2013-03-20 施曼信医疗Asd公司 Method and system of communication between server and a plurality of medical devices
CN101174982A (en) * 2007-11-16 2008-05-07 华为技术有限公司 Method, device and system for implementing multi-time zone data information unification
CN101630426A (en) * 2008-07-18 2010-01-20 株式会社山武 Process monitoring system and method
JP2010230341A (en) * 2009-03-26 2010-10-14 Mizuho Information & Research Institute Inc Information processing system, method of control and program, and global cash management system
CN101873456A (en) * 2009-04-24 2010-10-27 上海乐金广电电子有限公司 Video recording data reproduction device on digital video recorder and method thereof
CN102244758A (en) * 2011-07-08 2011-11-16 杭州华三通信技术有限公司 Video-recording-file-based data acquisition method and equipment
CN103092959A (en) * 2013-01-18 2013-05-08 中兴通讯股份有限公司 Processing method and device for task time zone
JP2015014515A (en) * 2013-07-05 2015-01-22 キヤノン株式会社 Cycle time zone setting method when site cycle time is acquired from user
CN103986944A (en) * 2014-06-05 2014-08-13 西安诺瓦电子科技有限公司 Display terminal cluster broadcast control method, display terminal and display terminal cluster management end
CN105338297A (en) * 2014-08-11 2016-02-17 杭州海康威视系统技术有限公司 Video data storage and playback system, device and method
CN105989048A (en) * 2015-02-05 2016-10-05 浙江大华技术股份有限公司 Data record processing method, equipment and system
CN106487895A (en) * 2016-10-14 2017-03-08 深圳市欧瑞博电子有限公司 Time control method and device
CN108206933A (en) * 2016-12-16 2018-06-26 杭州海康威视数字技术股份有限公司 A kind of video data acquisition methods and device based on video cloud storage system
CN107657058A (en) * 2017-10-19 2018-02-02 上海大汉三通数据通信有限公司 The querying method and relevant apparatus of a kind of data
CN107919933A (en) * 2017-11-17 2018-04-17 深圳市泉眼网络科技有限公司 A kind of method, apparatus, mobile terminal and the storage medium of time renewal
CN108495183A (en) * 2018-04-09 2018-09-04 广州酷狗计算机科技有限公司 The method and apparatus for showing album information

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
无线网状网信标时钟同步系统设计;徐卫军;焦蓉;;计算机工程与设计(第12期);全文 *

Also Published As

Publication number Publication date
WO2020088542A1 (en) 2020-05-07
CN111125436A (en) 2020-05-08

Similar Documents

Publication Publication Date Title
CN110674022B (en) Behavior data acquisition method and device and storage medium
CN110841285B (en) Interface element display method and device, computer equipment and storage medium
CN111125436B (en) Data management method, device and system
CN110278464B (en) Method and device for displaying list
CN112751679B (en) Instant messaging message processing method, terminal and server
CN111913679A (en) Method, device, equipment and storage medium for establishing wireless screen projection connection
CN110471614B (en) Method for storing data, method and device for detecting terminal
CN111385525B (en) Video monitoring method, device, terminal and system
CN108401194B (en) Time stamp determination method, apparatus and computer-readable storage medium
CN112612539B (en) Data model unloading method and device, electronic equipment and storage medium
CN111008083B (en) Page communication method and device, electronic equipment and storage medium
CN112181915B (en) Method, device, terminal and storage medium for executing service
CN111428080B (en) Video file storage method, video file search method and video file storage device
CN113099378B (en) Positioning method, device, equipment and storage medium
CN112597417B (en) Page updating method and device, electronic equipment and storage medium
CN112995587B (en) Electronic equipment monitoring method, system, computer equipment and storage medium
CN112988254B (en) Method, device and equipment for managing hardware equipment
CN112529871B (en) Method and device for evaluating image and computer storage medium
CN111064657B (en) Method, device and system for grouping concerned accounts
CN110336881B (en) Method and device for executing service processing request
CN113935678A (en) Method, device, equipment and storage medium for determining multiple distribution terminals held by distributor
CN107948171B (en) User account management method and device
CN112132472A (en) Resource management method and device, electronic equipment and computer readable storage medium
CN112135256A (en) Method, device and equipment for determining movement track and readable storage medium
CN113220935B (en) Video data storage and query 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
GR01 Patent grant
GR01 Patent grant