CN102999607A - Data storage method, data access method and related devices - Google Patents
Data storage method, data access method and related devices Download PDFInfo
- Publication number
- CN102999607A CN102999607A CN2012104767564A CN201210476756A CN102999607A CN 102999607 A CN102999607 A CN 102999607A CN 2012104767564 A CN2012104767564 A CN 2012104767564A CN 201210476756 A CN201210476756 A CN 201210476756A CN 102999607 A CN102999607 A CN 102999607A
- Authority
- CN
- China
- Prior art keywords
- data
- user
- tables
- organization identification
- organization
- 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
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a data storage method, a data access method and related devices, which can be used for reducing the workloads of establishing and maintaining a database. The data storage method disclosed by the embodiment comprises the following steps of: establishing a database instance for storing data of each organization; establishing a first data sheet in the database instance, wherein the first data sheet contains organization identifier fields which are used for indicating organizations to which the data belongs; adding each organization data to the first data sheet; distributing corresponding organization identifiers to each organization data according to the organizations to which the data belong; and establishing a correspondence relationship between a user and the organization identifiers. The embodiment of the invention also provides other related methods and the devices. According to the embodiment of the invention, the workloads of establishing and maintaining the database can be effectively reduced.
Description
Technical field
The present invention relates to data processing field, relate in particular to a kind of date storage method, data access method and relevant apparatus.
Background technology
Aggravation along with the globalizing market competition, a lot of large-scale group enterprises have faced very large challenge when the operation of cross-region, inter-trade, diversification, how internal resource is effectively integrated, improve the ability of resource utilization and enterprise's fast responding market, become important problem of enterprise.Under traditional Decentralization pattern, the infotech of enterprise (IT, Information Technology) framework lacks unified basis, makes IT circumstance complication and out of control.Therefore, the centralized management pattern has progressively been selected by a lot of enterprises, and IT system is enterprise-level application from the department level application upgrade, and business data has also been realized centralized stores and management.
In the prior art, for realizing the target of data centralization storage and control data access, Enterprise IT System has generally used a kind of comparatively simple method, the implementation procedure of the method is: the application system that is respectively the subordinate of enterprise tissue creates a database instance, and the data of each tissue are stored in the corresponding example; Because the data of different tissues are stored in the different database instances, so the data of different tissues isolate mutually, do not interfere with each other; During the data organized under the user accesses him, system creates the connection of a database instance corresponding with this tissue for him, to finish data access.
But have following shortcoming in the scheme of prior art: when scope of the enterprise is larger, when existing more subordinate to organize, IT department of enterprise is corresponding will to be respectively creation database examples of these tissues, and workload is huge.On the other hand, mass data storehouse example independent of one another lacks unified standard and form between the data, also increased follow-up maintenance cost, such as database upgrade, backup and recovery etc.
Summary of the invention
The embodiment of the invention discloses a kind of date storage method, data access method and relevant apparatus, can effectively reduce the workload of database initialize and maintenance, thereby reduce cost.
The date storage method that the embodiment of the invention provides comprises:
Create the database instance that is used for preserving each data of organizing;
Create the first tables of data in described database instance, include the organization identification field in described the first tables of data, described organization identification field is used for the tissue under the expression data;
In described the first tables of data, add each organising data;
According to the tissue under described each organising data, for described each organising data distributes corresponding organization identification;
Set up the corresponding relation between user and the described organization identification.
Alternatively, described first tables of data that creates in described database instance comprises:
Create raw data table;
In described raw data table, add the organization identification field, thereby obtain described the first tables of data.
Alternatively, described the first tables of data has unified Standards and formats, so that each organising data is stored according to described Standards and formats.
Alternatively, the corresponding relation between the described user of foundation and the described organization identification comprises:
Create the second tables of data, described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
The user name of each organizing user is made an addition in described the second tables of data, and the organization identification of the tissue under this user is set in the organization identification field of described the second tables of data.
The data access method that the embodiment of the invention provides comprises:
When logging in system by user, obtain described user's user name;
Organization identification corresponding to the described user name of inquiry from the second tables of data, described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
The organization identification that inquires is stored in the system context;
Receive described Client-initiated query requests;
The data relevant with tissue under the described user according to the organization identification in described system context inquiry.
Alternatively, described method also comprises:
When logging in system by user, obtain the check information of described user's input;
Described check information is authenticated;
If authentication success then triggers described step of inquiring about organization identification corresponding to described user name from the second tables of data; If authentification failure, the then login of refusing user's.
The data storage device that the embodiment of the invention provides comprises:
Database creation unit is used for creating the database instance for the data of preserving each tissue;
The tables of data creating unit is used for creating the first tables of data at described database instance, includes the organization identification field in described the first tables of data, and described organization identification field is used for the tissue under the expression data;
Adding device is used for adding each organising data in described the first tables of data;
Allocation units are used for according to the tissue under described each organising data, for described each organising data distributes corresponding organization identification;
Set up the unit, be used for setting up the corresponding relation between user and the described organization identification.
Alternatively, the described unit of setting up comprises:
Create subelement, be used for creating the second tables of data, described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
Add subelement, be used for the user name of each organizing user is made an addition to described the second tables of data, and the organization identification of the tissue under this user is set in the organization identification field of described the second tables of data.
The DAA that the embodiment of the invention provides comprises:
Acquiring unit is used for obtaining described user's user name when logging in system by user;
The first query unit is used for from organization identification corresponding to the second tables of data described user name of inquiry, and described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
Storage unit is used for the organization identification that inquires is stored in system context;
Receiving element is used for receiving described Client-initiated query requests;
The second query unit is used for the data relevant with tissue under the described user according to the organization identification inquiry of described system context.
Alternatively, described device also comprises:
Verification unit is used for when logging in system by user, obtains the check information of described user's input, and described check information is authenticated, if authentication success then triggers described the first query unit and carries out corresponding operating, if authentification failure, the then login of refusing user's.
Can be found out that by technique scheme the embodiment of the invention has following beneficial effect:
In the embodiment of the invention, after having created database instance, can in this database instance, create the first tables of data, include the organization identification field in this first tables of data, this organization identification field is used for the tissue under the expression data, simultaneously after in the first tables of data, adding each organising data, can distribute corresponding organization identification for each organising data, but also can set up corresponding relation between user and the organization identification, therefore can find out, in the embodiment of the invention, can indirectly associate user and organising data by organization identification, so that just can concentrate the organising data of preserving each tissue in a database instance, thus the workload of database initialize and maintenance reduced, and then reduce cost.
Description of drawings
Fig. 1 is embodiment synoptic diagram of date storage method in the embodiment of the invention;
Fig. 2 is another embodiment synoptic diagram of date storage method in the embodiment of the invention;
Fig. 3 is embodiment synoptic diagram of data access method in the embodiment of the invention;
Fig. 4 is another embodiment synoptic diagram of data access method in the embodiment of the invention;
Fig. 5 is embodiment synoptic diagram of data storage device in the embodiment of the invention;
Fig. 6 is embodiment synoptic diagram of DAA in the embodiment of the invention.
Embodiment
The embodiment of the invention discloses a kind of date storage method, data access method and relevant apparatus, can effectively reduce the workload of database initialize and maintenance, thereby reduce cost.
See also Fig. 1, embodiment of date storage method comprises in the embodiment of the invention:
101, create the database instance that is used for preserving each data of organizing;
In the embodiment of the invention, data storage device can at first create the database instance for the data of preserving each tissue.
Be understandable that this database instance can be the database instance in the various different relational database systems, Microsoft SQL Server for example, Oracle, DB2, MySQL etc., concrete kind is not done restriction herein.
102, in database instance, create the first tables of data;
After the database instance establishment is finished, can in the database instance that has created, create the first tables of data, include the organization identification field in this first tables of data, this organization identification field is used for the tissue under the expression data.
103, in the first tables of data, add each organising data;
After the establishment of the first tables of data is finished, the data that then can in the first tables of data that has created, add each tissue.
104, according to the tissue under each organising data, for each organising data distributes corresponding organization identification;
Owing to include the organization identification field in the first tables of data, this organization identification field is used for the tissue under the expression data, and the data of each tissue have own affiliated tissue, so after these organising datas are added into the first tables of data, can according to the tissue under each organising data, distribute corresponding organization identification in the organization identification field of the first tables of data for each organising data.
105, set up corresponding relation between user and the organization identification.
When each organising data is added into the first tables of data, and be assigned with after the corresponding organization identification, then can have set up the corresponding relation between user and the organization identification, so that user and organization identification are associated.
In the present embodiment, after having created database instance, can in this database instance, create the first tables of data, include the organization identification field in this first tables of data, this organization identification field is used for the tissue under the expression data, simultaneously after in the first tables of data, adding each organising data, can distribute corresponding organization identification for each organising data, but also can set up corresponding relation between user and the organization identification, therefore can find out, in the embodiment of the invention, can indirectly associate user and organising data by organization identification, so that just can concentrate the organising data of preserving each tissue in a database instance, thus the workload of database initialize and maintenance reduced, and then reduce cost.
For ease of understanding, the below is described in detail the date storage method in the embodiment of the invention with an instantiation, sees also Fig. 2, and another embodiment of date storage method comprises in the embodiment of the invention:
201, create the database instance that is used for preserving each data of organizing;
In the embodiment of the invention, data storage device can at first create the database instance for the data of preserving each tissue.
Be understandable that this database instance can be the database instance in the various different relational database systems, Microsoft SQL Server for example, Oracle, DB2, MySQL etc., concrete kind is not done restriction herein.
202, in database instance, create raw data table;
After the database instance establishment is finished, can set up raw data table according to usual way first in the present embodiment, the structure of concrete raw data table can be as shown in table 1:
Table 1
203, in raw data table, add the organization identification field, thereby obtain the first tables of data;
After raw data table is set up and is finished, can obtain the first tables of data to raw data table adjustment, concrete, can in raw data table, add the organization identification field, thereby obtain this first tables of data, this organization identification field is used for the tissue under the expression data.
The first tables of data in the present embodiment has unified Standards and formats, so that each organising data is stored according to this Standards and formats.
In the present embodiment, the structure of the first tables of data that obtains can be as shown in table 2:
Table 2
204, in the first tables of data, add each organising data;
After the establishment of the first tables of data is finished, then can in the first tables of data that has created, add each organising data, make newly-built database instance can comprise the data that each is organized fully, reach the purpose of centralized stores.
In the present embodiment, the structure of having added each organising data the first tables of data afterwards can be as shown in table 3:
Table 3
205, according to the tissue under each organising data, for each organising data distributes corresponding organization identification;
Owing to include the organization identification field in the first tables of data, this organization identification field is used for the tissue under the expression data, and the data of each tissue have own affiliated tissue, so after these organising datas are added into the first tables of data, can according to the tissue under each organising data, distribute corresponding organization identification in the organization identification field of the first tables of data for each organising data.
In the present embodiment, distributed the structure of the first tables of data after the organization identification can be as shown in table 4:
Table 4
206, create the second tables of data;
In the present embodiment, when each organising data is added into the first tables of data, and be assigned with after the corresponding organization identification, then can have set up the corresponding relation between user and the organization identification, so that user and organization identification are associated.
Concrete, at first can create the second tables of data, this second tables of data is used for preserving the corresponding relation between user and the organization identification.
The second tables of data in the present embodiment can be as shown in table 5:
Table 5
207, the user name with each organizing user makes an addition in the second tables of data, and the organization identification of the tissue under this user is set in the organization identification field of the second tables of data.
In the present embodiment, create after the second tables of data, can add the user name of each tissue in user and the organization identification data, and tissue under this user is set in the organization identification field.
In the present embodiment, can be as shown in table 6 through the second tables of data after arranging:
Table 6
In the present embodiment, after having created database instance, can in this database instance, create the first tables of data, include the organization identification field in this first tables of data, this organization identification field is used for the tissue under the expression data, simultaneously after in the first tables of data, adding each organising data, can distribute corresponding organization identification for each organising data, but also can set up corresponding relation between user and the organization identification, therefore can find out, in the embodiment of the invention, can indirectly associate user and organising data by organization identification, so that just can concentrate the organising data of preserving each tissue in a database instance, thus the workload of database initialize and maintenance reduced, and then reduce cost.
The above is described the date storage method among the present invention, and the below is described data access method of the present invention from the angle of data access, sees also Fig. 3, and embodiment of data access method comprises in the embodiment of the invention:
301, when logging in system by user, obtain user's user name;
When some users wish data query, then can login system, when login system, DAA then can get access to this user's user name.
302, the organization identification of inquiring user name correspondence from the second tables of data;
DAA gets access to after the user's of login system the user name, can inquire about organization identification corresponding to this user name according to the second tables of data of pre-save, need to prove that in the present embodiment, this second tables of data is used for preserving the corresponding relation between user and the organization identification.
303, the organization identification that inquires is stored in the system context;
DAA inquires after organization identification corresponding to user name, the organization identification that inquires can be stored in the system context, uses for the subsequent query process.
304, receive the Client-initiated query requests;
When this user wished to carry out data query, then DAA can be received this Client-initiated query requests.
305, the data relevant with tissue under the user according to the organization identification in system context inquiry.
In the present embodiment, because DAA is stored in the organization identification that inquires in the system context in step 303, so the data that this moment, DAA can be relevant with tissue under the user according to the inquiry of the organization identification in the system context.
In the present embodiment, DAA can use the incidence relation of preserving in the second tables of data when visit data, thereby filters out the organising data that has nothing to do with this user, the data of tissue under the user can have access to.Therefore, this invention can only create a database instance, satisfies the data centralization storage demand of many tissues, and can effectively isolate the data under the different tissues, does not interfere with each other.
For ease of understanding, the below is described in detail the data access method in the embodiment of the invention with an instantiation, sees also Fig. 4, and another embodiment of data access method comprises in the embodiment of the invention:
401, when logging in system by user, obtain user's user name and check information;
When some users wish data query, then can login system, when login system, DAA then can get access to this user's user name and check information, and this check information can for login name and password etc., specifically not done restriction herein.
402, check information is authenticated, if authentication success, then execution in step 403, if authentification failure, then repeated execution of steps 401;
After DAA gets access to this user's check information, can authenticate this check information, specifically can compare with the information of preserving in the local security database, if comparison is consistent, then determine authentication success, if compare inconsistently, then determine authentification failure.
When authentification failure, the login that DAA can refusing user's, and repeated execution of steps 401.
403, the organization identification of inquiring user name correspondence from the second tables of data;
When DAA is determined this user's authentication success, can inquire about organization identification corresponding to this user name according to the second tables of data of pre-save, need to prove that in the present embodiment, this second tables of data is used for preserving the corresponding relation between user and the organization identification.
Concrete, the second tables of data in the present embodiment can be shown in aforementioned table 6.
The user that the tentation data access means gets access to is called " Xiao Li ", then can inquire the organization identification corresponding with " Xiao Li " by table 6 and be " sales department ".
404, the organization identification that inquires is stored in the system context;
DAA inquires after organization identification corresponding to user name, the organization identification that inquires can be stored in the system context, uses for the subsequent query process.
For example, DAA can be stored in " sales department " in the system context, uses for the subsequent query process.
405, receive the Client-initiated query requests;
When this user wished to carry out data query, then DAA can be received this Client-initiated query requests.
406, the data relevant with tissue under the user according to the organization identification in system context inquiry.
In the present embodiment, because DAA is stored in the organization identification that inquires in the system context in step 404, so the data that this moment, DAA can be relevant with tissue under the user according to the inquiry of the organization identification in the system context.
For example, the organization identification of preserving in the system context this moment is " sales department ", so when this user wishes to carry out data query, DAA can be known, what this user wished to inquire about is that organization identification is the organising data of " sales department ", then the final data access means can extract query structure and feed back to the user from aforementioned table 4, and concrete Query Result can be as shown in table 7:
Table 7
In the present embodiment, DAA can use the incidence relation of preserving in the second tables of data when visit data, thereby filters out the organising data that has nothing to do with this user, the data of tissue under the user can have access to.Therefore, this invention can only create a database instance, satisfies the data centralization storage demand of many tissues, and can effectively isolate the data under the different tissues, does not interfere with each other.
The above is described the date storage method in the embodiment of the invention and data access method, and the below is described corresponding device, sees also Fig. 5, and data storage device embodiment of the present invention comprises:
Database creation unit 501 is used for creating the database instance for the data of preserving each tissue;
Tables of data creating unit 502 is used for creating the first tables of data at this database instance, includes the organization identification field in this first tables of data, and this organization identification field is used for the tissue under the expression data;
Adding device 503 is used for adding each organising data in this first tables of data;
Allocation units 504 are used for according to the tissue under this each organising data, for this each organising data distributes corresponding organization identification;
Set up unit 505, be used for setting up the corresponding relation between user and this organization identification.
The unit 505 of setting up in the present embodiment can further include:
Create subelement 5051, be used for creating the second tables of data, this second tables of data is used for preserving the corresponding relation between user and this organization identification;
Add subelement 5052, be used for the user name of each organizing user is made an addition to this second tables of data, and the organization identification of the tissue under this user is set in the organization identification field of this second tables of data.
The performed function in each unit in the present embodiment data storage device is consistent with the flow process of aforementioned middle description embodiment illustrated in fig. 2, repeats no more herein.
In the present embodiment, after database creation unit 501 has created database instance, tables of data creating unit 502 can create the first tables of data in this database instance, include the organization identification field in this first tables of data, this organization identification field is used for the tissue under the expression data, simultaneously when adding device 503 adds each organising data in the first tables of data after, allocation units 504 can distribute corresponding organization identification for each organising data, and set up unit 505 and also can set up corresponding relation between user and the organization identification, therefore can find out, in the embodiment of the invention, can indirectly associate user and organising data by organization identification, so that just can concentrate the organising data of preserving each tissue in a database instance, thus the workload of database initialize and maintenance reduced, and then reduce cost.
See also Fig. 6, DAA embodiment of the present invention comprises:
Acquiring unit 601 is used for obtaining this user's user name when logging in system by user;
The first query unit 602 is used for from organization identification corresponding to the second tables of data this user name of inquiry, and this second tables of data is used for preserving the corresponding relation between user and this organization identification;
Receiving element 604 is used for receiving this Client-initiated query requests;
The second query unit 605 is used for the data relevant with tissue under this user according to the organization identification inquiry of this system context.
DAA in the embodiment of the invention can further include:
The performed function in each unit in the present embodiment DAA is consistent with the flow process of aforementioned middle description embodiment illustrated in fig. 4, repeats no more herein.
In the present embodiment, DAA can use the incidence relation of preserving in the second tables of data when visit data, thereby filters out the organising data that has nothing to do with this user, the data of tissue under the user can have access to.Therefore, this invention can only create a database instance, satisfies the data centralization storage demand of many tissues, and can effectively isolate the data under the different tissues, does not interfere with each other.
One of ordinary skill in the art will appreciate that all or part of step that realizes in above-described embodiment method is to come the relevant hardware of instruction to finish by program, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium of mentioning can be ROM (read-only memory), disk or CD etc.
More than a kind of date storage method provided by the present invention, data access method and relevant apparatus are described in detail, for one of ordinary skill in the art, thought according to the embodiment of the invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (10)
1. a date storage method is characterized in that, comprising:
Create the database instance that is used for preserving each data of organizing;
Create the first tables of data in described database instance, include the organization identification field in described the first tables of data, described organization identification field is used for the tissue under the expression data;
In described the first tables of data, add each organising data;
According to the tissue under described each organising data, for described each organising data distributes corresponding organization identification;
Set up the corresponding relation between user and the described organization identification.
2. method according to claim 1 is characterized in that, described first tables of data that creates in described database instance comprises:
In described database instance, create raw data table;
In described raw data table, add the organization identification field, thereby obtain described the first tables of data.
3. method according to claim 1 is characterized in that, described the first tables of data has unified Standards and formats, so that each organising data is stored according to described Standards and formats.
4. each described method in 3 according to claim 1 is characterized in that the corresponding relation between the described user of foundation and the described organization identification comprises:
Create the second tables of data, described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
The user name of each organizing user is made an addition in described the second tables of data, and the organization identification of the tissue under this user is set in the organization identification field of described the second tables of data.
5. a data access method is characterized in that, comprising:
When logging in system by user, obtain described user's user name;
Organization identification corresponding to the described user name of inquiry from the second tables of data, described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
The organization identification that inquires is stored in the system context;
Receive described Client-initiated query requests;
The data relevant with tissue under the described user according to the organization identification in described system context inquiry.
6. method according to claim 5 is characterized in that, described method also comprises:
When logging in system by user, obtain the check information of described user's input;
Described check information is authenticated;
If authentication success then triggers described step of inquiring about organization identification corresponding to described user name from the second tables of data; If authentification failure, the then login of refusing user's.
7. a data storage device is characterized in that, comprising:
Database creation unit is used for creating the database instance for the data of preserving each tissue;
The tables of data creating unit is used for creating the first tables of data at described database instance, includes the organization identification field in described the first tables of data, and described organization identification field is used for the tissue under the expression data;
Adding device is used for adding each organising data in described the first tables of data;
Allocation units are used for according to the tissue under described each organising data, for described each organising data distributes corresponding organization identification;
Set up the unit, be used for setting up the corresponding relation between user and the described organization identification.
8. device according to claim 7 is characterized in that, the described unit of setting up comprises:
Create subelement, be used for creating the second tables of data, described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
Add subelement, be used for the user name of each organizing user is made an addition to described the second tables of data, and the organization identification of the tissue under this user is set in the organization identification field of described the second tables of data.
9. a DAA is characterized in that, comprising:
Acquiring unit is used for obtaining described user's user name when logging in system by user;
The first query unit is used for from organization identification corresponding to the second tables of data described user name of inquiry, and described the second tables of data is used for preserving the corresponding relation between user and the described organization identification;
Storage unit is used for the organization identification that inquires is stored in system context;
Receiving element is used for receiving described Client-initiated query requests;
The second query unit is used for the data relevant with tissue under the described user according to the organization identification inquiry of described system context.
10. device according to claim 9 is characterized in that, described device also comprises:
Verification unit is used for when logging in system by user, obtains the check information of described user's input, and described check information is authenticated, if authentication success then triggers described the first query unit and carries out corresponding operating, if authentification failure, the then login of refusing user's.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012104767564A CN102999607A (en) | 2012-11-21 | 2012-11-21 | Data storage method, data access method and related devices |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012104767564A CN102999607A (en) | 2012-11-21 | 2012-11-21 | Data storage method, data access method and related devices |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102999607A true CN102999607A (en) | 2013-03-27 |
Family
ID=47928175
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2012104767564A Pending CN102999607A (en) | 2012-11-21 | 2012-11-21 | Data storage method, data access method and related devices |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102999607A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106384057A (en) * | 2016-04-27 | 2017-02-08 | 平安科技(深圳)有限公司 | Data access authority identification method and device |
CN106557884A (en) * | 2016-11-30 | 2017-04-05 | 中国南方电网有限责任公司 | index library generating method and device |
CN107577784A (en) * | 2017-09-15 | 2018-01-12 | 郑州云海信息技术有限公司 | A kind of data correlation method and device |
CN109219807A (en) * | 2016-05-19 | 2019-01-15 | 微软技术许可有限责任公司 | Reconciliation foreign key reference and table safety strategy |
CN110611660A (en) * | 2019-08-22 | 2019-12-24 | 山东浪潮通软信息科技有限公司 | Enterprise-level multi-domain-name login integration method |
CN110851853A (en) * | 2019-09-18 | 2020-02-28 | 平安科技(深圳)有限公司 | Data isolation method and device, computer equipment and storage medium |
CN111339560A (en) * | 2020-02-26 | 2020-06-26 | 中国邮政储蓄银行股份有限公司 | Data isolation method, device and system |
CN115328882A (en) * | 2022-06-27 | 2022-11-11 | 光大环境科技(中国)有限公司 | Method and system for creating distributed database cluster |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2002054222A1 (en) * | 2001-01-08 | 2002-07-11 | Capricorn Computer Systems, Inc. | Method for accessing a database |
CN101448002A (en) * | 2008-12-12 | 2009-06-03 | 北京大学 | Method and device for accessing digital resources |
CN101499061A (en) * | 2008-01-30 | 2009-08-05 | 国际商业机器公司 | Multi-tenant oriented database engine and its data access method |
CN102479186A (en) * | 2010-11-23 | 2012-05-30 | 金蝶软件(中国)有限公司 | Method, device and system for integrating third-party service system authority into data processing system |
-
2012
- 2012-11-21 CN CN2012104767564A patent/CN102999607A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2002054222A1 (en) * | 2001-01-08 | 2002-07-11 | Capricorn Computer Systems, Inc. | Method for accessing a database |
CN101499061A (en) * | 2008-01-30 | 2009-08-05 | 国际商业机器公司 | Multi-tenant oriented database engine and its data access method |
CN101448002A (en) * | 2008-12-12 | 2009-06-03 | 北京大学 | Method and device for accessing digital resources |
CN102479186A (en) * | 2010-11-23 | 2012-05-30 | 金蝶软件(中国)有限公司 | Method, device and system for integrating third-party service system authority into data processing system |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106384057A (en) * | 2016-04-27 | 2017-02-08 | 平安科技(深圳)有限公司 | Data access authority identification method and device |
CN109219807A (en) * | 2016-05-19 | 2019-01-15 | 微软技术许可有限责任公司 | Reconciliation foreign key reference and table safety strategy |
CN109219807B (en) * | 2016-05-19 | 2022-01-21 | 微软技术许可有限责任公司 | System, method, and medium providing access to a database |
CN106557884A (en) * | 2016-11-30 | 2017-04-05 | 中国南方电网有限责任公司 | index library generating method and device |
CN106557884B (en) * | 2016-11-30 | 2018-05-29 | 中国南方电网有限责任公司 | index library generating method and device |
CN107577784A (en) * | 2017-09-15 | 2018-01-12 | 郑州云海信息技术有限公司 | A kind of data correlation method and device |
CN110611660A (en) * | 2019-08-22 | 2019-12-24 | 山东浪潮通软信息科技有限公司 | Enterprise-level multi-domain-name login integration method |
CN110611660B (en) * | 2019-08-22 | 2021-08-24 | 浪潮通用软件有限公司 | Enterprise-level multi-domain-name login integration method |
CN110851853A (en) * | 2019-09-18 | 2020-02-28 | 平安科技(深圳)有限公司 | Data isolation method and device, computer equipment and storage medium |
CN111339560A (en) * | 2020-02-26 | 2020-06-26 | 中国邮政储蓄银行股份有限公司 | Data isolation method, device and system |
CN111339560B (en) * | 2020-02-26 | 2023-06-13 | 中国邮政储蓄银行股份有限公司 | Data isolation method, device and system |
CN115328882A (en) * | 2022-06-27 | 2022-11-11 | 光大环境科技(中国)有限公司 | Method and system for creating distributed database cluster |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102999607A (en) | Data storage method, data access method and related devices | |
US10623406B2 (en) | Access authentication for cloud-based shared content | |
US9286475B2 (en) | Systems and methods for enforcement of security profiles in multi-tenant database | |
US9569634B1 (en) | Fine-grained structured data store access using federated identity management | |
CN102708316B (en) | Method for isolating data in multi-tenant architecture | |
US10037430B2 (en) | System and method for controlling the on and off state of features of business logic at runtime | |
EP2706700A1 (en) | Computer account management system and implementation method thereof | |
US20200311031A1 (en) | User Environment, Multi-user Collaborative Data Governance Method and Computer-Readable Storage Medium | |
CN108092945B (en) | Method and device for determining access authority and terminal | |
US20110314520A1 (en) | Online service access controls using scale out directory features | |
CN111159134A (en) | Multi-tenant-oriented distributed file system security access control method and system | |
CN104123616A (en) | Cloud computing system towards multiple tenants | |
CN105184144A (en) | Multi-system privilege management method | |
CN107113341A (en) | The system of the high-throughput processing of affairs in the Distributed Relation Database Management System divided for data | |
CN103023921A (en) | Authentication and access method and authentication system | |
CN102314480A (en) | Distributed data storage method specific to mass data | |
CN102917006A (en) | Method and device for achieving uniform control management of computing resource and object authority | |
CN104298761A (en) | Implementation method for master data matching between heterogeneous software systems | |
CN109565443A (en) | Certificate deployment based on range | |
CN104217283A (en) | Data sharing device and data sharing system | |
US20180137301A1 (en) | Proxy-controlled compartmentalized database access | |
CN111752539B (en) | BI service cluster system and construction method thereof | |
CN103220172A (en) | Device and method based on LDAP (lightweight directory access protocol) user authorization management | |
CN106210134A (en) | A kind of enterprise based on virtual desktop cloud service system | |
JP5664441B2 (en) | Resource management system, data update method and program |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130327 |