I am working with our libraries right now and have an oppertunity to change them drastically if I need to. Currently, our libraries contain aproximatly 20,000 different physical parts (lines of .ptf files), about 1,000 different pad stacks, 6,500 symbols. We are creating databases for our sourcing and quality groups to have vision to what parts we use, where we use them and how often. We would also like to pull from those databases to make design decisons based off part cost and quality when placing parts in Design Entry HDL. Does anybody have any "best practices" for how to structure the library, key things to include, key things to exclude, etc?
Also, are there any suggestions on how to integrate the different databases and libraries? We use Windchill on the mechanical side of things, would it be beneficial to change our license from SPB to ADW so that we can use the integration between Windchill and ADW, or are there other systems that can do the same thing without changing our platform?