With SPB16.2 release, Capture-CIS allows you to create and use relational tables in the parts database. These tables have a one-to-many relationship with part information (primary) tables. For example, the database may contain a Vendor table with multiple vendor / manufacture part numbers for one company part number in your Resistor table. This structure allows you to query for data across the primary and relational tables.
What is Relational table support and how it works
Short for relational database management system, RDBMS and pronounced as separate letters, is a type of database management system (DBMS) that stores data in the form of related tables. Relational tables are powerful because they require few assumptions about how data is related or how it will be extracted from the database. As a result, the same database can be viewed in many different ways. An important feature of relational systems is that a single database can be spread across several tables.
How it works in Capture-CIS
Capture-CIS allows you to create and use relational tables. You can define the primary - foreign key relationship between the parts (primary) tables and related tables in the database. In the Relational Database tab, you define the relationship between the part (primary) and relational tables in the database.
Relationship through Part Number between Capacitor table and Vendor table
Note: Capture CIS supports a one-to-many database relationship between the part information tables and related tables.
The Set Relational Data grid contains the following fields:
To define the relational data:
First, ensure you are in the Relational Database tab of the Configure Database dialog. Go to a row that contains a primary table.
How will the you see the relationship in CIS?
As always, I look forward to your feedback on how you employ this new capability in Capture-CIS.
Jerry "GenPart" Grzenia
The corresponding "enterprise product" for Capture is Design Entry HDL (DEHDL - or earlier known as ConceptHDL).
I installed spb 162 from my university resource. However, I dont see capture CIS in the program list. I think what I installed is the "enterpise products" as you mentioned. So what is the corresponding product in "enterpise products" for capture CIS?
Sorry to hear about your difficulties. I would encourage you to please contact our Customer Support team and they can assist you.
after reading and reading I still can not get the board done. What a difficult thing to learn and little information to get .
The SPB16.2 release for enterpise products (e.g. Allegro Design Entry HDL, Allegro PCB Editor, etc.) is available on all platforms - Windows, Linux, Solaris, HP-UX, IBM-AIX. However, the SPB16.2 release for the OrCAD series of products (e.g. Capture), is only available on the Windows platform.
There is Linux edition of SPB 16.2? and how many price?