Offline Consumption of QuML Content
- Sharath Prasad
Solution
SQL Table |
|
|
|---|---|---|
Question Set | Saves the metadata of Question Set in the table |
|
Question | Saves the individual Question Metadata of the Question |
|
ECAR Structure
ECAR of Question Set
-------- metadata.json (Complete Question Set Hierarchy)
-------- do_id-1 (Question Leaf Folder)
------ asset-1
------ asset-2
------ asset-3
------ asset-4
-------- do_id-2 (Question Leaf Folder)
------ asset-1
------ asset-2
------ asset-3
------ asset-4
-------- do_id-2 (Question Leaf Folder)
------ asset-1
------ asset-2
------ asset-3
------ asset-4
……………
……………
……………
……………
…………..
-------- do_id-n (Question Leaf Folder)
------ asset-1
------ asset-2
------ asset-3
------ asset-4
ECAR Import Process :
Fetch the temporary Location from device
Extraction of Ecar
Unzip the Ecar using ZipServiceValidation of ECAR Content
Absence of Manifest
Invalid JSON in Manifest
Empty JSONExtract Payload
Copy the entire directory set on leaf nodes to File System of DeviceUpdate Size on Download Manager
Create Manifest for each leaf node //Optional
SQL Table
Design 1: (Considering some limit is imposed on payload size)
Question Set Table
do_id (Primary Key) | Payload (Max Limit of 2 MB) | CreatedTime | UpdatedTime |
|
|
|
|
Design 2 : (Considering no limit is imposed on payload size)
Question Set Table
do_id (Primary Key) | Spine Content (Max Limit of 2 MB) | CreatedTime | UpdatedTime |
|
|
|
|
Question Table
do_id (Primary Key) | Question Metadata | CreatedTime | UpdatedTime |
|
|
|
|
Caching Strategy :
FIFO :
LIFO :
LRU :