Desain Dan Implementasi Data Warehouse Pada Perpustakaan Daerah Provinsi Sumatera Selatan

This research will focus on processing visitor data, member data, book borrowing data and book return data at the Regional Library of South Sumatra Province. The data is stored in the form of an excel file with a large amount of data, causing problems in the storage system such as data accumulation, data loss, no data analysis and delays in the reporting process. The process of data storage and data retrieval will be well integrated by building a data Warehouse at the Regional Library of South Sumatra Province. Data Warehouse is a system that contains several years of history and facilitates decision making. At the data Warehouse design stage using the Nine-Step method (Kimball, 2002), in this method there are nine steps in designing a data Warehouse, namely Process Selection, Grain Selection, Identification of dimensional adjustments, Fact Selection, Storage of initial calculations in the fact table, Reviewing the dimension table, selecting the database duration, tracking dimension changes, and prioritizing, querying the model and selecting the physical design. And the design and data processing process will use the Pentaho kettle and public Tableau applications, with the design and implementation of the data Warehouse, it is expected to help facilitate the reporting and analysis process for the Regional Library of South Sumatra Province.

Download Full-text

BECA: A Blockchain-Based Edge Computing Architecture for Internet of Things Systems

IoT ◽

10.3390/iot2040031 ◽

2021 ◽

Vol 2 (4) ◽

pp. 610-632

Author(s):

Oluwashina Joseph Ajayi ◽

Joseph Rafferty ◽

Jose Santos ◽

Matias Garcia-Constantino ◽

Zhan Cui

Keyword(s):

Internet Of Things ◽

Data Storage ◽

Distributed Storage ◽

Storage System ◽

Data Retrieval ◽

Edge Computing ◽

Computing Architecture ◽

Symbiotic Relationships ◽

Data Ownership ◽

Latency Response

The scale of Internet of Things (IoT) systems has expanded in recent times and, in tandem with this, IoT solutions have developed symbiotic relationships with technologies, such as edge Computing. IoT has leveraged edge computing capabilities to improve the capabilities of IoT solutions, such as facilitating quick data retrieval, low latency response, and advanced computation, among others. However, in contrast with the benefits offered by edge computing capabilities, there are several detractors, such as centralized data storage, data ownership, privacy, data auditability, and security, which concern the IoT community. This study leveraged blockchain’s inherent capabilities, including distributed storage system, non-repudiation, privacy, security, and immutability, to provide a novel, advanced edge computing architecture for IoT systems. Specifically, this blockchain-based edge computing architecture addressed centralized data storage, data auditability, privacy, data ownership, and security. Following implementation, the performance of this solution was evaluated to quantify performance in terms of response time and resource utilization. The results show the viability of the proposed and implemented architecture, characterized by improved privacy, device data ownership, security, and data auditability while implementing decentralized storage.

Download Full-text

Implementasi Pengembangan Sistem Model Water Fall Untuk Data Warehouse Akademik

INTENSIF Jurnal Ilmiah Penelitian dan Penerapan Teknologi Sistem Informasi ◽

10.29407/intensif.v1i2.837 ◽

2017 ◽

Vol 1 (2) ◽

pp. 108

Author(s):

Arik Sofan Tohir Sofan Tohir ◽

Kusrini Kusrini ◽

Sudarmawan Sudarmawan

Keyword(s):

Data Warehouse ◽

Flow System ◽

Step Method ◽

Good Data ◽

Analysis Process ◽

Warehouse Design ◽

Waterfall Model ◽

Transactional Data ◽

Model Water ◽

Selection Of

Data warehouse is a concept and a technology to store transactional data from several sources that have been through the process of filtering and selection of data. By using the Ectract, Transform and Load (ETL) process in the data warehouse, OLTP data is processed to produce good data and ready for use for the analysis process. For the design of this warehouse data will be built by using the Nine Step Method from Kimbal, so that the resulting warhouse data can be as expected. For the development of life flow system (SDLC) with waterfall model. By using the wate fall model will be built a prototype to implement the data warehouse design results.

Download Full-text

Expanding the Molecular Alphabet of DNA-Based Data Storage Systems with Neural Network Nanopore Readout Processing

10.1101/2021.09.27.462049 ◽

2021 ◽

Author(s):

S. Kasra Tabatabaei ◽

Bach Pham ◽

Chao Pan ◽

Jingqian Liu ◽

Shubham Chandak ◽

...

Keyword(s):

Neural Network ◽

Data Storage ◽

Network Architecture ◽

Double Helix ◽

Storage System ◽

Fold Increase ◽

Data Retrieval ◽

Modified Nucleotides ◽

Recording Time ◽

Dna Double Helix

DNA is a promising next-generation data storage medium, but the recording latency and synthesis cost of oligos using the four natural nucleotides remain high. Here, we describe an improved DNA-based storage system that uses an extended 11-letter molecular alphabet combining natural and chemically modified nucleotides. Our extended-alphabet molecular storage paradigm offers a nearly two-fold increase in storage density and potentially the same order of reduction in the recording time. Experimental results involving a library of 77 custom-designed hybrid sequences reveal that one can readily detect and discriminate different combinations and orders of monomers via MspA nanopores. Furthermore, a neural network architecture designed to classify raw current signals generated by Oxford Nanopore Technologies sequencing ensures an average accuracy exceeding 60%, which is 39 times higher than that of random guessing. Molecular dynamics simulations reveal that the majority of modified nucleotides do not induce dramatic disruption of the DNA double helix, making the extended alphabet system potentially compatible with PCR-based random access data retrieval. The methodologies proposed provide a forward path for new implementations of molecular recorders.

Download Full-text