CN107148625A - The method for the management split to the information object being stored in single database - Google Patents
The method for the management split to the information object being stored in single database Download PDFInfo
- Publication number
- CN107148625A CN107148625A CN201580058828.5A CN201580058828A CN107148625A CN 107148625 A CN107148625 A CN 107148625A CN 201580058828 A CN201580058828 A CN 201580058828A CN 107148625 A CN107148625 A CN 107148625A
- Authority
- CN
- China
- Prior art keywords
- tenant
- separator
- shared
- data
- value
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/213—Schema design and management with details for schema evolution support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to the automatic management method that the information object that will be stored in single database is divided into independent fragment.The automatic management method that the information object being stored in single database is split is included：Create metadata object, " shared attribute "；Set " shared object " parameter；The metadata object of entitled " session parameter " is set, tenant and/or tenant are organized ID and stored together with currently separating identifier value by the metadata object of entitled " session parameter "；Recognize specific tenant and define the currency of each separator metadata object；The data area of the isolation of the metadata object comprising " shared attribute " with addition is distributed to each tenant；When writing data into the segmentation information object with " shared attribute " metadata object, " shared attribute " value is write into corresponding row；Generation is inquired about to obtain data from the data area for distributing to tenant.Separator quotes segmentation information object and provides complete and partial data segmentation.
Description
Technical field
The present invention relates to the multi-tenant architecture for providing service as the tenant from multiple tissues using isolation method, and more
Body, it is related to the method that the information object that will be stored in single database is divided into the automatic management of independent fragment.
Multi-tenant can be used in single service (device or deployment) using isolation method as the tenant from various tissues (i.e.
Individual subscriber) service is provided.Key is to ensure that subscriber keeps being mutually isolated.
Background technology
Known prior art includes solution US 2013/086322A1, and which depict one or more by adding
Field (row) is used as the method that separator carrys out segmented table data.
However, because each one or more new separators row must be added into each form or catalogue, therefore should
Method is tended to relatively time consuming.
The content of the invention
The purpose of the present invention is to create a kind of mechanism and method split for flexible management data, i.e., by making for phase
Same application solution enables or disables data segmentation, for example, to ensure that it can work under local (" desktop ") pattern,
And it can be worked in the case where multiple subscribers access the pattern of identical network service (" cloud segmentation "), and for application solution
The framework of itself does not have significant modification.
The technological achievement of the present invention provides complete and partial data segmentation.For example, some data can by a organized way
(for example, catalogue of bank) is shared, and other data of such as business or financial data are that tenant is specific and only specific
Tissue is shown and available.
Definition
Configuration is the application solution based on 1C platforms, and is the combination of algorithm, form and data structure.It is any to match somebody with somebody
The main purpose put is that correct record is preserved, such as accounting purpose.1C platforms, which are one group, to be used to store specific to theme
The specialized object of the data in region：Constant, catalogue, the chart of document and account.
Attribute is shown in the catalogue to be filled in application solution or the field of document.Each attribute is with specified
How its Value Types stored and user can be characterized using its property.
Separator (shared attribute) is to allow to make for multiple configuration objects (catalogue, document, the chart of account, constant etc.)
With the metadata object (configuration object) of single attribute.Configuration developer can add and configure " shared attribute ", to avoid pair
The modification of standard configuration object.In other words, developer can set and management shared attribute for all or some objects, without
It is for each existing catalogue (being referred to as in the prior art " form ") addition separator row." shared attribute " object has some
Predefined property, such as title, content (list of object or catalogue, wherein to use shared attribute), value, partition data
Use.
Metadata is description related data layout and its configuration object interacted with database.
Session parameter is configuration sharing object.Some currency is set and is stored in current 1C：In enterprise's session.Example
Such as, session parameter can be used to limit the access to the data of entry level.
Technological achievement is by the way that advantages of the present invention as described below is combined realization.In the first embodiment party of the present invention
In formula, the method for the automatic management split to the information object being stored in single database includes：It is preliminary to create at least
One metadata object, " shared attribute ", metadata object is used as separator and stored at least one segmentation information object
Reference and the separator value source；Define how at least one segmentation information object using the " shared of it
Attribute " parameter；Set the metadata object of entitled " session parameter ", the metadata object storage of entitled " session parameter " need by
The ID of the tenant for accessing various segmentation information objects and/or tenant's group is authorized, and also stores current separation identifier value；Identification is special
Fixed tenant and/or tenant's group, and define when database session starts the currency of each separator metadata object；To every
Data area of individual tenant and/or the tenant component with isolation, the region includes the metadata of " shared attribute " with addition
Object；When writing data into the segmentation information object that with the addition of " shared attribute " metadata object, " shared attribute " value is write
Enter in corresponding row；Generation is inquired about to obtain data from the data area for distributing to specific " tenant " and/or tenant's group.
In the case of the embodiment of the present invention, if relative to " using automatically " property of " shared attribute " parameter
Matter is set as " use ", then " shared attribute " created is automatically added to all existing configuration objects and all new establishments
Configure object.If " using automatically " property relative to " shared attribute " parameter is set as " without using ", attribute is not automatic
It is added to configuration object；Need to add the object of separator using " content " property selection of separator.
In second embodiment of the present invention, what the information object being stored in single database was split is automatic
The method of management includes：Preliminary create will be used as at least two " shared attribute " metadata objects of separator, each object
Store the source to the reference of at least one segmentation information metadata object and the value of separator；Including being marked to splitting comprising condition
The reference of the divisible constant of will "true" or "false", the divisible constant is another in the separator for quoting segmentation information object
The part of one separator in itself；Set the metadata object of entitled " session parameter ", the metadata of entitled " session parameter "
Object storage needs to access the ID of the tenant of various segmentation information objects and/or tenant's group and also stores current separator
Value；Once database session starts, specific tenant and/or tenant's group are recognized, so as to define the value of each separator；To each
Tenant and/or tenant's component match somebody with somebody isolated data storehouse, and the database is comprising metadata object and for by by " shared category
Property " value and condition segmentation value of statistical indicant filtered, to each tenant and/or tenant's component with data area；Write when by data
When entering the segmentation information object of separator reference, identifier value will be separated and write in corresponding separator row；Generation inquiry so as to from point
The data area of the specific tenant of dispensing and/or tenant's group obtains data.
In the case of the embodiment of the present invention, in addition to segmentation information object, database is also comprising at least
One shared object, splits value of statistical indicant regardless of session parameter and condition, the shared object can be accessed by all users with
At least it is used for read operation.Except its content and value, whether " shared attribute " object can also be in shared mould comprising partition data
The instruction used under formula, the shared model can have at least one in two value "true" or "false", and when database meeting
When words start, identification tenant and/or tenant's group, and set current sessions parameter.If shared model be set as "true" and
These users call the information object in database, then ignore current sessions parameter and authorize in access segmentation information object
Depending on a random set entry of programme controlled set isolation identifier value, to be at least used for read operation.
The management of data segmentation must be flexible, enables or disables data to be provided for identical application solution, for example
To ensure that it can work under local (" desktop ") pattern, and identical network service (" cloud can be accessed in multiple subscribers
Segmentation ") pattern under work, and there is no significant modification to the framework of application solution in itself.Furthermore, it is necessary to enable and disable
The special object in the memory of (such as form) is segmented in, to be partially isolating data and to make it can to single subscription tenant
With, and other data can be shared by all or some tenants.
The principle of data segmentation is based on new configuration object, " shared attribute ".
The pattern of shared attribute operation is set using data Partition property.This configuration object has both of which：
1. " if data segmentation " property is set as " without using ", the configuration object created is used only as being included in multiple
Attribute in (whole) configuration object.
2. " if data segmentation " property is set as " splitting ", shared attribute is used as data delimiter.
The method provides the management of the data stored in information bank segmentation and the management of application solution operation.
The first embodiment of invention claimed represents the letter relatively split using at least one separator
Single method.
In this second embodiment, the side split using the more complicated data of two or more separators is described
Method.The advantage of this method be its can use condition data segmentation come manage data segmentation.
The splicing mechanism being characterized with dividing method provides part and complete data are split.For example, some data can
By in a organized way (for example, bank's catalogue) share, and other data of such as business or financial data be tenant it is specific and
Only particular organization shows and can use.
This method enormously simplify the application when the record that single application solution is used in multiple tissues is preserved
The management and renewal of solution situation.
The first embodiment of dividing method includes creating the single shared attribute metadata object as separator.Separate
Reference of the symbol storage to one or more segmentation information objects.It further indicates the source of the value of separator.It is fixed to be specified for separator
How justice uses the parameter of separator in one or more segmentation metadata objects.Set the metadata of entitled " session parameter "
Object.The metadata object storage of entitled " session parameter " needs to access the tenant of various segmentation information objects and tenant's group
ID.It also stores current separation identifier value.When database session starts, specific tenant and/or tenant's group are recognized, and it is fixed
The currency of adopted each separator metadata object.This method also include to each tenant and/or tenant's component match somebody with somebody comprising with
The data area of the isolation of the metadata object of " shared attribute " of addition.In addition, when information is written into shared attribute
When in the segmentation information object in database, the value of shared attribute is written into corresponding row.Therefore, generation inquiry so as to from point
The data area of dispensing specific " tenant " and/or tenant's group obtains data.
If the shared attribute created needs to be automatically added in the configuration object of all existing and all new establishments,
" using automatically " property in shared attribute parameter is set to " use ".If however, " using automatically " property is set as " not making
With ", then attribute is not automatically added to configure object；Pair for needing to add separator is selected using " content " property of separator
As.
In another embodiment of dividing method (two or more separators), shared attribute metadata pair is also created
As and the shared attribute metadata object be used as separator.Different from first embodiment, in this embodiment, creating
Build at least two shared attribute metadata objects.Assuming that separator should include to constant and carry out the number that freely separator is quoted
According to the reference of the segmentation information object in storehouse.Split the constant of mark "true" or "false" comprising condition, be one of another separator
Divide and be also divided.Similar to first embodiment, the metadata object of entitled " session parameter " is set.When tenant is identified
And during session start, the isolated data storehouse comprising metadata object be allocated and be used by by " shared attribute " value and
Condition segmentation value of statistical indicant filtering to be that each tenant and/or tenant's component match somebody with somebody data area.Similar to first embodiment, this
Embodiment also includes that the corresponding separator row of identifier value write-in will be separated when writing information into the information object in database
In, and generate inquiry.
In addition, database includes segmentation information object and shared object, it is regardless of session parameter and condition segmentation mark
How is value, and the shared object can be accessed at least to be used for read operation by all users.
In addition to its content and value, whether " shared attribute " can also use in a shared mode comprising partition data
Indicate.The pattern can have two values：At least one in "true" or "false".When database session starts, identification is specific
Tenant and/or tenant's group, that is, set current session parameter.
Embodiment
In the first embodiment of the present invention, " data segmentation " property is set as " without using ".
Let us consider that how this embodiment can use in 1C softwares.
Before software startup, acquiescence creates at least one separator in designer.The separator is used for automatically will altogether
Enjoy information bank and be divided into single isolation information storehouse automatically, each isolation information storehouse is by the Admin Administration of its own.
For example, shared information bank potentially includes multiple information banks, each information bank includes all documents of particular organization.Such as
Fruit tissue separator is used as standard delimiter in designer, then shares information bank and be divided into multiple information banks, information bank
Each information bank be isolation and operated under its own configuration, and the text from other isolated data storehouses can not be accessed
Shelves.
Then " shared attribute " metadata object is created.For example, you can be shared --- shared attribute --- by selection
New object is added in allocation window to complete.
Next, specifying the property of a shared attribute.
A the title of shared attribute) is specified in default behavior.
B) in character of use：
The interior of shared attribute is specified using the drop-down menu (list for configuring object) shown in configuration editor
Hold (content property), the shared attribute that will be added has been compiled in the list for configuring object.
Window for editing shared attribute content is divided into two parts, and whether each part includes relevant shared attribute
The information (" using row ") of specific object should be applied to：
- above partly list all configuration objects that can be included in shared attribute content；
- under partly list pair with the setting of default setting for being different from being defined by the automatic character of use of shared attribute
As.
If the property is set as " use ", pair not being included in shared attribute content is listed in the lower part of window
As.
If the property is set as " without using ", pair being included in shared attribute content is listed in the lower part of window
As.
Configuration object can be edited in the upper part or lower part of window.The configuration object of editor will be according to using in row
Value and moved between the part of window.
For each configuration object, one of three below value can be set as using row：
1. it is automatic：Object will be configured and distribute to value of the shared attribute depending on the automatic character of use of shared attribute：
- use：Configuration object is included in shared attribute content；
- without using：Configuration object is not included in shared attribute content.
2. use：Regardless of automatic character of use value, configuration object is included in shared attribute content.
3. without using：Regardless of automatic character of use value, configuration object is not included in shared attribute content.
Configuration object can be included in shared attribute content below：Catalogue, document, the chart of characteristic type, account
Chart, calculate type chart, operation flow, task, information register, accumulation register, accounting registration, counter register
And exchange plan.
C) then, the drop-down menu in allocation window is used to select how the object with listing in content property associatedly makes
With shared attribute (automatic character of use).
If automatic character of use is set as " use ", the shared attribute created is automatically added to all existing configurations
Object (if enabled for these objects using shared attribute) and the configuration object of all new establishments.
If " using automatically " property is set as " without using ", the attribute will not be automatically added to configure object；Use
" content " property selects to need to add the object of shared attribute.
If shared attribute is used automatically, the property is also used, but also have some should not add shared attribute
Object.
Then the metadata object of entitled " session parameter " is specified.The metadata object storage of entitled " session parameter " needs
Access the entity (tenant) of various segmentation information objects and/or the ID of group of entities (tenant's group).
Therefore, upon power-up of the system, initializing set session parameter value.These values are based on startup order line or are information bank
The option for the value that user specifies uses instruction and the value of separator of separator to store.
Then the data that network analysis is inputted, specifically：
The specific tenant of-identification and/or tenant's group, or setting current sessions parameter (such as based on machine ID) in addition,
So as to define a value for each metadata object；
- identification to be used to splitting shared information bank specific separation identifier value (if for example, separator is set as tissue,
Then shared data bank is divided into by the database of tissue isolation by system)；
- identify whether to set shared attribute, if it is, determining that the shared attribute needs which configuration pair be added into
As.
When setting all parameters, shared information bank is divided into the information bank of multiple isolation, in these information banks
In, the shared data of establishment is added to the configuration object used by keeper based on specified parameter.
If shared attribute segmentation is conditionally disabled：
1. when reading and writing data, ignore the currency that definition separates identifier value and the session parameter used.
On the contrary, using values below.
Use attribute --- true (using acquiescence separator)；
Separate identifier value --- the default value of Delimiter Type.
2. when reading and writing information bank user, ignore the currency that definition separates identifier value and the session parameter used.
On the contrary, using values below.
Use attribute --- false (without using separator).
Separate identifier value --- it is not used.
In second embodiment of the present invention, " data segmentation " property is set as " splitting ".
1. at least two separators before being initiated, are created in designer.
- at least one in multiple separators is set as standard (master) separator, and standard (master) separator is silent
Recognize for shared information bank to be divided into single isolated data storehouse automatically, each isolated data storehouse is managed by the keeper of its own
Reason.
For example, shared information bank potentially includes multiple information banks, each information bank includes all documents of particular organization.Such as
Fruit uses tissue separator as standard delimiter in designer, then shares information bank and be divided into multiple information banks, information
Each information bank in storehouse is isolation and operated in its own data area, and can not access from other isolated datas
The document in storehouse.
- another separator represents the shared attribute configuration object (subordinate separator) newly created, for example, it can pass through choosing
Selecting shared, --- shared attribute --- adds new object to create in allocation window.
2. then, as it appears from the above, setting shared attribute property, such as its title, using and content.
3. then using the drop-down menu in allocation window, to be selected relative to the object listed in content property altogether
Enjoy attribute partitioning parameters (data Partition property).
In this embodiment, data Partition property is set as segmentation.
Shared attribute as separator has extra property, and the behavior and modification of property influence system are included in
The behavior of configuration object in separator content.
4. and then using the drop-down menu in allocation window, so as to select how pair included relative to separator content
As using separator (partition data character of use).
If partition data character of use is set as " independence ", if the session of current information storehouse is without using separator, just
Do not allow to call cutting object.In this case, dump and number in object model, query language, XML and XDTO forms
According to accessing in limitation, separator is also unavailable.When writing partition data, system is filled out automatically with the value set in current sessions
Fill shared attribute value.
When the data from individual data region are used only in application solution, this pattern can be used.
If partition data character of use is set as " independent and shared ", it can use or ignore separator.This
Under pattern, the data area defined by the value of used separator is available.In this case, separator is in object mould
It is also available during dump and data access are limited in type, query language, XML and XDTO forms.
If session is become without using some separators including some object in separator using the work of the object
Obtain poorly efficient.
When application solution mainly uses the data from individual data region (such as when inputting document), use
This pattern, and under some patterns, it may use the data from multiple or all regions, for example, the report for consolidation
Accuse.
5. then using the drop-down menu in allocation window, to select to store the separation identifier value set in current sessions
Session parameter (data partition value property).Session parameter type should match Delimiter Type completely.
6. then using the drop-down menu in allocation window, how to select relative to the configuration object in current sessions
Use shared separator (data segmentation character of use).
The use of shared attribute separator management is to be based on boolean or constant type：If the session parameter specified is set as
"true", then use (subordinate) separator in the session.
7. and then using the drop-down menu in allocation window with alternative condition partitioning parameters.
When application solution will be used under segmentation and non-Fractionation regimen, use condition segmentation.
For example, application solution can be used with off line (in this case, without using separator, although they are included
In a solution), or application solution can be used for orthogonal (and in information bank have independent data group)
Multiple subscribers.
This behavior can be realized with use condition segmentation：If solution is off line, disabling segmentation；Dividing
Cut under pattern, enable segmentation.
Condition segmentation operation is as follows：
- can for separator (or separator content include object) setting storage separator state object.
- change the value of the object, can be for all objects (being imposed a condition segmentation if separator) or selected objects are (such as
The object that fruit includes for separator content imposes a condition segmentation) enable or disable segmentation using the separator.
If-separator is conditionally disabled, the default value of the Delimiter Type is used.
As next step, the metadata object of entitled " session parameter " is specified.The metadata object of entitled " session parameter "
Storage needs the ID for accessing the entity (tenant) of various information objects and/or group of entities (tenant's group).
Therefore, upon power-up of the system, initializing set session parameter value.These values are based on startup order line or are information bank
The option for the value that user specifies uses instruction and the currency of separator of separator to store.
Then the data that network analysis is inputted, specifically：
The specific tenant of-identification and/or tenant's group, or setting current sessions parameter (such as based on machine ID) in addition,
So as to define currency for each separator metadata object；
- identification will be used for the current separation identifier value specified for splitting shared information bank (if for example, separator is set as group
Knit, then shared data bank is divided into by the database of tissue isolation by system)；
- identify whether to set shared attribute；
- identification shared attribute use pattern (shared attribute is used as separator in this embodiment)；
- identification needs the configuration object split by shared attribute；
The Fractionation regimen of-identification shared attribute.
When setting all parameters, shared information bank is divided into multiple isolated data storehouses, in each isolated data
In storehouse, configuration object is shared attribute segmentation (filtering) and based on specified parameter combination in new database.
Example
The condition that example 1. is carried out using the constant set in shared attribute property is split.
The Boolean type constant ("true" or "false") do not split by attribute can be used to disable separator completely.
Configuration includes goods catalogue, and numeric type company shared attribute is included in the metadata.By Split By
The condition of Company constants management is split for company's shared attribute.
If Split By Company=are false, then it represents that without using separator (segmentation is disabled), vice versa.
If segmentation is disabled, the availability of goods catalogue will depend on partition data character of use.
If the latter is set as " independence ", any tenant (company) will all be not authorized to access the bar in goods catalogue
Mesh.
If the property of shared attribute is set as " independent and shared ", all tenants be able to will be accessed in goods catalogue
All entries.
Example 2. is split for the condition that object (in content property) is set
Can be imposed a condition segmentation for each configuration object that include of content of separator.In this case, only
Object for having built up condition segmentation, segmentation is only disabling.
The embodiment split using the condition data of constant.
Assuming that developer has created application solution using client and inventory accountant as main target.Wherein, using solution
Certainly scheme includes two data storage entities：Goods catalogue and contractor's catalogue.
The solution is got ready for local " desktop " pattern；But, it is now desired to adaptation to cloud network clothes
Business pattern.It is expected that at least two subscribers are by the authorized online access solution, and each subscriber in the subscriber will generation
At least two in its accessory structure of table retain accounting record.
Assuming that there is two subscribers, each subscriber represents multiple subsidiaries and retains accounting record.Any row of subscriber
Table subsidiary corresponding with them is expressed as follows.
Subscriber A
- company 1,
- company 2.
Subscriber B
- company 3,
- company 4,
- company 5.
The organized data of institute are stored in two catalogues：In single information bank in contractor and commodity.However, most
Under common scenario, the user of some tissue must only access the record of this particular organization.
It is further assumed that subscriber A wants tissue 1 and tissue 2, because they are attached to the identical owner and by its management,
To access whole goods catalogue.Therefore, tissue 3,4 and 5 must be completely isolated in their own data area, and organizes 1
With 2 and to register later and by subscriber A groups control any other tissue must share the access to goods catalogue, and energy
Enough check all records related to subscriber A commodity.Meanwhile, the data area of contractor's catalogue is still by organizing strictly to divide
Open, regardless of whether which subscriber they belong to.
Separator includes multiple catalogues；Two therein：Contractor and commodity are divided.In latter catalogue, according to
The currency of segmentation commodity constant ("true" or "false") further imposes a condition segmentation, in this case, segmentation commodity constant
Split by subscriber, i.e., its value is different for each subscriber.By for user A by the constant be set as "true" and for
Subscriber B is set as "false", to realize intended effect.
The combination of cited advantage is enough to realize claimed technological achievement in independent claims of the present invention.
Author thinks, it is desirable to which the solution of protection meets all standards of patent of invention.
Claims (7)
1. a kind of method for the automatic management split to the information object being stored in single database, including：
- preliminary create will be used as at least one " shared attribute " metadata object of separator, and the separator storage is to extremely
The reference of a few segmentation information metadata object and the source of the value of the separator；
- defined how for " shared attribute " at least one segmentation metadata object using " shared attribute "
Parameter；
The metadata object of-specified entitled " session parameter ", the metadata object storage of entitled " session parameter " needs to visit
The tenant of various segmentation information objects and/or the ID of tenant's group are asked, and also stores current separation identifier value；
The specific tenant of-identification and/or tenant's group, and define when database session starts each separator metadata object
Currency；
- to the number of the isolation of each tenant and/or tenant's component with the metadata object comprising " shared attribute " with addition
According to region；
- when writing data into the segmentation information object that with the addition of " shared attribute " metadata object, will " shared category
Property " value write in corresponding row；
- generation is inquired about to obtain data from the data area for distributing to specific tenant and/or tenant's group.
2. according to the method described in claim 1, wherein, if being included in " using automatically " in described " shared attribute " parameter
Property is set as " use ", then " shared attribute " created is automatically added to all existing configuration object and all new
The configuration object of establishment.
3. according to the method described in claim 1, wherein, if being included in " using automatically " in described " shared attribute " parameter
Property is set as " without using ", then attribute is not automatically added to configure object, and uses " content " property of the separator
To select the object for needing to add the separator.
4. a kind of method for the automatic management split to the information object being stored in single database, including：
- preliminary create will be used as at least two " shared attribute " metadata objects of separator, and each object storage is at least one
The reference of individual segmentation information metadata object and the source of the value of the separator；
- including the reference to splitting the divisible constant for indicating "true" or "false" comprising condition, the divisible constant is to draw
With the part of another separator in the separator of segmentation information object in itself；
- specify the metadata object of entitled " session parameter ", the metadata object storage of entitled " session parameter " need by
The ID of the tenant for accessing various segmentation information objects and/or tenant's group is authorized, and also stores current separation identifier value；
Once-database session starts, specific tenant and/or tenant's group are recognized, so as to define the value of each separator；
- match somebody with somebody isolated data storehouse to each tenant and/or tenant's component, the database is comprising metadata object and for passing through
Filtered by " shared attribute " value and condition segmentation mark, match somebody with somebody data area to each tenant and/or tenant's component；
- when writing data into the segmentation information object quoted by the separator, by the separation identifier value write-in pair
In the separator row answered；
- generation is inquired about to obtain data from the data area for distributing to specific tenant and/or tenant's group.
5. method according to claim 4, wherein, in addition to the segmentation information object, the database is also included
At least one shared object, splits value of statistical indicant, the shared object can be by owning regardless of the session parameter and condition
Tenant accesses at least to be used for read operation.
6. method according to claim 4, wherein, " shared attribute " object includes its content and value, and partition data
Whether the instruction that can be used in a shared mode, the shared model can have two value "true" or "false" at least one
It is individual, and when the database session starts, recognize tenant and/or tenant's group and set current sessions parameter.
7. method according to claim 6, wherein, if the shared model is set as "true" and these tenants call
Information object in the database, then ignore the current sessions parameter and authorize in the access segmentation information object
Depending on a random set entry of programme controlled set isolation identifier value, to be at least used for read operation.
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| RU2014143713 | 2014-10-30 | ||
| RU2014143713A RU2014143713A (en) | 2014-10-30 | 2014-10-30 | METHOD FOR AUTOMATED MANAGEMENT OF DIVISION OF INFORMATION OBJECTS STORED IN ONE DATABASE (OPTIONS) |
| PCT/RU2015/000698 WO2016068750A1 (en) | 2014-10-30 | 2015-10-22 | Method of management of splitting the information object stored in a single database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107148625A true CN107148625A (en) | 2017-09-08 |
| CN107148625B CN107148625B (en) | 2020-11-13 |
Family
ID=55857912
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201580058828.5A Active CN107148625B (en) | 2014-10-30 | 2015-10-22 | Method for the management of the segmentation of information objects stored in a single database |
Country Status (9)
| Country | Link |
|---|---|
| EP (1) | EP3213237A4 (en) |
| JP (1) | JP2017534987A (en) |
| KR (1) | KR20170075772A (en) |
| CN (1) | CN107148625B (en) |
| BR (1) | BR112017009153A8 (en) |
| IL (1) | IL251658B (en) |
| MX (1) | MX2017005013A (en) |
| RU (1) | RU2014143713A (en) |
| WO (1) | WO2016068750A1 (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111602034A (en) * | 2018-02-13 | 2020-08-28 | 欧姆龙株式会社 | Output management device, output management method, and program |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021230771A2 (en) * | 2020-05-12 | 2021-11-18 | Ubic Technologies Llc | Method of piece data synchronization describing a single entity and stored in different databases |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050289150A1 (en) * | 2004-06-29 | 2005-12-29 | International Business Machines Corporation | Access controller using tree-structured data |
| US20060248199A1 (en) * | 2005-04-29 | 2006-11-02 | Georgi Stanev | Shared closure persistence of session state information |
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| US20070299867A1 (en) * | 2006-06-23 | 2007-12-27 | Timothy John Baldwin | Method and System for Defining a Heirarchical Structure |
| US20100132012A1 (en) * | 2008-11-26 | 2010-05-27 | Red Hat, Inc. | Merging mandatory access control (mac) policies in a system with multiple execution containers |
| CN101777047A (en) * | 2009-01-08 | 2010-07-14 | 国际商业机器公司 | System, equipment and method for accessing database under multiple-tenant environment |
| JP2011113103A (en) * | 2009-11-24 | 2011-06-09 | Hitachi Ltd | Multi-tenant type computer system |
| US20130086322A1 (en) * | 2011-09-30 | 2013-04-04 | Oracle International Corporation | Systems and methods for multitenancy data |
| US8819068B1 (en) * | 2011-09-07 | 2014-08-26 | Amazon Technologies, Inc. | Automating creation or modification of database objects |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7716211B2 (en) * | 2004-02-10 | 2010-05-11 | Microsoft Corporation | System and method for facilitating full text searching utilizing inverted keyword indices |
-
2014
- 2014-10-30 RU RU2014143713A patent/RU2014143713A/en unknown
-
2015
- 2015-10-22 JP JP2017523361A patent/JP2017534987A/en active Pending
- 2015-10-22 KR KR1020177014247A patent/KR20170075772A/en not_active Application Discontinuation
- 2015-10-22 BR BR112017009153A patent/BR112017009153A8/en not_active Application Discontinuation
- 2015-10-22 CN CN201580058828.5A patent/CN107148625B/en active Active
- 2015-10-22 WO PCT/RU2015/000698 patent/WO2016068750A1/en active Application Filing
- 2015-10-22 MX MX2017005013A patent/MX2017005013A/en unknown
- 2015-10-22 EP EP15855258.8A patent/EP3213237A4/en not_active Withdrawn
-
2017
- 2017-04-09 IL IL251658A patent/IL251658B/en active IP Right Grant
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050289150A1 (en) * | 2004-06-29 | 2005-12-29 | International Business Machines Corporation | Access controller using tree-structured data |
| US20060248199A1 (en) * | 2005-04-29 | 2006-11-02 | Georgi Stanev | Shared closure persistence of session state information |
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| US20070299867A1 (en) * | 2006-06-23 | 2007-12-27 | Timothy John Baldwin | Method and System for Defining a Heirarchical Structure |
| US20100132012A1 (en) * | 2008-11-26 | 2010-05-27 | Red Hat, Inc. | Merging mandatory access control (mac) policies in a system with multiple execution containers |
| CN101777047A (en) * | 2009-01-08 | 2010-07-14 | 国际商业机器公司 | System, equipment and method for accessing database under multiple-tenant environment |
| JP2011113103A (en) * | 2009-11-24 | 2011-06-09 | Hitachi Ltd | Multi-tenant type computer system |
| US8819068B1 (en) * | 2011-09-07 | 2014-08-26 | Amazon Technologies, Inc. | Automating creation or modification of database objects |
| US20130086322A1 (en) * | 2011-09-30 | 2013-04-04 | Oracle International Corporation | Systems and methods for multitenancy data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111602034A (en) * | 2018-02-13 | 2020-08-28 | 欧姆龙株式会社 | Output management device, output management method, and program |
Also Published As
| Publication number | Publication date |
|---|---|
| MX2017005013A (en) | 2017-07-19 |
| JP2017534987A (en) | 2017-11-24 |
| EP3213237A1 (en) | 2017-09-06 |
| EP3213237A4 (en) | 2018-05-30 |
| WO2016068750A1 (en) | 2016-05-06 |
| CN107148625B (en) | 2020-11-13 |
| IL251658A0 (en) | 2017-06-29 |
| RU2014143713A (en) | 2016-05-27 |
| BR112017009153A2 (en) | 2018-01-30 |
| IL251658B (en) | 2021-03-25 |
| BR112017009153A8 (en) | 2022-12-13 |
| KR20170075772A (en) | 2017-07-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9420017B2 (en) | Information organization, management, and processing system and methods | |
| US20170200122A1 (en) | Information organization, management, and processing system and methods | |
| US8813250B2 (en) | Access control program, system, and method | |
| CN105487864A (en) | Method and device for automatically generating code | |
| DE112013002542T5 (en) | Cloud-based application resource files | |
| CN106878084B (en) | Authority control method and device | |
| US8875163B2 (en) | Privacy application and method | |
| CN106911770A (en) | A kind of data sharing method and system based on many cloud storages | |
| CN106649857A (en) | Reading and writing separation-based database operation method and apparatus | |
| CN107147728A (en) | A kind of management method of object storage system multi-tenant | |
| CN109831540A (en) | Distributed storage method, device, electronic equipment and storage medium | |
| CN105262620A (en) | Network management system supporting customizable groups | |
| CN101976314A (en) | Access control method and system | |
| CN104008441A (en) | Task management system and method for automatically submitting files into version library | |
| CN107742066A (en) | Account authority configuring method, device, terminal device and computer-readable storage medium | |
| CN107148625A (en) | The method for the management split to the information object being stored in single database | |
| DE112018008066B4 (en) | Virtualized network functions | |
| CN104272273A (en) | Dynamic memory allocation | |
| JP2023543998A (en) | System and method for providing a user interface for KPI customization in an analytical application environment | |
| CN114138181A (en) | Method, device, equipment and readable medium for placing, grouping and selecting owners in binding pool | |
| WO2016032496A1 (en) | Workflow customization | |
| US20220292205A1 (en) | Enhancing security in a content management system | |
| JP2000155715A (en) | System and method for directory access control by computer | |
| US10673624B2 (en) | Communication control device, communication control method, and computer program product | |
| US20140067840A1 (en) | System and method for retrieving information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |