CN101276445B - Method and system for quickly positioning plant calendar - Google Patents
Method and system for quickly positioning plant calendar Download PDFInfo
- Publication number
- CN101276445B CN101276445B CN2008100979083A CN200810097908A CN101276445B CN 101276445 B CN101276445 B CN 101276445B CN 2008100979083 A CN2008100979083 A CN 2008100979083A CN 200810097908 A CN200810097908 A CN 200810097908A CN 101276445 B CN101276445 B CN 101276445B
- Authority
- CN
- China
- Prior art keywords
- day
- working day
- date
- working
- before yesterday
- 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
Images
Abstract
The invention discloses a method and a system for rapidly positioning a factory calendar, wherein the method comprises the steps of: modifying the physical table structure of the factory calendar, adding fields of advancing working days and postponing working days; updating the contents of the fields of advancing working days and postponing working days; inquiring the advancing working days or postponing working days corresponding to a special target day from the modified factory calendar; in accordance with the embodiment of the invention, SQL sentences are no longer required to judge the values and take the maximum/minimum when inquiring each time, thus lessening the operation work, saving the operation time and improving the work efficiency.
Description
Technical field
The present invention relates to Enterprise Resources Planning (ERP, Enterprise Resourse Planning) field, relate in particular to the method and system of quickly positioning plant calendar.
Background technology
Plant calendar is also referred to as the production calendar; It is the calendar that is used for the special shape of Enterprise Resources Planning (ERP) system; It is removed weekly off-day, festivals or holidays, shut-down and other unproductive date by generic calendar and forms; Be that MRP (MRP, Material Requirement Planning) launches one of foundation of planning.
For some day, possibly be working day, also possibly be nonworkdays; System is when generating plan, and the task because nonworkdays can not be arranged production must be skipped when therefore running into nonworkdays automatically; Perhaps delay in advance, up to finding first working day always.
For nonworkdays, be meant working day in advance and skip nonworkdays, find first working day forward, be working day of maximum smaller or equal to this day; Delay and be meant working day and skip nonworkdays, find first working day backward, be working day of minimum more than or equal to this day.If this sky is working day, then working day be this sky with delaying working day in advance.
Fast pairing working day of arranging production on a certain date in the Search and Orientation ERP system,, important effect is arranged for the task of arranging production effectively and reasonably.
At present; Pairing method on working day of arranging production of a certain date is exactly to inquire about through SQL statement to obtain corresponding working day on common date in the location ERP system commonly used; As: obtain the working day in advance on September 15th, 2007, realize through following statement:
Select MAX ([date]) from [plant calendar] where [whether working day]=' Y ' and [date]＜=' 2007-09-15 '
That is: select satisfying is that working day and date are less than the in advance working day of maximum one day of date in the date on September 15th, 2007 as on September 15th, 2007.
If there are many cover plant calendars in enterprise, for example: a plurality of workshops of enterprise exist different the lay day, then need the dissimilar plant calendars of many covers.If obtain the working day in advance on September 15th, 2007, realize so through following statement:
Select [plant calendar type], max ([date]) from [plant calendar] where [plant calendar type]=' job shop ' and [date]＜=' 2007-09-15 ' and [whether working day]=' Y ' group by [plant calendar type].
That is: selecting to satisfy in [plant calendar type] pairing plant calendar is that working day and date are less than the in advance working day of maximum one day of date in the date on September 15th, 2007 as on September 15th, 2007.
The inventor finds that under study for action above-mentioned ERP system is located workaday method, need to use SQL statement to carry out judging relatively more than or equal to (or smaller or equal to), and data are got maximal value.SQL statement is write complicacy, can't make full use of database index, poor-performing.
Summary of the invention
In view of this, the purpose of the embodiment of the invention is to provide the method and system of quickly positioning plant calendar, has avoided SQL statement to be greater than or less than judging and gets the maximum/minimum operation, has optimized operation time, has improved work efficiency.
For realizing above-mentioned purpose, the embodiment of the invention provides following technical scheme:
A kind of method of quickly positioning plant calendar comprises:
Revise plant calendar physical table structure, interpolation shifts to an earlier date working day and delays the field on working day;
Upgrade working day and the content of delaying the field on working day in advance;
What inquiry specific objective day was corresponding from amended plant calendar shifts to an earlier date working day or delays working day.
A kind of system of quickly positioning plant calendar comprises:
The field adding device is used to revise plant calendar physical table structure, adds to shift to an earlier date working day and delay the field on working day;
Updating block is used to upgrade working day and the content of delaying the field on working day in advance;
Query unit, what inquiry specific objective day was corresponding from amended plant calendar shifts to an earlier date working day or delays working day.
It is thus clear that, in embodiments of the present invention, through revising plant calendar physical table structure; Add in advance working day and delay the field on working day, after upgrading in advance working day and delaying the content of field on working day, on corresponding working day in advance inquiry specific objective day from amended plant calendar or when delaying working day; Need not use SQL statement to be greater than or less than to judge and get the maximum/minimum operation; Reduce operand, saved time operation time, improved work efficiency.
Description of drawings
The process flow diagram of the method for the quickly positioning plant calendar that Fig. 1 one embodiment of the invention provides;
The batch updating that Fig. 2 one embodiment of the invention provides shifts to an earlier date the process flow diagram of workaday method;
The batch updating that Fig. 3 provides for invention one embodiment is delayed the process flow diagram of workaday method;
The structural representation of the system of the quickly positioning plant calendar that Fig. 4 provides for one embodiment of the invention.
Embodiment
The embodiment of the invention provides the method and system of quickly positioning plant calendar; Revise plant calendar physical table structure, interpolation is also upgraded working day and the data of delaying the field on working day in advance, according to actual ERP system needs; In amended plant calendar table, inquire about in advance working day or delay working day through SQL; In the method that the embodiment of the invention provides, need not use SQL statement to be greater than or less than to judge and get the maximum/minimum operation, reduced operand; Save time operation time, improved work efficiency.
Below in conjunction with accompanying drawing the embodiment of the invention is described in detail.
Referring to accompanying drawing 1, in an embodiment of the present invention, realize that the method for the quickly positioning plant calendar that the embodiment of the invention provided may further comprise the steps:
Step 101: revise plant calendar physical table structure, interpolation shifts to an earlier date working day and delays the field on working day.
Step 102: upgrade working day and the content of delaying the field on working day in advance.
Step 103: what inquiry specific objective day was corresponding from amended plant calendar shifts to an earlier date working day or delays working day.
The plant calendar physical table is as shown in table 1, comprises serial number, and on the date, whether week and another day are workaday records.The method of prior art is: if will judge certain day working day in advance, then according to the plant calendar physical table, select to satisfy maximum one day of date in the date that to be working day and date will inquire about less than institute and shift to an earlier date working day as inquire about day.
Table 1:
| Serial number | Date | Week | Working day whether |
| 1 | 2007-09-03 | Monday | Y |
| 2 | 2007-09-04 | Tu. | Y |
| 3 | 2007-09-05 | Wednesday | Y |
| 4 | 2007-09-06 | Thursday | Y |
| 5 | 2007-09-07 | Friday | Y |
| 2007-09-08 | Saturday | N | |
| 2007-09-09 | Sun. | N | |
| 6 | 2007-09-10 | Monday | Y |
| 7 | 2007-09-11 | Tu. | Y |
| 8 | 2007-09-12 | Wednesday | Y |
| 9 | 2007-09-13 | Thursday | Y |
| 10 | 2007-09-14 | Friday | Y |
| 2007-09-15 | Saturday | N | |
| 2007-09-16 | Sun. | N | |
| 11 | 2007-09-17 | Monday | Y |
| 12 | 2007-09-18 | Tu. | Y |
| 13 | 2007-09-19 | Wednesday | Y |
| 14 | 2007-09-20 | Thursday | Y |
| 15 | 2007-09-21 | Friday | Y |
Among the embodiment provided by the invention the plant calendar physical table is revised; Added and shifted to an earlier date working day and delay two fields on working day; Amended plant calendar physical table is seen shown in the table 2; Except comprising serial number, date, week, whether being these projects on working day, also comprise shifting to an earlier date working day and delaying working day.
Table 2:
| Serial number | Date | Week | Working day whether | Shift to an earlier date working day | Delay working day |
| 1 | 2007-09-03 | Monday | Y | 2007-09-03 | 2007-09-03 |
| 2 | 2007-09-04 | Tu. | Y | 2007-09-04 | 2007-09-04 |
| 3 | 2007-09-05 | Wednesday | Y | 2007-09-05 | 2007-09-05 |
| 4 | 2007-09-06 | Thursday | Y | 2007-09-06 | 2007-09-06 |
| 5 | 2007-09-07 | Friday | Y | 2007-09-07 | 2007-09-07 |
| 2007-09-08 | Saturday | N | 2007-09-07 | 2007-09-10 | |
| 2007-09-09 | Sun. | N | 2007-09-07 | 2007-09-10 | |
| 6 | 2007-09-10 | Monday | Y | 2007-09-10 | 2007-09-10 |
| 7 | 2007-09-11 | Tu. | Y | 2007-09-11 | 2007-09-11 |
| 8 | 2007-09-12 | Wednesday | Y | 2007-09-12 | 2007-09-12 |
| 9 | 2007-09-13 | Thursday | Y | 2007-09-13 | 2007-09-13 |
| 10 | 2007-09-14 | Friday | Y | 2007-09-14 | 2007-09-14 |
| 2007-09-15 | Saturday | N | 2007-09-14 | 2007-09-17 | |
| 2007-09-16 | Sun. | N | 2007-09-14 | 2007-09-17 | |
| 11 | 2007-09-17 | Monday | Y | 2007-09-17 | 2007-09-17 |
| 12 | 2007-09-18 | Tu. | Y | 2007-09-18 | 2007-09-18 |
| 13 | 2007-09-19 | Wednesday | Y | 2007-09-19 | 2007-09-19 |
| 14 | 2007-09-20 | Thursday | Y | 2007-09-20 | 2007-09-20 |
| 15 | 2007-09-21 | Friday | Y | 2007-09-21 | 2007-09-21 |
Upgrade working day and the content of delaying these two fields on working day in advance, specifically can adopt the content of these two fields of batch updating or, safeguard the content of inserting these two fields by hand according to the situation on working day.
Referring to Fig. 2, batch updating shifts to an earlier date the content of field on working day, specifically comprises:
Step 201: plant calendar is pressed [date] ascending sort;
Step 202: judge whether when the day before yesterday be working day, if get into step 203; If not just getting into step 204;
Step 203: that will work as the day before yesterday is made as itself in advance working day, a variable is set simultaneously preserves current date, gets into step 205;
Step 204: the date that current variable is preserved is made as the working day in advance when the day before yesterday, gets into step 205;
Step 205: added 1 when the day before yesterday, and got into step 206;
Step 206: judge and whether work as the day before yesterday greater than last day, if, process ends; If, do not get into step 202.
Method through present embodiment provides can shift to an earlier date working day by batch updating.
Referring to Fig. 3, batch updating is delayed the content of field on working day, specifically comprises:
Step 301: plant calendar is pressed [date] descending sort;
Step 302: judge whether when the day before yesterday be working day, if get into step 303; If not just getting into step 304;
Step 303: that will work as the day before yesterday is made as itself in advance working day, a variable is set simultaneously preserves current date, gets into step 305;
Step 304: the date that current variable is preserved is made as the working day of delaying when the day before yesterday, gets into step 305;
Step 305: subtracted 1 when the day before yesterday, and got into step 306;
Step 306: whether judge current date less than last day, if, process ends; If, do not get into step 302.
Through the method that present embodiment provides, can delay working day by batch updating.
The workaday practical implementation method that shifts to an earlier date of the method inquiry specific objective day that the embodiment of the invention provides is: directly inquire about according to amended plant calendar physical table.Do not need to carry out again size and judge, need not get maximal value simultaneously yet.
For example to inquire about the working day in advance on September 8th, 2007, use the method for prior art to be:
With table 1 is query object, uses SQL statement: select MAX ([date]) from [plant calendar] where [whether working day]=' Y ' and [date]＜=' 2007-09-8 ' inquires about, and wherein plant calendar is the pairing plant calendar of table 1.
That is: select satisfying is that working day and date are less than the in advance working day of maximum one day of date in the date on September 8th, 2007 as on September 8th, 2007.
With the method that the embodiment of the invention provided, be query object just with table 2, be used for SQL statement: select [working day in advance] from [plant calendar] where [date]=' 2007-09-15 ', wherein plant calendar is the pairing plant calendar of table 2.
Because patented method SQL statement filtercondition has only one to equal to judge, and need not get maximal value to the result, operational efficiency is high.
If all write down number 2N, count 2M less than the record of Query Dates ' 2007-09-8 ', the operational performance of two kinds of methods is more as shown in table 3:
Table 3:
Wherein fx () obtains the required operation times of maximal value algorithm for ordering.
Can find out significantly that from table 3 the present invention has reduced operation times, operation ratio is provided, thereby improve work efficiency.
In practical application, also has the situation of multiplex (MUX) factory calendar.If there are many cover plant calendars in enterprise,, then need the dissimilar plant calendars of many covers if for example a plurality of workshops of enterprise exist different the lay day.
In the plant calendar physical table shown in the table 2, add field [plant calendar type], form many covers plant calendar of the embodiment of the invention, referring to table 4.
Table 4:
The present invention provides the inquiries to many cover plant calendars to shift to an earlier date working day or delays workaday method and the pairing single plant calendar inquiry of table 2 working day or to delay workaday method basic identical in advance, and difference only is the parameter of this field of adding plant calendar type in query statement.Concrete statement is:
Select [plant calendar type], [working day in advance] from [plant calendar] where [plant calendar type]=' workshop 1'and [date]=' 2007-09-15 '
Promptly from the plant calendar in workshop 1, inquire about the working day in advance on September 15th, 2007.
In the process that order in every particular is implemented, often possibly need the working day in advance on some date of inquiry or delay working day, utilize prior art; When each inquiry, all to carry out judging and maximum (perhaps minimum value) judged greater than (perhaps less than); Waste time and energy, still, the present invention has accomplished at first and has shifted to an earlier date working day and delay workaday renewal; And it is stored in the database; When practical application, only need do retrieval, practice thrift the time widely, improve work efficiency amended plant calendar.
The method of the quickly positioning plant calendar that provides with the embodiment of the invention is corresponding, and the embodiment of the invention also provides the system of quickly positioning plant calendar.Referring to Fig. 4, this system comprises:
Updating block 402 is used to upgrade working day and the content of delaying the field on working day in advance;
Wherein updating block 402 also comprises:
SQL batch updating module 4021 is used to utilize the SQL batch updating to shift to an earlier date working day and delays the field contents on working day.
Wherein, query unit 403 also comprises:
Generate submodule 4031, be used for generating automatically the SQL query statement;
Inquire about submodule 4032, be used to carry out the SQL query statement that is generated, in corresponding plant calendar, inquire about the pairing content of perhaps delaying the field on working day working day in advance of specific objective day, obtain shifting to an earlier date working day and delaying working day of this target day.
When the many covers of existence plant calendar, said SQL query statement also comprises querying condition: the plant calendar type.
The present invention can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises the routine carrying out particular task or realize particular abstract, program, object, assembly, data structure or the like.Also can in DCE, put into practice the present invention, in these DCEs, by through communication network connected teleprocessing equipment execute the task.In DCE, program module can be arranged in this locality and the remote computer storage medium that comprises memory device.
The above only is a preferred implementation of the present invention; Should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; Can also make some improvement and retouching, these improvement and retouching also should be regarded as protection scope of the present invention.
Claims (6)
1. the method for a quickly positioning plant calendar is characterized in that, comprising:
Revise plant calendar physical table structure, interpolation shifts to an earlier date working day and delays the field on working day;
Upgrade working day and the content of delaying the field on working day in advance;
What inquiry specific objective day was corresponding from amended plant calendar shifts to an earlier date working day or delays working day;
Wherein, said renewal shifts to an earlier date working day and the content of delaying the field on working day, comprising: carry out SQL statement, batch updating shifts to an earlier date working day and the content of delaying the field on working day;
Wherein, said batch updating shifts to an earlier date workaday method and comprises:
A1: plant calendar is pressed [date] ascending sort;
A2: judge whether when the day before yesterday be working day, if get into steps A 3; If not just getting into steps A 4;
A3: that will work as the day before yesterday is made as itself in advance working day, a variable is set simultaneously preserves current date, gets into steps A 5;
A4: the date that current variable is preserved is made as the working day in advance when the day before yesterday, gets into steps A 5;
A5: added 1 when the day before yesterday, and got into steps A 6;
A6: judge and whether work as the day before yesterday greater than last day, if, process ends; If, do not get into steps A 2;
Wherein, said batch updating is delayed workaday method and is comprised:
B1: plant calendar is pressed [date] descending sort;
B2: judge whether when the day before yesterday be working day, if get into step B3; If not just getting into step B4;
B3: that will work as the day before yesterday is made as itself in advance working day, a variable is set simultaneously preserves current date, gets into step B5;
B4: the date that current variable is preserved is made as the working day of delaying when the day before yesterday, gets into step B5;
B5: subtracted 1 when the day before yesterday, and got into step B6;
B6: whether judge current date less than last day, if, process ends; If, do not get into step B2.
2. method according to claim 1 is characterized in that, from amended plant calendar, inquires about the in advance working day corresponding with required target day or delays working day through following steps:
Generate the SQL query statement, be used for, inquire about the pairing content of perhaps delaying the field on working day working day in advance of specific objective day, obtain shifting to an earlier date working day and delaying working day of this target day at said plant calendar.
3. method according to claim 1 is characterized in that, when the many covers of existence plant calendar, said inquiry also comprises querying condition: the plant calendar type.
4. the system of a quickly positioning plant calendar is characterized in that, comprising:
The field adding device is used to revise plant calendar physical table structure, adds to shift to an earlier date working day and delay the field on working day;
Updating block is used to upgrade working day and the content of delaying the field on working day in advance;
Query unit, what inquiry specific objective day was corresponding from amended plant calendar shifts to an earlier date working day or delays working day;
Wherein, said updating block also comprises:
SQL batch updating module: be used to utilize the SQL batch updating to shift to an earlier date working day and the content of delaying the field on working day;
Wherein, said batch updating shifts to an earlier date workaday method and comprises:
A1: plant calendar is pressed [date] ascending sort;
A2: judge whether when the day before yesterday be working day, if get into steps A 3; If not just getting into steps A 4;
A3: that will work as the day before yesterday is made as itself in advance working day, a variable is set simultaneously preserves current date, gets into steps A 5;
A4: the date that current variable is preserved is made as the working day in advance when the day before yesterday, gets into steps A 5;
A5: added 1 when the day before yesterday, and got into steps A 6;
A6: judge and whether work as the day before yesterday greater than last day, if, process ends; If, do not get into steps A 2;
Wherein, said batch updating is delayed workaday method and is comprised:
B1: plant calendar is pressed [date] descending sort;
B2: judge whether when the day before yesterday be working day, if get into step B3; If not just getting into step B4;
B3: that will work as the day before yesterday is made as itself in advance working day, a variable is set simultaneously preserves current date, gets into step B5;
B4: the date that current variable is preserved is made as the working day of delaying when the day before yesterday, gets into step B5;
B5: subtracted 1 when the day before yesterday, and got into step B6;
B6: whether judge current date less than last day, if, process ends; If, do not get into step B2.
5. system according to claim 4 is characterized in that, said query unit further comprises:
Generate submodule, be used for generating automatically the SQL query statement;
Inquire about submodule, be used to carry out the SQL query statement that is generated, in corresponding plant calendar, inquire about the pairing content of perhaps delaying the field on working day working day in advance of specific objective day, obtain shifting to an earlier date working day and delaying working day of this target day.
6. system according to claim 5 is characterized in that, when the many covers of existence plant calendar, said SQL query statement also comprises querying condition: the plant calendar type.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008100979083A CN101276445B (en) | 2008-05-16 | 2008-05-16 | Method and system for quickly positioning plant calendar |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008100979083A CN101276445B (en) | 2008-05-16 | 2008-05-16 | Method and system for quickly positioning plant calendar |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101276445A CN101276445A (en) | 2008-10-01 |
| CN101276445B true CN101276445B (en) | 2012-11-21 |
Family
ID=39995866
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2008100979083A Active CN101276445B (en) | 2008-05-16 | 2008-05-16 | Method and system for quickly positioning plant calendar |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101276445B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102542437B (en) * | 2011-12-30 | 2014-11-26 | 东软集团股份有限公司 | Task expiration reminding method and device |
| CN107679835A (en) * | 2017-10-19 | 2018-02-09 | 山东浪潮通软信息科技有限公司 | A kind of method and device for positioning work calendar |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4648036A (en) * | 1985-03-06 | 1987-03-03 | At&T Bell Laboratories | Method for controlling query and update processing in a database system |
| CN1111369A (en) * | 1994-04-15 | 1995-11-08 | 湖南省零陵地区专利实施开发研究所 | Digital code information quick-looking up manual and writing method thereof |
| CN1124000A (en) * | 1994-09-13 | 1996-06-05 | 美国电报电话公司 | A method and system for updating replicated databases in telecommunication network system |
| CN1399475A (en) * | 2001-07-25 | 2003-02-26 | 华为技术有限公司 | Quick flow-searching method |
| US20070005630A1 (en) * | 2005-06-29 | 2007-01-04 | Microsoft Corporation | Modifying table definitions within a database application |
| CN1920824A (en) * | 2005-07-21 | 2007-02-28 | 曾致中 | Database cryptogram search method |
-
2008
- 2008-05-16 CN CN2008100979083A patent/CN101276445B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4648036A (en) * | 1985-03-06 | 1987-03-03 | At&T Bell Laboratories | Method for controlling query and update processing in a database system |
| CN1111369A (en) * | 1994-04-15 | 1995-11-08 | 湖南省零陵地区专利实施开发研究所 | Digital code information quick-looking up manual and writing method thereof |
| CN1124000A (en) * | 1994-09-13 | 1996-06-05 | 美国电报电话公司 | A method and system for updating replicated databases in telecommunication network system |
| CN1399475A (en) * | 2001-07-25 | 2003-02-26 | 华为技术有限公司 | Quick flow-searching method |
| US20070005630A1 (en) * | 2005-06-29 | 2007-01-04 | Microsoft Corporation | Modifying table definitions within a database application |
| CN1920824A (en) * | 2005-07-21 | 2007-02-28 | 曾致中 | Database cryptogram search method |
Non-Patent Citations (2)
| Title |
|---|
| 孙洪伟.数据表和查询设计点滴.《新乡师范高等专科学校学报》.2006,第20卷(第2期),46、47. * |
| 谢坚等.数据库建表要注意的若干问题.《江西电力职业技术学院学报》.2007,第20卷(第2期),76,77. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101276445A (en) | 2008-10-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101876983B (en) | Method for partitioning database and system thereof | |
| CN102129425B (en) | The access method of big object set table and device in data warehouse | |
| CN110597842B (en) | Service data query method and system | |
| CN104899199A (en) | Data processing method and system for data warehouse | |
| CN102163195A (en) | Query optimization method based on unified view of distributed heterogeneous database | |
| MXPA05006966A (en) | System and method for preference application installation and execution. | |
| CN102541529A (en) | Query page generating device and method | |
| CN103593456A (en) | Form user-defined design method and device | |
| CN105678459A (en) | Metadatabase-based business flow customization model | |
| CN102542009A (en) | Data querying method and device | |
| CN102063634A (en) | Mask intelligent card and function expanding method thereof | |
| CN101276445B (en) | Method and system for quickly positioning plant calendar | |
| CN109885642A (en) | Classification storage method and device towards full-text search | |
| CN104424021A (en) | Task priority setting system and method | |
| CN110347693A (en) | Method of data synchronization, device and storage medium | |
| US11429629B1 (en) | Data driven indexing in a spreadsheet based data store | |
| US11514236B1 (en) | Indexing in a spreadsheet based data store using hybrid datatypes | |
| CN112817915A (en) | Automatic multi-product document uniform publishing and displaying method | |
| CN101840427A (en) | Data processing method and device | |
| CN103699627A (en) | Dummy file parallel data block positioning method based on Hadoop cluster | |
| CN103902574A (en) | Real-time data loading method and device based on data flow technology | |
| CN101393621A (en) | Method and system for acquiring designated workday | |
| US11500839B1 (en) | Multi-table indexing in a spreadsheet based data store | |
| CN101452486A (en) | System data management method for [inscriptions on bones or tortoise shells and apparatus thereof | |
| CN102402527B (en) | Spatial data correlation method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20221123 Address after: 266000 201a, 2nd floor, international ocean Sensor Research Institute, Qingdao Blue Valley technology road, aoshanwei street, Jimo District, Qingdao City, Shandong Province Patentee after: Qingdao Kingdee Software Technology Co.,Ltd. Address before: 518057 hi tech Industrial Park, Shennan Avenue, Shenzhen, Guangdong, Nanshan District W1-B4 Patentee before: Kingdee software (China) Co.,Ltd. |