CN1549164A - Data bank system and data access method thereof - Google Patents
Data bank system and data access method thereof Download PDFInfo
- Publication number
- CN1549164A CN1549164A CNA031235905A CN03123590A CN1549164A CN 1549164 A CN1549164 A CN 1549164A CN A031235905 A CNA031235905 A CN A031235905A CN 03123590 A CN03123590 A CN 03123590A CN 1549164 A CN1549164 A CN 1549164A
- Authority
- CN
- China
- Prior art keywords
- estate
- database systems
- grade
- user
- data
- 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
Images
Landscapes
- Storage Device Security (AREA)
Abstract
The data base system features that it is established based on business data grade classification. It includes at least at least one first set with unique first grade classified based on the requirement of the user; the second set related with the first set and providing business data related to the first set; and the corresponding relation for correlatively positioning between the first set and the second set via utilizing the uniqueness of the first classification. Correspondingly, the system has data access method including data adding course, searching course, displaying course and authority realizing course.
Description
Technical field
The present invention relates generally to Database Systems and data access method thereof.
Background technology
Along with massaging devices such as personal computer extensively popularize and be accompanied by expansion by the online service of networks such as the world is interconnected, then the quantity of needed database and type increase sharply.
Present computer database system branch comprises following several, promptly netted graphic data storehouse, tree data storehouse, relational database (Relational Database, RDB) and object-oriented database (Object-oriented Database, OODB).These conventional databases uses and a kind ofly are correlated with, have the Database field of clearly describing feature in logic based on several when handling mass data, represent the uniqueness of this type of information.In information process, the data field of data storage and inquiry is of a great variety, and each data all will have the respective field type, need or estimate that when being provided with the number of the use word of maximum possible is provided with according to the number of using word at that time on demand.As making the data security visit, need additionally to represent the storage space of user right in the data storage areas, ensure the secure access of data message.
In addition, it is after having analyzed all and needing the information of managing object that tradition is utilized the method for data base administration information, information is divided into " project name " and " contents of a project " dialog box, thereby cause in the dialog box of correspondence, the corresponding contents of a project can only be inserted, operations such as inquiry, statistics, editor could be realized.So just require a large amount of dialog boxes and database table, and each is to dialog box, can only inserts specific and only one data content.For example taking care of books software except that book information, can not be managed other kinds of information.Prescriptions of traditional Chinese medicine software is except prescriptions of traditional Chinese medicine can not be managed other kinds of information.Its reason be exactly the title of dialog box be specific, and then cause the Database Systems versatility poor.
The problem that above-mentioned database exists is:
1) in Database field is set, several fields of clearly describing feature must be arranged, thereby cause the field of describing feature a lot, which information management and user of service are that easy generation of important information obscured to.
2) number of the word of representing with data field type in information process need be estimated to set, and promptly information stores is limited its memory length, needs to judge artificially to estimate the canned data segment, loses valuable information so probably;
3) occupying volume is represented the storage space of user right outward, ensures the secure access of data message.
4) at needs personnel various complicated operation of step during, easily cause database file to damage, be unfavorable for safeguarding the database field operations.
5) title of each dialog box is fixed in the traditional method of utilizing the database access data, therefore need set up a large amount of dialog boxes and database table,
Summary of the invention
The problem that the present invention solves provides a kind of Database Systems, avoids that Database field is numerous and diverse, information stores length limited and operation steps complexity.The data access method of these Database Systems correspondingly, is provided.
For addressing the above problem, Database Systems of the present invention are set up based on the business datum grade classification, comprising:
At least one first set, each first set has unique the first estate, and this first estate is divided according to user's needs;
Second set is associated with first set, and the business datum that is associated with first set is provided;
Corresponding relation utilizes the uniqueness of the first estate to carry out association location between first and second set.
Wherein, the first estate is provided with unique identification, and the business datum that is associated has identical sign or points to the unique identification of the first estate or directly point to the first estate, sets up corresponding corresponding relation with this related location.
First set is or/and second set is provided with the distribution rights field, to determine user's access rights.
Common title of every kind of grade general characterization can be chosen all corresponding this kind grades in the dialog box that claims to name with this general character assumed name, reach the purpose of unified management information.
Correspondingly, based on the data access method of described Database Systems, comprise data interpolation process, retrieving, procedure for displaying, this method also comprises the authority implementation procedure, and the authority implementation procedure may further comprise the steps:
(1) at first adds the corresponding rights field of distributing;
(2) divide users by user of service's access rights are different, the distribution that corresponding employing figure pattern is carried out, rights of using are distributed the numerical value combination that can add up as required, and no repeated code is finished the user right distribution;
(3) user of service just can be according to distributing the authority permission to check information.
Compared with prior art, the present invention has the following advantages:
1) according to grade classification set up that Database Systems avoid that Database field is numerous and diverse, information stores length limited and operation steps complexity
2) database of access privilege is set, need not to be provided with in addition the rights database field and just can correctly distribute.
3) the present invention is directed to business administration and relate to matters such as expense is examined, administrative measure and need not to adopt other schemes, avoid the waste on the Enterprise Resource, the tightness degree of improvement personnel and scheme improves the operability of embodiment.
4) the restricted information memory length does not reduce error in judgement.
5) simple to operate, database table is beneficial to maintenance less.
Description of drawings
Fig. 1 is the Database Systems first embodiment synoptic diagram of the present invention.
Fig. 2 is the Database Systems second embodiment synoptic diagram of the present invention.
Fig. 3 is Database Systems the 3rd an embodiment synoptic diagram of the present invention
Fig. 4 is Fig. 3 instantiation synoptic diagram.
Fig. 5-the 8th, Database Systems instantiation of the present invention interface synoptic diagram.
Fig. 9 is the process flow diagram that data are added into Database Systems in the data access method of the present invention.
Figure 10 is the process flow diagram that authority realizes in the data access method of the present invention.
Embodiment
The present invention sets up Database Systems in the mode of grade classification, and present embodiment is classified (hereinafter can describe in detail) according to the degree that is associated or the significance level of business, also can classify by other rules certainly.These Database Systems comprise at least one first set, and each first set has unique the first estate, and this first estate needs and divides; Second set is associated with first set, and the business datum that is associated with first set is provided; Corresponding relation utilizes the uniqueness of the first estate to carry out association location between first and second set, below can concrete narration.
Please refer to Fig. 1 and combination with reference to shown in the table 1,2, Database Systems of the present invention comprise at least one first set 1 and second set 2 that is associated with first set 1 based on the storage space 4 of existing database platform, wherein utilize corresponding relation 3 to carry out the association location.Each first set 1 comprises a first estate 10, and this first estate 10 is well-determined, adopts a unique identification, and for example feature field " is mainly described title "; Second set 2 comprises the business datum relevant with the first estate 10, adopts the feature field (unique identification) of common feature field (being identical sign) " mainly describing title " or sensing the first estate 10, sets up corresponding relation 3.Business datum also can further be divided into several first and second in this second set 2 ... N grade 20, each grade all needs to be associated with the first estate 10 certainly.Utilize the unique identification of the first estate 10 to carry out the association location of business datum in this example.
First set, 1 (table 1):
| The first estate 10 (unique) |
| The main title of describing |
| The main title abbreviation |
| Distribute authority |
Second set, 2 (tables 2):
| Second and third, four ... |
| The main title of describing |
| Main descriptive text |
| Less important descriptive text |
| Additional descriptive text |
| ????…… |
Please refer to Fig. 2 and combination with reference to shown in the table 3.1,3.2,4, among Database Systems second embodiment of the present invention, first set 1 also includes second grade 12 that several are associated with the first estate 10, is provided with the first estate 10 to adopt the feature field (unique identification) of common feature field (being identical sign) " mainly describing title " or sensing the first estate 10 or directly point to the first estate.And second set 2 is provided with the feature field (be identical sign) " mainly describe title " common with the first estate 10 simultaneously, and with its common feature field (being identical sign) " less important description title " of second grade 12 that is associated; Perhaps second set 2 is pointed to the feature field (unique identification) of the first estate 10 simultaneously and is directly pointed to first and second grade 10,12 with the feature field (sign) of its second grade 12 that is associated or relevant business datum.Present embodiment first set 1 utilizes second grade, 12 auxiliary related location, certainly, also can utilize more directly or indirectly relevant with the first estate 10 auxiliary related location of grade, sets up first with this and gathers 1 and second and gather 2 corresponding relation 3.In addition, also can not point to feature field during related the location, but directly point to the first estate 10 and other relevant auxiliary positioning grades in first set 1, set up the corresponding relation 3 of first set, 1 and second set 2 with this.
First set, 1 (table 3.1,3.2):
| The first estate 10 (unique) |
| The main title of describing |
| The main title abbreviation |
| Distribute authority |
| Second grade 12 (several) |
| The main title of describing |
| Less important description title |
| Less important title abbreviation |
| Distribute authority |
Second set, 2 (tables 4):
| Third and fourth ... |
| The main title of describing |
| Less important description title |
| Main descriptive text |
| Less important descriptive text |
| Additional descriptive text |
| ????…… |
Please continue with reference to shown in the table 3.1,3.2,4, each grade also comprises other fields: title abbreviation, descriptive text, distribution authority etc., and the scope maximum of the first estate, it is minimum to comprise concrete data content, other grades scope refinement are successively dwindled, and the content that comprises is concrete more.Its specific descriptions are as follows:
The data structure that the first estate 10 is set by the main descriptive text that is suitable for its service needed/general character/degree of correlation/statistics needs and other rules comprises the Pinyin abbreviation of main description title, title and the rights field that the first estate 10 is distributed, said structure provides the main scope of the first estate 10 data storage, when the full text of business datum is handled, play the effect of related location, set up corresponding relation successively.
The less important descriptive text of one or several relevant with service needed is provided with the data structure of second grade 12, comprise the Pinyin abbreviation of the main description title of service needed, one or several less important description titles relevant, less important description title, the rights field that second grade 12 is distributed with its service needed, can the secondary scope that second grade, 12 data storage are provided be described by one or several said structures, when the data of business datum are handled in full, play the effect of auxiliary related location, set up corresponding relation 3 with this.
Unique identification in first set 1 is arranged on the first estate 10, plays the effect of related location when second set 2 is handled.Second grade 12 is provided secondary scope in second set 2 by its structrual description, and wherein feature field plays the effect of auxiliary related location when second set 2 is handled.Can use the unique identification of the first estate 10 separately or unite use second grade 12/ other auxiliary positioning grades, set up corresponding relation 3.The first estate 10 in first set 1 is provided with the distribution rights field with auxiliary related location grade 12, to determine user's access rights.Really, can in second set 2, also can be provided with the distribution rights field as required.
Please refer to shown in Fig. 3,4, the 3rd embodiment of Database Systems of the present invention, comprise several first set 1, each first set 1 only is provided with a unique the first estate 10, wherein each first set 1 and identical with second embodiment with the corresponding relation 3 of second set 2, repeat no more,, second set 2 can be divided into some subclass really for convenient storage.
In the present embodiment, the first estate 10 in each first set 1 all is stored in the database table 14 (master library tables of data), all auxiliary related grades (as second grade 12) of locating are existed in another database table 16 (auxilliary database data table).The business datum of second set 2 is stored in the database table 22 (business datum table).In the present embodiment, each the first estate 10 general character is changed into a title master library classification, in its corresponding user interfaces, master library classification dialog box can be chosen all the first estates 10; In like manner second grade, 12 general character change into the auxilliary storehouse of title classification, and in its corresponding user interfaces, dialog box can be chosen the second all grades 12, and other grade also can be taked this sample loading mode storage, and restricted information memory length not.This mode with a common title of every kind of grade general characterization (can choose all corresponding this kind grades in the dialog box that claims to name with this general character assumed name) can be with all information resources of company/unit of a database system management.
Please refer to shown in Fig. 5-8, is the instantiation interface synoptic diagram that the applicant adopts Database Systems of the present invention.As seen from the figure, Database Systems of the present invention adopt five grades to be followed successively by: master library classification, auxilliary storehouse classification, primary key, secondary key, text.Wherein master library classification, auxilliary storehouse classification belong in first set 1, the auxiliary related location of auxilliary storehouse classification, and other grades then belong to second set 2.
In the dialog box of master library classification, selectable the first estate 10 has: TS adds up man-hour, case paperwork management, Chinese stack room etc.; Corresponding auxilliary storehouse classification is respectively with it: employee's name, telephony recording, publishing house etc.
Data access method based on Database Systems of the present invention comprises: data are added process, retrieving, procedure for displaying and authority implementation procedure.
The interpolation process comprises the steps:
(1) execution in step 91, at first be by managerial personnel to existing information, carry out carrying out collating sort at the scope that operation relates to according to present situation by correlation degree, user of service degree of dependence and other rules to data, promptly be divided into some the first estates.
(2) execution in step 92,93, and the user of service under managerial personnel's auxiliary guidance, has the field of clearly describing feature to divide associated ratings by close relation and data significance level with the user of service according to each the first estate several for the first time.
(3) execution in step 94, and by the height typing successively of grade, typing work thereafter can be by the user of service from line operate.
(4) execution in step 95, and the user of service can be according to Business Nature and the characteristics of oneself, by above-mentioned analysis, create the descriptive text that is suitable for its service needed or operation after concluding its peculiar business datum, add Database Systems to.
Data retrieval process comprises the steps:
(1) it is different and divide the user at first to be that managerial personnel set by user of service's access rights, originally is that to be divided into four kinds in the example be external user, general user, advanced level user, keeper.
(2) information that will retrieve according to the user of service, selection is suitable for the main descriptive text of the first estate of its service needed from the general character dialog box (master library classification) of the first estate.
(3) after having selected the first estate, from the general character dialog box of second grade (auxilliary storehouse classification), select and the corresponding less important descriptive text of its service needed again, if more than of grade two continues selection until finishing.
(4) if the user of service promptly reaches the purpose of retrieval by step (2), (3), then search complete, otherwise proceed following operation.
(5) need the user of service to provide the content of third and fourth grade general character dialog box (primary key, secondary key), the content of the 5th grade general character dialog box (text) is that the descriptive text that adds can omit.
Procedure for displaying shows the information that retrieves.
The authority implementation procedure comprises the steps:
(1) execution in step 100, at first add the corresponding rights field of distributing, when the field structure of the first estate is provided with, be provided with " distribute authority " field.
(2) execution in step 102, divide the user by user of service's access rights are different, as are divided into four kinds of users, i.e. external user, general user, domestic consumer, keeper.
The distribution that corresponding employing figure pattern is carried out is respectively numeral 1, numeral 2, numeral 4, numeral 8, and rights of using are distributed the numerical value combination that can add up as required, and no repeated code is finished the user right distribution.
(3) execution in step 104, and the user of service just can be according to distributing the authority permission to check information.
In sum, the present invention has the following advantages:
1) according to grade classification set up that Database Systems avoid that Database field is numerous and diverse, information stores length limited and operation steps complexity
2) database of access privilege is set, need not to be provided with in addition the rights database field and just can correctly distribute.
3) the present invention is directed to business administration and relate to matters such as expense is examined, administrative measure and need not to adopt other schemes, avoid the waste on the Enterprise Resource, the tightness degree of improvement personnel and scheme improves the operability of embodiment.
4) the restricted information memory length does not reduce error in judgement.
Claims (14)
1, a kind of Database Systems is characterized in that, these Database Systems are set up based on the business datum grade classification, comprising:
At least one first set, each first set has unique the first estate, and this first estate is divided according to user's needs;
Second set is associated with first set, and the business datum that is associated with first set is provided;
Corresponding relation utilizes the uniqueness of the first estate to carry out association location between first and second set.
2, Database Systems as claimed in claim 1, it is characterized in that, the first estate is provided with unique identification, and the business datum that is associated has identical sign or points to the unique identification of the first estate or directly point to the first estate, sets up corresponding corresponding relation with this related location.
3, Database Systems as claimed in claim 2, it is characterized in that, first set also comprises the auxiliary related location grade that several and the first estate are associated, and should auxiliary related location grade be associated, set up first and second corresponding relation between gathering with this with related service data in second set.
4, Database Systems as claimed in claim 3 is characterized in that, auxiliary related location grade has the identical sign of the first estate or points to the unique identification of the first estate or directly point to the first estate, with this association.
5, Database Systems as claimed in claim 4, it is characterized in that, auxiliary related location grade has sign, and relevant business datum has identical sign or points to the sign of auxiliary related location grade or directly point to auxiliary related location grade, with this association.
6, Database Systems as claimed in claim 5, it is characterized in that, all the first estates are stored in the database table, and all auxiliary related location class stores are in another database table, and the business datum in second set is stored in the business datum table.
7, Database Systems as claimed in claim 6 is characterized in that, second set comprises some grades, and each grade is related with the first estate foundation during relevant first gathers.
8, as any one described Database Systems of claim 2 to 7, it is characterized in that, be designated feature field.
9, Database Systems as claimed in claim 1 is characterized in that, common title of every kind of grade general characterization can be chosen all corresponding this kind grades in the dialog box that claims to name with this general character assumed name.
10, the described Database Systems of claim 9 is characterized in that, the general character assumed name of first, second, third and fourth and five grades claim be respectively: master library classification, auxilliary storehouse classification, primary key, secondary key and text.
11, Database Systems as claimed in claim 1 is characterized in that, first set is provided with the distribution rights field, to determine user's access rights.
As claim 1 or 11 described Database Systems, it is characterized in that 12, second set is provided with the distribution rights field, to determine user's access rights.
13, a kind of data access method based on the described Database Systems of claim 1 comprises data interpolation process, retrieving, procedure for displaying, it is characterized in that this method also comprises the authority implementation procedure, and the authority implementation procedure may further comprise the steps:
(1) at first adds the corresponding rights field of distributing;
(2) by different user, the corresponding employing numbers divided of user of service's access rights
The distribution that word pattern carries out, rights of using distribute numerical value to carry out as required
The combination that adds up, no repeated code is finished user right and is distributed;
(3) user of service just can be according to distributing the authority permission to check information.
14, the data access method of stating as claim 13 is characterized in that, data interpolation process may further comprise the steps:
(1) at first be by managerial personnel to existing information, carry out by related journey according to present situation
Degree and user of service's needs are put in order at the scope that operation relates to
Classification is to be divided into some the first estates;
(2) user of service is for the first time under managerial personnel's auxiliary guidance, by following the end user
Member's close relation and data significance level are carried out according to each the first estate
Divide associated ratings;
(3) by the height typing successively of grade;
(4) user of service can by above-mentioned analysis, conclude its business datum as required
The descriptive text that is suitable for its service needed or operation is created in the back, adds number to
According to the storehouse system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA031235905A CN1549164A (en) | 2003-05-16 | 2003-05-16 | Data bank system and data access method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA031235905A CN1549164A (en) | 2003-05-16 | 2003-05-16 | Data bank system and data access method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1549164A true CN1549164A (en) | 2004-11-24 |
Family
ID=34321383
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA031235905A Pending CN1549164A (en) | 2003-05-16 | 2003-05-16 | Data bank system and data access method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1549164A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101996218A (en) * | 2009-08-21 | 2011-03-30 | 上海博科资讯股份有限公司 | Method for realizing data access authority control |
| CN101625699B (en) * | 2009-07-28 | 2013-01-09 | 大连新中连软件集团有限公司 | Application software business control method and system based on business componentization |
| CN106230865A (en) * | 2016-09-29 | 2016-12-14 | 郑州云海信息技术有限公司 | A kind of secure access monitoring method, system and big data platform |
| CN107656943A (en) * | 2016-08-23 | 2018-02-02 | 平安科技（深圳）有限公司 | Job enquiry method and server |
| CN112597516A (en) * | 2020-12-23 | 2021-04-02 | 上海融恒智能科技有限公司 | Multi-stage linkage authority control system and method |
-
2003
- 2003-05-16 CN CNA031235905A patent/CN1549164A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101625699B (en) * | 2009-07-28 | 2013-01-09 | 大连新中连软件集团有限公司 | Application software business control method and system based on business componentization |
| CN101996218A (en) * | 2009-08-21 | 2011-03-30 | 上海博科资讯股份有限公司 | Method for realizing data access authority control |
| CN101996218B (en) * | 2009-08-21 | 2013-07-24 | 上海博科资讯股份有限公司 | Method for realizing data access authority control |
| CN107656943A (en) * | 2016-08-23 | 2018-02-02 | 平安科技（深圳）有限公司 | Job enquiry method and server |
| CN107656943B (en) * | 2016-08-23 | 2020-01-14 | 平安科技（深圳）有限公司 | Task query method and server |
| CN106230865A (en) * | 2016-09-29 | 2016-12-14 | 郑州云海信息技术有限公司 | A kind of secure access monitoring method, system and big data platform |
| CN112597516A (en) * | 2020-12-23 | 2021-04-02 | 上海融恒智能科技有限公司 | Multi-stage linkage authority control system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6236988B1 (en) | Data retrieval system | |
| US8037059B2 (en) | Implementing aggregation combination using aggregate depth lists and cube aggregation conversion to rollup aggregation for optimizing query processing | |
| Gosink et al. | HDF5-FastQuery: Accelerating complex queries on HDF datasets using fast bitmap indices | |
| AU777792B2 (en) | System for managing RDBM fragmentations | |
| CN102362273A (en) | Dynamic hash table for efficient data access in relational database system | |
| CN1255215A (en) | System and method for storing and manipulating data in information handling system | |
| EP0753819A1 (en) | System and method for accessing cobol data with a cobol compatible structured query language | |
| ZA200100187B (en) | Value-instance-connectivity computer-implemented database. | |
| CN1652112A (en) | Implementing method of data dictionary under embedded environment | |
| WO2005092032A2 (en) | Secure virtual data warehousing system and method | |
| CN1635494A (en) | Method for implementing class memory database access and retrieval | |
| CN1924915A (en) | Database technique based library intelligent management system | |
| US7051016B2 (en) | Method for the administration of a data base | |
| Tousidou et al. | Signature-based structures for objects with set-valued attributes | |
| CN101916275B (en) | Method and system for accessing log data of multiple data sources | |
| CN1549164A (en) | Data bank system and data access method thereof | |
| Sheng et al. | Dynamic top-k range reporting in external memory | |
| Grandi et al. | Frame-sliced partitioned parallel signature files | |
| Catania et al. | Lazy XML updates: laziness as a virtue, of update and structural join efficiency | |
| Lopes Siqueira et al. | A spatial bitmap-based index for geographical data warehouses | |
| CN101430706B (en) | Subobject checking method, system and equipment for complex object | |
| Haw et al. | Query optimization techniques for xml databases | |
| CN1430148A (en) | Method of storing and accessing embedded database | |
| Kelly | Persistent Memory Allocation: Leverage to move a world of software | |
| CN1493995A (en) | Method of control system safety management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |