CN111881141A - Connector cable database query management system - Google Patents
Connector cable database query management system Download PDFInfo
- Publication number
- CN111881141A CN111881141A CN202010748381.7A CN202010748381A CN111881141A CN 111881141 A CN111881141 A CN 111881141A CN 202010748381 A CN202010748381 A CN 202010748381A CN 111881141 A CN111881141 A CN 111881141A
- Authority
- CN
- China
- Prior art keywords
- information
- cable
- connector
- database
- connector cable
- 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
- 230000008676 import Effects 0.000 claims abstract description 9
- 239000013589 supplement Substances 0.000 claims abstract description 9
- 230000001502 supplementing effect Effects 0.000 claims abstract description 8
- 239000000463 material Substances 0.000 claims description 4
- 230000000712 assembly Effects 0.000 claims description 3
- 238000000429 assembly Methods 0.000 claims description 3
- 206010063385 Intellectualisation Diseases 0.000 abstract description 4
- 238000010616 electrical installation Methods 0.000 abstract description 3
- 238000004519 manufacturing process Methods 0.000 abstract description 3
- 238000007689 inspection Methods 0.000 abstract description 2
- 238000000034 method Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 239000000047 product Substances 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000009469 supplementation Effects 0.000 description 1
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/2291—User-Defined Types; Storage 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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a connector cable database query management system, and belongs to the technical field of database management systems. The system comprises the following modules: a database; the authority management module is used for judging the authority of a login user by acquiring a login information submission instruction input by a user; the wiring table import module is used for reading related data of the connector cable; the database query module is used for storing data, transmitting the cable information of the relevant connector in the wiring list to the display module and allowing a user to query the cable information of other connectors; the connector cable data supplement module is used for intelligently supplementing connectors, lead cables and tail accessories of which information is not inquired and adding the connectors, the lead cables and the tail accessories into a database; and the display module is used for displaying the interface and the information. The invention has wide application range, can effectively improve the production efficiency and promote the intellectualization of the inspection of the electrical installation drawings.
Description
Technical Field
The invention relates to a connector cable database query management system, and belongs to the technical field of database management systems.
Background
Small and lightweight electronic products such as connector cables are widely used in the fields of aerospace and the like. However, as the diversified demand patterns of the electronic equipment systems are generated, the related information such as the types, model specifications, and node arrangements of the connector cables is increased. Traditional review of electrical installation drawings requires that process personnel inquire information such as connectors, lead cables, tail accessories and the like in a wiring list one by one, and the work efficiency is very low and mistakes are easy to make. Therefore, when information of different types and a large number of connector cables is queried, how to improve the review efficiency and obtain the most accurate connector cable information, realize deep integration of informatization and industrialization, and promote intellectualization of a drawing review process is a problem to be solved urgently.
Disclosure of Invention
The invention aims to solve the technical problems in the prior art and provides a connector cable database query management system which can automatically query and display connector cable information in a wiring table by importing the wiring table. Meanwhile, the intelligent database system is used for supplementing connectors, lead cables and tail accessories which do not inquire information, production efficiency is improved, and intellectualization of a drawing examination process is promoted.
In order to achieve the purpose, the invention adopts the technical scheme that:
a connector cable database query management system comprising a database and, in addition, the following modules:
the authority management module is used for judging the authority of a login user by acquiring a login information submission instruction input by a user;
the wiring table import module is used for reading related data of the connector cable;
the database query module is used for storing data, transmitting the cable information of the relevant connector in the wiring list to the display module and allowing a user to query the cable information of other connectors;
the connector cable data supplement module is used for intelligently supplementing connectors, lead cables and tail accessories of which information is not inquired and adding the connectors, the lead cables and the tail accessories into a database;
and the display module is used for displaying the system interface and the connector cable information.
Further, the authority management module divides the authority of the login user into three levels: first-level administrator authority, second-level internal personnel authority and third-level tourist authority.
Furthermore, the first-level administrator permission allows new connector, lead cable and tail accessory information to be added into the database, and sets the security level of the added information; the second level internal personnel authority allows the secret information to be inquired but does not allow new information to be added; the third-level tourist authority only allows browsing of non-confidential information, does not allow querying of confidential information, and does not allow adding new information.
Further, the administrator and internal personnel passwords are stored in an MD5 encrypted form.
Furthermore, the wiring table is led into the module, the wiring table is in WORD format, the first column of the wiring table is cable number, the second column is line number, and the third column is wire, cable type and specification.
Further, in the database query module, the connector cable information that can be queried includes general information, low frequency connector, terminal arrangement, contact, self-contained tail accessory, wire, multi-core cable, core wire information, radio frequency connector, radio frequency cable, tail accessory, terminal, and semi-finished cable assembly.
Furthermore, the database query module has the functions of autonomous query and system automatic query, wherein the system automatic query can read the model number of the connector cable in the wiring list and display the detailed information of the connector cable of each model number to the interface.
Further, the connector cable data supplement module can manually supplement connectors, lead cables and tail accessories which are not inquired with information by means of an intelligent database system.
Further, the display module displays the connector, the wire, the cable and the tail accessory model which are not inquired in a list on the left side of the window, and when a user clicks the connector, the wire, the cable and the tail accessory model which are not inquired in information, if the model information similar to or the same as the connector, the wire, the cable and the tail accessory model is known, the connector, the wire, the cable and the tail accessory model are modified, and the corresponding type is selected; when a user clicks for inquiry, corresponding information is inquired from the database, if the information is the same as the information, the user clicks an adding button after selecting the information, a piece of information which is the same as the selected item is newly built in the database, the type is the name of the type selected at the left side of the window, and the type of the selected item is deleted at the left side of the window after the adding is successful.
Further, if the user double-clicks the inquired information, an interface of cable information of the newly-built connector is opened, in the interface of the cable information of the newly-built connector, after the material codes and the related information are modified into corresponding information, the addition is clicked, after the addition is successful, a piece of connector cable information is newly built in the database, the information is stored in the current program, and the model of the selected item is deleted on the left side of the window.
Compared with the prior art, the invention has the advantages that:
1. the application range is wide. The system covers the information of electronic products including low-frequency connectors, terminal arrays, contact elements, accessories with tail parts, wires, multi-core cables, core wire information, radio-frequency connectors, radio-frequency cables, tail accessories, terminals and semi-finished cable assemblies, and is suitable for inquiring the information of the cables of the electronic connectors of most wiring meters in principle.
2. The working efficiency is high. By introducing the wiring meter, the connector cable information can be automatically inquired and displayed. Meanwhile, the intelligent database system is used for supplementing the connectors, the lead cables and the tail accessories of which the information is not inquired.
Drawings
Fig. 1 is a flowchart illustrating the operation of the database query system according to an embodiment of the present invention.
Fig. 2 is a flowchart illustrating information supplementation by a database according to an embodiment of the present invention.
Detailed Description
The invention is described in detail below with reference to the figures and specific embodiments.
A connector cable database query management system, comprising: the authority management module is used for judging the authority of a login user by acquiring a login information submission instruction input by a user; the wiring table import module is used for reading related data of the connector cable; the database query module is used for storing data, displaying related connector cable information in the wiring list or providing a user for querying other connector cable information; and the connector cable data supplement module is used for intelligently supplementing the connectors, the lead cables and the tail accessories which are not inquired to obtain information and adding the connector, the lead cables and the tail accessories into the database.
In the authority management module, the authority of the loggers is divided into three levels, wherein the three levels comprise first-level administrator authority, second-level internal personnel authority and third-level tourist authority. The first-level administrator authority can add new connector, lead cable and tail accessory information to the database and set the security level of the added information; the second level internal personnel authority allows the secret information to be inquired but does not allow new information to be added; the third-level tourist authority only allows browsing of non-confidential information, does not allow querying of confidential information, and does not allow adding new information. And the administrator and internal personnel passwords are turned to MD5 encryption.
In the wiring table import module, the wiring table is required to be in WORD format, the first column is cable number, the second column is line number, and the third column is wire, cable model and specification. The system reads the relevant data and displays the data to the interface. And clicking an import button to open a document selection interface to select and determine the wiring table file. The software will read the relevant data and display it to the interface.
In the database query module, the inquireable information includes the general information, the low frequency connector, the terminal arrangement, the contact, the self-contained tail accessory, the lead, the multi-core cable, the core wire information, the radio frequency connector, the radio frequency cable, the tail accessory, the terminal, the semi-finished cable assembly and other connector cable information. The user may select an autonomous query or a system automatic query. If the system automatic query is selected, the system reads the connector cable model in the connection list and displays the detailed information of the connector cable of each model to the interface.
In the connector cable data supplement module, connectors, lead cables and tail accessories which are not inquired with information can be supplemented by means of an intelligent database system. And the left list of the system displays the models of the connectors, the wires, the cables and the tail accessories which are not inquired, clicks the models of the connectors, the wires, the cables and the tail accessories which are not inquired, modifies the models if the model information similar or identical to the models is known, selects the corresponding type of the models, and clicks the inquiry to inquire the corresponding information from the database. If the same information exists, clicking an adding button after the information is selected, newly building an information which is the same as the selected item in the database, wherein the model is the model name selected on the left side. The left side will delete the model number of the selected entry after the addition is successful.
If the model similar to the selected item model is known, the model can be changed into the corresponding model and inquired, the inquired information can be double-clicked after the inquiry is finished, and an interface of cable information of the newly-built connector is opened. In the newly-built connector cable information interface, after modifying material codes and related information into corresponding information, clicking and adding, after the adding is successful, newly building connector cable information in a database, storing the information into a current program, and deleting the selected item model on the left side of the system.
The following is a more specific example:
referring to fig. 1, the connector cable database query management system provided by the present invention mainly includes: the authority management module is used for judging the authority of a login user by acquiring a login information submission instruction input by a user; the wiring table import module is used for reading related data of the connector cable; the database query module is used for storing data, displaying related connector cable information in the wiring list or providing a user for querying other connector cable information; and the connector cable data supplement module is used for intelligently supplementing the connectors, the lead cables and the tail accessories which are not inquired to obtain information and adding the connector, the lead cables and the tail accessories into the database.
The user firstly logs in the connector cable database query management system provided by the invention through a login interface, and the system can judge the authority of a login user through a user name and a password input by the user. The authority of the loggers is divided into three levels, wherein the authority of the loggers comprises a first-level manager authority, a second-level internal personnel authority and a third-level tourist authority. The first-level administrator authority can add new connector, lead cable and tail accessory information to the database and set the security level of the added information; the second level internal personnel authority allows the secret information to be inquired but does not allow new information to be added; the third-level tourist authority only allows browsing of non-confidential information, does not allow querying of confidential information, and does not allow adding new information. And the administrator and internal personnel passwords are turned to MD5 encryption.
After the user logs in, clicking an 'import' button, opening a document selection interface to select a wiring table file, and determining. The wiring table is required to be in WORD format, the first column is cable number, the second column is line number, and the third column is wire, cable model and specification. The system reads the relevant data and displays the data to the interface. And clicking an import button to open a document selection interface to select and determine the wiring table file. The software will read the relevant data and display it to the interface.
Clicking 'database query', wherein the queried information comprises connector cable information such as general information, low-frequency connectors, terminal arrangement, contact elements, self-contained tail accessories, wires, multi-core cables, core wire information, radio-frequency connectors, radio-frequency cables, tail accessories, terminals, semi-finished cable assemblies and the like.
The user may select an autonomous query or a system automatic query. If the system automatic query is selected, the system reads the connector cable model in the connection list and displays the detailed information of the connector cable of each model to the interface.
When a certain connector model is found not to be inquired, the system can display the connector model of which the information is not inquired on the left list, click the connector model of which the information is not inquired, modify the connector model of which the information is not inquired if the similar or the same model information is known, select the corresponding type of the connector model, and click the inquiry to inquire the corresponding information in the database. If the same information exists, clicking an adding button after the information is selected, newly building an information which is the same as the selected item in the database, wherein the model is the model name selected on the left side. The left side will delete the model number of the selected entry after the addition is successful.
If the model similar to the selected item model is known, the model can be changed into the corresponding model and inquired, and the inquired information can be double-clicked after the inquiry is finished, so that the interface of the newly-built connector is opened. In the newly-built connector interface, after modifying the material codes and the related information into the corresponding connector information, clicking and adding, after the adding is successful, newly building connector cable information in the database, storing the information into the current program, and deleting the selected item model on the left side of the system.
In a word, the invention has wide application range, can effectively improve the production efficiency and promote the intellectualization of the inspection of the electrical installation drawings.
The above description is only an embodiment of the present invention, but the present invention is not limited to the embodiment. Those skilled in the art can make various equivalent modifications or substitutions without departing from the spirit and principle of the invention, and the equivalents or substitutions are included in the scope defined by the claims of the present application.
Claims (10)
1. A connector cable database query management system comprises a database and is characterized by further comprising the following modules:
the authority management module is used for judging the authority of a login user by acquiring a login information submission instruction input by a user;
the wiring table import module is used for reading related data of the connector cable;
the database query module is used for storing data, transmitting the cable information of the relevant connector in the wiring list to the display module and allowing a user to query the cable information of other connectors;
the connector cable data supplement module is used for intelligently supplementing connectors, lead cables and tail accessories of which information is not inquired and adding the connectors, the lead cables and the tail accessories into a database;
and the display module is used for displaying the system interface and the connector cable information.
2. The connector cable database query management system as claimed in claim 1, wherein said authority management module divides the login authority into three levels: first-level administrator authority, second-level internal personnel authority and third-level tourist authority.
3. The inquiry management system of connector cable database as claimed in claim 2, wherein the first level administrator authority allows adding new connector, wire cable and tail accessory information to the database, and setting security level for the added information; the second level internal personnel authority allows the secret information to be inquired but does not allow new information to be added; the third-level tourist authority only allows browsing of non-confidential information, does not allow querying of confidential information, and does not allow adding new information.
4. The connector cable database query management system as claimed in claim 2, wherein the administrator and internal personnel passwords are stored in an MD5 encrypted form.
5. The connector cable database query management system as claimed in claim 1, wherein the connection table is imported into the module, the connection table is in WORD format, the first column of the connection table is cable number, the second column is line number, and the third column is wire, cable type and specification.
6. The database query management system for connector cable according to claim 1, wherein the database query module is configured to query connector cable information including general information, low frequency connectors, terminal arrangements, contacts, self-contained tail attachments, wires, multi-core cables, core wire information, rf connectors, rf cables, tail attachments, terminals, and semi-finished cable assemblies.
7. The database query management system for connector cables as claimed in claim 6, wherein the database query module has an autonomous query function and an automatic system query function, wherein the automatic system query function reads the connector cable models in the connection list and displays detailed information of each connector cable model to the interface.
8. The connector cable database query management system as claimed in claim 1, wherein the connector cable data supplement module is capable of manually supplementing connectors, lead cables and tail accessories which are not queried for information by means of an intelligent database system.
9. The query management system for the connector cable database according to claim 8, wherein the display module lists connector, wire, cable and tail accessory models which are not queried for information on the left side of the window, and when a user clicks the connector, wire, cable and tail accessory models which are not queried for information, if model information similar to or the same as the model information is known, the connector, wire, cable and tail accessory models are modified and the corresponding type is selected; when a user clicks for inquiry, corresponding information is inquired from the database, if the information is the same as the information, the user clicks an adding button after selecting the information, a piece of information which is the same as the selected item is newly built in the database, the type is the name of the type selected at the left side of the window, and the type of the selected item is deleted at the left side of the window after the adding is successful.
10. The system of claim 9, wherein if the user double-clicks the query message, the interface of the new connector cable message is opened, the material code and related information are modified into corresponding information in the new connector cable message interface, the adding is clicked, after the adding is successful, a new connector cable message is created in the database, the message is saved in the current program, and the type of the selected entry is deleted on the left side of the window.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010748381.7A CN111881141A (en) | 2020-07-30 | 2020-07-30 | Connector cable database query management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010748381.7A CN111881141A (en) | 2020-07-30 | 2020-07-30 | Connector cable database query management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111881141A true CN111881141A (en) | 2020-11-03 |
Family
ID=73201186
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010748381.7A Pending CN111881141A (en) | 2020-07-30 | 2020-07-30 | Connector cable database query management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111881141A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115240329A (en) * | 2021-04-22 | 2022-10-25 | 航天科工惯性技术有限公司 | Intelligent storage management system for tooling cables and management method using intelligent storage management system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701300A (en) * | 2016-01-14 | 2016-06-22 | 北京空间飞行器总体设计部 | Spacecraft electrical information query system |
| KR102008827B1 (en) * | 2019-03-11 | 2019-10-21 | 김형섭 | System and method for providing cable data management service, recording medium for performing the method |
-
2020
- 2020-07-30 CN CN202010748381.7A patent/CN111881141A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701300A (en) * | 2016-01-14 | 2016-06-22 | 北京空间飞行器总体设计部 | Spacecraft electrical information query system |
| KR102008827B1 (en) * | 2019-03-11 | 2019-10-21 | 김형섭 | System and method for providing cable data management service, recording medium for performing the method |
Non-Patent Citations (2)
| Title |
|---|
| 杨锋;尚维琦;吴齐才;: "电缆网标准化设计系统的建设与应用", 网信军民融合, no. 07, 25 July 2018 (2018-07-25) * |
| 黄皓;陈策;: "基于Labsql数据库工具的电缆连接关系映射及拓扑实现", 自动化与仪器仪表, no. 03, 25 March 2015 (2015-03-25), pages 178 - 180 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115240329A (en) * | 2021-04-22 | 2022-10-25 | 航天科工惯性技术有限公司 | Intelligent storage management system for tooling cables and management method using intelligent storage management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20140279625A1 (en) | Social Network Based Skill Rating and Performance Feedback System | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| US20200057550A1 (en) | Method and apparatus for generating customized visualization component | |
| CN109634805A (en) | Monitoring data processing method, device, electronic equipment and storage medium | |
| CN109063381B (en) | Automobile wire harness process design method and system based on CAD platform | |
| CN111124917B (en) | Method, device, equipment and storage medium for managing and controlling public test cases | |
| US11089107B1 (en) | Management of connected sensor devices | |
| CN103678803A (en) | Integrated design method and system of electrical fitting engineering drawing | |
| CN111984239A (en) | Page configuration method, device, server and storage medium | |
| CN112433941A (en) | Test analysis method, device, equipment and storage medium | |
| CN111881141A (en) | Connector cable database query management system | |
| CN102906768A (en) | System and method for providing an enhanced facility plan | |
| CN103514303A (en) | Method and system for recognizing electrical element wiring diagram | |
| CN110780960A (en) | Webpage making method and system, readable storage medium and server | |
| CN110968367A (en) | E-commerce commodity field configuration method, device, server and storage medium | |
| KR100487100B1 (en) | Method for manufacturing of wire harness | |
| CN109213782A (en) | Configuration, display methods, device and the communication equipment of search interface | |
| CN111353671B (en) | Supply chain management method, device and system | |
| CN102281260A (en) | Generating method and server of monitoring rule | |
| CN116126314A (en) | Business process configuration method and device, electronic equipment and storage medium | |
| CN108549676B (en) | Display method and device of power data, computer equipment and storage medium | |
| CN112612817B (en) | Data processing method, device, terminal equipment and computer readable storage medium | |
| CN112232762A (en) | Automatic checking system for wiring meter | |
| CN1577317A (en) | Schematic diagram component symbol examining apparatus and obtaining method | |
| CN115827452B (en) | Data processing type test system, method, storage medium and equipment |
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 |