CDBMS (CLOUD DATABASE MANAGEMENT SYSTEM) DISTRIBUTED LOGICAL UNIT REPOSITORY

• US 20160140134A1
• Filed: 06/12/2014
• Published: 05/19/2016
• Est. Priority Date: 06/24/2013
• Status: Active Grant

• Current Assignee: K2View Ltd.
• Original Assignee: K2View Ltd.
• Inventors: ITAMAR, Einav, ROTEM, Achi
• Granted Patent: US 10,311,022 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/128 Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion use of snapshots for error detection or correction G06F11/14, G06F11/16
• CPC Class Codes: G06F 16/1744 using compression, e.g. sparse files
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 21/80 in storage media based on magnetic or optical technology, e.g. disks with sectors preventing unauthorised reproduction or copying of disc-type recordable media G11B20/00

Abstract

The invention comprises systems and methods for implementation of database technology using ‘Distributed logical unit repositories’ (DLUR). This is a new type of database which contains information and database structure related to a specific logical unit such as a customer, employee or the like. The information comprises data, database structure, functions, and any other data necessary to form a complete model of the information concerning the logical unit. Queries concerning entities can then be answered immediately by accessing this database, obviating the step of consulting a number of databases in parallel and greatly reducing memory and time required.

Claims

1. In an SQL database, a system for storing data comprising:

a. a computing device having processing means, storage means, and communications means;

b. a database containing a plurality of entries, each entry comprising an ID portion and a data portion, said data portion containing all information pertaining to a given logical unit including data, database structures, methods, functions, relations, constraints, links, sequences, and procedures;

wherein data and structure concerning logical units spanning a plurality of databases is stored in a database.

2. The method of claim 1 wherein said logical units are selected from the group consisting of:

customers, employees, borrowers, lenders, persons, departments, teams, corporations, phone lines, and accounts.

3. The method of claim 1 further providing means for compressing said data portion.

4. The method of claim 3 wherein said compressed data portion is stored in binary form.

5. The method of claim 4 wherein said compressed data portion is stored in encrypted form.

6. The method of claim 3 wherein said means for compressing said data portion achieves about a 1:

10 compression ratio or better.

7. A method for storing data concerning a logical unit comprising steps of:

a. assembling structure and data from extant databases concerning said logical unit;

b. forming a representation of said data and structure;

c. storing said representation in a database;

wherein information concerning a given is stored by logical unit.

8. The method of claim 7 wherein said representation is compressed.

9. The method of claim 8 wherein said compressed representation is stored in binary form.

10. The method of claim 8 wherein said compressed data is further encrypted.

11. The method of claim 8 wherein said step of compressing said data achieves about a 1:

10 compression ratio or better.

12. A method for storing data concerning a logical unit in an SQL database comprising steps of:

a. gathering structure and data from extant databases concerning said logical unit;

b. forming a representation of said data and structure;

c. encrypting said stored representation;

d. storing said encrypted compressed representation in a database;

wherein information concerning a given is stored by logical unit in encrypted format.

13. The method of claim 12 further compressing said representation.

14. The method of claim 12 wherein said entities are selected from the group consisting of:

customers, employees, borrowers, lenders, persons, departments, teams, corporations, phone lines, and accounts.

15. The method of claim 12 wherein said step of gathering structure and data comprises querying said databases selecting said entities.

16. The method of claim 12 wherein said step of storing said data is implemented using memory selected from the group consisting of:

local memory;

remote memory;

disk storage; and

RAM.

17. The method of claim 12 wherein said data is stored in binary form.

18. The method of claim 123 wherein said step of compressing said data achieves about a 1:

10 compression ratio or better.