CN112328680A - Electronic component data processing method, data interface and management system - Google Patents
Electronic component data processing method, data interface and management system Download PDFInfo
- Publication number
- CN112328680A CN112328680A CN202011206431.5A CN202011206431A CN112328680A CN 112328680 A CN112328680 A CN 112328680A CN 202011206431 A CN202011206431 A CN 202011206431A CN 112328680 A CN112328680 A CN 112328680A
- Authority
- CN
- China
- Prior art keywords
- electronic component
- data
- user
- teamcenter
- ecad
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 18
- 238000013461 design Methods 0.000 claims description 19
- 238000012545 processing Methods 0.000 claims description 13
- 230000001360 synchronised effect Effects 0.000 claims description 9
- 238000000034 method Methods 0.000 claims description 7
- 230000004048 modification Effects 0.000 claims description 4
- 238000012986 modification Methods 0.000 claims description 4
- 238000011161 development Methods 0.000 claims description 3
- 238000007726 management method Methods 0.000 abstract description 54
- 238000012827 research and development Methods 0.000 abstract description 12
- 238000013523 data management Methods 0.000 abstract description 5
- 238000010606 normalization Methods 0.000 abstract description 3
- 238000012550 audit Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000010354 integration Effects 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000012384 transportation and delivery Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 238000004904 shortening Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 238000012795 verification Methods 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/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
-
- 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
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)
Abstract
The invention provides a processing method of electronic component data, a data interface and a management system, wherein the processing method comprises the following steps: receiving a data synchronization signal sent by a Teamcenter system; responding to the data synchronization signal, and synchronizing the attribute information corresponding to the target electronic component from the Teamcenter system to an SQL Server database pre-deployed by the Cadence system through an SQL drive; and synchronizing the technical file to a shared file warehouse pre-deployed by the Cadence system through Webservice, wherein the SQL Server database and the shared file warehouse are connected with the ECAD user side through ODBC data. The data interface is in data connection with the terminal system and the Cadence system, and data synchronization is carried out, so that the Cadence system has a uniform and unique data source, data management of electronic components is facilitated, the accuracy and the normalization of data of the electronic components are ensured, the repeated labor of designers is avoided, and the research and development efficiency is improved.
Description
Technical Field
The invention relates to the technical field of data management, in particular to a processing method of electronic component data, a data interface and a management system.
Background
Electronic circuit design in an Electronic Design Automation (EDA) research and development enterprise is performed by multiple persons in parallel, and numerous research and development personnel need to perform component type selection based on a set of shared and unified component library, wherein components in the component library record information such as Material codes, Manufacturer Part Numbers (MPN) and manufacturers in a Product Lifecycle Management (PLM) system, and output the information to a Bill of materials (BOM) to satisfy the requirement of a purchasing department for rapidly outputting a purchasing list. However, since each Computer Aided Electronic Design (ECAD) engineer has its own component library, the current scheme for enterprise data unification is as follows: the sharing of the component library based on the ECAD software requires ECAD engineers to manually share the component library, the problems of component repetition and one object with multiple codes are likely to occur among the engineers, so that a BOM list output by the ECAD has the problem of irregular list information, and purchasers need to confirm information of material codes, suppliers and the like of the components one by one, thereby reducing the research and development design efficiency and prolonging the research and development period of products.
Disclosure of Invention
The technical purpose to be achieved by the embodiment of the invention is to provide a processing method, a data interface and a management system of electronic component data, which are used for solving the problems that electronic components are repeated and one object has multiple codes because electronic component libraries of designers are not uniform when electronic design automation research and development enterprises design circuits of multiple persons at present.
In order to solve the above technical problem, an embodiment of the present invention provides a method for processing data of an electronic component, including:
receiving a data synchronization signal sent by a Teamcenter system;
responding to the data synchronization signal, synchronizing the attribute information corresponding to the target electronic component carried in the data synchronization signal from an electronic component library in the Teamcenter system to an SQL Server database pre-deployed by the Cadence system through an SQL Driver, and establishing a corresponding relation between the attribute information;
and synchronizing the technical file corresponding to the target electronic component from the electronic component library to a shared file warehouse pre-deployed by the Cadence system through Webservice, wherein the SQL Server database and the shared file warehouse are in data connection with the computer-aided electronic design ECAD user side through a development database interconnection interface ODBC.
Specifically, according to the processing method described above, the target electronic component is a classified electronic component selected by the first preset management user in the classification library of the teamecenter system.
Preferably, in the processing method described above, the classified electronic component is an electronic component obtained by the second preset management user performing, in the terminal system, audit, classification, attribute assignment, and release on an initial electronic component newly created or modified by the first preset user.
Specifically, in the processing method described above, the attribute information includes: at least one of material code, manufacturer part number.
Another preferred embodiment of the present invention also provides a data interface, including:
the first processing module is used for receiving a data synchronization signal sent by a Teamcenter system;
the second processing module is used for responding to the data synchronization signal, synchronizing the attribute information corresponding to the target electronic component carried in the data synchronization signal from the electronic component library in the Teamcenter system to an SQL Server database pre-deployed by the Cadence system through SQL drive, and establishing the corresponding relation between the attribute information;
and the third processing module is used for synchronizing the technical file corresponding to the target electronic component from the electronic component library to a shared file warehouse pre-deployed by the Cadence system through the Webservice, wherein the SQL Server database and the shared file warehouse are in data connection with the ECAD user side through ODBC.
Still another preferred embodiment of the present invention further provides a management system for electronic components, including: the terminal system, the Cadence system, the ECAD user terminal and the data interface;
wherein, Cadence system includes: the system comprises a pre-deployed SQL Server database and a shared file warehouse, wherein a data interface is connected with a terminal system and the SQL Server database through SQL driving data, and is used for synchronizing the attribute information of a target electronic component and establishing an attribute information corresponding relation; the data interface is connected with the Teamcenter system and the shared file warehouse through Webservice data, and technical files corresponding to the target electronic component are synchronized;
and at least one ECAD user terminal is respectively connected with the SQL Server database and the shared file warehouse data through ODBC.
Preferably, as the management system described above, the Teamcenter system includes:
and the first synchronization module is used for selecting the classified electronic component from the classification library of the Teamcenter system as a target electronic component according to a first instruction of a first preset management user and sending a data synchronization signal to the data interface.
Specifically, as the management system described above, the Teamcenter system further includes:
the electronic component creating module is used for obtaining an initial electronic component through new creation or modification in the Teamcenter system according to a second instruction of a first preset user;
the auditing module is used for auditing the initial electronic component according to a third instruction of a second preset management user and obtaining an auditing result;
the classification module is used for classifying the checked initial electronic components according to a fourth instruction of a second preset management user and storing the initial electronic components into a classification library;
and the attribute giving module is used for giving and issuing attributes to the classified initial electronic components according to a fifth instruction of a second preset management user to obtain the classified electronic components.
Preferably, as the above-mentioned management system, the ECAD user side includes:
and the second synchronization module is used for connecting the ODBC with the SQL Server database and the shared file warehouse data when detecting that the ECAD client is started, and converting the attribute information in the SQL Server database into readable attribute information of the ECAD client.
Further, as described above, the ECAD user side further includes:
and the third synchronization module is used for acquiring the technical file corresponding to the electronic component from the shared file warehouse according to a sixth instruction of a second preset user.
Compared with the prior art, the processing method, the data interface and the management system for the electronic component data provided by the embodiment of the invention at least have the following beneficial effects:
the invention is in data connection with the Teamcenter system and the Cadence system through the data interface, synchronizes the attribute information of the target electronic component in the Teamcenter system to the SQL Server database of the Cadence system through the SQL drive, synchronizes the technical file of the target electronic component in the Teamcenter system to the Cadence system through the Webserver, realizes the data synchronization of the electronic component between the TEAmcenter system and the Cadence system, ensures that the Cadence system has a uniform and unique data source after the data synchronization, is convenient for the data management of the electronic component, ensures the accuracy and the normativity of the data of the electronic component, meets the requirement of a designer on the rapid selection of the electronic component, avoids the problems of the duplication of the electronic component, the multi-code of a product and the repeated labor of the designer, and improves the research and development efficiency. In addition, each designer adopts the same data source during design, so that the business integration of the design end and the purchasing end can be rapidly communicated, the requirement of a purchasing department for rapidly outputting a purchasing list is met, and the production delivery cycle of the product is shortened.
Drawings
Fig. 1 is a schematic flow chart of a method for processing electronic component data according to the present invention;
FIG. 2 is a schematic structural diagram of a data interface according to the present invention;
fig. 3 is a schematic structural diagram of the management system of the present invention.
Detailed Description
In order to make the technical problems, technical solutions and advantages of the present invention more apparent, the following detailed description is given with reference to the accompanying drawings and specific embodiments. In the following description, specific details such as specific configurations and components are provided only to help the full understanding of the embodiments of the present invention. Thus, it will be apparent to those skilled in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the invention. In addition, descriptions of well-known functions and constructions are omitted for clarity and conciseness.
It should be appreciated that reference throughout this specification to "one embodiment" or "an embodiment" means that a particular feature, structure or characteristic described in connection with the embodiment is included in at least one embodiment of the present invention. Thus, the appearances of the phrases "in one embodiment" or "in an embodiment" in various places throughout this specification are not necessarily all referring to the same embodiment. Furthermore, the particular features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
In various embodiments of the present invention, it should be understood that the sequence numbers of the following processes do not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.
It should be understood that the term "and/or" herein is merely one type of association relationship that describes an associated object, meaning that three relationships may exist, e.g., a and/or B may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" herein generally indicates that the former and latter related objects are in an "or" relationship.
In the embodiments provided herein, it should be understood that "B corresponding to a" means that B is associated with a from which B can be determined. It should also be understood that determining B from a does not mean determining B from a alone, but may be determined from a and/or other information.
Referring to fig. 1, a preferred embodiment of the present invention provides a method for processing electronic component data, including:
step S101, receiving a data synchronization signal sent by a Teamcenter system;
step S102, responding to the data synchronization signal, synchronizing the attribute information corresponding to the target electronic component carried in the data synchronization signal from the electronic component library in the Teamcenter system to an SQL Server database pre-deployed by the Cadence system through SQL drive, and establishing the corresponding relation between the attribute information;
and step S103, synchronizing the technical file corresponding to the target electronic component from the electronic component library to a shared file warehouse pre-deployed by the Cadence system through the Webservice, wherein the SQL Server database and the shared file warehouse are in data connection with the computer-aided electronic design ECAD user side through a development database interconnection interface ODBC.
In a preferred embodiment of the present invention, the data interface is respectively in data connection with the teancer system and the Cadence system, and when receiving a data synchronization signal sent by the teancer system, it is determined that data synchronization between the teancer system and the Cadence system needs to be performed, at this time, in response to the data synchronization signal, according to information of a target electronic component carried in the data synchronization signal, for example, a number of the target electronic component in the teancer system, and the like, attribute information corresponding to the target electronic component is synchronized from an electronic component library in the teancer system to an SQL Server database pre-deployed by the Cadence system through SQL drive, and meanwhile, a corresponding relationship between the attribute information is established, so that the attribute information in the two systems corresponds one to one, and accuracy of the data synchronization is ensured. Meanwhile, the technical files corresponding to the target electronic component in the electronic component library are remotely called to the shared file warehouse pre-deployed by the Cadence system through the Webservice, so that the technical file synchronization of the electronic component between the Teamcenter system and the Cadence system is realized, and the SQL Server database, the shared file warehouse and the ECAD user side are in ODBC data connection, so that the ECAD user side can automatically read and synchronize the attribute information of the electronic component from the Cadence system when being started, a user can conveniently output a purchase list, and the ECAD user side can obtain the corresponding technical files from the shared file warehouse, so that different designers can use the same data source to design.
According to the steps, after data synchronization is carried out, attribute information and technical files of electronic components in the Cadence system are all from the Teamcenter system, so that the Cadence system has a uniform and unique data source, data management of the electronic components is facilitated, accuracy and normalization of data of the electronic components are guaranteed, the requirement of a designer for fast type selection of the electronic components is met, repeated labor of the designer is avoided, and research and development efficiency is improved. In addition, each designer adopts the same data source during design, so that the business integration of the design end and the purchasing end can be rapidly communicated, the requirement of a purchasing department for rapidly outputting a purchasing list is met, and the production delivery cycle of the product is shortened. In addition, the technical files corresponding to the electronic components are synchronized to a shared file warehouse in the Cadence system, so that a designer can use the technical files corresponding to the electronic components in the scene of departing from the Teamcenter system.
It should be noted that the Teamcenter system is a specific system in the PLM system, the Cadence system is a specific system in the EDA system, and those skilled in the art may replace the Teamcenter system and/or the Cadence system.
Specifically, according to the processing method described above, the target electronic component is a classified electronic component selected by the first preset management user in the classification library of the teamecenter system.
In a specific embodiment of the present invention, the synchronized target electronic component is a classified electronic component selected by the first preset management user in the classification library of the teancer system, that is, the first preset management user can selectively perform data synchronization on the Cadence system according to the product design requirement and/or the electronic component update requirement, so as to avoid occurrence of repeated synchronization or omission. The first preset management user is a user preset in the Teamcenter system for executing management operations, and includes but is not limited to a user with higher professional knowledge or a management layer user.
Preferably, in the processing method described above, the classified electronic component is an electronic component obtained by the second preset management user performing, in the terminal system, audit, classification, attribute assignment, and release on an initial electronic component newly created or modified by the first preset user.
In another specific embodiment of the present invention, the classified electronic component selected by the first administrative user is an electronic component that is obtained after the second predetermined administrative user performs the auditing, classifying, attribute assigning, and issuing on the initial electronic component; the special second preset management user is used for auditing the initial electronic components newly built or modified by the first preset user, so that the issued electronic components are all correct and qualified. Meanwhile, the second preset management user classifies, assigns and issues the initial electronic components after the verification is passed, so that the phenomenon that the results of classification and attribute assignment are not uniform due to factors such as knowledge levels of different users and the like and the situation that the same electronic component corresponds to different attributes and the like are avoided, and the accuracy and the uniformity of the finally obtained classified electronic components are ensured. The second default management user is a user that executes a preset management operation in the terminal system, and includes but is not limited to a user with higher professional knowledge or a management layer user, and the second default management user and the first default management user may be the same user. The first preset user is a user in the Teamcenter system, which may be a user in each permission level in the Teamcenter system, or may be a user in some preset levels. Specifically, the user in the Teamcenter system and the user at the ECAD user side may be the same user.
Optionally, the order of auditing, classifying, attributing and issuing the initial electronic components is exchanged, which also belongs to the protection scope of the invention.
Specifically, in the processing method described above, the attribute information includes: at least one of material code, manufacturer part number.
In a specific embodiment of the present invention, the attribute information of the electronic component includes, but is not limited to, a material code, a manufacturer, a part number of the manufacturer, and the like, so that when the attribute information is output, a purchasing department can rapidly output a purchasing list, and meanwhile, since the same electronic component used by different designers is from the same data source, it is beneficial to prevent a purchaser from confirming the information of the material code, the supplier, and the like of the component one by one again, thereby improving the research and development design efficiency and shortening the research and development cycle of the product.
Referring to fig. 2, another preferred embodiment of the present invention also provides a data interface including:
a first processing module 201, configured to receive a data synchronization signal sent by a Teamcenter system;
the second processing module 202 is configured to respond to the data synchronization signal, synchronize attribute information corresponding to a target electronic component carried in the data synchronization signal from an electronic component library in the teamecenter system to an SQL Server database pre-deployed by the Cadence system through SQL driving, and establish a corresponding relationship between the attribute information;
and the third processing module 203 is configured to synchronize the technical file corresponding to the target electronic component from the electronic component library to a shared file warehouse pre-deployed by the Cadence system through Webservice, where the SQL Server database and the shared file warehouse are connected with the ECAD user side through ODBC data.
The embodiment of the data interface of the present invention is a data interface corresponding to the embodiment of the processing method, and all implementation means in the embodiment of the processing method are applicable to the embodiment of the data interface, so that the same technical effect can be achieved.
Referring to fig. 3, still another preferred embodiment of the present invention further provides a management system for electronic components, including: a Teamcenter system 301, a Cadence system 302, an ECAD client 303, and a data interface 304 as described above;
the Cadence system 302 includes: a pre-deployed SQL Server database 3021 and a shared file repository 3022, wherein the data interface 304 is connected to the Teamcenter system 301 and the SQL Server database 3021 through SQL-driven data, synchronizes attribute information of a target electronic component and establishes an attribute information corresponding relationship; moreover, the data interface 304 is connected with the terminal system 301 and the shared file warehouse 3022 through Webservice data, and synchronizes the technical files corresponding to the target electronic component;
at least one ECAD client 303 is respectively in data connection with SQL Server database 3021 and shared file repository 3022 via ODBC.
In another preferred embodiment of the present invention, a management system for electronic components includes: the terminal system 301, the Cadence system 302, the ECAD user terminal 303 and the data interface 304 are connected to the terminal system 301 and the Cadence system 302, where the data interface 304 is respectively in data connection with the terminal system 301 and the Cadence system 302, specifically, the terminal system 301 is respectively in data connection with an SQL Server database 3021 and a shared file repository 3022 pre-deployed by the Cadence system 302 through the data interface 304, and when synchronization is performed, attribute information of a target electronic component selected in the terminal system 301 is synchronized into the SQL Server database 3021 through SQL driving, and a corresponding relationship between the attribute information is established, so that attribute information synchronization of the electronic component between the terminal system 301 and the Cadence system 302 is realized, so that the attribute information in the two systems corresponds one to one, and accuracy of data synchronization is ensured; meanwhile, the technical files corresponding to the target electronic component in the Teamcenter system 301 are remotely synchronized to the shared file warehouse 3022 through the Webservice, so that the technical files of the electronic component between the Teamcenter system 301 and the Cadence system 302 are synchronized; in summary, the attribute information and the technical files of the electronic components in the Cadence system 302 are all synchronized with the terminal system 301, so that the Cadence system 302 has only one unified data source of the electronic components, which is convenient for data management of the electronic components and ensures the accuracy and the normalization of the data of the electronic components. And at least one ECAD user terminal 303 respectively communicates with the SQL Server database 3021 and the shared file repository 3022 through ODBC, so that the ECAD user terminal 303 can automatically read the attribute information of the electronic component from the Cadence system 302 when being started, and the ECAD user terminal 303 can acquire the corresponding technical file from the shared file repository 3022, so that different designers can use the same data source for designing, the requirement of the designers for quickly selecting the electronic component is met, the repeated labor of the designers is avoided, and the research and development efficiency is improved. And the business integration of the design end and the purchasing end can be quickly communicated, the requirement of a purchasing department for quickly outputting a purchasing list is met, and the production delivery cycle of the product is shortened.
In addition, by synchronizing the technical files corresponding to the electronic components to the shared file repository 3022 in the Cadence system 302, the designer can use the technical files corresponding to the electronic components even in the scenario of departing from the teancer system 301.
Alternatively, the data interface 304 may be integrated into the Cadence system 302 or the Teamcenter system 301.
Preferably, as the management system described above, the Teamcenter system 301 includes:
the first synchronization module 3015 is configured to select a classified electronic component from the classification library of the teamecenter system 301 as a target electronic component according to a first instruction of a first preset management user, and send a data synchronization signal to the data interface 304.
In an embodiment of the present invention, the teamecenter system 301 includes a first synchronization module 3015, where the first synchronization module 3015, after receiving a first instruction of a first preset management user, selects a classified electronic component carried in the first instruction from a classification library of the teamecenter system 301 as a target electronic component in response to the first instruction, and sends a data synchronization signal to the data interface 304 to perform data synchronization on the target electronic component. Therefore, a first preset management user can selectively perform data synchronization on the Cadence system 302 according to product design requirements and/or electronic component updating requirements and the like, and repeated synchronization or omission is avoided. The first preset management user is a user preset in the Teamcenter system 301 to perform a management operation, and includes but is not limited to a user with higher professional knowledge or a management layer user.
Specifically, as the management system described above, the Teamcenter system 301 further includes:
an electronic component creating module 3011, configured to obtain an initial electronic component by creating or modifying in the terminal system 301 according to a second instruction of the first preset user;
the auditing module 3012 is configured to audit the initial electronic component according to a third instruction of a second preset management user, and obtain an auditing result;
the classification module 3013 is configured to classify the checked initial electronic component according to a fourth instruction of the second preset management user, and store the classified initial electronic component in a classification library;
and the attribute giving module 3014 is configured to, according to a fifth instruction of the second preset management user, give and issue an attribute to the classified initial electronic component, so as to obtain a classified electronic component.
In another embodiment of the present invention, the Teamcenter system 301 includes, in addition to the first synchronization module 3015: an electronic component creating module 3011, an auditing module 3012, a classification module 3013, and an attribute assigning module 3014;
after receiving the second instruction of the first preset user, the electronic component creating module 3011 obtains the newly created initial electronic component by newly creating an electronic component or modifying an original electronic component in the Teamcenter system 301, where the first preset user is a user in the Teamcenter system 301, and may be a user in each authority level in the Teamcenter system 301, or may be a user in some preset levels. Specifically, the user in the Teamcenter system 301 and the user of the ECAD user terminal 303 may be the same user.
The auditing module 3012 is configured to audit the initial electronic component obtained in the electronic component creating module 3011 according to a third instruction of a second preset management user, and obtain an auditing result, where the auditing includes but is not limited to automatically detecting whether the same electronic component exists in an electronic component library of the teamecenter system 301, or whether the second preset management user passes the auditing or does not pass the auditing operation. The second default management user is a user that executes a preset management operation in the terminal system 301, and includes but is not limited to a user with higher professional knowledge or a management layer user, and the second default management user and the first default management user may be the same user.
The classification module 3013 is configured to classify the checked initial electronic components according to a fourth instruction of a second preset management user, and store the classified initial electronic components in the classification library, so as to manage the electronic components in different classification libraries, and speed up the user to select the electronic components.
The attribute giving module 3014 is configured to give attributes to the classified initial electronic components according to a fifth instruction of a second preset management user, so that attribute giving is performed by a unified user, which avoids that results of classification and attribute giving are not unified due to factors such as knowledge levels of different users, and further, situations that the same electronic component corresponds to different attributes occur, and thus accuracy and uniformity of finally obtained classified electronic components are ensured. And the classified electronic components are made available through distribution, so that the condition that synchronization is carried out when attribute endowment is not finished is avoided.
Preferably, as the management system described above, the ECAD client 303 includes:
the second synchronization module 3031 is configured to, when detecting that the ECAD client 303 is started, perform data connection with the SQL Server database 3021 and the shared file repository 3022 through ODBC, and convert the attribute information in the SQL Server database 3021 into readable attribute information of the ECAD client 303.
In another preferred embodiment of the present invention, the ECAD client 303 includes a second synchronization module 3031, and the second synchronization module 3031 can detect the start information of the ECAD client 303 when the ECAD client 303 starts, so as to facilitate data interaction between the ECAD client 303 and the Cadence system 302 by data connection between the odac and the SQL Server database 3021 and the shared file repository 3022; and carry out attribute information's autosynchronization, the user of being convenient for exports the purchase list, and avoided not in time because of the synchronization that needs user manual operation to and then the condition that the same electronic components who leads to corresponds two kinds of attribute information appears, the accuracy and the standardization of the electronic components data when guaranteeing to design satisfy the demand that the designer carries out the type selection fast to electronic components, avoided designer's repetition labor, improve research and development efficiency.
Specifically, in this embodiment, the attribute synchronization specifically includes converting the attribute information in the SQL Server database 3021 into readable attribute information of the ECAD client 303, so that the user can know the attribute information of the electronic component through the straight rod of the ECAD client 303, and the attribute information is prevented from being directly modified by the ECAD client 303, thereby further ensuring the uniformity of the data of the electronic component.
Further, as described above, the ECAD client 303 further includes:
the third synchronization module 3032 is configured to obtain a technical file corresponding to the electronic component from the shared file repository 3022 according to a sixth instruction of a second preset user.
In another preferred embodiment of the present invention, the ECAD client 303 further includes a third synchronization module 3032 in addition to the second synchronization module 3031, when a designer using the ECAD client 303, that is, a second preset user, needs to use a certain electronic component, by inputting a sixth instruction corresponding to the electronic component, the third synchronization module obtains a technical file corresponding to the electronic component from the shared file repository 3022 according to the sixth instruction, that is, the ECAD client 303 does not store the technical file corresponding to the electronic component, which is beneficial to reducing a load on the ECAD client 303 caused by a large amount of technical file storage.
Furthermore, the present invention may repeat reference numerals and/or letters in the various examples. This repetition is for the purpose of simplicity and clarity and does not in itself dictate a relationship between the various embodiments and/or configurations discussed.
It is further noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (10)
1. A method for processing electronic component data is characterized by comprising the following steps:
receiving a data synchronization signal sent by a Teamcenter system;
responding to the data synchronization signal, synchronizing the attribute information corresponding to the target electronic component carried in the data synchronization signal from an electronic component library in a Teamcenter system to an SQL Server database pre-deployed by a Cadence system through an SQL drive, and establishing a corresponding relation between the attribute information;
and synchronizing the technical file corresponding to the target electronic component from the electronic component library to a shared file warehouse pre-deployed by the Cadence system through Webservice, wherein the SQL Server database and the shared file warehouse are in data connection with the computer-aided electronic design ECAD user side through a development database interconnection interface ODBC.
2. The processing method according to claim 1, wherein the target electronic component is a classified electronic component selected by a first predetermined administrative user in a classification library of the teamecenter system.
3. The processing method according to claim 2, wherein the classified electronic component is an electronic component obtained after the second preset management user performs auditing, classification, attribute assignment and release on an original electronic component newly created or modified by the first preset user in the Teamcenter system.
4. The processing method according to claim 1, wherein the attribute information includes: at least one of material code, manufacturer part number.
5. A data interface, comprising:
the first processing module is used for receiving a data synchronization signal sent by a Teamcenter system;
the second processing module is used for responding to the data synchronization signal, synchronizing the attribute information corresponding to the target electronic component carried in the data synchronization signal from the electronic component library in the Teamcenter system to an SQL Server database pre-deployed by the Cadence system through SQL drive, and establishing the corresponding relation between the attribute information;
and the third processing module is used for synchronizing the technical file corresponding to the target electronic component from the electronic component library to a shared file warehouse pre-deployed by the Cadence system through Webservice, wherein the SQL Server database and the shared file warehouse are in data connection with the ECAD user side through ODBC.
6. A management system for electronic components, comprising: the Teamcenter system, Cadence system, ECAD client and the data interface of claim 5;
wherein the Cadence system comprises: the system comprises a prearranged SQL Server database and a shared file warehouse, wherein a data interface is connected with a Teamcenter system and the SQL Server database through SQL driving data, and is used for synchronizing the attribute information of a target electronic component and establishing an attribute information corresponding relation; the data interface is connected with the Teamcenter system and the shared file warehouse through Webservice data, and technical files corresponding to the target electronic component are synchronized;
and at least one ECAD user terminal is respectively in data connection with the SQL Server database and the shared file warehouse through ODBC.
7. The management system of claim 6, wherein the Teamcenter system comprises:
and the first synchronization module is used for selecting a classified electronic component from a classification library of the Teamcenter system as a target electronic component according to a first instruction of a first preset management user, and sending a data synchronization signal to the data interface.
8. The management system of claim 7, wherein the Teamcenter system further comprises:
the electronic component creating module is used for obtaining an initial electronic component through new creation or modification in the Teamcenter system according to a second instruction of a first preset user;
the auditing module is used for auditing the initial electronic component according to a third instruction of a second preset management user and obtaining an auditing result;
the classification module is used for classifying the checked initial electronic components according to a fourth instruction of the second preset management user and storing the classified initial electronic components in a classification library;
and the attribute giving module is used for giving and issuing the attributes of the classified initial electronic components according to a fifth instruction of the second preset management user to obtain the classified electronic components.
9. The management system according to claim 6, wherein said ECAD client comprises:
and the second synchronization module is used for connecting the SQL Server database and the shared file warehouse data through ODBC when detecting that the ECAD user side is started, and converting the attribute information in the SQL Server database into readable attribute information of the ECAD user side.
10. The management system according to claim 9, wherein said ECAD client further comprises:
and the third synchronization module is used for acquiring the technical file corresponding to the electronic component from the shared file warehouse according to a sixth instruction of a second preset user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011206431.5A CN112328680B (en) | 2020-11-03 | 2020-11-03 | Electronic component data processing method, data interface and management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011206431.5A CN112328680B (en) | 2020-11-03 | 2020-11-03 | Electronic component data processing method, data interface and management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112328680A true CN112328680A (en) | 2021-02-05 |
| CN112328680B CN112328680B (en) | 2023-06-06 |
Family
ID=74322982
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011206431.5A Active CN112328680B (en) | 2020-11-03 | 2020-11-03 | Electronic component data processing method, data interface and management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112328680B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114840729A (en) * | 2022-01-14 | 2022-08-02 | 百芯智能制造科技(深圳)有限公司 | Method, system, equipment and storage medium for generating component classification test data |
| CN117474504A (en) * | 2023-12-28 | 2024-01-30 | 广东美创希科技有限公司 | Device information management method, device, electronic equipment and medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN105653618A (en) * | 2015-12-25 | 2016-06-08 | 深圳联友科技有限公司 | Product parameter acquisition method and system based on TC (TeamCenter) synchronization tool |
| US20180336222A1 (en) * | 2017-05-18 | 2018-11-22 | Geoffrey Bourgeois | Methods and systems for migrating public folders to online mailboxes |
| CN110717088A (en) * | 2019-09-04 | 2020-01-21 | 江苏能电科技有限公司 | Electronic document-based device management method, apparatus, device and storage medium |
| US20200134639A1 (en) * | 2017-03-16 | 2020-04-30 | Siemens Aktiengesellschaft | Homogeneous model of hetergeneous product lifecycle data |
| CN111507056A (en) * | 2020-04-17 | 2020-08-07 | 成都寰蓉光电科技有限公司 | PCB design method and system for realizing component management and sharing |
| CN111680024A (en) * | 2020-06-11 | 2020-09-18 | 北京计算机技术及应用研究所 | Universal heterogeneous database data migration method |
| CN111858544A (en) * | 2019-04-29 | 2020-10-30 | 北京振兴计量测试研究所 | Component information management system |
-
2020
- 2020-11-03 CN CN202011206431.5A patent/CN112328680B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN105653618A (en) * | 2015-12-25 | 2016-06-08 | 深圳联友科技有限公司 | Product parameter acquisition method and system based on TC (TeamCenter) synchronization tool |
| US20200134639A1 (en) * | 2017-03-16 | 2020-04-30 | Siemens Aktiengesellschaft | Homogeneous model of hetergeneous product lifecycle data |
| US20180336222A1 (en) * | 2017-05-18 | 2018-11-22 | Geoffrey Bourgeois | Methods and systems for migrating public folders to online mailboxes |
| CN111858544A (en) * | 2019-04-29 | 2020-10-30 | 北京振兴计量测试研究所 | Component information management system |
| CN110717088A (en) * | 2019-09-04 | 2020-01-21 | 江苏能电科技有限公司 | Electronic document-based device management method, apparatus, device and storage medium |
| CN111507056A (en) * | 2020-04-17 | 2020-08-07 | 成都寰蓉光电科技有限公司 | PCB design method and system for realizing component management and sharing |
| CN111680024A (en) * | 2020-06-11 | 2020-09-18 | 北京计算机技术及应用研究所 | Universal heterogeneous database data migration method |
Non-Patent Citations (1)
| Title |
|---|
| 祝生华;朱海平;张国军;: "基于PDM的EDA集成关键技术研究与实现", 计算机应用研究, no. 10 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114840729A (en) * | 2022-01-14 | 2022-08-02 | 百芯智能制造科技(深圳)有限公司 | Method, system, equipment and storage medium for generating component classification test data |
| CN117474504A (en) * | 2023-12-28 | 2024-01-30 | 广东美创希科技有限公司 | Device information management method, device, electronic equipment and medium |
| CN117474504B (en) * | 2023-12-28 | 2024-05-10 | 广东美创希科技有限公司 | Device information management method, device, electronic equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112328680B (en) | 2023-06-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3916501A1 (en) | Digital twin modeling and simulation method, device, and system | |
| US6557002B1 (en) | Data management system for storing structural element data management program | |
| CN108090073B (en) | Configurable bill of material conversion method and device | |
| CN111722839B (en) | Code generation method and device, electronic equipment and storage medium | |
| TW200532516A (en) | Product data exchange | |
| CN110717320A (en) | Form/report designer and method suitable for multiple platforms and information management system | |
| US9230273B2 (en) | Creation and use of constraint templates | |
| CN106445536B (en) | Automatic business design management system | |
| CN102117306A (en) | Method and system for monitoring ETL (extract-transform-load) data processing process | |
| CN112948427B (en) | Data query method, device, equipment and storage medium | |
| US8327320B2 (en) | Process model lean notation | |
| US20120010739A1 (en) | Design configurator system | |
| US8050785B2 (en) | Apparatus and method for handling orders | |
| CN112328680A (en) | Electronic component data processing method, data interface and management system | |
| CN110889582A (en) | Method for realizing PBOM visualization based on Teamcenter | |
| CN112347084A (en) | Intelligent PCB BOM generation method and system | |
| CN111597777A (en) | Material data processing method and device and electronic equipment | |
| CN112204527A (en) | Method and system for processing engineering data in a multi-engineering system environment | |
| CN115080019A (en) | Aviation aircraft software EBOM structure construction method | |
| WO2009111141A1 (en) | Computer-implemented method for planning a manufacturing process | |
| CN112905720A (en) | Operation data processing method and device based on source data management model | |
| CN112988576A (en) | Method and device for determining software project research and development process | |
| CN110244934B (en) | Method and device for generating product demand document and test information | |
| CN111522748B (en) | Automatic test case generation method, device, server and storage medium | |
| CN110968342B (en) | Version comparison method, device and system |
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 | ||
| CP03 | Change of name, title or address |
Address after: No. 477, Hongxing Road, economic and Technological Development Zone, Xiaoshan District, Hangzhou City, Zhejiang Province 310000 Patentee after: Guotou Fusion (Hangzhou) Technology Co.,Ltd. Country or region after: China Address before: No. 477, Hongxing Road, economic and Technological Development Zone, Xiaoshan District, Hangzhou City, Zhejiang Province 310000 Patentee before: Datang Zhilian Technology (Hangzhou) Co.,Ltd. Country or region before: China |
|
| CP03 | Change of name, title or address |