Identifying connection accessories for electrical cables
This specification generally describes technology for identifying connection accessories for electrical cables. In some implementations, a system includes a product repository that includes electrical cable product data, the product data including, for each electrical cable represented in the product data, an electrical cable part number and various characteristic values for the electrical cable. An association data structure associates, for an electrical cable part number and a connection accessory type, connection accessories that are compatible for use with the electrical cable. A computing server is configured to handle requests for electrical cable and/or connection accessory information. User interfaces are provided to computing devices to facilitate information requests.
1 . A computer system configured to perform a progressive search of a compound index, the computer system comprising:
a product repository configured as a schemaless database that includes unstructured product data, the unstructured product data comprising, for each product represented in the unstructured product data, a product part number;
at least one association data structure, the association data structure associating, with the product part number, one or more accessory products that are compatible for use with the product; and
a computing server configured to perform operations comprising:
generating a compound index based on the unstructured product data and a sequence of parameters;
performing a progressive search, comprising:
receiving, from a computer device over a communication network, a request for information;
identifying a first collection of parts data based on a first index of the compound index and a first parameter of the sequence of parameters;
providing, to the computing device over the communication network, the first collection of parts data;
receiving, from the computing device over the communication network, a first selection based on the first collection of parts data;
identifying a second collection of parts data based on a second parameter of the sequence of parameters, wherein the second collection of parts data is a subset of a second index of the compound index based on the received first selection;
providing, to the computing device over the communication network, the second collection of parts data; and
receiving, from the computing device over the communication network, a second selection based on the second collection of parts data;
identifying a collection of accessory data based on the second selection of the progressive search and the association data structure; and
providing the identified accessory data to the computing device over the communication network.
2 . The computer system of claim 1 , wherein the product is an electrical cable, the unstructured product data further comprises an electrical cable part number, a voltage value, an insulation value, a number of conductors value, a cable type value, a conductor metal value, and a conductor size value, and the sequence of parameters includes (i) a voltage parameter corresponding to the voltage value, (ii) an insulation parameter corresponding to the insulation value, (iii) a number of conductors parameter corresponding to the number of conductors value, (iv) a cable type parameter corresponding to the cable type value, (v) a conductor metal parameter corresponding to the conductor metal value, and (vi) a conductor size parameter corresponding to the conductor size value.
3 . The computer system of claim 1 , wherein the association data structure includes a cache of matching parts data that indicates the one or more accessory products that are compatible for use with the product.
4 . The computer system of claim 1 , wherein performing a progressive search comprises:
determining and transmitting one or more query parameter options for a first filter level;
receiving a selected option for a first query parameter;
iteratively determining and transmitting query parameter options for subsequent filter levels, and receiving selected options for subsequent query parameters until selected options for all of the query parameters are received; and
performing a search using the first query parameter and the subsequent query parameters to identify the collection of accessory product information.
5 . The computer system of claim 1 , wherein the requested information includes the one or more accessory products that are compatible for use with the product.
6 . The computer system of claim 1 , the operations further comprising:
extracting unstructured product data for each product from a datasheet; and
ingesting the unstructured product data into the schemaless database.
7 . A computer-implemented method of performing a progressive search of a compound index, the method, comprising:
receiving requests for information from computing devices;
accessing a product repository configured as a schemaless database that comprises unstructured product data and an association data structure to identify the requested information, wherein the product repository includes product data;
generating a compound index based on the unstructured product data and a sequence of parameters;
performing a progressive search, comprising:
receiving, from a computing device over a communication network, a request for information;
identifying a first collection of parts data based on a first index of the compound index and a first parameter of the sequence of parameters;
providing, to the computing device over the communication network, the first collection of parts data;
receiving, from the computing device over the communication network, a first selection based on the first collection of parts data;
identifying a second collection of parts data based on a second parameter of the sequence of parameters, wherein the second collection of parts data is a subset of a second index of the compound index based on the received first selection;
providing, to the computing device over the communication network, the second collection of parts data; and
receiving, from the computing device over the communication network, a second selection based on the second collection of parts data;
identifying a collection of accessory product data based on the second selection of the progressive search and the association data structure; and
providing the identified accessory product data to the computing device over the communication network.
8 . The computer-implemented method of claim 7 , wherein the product is an electrical cable, the unstructured product data further comprises an electrical cable part number, a voltage value, an insulation value, a number of conductors value, a cable type value, a conductor metal value, and a conductor size value, and the sequence of parameters includes (i) a voltage parameter corresponding to the voltage value, (ii) an insulation parameter corresponding to the insulation value, (iii) a number of conductors parameter corresponding to the number of conductors value, (iv) a cable type parameter corresponding to the cable type value, (v) a conductor metal parameter corresponding to the conductor metal value, and (vi) a conductor size parameter corresponding to the conductor size value.
9 . The computer-implemented method of claim 7 , wherein the association data structure includes a cache of matching parts data that indicates the one or accessory products that are compatible for use with the product.
10 . The computer-implemented method of claim 7 , wherein performing a progressive search comprises:
determining and transmitting one or more query parameter options for a first filter level;
receiving a selected option for a first query parameter;
iteratively determining and transmitting query parameter options for subsequent filter levels, and receiving selected options for subsequent query parameters until selected options for all of the query parameters are received; and
performing a search using the first query parameter and the subsequent query parameters to identify the collection of accessory product information.
11 . The computer-implemented method of claim 7 , wherein the collection of accessory product information includes the one or more accessory products that are compatible for use with the product.
12 . The computer-implemented method of claim 7 , further comprising:
extracting unstructured product data for each product from a datasheet; and
ingesting the unstructured product data into the schemaless database.
13 . A non-transitory, computer-readable medium storing one or more instructions configured to perform a progressive search of a compound index and executable by a computer system to perform operations comprising:
generating a compound index based on unstructured product data and a sequence of parameters;
performing a progressive search, comprising:
receiving, from a computing device over a communication network, a request for information;
identifying a first collection of parts data based on a first index of the compound index and a first parameter of the sequence of parameters;
providing, to the computing device over the communication network, the first collection of parts data;
receiving, from the computing device over the communication network, a first selection based on the first collection of parts data;
identifying a second collection of parts data based on a second parameter of the sequence of parameters, wherein the second collection of parts data is a subset of a second index of the compound index based on the received first selection;
providing, to the computing device over the communication network, the second collection of parts data; and
receiving, from the computing device over the communication network, a second selection based on the second collection of parts data;
identifying a collection of connection accessory data based on the second selection of the progressive search and an association data structure, wherein the association data structure associates, with the product, one or more accessory products that are compatible for use with the product; and
providing the identified connection accessory data to the computing device over the communication network.
14 . The computer-readable medium of claim 13 , wherein the product is an electrical cable, the unstructured product data further comprises an electrical cable part number, a voltage value, an insulation value, a number of conductors value, a cable type value, a conductor metal value, and a conductor size value, and the sequence of parameters includes (i) a voltage parameter corresponding to the voltage value, (ii) an insulation parameter corresponding to the insulation value, (iii) a number of conductors parameter corresponding to the number of conductors value, (iv) a cable type parameter corresponding to the cable type value, (v) a conductor metal parameter corresponding to the conductor metal value, and (vi) a conductor size parameter corresponding to the conductor size value.
15 . The computer-readable medium of claim 13 , wherein the association data structure includes a cache of matching parts data that indicates the one or more accessory products that are compatible for use with the product.
16 . The computer-readable medium of claim 13 , wherein performing a progressive search comprises:
determining and transmitting one or more query parameter options for a first filter level;
receiving a selected option for a first query parameter;
iteratively determining and transmitting query parameter options for subsequent filter levels, and receiving selected options for subsequent query parameters until selected options for all of the query parameters are received; and
performing a search using the first query parameter and the subsequent query parameters to identify the collection of accessory product information.
17 . The computer-readable medium of claim 13 , the operations further comprising:
extracting unstructured product data for each product from a datasheet; and
ingesting the unstructured product data into a product repository and an association data structure to identify the requested information, wherein the product repository configured as a schemaless database that comprises product data, the unstructured product data comprising, for each product represented in the unstructured product data, a product part number.