Page 234 - Kỷ yếu hội thảo khoa học lần thứ 12 - Công nghệ thông tin và Ứng dụng trong các lĩnh vực (CITA 2023)

218

Windows 11 Home system with 11th Gen Intel(R) Core(TM) i5-1135G7 @ 2.40GHz
CPU, 8 GB DDR, 256GB SSD with 1 Kbyte page size and 128 Kbyte block size and
64KB FRAM.

4.1 Performance of the system

In this section, we assess the performance of the proposed scheme by inserting 100,000
records into SQLite database. As shown in figure 2, the number of read operations of
BBS is fewer than the original one about 14.1% because BBS uses FRAM which can
be overritten to temporarily store data and journal file.

Figure 2. The number of read operations

For the write and delete operations, BBS performs fewer than the original one about
17.8% and 21.3% respectively as shown in figure 3 and figure 4.

Figure 3. Number of write operations Figure 4. Number of delete operations

Although BBS need some write operations to write data and jounal file to FRAM before
writing to flash memory, but its does not perform merge operations which lead to a lot
of read, write operations and 1 delete operation. So, it helps BBS avoid a lot of merge
operations on flash memory leading to a big number of read and write operations is
reduced. This is very useful for flash memory because its lifecycle is protected and the
performance of Sqlite is improved.

4.2 Time comsumption

Figure 5 shows the time consumption of inserting 100,000 records into SQLite
database. Since, BBS reduces a lot of flash operations and the high speed of FRAM,

CITA 2023 ISBN: 978-604-80-8083-9