Multi-dimensional Data Compression and Query Processing in Array Databases
In recent times, the production of multidimensional data in various domains and their storage in array databases has witnessed a sharp increase; this rapid growth in data volumes necessitates compression in array databases. However, existing compression schemes used in array databases are general-pu...
Uloženo v:
| Vydáno v: | IEEE access Ročník 10; s. 1 |
|---|---|
| Hlavní autoři: | , , |
| Médium: | Journal Article |
| Jazyk: | angličtina |
| Vydáno: |
Piscataway
IEEE
2022
The Institute of Electrical and Electronics Engineers, Inc. (IEEE) |
| Témata: | |
| ISSN: | 2169-3536, 2169-3536 |
| On-line přístup: | Získat plný text |
| Tagy: |
Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
|
| Abstract | In recent times, the production of multidimensional data in various domains and their storage in array databases has witnessed a sharp increase; this rapid growth in data volumes necessitates compression in array databases. However, existing compression schemes used in array databases are general-purpose and not designed specifically for the databases. They could degrade query performance with complex analytical tasks, which incur huge computing costs. Thus, a compression scheme that considers the workflow of array databases is required. This study presents a compression scheme, SEACOW, for storing and querying multidimensional array data. The scheme is specially designed to be efficient for both dimension-based and value-based exploration. It considers data access patterns for exploration queries and embeds a synopsis, which can be utilized as an index, in the compressed array. In addition, we implement an array storage system, namely MSDB, to perform experiments. We evaluate query performance on real scientific datasets and compared it with those of existing compression schemes. Finally, our experiments demonstrate that SEACOW provides high compression rates compared to existing compression schemes, and the synopsis improves analytical query processing performance. |
|---|---|
| AbstractList | In recent times, the production of multidimensional data in various domains and their storage in array databases has witnessed a sharp increase; this rapid growth in data volumes necessitates compression in array databases. However, existing compression schemes used in array databases are general-purpose and not designed specifically for the databases. They could degrade query performance with complex analytical tasks, which incur huge computing costs. Thus, a compression scheme that considers the workflow of array databases is required. This study presents a compression scheme, SEACOW, for storing and querying multidimensional array data. The scheme is specially designed to be efficient for both dimension-based and value-based exploration. It considers data access patterns for exploration queries and embeds a synopsis, which can be utilized as an index, in the compressed array. In addition, we implement an array storage system, namely MSDB, to perform experiments. We evaluate query performance on real scientific datasets and compared it with those of existing compression schemes. Finally, our experiments demonstrate that SEACOW provides high compression rates compared to existing compression schemes, and the synopsis improves analytical query processing performance. |
| Author | Chung, Yon Dohn Lee, Hyubjin Kim, Minsoo |
| Author_xml | – sequence: 1 givenname: Minsoo surname: Kim fullname: Kim, Minsoo organization: Department of Computer Science and Engineering, Korea University, 145 Anam-ro, Seongbuk-gu, Seoul, Republic of Korea – sequence: 2 givenname: Hyubjin surname: Lee fullname: Lee, Hyubjin organization: Department of Computer Science and Engineering, Korea University, 145 Anam-ro, Seongbuk-gu, Seoul, Republic of Korea – sequence: 3 givenname: Yon Dohn orcidid: 0000-0003-2070-5123 surname: Chung fullname: Chung, Yon Dohn organization: Department of Computer Science and Engineering, Korea University, 145 Anam-ro, Seongbuk-gu, Seoul, Republic of Korea |
| BookMark | eNp9kV9PwyAUxYmZifPPJ_Clic-dcCktfVzq1BmNmukzoUAXlq5M6B727WV2GuODvFxycs4J3N8pGnWuMwhdEjwhBJfX06qaLRYTwAATCoQxYEdoDCQvU8poPvp1P0EXIaxwPDxKrBijh6dt29tU27XpgnWdbJMb2cukcuuNN2EvJbLTyevW-F3y4p3ai90ysV0y9V7uvuy1DCaco-NGtsFcHOYZer-dvVX36ePz3byaPqYqw7xPs1w3xEieK8ox4bLmBTQaZ4TrutYq14xQDRJjwLjhPFPAmrwoiSoY5MAVPUPzoVc7uRIbb9fS74STVnwJzi-F9L1VrRE02oGSODLIaqBlZhgUYHBWc8VzEruuhq6Ndx9bE3qxclsftxBE9HFWEEyK6CoHl_IuBG8aoWwv-7ib3kvbCoLFnoQYSIg9CXEgEbP0T_b7xf-nLoeUNcb8JMoyfiFy_ATfFJQX |
| CODEN | IAECCG |
| CitedBy_id | crossref_primary_10_3390_earth5030027 crossref_primary_10_1109_ACCESS_2024_3391333 |
| ContentType | Journal Article |
| Copyright | Copyright The Institute of Electrical and Electronics Engineers, Inc. (IEEE) 2022 |
| Copyright_xml | – notice: Copyright The Institute of Electrical and Electronics Engineers, Inc. (IEEE) 2022 |
| DBID | 97E ESBDL RIA RIE AAYXX CITATION 7SC 7SP 7SR 8BQ 8FD JG9 JQ2 L7M L~C L~D DOA |
| DOI | 10.1109/ACCESS.2022.3215525 |
| DatabaseName | IEEE Xplore (IEEE) IEEE Xplore Open Access Journals IEEE All-Society Periodicals Package (ASPP) 1998–Present IEEE Electronic Library (IEL) CrossRef Computer and Information Systems Abstracts Electronics & Communications Abstracts Engineered Materials Abstracts METADEX Technology Research Database Materials Research Database ProQuest Computer Science Collection Advanced Technologies Database with Aerospace Computer and Information Systems Abstracts Academic Computer and Information Systems Abstracts Professional DOAJ Directory of Open Access Journals |
| DatabaseTitle | CrossRef Materials Research Database Engineered Materials Abstracts Technology Research Database Computer and Information Systems Abstracts – Academic Electronics & Communications Abstracts ProQuest Computer Science Collection Computer and Information Systems Abstracts Advanced Technologies Database with Aerospace METADEX Computer and Information Systems Abstracts Professional |
| DatabaseTitleList | Materials Research Database |
| Database_xml | – sequence: 1 dbid: DOA name: DOAJ Directory of Open Access Journals url: https://www.doaj.org/ sourceTypes: Open Website – sequence: 2 dbid: RIE name: IEEE Electronic Library (IEL) url: https://ieeexplore.ieee.org/ sourceTypes: Publisher |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Engineering |
| EISSN | 2169-3536 |
| EndPage | 1 |
| ExternalDocumentID | oai_doaj_org_article_38c323138c424b2394e5272e04b8c861 10_1109_ACCESS_2022_3215525 9923935 |
| Genre | orig-research |
| GrantInformation_xml | – fundername: National Research Foundation of Korea grantid: NRF-2020R1A2C2013286; NRF-2021R1A6A1A13044830 funderid: 10.13039/501100003725 – fundername: Institute for Information & communications Technology Planning & Evaluatio grantid: IITP-2021-2020-0-01819 |
| GroupedDBID | 0R~ 4.4 5VS 6IK 97E AAJGR ABVLG ACGFS ADBBV AGSQL ALMA_UNASSIGNED_HOLDINGS BCNDV BEFXN BFFAM BGNUA BKEBE BPEOZ EBS EJD ESBDL GROUPED_DOAJ IPLJI JAVBF KQ8 M43 M~E O9- OCL OK1 RIA RIE RNS AAYXX CITATION 7SC 7SP 7SR 8BQ 8FD ABAZT JG9 JQ2 L7M L~C L~D |
| ID | FETCH-LOGICAL-c408t-46df1ea86c38018ab872fd0418dbbdc6d513d2a00200f884c25f6791c752628c3 |
| IEDL.DBID | RIE |
| ISICitedReferencesCount | 2 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000873839600001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| ISSN | 2169-3536 |
| IngestDate | Fri Oct 03 12:52:14 EDT 2025 Mon Jun 30 03:20:58 EDT 2025 Sat Nov 29 04:02:16 EST 2025 Tue Nov 18 21:48:10 EST 2025 Tue Nov 25 14:44:24 EST 2025 |
| IsDoiOpenAccess | true |
| IsOpenAccess | true |
| IsPeerReviewed | true |
| IsScholarly | true |
| Language | English |
| License | https://creativecommons.org/licenses/by-nc-nd/4.0 |
| LinkModel | DirectLink |
| MergedId | FETCHMERGED-LOGICAL-c408t-46df1ea86c38018ab872fd0418dbbdc6d513d2a00200f884c25f6791c752628c3 |
| Notes | ObjectType-Article-1 SourceType-Scholarly Journals-1 ObjectType-Feature-2 content type line 14 |
| ORCID | 0000-0003-2070-5123 0000-0003-0046-7316 0000-0003-3450-9721 |
| OpenAccessLink | https://ieeexplore.ieee.org/document/9923935 |
| PQID | 2728571017 |
| PQPubID | 4845423 |
| PageCount | 1 |
| ParticipantIDs | crossref_citationtrail_10_1109_ACCESS_2022_3215525 crossref_primary_10_1109_ACCESS_2022_3215525 doaj_primary_oai_doaj_org_article_38c323138c424b2394e5272e04b8c861 proquest_journals_2728571017 ieee_primary_9923935 |
| PublicationCentury | 2000 |
| PublicationDate | 20220000 2022-00-00 20220101 2022-01-01 |
| PublicationDateYYYYMMDD | 2022-01-01 |
| PublicationDate_xml | – year: 2022 text: 20220000 |
| PublicationDecade | 2020 |
| PublicationPlace | Piscataway |
| PublicationPlace_xml | – name: Piscataway |
| PublicationTitle | IEEE access |
| PublicationTitleAbbrev | Access |
| PublicationYear | 2022 |
| Publisher | IEEE The Institute of Electrical and Electronics Engineers, Inc. (IEEE) |
| Publisher_xml | – name: IEEE – name: The Institute of Electrical and Electronics Engineers, Inc. (IEEE) |
| SSID | ssj0000816957 |
| Score | 2.2490902 |
| Snippet | In recent times, the production of multidimensional data in various domains and their storage in array databases has witnessed a sharp increase; this rapid... |
| SourceID | doaj proquest crossref ieee |
| SourceType | Open Website Aggregation Database Enrichment Source Index Database Publisher |
| StartPage | 1 |
| SubjectTerms | Arrays Cost analysis Data compression Data structures Database systems Discrete wavelet transforms Huffman coding Image coding Indexes Low-pass filters Multidimensional data Performance degradation Performance evaluation Queries Query processing Scientific computing Storage Task analysis Task complexity Tree data structures Workflow |
| SummonAdditionalLinks | – databaseName: DOAJ Directory of Open Access Journals dbid: DOA link: http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV3NS8MwFA8yPOhB1ClOp_Tg0bombfNxnJtDPAwFhd1CmqYwkCpdJ-y_9-VjYyLoxVOhvJc2v7zkvdcmv4fQtaYcAl1exgVTNM4g5I-LStm_7InlKwKHk_liE2w65bOZeNoq9WX3hHl6YA_cIOU6hRgELhnJClvI2-SEEZNkBdfcJz4JE1vJlFuDOaYiZ4FmCCdiMByNoEeQEBJymxJLPJZ_c0WOsT-UWPmxLjtnMzlEByFKjIb-7Y7QjqmP0f4Wd2AXPbqjs_HYsvN7Zo1orFoV2Qnu97bWkarL6HlpmlUUzgOAZjSvod1GrZy4dWKLE_Q6uX8ZPcShMEKss4S3AGlZYaM41Sk4GK4KzkhVAqq8LIpS0zLHaUmUDQWTivNMk7yiTGDNckIJAHqKOvV7bc5QhFlS6UpRkM4g-WFcQQBSYGUwSBuse4isMZI6sIbb4hVv0mUPiZAeWGmBlQHYHrrZKH140ozfxe8s-BtRy3jtboAdyGAH8i876KGuHbpNI0I4crce6q-HUobZuZCgx3NmF6Pz_3j0Bdqz3fEfZvqo0zZLc4l29Wc7XzRXzjC_AM_l3tw priority: 102 providerName: Directory of Open Access Journals |
| Title | Multi-dimensional Data Compression and Query Processing in Array Databases |
| URI | https://ieeexplore.ieee.org/document/9923935 https://www.proquest.com/docview/2728571017 https://doaj.org/article/38c323138c424b2394e5272e04b8c861 |
| Volume | 10 |
| WOSCitedRecordID | wos000873839600001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| journalDatabaseRights | – providerCode: PRVAON databaseName: DOAJ Directory of Open Access Journals customDbUrl: eissn: 2169-3536 dateEnd: 99991231 omitProxy: false ssIdentifier: ssj0000816957 issn: 2169-3536 databaseCode: DOA dateStart: 20130101 isFulltext: true titleUrlDefault: https://www.doaj.org/ providerName: Directory of Open Access Journals – providerCode: PRVHPJ databaseName: ROAD: Directory of Open Access Scholarly Resources customDbUrl: eissn: 2169-3536 dateEnd: 99991231 omitProxy: false ssIdentifier: ssj0000816957 issn: 2169-3536 databaseCode: M~E dateStart: 20130101 isFulltext: true titleUrlDefault: https://road.issn.org providerName: ISSN International Centre |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV1Na9wwEB2SpYf2kLbZlG6aBh96jBNLtiX5mG53KYWGBlLYm5AlGRaCE7zeQi757ZmRFZPSEOjFNmZGyHqWZvQxbwC-WKHQ0VUuraURaYEuf1o3hnbZM-IrQoNTDMkm5MWFWq2qXztwMsbCeO_D4TN_So9hL9_d2C0tlZ1VVSDs2oVdKcUQqzWup1ACiaqUkViIZdXZ-XyO34BTQM5Pc05UY-Vfxidw9MekKv-MxMG8LN_-X8XewV50I5PzAff3sOPbfXjzhFxwCj9CbG3qiL5_oN5IvpneJDQCDIdf28S0Lrnc-u4uiQEDqJmsWyy3M3dBnKzc5gB-LxdX8-9pzJyQ2iJTPba5a5g3StgcLZAytZK8cdjsytW1s8KVLHfckK-YNUoVlpeNkBWzsuSCK5t_gEl70_qPkDCZNbYxAqULnB1JZdBDqZnxDKU9szPgj02qbaQVp-wW1zpML7JKDzhowkFHHGZwMirdDqwaL4t_JaxGUaLEDi8QBB17mM6x2uis4q3gRU0Z333JJfdZUSurBJvBlIAbC4mYzeDoEXkdu-9Go54qJY1Wh89rfYLXVMFhLeYIJn239Z_hlf3TrzfdcZjY4_Xn_eI4_KUP5EPgIA |
| linkProvider | IEEE |
| linkToHtml | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV3da9swED_abtDuYR_NRrNlmx_2GCeW_CH5scsWsjYLK6SQNyFLMhSGO_IxyH-_O1kxGxuFPdmYOyHpZ-lOH_c7gA-mkOjoShtXQhdxhi5_XNWaTtkT4itCg5O1ySbEYiFXq_LbEQy7WBjnnL985kb06s_y7b3Z0VbZuCw9YdcxPKLMWSFaq9tRoRQSZS4CtRBLyvHlZIKtwEUg56OUE9lY_of58Sz9Ia3KX3OxNzDTZ_9XtefwNDiS0WWL_As4cs05PPmNXrAHVz66NrZE4N-Sb0Sf9FZHNAe011-bSDc2utm59T4KIQOoGd01WO5a77042bnNS7idfl5OZnHInRCbLJFb7HVbM6dlYVK0QVJXUvDaYsdLW1XWFDZnqeWavMWkljIzPK8LUTIjcl5wadJXcNLcN-4CIiaS2tS6QOkM10dCavRRKqYdQ2nHTB_4oUuVCcTilN_iu_ILjKRULQ6KcFABhz4MO6UfLa_Gw-IfCatOlEix_QcEQYUxplKsNrqr-Mh4VlHOd5dzwV2SVdLIgvWhR8B1hQTM-jA4IK_CAN4o1JO5oPnq9b-13sPpbPl1ruZfFtdv4Iwq2-7MDOBku965t_DY_Nzebdbv_F_6CyhT4UM |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Multi-Dimensional+Data+Compression+and+Query+Processing+in+Array+Databases&rft.jtitle=IEEE+access&rft.au=Kim%2C+Minsoo&rft.au=Lee%2C+Hyubjin&rft.au=Chung%2C+Yon+Dohn&rft.date=2022&rft.issn=2169-3536&rft.eissn=2169-3536&rft.volume=10&rft.spage=111528&rft.epage=111544&rft_id=info:doi/10.1109%2FACCESS.2022.3215525&rft.externalDBID=n%2Fa&rft.externalDocID=10_1109_ACCESS_2022_3215525 |
| thumbnail_l | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=2169-3536&client=summon |
| thumbnail_m | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=2169-3536&client=summon |
| thumbnail_s | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=2169-3536&client=summon |