CN111078680A - Form information processing method and device, electronic equipment and readable storage medium - Google Patents
Form information processing method and device, electronic equipment and readable storage medium Download PDFInfo
- Publication number
- CN111078680A CN111078680A CN201811216827.0A CN201811216827A CN111078680A CN 111078680 A CN111078680 A CN 111078680A CN 201811216827 A CN201811216827 A CN 201811216827A CN 111078680 A CN111078680 A CN 111078680A
- Authority
- CN
- China
- Prior art keywords
- recording period
- information
- recording
- storage
- target
- 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.)
- Granted
Links
Images
Abstract
The application provides a table information processing method, a table information processing device, an electronic device and a readable storage medium, wherein the method comprises the following steps: generating a first table with a first quantity and a second table with a second quantity according to a table information configuration instruction, wherein index information of related first tables is recorded in the second tables, at least one first table is related to a plurality of second tables, and the first quantity is smaller than the second quantity; storing the first table and the second table. The method can reduce the storage of repeated information and reduce the waste of storage resources.
Description
Technical Field
The present disclosure relates to data processing technologies, and in particular, to a method and an apparatus for processing table information, an electronic device, and a readable storage medium.
Background
Recording information through a spreadsheet is a common form of information recording, and is widely used in daily work and life.
However, practice shows that for electronic forms such as a class schedule and a work schedule (e.g. a shift schedule), there often exist many repeated information between forms on different dates, which results in a large amount of storage space occupied when storing data of the electronic forms, and waste of storage space.
Disclosure of Invention
In view of the above, the present application provides a table information method, apparatus, electronic device and readable storage medium.
Specifically, the method is realized through the following technical scheme:
according to a first aspect of embodiments of the present application, there is provided a table information method, including:
generating a first table with a first quantity and a second table with a second quantity according to a table information configuration instruction, wherein index information of related first tables is recorded in the second tables, at least one first table is related to a plurality of second tables, and the first quantity is smaller than the second quantity;
storing the first table and the second table.
Optionally, the storing the first table and the second table includes:
storing the first table to a first table storage area and storing the second table to a second table storage area;
the second table storage area is also stored with table head information, one piece of table head information is related to the second table in one recording period, and the table head information records the index of the related second table, the starting time and the ending time of the recording period.
Optionally, the second tables in any recording period are stored continuously, and the index of the associated second table of the header information record includes the storage start position of the first second table in the associated recording period.
Optionally, the recording period includes at least one level of sub-recording periods, and the lengths of the second tables in the sub-recording periods of the same level are the same.
Optionally, the header information further records the number of each respective sub-recording period included in the recording period.
Optionally, the method further comprises:
when a table information search request aiming at a target sub-recording period in a target recording period is received, determining the header information of the target recording period according to the recording period with the earliest time of the stored table information and the time difference value between the target recording period and the recording period with the earliest time;
determining the storage position of a second table in the target sub-recording period according to the storage starting position of a first second table recorded in the header information of the target recording period and the offset corresponding to the target sub-recording period;
searching a second table in the target sub-recording period according to the storage position of the second table in the target sub-recording period;
searching the first table associated with each second table according to the index information of the first table recorded in the second table in the target sub-recording period;
and returning the searched second table and the associated first table.
According to a second aspect of embodiments of the present application, there is provided a form information processing apparatus including:
the generating unit is used for generating a first table with a first quantity and a second table with a second quantity according to a table information configuration instruction, wherein index information of the associated first table is recorded in the second table, at least one first table is associated with a plurality of second tables, and the first quantity is smaller than the second quantity;
a storage unit for storing the first table and the second table.
Optionally, the storage unit is specifically configured to store the first table in a first table storage area, and store the second table in a second table storage area;
the second table storage area is also stored with table head information, one piece of table head information is related to the second table in one recording period, and the table head information records the index of the related second table, the starting time and the ending time of the recording period.
Optionally, the second tables in any recording period are stored continuously, and the index of the associated second table of the header information record includes the storage start position of the first second table in the associated recording period.
Optionally, the recording period includes at least one level of sub-recording periods, and the lengths of the second tables in the sub-recording periods of the same level are the same.
Optionally, the header information further records the number of each respective sub-recording period included in the recording period.
Optionally, the apparatus further comprises:
a searching unit, configured to, when a table information search request for a target sub-recording period within a target recording period is received, determine header information of the target recording period according to a recording period of the stored table information at the earliest time and a time difference between the target recording period and the recording period at the earliest time;
determining the storage position of a second table in the target sub-recording period according to the storage starting position of a first second table recorded in the header information of the target recording period and the offset corresponding to the target sub-recording period;
searching a second table in the target sub-recording period according to the storage position of the second table in the target sub-recording period;
searching the first table associated with each second table according to the index information of the first table recorded in the second table in the target sub-recording period;
and returning the searched second table and the associated first table.
According to a third aspect of the embodiments of the present application, there is provided an electronic device, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus;
a memory for storing a computer program;
and the processor is used for realizing the table information processing method when executing the program stored in the memory.
According to a fourth aspect of embodiments of the present application, there is provided a machine-readable storage medium having stored therein a computer program which, when executed by a processor, implements the above-described table information processing method.
According to the table information processing method, when the table is generated, the table is divided into the first table and the second table according to the repetition probability of the information in the table, and one first table can be associated with a plurality of second tables, so that when the table information is stored, only one first table and the associated plurality of second tables are needed to be stored for a plurality of tables with repeated information, the storage of the repeated information is reduced, and the waste of storage resources is reduced.
Drawings
FIG. 1 is a flow chart diagram illustrating a method for processing tabular information in accordance with an exemplary embodiment of the present application;
FIG. 2 is a diagram illustrating a division of a tablet storage area according to an exemplary embodiment of the present application;
FIG. 3 is a diagram illustrating the location of schedule information according to an exemplary embodiment of the present application;
fig. 4 is a schematic structural diagram of a form information processing apparatus according to an exemplary embodiment of the present application;
fig. 5 is a schematic structural diagram of a form information processing apparatus according to still another exemplary embodiment of the present application;
fig. 6 is a schematic diagram illustrating a hardware structure of an electronic device according to an exemplary embodiment of the present application.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this application and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
In order to make the technical solutions provided in the embodiments of the present application better understood and make the above objects, features and advantages of the embodiments of the present application more comprehensible, the technical solutions in the embodiments of the present application are described in further detail below with reference to the accompanying drawings.
Referring to fig. 1, a flow chart of a table information processing method provided in an embodiment of the present application is schematically illustrated, where the table information processing method may be applied to a network device (hereinafter, referred to as a network device for short) that supports a table information storage and query function, and as shown in fig. 1, the table information processing method may include the following steps:
step S100, generating a first table with a first quantity and a second table with a second quantity according to the table information configuration instruction, wherein index information of the associated first table is recorded in the second table, at least one first table is associated with a plurality of second tables, and the first quantity is smaller than the second quantity.
In the embodiment of the application, in order to reduce the waste of storage resources caused by repeated information among different tables when table data is stored, different table records can be respectively used for information with more repeated information and information with less repeated information when the tables are generated, and the association among the different tables is established.
Wherein the information in the first table and the information in any second table associated with the first table together comprise complete table data.
For example, taking a class schedule as an example, for a class schedule of any lesson, a first table may be generated according to one or more of information such as a class name, teacher information, and a class content, and a second table may be generated according to information such as a start time and an end time of the class schedule.
For example, a shift schedule is taken as an example, a first table may be generated according to information of a shift operator and information of a shift task, and a second table may be generated according to information of a shift start time and a shift end time.
Accordingly, in the embodiment of the present application, when generating the table, the first table of the first number and the second table of the second number may be generated according to the table information carried in the table information configuration instruction.
And for any second table, the first table associated with the second table can be positioned through the index information recorded in the second table.
For example, the index information recorded in the second table may be a storage location of the first table associated with the second table; alternatively, the index information recorded in the second table may be the number of the first table associated with the second table (the number of the first table corresponds to the first table one by one).
It should be noted that the second table also records attribute information for performing table search, and the second table that is required can be searched by searching the attribute information, and further, the associated first table is determined according to the index in the second table, so as to obtain complete table information.
For example, taking a class schedule as an example, the attribute information may be time information of the table (e.g., day M of the nth week of 2018).
And step S110, storing the generated first table and second table.
In the embodiment of the present application, after the network device generates the first table and the second table in the manner described in step S100, the generated first table and second table may be stored.
It can be seen that, in the method flow shown in fig. 1, when the table is generated, the table is split into the first table and the second table according to the repetition probability of the information in the table, and one first table can be associated with a plurality of second tables, so that when the table information is stored, only one first table and the associated plurality of second tables need to be stored for a plurality of tables with repeated information, thereby reducing the storage of repeated information and reducing the waste of storage resources.
In one embodiment of the present application, the storing the first table and the second table may include:
storing the first table in a first table storage area and the second table in a second table storage area;
and the second table storage area also stores table header information, and one piece of table header information is related to the index of the second table in one recording period, the starting time and the ending time of the recording period.
In this embodiment, when the network device stores the table information, different storage areas may be divided for the first table and the second table, respectively, and the first table and the second table may be stored in corresponding storage areas (referred to as a first table storage area and a second table storage area, respectively, herein).
In this embodiment, when the second table is stored, some non-configuration information (which may also be referred to as default information) may be extracted from the second table to generate a header, and the header and the rest of the information of the second table are stored separately.
The non-configuration information may include a recording period (e.g., year, month), a start time and an end time of the recording period, and the like.
For example, taking a class schedule as an example, assuming that the recording period is years, for a class schedule of any year, it may include a class schedule of many weeks.
For example, taking the example of a wet year, 366 days of the whole year, 2 days of 52 weeks in total, a span between the top and bottom, and a maximum support of 54 weeks, the start time and the end time of the recording period can be determined based on the start time of the first week of the 54 weeks and the end time of the last week.
Correspondingly, the second table storage area may further store table header information, and one piece of table header information may be associated with the second table in one recording period, and the table header information may record an index of the associated second table, a start time of the recording period, and an end time of the recording period.
As an implementation manner of this embodiment, the second tables in any recording period are stored continuously, and the index of the associated second table of the header information record includes the storage start position of the first second table in the associated recording period.
In this embodiment, when storing the second tables, the second tables in any cycle may be stored continuously, and the storage start position of the first second table in the associated recording cycle is recorded in the table header information.
Correspondingly, when table information in a certain recording period needs to be searched, the storage starting position of a first second table in the second recording period can be determined according to the table head of a second table in the recording period, the second table information in the recording period can be searched according to the storage starting position, and related first table information can be searched according to index information recorded in the second table.
In one example, the recording period includes at least one level of sub-recording periods, and the lengths of the second tables in the sub-recording periods of the same level are the same.
For example, taking the recording period as the year as an example, the sub-recording period may be the week, and the lengths of the second tables in the sub-recording periods of the same level are the same (i.e. the lengths of the second tables in each week are the same).
Further, the header information may further record the number of each level sub-recording period included in the associated recording period.
For example, taking a recording period as a year and a sub-recording period as a week as an example, the number of sub-recording periods included in the recording period may be 51, 52, 53, 54, or the like.
Accordingly, in this embodiment, when the network device receives a table information search request for a target sub-recording period within a target recording period, the network device may determine header information of the target recording period according to a recording period at which the time of the stored table information is the earliest and a time difference between the target recording period and the recording period at which the time is the earliest, and determine a storage location of a second table within the target sub-recording period according to a storage start location of a first second table recorded in the header information of the target recording period and an offset corresponding to the target sub-recording period, and further, the network device may search for the second table within the target sub-recording period according to the storage location of the second table within the target sub-recording period and search for a first table associated with each second table according to index information of the first table recorded in the second table within the target sub-recording period, finally, the searched second table and the associated first table are returned, and specific implementation thereof may be described below with reference to an example, which is not described herein again in this embodiment of the present application.
In order to enable those skilled in the art to better understand the technical solutions provided by the embodiments of the present application, the technical solutions provided by the embodiments of the present application are described below with reference to specific examples.
In this embodiment, the schedule management of the recording and broadcasting host is taken as an example.
The recording and broadcasting host can be applied to a classroom video recording and remote teaching system consisting of the recording and broadcasting host, a detection camera and an image camera.
The recording and broadcasting host belongs to embedded equipment, the space size of a FLASH (FLASH memory) is limited, and the space for storing the schedule information cannot be enough. Meanwhile, the recording and broadcasting host needs to access signals and store signal coding data in real time, a large amount of storage media are needed for the data, and the recording and broadcasting host stores the data in a hard disk storage mode.
In this embodiment, the recording and broadcasting host divides the hard disk space into a small space as a schedule storage, and the small space is used as the schedule storage.
In this embodiment, the schedule data is divided into two parts: course information and schedule information. Wherein, the course information and the schedule information can be respectively shown in table 1 and table 2:
TABLE 1
| Description of the invention | |
| Course name | Recording the course name of the course information, such as: mathematics " |
| Course teacher | The teacher's name of the course information is recorded, such as: 'Zhang san' |
| Course content | Recording course content of course information, such as: 'multiplication table of nine times' |
TABLE 2
In this embodiment, table 2 information is used to represent a course, and a course includes course information, a course start time, and a course end time. Wherein:
1. the method supports multi-section class schedule configuration.
2. A week of 7 days, a maximum of 112 courses (e.g., a maximum of 16 courses for 1 day) are supported.
3. Taking the wet year as an example, 366 days are taken as the whole year of the wet year, 2 days are taken as 52 weeks in total, and the maximum support is 54 weeks counted by the front span and the back span.
In this embodiment, when storing the schedule, the schedule storage area may be divided into two parts: a schematic diagram of the lesson information storage area and the schedule information storage area can be shown in fig. 2. Wherein:
1. the course information area is used for storing a plurality of courses, and each course information corresponds to one teacher;
2. the class schedule information area comprises a class schedule head and a class schedule;
3. the school timetable area supports storage of a multi-year school timetable;
4. the school timetable head area is used for managing a school timetable and explaining the information of the year, the week number and the like of the school timetable of the year;
5. a class schedule head is arranged in each year, and corresponds to the class schedule head.
In this embodiment, please refer to fig. 3, the schedule storage area may store schedule header information of a plurality of years (the value of MAX may be set according to an actual scene), the schedule header information of any year may include an activation state (e.g., activation or deactivation) of the schedule of the year, a schedule index (e.g., a schedule information storage start position of a first lesson of a first day of a first week of the year), a year (e.g., a year of the year, e.g., 2018), a week number (e.g., a week number included in the year, for example, 2018, assuming that a last week is from the last week to 2019, month 1 and day 6, the week number included in the year is 53 weeks), a first week start date (e.g., 2018, a week start date is 2018, month 1 and day 1), and a last week end date (e.g., 2019, month 1 and day 6).
The length of the schedule information of each week is the same (the specific length can be set according to the actual scene), and the length of the schedule information of each day is the same (the specific length can be set according to the actual scene).
In this embodiment, the year information for each year in the schedule header may be updated by updating the beginning year and year number (i.e., MAX) information of the schedule header.
For example, assuming the beginning year of the schedule header is 2014, year 1 is 2014, year 2 is 2015, year … is (2013+ MAX) and year MAX.
For another example, suppose the beginning year of the schedule header is 2015, year 1 is 2015, year 2 is 2016, year … is (2015+ MAX) year MAX.
In this embodiment, when the schedule information of a certain year needs to be searched, the recording and broadcasting host can determine the schedule header information of the searched year according to the starting year of the schedule header and the time difference between the searched year and the starting year.
For example, assuming that the starting year of the schedule header is 2014, the searched year is 2018 (i.e. the schedule information of 2018 needs to be searched), the schedule header information of the searched year is the schedule header information of the 5 th year.
The recording and broadcasting host can determine the class schedule information storage initial position of the first class in the first day of the first week of the year according to the class schedule index included in the head information of the class schedule, further can search the class schedule information of the year, and search the corresponding class schedule information according to the index of the class schedule information recorded in the class schedule information, further can obtain the complete class schedule data in 2018.
Further, in this embodiment, after the schedule information of the year 2018 is searched, when schedule data of a specific week of the year 2018 needs to be searched, a corresponding offset in the schedule information of the week 2018 may be determined, a storage start position of the schedule information of the week may be determined according to a schedule information storage start position of a first lesson of a first day of a first week of the year 2018 and the offset, and then the schedule information of the week is read, and corresponding schedule information is obtained according to a schedule information index in the schedule information, so that complete schedule data of the week is finally obtained.
For example, assuming that the schedule information storage starting position of the first lesson of the first day of the first week in 2018 is a1, and the length of the schedule information of the week is L1, the storage starting position of the schedule information of the K week is a1+ (K-1) L1, the recording and broadcasting host can read the data of the length of L1 from the storage starting position, that is, the schedule information of the K week in 2018, and obtain the corresponding schedule information according to the index of the schedule information recorded in the schedule information, and further, the recording and broadcasting host can obtain the complete schedule information of the K week in 2018.
Further, in this embodiment, after the schedule information of the K week in 2018 is searched, when the schedule information of a specific day in the K week needs to be searched, the offset of the day in the K week may be determined first, and the storage start position of the schedule information of the day may be determined according to the schedule information storage start position of the K week in 2018 and the offset, and then the schedule information of the day is read, and the corresponding schedule information is obtained according to the schedule information index in the schedule information, and finally the complete schedule data of the day is obtained.
Still by taking the above example as an example, assuming that the length of the schedule information of one day is L2, after the recording and broadcasting host obtains the storage start position (assumed as a2) of the schedule of the K week of 2018, the storage start position of the schedule information of the J day of the K week is a2+ (J-1) L2, the recording and broadcasting host can read the data of the length of L2 from the storage start position, that is, the schedule information of the J day of the K week of 2018, and obtain the corresponding schedule information according to the index of the schedule information recorded in the schedule information, and further, the recording and broadcasting host can obtain the complete schedule information of the J day of the K week of 2018.
In the embodiment of the application, when the table is generated, the table is split into the first table and the second table according to the repetition probability of the information in the table, and one first table can be associated with a plurality of second tables, so that when the table information is stored, only one first table and the associated plurality of second tables are needed to be stored for a plurality of tables with repeated information, the storage of the repeated information is reduced, and the waste of storage resources is reduced.
The methods provided herein are described above. The following describes the apparatus provided in the present application:
referring to fig. 4, a schematic structural diagram of a table information processing apparatus provided in an embodiment of the present application is shown, where the table information processing apparatus may be applied to a network device in the foregoing method embodiment, and as shown in fig. 4, the table information processing apparatus may include:
a generating unit 410, configured to generate a first table of a first number and a second table of a second number according to a table information configuration instruction, where index information of an associated first table is recorded in the second table, and at least one first table exists to associate multiple second tables, the first number is smaller than the second number, and the first number is greater than or equal to 1;
a storage unit 420, configured to store the first table and the second table.
In an optional implementation manner, the storage unit 420 is specifically configured to store the first table in a first table storage area, and store the second table in a second table storage area;
the second table storage area is also stored with table head information, one piece of table head information is related to the second table in one recording period, and the table head information records the index of the related second table, the starting time and the ending time of the recording period.
In an alternative embodiment, the second tables in any recording period are stored continuously, and the index of the associated second table of the header information record includes the storage start position of the first second table in the associated recording period.
In an alternative embodiment, the recording period includes at least one level of sub-recording periods, and the lengths of the second tables in the sub-recording periods of the same level are the same.
In an alternative embodiment, the header information further records the number of each level of sub-recording periods included in the recording period.
In an alternative embodiment, as shown in fig. 5, the apparatus further comprises:
a searching unit 430, configured to, when receiving a table information search request for a target sub-recording period within a target recording period, determine header information of the target recording period according to an earliest-in-time recording period of the stored table information and a time difference between the target recording period and the earliest-in-time recording period;
determining the storage position of a second table in the target sub-recording period according to the storage starting position of a first second table recorded in the header information of the target recording period and the offset corresponding to the target sub-recording period;
searching a second table in the target sub-recording period according to the storage position of the second table in the target sub-recording period;
searching the first table associated with each second table according to the index information of the first table recorded in the second table in the target sub-recording period;
and returning the searched second table and the associated first table.
Fig. 6 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present disclosure. The electronic device may include a processor 601, a communication interface 602, a memory 603, and a communication bus 604. The processor 601, the communication interface 602, and the memory 603 communicate with each other via a communication bus 604. Wherein, the memory 603 is stored with a computer program; the processor 601 can execute the above-described table information processing method by executing the program stored on the memory 603.
The memory 603 referred to herein may be any electronic, magnetic, optical, or other physical storage device that can contain or store information such as executable instructions, data, and the like. For example, the memory 602 may be: RAM (random access memory), volatile memory, non-volatile memory, flash memory, a storage drive (e.g., a hard drive), a solid state drive, any type of storage disk (e.g., an optical disk, dvd, etc.), or similar storage medium, or a combination thereof.
The embodiment of the present application also provides a machine-readable storage medium, such as the memory 603 in fig. 6, storing a computer program, which can be executed by the processor 601 in the electronic device shown in fig. 6 to implement the above-described table information processing method.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The above description is only exemplary of the present application and should not be taken as limiting the present application, as any modification, equivalent replacement, or improvement made within the spirit and principle of the present application should be included in the scope of protection of the present application.
Claims (14)
1. A form information processing method, comprising:
generating a first table with a first quantity and a second table with a second quantity according to a table information configuration instruction, wherein index information of related first tables is recorded in the second tables, at least one first table is related to a plurality of second tables, and the first quantity is smaller than the second quantity;
storing the first table and the second table.
2. The method of claim 1, wherein storing the first table and the second table comprises:
storing the first table to a first table storage area and storing the second table to a second table storage area;
the second table storage area is also stored with table head information, one piece of table head information is related to the second table in one recording period, and the table head information records the index of the related second table, the starting time and the ending time of the recording period.
3. The method according to claim 2, wherein the second tables in any recording period are stored consecutively, and the index of the associated second table of the header information record includes a storage start position of the first second table in the associated recording period.
4. A method according to claim 3, wherein the recording period comprises at least one level of sub-recording periods, and the length of the second table in the same level of sub-recording periods is the same.
5. The method according to claim 4, wherein the header information further records the number of each respective sub-recording period included in the recording period.
6. The method according to claim 4 or 5, characterized in that the method further comprises:
when a table information search request aiming at a target sub-recording period in a target recording period is received, determining the header information of the target recording period according to the recording period with the earliest time of the stored table information and the time difference value between the target recording period and the recording period with the earliest time;
determining the storage position of a second table in the target sub-recording period according to the storage starting position of a first second table recorded in the header information of the target recording period and the offset corresponding to the target sub-recording period;
searching a second table in the target sub-recording period according to the storage position of the second table in the target sub-recording period;
searching the first table associated with each second table according to the index information of the first table recorded in the second table in the target sub-recording period;
and returning the searched second table and the associated first table.
7. A form information processing apparatus characterized by comprising:
the generating unit is used for generating a first table with a first quantity and a second table with a second quantity according to a table information configuration instruction, wherein index information of the associated first table is recorded in the second table, at least one first table is associated with a plurality of second tables, and the first quantity is smaller than the second quantity;
a storage unit for storing the first table and the second table.
8. The apparatus of claim 7,
the storage unit is specifically configured to store the first table in a first table storage area, and store the second table in a second table storage area;
the second table storage area is also stored with table head information, one piece of table head information is related to the second table in one recording period, and the table head information records the index of the related second table, the starting time and the ending time of the recording period.
9. The apparatus according to claim 8, wherein the second tables in any recording period are stored consecutively, and the index of the associated second table of the header information record includes a storage start position of the first second table in the associated recording period.
10. The apparatus of claim 9, wherein the recording period comprises at least one level of sub-recording periods, and the length of the second table in the same level of sub-recording periods is the same.
11. The method according to claim 10, wherein the header information further records the number of each respective sub-recording period included in the recording period.
12. The apparatus of claim 10 or 11, further comprising:
a searching unit, configured to, when a table information search request for a target sub-recording period within a target recording period is received, determine header information of the target recording period according to a recording period of the stored table information at the earliest time and a time difference between the target recording period and the recording period at the earliest time;
determining the storage position of a second table in the target sub-recording period according to the storage starting position of a first second table recorded in the header information of the target recording period and the offset corresponding to the target sub-recording period;
searching a second table in the target sub-recording period according to the storage position of the second table in the target sub-recording period;
searching the first table associated with each second table according to the index information of the first table recorded in the second table in the target sub-recording period;
and returning the searched second table and the associated first table.
13. An electronic device is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing mutual communication by the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the method of any one of claims 1 to 6 when executing a program stored in a memory.
14. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, which computer program, when being executed by a processor, carries out the method steps of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811216827.0A CN111078680B (en) | 2018-10-18 | 2018-10-18 | Table information processing method, apparatus, electronic device and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811216827.0A CN111078680B (en) | 2018-10-18 | 2018-10-18 | Table information processing method, apparatus, electronic device and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111078680A true CN111078680A (en) | 2020-04-28 |
| CN111078680B CN111078680B (en) | 2023-09-26 |
Family
ID=70308770
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811216827.0A Active CN111078680B (en) | 2018-10-18 | 2018-10-18 | Table information processing method, apparatus, electronic device and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111078680B (en) |
Citations (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030233347A1 (en) * | 2002-06-04 | 2003-12-18 | Weinberg Paul N. | Method and apparatus for generating and utilizing qualifiers and qualified taxonomy tables |
| US20080046462A1 (en) * | 2000-10-31 | 2008-02-21 | Kaufman Michael P | System and Method for Generating Automatic User Interface for Arbitrarily Complex or Large Databases |
| CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
| CN102723094A (en) * | 2012-06-15 | 2012-10-10 | 杭州海康威视数字技术股份有限公司 | High-reliability and easily-extensible video storage and retrieval method and system thereof |
| CN102902763A (en) * | 2012-09-21 | 2013-01-30 | 东软集团股份有限公司 | Method and device for relating and retrieving information processing data and processing information tasks |
| US20140074891A1 (en) * | 2012-09-13 | 2014-03-13 | Microsoft Corporation | Generation of a user interface based on a relational data model |
| CN103678314A (en) * | 2012-09-03 | 2014-03-26 | 中国银联股份有限公司 | Mass data processing system, equipment and method based on association rule extraction |
| US20150242453A1 (en) * | 2014-02-24 | 2015-08-27 | Fujitsu Limited | Information processing apparatus, computer-readable recording medium having stored therein data conversion program, and data conversion method |
| US9158804B1 (en) * | 2011-12-23 | 2015-10-13 | Emc Corporation | Method and system for efficient file-based backups by reverse mapping changed sectors/blocks on an NTFS volume to files |
| WO2015200405A1 (en) * | 2014-06-27 | 2015-12-30 | Microsoft Technology Licensing, Llc | Rule-based joining of foreign to primary key |
| CN105531706A (en) * | 2013-07-17 | 2016-04-27 | 索特斯波特有限公司 | Search engine for information retrieval system |
| US20160148162A1 (en) * | 2014-11-25 | 2016-05-26 | Fih (Hong Kong) Limited | Electronic device and method for searching calendar event |
| CN105718436A (en) * | 2015-12-18 | 2016-06-29 | 武汉开目信息技术有限责任公司 | New type table data management method |
| CN105934756A (en) * | 2013-10-31 | 2016-09-07 | 微软技术许可有限责任公司 | Indexing spreadsheet structural attributes for searching |
| US20170134532A1 (en) * | 2015-11-11 | 2017-05-11 | Canon Europa N.V. | Method and apparatus for serving and managing storage of data streams in a surveillance and/or monitoring system |
| US20180018361A1 (en) * | 2015-06-03 | 2018-01-18 | Huawei Technologies Co., Ltd. | Index Table Update Method, and Device |
| US20180052887A1 (en) * | 2016-08-16 | 2018-02-22 | Netscout Systems Texas, Llc | Optimized merge-sorting of data retrieved from parallel storage units |
| CN107798021A (en) * | 2016-09-07 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data correlation processing method, system and electronic equipment |
| US20180225273A1 (en) * | 2015-07-31 | 2018-08-09 | Wisetech Global Limited | Methods and systems for creating configurable forms, configuring forms and for form flow and form correlation |
| CN108510418A (en) * | 2018-05-29 | 2018-09-07 | 黑龙江省经济管理干部学院 | A kind of talent cultivation index system educational administration management system |
-
2018
- 2018-10-18 CN CN201811216827.0A patent/CN111078680B/en active Active
Patent Citations (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080046462A1 (en) * | 2000-10-31 | 2008-02-21 | Kaufman Michael P | System and Method for Generating Automatic User Interface for Arbitrarily Complex or Large Databases |
| US20030233347A1 (en) * | 2002-06-04 | 2003-12-18 | Weinberg Paul N. | Method and apparatus for generating and utilizing qualifiers and qualified taxonomy tables |
| CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
| US9158804B1 (en) * | 2011-12-23 | 2015-10-13 | Emc Corporation | Method and system for efficient file-based backups by reverse mapping changed sectors/blocks on an NTFS volume to files |
| CN102723094A (en) * | 2012-06-15 | 2012-10-10 | 杭州海康威视数字技术股份有限公司 | High-reliability and easily-extensible video storage and retrieval method and system thereof |
| CN103678314A (en) * | 2012-09-03 | 2014-03-26 | 中国银联股份有限公司 | Mass data processing system, equipment and method based on association rule extraction |
| US20140074891A1 (en) * | 2012-09-13 | 2014-03-13 | Microsoft Corporation | Generation of a user interface based on a relational data model |
| CN102902763A (en) * | 2012-09-21 | 2013-01-30 | 东软集团股份有限公司 | Method and device for relating and retrieving information processing data and processing information tasks |
| CN105531706A (en) * | 2013-07-17 | 2016-04-27 | 索特斯波特有限公司 | Search engine for information retrieval system |
| CN105934756A (en) * | 2013-10-31 | 2016-09-07 | 微软技术许可有限责任公司 | Indexing spreadsheet structural attributes for searching |
| US20150242453A1 (en) * | 2014-02-24 | 2015-08-27 | Fujitsu Limited | Information processing apparatus, computer-readable recording medium having stored therein data conversion program, and data conversion method |
| WO2015200405A1 (en) * | 2014-06-27 | 2015-12-30 | Microsoft Technology Licensing, Llc | Rule-based joining of foreign to primary key |
| US20160148162A1 (en) * | 2014-11-25 | 2016-05-26 | Fih (Hong Kong) Limited | Electronic device and method for searching calendar event |
| US20180018361A1 (en) * | 2015-06-03 | 2018-01-18 | Huawei Technologies Co., Ltd. | Index Table Update Method, and Device |
| US20180225273A1 (en) * | 2015-07-31 | 2018-08-09 | Wisetech Global Limited | Methods and systems for creating configurable forms, configuring forms and for form flow and form correlation |
| US20170134532A1 (en) * | 2015-11-11 | 2017-05-11 | Canon Europa N.V. | Method and apparatus for serving and managing storage of data streams in a surveillance and/or monitoring system |
| CN105718436A (en) * | 2015-12-18 | 2016-06-29 | 武汉开目信息技术有限责任公司 | New type table data management method |
| US20180052887A1 (en) * | 2016-08-16 | 2018-02-22 | Netscout Systems Texas, Llc | Optimized merge-sorting of data retrieved from parallel storage units |
| CN107798021A (en) * | 2016-09-07 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data correlation processing method, system and electronic equipment |
| CN108510418A (en) * | 2018-05-29 | 2018-09-07 | 黑龙江省经济管理干部学院 | A kind of talent cultivation index system educational administration management system |
Non-Patent Citations (4)
| Title |
|---|
| 崔超;: "校园一卡通系统中学生关联信息的应用研究", 北京石油化工学院学报, no. 02 * |
| 方勇;郑小林;陈德人;: "基于语义映射的可配置信息索引方法", 计算机工程, no. 15 * |
| 林晓莉;: "对图书资料存储方式自动转换的探讨", 科技情报开发与经济, no. 20 * |
| 茹峰;彭晓宏;侯立刚;宋辰;: "基于人脸识别的学生课程出勤管理系统设计", 现代电子技术, no. 01 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111078680B (en) | 2023-09-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9183268B2 (en) | Partition level backup and restore of a massively parallel processing database | |
| US9665632B2 (en) | Managing activities over time in an activity graph | |
| US9122580B2 (en) | Flash memory system and managing and collecting methods for flash memory with invalid page messages thereof | |
| US9672241B2 (en) | Representing an outlier value in a non-nullable column as null in metadata | |
| EP3079078A1 (en) | Multi-version concurrency control method in database, and database system | |
| US10275481B2 (en) | Updating of in-memory synopsis metadata for inserts in database table | |
| US20140146200A1 (en) | Entries to an electronic calendar | |
| CN105279213A (en) | Retrieval device and retrieval method for log database | |
| CN111126495B (en) | Model training method, information prediction device, storage medium and equipment | |
| CN103631937B (en) | Build method, the apparatus and system of row storage index | |
| CN106708912B (en) | Junk file identification and management method, identification device, management device and terminal | |
| US20140071135A1 (en) | Managing activities over time in an activity graph | |
| CN107391544B (en) | Processing method, device and equipment of column type storage data and computer storage medium | |
| CN105183391B (en) | The method and apparatus that data store under a kind of distributed data platform | |
| US20180096021A1 (en) | Methods and systems for improved search for data loss prevention | |
| CN107066588A (en) | A kind of database and corresponding method and apparatus | |
| US10614136B2 (en) | Method and system for managing primary field-specific entity records required by user | |
| CN106933974B (en) | Video file index information construction and query method and device | |
| CN111078680B (en) | Table information processing method, apparatus, electronic device and readable storage medium | |
| US20170235779A1 (en) | Processing query of database and data stream | |
| CN110019117A (en) | A kind of data archiving method and device | |
| JP2019012367A (en) | Salary data calculation device, salary data calculation program, and salary data calculation method | |
| CN109033271B (en) | Data insertion method and device based on column storage, server and storage medium | |
| CN110874182B (en) | Processing method, device and equipment for strip index | |
| US8762377B2 (en) | Candidate key retrieving apparatus, candidate key retrieving method and tangible machine-readable medium thereof |
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 |