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 PDF

Info

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
Application number
CN201910601005.2A
Other languages
Chinese (zh)
Inventor
严卫国
藏宇铎
王冠军
陆银飞
严晴远
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Run Information Technology Co Ltd
Original Assignee
Shanghai Run Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shanghai Run Information Technology Co Ltd filed Critical Shanghai Run Information Technology Co Ltd
Priority to CN201910601005.2A priority Critical patent/CN110377586A/en
Publication of CN110377586A publication Critical patent/CN110377586A/en
Withdrawn legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/214Database migration support
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60Protecting data
    • G06F21/62Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218Protecting 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

A kind of control method and data base management system of dependent data management
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.
CN201910601005.2A 2019-07-04 2019-07-04 A kind of control method and data base management system of dependent data management Withdrawn CN110377586A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (4)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
任开银等: "数据交换系统中数据处理技术研究与应用", 《电力信息化》 *

Cited By (2)

* Cited by examiner, † Cited by third party
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
WO2022160707A1 (en) Human-machine interaction method and apparatus combined with rpa and ai, and storage medium and electronic device
US11568338B2 (en) Task map providing apparatus and method thereof
EP2778929B1 (en) Test script generation system
US8930833B2 (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
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
CN110134930A (en) Electronic contract management method, device, computer equipment and storage medium
CN112380219B (en) Method for defining block chain cochain data service stipulation and application service stipulation
CN110377586A (en) A kind of control method and data base management system of dependent data management
CN109960538A (en) A kind of configuration interface management method, configuration interface managing device and electronic equipment
CN109558447A (en) Data managing method, device and computer readable storage medium
CN111798580B (en) Authority configuration method, device, system, server, terminal and storage medium
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
CN109118151B (en) Work order transaction processing method and work order transaction processing system
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

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