Patent ID: 9020995
Filing Date: 2015-04-28
Classification: G06F

Abstract:
1. A method of data storage and retrieval using a relational database comprising: defining a first table in a relational database comprising a plurality of entries having a first value for a first field; defining a second table in the relational database comprising a plurality of entries, wherein each of the plurality of entries in the second table includes a second field and a third field for the first field of a corresponding entry in the first table, wherein the second field is reserved to store a media file having a size equal to or smaller than a threshold value and the third field is reserved to store a media file having a size greater than the threshold value; determining a size of a media file to be stored, the media file corresponding to the first value in the first field in at least one of the plurality of entries of the first table; selecting from the second field and at least the third field a field for storing the media file according to a size of the media file; storing the media file in the selected field; and responsive to a query, presenting a data item selected from at least one of the plurality of entries from the first table and the corresponding media file stored in the selected field.