IP Library Granted Patent US 9,286,372
Granted Patent B2
US 9,286,372 · App. 14/073,467 · Granted Mar 15, 2016

Content management with RDBMS

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,286,372
App. No.
14/073,467
Granted
Mar 15, 2016
Kind
B2
Abstract

According to some embodiments, a method and an apparatus of using a relational database as an underlying structure of file storage are provided to receive a file and store non-content information associated with the file in a row of a first relational database table. If the content associated with the file is binary content then the content associated with the file is stored in a second relational database table else the content associated with the file is stored in a third relational database table.

Claims (43)

1. A method of using a relational database as an underlying structure of a cloud file storage, the method comprising:

receiving a first file comprising first content and first non-content information;

storing, via a processor, the first non-content information associated with the first file in a a first relational database table;

in a case that the first content is binary content, storing the first content in a second relational database table;

in a case that the first content is non-binary content, storing the first content in a third relational database table; and

in a case that the first content is non-binary content and is of type VARCHAR, (i) segmenting the first content into multiple strings with each string of the multiple strings being stored in a respective row of the third relational database table and (ii) assigning an assembly order identification to each string of the multiple strings so that the multiple strings are ordered based on their respective assembly order identification.

2. The method of claim 1 , wherein the content associated with the file is binary content and the first content is stored as type binary large object (“BLOB”).

3. The method of claim 1 , wherein the non-content information comprises (i) a file path, (ii) a file name, (iii) a file type, and (iv) a file content type.

4. The method of claim 1 , wherein the first relational database table, the second relational database table and the third relational database table comprise an underlying structure of a cloud file storage.

5. The method of claim 1 , further comprising:

receiving a second file comprising second content and second non-content information;

storing, via the processor, the second non-content information in the first relational database table;

in a case that the second content is binary content, storing the second content in the second relational database table; and

in a case that the second content is non-binary content, storing the second content in the third relational database table, wherein the first content and the second content comprise different content types.

6. A non-transitory computer-readable medium comprising instructions that when executed by a processor perform a method of using a relational database as an underlying structure of file storage, the method comprising:

receiving a first file comprising first content and first non-content information;

storing, via a processor, the first non-content information associated with the first file in a a first relational database table;

in a case that the first content is binary content, storing the first content in a second relational database table;

in a case that the first content is non-binary content, storing the first content in a third relational database table; and

in a case that the first content is non-binary content and is of type VARCHAR, (i) segmenting the first content into multiple strings with each string of the multiple strings being stored in a respective row of the third relational database table and (ii) assigning an assembly order identification to each string of the multiple strings so that the multiple strings are ordered based on their respective assembly order identification.

7. The medium of claim 6 , wherein the content associated with the file is binary content and the first content is stored as type binary large object (“BLOB”).

8. The medium of claim 6 , wherein the non-content information comprises (i) a file path, (ii) a file name, (iii) a file type, and (iv) a file content type.

9. The medium of claim 8 , wherein the file type comprises one of (i) a folder type, (ii) a document, or (iii) binary.

10. The method of claim 6 , wherein the method further comprises:

receiving a second file comprising second content and second non-content information;

storing, via the processor, the second non-content information in the first relational database table;

in a case that the second content is binary content, storing the second content in the second relational database table; and

in a case that the second content is non-binary content, storing the second content in the third relational database table, wherein the first content and the second content comprise different content types.

11. An apparatus comprising:

a processor; and

a non-transitory computer-readable medium comprising instructions that when executed by the processor perform a method of using a relational database as an underlying structure of file storage, the method comprising:

receiving a first file comprising first content and first non-content information;

storing, via the processor, the first non-content information associated with the first file in a first relational database table;

in a case that the first content is binary content, storing the first content in a second relational database table;

in a case that the first content is non-binary content, storing the first content in a third relational database table; and

in a case that the first content is non-binary content and is of type VARCHAR, (i) segmenting the first content into multiple strings with each string of the multiple strings being stored in a respective row of the third relational database table and (ii) assigning an assembly order identification to each string of the multiple strings so that the multiple strings are ordered based on their respective assembly order identification.

12. The apparatus of claim 11 , wherein the content associated with the file is binary content and the first content is stored as type binary large object (“BLOB”).

13. The apparatus of claim 11 , wherein the non-content information comprises (i) a file path, (ii) a file name, (iii) a file type, and (iv) a file content type.

14. The apparatus of claim 11 , wherein the method further comprises:

receiving a second file comprising second content and second non-content information;

storing, via the processor, the second non-content information in the first relational database table;

in a case that the second content is binary content, storing the second content in the second relational database table; and

in a case that the second content is non-binary content, storing the second content in the third relational database table, wherein the first content and the second content comprise different content types.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 6, 2013
From: DELCHEV, NEDELCHO
To: SAP AG
Reel/Frame 031556/0461 →