CN101493827B - Storage process adaptive system and method - Google Patents
Storage process adaptive system and method Download PDFInfo
- Publication number
- CN101493827B CN101493827B CN 200810300176 CN200810300176A CN101493827B CN 101493827 B CN101493827 B CN 101493827B CN 200810300176 CN200810300176 CN 200810300176 CN 200810300176 A CN200810300176 A CN 200810300176A CN 101493827 B CN101493827 B CN 101493827B
- Authority
- CN
- China
- Prior art keywords
- storing process
- information
- storage
- storing
- link table
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 193
- 230000008569 process Effects 0.000 title claims abstract description 180
- 238000003860 storage Methods 0.000 title claims abstract description 50
- 230000003044 adaptive effect Effects 0.000 title claims abstract description 20
- 230000008859 change Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 2
- 230000018109 developmental process Effects 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000012508 change request Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to an adaptive method of a storage process, which comprises the following steps: a rule table of the storage process is set up in a database server and stores visit rules of the storage process defined by a user; the information of the storage process required by the user is selected in a data dictionary of the database server; the selected information of the storage process required by the user is stored in a data chain table in the database server; a corresponding visit rule of a storage process of the storage process which needs implementing currently is selected in the rule table of the storage process; according to the selected visit rule of the storage process, the information which needs implementing currently is obtained from the data chain table; and the storage process is implemented, and the implemented result of the storage process is returned. The invention also provides an adaptive system of a storage process.
Description
Technical field
The present invention relates to a kind of storage process adaptive system and method.
Background technology
Management information system (MIS, Management Information System) is the system of collection, transmission, storage, processing, maintenance and the use that can carry out information of being made up of people, computing machine and other peripherals etc.At present, the computer network of enterprise has become the important means that enterprise undergoes technological transformation and improves enterprise management.Along with integrating with of China and world's information highway, enterprise will bring huge economic benefit and social benefit for enterprise by the computer network acquired information, and the office of enterprise and management all will develop towards efficient, quick, with no paper direction.Mis system is generally used for the system decision-making, for example, can utilize mis system to find out the problem that presses for solution at present, and information is in time fed back to the major executives, makes them understand progress or the deficiency of work at present development.
Yet all mis systems all be unable to do without large-scale database support, and nearly all application also all is that the data base-oriented exchange is carried out.Usually in the enforcement and the course of receiving of system, the client can propose some change requests, most modification database and the data structures of needing of the request of change, need corresponding program code owing to call storing process, if change storing process, then need to change corresponding invoke code, this brings very big pressure and burden can for undoubtedly the program development personnel, has reduced work efficiency.
Summary of the invention
In view of above content, be necessary to provide a kind of storage process adaptive system, comprise database server, this database server comprises: storing process and data dictionary, store the information of all storing processs in this data dictionary, this database server also comprises a storing process rule list, store the defined storing process access rule of user in this storing process rule list, described database server also comprises: select module, be used for selecting the information of the needed storing process of described data dictionary user; Preserve module, be used for the information of the needed storing process of selected user is stored in data link table; Described selection module also is used for the corresponding storing process access rule of storing process in a current required execution of described storing process rule list selection; Acquisition module is for the information of obtaining the storing process of current required execution according to selected storing process access rule in described data link table; And execution module, be used for carrying out described storing process and return the result who carries out storing process.
In addition, also be necessary to provide a kind of storage process adaptive method, this method comprises the steps: to set up the storing process rule list in database server, stores the defined storing process access rule of user in this storing process rule list; Select the information of the needed storing process of user in the data dictionary in described database server; The information of the needed storing process of selected user is stored in the data link table in the described database server; In described storing process rule list, select the corresponding storing process access rule of storing process of a current required execution; In described data link table, obtain the information of the storing process of current required execution according to selected storing process access rule; And carry out described storing process and return the result who carries out storing process.
Compared to prior art, described storage process adaptive system and method, can the database of revising be adapted to automatically, when changing storing process, need not to change the code that calls storing process, reduce the modification of code to greatest extent, reduced the risk of system development project, improved work efficiency.
Description of drawings
Fig. 1 is the hardware structure figure of storage process adaptive system preferred embodiment of the present invention.
Fig. 2 is the functional block diagram of database server 3 among Fig. 1.
Fig. 3 is the operation process chart of storage process adaptive method of the present invention preferred embodiment.
Fig. 4 is storing process rule list synoptic diagram.
Embodiment
As shown in Figure 1, be the hardware structure figure of storage process adaptive system preferred embodiment of the present invention.The database server 3 that this system comprises client computer 1, communicates by letter by network 2 with this client computer 1.Wherein, network 2 can comprise any network well known in the art, comprising: transmission control protocol/procotol (TCP/IP) network (for example: internal network, the Internet), LAN (Local Area Network), wide area network, fiber channel, token ring etc.Described database server 3 comprises: database 300, storing process 400 and data link table 500.
Described database 300 comprises data dictionary 301.Data dictionary 301 is that main existence form exists with tables of data and view, is the set about the information of data.This data dictionary 301 is deposited all relevant informations of database, for example: how many spaces database 300 distributes, current how many spaces of having used, user's name, the relevant informations of the authority that user and role are awarded and storing process 400 etc., the relevant information of described storing process 400 comprises: the title of the input parameter of storing process 400, output parameter, storing process 400 etc.
Described storing process 400 is one section program of being write by the programming personnel, and this program is used for the data interaction of database 300 and client computer 1, and each data manipulation of database 300 is had corresponding storing process 400.For example: if client computer 1 needs the storage data to database 300, then carry out the storing process 400 of storage data; If client computer 1 need call the data in the database 300, then carry out the storing process 400 that calls data.Described storing process 400 also comprises a parameter list (not shown), stores input parameter and the output parameter of storing process 400 in this parameter list.Described data link table 500 is used for all information of the storing process 400 of the required usefulness of user that storage obtains from data dictionary 301, and all information of described storing process 400 are that name storage with storing process 400 is in this data link table 500.
As shown in Figure 2, be the functional block diagram of database server 3 among Fig. 1.Described database server 3 comprises: acquisition module 10, selection module 12, preservation module 14 and execution module 16.Storage process adaptive system of the present invention is before starting, need in database server 3, to set up the storing process rule list by the programming personnel, as shown in Figure 4, the content of this storing process rule list comprises: the return label value of the title of the job category of storing process 400, storing process 400, the index value sequence number of storing process 400 and storing process 400.The job category of described storing process 400 is recited as ID number of job category, defined voluntarily by the programming personnel for the ID of this job category number, for example in the present embodiment described ID number is defined as: ID number is that 1 expression job category is material loading, and ID number is that 2 expression job categories are the storage employee number.The title of described storing process 400 is used for according to the information of this name acquiring data link table 500 to storing process 400 that should title.The index value sequence number of described storing process 400 is represented the sequence number of output valve in the parameter list of storing process 400 of storing process 400.The return label value of described storing process 400 has two kinds of situations: " 1 " or " 0 ", if the return label value is " 1 ", represent that described storing process 400 has output valve, if do not need output, then the return label value is " 0 ".For example: as shown in Figure 4, ID number of the job category of storage employee number is 2, and the index value sequence number is 3, and the return label value is 1, and the storing process 400 of expression storage employee number correspondence has output valve, and this output valve is the 3rd parameter in the described parameter list.
Select module 12 to be used for selecting the information of needed all storing processs 400 of described data dictionary 301 users.
Preserving module 14 is used for the information of needed all storing processs 400 of selected user is stored in data link table 500 with the name nominating of storing process 400.
Described selection module 12 also is used for selecting current storing process 400 corresponding storing process access rules that need execution at described storing process rule list, for example: if the current storage employee number that needs, as shown in Figure 4, described selection module 12 is used for selecting the corresponding storing process access rule of storage employee number at the storing process rule list: the ID of job category number is 2, the index value sequence number is 3, and the return label value is 1.
Described acquisition module 10 also is used for searching these storing process 400 titles according to the title of this storing process 400 in the rule of described rule list in described data link table 500, thereby obtain the information of storing process 400 in data link table 500 of current required execution, obtain the information of storing process 400 in data link table 500 of storage employee number correspondence in the present embodiment.
As shown in Figure 3, be the operation process chart of storage process adaptive method of the present invention preferred embodiment.
Step S30 sets up the storing process rule list, and as shown in Figure 4, the content of this storing process rule list comprises: the return label value of the title of the job category of storing process 400, storing process 400, the index value sequence number of storing process 400 and storing process 400.The job category of described storing process 400 is recited as ID number of job category, defined voluntarily by the programming personnel for the ID of this job category number, for example in the present embodiment described ID number is defined as: ID number is that 1 expression job category is material loading, and ID number is that 2 expression job categories are the storage employee number.The title of described storing process 400 is used for the information of storing process 400 that should title according to this title or 500 pairs of the chained lists of fetching data.The index value sequence number of described storing process 400 is represented the sequence number of output valve in the parameter list of storing process 400 of storing process 400.The return label value of described storing process 400 has two kinds of situations: " 1 " or " 0 ", if the return label value is " 1 ", represent that described storing process 400 has output valve, if do not need output, then the return label value is " 0 ".For example: as shown in Figure 4, ID number of the job category of storage employee number is 2, and the index value sequence number is 3, and the return label value is 1, and the storing process 400 of expression storage employee number correspondence has output valve, and this output valve is the 3rd parameter in the described parameter list.
Step S32, acquisition module 10 obtain the data dictionary 301 in the database 300.
Step S34 selects module 12 to select the information of needed all storing processs 400 of user in described data dictionary 301.
Step S36 preserves module 14 information of needed all storing processs 400 of the selected user name nominating with storing process 400 is stored in the data link table 500.
Step S38, described selection module 12 is selected current storing process 400 corresponding storing process access rules that need execution in described storing process rule list, for example: if the current storage employee number that needs, as shown in Figure 4, described selection module 12 is used for selecting the corresponding storing process access rule of storage employee number at the storing process rule list: the ID of job category number is 2, the index value sequence number is 3, and the return label value is 1.
Step S40, described acquisition module 10 is searched these storing process 400 titles according to the title of this storing process 400 of the storing process access rule correspondence of described selection in described data link table 500, thereby obtain the information of storing process 400 in data link table 500 of current required execution, obtain the information of storing process 400 in data link table 500 of storage employee number correspondence in the present embodiment.
Step S42, execution module 16 is carried out the current storing process 400 that needs execution, carries out the storing process 400 of described storage employee number correspondence in the present embodiment.
Step S44, execution module 16 return the output result who carries out described storing process 400.If described storing process 400 complete back no-output values are then returned the output result and are " ok ", if described storing process 400 has output valve after complete, then returning the output result is this output valve.
It should be noted last that, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although with reference to preferred embodiment the present invention is had been described in detail, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (6)
1. a storage process adaptive system is characterized in that, described storage process adaptive system comprises:
Acquisition module is for the data dictionary that obtains database;
Select module, be used for selecting the information of the needed storing process of data dictionary user;
Preserve module, be used for the information of the needed storing process of selected user is stored in data link table with the name nominating of storing process;
Described selection module also is used for the corresponding storing process access rule of storing process in a current required execution of storing process rule list selection;
Described acquisition module also is used for searching this storing process title according to the storing process title of storing process access rule in data link table, obtains the information of the storing process of current required execution in the data link table; And
Execution module is used for carrying out described storing process and returns the result who carries out storing process.
2. storage process adaptive system as claimed in claim 1 is characterized in that, comprises in the described storing process rule list: the job category of storing process, the title of storing process, storing process index value sequence number and return label value.
3. storage process adaptive system as claimed in claim 1 is characterized in that, all information of described storing process are that name storage with storing process is in this data link table.
4. a storage process adaptive method is characterized in that, this method comprises the steps:
Obtain the data dictionary in the database;
In database server, set up the storing process rule list, store the defined storing process access rule of user in this storing process rule list;
Select the information of the needed storing process of user in the data dictionary in described database server;
The information of the needed storing process of selected user is stored in the data link table in the described database server with the name nominating of storing process;
In described storing process rule list, select the corresponding storing process access rule of storing process of a current required execution;
In data link table, search this storing process title according to the storing process title in the storing process access rule, obtain the information of the storing process of current required execution in the data link table; And
Carry out described storing process and return the result who carries out storing process.
5. storage process adaptive method as claimed in claim 4 is characterized in that, comprises in the described storing process rule list: the job category of storing process, the title of storing process, storing process index value sequence number and return label value.
6. storage process adaptive method as claimed in claim 4 is characterized in that, all information of described storing process are that name storage with storing process is in this data link table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200810300176 CN101493827B (en) | 2008-01-21 | 2008-01-21 | Storage process adaptive system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200810300176 CN101493827B (en) | 2008-01-21 | 2008-01-21 | Storage process adaptive system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101493827A CN101493827A (en) | 2009-07-29 |
| CN101493827B true CN101493827B (en) | 2013-08-21 |
Family
ID=40924431
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200810300176 Expired - Fee Related CN101493827B (en) | 2008-01-21 | 2008-01-21 | Storage process adaptive system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101493827B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102890675B (en) * | 2011-07-18 | 2015-05-13 | 阿里巴巴集团控股有限公司 | Method and device for storing and finding data |
| CN103164445A (en) * | 2011-12-14 | 2013-06-19 | 深圳光启高等理工研究院 | Manual electromagnetic material design data base processing method |
| WO2017156673A1 (en) * | 2016-03-14 | 2017-09-21 | 华为技术有限公司 | Processing method and device for stored procedure |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| US20070106629A1 (en) * | 2005-10-17 | 2007-05-10 | Steve Endacott | System and method for accessing data |
-
2008
- 2008-01-21 CN CN 200810300176 patent/CN101493827B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| US20070106629A1 (en) * | 2005-10-17 | 2007-05-10 | Steve Endacott | System and method for accessing data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101493827A (en) | 2009-07-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7409401B2 (en) | Method and system for supporting multivalue attributes in a database system | |
| CN103810224B (en) | information persistence and query method and device | |
| CN105338113B (en) | A kind of multi-platform data interconnection system for Urban Data resource-sharing | |
| CN104408159B (en) | A kind of data correlation, loading, querying method and device | |
| RU2001112668A (en) | Method and system for providing access to information on a network using functions of a message alias having shadow callback functions | |
| CN1169195A (en) | Method and/or system for accessing information | |
| CN103927331B (en) | Data querying method, data querying device and data querying system | |
| DE10122197A1 (en) | Method and system for accessing information on a network using message linking functions with shadow callback functions | |
| CN109815254B (en) | Cross-region task scheduling method and system based on big data | |
| CN101208692A (en) | Automatically moving multidimensional data between live datacubes of enterprise software systems | |
| CN101146152A (en) | Information collection and search system for telecommunication information station | |
| CN108509437A (en) | A kind of ElasticSearch inquiries accelerated method | |
| CN107786355A (en) | A kind of method and apparatus of smart city information sharing | |
| CN108763573A (en) | A kind of OLAP engines method for routing and system based on machine learning | |
| US8468195B1 (en) | System and method for controlling an exchange of information in a network environment | |
| US20200334314A1 (en) | Emergency disposal support system | |
| CN113282599A (en) | Data synchronization method and system | |
| CN106815258A (en) | A kind of date storage method and coordinator node | |
| CN101493827B (en) | Storage process adaptive system and method | |
| US20190179928A1 (en) | On-demand, dynamic and optimized indexing in natural language processing | |
| CN104182546B (en) | The data query method and device of database | |
| CN113806446A (en) | Rapid retrieval method for mass data of big data | |
| CN110532282A (en) | Data query method and device | |
| CN116700929A (en) | Task batch processing method and system based on artificial intelligence | |
| KR20180077830A (en) | Processing method for a relational query in distributed stream processing engine based on shared-nothing architecture, recording medium and device for performing the method |
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 | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20160318 Address after: 100005, room 701, block E1, Oriental Plaza, No. 1 East Chang'an Avenue, Beijing, Dongcheng District Patentee after: China Morita Enterprise Group Ltd. Address before: 518109 Guangdong city of Shenzhen province Baoan District Longhua Town Industrial Zone tabulaeformis tenth East Ring Road No. 2 two Patentee before: HONG FU JIN PRECISION INDUSTRY (SHENZHEN) Co.,Ltd. Patentee before: HON HAI PRECISION INDUSTRY Co.,Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20130821 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |