CN101256578A - Method for implementing multi-user in internal memory database - Google Patents
Method for implementing multi-user in internal memory database Download PDFInfo
- Publication number
- CN101256578A CN101256578A CNA2008100664717A CN200810066471A CN101256578A CN 101256578 A CN101256578 A CN 101256578A CN A2008100664717 A CNA2008100664717 A CN A2008100664717A CN 200810066471 A CN200810066471 A CN 200810066471A CN 101256578 A CN101256578 A CN 101256578A
- Authority
- CN
- China
- Prior art keywords
- user
- database
- memory database
- different
- described step
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a multi-user realization method of EMS memory database, which comprises the following steps: introducing user registry in EMS memory to deposit users' relative information; confirming users according to affair need and registering used lists of users; only registered lists by users and relative logic objects being used by users. The multi-user realization method of EMS memory database of the invention can fundamentally reduce couplings of different affair user logic object data in EMS memory database, reduce interfere states among different users and greatly reduce software system's complex because the method introduces a management mechanism for multi-user to manage each logic object sub-users in EMS memory.
Description
Technical field
The present invention relates to a kind of memory database application process, more particularly, the present invention relates to be a kind of when using memory database the object logic of database and data by the implementation method of multi-user management.
Background technology
In the prior art, along with the widespread use of embedded software, the data that need in the software systems to preserve occur in a large number, and the demand of memory database rolls up.In the embedded memory database field, no matter be the embedded database of commercialization or the memory database that each company researches and develops voluntarily, all do not propose multi-user's notion at present, the database application pattern that they supported is also more single; If upper layer application need be according to the different services of using database to provide of business characteristic, so most of situation is that all tables store together, two kinds of diverse business datums that What is more can be coupled in the table, different user judges according to upper layer application that to the action need of database database itself can't be distinguished management to different users.
To an example of multi-user's memory database demand, be the proposition that the multi-system of mobile communication industry is used same device concept with.In the mobile communication industry; in order to make full use of the existing network of operator; industry has extensively proposed the situation of hardware devices such as base station, base station controller realization bimodulus or multimode; be that same base station can be moved the different systems standard simultaneously; similar base station can provide GSM/WCDMA bimodule service simultaneously, various modes existence simultaneously that What is more.
Concerning database, the mixed storage of various modes obviously is to increase coupling so, and therefore, prior art has yet to be improved and developed.
Summary of the invention
The object of the present invention is to provide a kind of multi-user's implementation method of memory database, when using memory database, pass through management to the multi-user, the management method of introducing the multi-user reduces the degree of coupling of different user data to reduce the complexity of whole software system significantly.
Technical scheme of the present invention comprises:
A kind of multi-user's implementation method of memory database, it may further comprise the steps:
A, in memory database, introduce user's registration table and be used to deposit user related information;
B, determine the user, and the employed table of user is registered according to business demand;
C, user only use oneself the registration table with and the interrelated logic object.
Described method, wherein, described step B also comprises: the table of registering oneself when different users uses identical table respectively.
Described method, wherein, described step B also comprises: different users uses identical list structure and table data.
Described method, wherein, described step B also comprises: different users uses shared list structure, and its table data are separately deposited.
Described method, wherein, described step B also comprises: different users use different list structures and, different table data.
Described method, wherein, described step C also comprises: when memory database starts, the relevant information that the user registered is read in internal memory from file; Described memory database carries out user's verification in the database rank after starting, and does not allow the user that the table that does not have registration is conducted interviews.
Described method, wherein, described step C also comprises: the database manipulation of different user sends to relevant common processes in the mode of message, and waiting lines handles.
Described method, wherein, described database manipulation comprises: deposit, data sync.
Multi-user's implementation method of a kind of memory database provided by the present invention, owing to introduced administrative mechanism to the multi-user, divide the user to manage the various logic object of memory database, can fundamentally reduce the coupling of memory database different business user logic object data, reduce the state that interferes with each other between the different user, reduced the complexity of software systems significantly.
Description of drawings
Fig. 1 is the shared list structure of the inventive method and shows structural drawing under the data scene;
Fig. 2 is that the shared list structure of the inventive method has structural drawing under oneself the table data scene respectively;
Fig. 3 is that the list structure and the table data of the inventive method are separated structural drawing under the scene fully.
Embodiment
Below in conjunction with accompanying drawing, will be described in more detail each preferred embodiment of the present invention.
When memory database uses, at first introduce the relevant information that user's registration table is used for depositing each user.After determining different user according to business demand, the table that the user is used is registered again, the user only with the table that uses own registration with and the object logic of being correlated with; Different users uses identical table then to register respectively and gets final product.
After memory database starts, different user can only be operated relative table data, the different user of the physical attribute table of equipment needs registration just can have generally speaking, this part table user can design the storage relation in internal memory as the case may be, following three kinds of general branch: 1) use identical list structure and table data, as shown in Figure 1; 2) only shared list structure, the table data are separately deposited, as shown in Figure 2; 3) list structure all separates fully with data, as shown in Figure 3.
Generally for the traffic table data, different user needs registration respectively; Store respectively for different user table data so, can so also just do not had the problem that operation interferes with each other by other customer impacts for certain user's operation note.
Have only the table of having registered, system just can distribute to memory headroom, and the table that does not have the user to register does not distribute data space, so just can save memory headroom in a large number.When certain user initiates the memory database associative operation, then can only operate own user table, such as transaction operation and database write daily record deposit etc.The deposit process has only one, by multi-user shared, carries out serial processing, if memory database need carry out Hot Spare, then memory database also can carry out according to user's difference synchronously.That is to say because the present invention has introduced multi-user's notion, relevantly with business in to all operations of memory database can introduce user concept, do not need then can select to use public function by professional separate processes.
The inventive method mainly comprises following treatment step:
A, the user who introduces is registered;
B, according to service-user classification, the table that the configuration registry user has, each user registers the traffic table of own needs respectively, for the public sheet that both sides use, both sides can register respectively;
When C, memory database startup, the relevant information of steps A and step B registration is read in internal memory from file, after database started, service-user was to access of database, carry out user's verification in the database rank, do not allow the user that the table that does not have registration is conducted interviews.
The database manipulation of D, different user sends to relevant common processes as deposit, data sync etc. in the mode of message, and waiting lines handles.
Realize bimodulus (USER1/USER2) sight as exemplary with mobile communication industry communication apparatus below, log-on message is all represented in the mode of structural array in the following examples, and the specific design implementation step of memory database comprises:
Two users that introduce register called after USER1, USER2 in configuration file.
According to the classification of two kinds of service-users, the table that the configuration registry user has, in the following tabulation according to demand the R_RACKT table have only USER1 and USER2 all to have, the R_SHELFT table has only USER1 to have.Concrete mode of operation can compare flexibly, can directly configure or describe in disk file good this registration relation etc. in source code.After database starts, as long as in internal memory, there is the corresponding relation of user and Biao.
User under the table handle table namelist smallest record table dominant record table
const?TSYSTABTuple?gtSysTabTuple[]＝{
{HANDLE_RACKTYPE，″R_RACKT″，0，RACKTYPE_MAX
USER1‖USER2}，
{HANDLE_SHELFTYPE，″R_SHELFT″，0，
SHELFTYPE_MAX，USER1}；
After memory database starts, service-user is to access of database, carry out user's verification in the database rank, do not allow the user not conduct interviews to there being the registration table table, a kind of method of verification is that the interface that is applied in accessing database is gone into the field that a user model is arranged in the ginseng, is used for identifying concrete user.
The table of all registering for USER1/USER2 user, if the table data sharing application could prevent the conflict of visiting by locking exclusive reference or carry out serial access by the same process of database.
The operation of USER1/USER2 user's data storehouse as deposit, data sync etc. send to relevant common processes in the mode of message, and waiting lines handles.
The inventive method is owing to the administrative mechanism of having introduced the multi-user, divide the user to manage the various logic object of memory database, can fundamentally reduce the coupling of memory database different business user logic object data, reduce the state that interferes with each other between the different user, reduced the complexity of software systems significantly.
Should be understood that above-mentioned description at preferred embodiment of the present invention is comparatively detailed, but can not therefore think the restriction to scope of patent protection of the present invention, scope of patent protection of the present invention should be as the criterion with claims.
Claims (8)
1, a kind of multi-user's implementation method of memory database, it may further comprise the steps:
A, in memory database, introduce user's registration table and be used to deposit user related information;
B, determine the user, and the employed table of user is registered according to business demand;
C, user only use oneself the registration table with and the interrelated logic object.
2, method according to claim 1 is characterized in that, described step B also comprises: the table of registering oneself when different users uses identical table respectively.
3, method according to claim 1 is characterized in that, described step B also comprises: different users uses identical list structure and table data.
4, method according to claim 1 is characterized in that, described step B also comprises: different users uses shared list structure, and its table data are separately deposited.
5, method according to claim 1 is characterized in that, described step B also comprises: different users use different list structures and, different table data.
6, according to claim 3,4 or 5 described methods, it is characterized in that described step C also comprises: when memory database starts, the relevant information that the user registered is read in internal memory from file; Described memory database carries out user's verification in the database rank after starting, and does not allow the user that the table that does not have registration is conducted interviews.
7, method according to claim 6 is characterized in that, described step C also comprises: the database manipulation of different user sends to relevant common processes in the mode of message, and waiting lines handles.
8, method according to claim 7 is characterized in that, described database manipulation comprises: deposit, data sync.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008100664717A CN101256578B (en) | 2008-04-08 | 2008-04-08 | Method for implementing multi-user in internal memory database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008100664717A CN101256578B (en) | 2008-04-08 | 2008-04-08 | Method for implementing multi-user in internal memory database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101256578A true CN101256578A (en) | 2008-09-03 |
| CN101256578B CN101256578B (en) | 2010-06-09 |
Family
ID=39891405
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2008100664717A Expired - Fee Related CN101256578B (en) | 2008-04-08 | 2008-04-08 | Method for implementing multi-user in internal memory database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101256578B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752847A (en) * | 2011-04-19 | 2012-10-24 | 腾讯科技（深圳）有限公司 | Method and device for processing networking application |
| CN103067376A (en) * | 2012-12-26 | 2013-04-24 | 北京讯鸟软件有限公司 | Structured query language (SQL) injection attacking protection method based on internal storage |
| US11100101B2 (en) | 2016-02-25 | 2021-08-24 | Huawei Technologies Co., Ltd. | Data operation method and data management server |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7203696B2 (en) * | 2003-08-29 | 2007-04-10 | Microsoft Corporation | Dynamic registry partitioning |
-
2008
- 2008-04-08 CN CN2008100664717A patent/CN101256578B/en not_active Expired - Fee Related
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752847A (en) * | 2011-04-19 | 2012-10-24 | 腾讯科技（深圳）有限公司 | Method and device for processing networking application |
| CN103067376A (en) * | 2012-12-26 | 2013-04-24 | 北京讯鸟软件有限公司 | Structured query language (SQL) injection attacking protection method based on internal storage |
| CN103067376B (en) * | 2012-12-26 | 2017-03-15 | 北京讯鸟软件有限公司 | A kind of SQL injection attacks means of defences based on internal memory |
| US11100101B2 (en) | 2016-02-25 | 2021-08-24 | Huawei Technologies Co., Ltd. | Data operation method and data management server |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101256578B (en) | 2010-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3058554B1 (en) | Communication and processing of credential data | |
| CN105025396B (en) | Realize method, system and the cluster cloud base station of private network and public network interphone communication | |
| US8284421B2 (en) | Printing client management method and wireless LAN printer in wireless network | |
| CN103702319B (en) | SIM (subscriber identity module) card, individualized card writing system and method as well as SIM card obtained according to method | |
| US8423784B2 (en) | Position registering method, program and apparatus for terminal equipment | |
| CN105142132B (en) | A kind of MNP numbers of taking turn network method and system | |
| US20120243444A1 (en) | Communication system to localize devices and methods thereof | |
| CN101256578B (en) | Method for implementing multi-user in internal memory database | |
| CN102891832A (en) | ID (Identity) binding method and system | |
| CN101588366A (en) | System and method for accessing enterprise information system based on SaaS | |
| CN101953188B (en) | Method and apparatus for processing multi-channel request subscription under service management platform | |
| CN102811338A (en) | Control method and control device for multi-level postback video signal in video conference system | |
| CN101820606A (en) | Authentication and authorization charging server and message processing method | |
| CN103716865A (en) | Commubnication appratus | |
| CN104079325B (en) | A kind of method of information sharing and electronic equipment | |
| CN103582068A (en) | Wireless accessing method and system | |
| CN101453730A (en) | Apparatus and method for supporting multiple operation support system | |
| CN115510496A (en) | Database access control method and related device | |
| CN102075534A (en) | Method and system for sharing home gateway data | |
| CN101355762B (en) | Method for managing mobile phone address book | |
| CN104766103B (en) | Smart card issuing method and system | |
| CN203025799U (en) | Group-customer-orientated access global control system | |
| CN102904616A (en) | Data exchange method based on equipment discovery mechanism | |
| JP4009383B2 (en) | Information processing device | |
| CN113438334B (en) | Port PVID configuration method, device and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20180702 Address after: California, USA Patentee after: Global innovation polymerization LLC Address before: 518057 Nanshan District high tech Industrial Park, Shenzhen, Guangdong, Ministry of justice, Zhongxing Road, South China road. Patentee before: ZTE Corp. |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20100609 |