CN107943900A - The method and device of a kind of data management - Google Patents
The method and device of a kind of data management Download PDFInfo
- Publication number
- CN107943900A CN107943900A CN201711144773.7A CN201711144773A CN107943900A CN 107943900 A CN107943900 A CN 107943900A CN 201711144773 A CN201711144773 A CN 201711144773A CN 107943900 A CN107943900 A CN 107943900A
- Authority
- CN
- China
- Prior art keywords
- mysql database
- key message
- cis
- server
- pcb
- 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.)
- Granted
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses the method and device of a kind of data management, and MySQL database is built according to the key message of CIS；The key message of the CIS is configured in the MySQL database and home server；The key message of the CIS is configured in home server；Utilize the powerful data managing capacity of MySQL database, schematic library and PCB storehouses to cadence carry out unified management, the cloud platform management to cadence encapsulation storehouse can be realized using this technology so that engineer can realize at any PC ends calls and manage cadence encapsulation storehouse.
Description
Technical field
The management of application, cadence databases the present embodiments relate to MySQL database, cadence encapsulate storehouse
The technical field built and safeguarded, more particularly to the method and device of a kind of data management.
Background technology
At present, cadence softwares are very universal in the use of electronics industry, wherein principle diagram design instrument OrCAD
Capture because it is upper it is quick-moving, be easily modified, friendly interface the features such as so that it becomes most popular principle diagram design at present
One of instrument.Cadence softwares provide Allegro components because its it is convenient and efficient, workable the features such as, become
The mark post software of PCB design industry.The schematic diagram encapsulation and PCB encapsulation that two establishment of component come out can be used cooperatively, still
It can not solve the management function in encapsulation storehouse.
The content of the invention
The purpose of the embodiment of the present invention is the method and device for proposing a kind of data management, it is intended to which how solution utilizes
MySQL database solves the problem of management in cadence encapsulation storehouse, and then solves enterprise's docking OA platforms, realizes that high in the clouds management is public
Take charge of the function of Component library.
For this purpose, the embodiment of the present invention uses following technical scheme：
In a first aspect, a kind of method of data management, the described method includes：
MySQL database is built according to the key message of CIS, the key message includes：Item number, type of device, device
The schematic diagram encapsulation of value, device PCB encapsulation and/or device；
The key message of the CIS is configured in the MySQL database and home server；
The key message of the CIS is configured in home server.
Alternatively, the item number is：In the stock number of MySQL database, for unique mark device；
The type of device is：Group in default major class；
The device value is：Capacitance, resistance value and/or device model；
The device PCB is encapsulated as：The PCB encapsulation name of device to be produced is identical.
Alternatively, the type of device includes：FPGA, CPU and/or microcontroller under IC.
Alternatively, the key message that the CIS is configured in the MySQL database, including：
Odbc data source is triggered, selects DNS and MySQL ODBC 5.3ANSI Driver, then the title in input data source,
Username and password is inputted, determines the MySQL database after structure.
Alternatively, the key message that the CIS is configured in the MySQL database, including：
If IP address and server operator that the MySQL database in server end, inputs server carry
The username and password of confession.
Second aspect, a kind of device of data management, described device include：
Module is built, for building MySQL database according to the key message of CIS, the key message includes：Item number,
Type of device, device value, device PCB encapsulation and/or the schematic diagram encapsulation of device；
First configuration module, for configuring the key message of the CIS in the MySQL database and home server；
Second configuration module, for configuring the key message of the CIS in home server.
Alternatively, the item number is：In the stock number of MySQL database, for unique mark device；
The type of device is：Group in default major class；
The device value is：Capacitance, resistance value and/or device model；
The device PCB is encapsulated as：The PCB encapsulation name of device to be produced is identical.
Alternatively, the type of device includes：FPGA, CPU and/or microcontroller under IC.
Alternatively, first configuration module, is specifically used for：
Odbc data source is triggered, selects DNS and MySQL ODBC 5.3ANSI Driver, then the title in input data source,
Username and password is inputted, determines the MySQL database after structure.
Alternatively, first configuration module, is specifically used for：
If IP address and server operator that the MySQL database in server end, inputs server carry
The username and password of confession.
The embodiment of the present invention has the beneficial effect that：A, the present invention can solve to help user preferably to arrange and manage member
Device encapsulates storehouse；B, other user of company level can also add stock number, the component of some necessary information such as companies
Brief introduction, the parameter of component, component number management, points for attention etc..Such a series of information forms one
The information of device or a kind of device, waits these information when calling again very clear will show, to circuit
Optimization and the selection of device have good help；C, if company's Yield comparison is big, whole device can also be managed
Outbound warehousing quantity, greatly simplifie workflow, only need to do a upper computer software real-time management and update the data storehouse
The stock of middle component, quantity in stock is known that in design, and well in advance buying prepares；D, the present invention due to the use of be
MySQL database, therefore pair of database can be preferably realized with the storage platform of existing cloud platform and other networkings
Connect, database is managed so as to fulfill high in the clouds.
Brief description of the drawings
Fig. 1 is a kind of flow diagram of the method for data management provided in an embodiment of the present invention；
Fig. 2 is a kind of high-level schematic functional block diagram of the device of data management provided in an embodiment of the present invention.
Embodiment
The embodiment of the present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this
Locate described specific embodiment to be used only for explaining the embodiment of the present invention, rather than the restriction to the embodiment of the present invention.In addition also
It should be noted that for the ease of describing, part relevant with the embodiment of the present invention rather than entire infrastructure are illustrate only in attached drawing.
With reference to figure 1, Fig. 1 is a kind of flow diagram of the method for data management provided in an embodiment of the present invention.Such as Fig. 1 institutes
Show, the method for the data management includes：
Step 110, built according to the key message of call information system (Call Information System, CIS)
MySQL (Relational DBMS) database, the key message include：Item number, type of device, device value, device
Printed circuit board (Printed Circuit Board, PCB) encapsulates and/or the encapsulation of the schematic diagram of device；
Wherein, the item number is：In the stock number of MySQL database, for unique mark device；The type of device
For：Group in default major class；The device value is：Capacitance, resistance value and/or device model；The device PCB is encapsulated as：Treat
The PCB encapsulation name of making devices is identical.Wherein, the type of device includes：Field programmable gate array (Field- under IC
Programmable Gate Array, FPGA), central processing unit (Central Processing Unit, CPU) and/or single
Piece machine.
Step 120, the key message of the CIS is configured in the MySQL database and home server；
Alternatively, the key message that the CIS is configured in the MySQL database, including：
Open CNC (Open Database Connectivity, ODBC) data source is triggered, selects domain name system
Unite (Domain Name System, DNS) and MySQL ODBC 5.3ANSI Driver, then the title in input data source, input
Username and password, determines the MySQL database after structure.
Alternatively, the key message that the CIS is configured in the MySQL database, including：
If IP address and server operator that the MySQL database in server end, inputs server carry
The username and password of confession.
Step 130, the key message of the CIS is configured in home server.
The embodiment of the present invention has the beneficial effect that：A, the present invention can solve to help user preferably to arrange and manage member
Device encapsulates storehouse；B, other user of company level can also add stock number, the component of some necessary information such as companies
Brief introduction, the parameter of component, component number management, points for attention etc..Such a series of information forms one
The information of device or a kind of device, waits these information when calling again very clear will show, to circuit
Optimization and the selection of device have good help；C, if company's Yield comparison is big, whole device can also be managed
Outbound warehousing quantity, greatly simplifie workflow, only need to do a upper computer software real-time management and update the data storehouse
The stock of middle component, quantity in stock is known that in design, and well in advance buying prepares；D, the present invention due to the use of be
MySQL database, therefore pair of database can be preferably realized with the storage platform of existing cloud platform and other networkings
Connect, database is managed so as to fulfill high in the clouds.
With reference to figure 2, Fig. 2 is a kind of high-level schematic functional block diagram of the device of data management provided in an embodiment of the present invention.Such as
Shown in Fig. 2, described device includes：
Module 210 is built, for building MySQL database according to the key message of CIS, the key message includes：Material
Number, type of device, device value, device PCB encapsulation and/or device schematic diagram encapsulation；
Wherein, the item number is：In the stock number of MySQL database, for unique mark device；
The type of device is：Group in default major class；
The device value is：Capacitance, resistance value and/or device model；
The device PCB is encapsulated as：The PCB encapsulation name of device to be produced is identical.
Alternatively, the type of device includes：FPGA, CPU and/or microcontroller under IC.
First configuration module 220, for configuring the crucial letter of the CIS in the MySQL database and home server
Breath；
Alternatively, first configuration module 220, is specifically used for：
Odbc data source is triggered, selects DNS and MySQL ODBC 5.3ANSI Driver, then the title in input data source,
Username and password is inputted, determines the MySQL database after structure.
Alternatively, first configuration module 220, is specifically used for：
If IP address and server operator that the MySQL database in server end, inputs server carry
The username and password of confession.
Second configuration module 230, for configuring the key message of the CIS in home server.
Above in association with the technical principle of specific embodiment the invention has been described embodiment.These descriptions are intended merely to explain this
The principle of inventive embodiments, and the limitation to protection domain of the embodiment of the present invention cannot be construed in any way.Based on herein
Explanation, those skilled in the art, which would not require any inventive effort, can associate the other specific of the embodiment of the present invention
Embodiment, these modes are fallen within the protection domain of the embodiment of the present invention.
Claims (10)
- A kind of 1. method of data management, it is characterised in that the described method includes：MySQL database is built according to the key message of CIS, the key message includes：Item number, type of device, device value, device Part PCB is encapsulated and/or the encapsulation of the schematic diagram of device；The key message of the CIS is configured in the MySQL database and home server；The key message of the CIS is configured in home server.
- 2. according to the method described in claim 1, it is characterized in that, the item number is：In the stock number of MySQL database, For unique mark device；The type of device is：Group in default major class；The device value is：Capacitance, resistance value and/or device model；The device PCB is encapsulated as：The PCB encapsulation name of device to be produced is identical.
- 3. according to the method described in claim 1, it is characterized in that, the type of device includes：FPGA, CPU under IC and/or Microcontroller.
- 4. according to the method described in claims 1 to 3 any one, it is characterised in that described to be configured in the MySQL database The key message of the CIS, including：Odbc data source is triggered, selects 5.3 ANSI Driver of DNS and MySQL ODBC, then the title in input data source, it is defeated Access customer name and password, determine the MySQL database after structure.
- 5. according to the method described in claims 1 to 3 any one, it is characterised in that described to be configured in the MySQL database The key message of the CIS, including：If the MySQL database in server end, input server IP address and server operator provide Username and password.
- 6. a kind of device of data management, it is characterised in that described device includes：Module is built, for building MySQL database according to the key message of CIS, the key message includes：Item number, device Type, device value, device PCB encapsulation and/or the schematic diagram encapsulation of device；First configuration module, for configuring the key message of the CIS in the MySQL database and home server；Second configuration module, for configuring the key message of the CIS in home server.
- 7. device according to claim 6, it is characterised in that the item number is：In the stock number of MySQL database, For unique mark device；The type of device is：Group in default major class；The device value is：Capacitance, resistance value and/or device model；The device PCB is encapsulated as：The PCB encapsulation name of device to be produced is identical.
- 8. device according to claim 6, it is characterised in that the type of device includes：FPGA, CPU under IC and/or Microcontroller.
- 9. according to the device described in claim 6 to 8 any one, it is characterised in that first configuration module is specific to use In：Odbc data source is triggered, selects DNS and MySQL ODBC 5.3ANSI Driver, then the title in input data source, input Username and password, determines the MySQL database after structure.
- 10. according to the device described in claim 6 to 8 any one, it is characterised in that first configuration module is specific to use In：If the MySQL database in server end, input server IP address and server operator provide Username and password.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711144773.7A CN107943900B (en) | 2017-11-17 | 2017-11-17 | Data management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711144773.7A CN107943900B (en) | 2017-11-17 | 2017-11-17 | Data management method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107943900A true CN107943900A (en) | 2018-04-20 |
| CN107943900B CN107943900B (en) | 2020-06-09 |
Family
ID=61932828
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711144773.7A Active CN107943900B (en) | 2017-11-17 | 2017-11-17 | Data management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107943900B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111507056A (en) * | 2020-04-17 | 2020-08-07 | 成都寰蓉光电科技有限公司 | PCB design method and system for realizing component management and sharing |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105610911A (en) * | 2015-12-18 | 2016-05-25 | 东北大学 | Wind power mobile monitoring system and method based on private cloud |
| CN106487560A (en) * | 2015-08-31 | 2017-03-08 | 北京国双科技有限公司 | A kind of acquisition method of server configuration information, apparatus and system |
| US20170132378A1 (en) * | 2015-07-29 | 2017-05-11 | Siemens Healthcare Gmbh | Devices, methods and computer readable mediums for flexible delivery and deployment of medical applications |
| CN107230032A (en) * | 2017-06-04 | 2017-10-03 | 翁毅 | A kind of electronic device manages big data analysis system |
-
2017
- 2017-11-17 CN CN201711144773.7A patent/CN107943900B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170132378A1 (en) * | 2015-07-29 | 2017-05-11 | Siemens Healthcare Gmbh | Devices, methods and computer readable mediums for flexible delivery and deployment of medical applications |
| CN106487560A (en) * | 2015-08-31 | 2017-03-08 | 北京国双科技有限公司 | A kind of acquisition method of server configuration information, apparatus and system |
| CN105610911A (en) * | 2015-12-18 | 2016-05-25 | 东北大学 | Wind power mobile monitoring system and method based on private cloud |
| CN107230032A (en) * | 2017-06-04 | 2017-10-03 | 翁毅 | A kind of electronic device manages big data analysis system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111507056A (en) * | 2020-04-17 | 2020-08-07 | 成都寰蓉光电科技有限公司 | PCB design method and system for realizing component management and sharing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107943900B (en) | 2020-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11461330B2 (en) | Managed query service | |
| US9652214B1 (en) | Pluggable extension of software applications | |
| CN110443010A (en) | One kind permission visual configuration control method, device, terminal and storage medium in information system | |
| TW202016761A (en) | Data processing method, device and equipment | |
| CN110457891A (en) | A kind of authority configuration interface display method, device, terminal and storage medium | |
| CN107122365A (en) | The access method and device of heterogeneous database | |
| CN109933571A (en) | Database design documentation generation method, device and computer readable storage medium | |
| US10740286B1 (en) | Migration task validation before data migration | |
| WO2021139565A1 (en) | Data processing method and device, and system | |
| CN108345691B (en) | Data source general processing framework construction method, data source processing method and device | |
| CN103150154A (en) | Implementation method and device of application plug-in | |
| CN108009296A (en) | A kind of SQL query method, system and relevant apparatus based on Hbase | |
| CN110706125A (en) | Water conservancy big data analysis information service system and platform service system | |
| CN107943900A (en) | The method and device of a kind of data management | |
| CN104598622A (en) | Method and system for implementing data modification log as well as application server | |
| US20140122159A1 (en) | License Meta-Model for Automatic License Reasoning | |
| CN102034170B (en) | Service encapsulates method and the integrated system of the business datum based on SOA | |
| CN109144980A (en) | Metadata management method, device and electronic equipment | |
| CN113705143B (en) | Automatic simulation system and automatic simulation method | |
| US11294901B1 (en) | Isolating the performance of functions included in queries | |
| CN116992092A (en) | Method and device for establishing flow model, storage medium and terminal equipment | |
| CN110874365A (en) | Information query method and related equipment thereof | |
| CN116339715A (en) | Front-end page construction method and device, electronic equipment and storage medium | |
| CN108287728A (en) | Document processing method, document processing device, document processing and terminal device | |
| CN100386756C (en) | Schematic diagram component symbol examining apparatus and obtaining method |
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 |