CN106446127A - Method for protecting data consistency using two-dimensional matrix table in database - Google Patents
Method for protecting data consistency using two-dimensional matrix table in database Download PDFInfo
- Publication number
- CN106446127A CN106446127A CN201610832425.8A CN201610832425A CN106446127A CN 106446127 A CN106446127 A CN 106446127A CN 201610832425 A CN201610832425 A CN 201610832425A CN 106446127 A CN106446127 A CN 106446127A
- Authority
- CN
- China
- Prior art keywords
- dimensional matrix
- matrix table
- unit
- data
- row
- 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.)
- Pending
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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
Abstract
The invention discloses a method for protecting data consistency using a two-dimensional matrix table in a database. The method is achieved by the steps that a service unit in need of verification and protection as well as constraint relations with related service units are stored in the form of the two-dimensional matrix table, wherein the service unit in need of the verification and protection refers to basic data dictionaries which run through a whole service module and are used frequently, and the dictionaries comprise a material dictionary and a supplier dictionary; and the correlated related service units refer to service records generated in actual service operations, including warehouse entry lists, warehouse delivery lists, lading bills and contracts. In comparison with the prior art, the method for protecting the data consistency using the two-dimensional matrix table in the database has the advantages that disastrous obstacles of software caused by wrong data operations are avoided; rigorousness of the software is enhanced; the data is kept intact and consistent; the practicability is high; the applicable scope is wide; and the method is highly valuable for promotion and application.
Description
Technical field
The present invention relates to field of computer technology, specifically one kind utilize two-dimensional matrix table to protect number in data base
According to conforming method.
Background technology
In software, the business unit of the software that some frequently use：Material dictionary, supplier's dictionary, warehouse dictionary, goods
Position dictionary, business personnel's dictionary etc., when information manager uses software initial, import or manual typing maintain substantial amounts of basis letter
Breath, such as material dictionary, including the crucial information of stock number, title, specifications and models, these information are once be used for business unit
In as outbound list, storage bill, between them, the row stock number of constraint cannot change deletion.If not taking effective control
Measure, once being deleted modification, business unit data, accounting data etc. arise that serious error in data, leads to manage soft
Part information is paralysed it is impossible to be continuing with.
Based on this, a kind of method utilizing two-dimensional matrix table to protect data consistency in data base is now provided, comes effectively
Protection business unit table data, thus avoid some data used in business function be tampered and delete by mistake, cause enterprise
Business is imperfect, and the inconsistent grade of data is than more serious problem.
Content of the invention
The technical assignment of the present invention is for above weak point, provides one kind to utilize two-dimensional matrix table to protect in data base
The method of shield data consistency.
A kind of method utilizing two-dimensional matrix table to protect data consistency in data base, it implements process and is：
By restriction relation between the business unit requiring verification to protect and relative business unit with two-dimensional matrix
The mode of table stores, and wherein needs the business unit verifying protection to refer to the basic number running through whole business module, frequently using
According to dictionary, including material dictionary, supplier's dictionary；The related service unit of association refers to the business note that practical business operation produces
Record, including storage bill, outbound list, bill of lading, contract.
Two-dimensional matrix table storage protection business unit and associated services unit restriction relation include herein below：
Restriction relation, the business unit of protection and associated services unit corresponding relation are described in the way of two-dimensional matrix table,
Wherein two-dimensional matrix table record verifies the mode of operation of restriction relation, including modification, deletes；Two-dimensional matrix table also records constraint and closes
Information in the presence of system.
Restriction relation is when checking by following logic realization：By incoming protection business unit, associated services unit, behaviour
Make the parameter information of type, i.e. operation flag, call parameters resolution component checks and whether there is restriction relation between the two, passes through
Rule match and Parameter analysis of electrochemical, obtain inspection result, and return this result, simultaneously by accordingly result record in daily record.
The two-dimensional matrix table of one record restriction relation of setting, this two-dimensional matrix table includes table name, table row, wherein table name
Including protection business unit, associated services unit, corresponding table row include protecting business unit row, associated services cell columns；
And operation flag, that is, the mark checking, changing, delete.
One tables of data of setting is used for depositing the record checking restriction relation, and its structure includes：Table name, table row, wherein table
Name includes protection business unit, associated services unit, and corresponding table row include protecting business unit row, associated services unit
Row；Metadata, i.e. associated services row initial value；New data, that is, associated services row are new is worth；Operation flag, that is, check, change, delete
Mark.
A kind of method and the prior art phase that utilize two-dimensional matrix table to protect data consistency in data base of the present invention
Ratio has the advantages that：
A kind of method utilizing two-dimensional matrix table to protect data consistency in data base of the present invention, there is provided Yi Zhongling
The side by utilizing two-dimensional matrix table protection data consistency in data base of configuration, ease for use height, the better user experience of living
Formula, it is to avoid data is misused and causes the catastrophic fault of software, improves the preciseness of software it is ensured that data is complete, consistent,
Practical, applied widely, there is good application value.
Brief description
Accompanying drawing 1 is the data structure schematic diagram of the present invention.
Specific embodiment
Below in conjunction with the accompanying drawings and specific embodiment the invention will be further described.
As shown in Figure 1, the present invention provides a kind of side utilizing two-dimensional matrix table protection data consistency in data base
Method, by using two-dimensional matrix table effective protection business unit table data, thus avoid some to use in business function
Data be tampered and delete by mistake, cause business event imperfect, the inconsistent grade of data is than more serious problem.
It implements process：
The method is realized by design software module, wherein software by require verify protection business unit and with its phase
Between the business unit closing, restriction relation is stored in the way of two-dimensional matrix table.The business unit needing verification protection refers to pass through
Wear whole business module, the basis of software data dictionary frequently using, such as material dictionary, supplier's dictionary etc.；Associated services list
Unit refers to the business record that practical business operation produces, such as storage bill, outbound list, bill of lading, contract etc..
Two-dimensional matrix table storage software protection business unit includes herein below with associated services unit restriction relation：
Restriction relation, the business unit of protection and associated services unit corresponding relation are described in the way of two-dimensional matrix table.
Two-dimensional matrix table record verifies the mode of operation of restriction relation, such as modification, deletion etc..
Information in the presence of two-dimensional matrix table record restriction relation.
It is arranged as required to the restriction relation in above-mentioned steps during running software, comprise herein below：
Software configures any content of two-dimensional matrix as needed in run duration.
Matrix information after adjustment can be able to be come into force with automatic synchronization, does not affect the software being currently running.
Software provides and calls resolution component automatically to check restriction relation and do the mode of respective handling, including herein below：
The implementation of resolution component is formed according to bivariate table configuration mode；
The mode record check restraint condition of software tables of data.
In above-mentioned steps, the two-dimensional matrix table of one record restriction relation of setting, structure is as follows：
Software is safeguarded by the configuration information that the intelligentized graphical interfaces of wizard-like provides restriction relation between business unit
Function.
Also can be by restriction relation between routine information item maintenance function automobile log-on service unit.
Business constraint relation checks logic：By the incoming parameter protecting business unit, associated services unit, action type
Information, calls resolution component to check and whether there is restriction relation between the two, return inspection result.
One tables of data of setting is used for depositing the record checking restriction relation, and its structure is as follows：
Further, specific implementation process of the present invention is as described below：
Step one, restriction relation resolution component implementation.
First determine whether to whether there is record in log sheet, if there is directly obtaining inquiry table information from daily record：
SELECT F_TABN,F_COLN,F_NOTE into:vs_table,:vs_coln,:vs_note FROM
LSDELZDLOG WHERE F_DELN=:Psdeln AND F_COLBH=:psoldvalue；
If len(trim(vs_table))>0then
Vssql=" select 1from LSXTMC WHERE EXISTS (SELECT 1FROM "+vs_table+ "
WHERE "+vsCol1+ "=' "+vsValues1+ " ' AND "+vsCol2+ ") "
End If.
If there is Query Result in object table, directly returning, otherwise deleting information in log sheet, continuing executing with following
Program：
Execution obtains result：
Record execution journal：
By specific embodiment above, described those skilled in the art can readily realize the present invention.But should
Work as understanding, the present invention is not limited to above-mentioned specific embodiment.On the basis of disclosed embodiment, described technical field
Technical staff can the different technical characteristic of combination in any, thus realizing different technical schemes.
In addition to technical characteristic described in except description, it is the known technology of those skilled in the art.
Claims (5)
1. a kind of in data base using two-dimensional matrix table protect data consistency method it is characterised in that it implements
Process is：By restriction relation between the business unit requiring verification to protect and relative business unit with two-dimensional matrix table
Mode store, wherein need the business unit verifying protection to refer to run through whole business module, the basic data frequently using
Dictionary, including material dictionary, supplier's dictionary；The related service unit of association refers to the business note that practical business operation produces
Record, including storage bill, outbound list, bill of lading, contract.
2. a kind of method utilizing two-dimensional matrix table to protect data consistency in data base according to claim 1, its
It is characterised by, two-dimensional matrix table storage protection business unit and associated services unit restriction relation include herein below：
Restriction relation, the business unit of protection and associated services unit corresponding relation are described in the way of two-dimensional matrix table, wherein
Two-dimensional matrix table record verifies the mode of operation of restriction relation, including modification, deletes；Two-dimensional matrix table also records restriction relation and deposits
When information.
3. a kind of method utilizing two-dimensional matrix table to protect data consistency in data base according to claim 1, its
It is characterised by, restriction relation is when checking by following logic realization：By incoming protection business unit, associated services unit,
The parameter information of action type, i.e. operation flag, call parameters resolution component checks and whether there is restriction relation between the two, leads to
Cross rule match and Parameter analysis of electrochemical, obtain inspection result, and return this result, simultaneously by accordingly result record in daily record.
4. a kind of method utilizing two-dimensional matrix table to protect data consistency in data base according to claim 1, its
It is characterised by, the two-dimensional matrix table of one record restriction relation of setting, this two-dimensional matrix table includes table name, table row, wherein table
Name includes protection business unit, associated services unit, and corresponding table row include protecting business unit row, associated services unit
Row；And operation flag, that is, the mark checking, changing, delete.
5. a kind of method utilizing two-dimensional matrix table to protect data consistency in data base according to claim 1, its
It is characterised by, one tables of data of setting is used for depositing the record checking restriction relation, and its structure includes：Table name, table row, wherein table
Name includes protection business unit, associated services unit, and corresponding table row include protecting business unit row, associated services unit
Row；Metadata, i.e. associated services row initial value；New data, that is, associated services row are new is worth；Operation flag, that is, check, change, delete
Mark.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610832425.8A CN106446127A (en) | 2016-09-19 | 2016-09-19 | Method for protecting data consistency using two-dimensional matrix table in database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610832425.8A CN106446127A (en) | 2016-09-19 | 2016-09-19 | Method for protecting data consistency using two-dimensional matrix table in database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106446127A true CN106446127A (en) | 2017-02-22 |
Family
ID=58165643
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610832425.8A Pending CN106446127A (en) | 2016-09-19 | 2016-09-19 | Method for protecting data consistency using two-dimensional matrix table in database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106446127A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106446182A (en) * | 2016-09-29 | 2017-02-22 | 贵州云众知乐教育科技有限公司 | Database engine |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101833473A (en) * | 2010-04-06 | 2010-09-15 | 浪潮集团山东通用软件有限公司 | Method for solving functional operation conflict inside management software by configuring conflict matrix |
-
2016
- 2016-09-19 CN CN201610832425.8A patent/CN106446127A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101833473A (en) * | 2010-04-06 | 2010-09-15 | 浪潮集团山东通用软件有限公司 | Method for solving functional operation conflict inside management software by configuring conflict matrix |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106446182A (en) * | 2016-09-29 | 2017-02-22 | 贵州云众知乐教育科技有限公司 | Database engine |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10430875B2 (en) | Integration and enhancement of business systems with external services | |
| US8688507B2 (en) | Methods and systems for monitoring transaction entity versions for policy compliance | |
| US8170902B2 (en) | Methods and systems for compliance monitoring case management | |
| US9183526B2 (en) | Metadata-driven audit reporting system that applies data security to audit data | |
| US11093521B2 (en) | Just-in-time data quality assessment for best record creation | |
| KR101013810B1 (en) | An excel-based management system for updating db tables and the method thereof | |
| US20160094681A1 (en) | Versatile Information Management System | |
| DE102014116369A1 (en) | MANAGEMENT OF LANGUAGE MARKERS IN INTERNATIONAL DATA STORAGE | |
| An et al. | Supplementary bug fixes vs. re-opened bugs | |
| CN106383812A (en) | New contract policy test method and apparatus | |
| CN103020753A (en) | Document state display system and document state display method | |
| US20100106541A1 (en) | Analyzing the Readiness of a Template | |
| CN106446127A (en) | Method for protecting data consistency using two-dimensional matrix table in database | |
| CN106250726A (en) | Software version state management-control method | |
| CN113220777A (en) | Service data processing method and device, computer equipment and storage medium | |
| US9773005B2 (en) | Polymorphic application of policy | |
| US7899835B2 (en) | Method and system for reviewing business activity of a business entity | |
| US9116935B2 (en) | Method and system to promote database cost savings | |
| DE102018113148A1 (en) | Method for audit-proof storage of data | |
| US11704094B2 (en) | Data integrity analysis tool | |
| US10402390B1 (en) | Model validation system | |
| Singleton | How to perform more effective audits by focusing on the data | |
| CN112965900A (en) | Data auditing method, device, server and storage medium based on block chain | |
| Tan et al. | A systematic approach for the design of post-transaction input error handling | |
| CN112069194A (en) | Real-time modification method and system for data in database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170222 |
|
| RJ01 | Rejection of invention patent application after publication |