1 / 22

Extended Database

Extended Database. Valuable Independent of EDI Research, Item Creation, Sourcing SKU & TMF Maintenance Biblio info, price, status changes Two Different Databases GM; Books Many data sources. EXTDB Records. Item/Title Header Record ISBN & UPC are Keys

karen-flowers
Download Presentation

Extended Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Extended Database • Valuable Independent of EDI • Research, Item Creation, Sourcing • SKU & TMF Maintenance • Biblio info, price, status changes • Two Different Databases • GM; Books • Many data sources

  2. EXTDB Records • Item/Title Header Record • ISBN & UPC are Keys • Item Specific Info, Data Source Indicated • Ability to Determine Primary Data Source • Vendor Specific Data • Price & Availability; Multiple Vendors • Toggle Between Header & Vendor Data

  3. EXTDB Books • titles@ingram (600K) • Ingram Extended (900K) • NACSCORP • Matthews Medical (7.7) • J.A. Majors (7.7) • Thomson (soon) • Over 2.2M records today

  4. EXTDB GM • Douglas Stewart • School, Dorm Supplies, Electronics, Tech Products • NACSCORP/Ingram Micro • Full Range of Hardware, Software, Peripherals

  5. Setup & Maintenance • Access from Vendor • License, Fee?, Media or FTP Credentials • Set Parameters; Load Code File • Load Database • Space & Time to Load Vary • Most Small Enough to Run Nightly • Ingram Price/Avail Nightly, Full Cat Weekly • Performance Issues Being Investigated

  6. Searching EXTDB • Within the Module • Book & Product Search • From Merch Systems • Prompts at Bottom of Screens • Use Search Parameters (T; etc.) • Different Parameters for GM • Interface Follows Book Conventions

  7. What’s Next • More Catalogs • Relatively Low Programming Overhead • Need to Resolve Load Performance Issues • Database Hierarchy • Richer Search Options/Interface • Avexxis Conversion Byproduct? • Utilities • Reporting & Automated Maintenance • By System/By Data Source

More Related