JSON']JSON standard support mechanisms for efficient data storage and processing in IBM DB2 environment

被引：0
|
作者：
Drzymala, Pawel [1 ]
Welfle, Henryk [1 ]
机构：
[1] Tech Univ Lodz, Inst Mechatron & Syst Informatycznych, Stefanowskiego 22, PL-90537 Lodz, Poland
来源：
PRZEGLAD ELEKTROTECHNICZNY | 2023年 / 99卷 / 02期
关键词：
IBM DB2; !text type='JSON']JSON[!/text] ([!text type='Java']Java[!/text]Script Object Notation); indexing [!text type='JSON']JSON[!/text] data;
D O I：
10.15199/48.2023.02.33
中图分类号：
TM [电工技术]; TN [电子技术、通信技术];
学科分类号：
0808 ; 0809 ;
摘要：
The paper presents the possibilities of storing, processing and exchanging JSON data (JavaScript Object Notation) in RDBMS IBM DB2 LUV from version v11.1, which are used in widely understood business applications. Increasingly JSON data is stored and processed in database environments, both relational and non-relational databases (NoSQL). The IBM DB2 database environment does not provide a JSON-specific data type as it is for the XML data type. The use of indexes allows efficient sorting and filtering of data, which are stored in the properties of documents in JSON format.
引用
收藏
页码：182 / 185
页数：4
相关论文
共 12 条
  • [1] Support JSON']JSON standard for storing and processing data in the Oracle environment
    Drzymala, Pawel
    Welfle, Henryk
    PRZEGLAD ELEKTROTECHNICZNY, 2020, 96 (02): : 142 - 145
  • [2] Advanced mechanisms of data exchange and processing in the SQL Server and Azure SQL Database environment with the use JSON']JSON standard
    Drzymala, Pawel
    Welfle, Henryk
    PRZEGLAD ELEKTROTECHNICZNY, 2019, 95 (01): : 25 - 28
  • [3] Storage of temporal data for the valid time on the IBM Db2 platform
    Lachecinski, Sebastian
    PRZEGLAD ELEKTROTECHNICZNY, 2024, 100 (12): : 201 - 205
  • [4] Storage of temporal data for the transaction time on the IBM Db2 platform
    Lachecinski, Sebastian
    PRZEGLAD ELEKTROTECHNICZNY, 2024, 100 (01): : 185 - 188
  • [5] Processing of temporal data for the transaction time on the IBM Db2 platform
    Lachecinski, Sebastian
    PRZEGLAD ELEKTROTECHNICZNY, 2024, 100 (06): : 100 - 106
  • [6] zHyperLink: Low-latency I/O for Db2 on IBM Z and DS8880 storage
    Craddock, D.
    Hoshikawa, A.
    Josten, J.
    Riedy, D. F.
    Sutton, P. G.
    Yudenfriend, H. M.
    IBM JOURNAL OF RESEARCH AND DEVELOPMENT, 2018, 62 (2-3) : 131 - 1310
  • [7] Native Cloud Object Storage in Db2 Warehouse: Implementing a Fast and Cost-Efficient Cloud Storage Architecture
    Kalmuk, David
    Garcia-Arellano, Christian
    Barber, Ronald
    Sidle, Richard
    Rakopoulos, Kostas
    Roumani, Hamdi
    Minor, William
    Cheung, Alexander
    Hooper, Robert C.
    Emmerton, Matthew
    Hoggard, Zach
    Walkty, Scott
    Perez, Patrick
    Santars, Aleksandrs
    Chen, Michael
    Olan, Matthew
    Zilio, Daniel C.
    Sayyid, Imran
    Li, Humphrey
    Rampurkar, Ketan
    Ramachandran, Krishna K.
    Shen, Yiren
    COMPANION OF THE 2024 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, SIGMOD-COMPANION 2024, 2024, : 188 - 200
  • [8] An Efficient and Secure Big Data Storage in Cloud Environment by Using Triple Data Encryption Standard
    Ramachandra, Mohan Naik
    Srinivasa Rao, Madala
    Lai, Wen Cheng
    Parameshachari, Bidare Divakarachari
    Ananda Babu, Jayachandra
    Hemalatha, Kivudujogappa Lingappa
    BIG DATA AND COGNITIVE COMPUTING, 2022, 6 (04)
  • [9] Fast Fourier transform based efficient data processing technique for big data processing speed enhancement in P2P computing environment
    Yoon-Su Jeong
    Seung-Soo Shin
    Peer-to-Peer Networking and Applications, 2018, 11 : 1186 - 1196
  • [10] Fast Fourier transform based efficient data processing technique for big data processing speed enhancement in P2P computing environment
    Jeong, Yoon-Su
    Shin, Seung-Soo
    PEER-TO-PEER NETWORKING AND APPLICATIONS, 2018, 11 (06) : 1186 - 1196
12