CN110457309A - A kind of database for metal material characterization parameter - Google Patents
A kind of database for metal material characterization parameter Download PDFInfo
- Publication number
- CN110457309A CN110457309A CN201910584636.8A CN201910584636A CN110457309A CN 110457309 A CN110457309 A CN 110457309A CN 201910584636 A CN201910584636 A CN 201910584636A CN 110457309 A CN110457309 A CN 110457309A
- Authority
- CN
- China
- Prior art keywords
- data
- interface
- database
- metal material
- characterization parameter
- 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
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
Abstract
The present invention provides a kind of database for metal material characterization parameter, belongs to technical field of metal material.The database includes account management interface, data upload interface, audit interface, data retrieval interface.Metal material characterization parameter information, including chemical component, manufacturing process, microstructure defect, mechanical property in data upload interface etc..The uploaded format and form that item is uploaded in data upload interface are standardized.Database is intended to that experimental data is calculated data collection and got up, data is made to have more logic, more easily find the potential rule of data, preferably contrived experiment, while by the unified formatting of data, it is convenient for the training of the machine learning mode such as neural network and support vector machines.
Description
Technical field
The present invention relates to technical field of metal material, particularly relate to a kind of database for metal material characterization parameter.
Background technique
In order to reduce cost, US President Barack Obama is in 2011 while guaranteeing to accelerate material development process and quality
Year proposes material genome plan (MGI), and the material database as one of the big tool of material genome plan three is just shown
It is most important, traditional material science depends on " trial-and-error method ", that is, proposes to assume then experimental verification, later scientist has found this
Kind method inefficiency, greatly spends human and material resources, and is unable to satisfy demand of the current industrial development to new material.And material
Database incorporates data science in material science, and material calculating, material experiment and material data are combined, number is passed through
The possibility of discovery new material is improved according to analysis and calculating.
Laboratory can all generate a large amount of different about metal material characterization parameter data daily, however these data are all divided
It is dispersed in everyone hand, everybody does not know what data others possesses from each other, when oneself needs certain experimental data
When, it tends to repeat to test, causes the waste in a large amount of manpower and material resources levels.Therefore, each data of experimental data
Come all hard-earned.However the form of expression about metal material characterization parameter is varied, for example macrograph may include
Metallograph, EBSD photo etc., manufacturing process, it is possible to which, including welding, rolling etc., this just uploads boundary to database data
The setting of the upload form in face causes very big difficulty.
Database is intended to that experimental data is calculated data collection and got up, data is made to have more logic, for mutual between everybody
It mutually consults, it is easier to find the potential rule of data, preferably contrived experiment；Simultaneously by the unified formatting of data, it is convenient for
The training of the machine learning mode such as neural network and support vector machines.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of database for metal material characterization parameter, the databases
Have and update at any time, data sharing uploads the features such as easy and access speed is fast.
The database includes account management interface, data upload interface, audit interface, data retrieval interface, while account
Administration interface, data upload interface, audit interface, data retrieval interface are connected with database back end respectively.
Wherein, metal material characterization parameter information, metal material characterization parameter packet are uploaded in database upload interface
Include chemical component, manufacturing process, microstructure defect, mechanical property, data source, add-ins.
The information of each interface transmitting is the data that will be encapsulated with data structure, with parameter transmitting or the shape of return value
Formula is transmitted between each interface.
Three kinds of manufacturing process temperature, time, deformation quantity parameters indicate that manufacturing process is welding or rolling mill practice,
In, it is rolling mill practice there are deformation quantity, is then welding procedure, the two-dimentional broken line of temperature and time composition there is no deformation quantity
Figure, reaction rolling temperature, rolling interval, rate temperature change.
Microscopic structure includes metallograph or EBSD photo and its corresponding treatment conditions；The database contains and laboratory
The mating interface of EBSD experiment can will generate in EBSD experiment big for each person every day on the basis of agreeing to uploading protocol
Amount data upload automatically.
Mechanical property includes yield strength, tensile strength, ballistic work, impact temperature, hardness, uniform elongation, uniformly receives
Shrinkage, tensile stress strain curve, drop hammer test, nondestructive inspection, clod wash, crack tip extension, double stretching, fatigue, corruption
Erosion.
Data source includes name, time, place, Experiment name, experimental expenses, upload data times.To facilitate to reality
The enthusiasm tested the standardized management of room and excite everybody to shared data.
User enters database login page by Web network address, by account management interface register account number, related personal letter
Breath is stored in database back end and after the audit of administrator's background audit interface successfully obtains permission, enters number by account number cipher
According to search interface, the retrieval and inquisition of related data is carried out by keyword and range of choice.User can carry out data upload, repair
Change and delete operation.It can record user's search information at data retrieval interface and successively sort from top to bottom according to search temperature.
Data upload interface and data search interface are mounted in intelligent terminal in the form of software, the intelligence behaviour
Make terminal through internet and mobile Internet to be attached with server.
The advantageous effects of the above technical solutions of the present invention are as follows:
Experimental data can be calculated data collection and got up, so that data is had more logic, it is easier to find number by the database
According to potential rule, preferably contrived experiment；Simultaneously by the unified formatting of data, it is convenient for neural network and support vector machines
The training of equal machine learning mode；By each Experiment name of everyone in laboratory, experimental data, experimental expenses is recorded,
The convenient standardized management to laboratory.
Detailed description of the invention
Fig. 1 is the database structure schematic diagram for metal material characterization parameter of the invention；
Fig. 2 is the database allomeric function structural schematic diagram for metal material characterization parameter of the invention.
Specific embodiment
To keep the technical problem to be solved in the present invention, technical solution and advantage clearer, below in conjunction with attached drawing and tool
Body embodiment is described in detail.
The present invention provides a kind of database for metal material characterization parameter.
As described in Figure 1, which includes account management interface, data upload interface, audit interface, data retrieval circle
Face, while account management interface, data upload interface, audit interface, data retrieval interface are connected with database back end respectively.
Wherein, metal material characterization parameter information, metal material characterization parameter packet are uploaded in database upload interface
Include chemical component, manufacturing process, microstructure defect, mechanical property, data source, add-ins.
The information of each interface transmitting is the data that will be encapsulated with data structure, with parameter transmitting or the shape of return value
Formula is transmitted between each interface.
Three kinds of manufacturing process temperature, time, deformation quantity parameters indicate that manufacturing process is welding or rolling mill practice,
In, it is rolling mill practice there are deformation quantity, is then welding procedure, the two-dimentional broken line of temperature and time composition there is no deformation quantity
Figure, reaction rolling temperature, rolling interval, rate temperature change.
Microscopic structure includes metallograph or EBSD (electron backscatter diffraction) photo and its corresponding treatment conditions；The number
Containing according to library will can exist for each person every day on the basis of agreeing to uploading protocol with the mating interface of laboratory EBSD experiment
The mass data generated in EBSD experiment uploads automatically.
Mechanical property includes yield strength, tensile strength, ballistic work, impact temperature, hardness, uniform elongation, uniformly receives
Shrinkage, tensile stress strain curve, drop hammer test (DWTT), nondestructive inspection (NDT), clod wash, crack tip extension
(CTOD), double stretching, fatigue, corrosion.
Data upload interface and data search interface are mounted in intelligent terminal in the form of software, the intelligence behaviour
Make terminal through internet and mobile Internet to be attached with server.
Data source includes name, time, place, Experiment name, experimental expenses, upload data times.To facilitate to reality
Test the standardized management of room and excite everybody to the enthusiasm of shared data and data when something goes wrong, in time connection carry out more
Change；The setting of add-ins option keeps database more flexible when uploading data, and database data upload interface not will include certainly
The total data of metal material characterization, when upload personnel need the metal uploaded characterization supplemental characteristic not relate in upload interface
In time, it can be arranged by add-ins and need to upload data name, and then add related accessories, it is added in the database.
In practical applications, database is constructed based on 2012 system of SQL Server, can be erected at solid-state service
In device, also can be used cloud storage, cloud storage use Web3.0 technology, by Web3.0 technology can by file, number,
Picture even video/audio store beyond the clouds and is shared, and when needing using database, can be logged in network address whenever and wherever possible and be come pair
Data carry out retrieval upload.
Database development environment is asp.net+hsweb3.0+SQL Server 2012, and underlying database uses SQL
2012 data base management systems.It is flat that running environment need to install net framework 4.0+SQLServer2012+hsweb3.0
Platform.
In a particular application, in laboratory everyone upload data require administrator enter backstage carry out audit pass through
Afterwards, data information can store, and upload data number to everyone in laboratory and count.
For the frame retrieval of blank, retrieval is clicked, may occur in which database total data list, is retrieval model above list
It encloses, range of search includes chemical component, the numberical range of mechanical property, and can be retrieved to keyword, the key
The search order of word content closely conforms to degree with keyword and is arranged successively from high to low.When showing the page into material information,
It shows all information, has header list, such as ingredient on the left of display interface, organize, technique etc., click title entering part information page
Face.
After database sharing success, laboratory member enters database login page by Web network address, passes through account management
Interface register account number, associated personal information are stored in database and after the audit of background audit interface successfully obtain permission, pass through
Account number cipher enters the database retrieval page, and the retrieval and inquisition of related data is carried out by keyword and range of choice.And it can be with
Carry out data upload, modification and delete operation.Recordable user searches for information and successively sorts from top to bottom according to search temperature.
The successful place of database is, in data upload interface, creatively by metal material manufacturing process as welded
It connects, roll etc. with same three parameters, it is rolling mill practice there are deformation quantity, no that temperature, time and deformation quantity, which are described,
It is then welding procedure there are deformation quantity, the two-dimentional line chart of temperature and time composition, and can neatly react, rolling temperature,
Rolling interval, rate temperature change etc..；In data upload interface, add-ins are added, it is more flexible when uploading data, it keeps away
Exempting from important characterization parameter data can not upload because not having uploaded format.Solves current most metal materials laboratory
In, because experimental data is dispersed in everyone hand, experimental data sharing degree is low, repeats test to cause the waste of manpower and material resources
The problems such as.And experimental data is standardized, it visualizes, centralization, regularization is with unified regular, convenient for for implying rule in material
The discovery of rule simultaneously facilitates the calculating for carrying out data.When needing certain parameter of material, first goes to consult in database and see whether deposit
Experiment the time it takes and money are being done if it does, will be greatly saved, if it does not, carrying out related experiment again.
It is explained combined with specific embodiments below.
As shown in Fig. 2, database provides metal material characterization parameter information, including chemical component, manufacturing process, group
Picture, defect, mechanical property, data source, add-ins are knitted, wherein manufacturing process creatively uses temperature, time, deformation quantity three
Kind parameter flexibly to indicate that manufacturing process is that welding or rolling or other process means are as shown in table 1, and there are deformation quantities to be
Rolling mill practice is then welding procedure there is no deformation quantity, the two-dimentional line chart of temperature and time composition, and can be neatly anti-
It answers, rolling temperature, rolling interval, rate temperature change etc.；Tissue picture includes metallograph or EBSD photo and its corresponding
Treatment conditions it is as shown in table 2, and database contain with laboratory EBSD test (electron backscatter diffraction) interface, in agreement
On the basis of passing agreement, the mass data generated in EBSD experiment for each person every day can be uploaded automatically.；Mechanical property includes
Yield strength, tensile strength, ballistic work, impact temperature, hardness, uniform elongation, uniform shrinkage rate, tensile stress strain curve
Deng；Data source refers to that each data can show the personnel for uploading notebook data in database, occur to facilitate in data
When problem, him is contacted in time and is modified；More flexible, database number when the setting of add-ins option makes database upload data
It certainly will not include the total data of metal material characterization according to upload interface, when the metal characterization ginseng that upload personnel need to upload
Number data upload interface without reference to when, can be arranged by add-ins and need to upload data name, and then add related attached
Part adds it in the database.
Arq mode in 1 manufacturing process of table
2 organization chart on piece arq mode of table
Database is constructed based on 2012 system of SQL Server, can be erected in solid state server, can also be made
It is stored with cloud, cloud storage uses Web3.0 technology, can be by file, number, picture even video by Web3.0 technology
Audio is stored beyond the clouds and is shared, and when needing using database, can log in whenever and wherever possible network address to retrieve to data
It uploads.
Database development environment is asp.net+hsweb3.0+SQL Server 2012, and underlying database uses SQL
2012 data base management systems.It is flat that running environment need to install net framework 4.0+SQLServer2012+hsweb3.0
Platform.
Data acquisition interface and data output interface are mounted in intelligent terminal in the form of software, the intelligence
Operating terminal can be attached by internet and mobile Internet with server.
The data that everyone uploads in laboratory require administrator and enter backstage progress after the approval, data information side
It can store, and data number is uploaded to everyone in laboratory and is counted.
For the frame retrieval of blank, retrieval is clicked, may occur in which database total data list, is retrieval model above list
Enclose, range of search includes chemical component, such as the range of C, S, P constituent content, mechanical property for example yield strength, tensile strength,
The numberical ranges such as ballistic work, impact temperature, hardness, uniform elongation, uniform shrinkage rate, and keyword can be retrieved,
The search order of the keyword content closely conforms to degree with keyword and is arranged successively from high to low.It is aobvious into material information
It when showing the page, shows all information, has header list, such as ingredient on the left of display interface, organize, technique etc., click title and enter
The partial information page.
The data retrieval interface of database is first formatted reading data, obtains whole in confirmation when calling
The information that after reading in data, data are sent to server by network, and server to be received is waited to return, receives return information
Information is handled immediately afterwards, generates corresponding output.
Laboratory member enters database login page by Web network address, related by account management interface register account number
Personal information is stored in database and after the audit of background audit interface successfully obtains permission, enters database by account number cipher
The page is retrieved, the retrieval and inquisition of related data is carried out by keyword and range of choice.
The above is a preferred embodiment of the present invention, it is noted that for those skilled in the art
For, without departing from the principles of the present invention, several improvements and modifications can also be made, these improvements and modifications
It should be regarded as protection scope of the present invention.
Claims (9)
1. a kind of database for metal material characterization parameter, it is characterised in that: upload boundary including account management interface, data
Face, audit interface and data search interface, account management interface, data upload interface, audit interface and data search interface point
It is not connected with database back end.
2. the database according to claim 1 for metal material characterization parameter, it is characterised in that: on the database
It passes and uploads metal material characterization parameter information in interface, metal material characterization parameter information includes chemical component, manufacturing process, shows
Micro-assembly robot, defect, mechanical property, data source, add-ins.
3. the database according to claim 1 for metal material characterization parameter, it is characterised in that: the account management
Interface, data upload interface, audit interface and data search interface interface transmitting information be that will be encapsulated with data structure
Data, transmitted between each interface in the form of parameter transmitting or return value, and then database Back end data is called.
4. the database according to claim 2 for metal material characterization parameter, it is characterised in that: the manufacturing process
Indicate that manufacturing process is welding or rolling mill practice with three kinds of temperature, time, deformation quantity parameters, wherein there are deformation quantities to be
It is then welding procedure there is no deformation quantity for rolling mill practice, the two-dimentional line chart of temperature and time composition, reaction rolling temperature,
Rolling interval, rate temperature change.
5. the database according to claim 2 for metal material characterization parameter, it is characterised in that: the microscopic structure
Including metallograph or EBSD photo and its corresponding treatment conditions；The database contains to be connect with docking for laboratory EBSD experiment
Mouthful, on the basis of agreeing to uploading protocol, the mass data generated in EBSD experiment for each person every day can be uploaded automatically.
6. the database according to claim 2 for metal material characterization parameter, it is characterised in that: the mechanical property
Including yield strength, tensile strength, ballistic work, impact temperature, hardness, uniform elongation, uniform shrinkage rate, tensile stress-strain
Curve, drop hammer test, nondestructive inspection, clod wash, crack tip extension, double stretching, fatigue, corrosion.
7. the database according to claim 2 for metal material characterization parameter, it is characterised in that: the data source
Including name, the time, place, Experiment name, experimental expenses, upload data times.
8. the database according to claim 1 for metal material characterization parameter, it is characterised in that: user passes through Web
Network address enters database login page, and by account management interface register account number, associated personal information is stored in database back end simultaneously
After audit successfully obtains permission by administrator's background audit interface, data retrieval interface is entered by account number cipher, passes through pass
Keyword and range of choice carry out the retrieval and inquisition of related data.
9. the database according to claim 1 for metal material characterization parameter, it is characterised in that: the data upload
Interface and data search interface are mounted in intelligent terminal in the form of software, and the intelligent terminal passes through internet
It is attached with mobile Internet and server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910584636.8A CN110457309A (en) | 2019-07-01 | 2019-07-01 | A kind of database for metal material characterization parameter |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910584636.8A CN110457309A (en) | 2019-07-01 | 2019-07-01 | A kind of database for metal material characterization parameter |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110457309A true CN110457309A (en) | 2019-11-15 |
Family
ID=68481888
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910584636.8A Pending CN110457309A (en) | 2019-07-01 | 2019-07-01 | A kind of database for metal material characterization parameter |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457309A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112965998A (en) * | 2021-02-04 | 2021-06-15 | 成都健数科技有限公司 | Compound database establishing and searching method and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100042351A1 (en) * | 2008-07-10 | 2010-02-18 | Covey Todd M | Methods and apparatus related to management of experiments |
| CN107480954A (en) * | 2017-08-22 | 2017-12-15 | 北京化工大学 | A kind of petroleum works LIMS |
| CN109034718A (en) * | 2018-06-05 | 2018-12-18 | 河北农业大学 | A kind of laboratory information total management system |
| CN109800591A (en) * | 2019-03-26 | 2019-05-24 | 上海盛巨信息技术有限公司 | The data processing method and system of medical laboratory's quality management |
-
2019
- 2019-07-01 CN CN201910584636.8A patent/CN110457309A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100042351A1 (en) * | 2008-07-10 | 2010-02-18 | Covey Todd M | Methods and apparatus related to management of experiments |
| CN107480954A (en) * | 2017-08-22 | 2017-12-15 | 北京化工大学 | A kind of petroleum works LIMS |
| CN109034718A (en) * | 2018-06-05 | 2018-12-18 | 河北农业大学 | A kind of laboratory information total management system |
| CN109800591A (en) * | 2019-03-26 | 2019-05-24 | 上海盛巨信息技术有限公司 | The data processing method and system of medical laboratory's quality management |
Non-Patent Citations (2)
| Title |
|---|
| 康医飞 等: "基于AMASS的车用材料数据管理系统研究", 《汽车材料与涂装》 * |
| 张亚鹏: "论高速公路施工质量信息化管理系统的应用", 《管理科学》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112965998A (en) * | 2021-02-04 | 2021-06-15 | 成都健数科技有限公司 | Compound database establishing and searching method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7774291B2 (en) | Network of networks of associative memory networks for knowledge management | |
| Kaur et al. | Ranked set sampling: an annotated bibliography | |
| US9256686B2 (en) | Using a bloom filter in a web analytics application | |
| Walters | Comparative recall and precision of simple and expert searches in Google Scholar and eight other databases | |
| Ozmutlu et al. | Application of automatic topic identification on excite web search engine data logs | |
| CN110462604A (en) | The data processing system and method for association internet device are used based on equipment | |
| Wallis et al. | Moving archival practices upstream: An exploration of the life cycle of ecological sensing data in collaborative field research | |
| Zhao et al. | Crowd-Selection Query Processing in Crowdsourcing Databases: A Task-Driven Approach. | |
| CN102779193A (en) | Self-adaptive personalized information retrieval system and method | |
| Wang et al. | Personalized recommendation for new questions in community question answering | |
| CN113139750B (en) | Course recommendation method and device, server and storage medium | |
| Dzihni et al. | Business process analysis and academic information system audit of helpdesk application using genetic algorithms a process mining approach | |
| CN101097575A (en) | Examination questions generation system and method there | |
| Rakhman et al. | Applying analytic hierarchy process for measuring knowledge management readiness in government institutions | |
| Chen et al. | The best answers? think twice: online detection of commercial campaigns in the CQA forums | |
| Mitchell et al. | Extracting knowledge about users’ activities from raw workstation | |
| CN110457309A (en) | A kind of database for metal material characterization parameter | |
| CN107423382A (en) | network crawling method and device | |
| CN111241821A (en) | Method and device for determining behavior characteristics of user | |
| RU2305314C1 (en) | Method for finding and selecting information in various databases | |
| CN101212337A (en) | Method for constructing online personal identity database automatically | |
| Al-Hamzi | The Implementation of Software Measurement Programs in Medium and Small Projects: A Systematic Literature Review | |
| Acheampong et al. | Information-Seeking Behaviour of Crops Research Scientists in Ghana | |
| CN114331789B (en) | Intelligent cheap and clean knowledge recommendation method, device, equipment and storage medium | |
| Franco et al. | Meeting organizational performance with shared knowledge management processes |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191115 |
|
| RJ01 | Rejection of invention patent application after publication |