System and method for processing complex queries

A computer program product comprising:

• a non-transitory computer-readable memory medium;
• and
• a computer program stored on the medium, the computer program comprising instructions configured to be executed by at least one data processor to process a search query, the instructions configured to:
• obtain definition data comprising data elements from first and second data repositories, wherein the data elements of the definition data from the first data repository have a first data structure that differs from a second data structure of the data elements of the definition data from the second data repository, the first data structure comprises a first travel product type and one or more first element fares, and the second data structure comprises a second travel product type and one or more second element fares;
• convert the definition data from the first data repository and the definition data from the second data repository into converted definition data sharing one single generic data structure;
• store the converted definition data in a database;
• after the converted definition data is stored in the database, receive the data search query at a search engine;
• query the database with the search engine to find the data elements of the first and second travel product types for which the converted definition data matches the search query;
• associate the element fares for the converted definition data that matches the search query based upon compliance with combinatory rules;
• build at least one fared set of data elements of the first travel product and the data elements of the second travel product based on the association of the element fares that comply with the combinatory rules;
• and
• for a first association of first and second element fares:
• determine if the first association complies with at least one combinatory rule;
• if the first association is determined to comply with the at least one combinatory rule, validate the first association;
• and
• if the first association is determined to not comply with the at least one combinatory rule, invalidate the first association such that the first association is excluded from the at least one fared set.

A system for processing a data search query, the system comprising:

• a first data repository including definition data comprising a plurality of data elements with a first data structure, the first data structure including a first travel product type and one or more first element fares;
• a second data repository including definition data comprising a plurality of data elements with a second data structure that differs from the data structure of the data elements of the first definition data, the second data structure including a second travel product type and one or more second element fares;
• a database;
• and
• at least one processor coupled with the first and second data repositories, wherein the at least one processor is configured to:
• obtain the definition data from the first repository and the definition data from the second data repository, convert the definition data from the first data repository and the definition data from the second data repository into converted definition data sharing one single generic data structure, and store the converted definition data in the database;
• receive the data search query, query the database to find the data elements of the first and second travel product types for which the converted definition data matches the search query, associate the element fares for the converted definition data that matches the search query based upon compliance with combinatory rules, and build at least one fared set of data elements of the first travel product and the data elements of the second travel product based on the association of the element fares that comply with the combinatory rules;
• and
• for a first association of first and second element fares:
• determine if the first association complies with at least one combinatory rule;
• if the first association is determined to comply with the at least one combinatory rule, validate the first association;
• and
• if the first association is determined to not comply with the at least one combinatory rule, invalidate the first association such that the first association is excluded from the at least one fared set.