Method and system for creating a database and searching the database for allowing multiple customized views
View Patent ↗A method and system allows multiple customized views which are organization, user role, and end-user specific, to be generated from a single search engine and a product database. The database is assembled to contain product information, pricing information, organization-specific configurations defining approved suppliers and other similar items and views which are defined by organization. The product information is arranged and indexed by key product information. A search mask is created for each product based on various filters to allow selected products to be identified through the filter function.
1. A method of creating a product database capable of being searched by individual users, and which provides customized search results for each individual user, user group and/or organization respectively, comprising:
inputting data relating to product information, product pricing information, buyer organization specific information, and search view information relating to individual users, into a data store;
arranging and indexing the product information data to allow searching thereof;
creating a search mask for each set of product data based on product pricing information, organization specific information and search view information; and
arranging said organization specific information in a specified manner with a Management Module under predetermined rules, and wherein said Management Module arranges the data in a manner under which said predetermined rules allow buying organizations to: turn specified suppliers' product information data on/off for viewing in search results of products; assign one of different levels of preferential treatment to suppliers in search results of product information; preferred position of products; turn product categories on/off for viewing in search results of product information for all suppliers offering products in those categories; and turn product categories on/off for viewing in search results for specific suppliers.
2. The method of claim 1 , wherein said product information data comprises product stock keeping unit (SKU) information, supplier information, product category information, product description information, and product attributes.
3. The method of claim 1 , wherein said search mask is created as a bit map that is associated with each product for which data is stored in the database.
4. The method of claim 1 , wherein said search mask is created as a bit map of 1's and 0's, wherein each bit represents a view in which a bit of 1 indicates the information for a product is viewable in the search view being used and a bit of 0 indicates the product is not viewable in the search view being used.
5. A method of searching a product database, said database capable of being searched by individual users, and capable of providing customized search results for each individual user, respectively, comprising:
establishing a database in a data store comprised of data relating to product information, product pricing information, organization specific information, and search view information relating to individual users, said product information being arranged and indexed to allow searching thereof, and creating and storing a search mask for each set of product data based on product pricing information, organization specific information and search view information;
arranging the organization specific information in a specified manner with a Management Module under predetermined rules, and wherein said Management Module arranges the data in a manner under which said predetermined rules allow buying organization to search and obtain search results by: turning specified suppliers' product information data on/off for viewing in search results of products; assigning one of different levels of preferential treatment to suppliers in search results of product information; preferred position of products; turning product categories on/off for viewing in search results of product information for all suppliers offering products in those categories; and turning product categories on/off for viewing in search results for specific suppliers;
requesting a search of a database with a search engine through a specified user input to the search engine;
retaining information about all products matching the user input;
applying the search mask to each set of information about each product returned to determine if product information should be provided to the user; and
providing information to the user about products about which information is allowed to be returned to the user.
6. The method of claim 5 , wherein said search mask is a bit map associated with each product for which data is stored in the database.
7. The method of claim 5 , wherein the search results are cached, specified display rules are applied to the results and only selected results specified for a specified user are displayed to the user.
8. The method of claim 5 , comprising using a search engine to conduct searching.
9. The method of claim 5 , further comprising returning search results in order of relevance.
10. The method of claim 5 , wherein said specified user input to request a search is a product attribute.
11. The method of claim 5 , further comprising arranging the product information in accordance with a preferred positioning arrangement.
12. A database system for providing information about products to individual users in a manner in which customized search results can be provided to each individual user, respectively, comprising:
a data store of data relating to product information, product pricing information, supplier organization specific information, and search view information relating to individual users;
said product information data being arranged and indexed to allow searching thereof;
a search mask for each product data based on product pricing information, supplier organization specific information, and search view information for filtering search results in accordance with specified users to allow a customized view of search results to be provided to each user, respectively; and
a Management Module arranging said organization specific information in a specific manner under predetermined rules, with said Management Module having said data arranged in a manner under which said predetermined rules allow buying organizations to: turn specified suppliers' product information data on/off for viewing in search results of products; assign one of different levels of preferential treatment to suppliers in search results of product information; preferred position of products; turn product categories on/off for viewing in search results of product information for all suppliers offering products in those categories; and turn product categories on/off for viewing in search results for specific suppliers.
13. The system of claim 12 , wherein said product information data comprises product stock keeping unit (SKU) information, supplier information, product category information, product description information, and product attributes.
14. The system of claim 12 , wherein said search mask is a bit map that is associated with each product for which data is stored in the database.
15. The system of claim 12 , wherein said search mask is a bit mask of 1's and 0's, wherein each bit represents a view in which a bit of 1 indicates the information for a product is viewable in the search view being used and a bit of 0 indicates the product is not viewable in the search view being used.