CN110134743B - Database management system and method for overall dimension of finished board - Google Patents
Database management system and method for overall dimension of finished board Download PDFInfo
- Publication number
- CN110134743B CN110134743B CN201910419021.XA CN201910419021A CN110134743B CN 110134743 B CN110134743 B CN 110134743B CN 201910419021 A CN201910419021 A CN 201910419021A CN 110134743 B CN110134743 B CN 110134743B
- Authority
- CN
- China
- Prior art keywords
- unit
- track
- finished
- slab
- detection
- 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.)
- Active
Links
Images
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/2433—Query languages
-
- 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/248—Presentation of query results
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention provides a database management system for the overall dimension of a finished board, which takes MySQL as a database and C # language as a system development tool, simultaneously carries out Windows embedded front-end page design, provides a visual query interface, has the functions of finished board detection information warehousing, query, sequencing, deletion, viewing, quality check, output and the like, provides a unified, safe, standard and convenient management mode for the detection result of the finished board, improves the sharing degree of the detection result, increases the independence of data, and simultaneously greatly reduces the construction and maintenance cost of an informatization system for the finished board overall dimension detection result. Based on the system, the invention also provides a database management method for the overall dimension of the finished board. The invention has simple structure, reasonable design and strong popularization and application value.
Description
Technical Field
The invention belongs to the technical field of database storage, and particularly relates to a database management system and method for the overall dimension of a finished board.
Background
The track slab is used as a foundation for bearing the steel rail, the dimensional accuracy of the track slab is directly related to the laying and installation of the track, and the track slab has very important influence on the stability and smoothness of the track and the running safety of a train, so that higher accuracy requirements are provided for the geometric dimension of the track slab before laying. In order to ensure that the manufactured track slab meets the production requirements, each finished slab must be strictly detected in various detection items before being paved.
However, the types of the finished track slab are more, and the types and the number of the detection result tables are more. Therefore, if the track slab detection result table is managed by manual management or a file system, the management is easy to be disordered, serious results such as loss of the detection result table and the like can be caused, and the time for looking up, browsing and rechecking is inconvenient.
In order to perform structured management on finished product board detection results, improve the sharing degree of the detection results, increase the data independence, improve the data recoverability, prevent random copy of a finished product board detection result report and intentional modification of the detection results, and reduce the redundancy degree of the finished product board detection result report, the detection results must be managed by a database. Therefore, the management and storage of the finished board detection data is an important mark for realizing 'automatic' and 'informationized' management of the track board outline dimension deviation detection.
Disclosure of Invention
Aiming at the defects in the prior art, the database management system and the database management method for the overall dimension of the finished product board can provide a uniform, safe, standard and convenient management mode for the detection result of the finished product board, improve the sharing degree of the detection result and increase the independence of data.
In order to achieve the above purpose, the invention adopts the technical scheme that:
the scheme provides a database management system for the overall dimension of a finished board, which comprises a foreground processing module and a background management module connected with the foreground processing module, wherein,
the foreground processing module is an operation interface and is used for finishing the operation of the background management module;
the background management module is a local server which is built by taking MySQL as a database and is used for processing and storing the detection information of the finished board.
Still further, the foreground processing module comprises two query sub-modules, two sequencing sub-modules and an automatic detection report output sub-module, wherein,
the two query sub-modules comprise a finished plate type query unit and a track plate mold query unit;
the two sorting sub-modules comprise a date sorting unit and a name sorting unit;
the automatic output sub-module of the detection report comprises an index catalog unit, a result list unit, a track plate record table unit, a track plate overall dimension detection card unit, a track plate overall dimension graphic display unit, a track plate appearance quality unit and all detection item sub-table units except skew.
Furthermore, the two query sub-modules of the foreground processing module are divided into two-level management and three-level management, wherein,
when the finished board type is inquired, a foreground processing module executes three-level management, wherein the three-level management respectively comprises the following steps: the plate type of the finished plate is managed for the first level, the track plate number is managed for the second level, and the measured value of each detection item of the finished plate is managed for the third level;
when the track plate mold is inquired, a foreground processing module executes two-stage management, wherein the two-stage management respectively comprises the following steps: the model of the track slab mold is the first-level management, the measured value of each detection item of the finished slab is the second-level management, and the measured values of each detection item of the finished slab are arranged according to the detection time as a progressive sequence.
Still further, the background management module comprises an information processing sub-module and a database management sub-module connected with the information processing sub-module.
Still further, the information processing sub-module is composed of a login unit, a storage unit, an inquiry unit, a sorting unit, a deletion unit, a check unit, a quality check unit and an output unit which are connected with each other,
the login unit is used for logging in the database management system according to the user name and the password;
the warehousing unit is used for warehousing the detection result of the finished board;
the query unit is used for checking the finished plate detection results of each detection date according to two query modes of a finished plate type query mode and a track plate mold query mode and automatically outputting the query results through a detection report;
the sorting unit is used for sorting and inquiring the finished board detection results according to two sorting modes of date and name and displaying the inquiry result;
the deleting unit is used for deleting unqualified finished board detection results;
the checking unit is used for checking the attributes of the finished plate, and the checking unit comprises checking track plate number, finished plate detection time, detection serial number, operators, contact ways, plate type attributes and detection information for manufacturing track plate molds;
the quality checking unit is used for checking whether the deviation of the overall dimension of the finished board exceeds the limit or not and prompting the exceeding information;
the output unit is used for outputting a detection report meeting the requirements.
Still further, the database management sub-module is composed of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished slab automatic detection unit and a track bearing platform automatic detection unit, wherein,
the track plate type unit comprises 7 attributes which are respectively an ID attribute, the number of rail bearing platforms, the name and the symmetry of the track plate, the overall dimension value of the track plate, the running track of the robot corresponding to the track plate type and an alignment parameter corresponding to the track plate type unit;
the track slab curve information unit comprises 3 attributes which are respectively an ID attribute, a curve radius and a design offset of a track bearing platform corresponding to the track slab curve information unit;
the track slab mold information unit comprises 3 attributes which are respectively an ID attribute, a track slab mold name and track slab mold information corresponding to the track slab mold information unit;
the automatic detection unit of the finished board comprises 7 attributes, namely a track board number, a line shape, ultrahigh information, bilateral symmetry, detection operation information, a relative relation between rail bearing platforms and a measured value of a frame;
the rail bearing platform automatic detection unit comprises 2 attributes which are respectively an ID attribute corresponding to the rail bearing platform automatic detection unit and measurement information inside the rail bearing platform.
Still further, the track slab type unit, the track slab curve information unit, the track slab mold information unit and the track bearing platform automatic detection unit respectively use one corresponding ID attribute as a unique index, and the finished slab automatic detection unit uses the track slab number as its index.
Still further, the track slab type unit is respectively connected with the track slab curve information unit and the mold information unit through corresponding ID attributes of the track slab type unit;
the track slab curve information unit is connected with the finished slab automatic detection unit through the corresponding ID attribute;
the track plate mould information unit is connected with the finished plate automatic detection unit through the corresponding ID attribute;
and the finished plate automatic detection unit is connected with the rail bearing platform automatic detection unit through the rail plate number attribute.
Based on the management system, the invention also discloses a database management method for the overall dimension of the finished board, which comprises the following steps:
s1, acquiring the incidence relation among 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and the incidence relation among the corresponding database tables;
s2, acquiring attribute names of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations between the field names of the database tables respectively corresponding to the attribute names;
s3, acquiring attribute values of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations between values of database field values corresponding to the attribute values;
s4, generating MySQL sentences according to the incidence relations among the 5 entities, the incidence relations among the database tables corresponding to the 5 entities, the attribute names of the 5 entity classes, the attribute values of the 5 entity classes, the corresponding relations among the database table field names corresponding to the 5 entities and the numerical value corresponding relations of the database table field values;
and S5, executing the MySQL statement to obtain a management result set, and reflecting the management result set to the database table, thereby realizing database management of the overall dimension of the finished board.
Further, the management result set in the step S5 includes a warehousing result set, a query result set, a sorting result set, a deleting result set, a viewing result set, a quality checking result set, and an output result set, wherein,
the warehousing result set is obtained by the execution result of the warehousing MySQL statement;
the query result set is obtained by querying an execution result of the MySQL statement;
the sequencing result set is obtained by sequencing the execution result of the MySQL statement;
the deletion result set is obtained by deleting the execution result of the MySQL statement;
the viewing result set is obtained by viewing the execution result of the MySQL statement;
the quality check result set is obtained by the execution result of the quality check MySQL statement;
the output result set is obtained by outputting the execution result of the MySQL statement.
The invention has the beneficial effects that:
(1) the invention provides a visual query interface, which has the functions of finished board detection information warehousing, query, sequencing, deletion, check, quality check, output and the like, has high system visualization degree, simple and convenient operation and intelligent and clear achievement management, provides a unified, safe and convenient management mode for finished board detection data, and enables detection personnel to conveniently, timely and accurately obtain required information from a database through a front-end interface of the database;
(2) according to the invention, a large amount of overall dimension detection data is organized through the system, so that the functions of storage, maintenance and retrieval are provided for detection results, the structured management of the detection data is realized, the sharing degree of the detection results is improved, the independence of the data is increased, the random copying of a track slab detection result report and the intentional modification of the detection results are prevented, and the problem of the management redundancy of a large amount of result reports is solved;
(3) the invention realizes the informatization management of the detection result of the finished board, greatly reduces the construction and maintenance cost of the informatization system of the finished board appearance dimension detection result, and has higher popularization and application values;
(4) the invention is connected with the data processing subsystem of the automatic detection system, and can directly carry out warehousing operation on the detection result after the detection of the finished track slab is finished, thereby realizing the integration and the flow of the detection process.
Drawings
FIG. 1 is a schematic diagram of the system of the present invention.
FIG. 2 is a schematic diagram of entities E-R in this embodiment.
Fig. 3 is a schematic structural diagram of a database management submodule in this embodiment.
FIG. 4 is a flow chart of the method of the present invention.
Detailed Description
The following description of the embodiments of the present invention is provided to facilitate the understanding of the present invention by those skilled in the art, but it should be understood that the present invention is not limited to the scope of the embodiments, and it will be apparent to those skilled in the art that various changes may be made without departing from the spirit and scope of the invention as defined and defined in the appended claims, and all matters produced by the invention using the inventive concept are protected.
Examples
The invention takes MySQL as a database, takes C # language as a system development tool, simultaneously carries out Windows embedded front-end page design, provides a visual query interface, has the functions of finished board detection information warehousing, query, sequencing, deletion, viewing, quality checking, output and the like, provides a unified, safe, standard and convenient management mode for the detection result of the finished board, improves the sharing degree of the detection result, increases the independence of data, and simultaneously greatly reduces the construction and maintenance cost of the finished board outline dimension detection result informatization system.
As shown in fig. 1, the present invention provides a database management system for overall dimensions of a finished board, which includes a foreground processing module and a background management module connected to the foreground processing module, wherein the foreground processing module is an operation interface for completing operations on the background management module, the background management module is a local server built by MySQL as a database for processing and storing detection information of the finished board, the foreground processing module includes two query sub-modules, two sorting sub-modules and a detection report automatic output sub-module, wherein the two query sub-modules include a finished board type query unit and a track board mold query unit, the two sorting sub-modules include a date sorting unit and a name sorting unit, and the detection report automatic output sub-module includes an index catalog unit, a database management module, and a database management module The result list unit, track board record table unit, track board overall dimension detection card unit, track board overall dimension graphic display unit, track board appearance quality unit and all detection items except skew divide the table unit, two kinds of inquiry submodule pieces of foreground processing module divide into second grade management and tertiary management, wherein, when inquiring to the finished board template, foreground processing module carries out tertiary management, and its tertiary management is respectively: the plate type of the finished plate is managed in a first level, the number of the track plate is managed in a second level, the measured value of each detection item of the finished plate is managed in a third level, and when the track plate is inquired, a foreground processing module executes two-level management, wherein the two-level management respectively comprises the following steps: the track slab mold model is the first-level management, the measured value of each detection item of the finished slab is the second-level management, and the measured value of each detection item of the finished slab is arranged according to the detection time as a progressive sequence, the background management module comprises an information processing submodule and a database management submodule connected with the information processing submodule, the information processing submodule consists of a login unit, a warehousing unit, an inquiry unit, a sequencing unit, a deletion unit, a checking unit, a quality checking unit and an output unit which are connected with each other, wherein the login unit is used for logging in a database management system according to a user name and a password, the warehousing unit is used for warehousing the detection result of the finished slab, and the inquiry unit is used for checking the detection result of the finished slab of each detection date according to two inquiry modes of the finished slab type and the track slab mold, and outputting the query result automatically through a detection report, wherein the sorting unit is used for sorting and querying the finished product board detection result according to two sorting modes of date and name and displaying the query result, the deleting unit is used for deleting the unqualified finished product board detection result, the checking unit is used for checking the attribute of the finished product board and comprises checking the track board number, the finished product board detection time, the detection sequence number, an operator, a contact mode, a board type attribute and detection information for manufacturing a track board mould, the quality checking unit is used for checking whether the deviation of the outer dimension of the finished product board exceeds the limit and prompting the information of the limit exceeding, the output unit is used for outputting the detection report meeting the management requirement, and the data submodule is composed of a track board type unit, a track board curve information unit, a track board mould information unit, a finished product board automatic detection unit and a track bearing platform automatic detection unit, wherein the track plate type unit includes 7 attributes, which are an ID attribute, a number of track bearing stages, a track plate name, symmetry, a track plate outer dimension value, a running track of the robot corresponding to the track plate type, and an alignment parameter corresponding to the track plate type unit, the track plate curve information unit includes 3 attributes, which are an ID attribute, a curve radius, and a track bearing stage design offset corresponding to the track plate curve information unit, the track plate mold information unit includes 3 attributes, which are an ID attribute, a track plate mold name, and track plate mold information corresponding to the track plate mold information unit, respectively, the finished plate automatic detection unit includes 7 attributes, which are a track plate number, a line shape, super high information, bilateral symmetry, detection operation information, a relative relationship between the track bearing stages, and a measured value of the frame, respectively, the automatic detection unit of the rail bearing platform comprises 2 attributes which are respectively an ID attribute corresponding to the automatic detection unit of the rail bearing platform and measurement information inside the rail bearing platform, the track slab type unit, the track slab curve information unit, the track slab mold information unit and the track bearing platform automatic detection unit respectively use one corresponding ID attribute as a unique index, the automatic detection unit of the finished product plate takes the track plate number as the index of the automatic detection unit, the track plate type unit is respectively connected with the track plate curve information unit and the mould information unit through the corresponding ID attribute, the track slab curve information unit is connected with the finished slab automatic detection unit through the corresponding ID attribute, the track plate mould information unit is connected with the finished plate automatic detection unit through the corresponding ID attribute, and the finished plate automatic detection unit is connected with the rail bearing platform automatic detection unit through the rail plate number attribute.
As shown in fig. 4, basically, the method according to the present invention further provides a database management method for the outline dimensions of a finished board, which comprises the following steps:
s1, acquiring the incidence relation among 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and the incidence relation among the corresponding database tables;
s2, acquiring attribute names of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations between the field names of the database tables respectively corresponding to the attribute names;
s3, acquiring attribute values of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations between values of database field values corresponding to the attribute values;
s4, generating MySQL sentences according to the incidence relations among the 5 entities, the incidence relations among the database tables corresponding to the 5 entities, the attribute names of the 5 entity classes, the attribute values of the 5 entity classes, the corresponding relations among the database table field names corresponding to the 5 entities and the numerical value corresponding relations of the database table field values;
s5, executing the MySQL sentence to obtain a management result set, and reflecting the management result set to the database table, thereby realizing the database management of the outline dimension of the finished board, wherein the management result set comprises a warehousing result set, a query result set, a sequencing result set, a deletion result set, a viewing result set, a quality checking result set and an output result set, wherein,
the warehousing result set is obtained by the execution result of the warehousing MySQL statement;
the query result set is obtained by querying an execution result of the MySQL statement;
the sequencing result set is obtained by sequencing the execution result of the MySQL statement;
the deletion result set is obtained by deleting the execution result of the MySQL statement;
the viewing result set is obtained by viewing the execution result of the MySQL statement;
the quality check result set is obtained by the execution result of the quality check MySQL statement;
the output result set is obtained by outputting the execution result of the MySQL statement.
In this embodiment, the foreground processing module mainly provides visual review of each detection project result of the finished board for the user, and performs operations such as warehousing, querying, sorting, deleting, viewing, and outputting on the detection result. The background management module is a module for a manager to maintain the system and the management system, and realizes unified, safe and convenient management of detection results by warehousing the detection information of each finished board.
In this embodiment, the track plate type is taken as a starting point; a plate type has a plurality of manufacturing dies, and comprises a linear plate, a circular curve plate and a gentle curve plate, wherein the linear plate can be considered as a special case of the curve plate, a finished plate of a plurality of track plates can be manufactured through the manufacturing dies and the curve line, and the finished plate comprises a plurality of track bearing platforms. As shown in fig. 2, the correlation among the track slab type unit, the track slab curve information unit, the track slab mold information unit, the finished product slab automatic detection unit and the track bearing platform automatic detection unit entity is represented by an E-R diagram, based on the MySQL database, the corresponding data tables and the correlation are established, and based on the open source database management system MySQL, the physical storage arrangement, the index establishment, the database internal mode establishment, the database physical model formation, and the storage of the finished product slab detection data are realized. In this embodiment, as shown in fig. 2, the track slab type unit and the track slab curve information unit have a "one-to-many" relationship, the track slab type unit and the track slab mold information unit have a "one-to-many" relationship, the track slab curve information unit and the finished slab detection unit have a "one-to-many" relationship, the track slab mold information unit and the finished slab automatic detection unit have a "one-to-many" relationship, and the finished slab automatic detection unit and the track supporting platform detection unit have a "one-to-many" relationship. Specifically, each entity unit has a plurality of attributes, wherein the track slab type unit entity comprises 7 attributes, namely an ID attribute, the number of rail bearing tables, a name, symmetry, a track slab overall dimension value, a robot running track of a track slab type and an alignment parameter; the track slab curve information unit entity comprises 3 attributes, namely an ID attribute, a curve radius and a design offset of a track bearing platform; the track slab mold information unit contains 3 attributes, namely an ID attribute, a mold name and other information (such as comments, descriptions and the like) of the mold; the finished board detection unit comprises 7 attributes, namely track board number, line shape, ultrahigh information, bilateral symmetry, detection operation information (such as detection date, detection personnel, detection equipment and the like), relative relation between rail bearing platforms, frame measurement value and other information; the automatic detection unit of the rail bearing platform comprises 2 attributes, namely ID and measurement information inside the rail bearing platform.
As shown in fig. 3, based on the MySQL database, corresponding data tables and associations therebetween are established, specifically, the track slab type unit is associated with the track slab curve information unit and the track slab mold information unit through ID attributes thereof; the finished board automatic detection unit is associated with the track board curve information through the ID attribute of the track board curve information; the automatic finished plate detection unit is associated with the track mold information unit through the ID attribute of the track mold information unit; the automatic detection unit of the track bearing platform is associated with the automatic detection unit of the finished board through the track board number attribute of the automatic detection unit of the finished board.
The invention provides a visual query interface for finished board management through the design, has the functions of finished board detection information warehousing, query, sorting, deletion, checking, quality checking, output and the like, provides a unified, safe, standard and convenient management mode for the detection results of the finished boards, improves the sharing degree of the detection results, increases the independence of data, and simultaneously greatly reduces the construction and maintenance cost of an informatization system for the finished board appearance dimension detection results.
Claims (3)
1. A database management system for the overall dimension of a finished board is characterized by comprising a foreground processing module and a background management module connected with the foreground processing module, wherein,
the foreground processing module is an operation interface and is used for finishing the operation of the background management module;
the background management module is a local server which is built by taking MySQL as a database and is used for processing and storing the detection information of the finished board;
the foreground processing module comprises two query sub-modules, two sequencing sub-modules and an automatic detection report output sub-module, wherein,
the two query sub-modules comprise a finished plate type query unit and a track plate mold query unit;
the two sorting sub-modules comprise a date sorting unit and a name sorting unit;
the automatic output sub-module of the detection report comprises an index catalog unit, a result list unit, a track plate record table unit, a track plate overall dimension detection card unit, a track plate overall dimension graphic unit, a track plate appearance quality unit and all detection item sub-table units except skew;
the two query sub-modules of the foreground processing module are divided into two-level management and three-level management, wherein,
when the finished board type is inquired, a foreground processing module executes three-level management, wherein the three-level management respectively comprises the following steps: the plate type of the finished plate is managed for the first level, the track plate number is managed for the second level, and the measured value of each detection item of the finished plate is managed for the third level;
when the track plate mold is inquired, a foreground processing module executes two-stage management, wherein the two-stage management respectively comprises the following steps: the model of the track slab mold is first-level management, the measured value of each detection item of the finished slab is second-level management, and the measured values of each detection item of the finished slab are arranged as a progressive sequence according to the detection time;
the background management module comprises an information processing sub-module and a database management sub-module connected with the information processing sub-module;
the information processing submodule consists of a login unit, a storage unit, an inquiry unit, a sorting unit, a deletion unit, a checking unit, a quality checking unit and an output unit which are connected with each other,
the login unit is used for logging in the database management system according to the user name and the password;
the warehousing unit is used for warehousing the detection result of the finished board;
the query unit is used for checking the finished plate detection results of each detection date according to two query modes of a finished plate type query mode and a track plate mold query mode and automatically outputting the query results through a detection report;
the sorting unit is used for sorting and inquiring the finished board detection results according to two sorting modes of date and name and displaying the inquiry result;
the deleting unit is used for deleting unqualified finished board detection results;
the checking unit is used for checking the attributes of the finished plate, and the checking unit comprises checking track plate number, finished plate detection time, detection serial number, operators, contact ways, plate type attributes and detection information for manufacturing track plate molds;
the quality checking unit is used for checking whether the deviation of the overall dimension of the finished board exceeds the limit or not and prompting the exceeding information;
the output unit is used for outputting a detection report meeting the requirements;
the database management submodule consists of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, wherein,
the track plate type unit comprises 7 attributes which are respectively an ID attribute, the number of rail bearing platforms, the name and the symmetry of the track plate, the overall dimension value of the track plate, the running track of the robot corresponding to the track plate type and an alignment parameter corresponding to the track plate type unit;
the track slab curve information unit comprises 3 attributes which are respectively an ID attribute, a curve radius and a design offset of a track bearing platform corresponding to the track slab curve information unit;
the track slab mold information unit comprises 3 attributes which are respectively an ID attribute, a track slab mold name and track slab mold information corresponding to the track slab mold information unit;
the automatic detection unit of the finished board comprises 7 attributes, namely a track board number, a line shape, ultrahigh information, bilateral symmetry, detection operation information, a relative relation between rail bearing platforms and a measured value of a frame;
the automatic detection unit of the rail bearing platform comprises 2 attributes which are respectively an ID attribute corresponding to the automatic detection unit of the rail bearing platform and measurement information inside the rail bearing platform;
the track slab type unit, the track slab curve information unit, the track slab mold information unit and the track bearing platform automatic detection unit respectively use one corresponding ID attribute as a unique index, and the finished slab automatic detection unit uses the track slab number as the index;
the track slab type unit is respectively connected with the track slab curve information unit and the mould information unit through the corresponding ID attributes of the track slab type unit;
the track slab curve information unit is connected with the finished slab automatic detection unit through the corresponding ID attribute;
the track plate mould information unit is connected with the finished plate automatic detection unit through the corresponding ID attribute;
the automatic finished plate detection unit is connected with the automatic track bearing platform detection unit through the track plate number attribute; the database management process is as follows:
a1, acquiring the association relationship among 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished slab automatic detection unit and a track bearing platform automatic detection unit, and the association relationship among the corresponding database tables;
a2, acquiring attribute names of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations between the field names of the database tables respectively corresponding to the attribute names;
a3, acquiring attribute values of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations among numerical values of database field values corresponding to the attribute values;
a4, generating MySQL sentences according to the incidence relations among the 5 entity classes, the incidence relations among the database tables corresponding to the 5 entity classes, the attribute names of the 5 entity classes, the attribute values of the 5 entity classes, the corresponding relations among the database table field names corresponding to the 5 entity classes and the numerical value corresponding relations among the database table field values;
and A5, executing the MySQL statement to obtain a management result set, and reflecting the management result set to the database table, thereby realizing database management of the overall dimension of the finished board.
2. A database management method for the overall dimension of a finished board is characterized by comprising the following steps:
s1, acquiring the incidence relation among 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and the incidence relation among the corresponding database tables;
s2, acquiring attribute names of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations between the field names of the database tables respectively corresponding to the attribute names;
s3, acquiring attribute values of 5 entity classes of a track slab type unit, a track slab curve information unit, a track slab mold information unit, a finished product slab automatic detection unit and a track bearing platform automatic detection unit, and corresponding relations between values of database field values corresponding to the attribute values;
s4, generating MySQL sentences according to the incidence relation among the 5 entity classes, the incidence relation among the database tables corresponding to the 5 entity classes, the attribute names of the 5 entity classes, the attribute values of the 5 entity classes, the corresponding relation among the database table field names corresponding to the 5 entity classes and the numerical value corresponding relation of the database table field values;
and S5, executing the MySQL statement to obtain a management result set, and reflecting the management result set to the database table, thereby realizing database management of the overall dimension of the finished board.
3. The database management method for finished board form factor of claim 2, wherein the management result set in step S5 includes a warehousing result set, a query result set, a sorting result set, a deleting result set, a viewing result set, a quality checking result set, and an outputting result set, wherein,
the warehousing result set is obtained by the execution result of the warehousing MySQL statement;
the query result set is obtained by querying an execution result of the MySQL statement;
the sequencing result set is obtained by sequencing the execution result of the MySQL statement;
the deletion result set is obtained by deleting the execution result of the MySQL statement;
the viewing result set is obtained by viewing the execution result of the MySQL statement;
the quality check result set is obtained by the execution result of the quality check MySQL statement;
the output result set is obtained by outputting the execution result of the MySQL statement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910419021.XA CN110134743B (en) | 2019-05-20 | 2019-05-20 | Database management system and method for overall dimension of finished board |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910419021.XA CN110134743B (en) | 2019-05-20 | 2019-05-20 | Database management system and method for overall dimension of finished board |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110134743A CN110134743A (en) | 2019-08-16 |
| CN110134743B true CN110134743B (en) | 2021-03-16 |
Family
ID=67571581
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910419021.XA Active CN110134743B (en) | 2019-05-20 | 2019-05-20 | Database management system and method for overall dimension of finished board |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110134743B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113256707B (en) * | 2021-06-25 | 2021-09-28 | 西南交通大学 | Rail center line extraction method based on rail top surface seed point automatic tracking |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090204317A1 (en) * | 2005-06-08 | 2009-08-13 | Wolfgang Daum | System and method for improved train handling and fuel consumption |
| CN103761401A (en) * | 2014-02-14 | 2014-04-30 | 中铁第一勘察设计院集团有限公司 | Data processing method for integrated slab layout and construction of CRTSIII type ballastless track |
| CN105806219A (en) * | 2016-03-23 | 2016-07-27 | 铁道第三勘察设计院集团有限公司 | Method for detecting external dimension deviation of CRTSIII type track board |
| CN106055820A (en) * | 2016-06-07 | 2016-10-26 | 铁道第三勘察设计院集团有限公司 | CRTS (Slab Ballastless Track) III type track slab machining deviation detection method and informatization method for detection results |
| CN108399283A (en) * | 2018-02-05 | 2018-08-14 | 中铁二十二局集团有限公司 | One kind being based on III type track plates appearance and size quick calculation methods of CRTS |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| BE1010123A3 (en) * | 1996-03-19 | 1998-01-06 | Mastbooms Francois | Roller rink, COMPONENT PARTS THEREOF AND METHOD FOR THE MANUFACTURE OF THESE PARTS. |
| CN102170429A (en) * | 2011-03-23 | 2011-08-31 | 铁道第三勘察设计院集团有限公司 | Ballastless track board storage management method based on wireless mode |
| CN106931885A (en) * | 2017-04-17 | 2017-07-07 | 铁道第三勘察设计院集团有限公司 | The quick, intelligent detecting system of track traffic basic component size and method |
-
2019
- 2019-05-20 CN CN201910419021.XA patent/CN110134743B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090204317A1 (en) * | 2005-06-08 | 2009-08-13 | Wolfgang Daum | System and method for improved train handling and fuel consumption |
| CN103761401A (en) * | 2014-02-14 | 2014-04-30 | 中铁第一勘察设计院集团有限公司 | Data processing method for integrated slab layout and construction of CRTSIII type ballastless track |
| CN105806219A (en) * | 2016-03-23 | 2016-07-27 | 铁道第三勘察设计院集团有限公司 | Method for detecting external dimension deviation of CRTSIII type track board |
| CN106055820A (en) * | 2016-06-07 | 2016-10-26 | 铁道第三勘察设计院集团有限公司 | CRTS (Slab Ballastless Track) III type track slab machining deviation detection method and informatization method for detection results |
| CN108399283A (en) * | 2018-02-05 | 2018-08-14 | 中铁二十二局集团有限公司 | One kind being based on III type track plates appearance and size quick calculation methods of CRTS |
Non-Patent Citations (1)
| Title |
|---|
| 客运专线CRTS型无砟轨道板预制质量控制数字化研究;卢炜;《中国优秀硕士学位论文全文数据库工程科技II辑》;20130415;第C033-4页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110134743A (en) | 2019-08-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105868373B (en) | Method and device for processing key data of power business information system | |
| CN101599146A (en) | A kind of management method of die manufacturing information and system | |
| CN105808538A (en) | Method and device for generating mobile report form | |
| CN109947741B (en) | Method for modeling and storing attribute parameters of items | |
| CN106095837A (en) | It is applicable to data system and the data processing method of industrial and commercial all kinds of business | |
| CN110134743B (en) | Database management system and method for overall dimension of finished board | |
| CN112529131A (en) | Equipment full production cycle management system based on three-dimensional visualization for power plant | |
| CN114880405A (en) | Data lake-based data processing method and system | |
| CN115617776A (en) | Data management system and method | |
| CN112541748A (en) | Engineering project management system based on BIM technology | |
| CN116010612A (en) | River basin flood control knowledge graph construction method and device and electronic equipment | |
| CN107526746A (en) | The method and apparatus of management document index | |
| CN107609151A (en) | The method that XBRL instance documents caching is realized based on Redis | |
| CN107609179A (en) | A kind of data processing method and equipment | |
| CN112181967B (en) | Method, device, computer equipment and medium for monitoring quality of source data | |
| CN103927402A (en) | Control logic diagram modular design management system implementation method | |
| CN116306807A (en) | AI model production method based on meta-universe data mark | |
| CN112784129A (en) | Pump station equipment operation and maintenance data supervision platform | |
| CN104657426B (en) | A kind of method for building up of the ranks blended data storage model based on unified view | |
| CN203520104U (en) | Device for controlling production according to standards | |
| JP2017010376A (en) | Mart-less verification support system and mart-less verification support method | |
| CN111199499A (en) | Student information management system based on Java | |
| CN110909999A (en) | Mining equipment safety special supervision decision-making system | |
| CN112416918B (en) | Data management system and working method thereof | |
| CN113392227B (en) | Metadata knowledge graph engine system oriented to rail transit field |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |