CN111339113A - Formula direct-through method and system based on ETL technology - Google Patents
Formula direct-through method and system based on ETL technology Download PDFInfo
- Publication number
- CN111339113A CN111339113A CN202010128525.9A CN202010128525A CN111339113A CN 111339113 A CN111339113 A CN 111339113A CN 202010128525 A CN202010128525 A CN 202010128525A CN 111339113 A CN111339113 A CN 111339113A
- Authority
- CN
- China
- Prior art keywords
- formula
- synchronized
- version
- system database
- cycle
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Abstract
The invention discloses a formula direct method based on an ETL technology, which comprises the following steps: acquiring information table data of a central control system, and storing the information table data to an ERP system database; setting formula synchronization cycle times according to an ERP system database, and acquiring information data of the ERP system database of the formula to be synchronized; judging whether the formula needs to be synchronized into a central control system database or not according to the information data of the formula needing to be synchronized; and deleting the formula information exceeding the release time according to the judgment standard of the formula version. The invention can skip the cooperative communication between a central control system manufacturer and an ERP system manufacturer, and directly communicate the data between the databases through the ETL technology, thereby achieving the purpose of direct prescription, saving the cost and the communication time, improving the convenience of prescription issuing and the timeliness of prescription updating, accelerating the development progress due to the convenience of the ETL technology and effectively improving the working efficiency.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a formula direct-through method and system based on an ETL technology.
Background
At present, the existing central control system and the feed formula set by the ERP system in the feed industry are difficult to correspond, the direct setting of the feed formula of the central control system and the ERP system is required to be completed only by the mutual cooperation of a central control system manufacturer and an ERP system manufacturer, so that higher communication cost is generated, the development speed is relatively slow, and meanwhile, the central control system manufacturer and the ERP system manufacturer are required to be matched with each other, so that the development cost is also high.
Disclosure of Invention
In order to solve the problems in the prior art, the embodiment of the invention provides a formula direct-reaching method and a formula direct-reaching system based on an ETL technology, and the aim of direct-reaching of a feed formula can be effectively achieved.
In order to achieve the above purpose, the present application provides a formula direct method and system based on ETL technology, the technical scheme is as follows:
in a first aspect, an ETL technology-based recipe through-going method, the method comprising:
acquiring information table data of a central control system, and storing the information table data to an ERP system database;
setting a formula synchronization cycle number according to the ERP system database, and acquiring information data of the formula to be synchronized in the ERP system database;
judging whether the formula needs to be synchronized into the central control system database or not according to the information data of the formula needing to be synchronized;
and deleting the recipe information exceeding the release time according to the judgment standard of the recipe version.
Further, the specific steps of setting the number of formula synchronization cycles according to the ERP system database and acquiring the information data of the formula to be synchronized in the ERP system database include:
acquiring the number of formulas to be synchronized according to the ERP system database;
and setting a formula synchronization cycle starting value T to be 1, and acquiring the formula name and the version number of the formula to be synchronized in the ERP system database.
Further, the specific step of judging whether the recipe needs to be synchronized into the central control system database according to the information data of the recipe needing to be synchronized includes:
and judging whether the formula of the formula name and the version number of the formula to be synchronized exists in the central control database, if so, entering a cycle 1, and if not, entering a cycle 2.
Further, the step of the cycle 1 is: and judging whether the formulas with the formula names and the formula version numbers to be synchronized exist, if so, judging that the formula cycle number T is T +1, then judging whether the formula cycle number T is equal to the formula number N to be synchronized, if so, completing the formula synchronization, entering a deleting process, and if not, entering a step of acquiring the formula names and the formula version numbers of the Tth formula to be synchronized in the ERP system database.
Further, the step of the cycle 2 is:
① if the formula does not exist, creating a data table with the formula name + version number as the table name;
②, acquiring the number M of the raw materials of the formula in the ERP system, and setting a synchronous cycle starting value R of the raw materials to be 1;
③ obtaining the name and quantity of the material of the No. R material in the formula in the ERP system;
④, matching the obtained raw material names and the raw material quantity with the central control bin information obtained in the first step, and then inserting the matched raw material names and the raw material quantity into the data table named by the formula name and the version number;
⑤, judging whether the raw material circulation number R is equal to the raw material number M to be synchronized, if so, inserting a trigger for limiting modification and returning to the first step of the circulation 1, and if not, entering the third step of the circulation 2.
Further, the specific step of deleting the recipe information exceeding the release time according to the judgment standard of the recipe version includes:
①, acquiring the number X of old version formulas corresponding to the new formula exceeding the release time of 48 hours, and setting a deletion cycle starting value Y to be 1;
② obtaining the recipe name and version number of the old version recipe corresponding to the new recipe with the overdischarge time of 48 hours;
③, judging whether the obtained old version formula corresponding to the new formula exists in the central control system database, if so, deleting the table, if not, judging whether the deleted cycle number Y is equal to Y +1, then judging whether the deleted cycle number is equal to the number X of the old version formula corresponding to the new formula, if not, entering a second step of the deletion process, and if so, finishing the whole process.
In a second aspect, an ETL technology-based recipe direct system, the system comprising:
the storage module is used for acquiring information table data of the central control system and storing the information table data to an ERP system database;
the setting module is used for setting the synchronous cycle times of the formula according to the ERP system database and acquiring the information data of the formula to be synchronized in the ERP system database;
the judging module is used for judging whether the formula needs to be synchronized into the central control system database according to the information data of the formula needing to be synchronized;
and the deleting module is used for deleting the formula information exceeding the release time according to the judgment standard of the formula version.
Further, the setting module is further configured to:
acquiring the number of formulas to be synchronized according to the ERP system database;
and setting a formula synchronization cycle starting value T to be 1, and acquiring the formula name and the version number of the formula to be synchronized in the ERP system database.
Further, the determining module is further configured to:
and judging whether the formula of the version of the formula name and the version number of the formula to be synchronized exists in the central control database, if so, entering a cycle 1, and if not, entering a cycle 2.
Further, the deletion module is further configured to:
①, acquiring the number X of old version formulas corresponding to the new formula exceeding the release time of 48 hours, and setting a deletion cycle starting value Y to be 1;
② obtaining the recipe name and version number of the old version recipe corresponding to the new recipe with the overdischarge time of 48 hours;
③, judging whether the obtained old version formula corresponding to the new formula exists in the central control system database, if so, deleting the table, if not, judging whether the deleted cycle number Y is equal to Y +1, then judging whether the deleted cycle number is equal to the number X of the old version formula corresponding to the new formula, if not, entering a second step of the deletion process, and if so, finishing the whole process.
Therefore, by the technical scheme, the cooperative communication between a central control system manufacturer and an ERP system manufacturer can be skipped, and the data among the databases can be communicated directly through the ETL technology, so that the purpose of direct prescription is achieved, the cost and the communication time are saved, the prescription issuing convenience and the prescription updating timeliness are improved, the development progress is accelerated due to the convenience of the ETL technology, and the working efficiency can be effectively improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a diagram illustrating the steps of a recipe express method based on ETL technology according to an embodiment of the present invention;
fig. 2 is a schematic diagram of a recipe direct system based on the ETL technology according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, an embodiment of the present invention provides a formula direct method based on an ETL technology, wherein the ETL technology is used to connect a central control system and an ERP system, the ETL technology is a technical process of extracting, converting, and cleaning data from a source end to a target end, and the ETL technology is widely applied to enterprise informatization at present. The method comprises the following steps:
acquiring information table data of a central control system, and storing the information table data to an ERP system database;
setting formula synchronization cycle times according to an ERP system database, and acquiring information data of the ERP system database of the formula to be synchronized;
judging whether the formula needs to be synchronized into a central control system database or not according to the information data of the formula needing to be synchronized;
and deleting the formula information exceeding the release time according to the judgment standard of the formula version.
Specifically, the number of formulas to be synchronized is obtained according to an ERP system database;
setting a formula synchronous cycle starting value T to be 1 according to the formula quantity;
and acquiring the formula name and the version number of the formula to be synchronized in the ERP system database according to the formula synchronization cycle starting value T.
In this embodiment, for the storage manner of the formula information in the ERP system, the formula logic in the ERP system should include a formula information main table and an associated raw material sub-table, and the formula name, the version number, the release time, the raw material name, the raw material ratio, and the raw material quantity are screened, and the formula information and the associated raw material information are generated by cleaning, filtering, and processing through the ETL technology according to the company formula processing logic.
Specifically, whether the recipe of the version exists in the central control database is judged, if yes, the loop 1 is entered, and if not, the loop 2 is entered.
The steps of cycle 1 are: and judging whether the formula exists, if so, judging the formula cycle number T to be T +1, then judging whether the formula cycle number T is equal to the number N of the formulas needing to be synchronized, if so, completing the formula synchronization, entering a deleting process, and if not, entering a step of acquiring the formula name and the version number of the T-th formula needing to be synchronized in the ERP system database.
The steps of cycle 2 are:
① if the formula does not exist, creating a data table with the formula name + version number as the table name;
②, acquiring the number M of the raw materials of the formula in the ERP system, and setting a synchronous cycle starting value R of the raw materials to be 1;
③ obtaining the name and quantity of the material of the No. R material in the formula in the ERP system;
④, matching the obtained raw material names and the raw material quantity with the central control bin information obtained in the first step, and then inserting the matched raw material names and the raw material quantity into the data table named by the formula name and the version number;
⑤, judging whether the raw material circulation number R is equal to the raw material number M to be synchronized, if so, inserting a trigger for limiting modification and returning to the first step of the circulation 1, and if not, entering the third step of the circulation 2.
According to the judgment basis of the formula version, the specific steps of deleting the formula with the overdue time comprise:
①, acquiring the number X of old version formulas corresponding to the new formula exceeding the release time of 48 hours, and setting a deletion cycle starting value Y to be 1;
② obtaining the recipe name and version number of the old version recipe corresponding to the new recipe with the overdischarge time of 48 hours;
③, judging whether the old version formula corresponding to the new formula exists in the central control system database, if so, deleting the table, if not, judging whether the number of deletion cycles Y is Y +1, then judging whether the number of deletion cycles is equal to the number X of the old version formula corresponding to the new formula, if not, entering the second step of the deletion process, and if so, finishing the whole process.
In this embodiment, whether dependency and foreign key constraint exist between database tables of the central control system is analyzed and confirmed according to the database of the central control system, the order of data table assignment, the master key design specification and the cycle flow design when data are synchronized are designed, the obtained formula information and associated raw material information are converted by the ETL technology and converted into data structures corresponding to a formula table, a raw material table, a formula raw material associated table and a bin corresponding table in the database of the central control system, data are stored in each table, the front desk of the central control system checks whether the formula data stored in the database of the central control system by the ETL technology are different from the rest manual data, whether modification, deletion, addition and other operations can be performed or not by checking whether an abnormality exists in the operation formula, the central control system uses the formula assigned by the ETL technology for production, and whether the production process is different or not by comparing with the manual entry formula, whether the production speed is normal or not ensures that the formula issued by the ETL technology can support the normal production requirement without adverse effect. After the test stage, a task plan program is configured on the windows server to execute a formula issuing ETL program regularly, and the newly issued formula is automatically docked into a company production central control system database at a fixed time point.
As shown in fig. 2, an embodiment of the present invention provides a formula direct system based on ETL technology, and the system includes:
the storage module is used for acquiring information table data of the central control system and storing the information table data to an ERP system database;
the setting module is used for setting the synchronous cycle times of the formula according to the ERP system database and acquiring the information data of the formula to be synchronized in the ERP system database;
the judging module is used for judging whether the formula needs to be synchronized into the central control system database according to the information data of the formula needing to be synchronized;
and the deleting module is used for deleting the formula information exceeding the release time according to the judgment standard of the formula version.
Specifically, the setting module is further configured to:
acquiring the number of formulas to be synchronized according to an ERP system database;
and setting a formula synchronization cycle starting value T to be 1, and acquiring the formula name and the version number of the formula to be synchronized in the ERP system database.
Specifically, the judging module is further configured to:
and judging whether a formula of the version of the formula name and version number needing to be synchronized exists in the central control database, if so, entering a cycle 1, and if not, entering a cycle 2.
Specifically, the deletion module is further configured to:
①, acquiring the number X of old version formulas corresponding to the new formula exceeding the release time of 48 hours, and setting a deletion cycle starting value Y to be 1;
② obtaining the recipe name and version number of the old version recipe corresponding to the new recipe with the overdischarge time of 48 hours;
③, judging whether the old version formula corresponding to the new formula exists in the central control system database, if so, deleting the table, if not, judging whether the number of deletion cycles Y is Y +1, then judging whether the number of deletion cycles is equal to the number X of the old version formula corresponding to the new formula, if not, entering the second step of the deletion process, and if so, finishing the whole process.
Therefore, by the scheme, the cooperative communication between a central control system manufacturer and an ERP system manufacturer can be skipped, and the data among the databases can be communicated directly through the ETL technology, so that the purpose of direct prescription is achieved, the cost and the communication time are saved, the prescription issuing convenience and the prescription updating timeliness are improved, the development progress is accelerated due to the convenience of the ETL technology, and the working efficiency can be effectively improved.
It should also be noted that 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 like elements in a process, method, article, or apparatus that comprises the element.
The above description is only an embodiment of the present application, and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. An ETL technology-based formulation through-process method, comprising:
acquiring information table data of a central control system, and storing the information table data to an ERP system database;
setting a formula synchronization cycle number according to the ERP system database, and acquiring information data of the formula to be synchronized in the ERP system database;
judging whether the formula needs to be synchronized into the central control system database or not according to the information data of the formula needing to be synchronized;
and deleting the recipe information exceeding the release time according to the judgment standard of the recipe version.
2. The method according to claim 1, wherein the step of setting the number of formula synchronization cycles according to the ERP system database and acquiring the information data of the formula to be synchronized in the ERP system database comprises:
acquiring the number of formulas to be synchronized according to the ERP system database;
and setting a formula synchronization cycle starting value T to be 1, and acquiring the formula name and the version number of the formula to be synchronized in the ERP system database.
3. The method according to claim 1, wherein the step of determining whether to synchronize the recipe into the central control system database according to the information data of the recipe to be synchronized comprises:
and judging whether the formula of the formula name and the version number of the formula to be synchronized exists in the central control database, if so, entering a cycle 1, and if not, entering a cycle 2.
4. The method of claim 3, wherein the step of cycle 1 is: and judging whether the formulas with the formula names and the formula version numbers to be synchronized exist, if so, judging that the formula cycle number T is T +1, then judging whether the formula cycle number T is equal to the formula number N to be synchronized, if so, completing the formula synchronization, entering a deleting process, and if not, entering a step of acquiring the formula names and the formula version numbers of the Tth formula to be synchronized in the ERP system database.
5. A method according to claim 3, characterized in that the step of cycle 2 is:
① if the formula does not exist, creating a data table with the formula name + version number as the table name;
②, acquiring the number M of the raw materials of the formula in the ERP system, and setting a synchronous cycle starting value R of the raw materials to be 1;
③ obtaining the name and quantity of the material of the No. R material in the formula in the ERP system;
④, matching the obtained raw material names and the raw material quantity with the central control bin information obtained in the first step, and then inserting the matched raw material names and the raw material quantity into the data table named by the formula name and the version number;
⑤, judging whether the raw material circulation number R is equal to the raw material number M to be synchronized, if so, inserting a trigger for limiting modification and returning to the first step of the circulation 1, and if not, entering the third step of the circulation 2.
6. The method according to claim 1, wherein the step of deleting the recipe information with the overdue time according to the judgment criteria of the recipe version comprises:
①, acquiring the number X of old version formulas corresponding to the new formula exceeding the release time of 48 hours, and setting a deletion cycle starting value Y to be 1;
② obtaining the recipe name and version number of the old version recipe corresponding to the new recipe with the overdischarge time of 48 hours;
③, judging whether the obtained old version formula corresponding to the new formula exists in the central control system database, if so, deleting the table, if not, judging whether the deleted cycle number Y is equal to Y +1, then judging whether the deleted cycle number is equal to the number X of the old version formula corresponding to the new formula, if not, entering a second step of the deletion process, and if so, finishing the whole process.
7. An ETL technology-based recipe direct system, comprising:
the storage module is used for acquiring information table data of the central control system and storing the information table data to an ERP system database;
the setting module is used for setting the synchronous cycle times of the formula according to the ERP system database and acquiring the information data of the formula to be synchronized in the ERP system database;
the judging module is used for judging whether the formula needs to be synchronized into the central control system database according to the information data of the formula needing to be synchronized;
and the deleting module is used for deleting the formula information exceeding the release time according to the judgment standard of the formula version.
8. The system of claim 7, wherein the setup module is further configured to:
acquiring the number of formulas to be synchronized according to the ERP system database;
and setting a formula synchronization cycle starting value T to be 1, and acquiring the formula name and the version number of the formula to be synchronized in the ERP system database.
9. The system of claim 7, wherein the determining module is further configured to:
and judging whether the formula of the version of the formula name and the version number of the formula to be synchronized exists in the central control database, if so, entering a cycle 1, and if not, entering a cycle 2.
10. The system of claim 7, wherein the deletion module is further configured to:
①, acquiring the number X of old version formulas corresponding to the new formula exceeding the release time of 48 hours, and setting a deletion cycle starting value Y to be 1;
② obtaining the recipe name and version number of the old version recipe corresponding to the new recipe with the overdischarge time of 48 hours;
③, judging whether the obtained old version formula corresponding to the new formula exists in the central control system database, if so, deleting the table, if not, judging whether the deleted cycle number Y is equal to Y +1, then judging whether the deleted cycle number is equal to the number X of the old version formula corresponding to the new formula, if not, entering a second step of the deletion process, and if so, finishing the whole process.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010128525.9A CN111339113B (en) | 2020-02-28 | 2020-02-28 | ETL technology-based formula direct method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010128525.9A CN111339113B (en) | 2020-02-28 | 2020-02-28 | ETL technology-based formula direct method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111339113A true CN111339113A (en) | 2020-06-26 |
| CN111339113B CN111339113B (en) | 2023-04-28 |
Family
ID=71184035
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010128525.9A Active CN111339113B (en) | 2020-02-28 | 2020-02-28 | ETL technology-based formula direct method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111339113B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6141664A (en) * | 1996-11-13 | 2000-10-31 | Puma Technology, Inc. | Synchronization of databases with date range |
| JP2002007190A (en) * | 2000-06-23 | 2002-01-11 | Mitsubishi Electric Corp | Communication network system and data base updating method for communication network system |
| CN101882165A (en) * | 2010-08-02 | 2010-11-10 | 山东中创软件工程股份有限公司 | Multithreading data processing method based on ETL (Extract Transform Loading) |
| CN102394927A (en) * | 2011-10-31 | 2012-03-28 | 国云科技股份有限公司 | Method for storing and synchronizing data of internal and external networks |
| CN103605809A (en) * | 2013-12-10 | 2014-02-26 | 厦门诚创网络有限公司 | Data synchronization method |
| CN103916482A (en) * | 2014-04-21 | 2014-07-09 | 合肥盈云信息科技有限公司 | Data synchronous transmission method based on sqlite |
| CN106445618A (en) * | 2016-10-17 | 2017-02-22 | 成都知道创宇信息技术有限公司 | Automatic database updating method |
| CN108241693A (en) * | 2016-12-26 | 2018-07-03 | 北京国双科技有限公司 | The method and apparatus of synchrodata |
| CN109255462A (en) * | 2017-07-14 | 2019-01-22 | 中移（杭州）信息技术有限公司 | A kind of goods delivery method and device |
| CN110502585A (en) * | 2019-08-30 | 2019-11-26 | 山东健康医疗大数据有限公司 | A kind of configurable MySql database data synchronic method |
-
2020
- 2020-02-28 CN CN202010128525.9A patent/CN111339113B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6141664A (en) * | 1996-11-13 | 2000-10-31 | Puma Technology, Inc. | Synchronization of databases with date range |
| JP2002007190A (en) * | 2000-06-23 | 2002-01-11 | Mitsubishi Electric Corp | Communication network system and data base updating method for communication network system |
| CN101882165A (en) * | 2010-08-02 | 2010-11-10 | 山东中创软件工程股份有限公司 | Multithreading data processing method based on ETL (Extract Transform Loading) |
| CN102394927A (en) * | 2011-10-31 | 2012-03-28 | 国云科技股份有限公司 | Method for storing and synchronizing data of internal and external networks |
| CN103605809A (en) * | 2013-12-10 | 2014-02-26 | 厦门诚创网络有限公司 | Data synchronization method |
| CN103916482A (en) * | 2014-04-21 | 2014-07-09 | 合肥盈云信息科技有限公司 | Data synchronous transmission method based on sqlite |
| CN106445618A (en) * | 2016-10-17 | 2017-02-22 | 成都知道创宇信息技术有限公司 | Automatic database updating method |
| CN108241693A (en) * | 2016-12-26 | 2018-07-03 | 北京国双科技有限公司 | The method and apparatus of synchrodata |
| CN109255462A (en) * | 2017-07-14 | 2019-01-22 | 中移（杭州）信息技术有限公司 | A kind of goods delivery method and device |
| CN110502585A (en) * | 2019-08-30 | 2019-11-26 | 山东健康医疗大数据有限公司 | A kind of configurable MySql database data synchronic method |
Non-Patent Citations (1)
| Title |
|---|
| 杨胜哲等: "数据流程序动态调度与优化" * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111339113B (en) | 2023-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101567013B (en) | Method and apparatus for implementing ETL scheduling | |
| CN102521254B (en) | Uniform access method of isomeric database | |
| CN101706803B (en) | Method for migrating production data of weaving workshop | |
| CN108090073B (en) | Configurable bill of material conversion method and device | |
| CN108009258B (en) | Data acquisition and analysis platform capable of being configured online | |
| CN108153784A (en) | Synchrodata treating method and apparatus | |
| CN105719126A (en) | System and method for internet big data task scheduling based on life cycle model | |
| CN102004954A (en) | Product information system and information integration method of product design system | |
| CN111626689B (en) | Intelligent data algorithm based on product example | |
| CN103593456A (en) | Form user-defined design method and device | |
| CN101174237B (en) | Automatic test method, system and test device | |
| CN109033452B (en) | Intelligent construction loading method and system for data warehouse | |
| CN110515995A (en) | Quickly generate the ETL operational method and device of big data platform | |
| CN108931963B (en) | Automatic programming system for numerical control machining of air valve parts | |
| CN102467697A (en) | Material demand generation method and system | |
| CN111339113A (en) | Formula direct-through method and system based on ETL technology | |
| CN113052529A (en) | Plane library management method and device, storage medium and electronic equipment | |
| CN113537943A (en) | Universal workflow engine and construction method thereof | |
| US20050096775A1 (en) | Method and system of automatic carrier transfer | |
| CN101500040A (en) | Configurable flow scheduling and section selection method based on arbitrarily spreading attribute specification | |
| CN100592303C (en) | Mould design alteration processing system and method | |
| CN114020719A (en) | License data migration method applied to heterogeneous database | |
| CN100474297C (en) | Man-machine language generating system and method thereof | |
| CN110928883B (en) | Data archiving method and device | |
| CN112967032A (en) | Sales bill of materials management method, system, equipment and storage medium |
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 |