qdb

Qdb

The Qualifier database (Qdb) is a fully normalized, relational database, that is used in conjunction with Aftermarket Catalog Exchange Standard (ACES). The Qdb helps to standardize fitment terminologies and expressions, also known as Qualifiers, used in catalog and web lookup's which require a vehicle or equipment lookup to navigate a correct product(s). Qdb qualifiers replace free-form text notes with consistent terminologies and expressions, in a coded manner, reducing redundant notes and inaccurate interpretation of unlimited free text formats. The use of the Qdb streamlines communication making it easier to parse data into catalogs and increases the search-ability of data. Users can apply validation to Qdb data increasing reliability over free-form text which cannot be validated in scalable ways.

Why use the Qdb?

  • Increased speed to market. Using coded qualifiers from the Qdb enables trading partners to load content faster, promoting faster speeds to market and increased sales.
  • Faster selection of the correct part at the counter. With standardized coded qualifiers, catalogs are easier to understand and navigate by both end consumers and store sales associates. This means finding the correct products the first time, reducing returns.
  • More sophisticated data management opportunities. Coded qualifiers enable simplified data mapping between different sources. Different sources may include OE data and VIO (vehicles in operation) data. Increased mapping accuracy promotes better product management decisions.
  • Centralized language translation. Utilization of coded qualifiers will facilitate a centralized translation effort.

Qualifiers not covered by a vehicle attribute will be contained in the Qdb. In general, only individual qualifiers are stored in the table. You can create compound expressions by joining multiple entries from this table. A placeholder (i.e. parameter) will replace variable data found in a qualifier. This mechanism greatly reduces the number of qualifiers stored in the table.

  • The Qualifier database (Qdb) documentation found below is the latest version of the database documentation. This version, and all versions, are designed and maintained by the industry, for the industry, through industry workgroups and the guidance of the Technology Standards Committee (TSC).

    Documentation Includes:
    Data Rules and Policies
    ER Diagram

    Note: Our documentation is available to the public. To view and download documentation, please sign-in with your autocare.org login information to the Auto Care Digital Hub. If you do not have a login, please create an account.

  • While the Aftermarket Catalog Exchange Standard (ACES) and Product Information Exchange Standard (PIES) are free, they both utilize multiple relational databases which contain standardized, codified data (aka reference data), some of which require an annual paid subscription.

    The Qualifier database (Qdb) requires an annual paid subscription.

    To subscribe to the Qdb, users must subscribe to the Vehicle Configuration database (VCdb). A subscription to the VCdb automatically provides access to the Qdb. VCdb subscriptions are segmented in a variety of ways, providing you flexibility in buying only what you need.

    Please visit our subscriptions page for more information and to subscribe.

  • The Qualifier database (Qdb) and all other ACES and PIES data standards supporting relational databases, can be managed and downloaded through the Auto Care Vehicle Information Portal (VIP).

    The VIP platform allows users to view the contents of the Qdb, submit changes to existing records, request new records, as well as download the published database.

    Publication Cycle: Monthly

    Release Notes: Click here

    The Qdb requires an active paid subscription to view and download.

    Note: Access to the VIP site does not require a paid active subscription. However, access to certain products within the site will require an active paid subscription. To access the VIP site, users are required to create an account. To create an account, please visit Autocarevip.com and follow the instructions on the landing page.

  • There are multiple ways to get involved in the development and management of the Aftermarket Catalog Exchange Standard (ACES) and Product Information Exchange Standard (PIES) data standards, as well as their supporting relational databases. Click to learn more.

    + Auto Care Vehicle Information Portal (VIP)
    + Communifire
    + Education and Networking
  • If you have any questions, please reach out to us! We are here for you!

    Data Standards and Technical Questions - technology@autocare.org

    Billing and Subscription Questions - techbilling@autocare.org


    Please visit our FAQs page for more information.

    FAQs

  • Share