CN110377586A - A kind of control method and data base management system of dependent data management - Google Patents
A kind of control method and data base management system of dependent data management Download PDFInfo
- Publication number
- CN110377586A CN110377586A CN201910601005.2A CN201910601005A CN110377586A CN 110377586 A CN110377586 A CN 110377586A CN 201910601005 A CN201910601005 A CN 201910601005A CN 110377586 A CN110377586 A CN 110377586A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- tested
- transferred
- validation
- 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.)
- Withdrawn
Links
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/21—Design, administration or maintenance of databases
-
- 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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Telephonic Communication Services (AREA)
Abstract
The present invention discloses a kind of data control method of dependent data management, by validation database and database cooperative response external data exchange instruction to be tested, include the following steps: that a. is instructed by least one response external data exchange in the validation database and the database to be tested；Wherein, further include following steps: data corresponding with first control instruction in the database to be tested being transferred in the validation database after the first control instruction is triggered, then, the associated data for being transferred data is transferred to the validation database from the database to be tested or verification operation is carried out to the associated data for being transferred data, whether the validation database can be transferred to from the database to be tested with the determination associated data.Operation of the present invention is simple, easy to use, powerful, can effectively be managed to the data in validation database and database to be tested, has high commercial value.
Description
Technical field
The invention belongs to mobile Internet field, in particular to the control method and data depositary management of a kind of dependent data management
Reason system.
Background technique
In existing management platform, there are the data source datas that it manages platform itself, are referred to as master data,
And these master datas are to be edited to form by staff (crawler perhaps to be read or passed through by generally acknowledged third party's api interface
Acquisition, the data from data most source), the change to it can not be related at present, it can only be by way of update come gradually complete
It is apt to its master data, and it is managed under platform, the data being not from management platform itself can all enter other data
In library, such as the data of each large enterprises, these data are not its data for managing platform itself, and enterprise will be by addition
Database in use is extracted to the information of its own.
And it is present, we usually need that certain verifying hand will be being passed through from the data of third party or other data sources
Duan Hou, the data being transformed into primary database, so as to be used for platform, but current way, often artificial hand
Dynamic editor updates, and brings great inconvenience to staff, reduces working efficiency, and then increase entreprise cost.
At present in existing technology, there is no a kind of technical solutions for being able to solve above-mentioned technical problem, specifically, lack
The control method and data base management system of a kind of few dependent data management.
Summary of the invention
For technological deficiency of the existing technology, the object of the present invention is to provide a kind of data controls of dependent data management
Method processed includes the following steps: that a. is logical by validation database and database cooperative response external data exchange instruction to be tested
Cross at least one response external data exchange instruction in the validation database and the database to be tested；Wherein, it also wraps
Include following steps: by number corresponding with first control instruction in the database to be tested after the first control instruction is triggered
According to being transferred in the validation database.
Preferably, in the case where meeting following condition, first control instruction is triggered:
- one or more identification instruction is received；
- one or more administrator instruction is received；
A data in the database to be tested is more than first threshold and is not received by the number of carry out data exchange
For the falsfication instruction of the data；And
The associated data of a data in the database to be tested is transferred in the validation database.
Preferably, data corresponding with first control instruction are transferred to the verifying number in the database to be tested
Further include any one of following steps behind library:
Iii. the associated data for being transferred data is transferred to the validation database from the database to be tested；Or
Whether the associated data for being iv. transferred data to described carries out verification operation, can be with the determination associated data
The validation database is transferred to from the database to be tested.
Preferably, data corresponding with first control instruction in the database to be tested are transferred to the verifying number
Any one of in the following way or appoint a variety of completions according to the step in library:
Physical transfer mode；And
Logic branch mode.
Preferably, it is modified with the verify data label for being transferred data.
According to another aspect of the present invention, a kind of dependent data management information system is provided, for passing through verifying number
According to library and database cooperative response external data exchange instruction to be tested, include at least:
The validation database,
The database to be tested,
One access control engine, the access control engine is after the first control instruction is triggered by the database to be tested
In data corresponding with first control instruction be transferred in the validation database.
Preferably, the validation database and the database to be tested are stored on the same physical equipment.
The present invention, which discloses, provides a kind of data control method of dependent data management, passes through validation database and number to be tested
According to library cooperative response external data exchange instruction, pass through at least one of the validation database and the database to be tested
The instruction of response external data exchange；Wherein, after the first control instruction is triggered by the database to be tested with described first
The corresponding data of control instruction are transferred in the validation database, then, by the associated data for being transferred data from institute
It states database to be tested to be transferred to the validation database or carry out verification operation to the associated data for being transferred data, with true
Whether the fixed associated data can be transferred to the validation database from the database to be tested.Operation of the present invention is simple, makes
It is powerful with convenience, effectively the data in validation database and database to be tested can be managed, had high
Commercial value.
Detailed description of the invention
Upon reading the detailed description of non-limiting embodiments with reference to the following drawings, other feature of the invention,
Objects and advantages will become more apparent upon:
Fig. 1 shows a specific embodiment of the invention, a kind of data control method of dependent data management it is specific
Flow diagram；
Fig. 2 shows the first embodiment of the present invention, a kind of specific stream of the data control method of dependent data management
Journey schematic diagram；And
Fig. 3 shows another embodiment of the present invention, a kind of module company of dependent data management information system
Connect schematic diagram.
Specific embodiment
In order to preferably technical solution of the present invention be made clearly to show, the present invention is made into one with reference to the accompanying drawing
Walk explanation.
It will be appreciated by those skilled in the art that in view of the deficiencies of the prior art, the invention discloses a kind of dependent data management
Control method and the data base management system to match with the control method, Fig. 1 show specific embodiment party of the invention
Formula, a kind of idiographic flow schematic diagram of the data control method of dependent data management, the dependent data management in the present invention
Data control method passes through validation database and database cooperative response external data exchange instruction to be tested, i.e., the described verifying number
The interactive instruction of external data is responded jointly according to library and the database to be tested, is included the following steps:
Firstly, entering step S101, rung by least one of the validation database and the database to be tested
External data exchange instruction is answered, it will be appreciated by those skilled in the art that the validation database is primary database, it is data source number
According to, it cannot modify, edit, can only update, and the data in database to be tested are passed by third-party platform or third party
The defeated data also or according to the analytic operation of database to be tested obtained, can carry out defeated in the database to be tested
Enter, store, shift or modifies, and it is outer by the response of at least one of the validation database and the database to be tested
Portion's data exchange instructs this means that validation database can carry out the automatic transfer of data by the response of external data, i.e.,
In the present invention, if the data in database to be tested are met certain condition after verifying, it can transfer them to and test
It demonstrate,proves in database, as the master data in the validation database.
It further, it will be appreciated by those skilled in the art that will be in the database to be tested after the first control instruction is triggered
Data corresponding with first control instruction are transferred in the validation database, and first control instruction, which refers to, to incite somebody to action
Certain data are transferred to the instruction of validation database from database to be tested, i.e., when the data base management system receives institute
The first control instruction is stated, then the database transfer to be tested by data associated with first control instruction where itself
It moves in the validation database.
Further, in the present invention, first control instruction is triggered when meeting corresponding condition, as this hair
A bright preferred embodiment, when one or more identification instruction is received, first control instruction is triggered, that is, works as
Data base management system identifies in the database to be tested that correspondingly data satisfaction can be turned by certain identification method
When moving to validation database, then the identification instruction is sent, the data being if desired transferred are a plurality of data, then send a plurality of mirror
Fixed instruction；As another preferred embodiment of the invention, when one or more administrator instruction is received, described the
One control instruction is triggered, and in such embodiments, i.e., can be transferred to verifying number when administrator thinks that it has manually
According to library ability when, generate the triggering command of first control instruction；It is described as another preferred embodiment of the invention
A data in database to be tested is more than first threshold and is not received for the data by the number of carry out data exchange
Falsfication instruction, in such embodiments, the data being if desired transferred once are exchanged many times before, described the
The value range of one threshold value can be 5,10,50 or more, then preferably assert that the data have a possibility that being transferred,
And when the data do not receive the falsfication instruction for the data, i.e., when the data pass through the feelings verified and passed through again
It is preferential to trigger the first control instruction under condition；And the data in another preferred embodiment, in the database to be tested
Associated data be transferred in the validation database, in such embodiments, if the number from a data source, these
Data have all been transferred to validation database, and the data left of this data source is seldom, are preferably carried out at one
In example, if only one, can remaining data be done with an automatic assessment, if assessment passes through, then it is assumed that the data tool
There is the ability for being transferred to validation database, then preferably triggers first control instruction.
Then, S102 is entered step, the associated data for being transferred data is transferred to institute from the database to be tested
Validation database is stated, in passing through step S101, at least one of the validation database and the database to be tested
Response external data carry out instruction exchange, and when the first control instruction is triggered, and execute step S102, i.e., according to described first
Control instruction, will data associated with first control instruction, that is, the associated data of data is transferred, from database to be tested
It is transferred to the validation database, thus the transfer operation of complete paired data.
Fig. 2 shows the first embodiment of the present invention, a kind of specific stream of the data control method of dependent data management
Journey schematic diagram, it will be appreciated by those skilled in the art that the control that Fig. 2 shows another to realize data control in dependent data management
Method processed specifically includes the following steps:
Firstly, S201 is entered step, it will be appreciated by those skilled in the art that the step S201 can be with reference to shown in Fig. 1
Step S101, it will not be described here.
Then, S202 is entered step, verification operation is carried out to the associated data for being transferred data, with the determination pass
Whether connection data can be transferred to the validation database from the database to be tested, in such embodiments, in the pass
It is preferred that verification operation is carried out to the associated data before connection data are transferred, it can by the manually identifying of manager,
The verification operation for associated data can be completed by the Unsolicited Grant of validation database, if verifying does not pass through, can not incited somebody to action
The associated data is transferred to the validation database from the database to be tested, if being verified, by the associated data
The validation database is transferred to from the database to be tested.
Further, data corresponding with first control instruction in the database to be tested are transferred to the verifying
Step in database is completed by physical transfer mode, in such embodiments, the validation database and it is described to
Testing database is two independent databases, then real when the associated data is transferred to validation database from database to be tested
It is to delete the associated data from the database to be tested, and the associated data is created on the verify data on border
Library.
And in another embodiment, data corresponding with first control instruction in the database to be tested are shifted
It is completed to the step in the validation database by logic branch mode, in such embodiments, the database to be tested
And the validation database is actually a database, in such embodiments, is only existed not from management label
Together, i.e., when the associated data is transferred to validation database from database to be tested, management label is actually had changed, i.e., will
Originally the data of database to be tested were marked on, the data were marked again, make it have the label of validation database, i.e.,
It is modified with the verify data label for being transferred data.
It will be appreciated by those skilled in the art that there are the data that multiple and different sources are come in the database to be tested, while
Different sources can be marked, the validation database different mark information is returned when validation database is to transfer, into
One step, i.e., the described validation database can obtain the data of different mark informations, and when the data in different mark informations
In have can be with determined information after, the matched data of each determined mark information institute are similarly determined.
Fig. 3 shows another embodiment of the present invention, a kind of module company of dependent data management information system
Schematic diagram is connect, in conjunction with Fig. 1 and Fig. 2 of the invention, shows two kinds of control methods for dependent data management, and as this
The data base management system of the device class of invention, for cooperating the control method to complete the data information pipe for dependent data
Reason, in such embodiments, the present invention provides a kind of dependent data management information systems, are used to pass through validation database
And database cooperative response external data exchange instruction to be tested, the validation database 1 is included at least, is used to store main number
According to further including the database to be tested 2, be used to store and receive the data from multi-party platform, while further including one
Access control engine 3, the access control engine 3 after the first control instruction is triggered by the database 2 to be tested with institute
The corresponding data of the first control instruction are stated to be transferred in the validation database 1, in such embodiments, the access control
Engine 3 is separately connected the validation database 1 and the database to be tested 2, and the working principle of the access control engine 3 can
To refer to abovementioned steps S101, step S102, step S202, it will not be described here.
Further, the validation database 1 is stored on the same physical equipment with the database 2 to be tested,
In such embodiment, the physical equipment can be for computer, mobile phone terminal also or other terminal devices, and the physics is set
The validation database 1 present in standby can be completed to be associated with the database 2 to be tested based on above-mentioned data managing method
The transfer of data, the present invention are different from the transmission of data in two different terminals, more by data command triggering, data verification etc.
Kind form is completed to operate the control for shifting data.
Specific embodiments of the present invention are described above.It is to be appreciated that the invention is not limited to above-mentioned
Particular implementation, those skilled in the art can make various deformations or amendments within the scope of the claims, this not shadow
Ring substantive content of the invention.
Claims (7)
1. a kind of data control method of dependent data management, outside validation database and database cooperative response to be tested
Data exchange instruction, which comprises the steps of:
A. it is instructed by least one response external data exchange in the validation database and the database to be tested；
Wherein, further include following steps:
Data corresponding with first control instruction in the database to be tested are shifted after the first control instruction is triggered
To in the validation database.
2. control method according to claim 1, which is characterized in that in the case where meeting following condition, first control
System instruction is triggered:
- one or more identification instruction is received；
- one or more administrator instruction is received；
A data in the database to be tested is more than that first threshold and not receiving is directed to by the number of carry out data exchange
The falsfication of the data instructs；And
The associated data of a data in the database to be tested is transferred in the validation database.
3. control method according to claim 1 or 2, which is characterized in that with described first in the database to be tested
Further include any one of following steps after the corresponding data of control instruction are transferred to the validation database:
I. the associated data for being transferred data is transferred to the validation database from the database to be tested；Or
Ii. verification operation is carried out to the associated data for being transferred data, whether can be from institute with the determination associated data
It states database to be tested and is transferred to the validation database.
4. control method according to any one of claim 1 to 3, which is characterized in that by the database to be tested with
The corresponding data of first control instruction are transferred to the step in the validation database any one of in the following way
Or appoint a variety of completions:
Physical transfer mode；And
Logic branch mode.
5. control method according to claim 4, which is characterized in that mark quilt with the verify data for being transferred data
Modification.
6. a kind of dependent data management information system, which is characterized in that for being assisted by validation database and database to be tested
It instructs, includes at least with response external data exchange:
The validation database (1),
The database to be tested (2),
One access control engine (3), the access control engine (3) is after the first control instruction is triggered by the data to be tested
Data corresponding with first control instruction are transferred in the validation database (1) in library (2).
7. control method according to any one of claim 1 to 5 and information system according to claim 6,
It is characterized in that, the validation database (1) and the database (2) to be tested are stored on the same physical equipment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910601005.2A CN110377586A (en) | 2019-07-04 | 2019-07-04 | A kind of control method and data base management system of dependent data management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910601005.2A CN110377586A (en) | 2019-07-04 | 2019-07-04 | A kind of control method and data base management system of dependent data management |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110377586A true CN110377586A (en) | 2019-10-25 |
Family
ID=68252013
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910601005.2A Withdrawn CN110377586A (en) | 2019-07-04 | 2019-07-04 | A kind of control method and data base management system of dependent data management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110377586A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908978A (en) * | 2019-11-06 | 2020-03-24 | 中盈优创资讯科技有限公司 | Database data structure verification method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106326222A (en) * | 2015-06-16 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| WO2017048766A1 (en) * | 2015-09-17 | 2017-03-23 | Mastercard International Incorporated | Method and system for managing authentication services customer data |
| CN107679210A (en) * | 2017-10-17 | 2018-02-09 | 山东浪潮通软信息科技有限公司 | A kind of report data exchange method, apparatus and system |
| CN109324959A (en) * | 2018-08-13 | 2019-02-12 | 中国平安人寿保险股份有限公司 | A kind of method, server and the computer readable storage medium of automatic transfer data |
-
2019
- 2019-07-04 CN CN201910601005.2A patent/CN110377586A/en not_active Withdrawn
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106326222A (en) * | 2015-06-16 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| WO2017048766A1 (en) * | 2015-09-17 | 2017-03-23 | Mastercard International Incorporated | Method and system for managing authentication services customer data |
| CN107679210A (en) * | 2017-10-17 | 2018-02-09 | 山东浪潮通软信息科技有限公司 | A kind of report data exchange method, apparatus and system |
| CN109324959A (en) * | 2018-08-13 | 2019-02-12 | 中国平安人寿保险股份有限公司 | A kind of method, server and the computer readable storage medium of automatic transfer data |
Non-Patent Citations (1)
| Title |
|---|
| 任开银等: "数据交换系统中数据处理技术研究与应用", 《电力信息化》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908978A (en) * | 2019-11-06 | 2020-03-24 | 中盈优创资讯科技有限公司 | Database data structure verification method and device |
| CN110908978B (en) * | 2019-11-06 | 2022-09-13 | 中盈优创资讯科技有限公司 | Database data structure verification method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP2778929B1 (en) | Test script generation system | |
| US20150127579A1 (en) | Method and apparatus to present an integrated process modeler | |
| CN107315814B (en) | Method and system for verifying data consistency after data migration of KDB (KDB) database | |
| CN109683869A (en) | The development approach and device of DAPP | |
| US20230388885A1 (en) | Enhanced data analytics for actionable improvements based on data collected in wireless and streaming data networks | |
| CN111124917B (en) | Method, device, equipment and storage medium for managing and controlling public test cases | |
| CN110442498A (en) | Localization method, device, storage medium and the computer equipment of abnormal data node | |
| CN108376065A (en) | The system for building the avionics software development environment of model-driven | |
| CN109618315A (en) | A kind of control method of lighting apparatus, device, storage medium and intelligent terminal | |
| CN112380219B (en) | Method for defining block chain cochain data service stipulation and application service stipulation | |
| CN109960538A (en) | A kind of configuration interface management method, configuration interface managing device and electronic equipment | |
| CN111798580B (en) | Authority configuration method, device, system, server, terminal and storage medium | |
| CN110377586A (en) | A kind of control method and data base management system of dependent data management | |
| CN109558447A (en) | Data managing method, device and computer readable storage medium | |
| CN109118151B (en) | Work order transaction processing method and work order transaction processing system | |
| CN103873297A (en) | Processing method for reverse inheritance modeling of data acquisition and processing system | |
| CN111026569A (en) | Method for repairing designated block data in alliance chain | |
| CN103971224A (en) | Signing method and system | |
| CN109683942A (en) | Script management method, device, medium and electronic equipment | |
| CN109636952A (en) | Access control system and its management method | |
| WO2022083236A1 (en) | Animated video backup method and apparatus therefor, and animated video management method and apparatus therefor | |
| CN114327426A (en) | Security service implementation method based on visual workflow and related equipment | |
| CN110221952B (en) | Service data processing method and device and service data processing system | |
| CN107590542B (en) | Mobile equipment allocation and management method and device based on screen locking application | |
| CN107609740B (en) | Method and device for distributing and managing mobile equipment based on internal application |
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 | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20191025 |
|
| WW01 | Invention patent application withdrawn after publication |