Table for storing parameterized product/services information using variable field columns

• US 10,303,730 B2
• Filed: 07/25/2016
• Issued: 05/28/2019
• Est. Priority Date: 10/18/2005
• Status: Active Grant

• Current Assignee: Robert Douglas Fish
• Original Assignee: Robert Douglas Fish
• Inventors: Fish, Robert D.
• Primary Examiner(s): Wu, Yicun
• Application Number:
  US15/218,930
• Publication Number:
  US 20160335363A1
• Time in Patent Office: 1,037 Days
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/00 Commerce

Abstract

Computer implemented systems store descriptions of multiple different types of marketplace items as a collection of parameter-value pairs, using a table having a plurality of rows and columns, wherein values for at least two of the items are stored in cells of first and second ones of the rows, respectively; keys that provide information that can be used to decipher differential mappings of a plurality of the columns to a plurality of parameters in different ones of the rows; and one or more interfaces that collectively display previously stored parameters and values to a human end-user.

Claims

1. A computer system that stores descriptions of multiple different types of information as a collection of parameter-value pairs, comprising:

a values table that stores values of items of information,

wherein a data type column of the values table comprises a first value identifying a first type of data and a second value identifying a second type of data different from the first type of data, such that the values table comprises different data types for cells in the same column and in different rows, and

wherein the values tables further comprises a pointer to a format designation;

a first class key that maps columns in a first row of the values table to a first set of parameters, and a second class key that maps columns in a second row of the values table to a second set of parameters different from the first set of parameters; and

a user interface that allows a user to store and retrieve the first value of the first type of data in the column of the values table utilizing the first class key to map the first value with a first parameter of the first set of parameters, and the second value of the second type of data in the column of the values table utilizing the second class key to map the second value with a second parameter of the second set of parameters,

wherein values for the first set of parameters correspond to the first value, and

wherein values for the second set of parameters correspond to the second value.

2. The system of claim 1, further comprising a class key table that associates the first class key with a designation for information type, selected from the group consisting of text, image, video, and audio.

3. The system of claim 1, further comprising a class key table that associates the first class key with a designation for units type, selected from the group consisting of distance and time.

4. The system of claim 1, further comprising a class key table that associates the first class key with a designation for data type, selected from the group consisting of integer, floating point, telephone number, text, and link.

5. The system of claim 1, further comprising a class key table that associates the first class key with a limited choices designation that limits at least one of the values in the values table with only specified values.

6. The system of claim 1, further comprising a class key table that associates the first class key with auction-related information, selected from the group consisting of last bid amount, last bid date, last bid time, and bidder identifier.

7. The system of claim 1, further comprising a search interface configured to display n members of the first set of parameters, and from which a user is restricted to selecting less than n of the members to conduct a search.

8. The system of claim 7, wherein n is greater than 15, and the search interface restricts the user to select no more than 15 of the members.

9. The system of claim 1, further comprising an item adding interface configured to display n members of the first set of parameters, and from which a user is restricted to selecting less than n of the members to conduct add the item.

10. The system of claim 1, further comprising a parameter adding interface configured to receive from a user an additional parameter that was not included in the first set of parameters, and wherein the system adds the additional parameter to the first set of parameters for subsequent display to other users.

11. The system of claim 10, wherein the additional parameter is treated as a suggestion, and subsequent display of the additional parameter to the other users is subjected to oversight.

12. The system of claim 1, further comprising a class selection interface through which a user selects a class from within a hierarchical classification, the selected class corresponding to the first class key.

13. The system of claim 1, further comprising a search interface that depicts available parameters that a user can select from among the first set of parameters according to prior frequency of use by other users.

14. The system of claim 1, further comprising a values selection interface configured to display members of a selected one of the first set of parameters according to prior frequency of use by other users.

15. The system of claim 1, further comprising a values adding interface configured to receive from a user an additional value that was not included as a choice for a selected one of the first set of parameters, and wherein the system adds the additional value to the first set of parameters for subsequent display to other users.

16. The system of claim 1, wherein the first set of parameters identifies characteristics of a marketplace item.

17. The system of claim 1, wherein the first set of parameters identifies characteristics of an informational item.

18. The system of claim 1, wherein the first set of parameters identifies characteristics of a textual work, and at least one of the first set of parameters is selected from the list consisting of title, author, subject, type of work, quality of work, and length.

19. The system of claim 1, wherein the first value and the second value are on different rows of the column.