Have a personal or library account? Click to login
Secure and Modular Data Portal: Database System to Manage Broadly Classified and Large Scale Data Cover

Secure and Modular Data Portal: Database System to Manage Broadly Classified and Large Scale Data

Open Access
|Apr 2024

Figures & Tables

dsj-23-1538-g1.png
Figure 1

Modular and secured data portal architecture.

dsj-23-1538-g2.png
Figure 2

Conceptual data model.

dsj-23-1538-g3.png
Figure 3

Data portal’s database structure.

dsj-23-1538-g4.png
Figure 4

Raw data uploading module.

dsj-23-1538-g5.png
Figure 5

Row data’s report upload module.

dsj-23-1538-g6.png
Figure 6

Global search Interface.

dsj-23-1538-g7.png
Figure 7

Table-based dataset access.

dsj-23-1538-g8.png
Figure 8

(a) Query that counts projects data stored in database. (b) Query that counts binary files stored in database.

dsj-23-1538-g9.png
Figure 9

Query that sums file size of raw data in gigabytes.

dsj-23-1538-g10.png
Figure 10

B-Tree and full table scan performances analysis.

Table 1

B-tree and full table scan comparision.

OPERATIONS/QUERIESB-TREEFULL TABLE SCAN
BEST CASEAVERAGEWORST CASEBEST CASEAVERAGEWORST CASE
SpaceO(1)O(n)O(n)O(1)O(1)O(1)
SearchO(1)O(log n)O(log n)O(1)O(n/2)O(n)
InsertO(log n)O(log n)O(log n)O(n)O(n)O(n)
DeleteO(log n)O(log n)O(log n)O(n)O(n)O(n)
Language: English
Submitted on: Jan 16, 2023
|
Accepted on: Mar 18, 2024
|
Published on: Apr 15, 2024
Published by: Ubiquity Press
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year

© 2024 Atnafu Abrham Lencha, Addisalem Bitew Mitiku, Abel Tadesse Woldemichael, published by Ubiquity Press
This work is licensed under the Creative Commons Attribution 4.0 License.