CN111078680B - Table information processing method, apparatus, electronic device and readable storage medium - Google Patents
Table information processing method, apparatus, electronic device and readable storage medium Download PDFInfo
- Publication number
- CN111078680B CN111078680B CN201811216827.0A CN201811216827A CN111078680B CN 111078680 B CN111078680 B CN 111078680B CN 201811216827 A CN201811216827 A CN 201811216827A CN 111078680 B CN111078680 B CN 111078680B
- Authority
- CN
- China
- Prior art keywords
- recording period
- information
- tables
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a table information processing method, a 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 the 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; the first table and the second table are stored. The method can reduce the storage of repeated information and reduce the waste of storage resources.
Description
Technical Field
The present application relates to data processing technologies, and in particular, to a method and apparatus for processing table information, an electronic device, and a readable storage medium.
Background
Recording information via a spreadsheet is a common form of information recording that is widely used in daily life and work.
However, it is found in practice that, for electronic forms such as a class table, a work schedule table (e.g. a duty table), there is often a lot of repeated information between the forms of different dates, which results in a large amount of storage space being occupied when storing the data of the electronic forms, resulting in a waste of storage space.
Disclosure of Invention
In view of this, the present application provides a table information method, apparatus, electronic device, and readable storage medium.
Specifically, the application is realized by the following technical scheme:
according to a first aspect of an embodiment 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 the 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;
the first table and the second table are stored.
Optionally, the storing the first table and the second table includes:
storing the first table in a first table storage area, and storing the second table in a second table storage area;
and the second table storage area also stores header information, one piece of header information is associated with the second table in one recording period, and the header information records the index of the associated 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 period, and the lengths of the second tables in the sub-recording period of the same level are the same.
Optionally, the header information further records the number of sub-recording periods of each level included in the recording period.
Optionally, the method further comprises:
when a table information search request for a target sub-recording period in a target recording period is received, determining table header information of the target recording period according to a recording period with earliest time of the stored table information and a time difference value between the target recording period and the recording period with earliest time;
determining the storage position of the second table in the target sub-recording period according to the storage starting position of the first second table recorded in the table head 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 tables 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 an embodiment of the present application, there is provided a form information processing apparatus including:
a generating unit, configured to generate a first number of first tables and a second number of second tables according to a table information configuration instruction, where index information of the associated first tables is recorded in the second tables, at least one first table is associated with a plurality of second tables, and the first number is smaller than the second number;
and the storage unit is used 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;
and the second table storage area also stores header information, one piece of header information is associated with the second table in one recording period, and the header information records the index of the associated 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 period, and the lengths of the second tables in the sub-recording period of the same level are the same.
Optionally, the header information further records the number of sub-recording periods of each level included in the recording period.
Optionally, the apparatus further comprises:
a search unit configured to determine, when a table information search request for a target sub-recording period within a target recording period is received, table header information of the target recording period according to a recording period of earliest time of the stored table information and a time difference between the target recording period and the recording period of earliest time;
determining the storage position of the second table in the target sub-recording period according to the storage starting position of the first second table recorded in the table head 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 tables 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 an embodiment of the present application, there is provided an electronic device including a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory perform 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 split into the first table and the second table according to the repetition probability of the information in the table, and a plurality of second tables can be associated with one first table, so that when the table information is stored, only one first table and a plurality of associated second tables are required to be stored for a plurality of tables with repeated information, the storage of the repeated information is reduced, and the storage resource waste is reduced.
Drawings
FIG. 1 is a flow chart of a method for processing table information according to an exemplary embodiment of the present application;
FIG. 2 is a schematic diagram of a class diagram storage area division, according to an exemplary embodiment of the present application;
FIG. 3 is a schematic diagram of a class diagram information location, according to an exemplary embodiment of the present application;
fig. 4 is a schematic diagram of a configuration of a table information processing apparatus according to an exemplary embodiment of the present application;
fig. 5 is a schematic structural view of a table information processing apparatus according to still another exemplary embodiment of the present application;
fig. 6 is a schematic diagram of 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 exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples do not represent all implementations consistent with the application. Rather, they are merely examples of apparatus and methods consistent with aspects of the application as detailed in the accompanying 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 specification 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 better understand the technical solution provided by the embodiments of the present application and make the above objects, features and advantages of the embodiments of the present application more obvious, the technical solution in the embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
Referring to fig. 1, a flowchart of a table information processing method according to an embodiment of the present application is shown, wherein the table information processing method may be applied to a network device (hereinafter simply referred to as a network device) supporting 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 number of first tables and a second number of second tables according to the table information configuration instruction, wherein index information of the first tables is recorded in the second tables, at least one first table is associated with a plurality of second tables, and the first number is smaller than the second number.
In the embodiment of the application, in order to reduce the storage resource waste caused by repeated information among different tables when the table data is stored, different table records can be respectively used for the more repeated information and the less repeated information when the table is generated, and the association among different tables is established, further, only one table (called a first table in the text) recorded with the more repeated information and a plurality of tables (called a second table in the text) recorded with the less repeated information can be stored for storing a plurality of tables with the repeated information, thereby reducing the storage of the repeated information and reducing the storage resource waste.
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 table as an example, for a class table of any lesson, a first table may be generated according to one or more of the class name, teacher information, class content, and other information, and a second table may be generated according to the information such as the start time and the end time of the lesson.
For example, the first table may be generated according to information of an operator on duty and information of an on duty task, and the second table may be generated according to information of an on duty start time, an on duty end time, and the like.
Accordingly, in the embodiment of the present application, when generating the table, the first table with the first number and the second table with the second number may be generated according to the table information carried in the table information configuration instruction.
The index information of the first table is recorded in the second table, and for any second table, the first table associated with the second table can be positioned by 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 searching the table, and the second table which 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, using a textbook as an example, the attribute information may be the time information of the form (e.g., day M of week N2018).
Step S110, the generated first table and the second table are stored.
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 repetition information, thereby reducing the storage of the repetition information and reducing the storage resource waste.
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 storing the second table in a second table storage area;
the second table storage area also stores header information, and one piece of header information is associated with 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 performs the table information storage, different storage areas may be divided for the first table and the second table, and the first table and the second table may be stored in the corresponding storage areas (referred to herein as the first table storage area and the second table storage area, respectively).
In this embodiment, when storing the second table, 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 remaining information of the second table may be stored separately.
The non-configuration information may include a recording period (e.g., year, month), a start time of the recording period, an end time, etc.
For example, taking a school timetable as an example, assuming a recording period as a year, for any year of the school timetable it may comprise a multi-week school timetable.
For example, taking the year of year as an example, the year of year is 366 days, for a total of 52 weeks of 2 days, and for a maximum of 54 weeks of support, the start time and end time of the recording period can be determined from the start time of the first week and the end time of the last week of the 54 weeks.
Accordingly, the second table storage area may further store header information, and one piece of header information is associated with the second table in one recording period, where an index of the associated second table, a start time and an end time of the recording period may be recorded in the header information.
As one implementation of this embodiment, the second table in any recording period is continuously stored, 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 table, the second table in any one period may be stored continuously, and the storage start position of the first second table in the associated recording period may be recorded in the header information.
Accordingly, when the table information in a certain recording period needs to be searched, the storage starting position of the first second table in the second recording period can be determined according to the table head of the second table in the recording period, the second table information in the recording period is searched according to the storage starting position, and the related first table information is searched according to the index information recorded in the second table.
In one example, the recording period includes at least one level of sub-recording period, and the lengths of the second tables in the sub-recording period of the same level are the same.
For example, taking a recording period as an example of a year, the sub-recording period may be a week, and the lengths of the second tables in the sub-recording period 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 also record the number of sub-recording periods of each level included in the associated recording period.
For example, taking a recording period as a year, a sub-recording period 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 in the target recording period, the network device may determine header information of the target recording period according to a recording period with earliest time of the stored table information and a time difference between the target recording period and the recording period with earliest time, and determine a storage start position 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, so that the network device may search the second table in the target sub-recording period according to the storage position of the second table in the target sub-recording period, search the first table associated with each second table according to index information of the first table recorded in the second table in the target sub-recording period, and finally return the searched second table and the associated first table.
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 table management of the recording 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 a recording and broadcasting host, a detection camera and an image camera.
The recording and broadcasting host belongs to embedded equipment, the FLASH (FLASH memory) space is limited, and enough space is not available for storing the textlist information. 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 playing host computer draws a small portion of the hard disk space as a class chart storage, which is used as a class chart storage.
In this embodiment, the tablet data is divided into two parts: course information and schedule information. The course information and the schedule information may be shown in table 1 and table 2, respectively:
TABLE 1
| Description of the application | |
| Course name | Recording course names of course information, such as: "math" |
| Course teacher | Teacher names recording course information, such as: zhang Sanzhi (Zhang Sanzhi) " |
| Course content | Course content of recording course information, such as: "Jiujiu multiplication Table" |
TABLE 2
In this embodiment, a section of course is represented using the table 2 information, and contains course information, course start time, course end time. Wherein:
1. the method supports multi-section textbook configuration.
2. At most 112 courses (for example, at most 16 courses for 1 day) are configured for 7 days a week.
3. Taking the example of the year of year, the moistening period is 366 days after the whole year, for a total of 52 weeks of 2 days, calculated front-to-back span, maximum support was 54 weeks.
In this embodiment, when the class table storage is performed, the class table storage area may be divided into two parts: a lesson information storage area and a lesson list information storage area, a schematic of which may be as shown in fig. 2. Wherein:
1. the course information area stores multiple courses, and each course information corresponds to one teacher;
2. the school timetable information area comprises a school timetable head and a school timetable;
3. the school timetable area supports the storage of a school timetable for a plurality of years;
4. the school timetable head area is used for managing school timetables and describing the year, week number and other information of the annual school timetables;
5. each year, there is a school timetable header, which corresponds to it.
In this embodiment, referring to fig. 3, the school timetable storage area may store the school timetable header information of many years (the value of MAX may be set according to the actual scenario), the school timetable header information of any year may include the enabled status (such as enabled or disabled) of the school timetable of any year, the school timetable index (such as the starting position of the school timetable information of the first lesson of the first week of the year), the year (i.e., the year of the year, such as 2018), the week (i.e., the number of weeks included in the year, such as 2018, for example, the number of weeks included in the year is 53 weeks, assuming that the last week to the month of 2019 are 1, the starting date of the first week is 2018, 1 month of 1), and the ending date of the last week (such as the month of 2019, 1 month 6).
The length of the school timetable information of each week is the same (the specific length can be set according to the actual scene), and the length of the school timetable information of each day is the same (the specific length can be set according to the actual scene).
In this embodiment, year information for each year in the tablet header may be updated by updating the beginning year and year (i.e., MAX) information of the tablet header.
For example, assuming that the beginning year of the school timetable header is 2014, the 1 st year is 2014, the 2 nd year is 2015, … nd year is (2013+max).
For another example, assuming that the beginning year of the school timetable header is 2015, the 1 st year is 2015, the 2 nd year is 2016, … nd year is (2015+max).
In this embodiment, when it is necessary to search for the schedule information of a certain year, the recording and playing host may determine the schedule header information of the search year according to the start year of the schedule header and the time difference between the searched year and the start year.
For example, assuming that the beginning year of the school timetable header is 2014, the searched year is 2018 (i.e., the school timetable information in 2018 needs to be searched), the school timetable header information in the searched year is the school timetable header information in the 5 th year.
The recording and broadcasting host can determine the initial position of the first class list information storage of the first day of the first week according to the class list index included in the class list head information, further, the class list information of the year can be searched, corresponding class information can be searched according to the index of the class list information recorded in the class list information, and further, 2018 complete class list data can be obtained.
Further, in this embodiment, after the table information in 2018 is searched, when the table data in a specific week in 2018 needs to be searched, the corresponding offset in the table information in 2018 in the week may be determined first, and the storage start position of the table information in the week may be determined according to the storage start position of the table information in the first lesson on in the first week in 2018 and the offset, and then the table information in the week may be read, and the corresponding course information may be obtained according to the course information index in the table information, so as to obtain the complete table data in the week.
For example, assuming that the initial storage position of the table information of the first lesson on the first week of 2018 is A1 and the length of the table information of one week is L1, the initial storage position of the table information of the kth week is a1+ (K-1) L1, the recording and playing host may read the data of the L1 length from the initial storage position, that is, the table information of the kth week of 2018, and obtain the corresponding course information according to the index of the course information recorded in the table information, and further, the recording and playing host may obtain the complete table information of the kth week of 2018.
Further, in this embodiment, after the table information on week K in 2018 is searched, when the course information on a specific day on week K needs to be searched, the offset of the day in week K may be determined first, and the storage start position of the table information on the day may be determined according to the storage start position of the table information on week K in 2018 and the offset, so that the table information on the day may be read, and the corresponding course information may be obtained according to the course information index in the table information, so as to finally obtain the complete table data on the day.
For example, assuming that the length of the day of the schedule information is L2, after the recording and playing host obtains the storage starting position (assumed to be A2) of the schedule of week K in 2018, the storage starting position of the schedule information of day J in week K is a2+ (J-1) L2, the recording and playing host can read the data of the length of L2 from the storage starting position, that is, the schedule information of day J in week K in 2018, and obtain the corresponding course information according to the index of the course information recorded in the schedule information, and further, the recording and playing host can obtain the complete schedule information of day J in week K in 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 required to be stored for a plurality of tables with the repetition information, thereby reducing the storage of the repetition information and reducing the waste of storage resources.
The method provided by the application is described above. The device provided by the application is described below:
referring to fig. 4, a schematic structural diagram of a table information processing apparatus according to an embodiment of the present application is provided, 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 number of first tables and a second number of second tables according to a table information configuration instruction, where index information of the associated first tables is recorded in the second tables, and at least one first table is associated with a plurality of second tables, the first number is less 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 alternative embodiment, 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;
and the second table storage area also stores header information, one piece of header information is associated with the second table in one recording period, and the header information records the index of the associated second table, the starting time and the ending time of the recording period.
In an alternative embodiment, the second table in any recording period is 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 period, and the lengths of the second tables in the sub-recording period of the same level are the same.
In an alternative embodiment, the header information further records the number of sub-recording periods of each level included in the recording period.
In an alternative embodiment, as shown in fig. 5, the apparatus further comprises:
a search unit 430 for determining, when a table information search request for a target sub-recording period within a target recording period is received, table header information of the target recording period according to a recording period of earliest time of the stored table information and a time difference between the target recording period and the recording period of earliest time;
determining the storage position of the second table in the target sub-recording period according to the storage starting position of the first second table recorded in the table head 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 tables 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 application. 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 perform communication with each other through the communication bus 604. Wherein the memory 603 has a computer program stored thereon; the processor 601 can execute the table information processing method described above 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 may contain or store information, such as executable instructions, data, or the like. For example, the memory 602 may be: RAM (Radom Access Memory, random access memory), volatile memory, non-volatile memory, flash memory, a storage drive (e.g., hard drive), a solid state drive, any type of storage disk (e.g., optical disk, dvd, etc.), or a similar storage medium, or a combination thereof.
Embodiments of the present application also provide a machine-readable storage medium, such as memory 603 in fig. 6, storing a computer program executable by processor 601 in the electronic device shown in fig. 6 to implement the table information processing method described above.
It is noted that relational terms such as first and second, and the like are 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. Moreover, 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 one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The foregoing description of the preferred embodiments of the application is not intended to be limiting, but rather to enable any modification, equivalent replacement, improvement or the like to be made within the spirit and principles of the application.
Claims (6)
1. A form information processing method, characterized by 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 the 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;
storing the first table and the second table;
the storing the first table and the second table includes:
storing the first table in a first table storage area, and storing the second table in a second table storage area;
wherein, the second table storage area also stores header information, one piece of header information is associated with a second table in one recording period, and the header information records the index of the associated second table, the starting time and the ending time of the recording period;
the second tables in any recording period are continuously stored, and the index of the associated second table of the header information record comprises the storage starting position of the first second table in the associated recording period;
the recording period comprises at least one level of sub-recording period, and the lengths of the second tables in the sub-recording period of the same level are the same;
the method further comprises the steps of:
when a table information search request for a target sub-recording period in a target recording period is received, determining table header information of the target recording period according to a recording period with earliest time of the stored table information and a time difference value between the target recording period and the recording period with earliest time;
determining the storage position of the second table in the target sub-recording period according to the storage starting position of the first second table recorded in the table head 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 tables 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.
2. The method of claim 1, wherein the header information further records a number of sub-recording periods of each level included in the recording period.
3. A form information processing apparatus, characterized by comprising:
a generating unit, configured to generate a first number of first tables and a second number of second tables according to a table information configuration instruction, where index information of the associated first tables is recorded in the second tables, at least one first table is associated with a plurality of second tables, and the first number is smaller than the second number;
a storage unit configured to store the first table and the second table;
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;
wherein, the second table storage area also stores header information, one piece of header information is associated with a second table in one recording period, and the header information records the index of the associated second table, the starting time and the ending time of the recording period;
the second tables in any recording period are continuously stored, and the index of the associated second table of the header information record comprises the storage starting position of the first second table in the associated recording period;
the recording period comprises at least one level of sub-recording period, and the lengths of the second tables in the sub-recording period of the same level are the same;
the apparatus further comprises:
a search unit configured to determine, when a table information search request for a target sub-recording period within a target recording period is received, table header information of the target recording period according to a recording period of earliest time of the stored table information and a time difference between the target recording period and the recording period of earliest time;
determining the storage position of the second table in the target sub-recording period according to the storage starting position of the first second table recorded in the table head 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 tables 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.
4. The apparatus of claim 3, wherein the header information further records a number of each level sub-recording period included in the recording period.
5. The electronic equipment is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are communicated with each other through the communication bus;
a memory for storing a computer program;
a processor for implementing the method of claim 1 or 2 when executing a program stored on a memory.
6. A computer readable storage medium, characterized in that the computer readable storage medium has stored therein a computer program which, when executed by a processor, implements the method of claim 1 or 2.
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 CN111078680A (en) | 2020-04-28 |
| CN111078680B true 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 (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN103678314A (en) * | 2012-09-03 | 2014-03-26 | 中国银联股份有限公司 | Mass data processing system, equipment and method based on association rule extraction |
| 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 |
| 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 |
| 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 |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7885981B2 (en) * | 2000-10-31 | 2011-02-08 | Michael Philip Kaufman | System and method for generating automatic user interface for arbitrarily complex or large databases |
| US6938038B2 (en) * | 2002-06-04 | 2005-08-30 | Sap Aktiengesellschaft | Method and apparatus for generating and utilizing qualifiers and qualified taxonomy tables |
| US9037611B2 (en) * | 2012-09-13 | 2015-05-19 | Microsoft Technology Licensing, Llc | Generation of a user interface based on a relational data model |
| JP6260339B2 (en) * | 2014-02-24 | 2018-01-17 | 富士通株式会社 | Information processing apparatus, data conversion program, and data conversion method |
| TWI539390B (en) * | 2014-11-25 | 2016-06-21 | 富智康（香港）有限公司 | System and method of querying calendar event |
| WO2016192057A1 (en) * | 2015-06-03 | 2016-12-08 | 华为技术有限公司 | Updating method and device for index table |
| EP3329354A4 (en) * | 2015-07-31 | 2019-03-20 | WiseTech Global Limited | Methods and systems for creating configurable forms, configuring forms and for form flow and form correlation |
| GB2544296B (en) * | 2015-11-11 | 2020-06-03 | Canon Kk | Method and apparatus for serving and managing storage of data streams in a surveillance and/or monitoring system |
| US10482084B2 (en) * | 2016-08-16 | 2019-11-19 | Netscout Systems Texas, Llc | Optimized merge-sorting of data retrieved from parallel storage units |
-
2018
- 2018-10-18 CN CN201811216827.0A patent/CN111078680B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 |
| WO2015200405A1 (en) * | 2014-06-27 | 2015-12-30 | Microsoft Technology Licensing, Llc | Rule-based joining of foreign to primary key |
| CN105718436A (en) * | 2015-12-18 | 2016-06-29 | 武汉开目信息技术有限责任公司 | New type table data management method |
| 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 |
|---|
| 基于人脸识别的学生课程出勤管理系统设计;茹峰;彭晓宏;侯立刚;宋辰;;现代电子技术(第01期);全文 * |
| 基于语义映射的可配置信息索引方法;方勇;郑小林;陈德人;;计算机工程(第15期);全文 * |
| 对图书资料存储方式自动转换的探讨;林晓莉;;科技情报开发与经济(第20期);全文 * |
| 校园一卡通系统中学生关联信息的应用研究;崔超;;北京石油化工学院学报(第02期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111078680A (en) | 2020-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20140310245A1 (en) | Partition level backup and restore of a massively parallel processing database | |
| CN105279213A (en) | Retrieval device and retrieval method for log database | |
| CN111126495B (en) | Model training method, information prediction device, storage medium and equipment | |
| KR20100086512A (en) | Associating metadata with media objects using time | |
| US20140071135A1 (en) | Managing activities over time in an activity graph | |
| CN106021207A (en) | A patent writing system and method | |
| CN105630934A (en) | Data statistic method and system | |
| Wiggins | eBirding: technology adoption and the transformation of leisure into science | |
| CN111078680B (en) | Table information processing method, apparatus, electronic device and readable storage medium | |
| CN107609017B (en) | Method and system for realizing intelligent search and consultation of medical industry through self-defined hot words | |
| CN106933974B (en) | Video file index information construction and query method and device | |
| CN108427675B (en) | Method and equipment for constructing index | |
| CN109598481B (en) | Conference management authority processing method and device, computer equipment and storage medium | |
| CN110019117A (en) | A kind of data archiving method and device | |
| US8762377B2 (en) | Candidate key retrieving apparatus, candidate key retrieving method and tangible machine-readable medium thereof | |
| CN110662027A (en) | Storage integrity detection method and device and computer equipment | |
| US20180373807A1 (en) | Data management apparatuses, methods, and non-transitory tangible machine-readable media thereof | |
| CN111190898B (en) | Data processing method and device, electronic equipment and storage medium | |
| Murphy | Physical object or variable, flexible, ephemeral and reproducible: the management and care of contemporary art collections in 2020 | |
| CN108108390A (en) | Data distributing method and device | |
| US20220207486A1 (en) | Transferring user records among systems | |
| Case | Meeting the Challenge of Collocating Metadata: Explore Chicago Collections | |
| CN102890677A (en) | Reliable storage method of non-document system | |
| US7908326B1 (en) | Method and apparatus for managing messaging identities | |
| Belovari | Expedited Digital Appraisal for Regular Archivists: An MPLP-Type Appraisal Workflow for Hybrid Collections |
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 |