CN103164445A - Manual electromagnetic material design data base processing method - Google Patents
Manual electromagnetic material design data base processing method Download PDFInfo
- Publication number
- CN103164445A CN103164445A CN2011104183741A CN201110418374A CN103164445A CN 103164445 A CN103164445 A CN 103164445A CN 2011104183741 A CN2011104183741 A CN 2011104183741A CN 201110418374 A CN201110418374 A CN 201110418374A CN 103164445 A CN103164445 A CN 103164445A
- Authority
- CN
- China
- Prior art keywords
- storing process
- operation demand
- database operation
- electromagnetic material
- artificial electromagnetic
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a manual electromagnetic material design data base processing method. The method comprises the steps of confirming operation requirements of a manual electromagnetic material design data base; judging whether a previously established storage process base contains storage processes corresponding to the operation requirements of the data base; if on yes judgment, calling and actuating the storage processes, corresponding to the operation requirements in the data base, in the storage process base; and returning to calculation of the storage processes corresponding to the operation requirements of the data base. The method can improve processing speed on the manual electromagnetic material design data base and meets production requirements of manual electromagnetic material industrialization.
Description
Technical field
The present invention relates to database field, particularly relate to a kind of data base processing method for the artificial electromagnetic material design.
Background technology
The artificial electromagnetic material technology is a frontier nature intersection science and technology, and artificial electromagnetic material refers to artificial composite structure or the compound substance that some have the not available extraordinary physical property of natural material.Structurally ordered design by on the key physical yardstick of material can break through the restriction of some apparent natural law, thereby obtains to exceed the meta-materials function of the intrinsic common character of nature.
The database of artificial electromagnetic material design has comprised the information of the physical characteristics of a large amount of artificial electromagnetic material structural parameters and artificial electromagnetic material.The structural parameters of artificial electromagnetic material are material, the size of base material, the material of artificial microstructure, topological structure and geometry, and the physical characteristics of artificial electromagnetic material is electric field response, magnetic responsiveness and/or refractive index.
In existing technology, the operation such as the method for process database is generally that every pair of database once upgrades, insertion, inquiry or deletion will be called the SQL statement collection one time.In the artificial electromagnetic material design phase, because the data volume of artificial electromagnetic material is very large, can cause processing speed excessively slow to database processing in this way, thereby can't satisfy the needs that the artificial electromagnetic material industrialization is produced.
Therefore solve in prior art excessively slow, loaded down with trivial details to the processing speed of the database of depositing artificial electromagnetic material design related data and huge problem consuming time is significant.
Summary of the invention
The technical matters that the present invention mainly solves is to provide a kind of data base processing method for the artificial electromagnetic material design, can accelerate the processing speed to large scale database.
For solving the problems of the technologies described above, the technical scheme that the present invention adopts is: a kind of data base processing method for the artificial electromagnetic material design is provided, comprises: the database operation demand of confirming the artificial electromagnetic material design; Whether comprise the corresponding storing process of database operation demand in the storing process storehouse that judgement is set up in advance; If comprise, call and carry out the corresponding storing process of database operation demand in the storing process storehouse; The result of calculation of the corresponding storing process of return data storehouse computing demand.
Wherein, the database operation demand of artificial electromagnetic material design comprises needs the data message that designs in the database of artificial electromagnetic material design.
Wherein, the step of calling and carry out the corresponding storing process of database operation demand in the storing process storehouse comprises: call and the corresponding storing process of performing database computing demand by the create name that calls for the corresponding storing process of identification database computing demand.
Wherein, whether comprise the corresponding storing process step of database operation demand in judgement is set up in advance storing process storehouse, also comprise step: if do not comprise, the corresponding storing process of creation database computing demand.
Wherein, in the step of the corresponding storing process of creation database computing demand, also comprise step: identify the storing process that creates with create name.
Wherein, after the step of the database that designs with create name mark artificial electromagnetic material, also comprise step: the corresponding storing process of database operation demand is saved in stored procedures database.
Wherein, the corresponding storing process of database operation demand comprises: to renewal, insertion, deletion and the query manipulation of the database operation demand of artificial electromagnetic material design.
Wherein, the corresponding storing process of database operation demand is selected from least a in following five kinds: the storing process that system provides, local storing process, interim storing process, long-range storing process and extended stored procedure.
Wherein, temporary stored procedure comprises: local temporary stored procedure and overall temporary stored procedure.
Wherein, the result of calculation of the corresponding storing process of database operation demand comprises the data message that the database operation demand needing in the database of the artificial electromagnetic material design that obtains after the operation of the corresponding storing process of database operation demand to be carried out the different physical arrangements that design.
The invention has the beneficial effects as follows: the situation that is different from prior art, the present invention is by being applied to depositing the database of artificial electromagnetic material design related data, accelerate the speed to the large scale database processing, thereby satisfied the requirement that the artificial electromagnetic material industrialization is produced.
Description of drawings
Fig. 1 is the process flow diagram of a kind of data base processing method for artificial electromagnetic material design of the present invention.
Embodiment
See also Fig. 1, Fig. 1 is the process flow diagram of a kind of data base processing method for artificial electromagnetic material design of the present invention.As shown in Figure 1, a kind of data base processing method for the artificial electromagnetic material design of the present invention comprises the following steps:
Step 10: the database operation demand of confirming the artificial electromagnetic material design.
The database operation demand of described artificial electromagnetic material design comprises the physical characteristics of structural parameters and the artificial electromagnetic material of artificial electromagnetic material.The structural parameters of artificial electromagnetic material are material, the size of base material, the material of artificial microstructure, topological structure and geometry, and the physical characteristics of artificial electromagnetic material is electric field response, magnetic responsiveness and/or refractive index.These are all to need the data message that designs in the database of artificial electromagnetic material design.
Step 11: whether comprise the corresponding storing process of described database operation demand in the storing process storehouse that judgement is set up in advance.
Storing process (Stored Procedure) be one group in order to complete the SQL statement collection of specific function, be the program that the Transact-SQL language that utilizes SQL Server (Relational DBMS) to provide is write.The essence of database store process is exactly to be deployed in one group of database side definition code and SQL.Creating storing process is the operation of commonly using to database, such as renewal, insertion, deletion and query manipulation etc. finish writing and use the name storage of an appointment in advance with sql like language, when wanting after so database that the identical service of function with defined good storing process is provided, only need call execution, get final product Auto completion for commands.
Stored procedures database does not have difference with common database, and this database is mainly to preserve storing process.
If there is no storing process, must create storing process.Storing process must identify with create name, facilitates the user to understand and uses.Create name can be named according to the function of storing process.For example, if the function of this storing process is to insert information toward database, can be designated insert, if the function of this storing process is delete database information, delete can be designated, if the function of this storing process is the information of Query Database, query can be designated, if function is to upgrade this data message, can be designated update.Concrete naming method can be made according to the demand of reality.
Below introduce in detail the concrete syntax of the language compilation storing process that utilizes SQL.
As follows:
CREATE PROC[EDURE]procedure_name[；number]
[
{@parameter data_type}][VARYING][＝default][OUTPUT]
]
For example: can be written as if the user wants the storing process Select_delete that sets up a record in delete list tmp:
Create Proc select_del As
Delete tmp
Again for example, as shown in table 1, be numbered the content of the table of book:
| Numbering | Title | Price |
| 001 | C language introduction | $30 |
| 002 | The exploitation of PowerBuilder form | $52 |
Table 1
Tables of data book establishment for table 1 adds one to be recorded to table book, and inquires about the storing process of the total charge of all books in this table, can be written as:
Create proc insert_book
@param1 char(10)，@param2 varchar(20)，@param3 money，@param4money output
With encryption---------encrypts
as
Insert into book (numbering, title, price) Values (@param1 ,@param2 ,@param3)
Select@param4=sum (price) from book
go
We can see that the storing process name is called insert_book here, show that this storing process has toward the function of showing to insert in book information, are understood and use by user or developer than being easier to.
The instruction set that sql like language commonly used is write storing process is stored in inside database, compiled when creating and completed, just need not compile again once when calling and just can directly carry out, improved greatly the processing speed to database, and the storing process that is saved in stored procedures database can be reused, and has reduced database development personnel's workload.
Step 12: if comprise, call and carry out the corresponding storing process of described database operation demand in the storing process storehouse.
The object lesson that calls and carry out this storing process is as follows:
declare @total_price money
Exec insert_book ' 003 ', ' Delphi control development guides ', $ 100 ,@total_price
Print ' total charge is '+convert (varchar ,@total_price)
go
We can see, data inserting inside the past table of these example needs book.Exec indicates to carry out Calling Stored Procedure.Add the title insert_book of storing process in the exec back, and the statement variable, the function of insert_book is carried out in expression, and inserts relevant information toward table book the inside.The great like this processing speed that has promoted database.
Foregoing storing process can be divided into following 5 classes:
1. system stored procedures: system stored procedures is that Microsoft is built in the storing process in product.In SQL Server 2000, system stored procedures is positioned at master database, take sp_ as prefix, and is labeled as " system " (MS Shipped).In SQL Server 2005, system stored procedures is positioned at the resource database that an inside hides physically, is present in logic in each database.
For example, the code below the operation can be designated system stored procedures to the sp_Proc1 storing process:
USE master；
EXEC sp_MS_marksystemobject′dbo.sp_Proc1′。
2. local storing process: the storing process that the user creates is to be created and completed the storing process of a certain specific function by the user, and in fact general said storing process just refers to local storing process.
For example, write the SQL grammer of storing process of local data base as follows:
create or replace procedure test2 is
p integer；
begin
test@doko(1，p)；
dbms_output.put_line(′p＝′‖p)；
end test2
3. temporary stored procedure can be divided into two kinds of temporary stored procedures:
The one, local temporary stored procedure, with the first character of pound sign (#) as its title, this storing process will become a local temporary stored procedure that leaves in tempdb database, and only have the user who creates it could carry out it;
Grammer is as follows: create procedure #book_proc
Only have the user who creates it can carry out it, and when the disconnected SQL of this user, can be automatically deleted.
Use storing process that the security of database is improved, because only have specific user that pair right to use of designated store process is just arranged.
The 2nd, overall temporary stored procedure, with two pound signs (##) number beginning, this storing process will become an overall temporary stored procedure that is stored in tempdb database, overall situation temporary stored procedure is in case create, the any user who is connected to later on server can carry out it, and does not need specific authority.
Grammer is as follows: create procedure ##book_proc
The user can carry out it arbitrarily, and when a user disconnected, SQL can inquire about and have or not other user to use, if having, keeps, until all users disconnect, is just automatically deleted.But after having the user to disconnect, this storing process can not re-execute again.
4. remote stored procedure: in SQL Server2005, remote stored procedure (Remote Stored Procedures) is the storing process that is positioned on remote server, usually can use distributed query and fill order to carry out a remote stored procedure.
5. extended stored procedure: extended stored procedure (Extended Stored Procedures) is the storing process that the user can use the external program language compilation, and the title of extended stored procedure starts with xp_ usually.
The below enumerates some extended stored procedures relatively more commonly used:
Xp_availablemedia---check the spatial information of disc driver available in system;
Xp_dirtree---check the structure of all sub-directories under certain catalogue;
Xp_enumdsn---check the odbc data source that sets in system;
Xp_enumgroups---check the group information in system;
Xp_getfiledetails---obtain the attribute of certain file;
Xp_makecab---within a plurality of file destinations are compressed to certain target folder.All archives that will compress can be connected on the rear of Argument List.As: xp_makecab ' c: test.zip ', ' mszip ', 1, ' c: 1.txt ', ' c:2.txt '.
Step 13: the result of calculation of returning to the corresponding storing process of described database operation demand.
The result of calculation here comprises the data message that the database operation demand needing in database of the artificial electromagnetic material design that obtains after its corresponding storing process operation to be carried out the different physical arrangements that design.The result of calculation of the storing process that returns can be to utilize storing process to the result of interpolation, insertion, inquiry or the deletion of the information such as physical characteristics of the structural parameters of artificial electromagnetic material and artificial electromagnetic material.
Utilize storing process that the artificial electromagnetic material design database is processed, greatly improved the processing speed to the artificial electromagnetic material design database, can realize the needs that the artificial electromagnetic material industrialization is produced.
The above is only embodiments of the invention; not thereby limit the scope of the claims of the present invention; every equivalent structure or equivalent flow process conversion that utilizes instructions of the present invention and accompanying drawing content to do; or directly or indirectly be used in other relevant technical fields, all in like manner be included in scope of patent protection of the present invention.
Claims (10)
1. a data base processing method that is used for the artificial electromagnetic material design, is characterized in that, comprising:
Confirm the database operation demand of artificial electromagnetic material design;
Whether comprise the corresponding storing process of described database operation demand in the storing process storehouse that judgement is set up in advance;
If comprise, call and carry out the corresponding storing process of described database operation demand in described storing process storehouse;
Return to the result of calculation of the corresponding storing process of described database operation demand.
2. method according to claim 1, is characterized in that, the database operation demand of described artificial electromagnetic material design comprises needs the data message that designs in the database of described artificial electromagnetic material design.
3. method according to claim 1, it is characterized in that, the described step of calling and carry out the corresponding storing process of described database operation demand in described storing process storehouse comprises: call and carry out the corresponding storing process of described database operation demand by calling be used to the create name that identifies the corresponding storing process of described database operation demand.
4. method according to claim 1, it is characterized in that, whether comprise the corresponding storing process step of described database operation demand in described judgement is set up in advance storing process storehouse in, also comprise step: if do not comprise, create the corresponding storing process of described database operation demand.
5. method according to claim 4, is characterized in that, in the step of the corresponding storing process of the described database operation demand of described establishment, also comprises step: identify the storing process that creates with create name.
6. method according to claim 5, it is characterized in that, after the step of the described database that designs with the described artificial electromagnetic material of create name mark, also comprise step: the corresponding storing process of described database operation demand is saved in described stored procedures database.
7. method according to claim 4, is characterized in that, the corresponding storing process of described database operation demand comprises: to renewal, insertion, deletion and the query manipulation of the database operation demand of described artificial electromagnetic material design.
8. according to claim 1-7 described methods of any one, it is characterized in that, the corresponding storing process of described database operation demand is selected from least a in following five kinds: the storing process that system provides, local storing process, interim storing process, long-range storing process and extended stored procedure.
9. method according to claim 8, is characterized in that, described temporary stored procedure comprises: local temporary stored procedure and overall temporary stored procedure.
10. method according to claim 1, it is characterized in that, the result of calculation of the corresponding storing process of described database operation demand comprises the data message that the database operation demand needing in the database of the artificial electromagnetic material design that obtains after the operation of the corresponding storing process of described database operation demand to be carried out the different physical arrangements that design.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104183741A CN103164445A (en) | 2011-12-14 | 2011-12-14 | Manual electromagnetic material design data base processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104183741A CN103164445A (en) | 2011-12-14 | 2011-12-14 | Manual electromagnetic material design data base processing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103164445A true CN103164445A (en) | 2013-06-19 |
Family
ID=48587539
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011104183741A Pending CN103164445A (en) | 2011-12-14 | 2011-12-14 | Manual electromagnetic material design data base processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103164445A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7461092B1 (en) * | 2005-09-12 | 2008-12-02 | Storage Technology Corporation | Content organization and storage method for storing holographic search database |
| CN101493827A (en) * | 2008-01-21 | 2009-07-29 | 鸿富锦精密工业（深圳）有限公司 | Storage process adaptive system and method |
| CN101582071A (en) * | 2008-05-16 | 2009-11-18 | 鸿富锦精密工业（深圳）有限公司 | System and method for updating data |
-
2011
- 2011-12-14 CN CN2011104183741A patent/CN103164445A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7461092B1 (en) * | 2005-09-12 | 2008-12-02 | Storage Technology Corporation | Content organization and storage method for storing holographic search database |
| CN101493827A (en) * | 2008-01-21 | 2009-07-29 | 鸿富锦精密工业（深圳）有限公司 | Storage process adaptive system and method |
| CN101582071A (en) * | 2008-05-16 | 2009-11-18 | 鸿富锦精密工业（深圳）有限公司 | System and method for updating data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108052321B (en) | Method for automatically generating intelligent contract of block chain based on configuration information | |
| CN103530327B (en) | A kind of data migration method from non-relational database to relevant database | |
| CN102752372A (en) | File based database synchronization method | |
| CN101499069B (en) | Internal memory database file updating method and apparatus | |
| CN101794226B (en) | Service software construction method and system adapting to multiple business abstraction levels | |
| CN105447122A (en) | Implementation method for autonomously creating file system based on multi-table association | |
| CN104899295B (en) | A kind of heterogeneous data source data relation analysis method | |
| CN105224377A (en) | A kind of method by metadata automatic generating software project code file and device | |
| CN104331285A (en) | Automatic code generation method and system | |
| CN103902671A (en) | Dynamic integration method and system of multi-source heterogeneous data | |
| CN103425762A (en) | Telecom operator mass data processing method based on Hadoop platform | |
| WO1999052047A1 (en) | Method and system for migrating data | |
| CN109508355A (en) | A kind of data pick-up method, system and terminal device | |
| CN104965735A (en) | Apparatus for generating upgrade SQL script | |
| CN103995854A (en) | Equipment cross-version upgrading method and device | |
| US20120158453A1 (en) | Workflow processing system for supporting multi-tenant, and method thereof | |
| CN102393889A (en) | Permissions configuration management system | |
| CN104321739A (en) | System and method of hierarchical data containers | |
| CN101727322A (en) | Method and device for optimizing bill of material management interface | |
| CN102054034A (en) | Implementation method for business basic data persistence of enterprise information system | |
| CN102375827B (en) | Method for fast loading versioned electricity network model database | |
| CN110147361A (en) | The system and method for master data coding rule maintenance function are realized under big data environment | |
| CN101719168A (en) | Algorithm configurability-based universal data loading method | |
| CN109726192A (en) | The system and method for master data model version and field separate management function is realized based on big data environment | |
| CN104376073A (en) | Database recovery method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130619 |