• 欢迎访问速搜资源吧,如果在网站上找不到你需要的资源,可以在留言板上留言,管理员会尽量满足你!

【速搜问答】公用数据库是什么

问答 admin 3年前 (2020-07-14) 603次浏览 已收录 0个评论

汉英对照:
Chinese-English Translation:

公共数据库是指数据库软件(如Access、SQLServer等)生成的各种包含元器件信息的表格文件。Altium Design通过创建和使用关联数据库DBLib文件,可直接从公共数据库调取元器件并通过连接库文件与公共数据库保持同步更新。

Public database is a kind of table file which contains component information generated by database software (such as access, SQL server, etc.). Altium design can directly fetch components from the public database by creating and using the associated database dblib file, and keep the update with the public database through the connection library file.

公共数据库是指数据库软件(如 Access、SQLServer 等)生成的各种包含元器件信息的表格文件。Altium Design 通过创建和使用关联数据库*.DBLib 文件,可直接从公共数据库调取元器件并通过连接库(*.DBLink)文件与公共数据库保持同步更新,使当前设计文件中的元器件参数与器件库中元器件资料变更一致。当 Libraries 面板加载了关联数据库后,相当一个数据库浏览器,可由此选取元件。

Public database is a kind of table file which contains component information generated by database software (such as access, SQL server, etc.). By creating and using the associated database *. Dblib file, Altium design can directly retrieve components from the public database, and keep the update with the public database through the connection Library (. Dblink) file, so that the component parameters in the current design file are consistent with the changes of the component data in the device library. When the associated database is loaded in the libraries panel, it is quite a database browser, from which components can be selected.

Altium Designer 提供两个用于连接公共数据库的文件,一是关联数据“库文件”(*.DBLib):二是数据库“链接文件”(*.DBLink)。

Altium designer provides two files for connecting to the public database. One is the associated data “library file” (*. Dblib) and the other is the database “link file” (*. Dblink).

1.关联数据库

1. Associated database

关联数据库(*.DBLib)文件定义了电路设计原理图元件和公共数据库中相匹配记录之间的联系。匹配记录由单个关键字段(如某个器件号)或多个关键字段(如 where 从句)来建立。这种方式将元件的符号、模型和参数信息作为外部数据库(Access 或 Excel 等文件)保存,而原理图的器件库(}.Schlib)文件则仅仅定义了元件的符号。在关联数据库中选择元件后,通过相关字段定义的映射,元件模型和参数信息会随之建立。这些参数通过连接文件与外部数据库保持同步匹配联系。

The associated database (. Dblib) file defines the relationship between circuit design schematic components and matching records in the common database. Matching records are created by a single key field (such as a device number) or multiple key fields (such as a where clause). In this way, the symbol, model and parameter information of components are saved as external database (access or Excel files), while the device library (}. Schlib) file of schematic diagram only defines the symbols of components. After the component is selected in the associated database, the component model and parameter information will be established through the mapping of related field definitions. These parameters are synchronized with the external database through the connection file.

这种方式用于“多数据库记录对应一个元件”的模式,即调用一个元件可检索到多条记录参数。关联数据库通常采用面向库的模式配置*.DBLib 文件,只需作为 Libraries 面板的可用元件库使用,例如,在公共数据库中建立一个所有电阻详细资料的文件或所有电容详细资料的文件,不需添加到工程项目中。这样可在任何设计中从公共数据库记录中有效检索元件信息,动态获取元件。

This method is used in the mode of “multiple database records corresponding to one component”, that is, calling one component can retrieve multiple record parameters. The associated database usually adopts the library oriented mode to configure the *. Dblib file, which only needs to be used as the available component library of the libraries panel. For example, a file of all resistance details or all capacitor details files should be established in the public database, and it is not necessary to add them to the project. In this way, the component information can be retrieved effectively from the common database records in any design, and the components can be obtained dynamically.

2.数据库链接

2. Database link

数据库链接(*.DBLink)文件通过关键字段定义原理图元件和关联数据库记录之间的匹配关系。元件的模型参数预先定义为库元件的一部分,之后将连接文件添加到 PCB 项目或封装库中,可确保元件信息与关键字段内容同步。此方法用于“一个数据库对应一个元件”的模式,即数据库中元件不会重复出现。

Database link (. Dblink) files define the matching relationship between schematic components and associated database records through key fields. The model parameters of components are pre-defined as part of the library components, and then the connection file is added to the PCB project or package library to ensure that the component information is synchronized with the key field content. This method is used in the pattern of “one database corresponds to one component”, that is, components in the database will not appear repeatedly.

设计者在使用数据库放置一个器件时,AltiumDesigner 软件通过数据库接口链接到公共数据库并读取与这个元器件相关的所有列表。读取到元器件的各种模型信息并加载到设计中,同时也将其他相关信息,如采购信息和库存信息等也加载到元器件的属性中。

When a designer places a device in a database, Altium designer software links to the public database through the database interface and reads all lists related to the component. Read all kinds of model information of components and load them into the design. At the same time, other related information, such as purchase information and inventory information, are also loaded into the attributes of components.

由于数据库形式固定了元器件各种模型之间的对应关系,所以实现了设计元件库的统一管理。如果数据库来源于公司的 PDM/ERP 系统,就可以实现 AltiumDesigner 电子开发平台与 PDM/ERP 系统在器件库的集成。

As the database forms the corresponding relationship between various models of components, the unified management of design component library is realized. If the database comes from the PDM / ERP system of the company, the integration of Altium designer electronic development platform and PDM / ERP system in device library can be realized.

完整数据库驱动的器件信息系统 DBLIB 为每个集成库元件添加了与数据库的接口链接,可以实现远程调用数据库信息。SVNDBLIB 在 DBLIB 的基础上,将元器件各种模型信息添加到 PDM/ERP 系统的版本控制流程,使 AltiumDesigner 的电子设计平台集成到 PDM/ERP 系统中,更加确保了设计元件库的安全性和统一管理。

Dblib, a complete database driven device information system, adds an interface link to the database for each component in the integrated library, which can remotely call the database information. Based on dblib, svndblib adds various model information of components to the version control process of PDM / ERP system, so that the electronic design platform of Altium designer is integrated into PDM / ERP system, which ensures the security and unified management of design component library.

在设计中实时查看数据库中各种元器件的采购信息和库存信息,为设计人员与采购人员之间建立了双向沟通的桥梁。避免了由于元器件的采购周期太长、采购差错、研发产品成本超过预算、大量长期不用的元器件占据库存管理的资源等原因造成的研发延期和浪费现象。

In the design, the purchasing information and inventory information of various components in the database can be viewed in real time, which establishes a two-way communication bridge between designers and purchasers. It avoids the delay and waste of R & D due to the long procurement cycle of components, purchase errors, the cost of R & D products exceeding the budget, and a large number of long-term unused components occupy the inventory management resources.


速搜资源网 , 版权所有丨如未注明 , 均为原创丨转载请注明原文链接:【速搜问答】公用数据库是什么
喜欢 (0)
[361009623@qq.com]
分享 (0)
发表我的评论
取消评论
表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址