{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,5,16]],"date-time":"2025-05-16T04:04:58Z","timestamp":1747368298085,"version":"3.40.5"},"reference-count":79,"publisher":"Springer Science and Business Media LLC","issue":"3","license":[{"start":{"date-parts":[[2025,3,19]],"date-time":"2025-03-19T00:00:00Z","timestamp":1742342400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2025,3,19]],"date-time":"2025-03-19T00:00:00Z","timestamp":1742342400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"DOI":"10.13039\/100006919","name":"Massachusetts Institute of Technology","doi-asserted-by":"crossref","id":[{"id":"10.13039\/100006919","id-type":"DOI","asserted-by":"crossref"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["The VLDB Journal"],"published-print":{"date-parts":[[2025,5]]},"abstract":"<jats:title>Abstract<\/jats:title>\n          <jats:p>This paper evaluates the suitability of Apache Arrow, Parquet, and ORC as formats for subsumption in an analytical DBMS. We systematically identify and explore the high-level features that are important to support efficient querying in modern OLAP DBMSs and evaluate the ability of each format to support these features. We find that each format has trade-offs that make it more or less suitable for use as a format in a DBMS and identify opportunities to more holistically co-design a unified in-memory and on-disk data representation. Notably, for certain popular machine learning tasks, none of these formats perform optimally, highlighting significant opportunities for advancing format design. Our hope is that this study can be used as a guide for system developers designing and using these formats, as well as provide the community with directions to pursue for improving these common open formats.<\/jats:p>","DOI":"10.1007\/s00778-025-00911-1","type":"journal-article","created":{"date-parts":[[2025,3,19]],"date-time":"2025-03-19T11:52:13Z","timestamp":1742385133000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Data formats in analytical DBMSs: performance trade-offs and future directions"],"prefix":"10.1007","volume":"34","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-1481-2678","authenticated-orcid":false,"given":"Chunwei","family":"Liu","sequence":"first","affiliation":[]},{"given":"Anna","family":"Pavlenko","sequence":"additional","affiliation":[]},{"given":"Matteo","family":"Interlandi","sequence":"additional","affiliation":[]},{"given":"Brandon","family":"Haynes","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2025,3,19]]},"reference":[{"key":"911_CR1","doi-asserted-by":"crossref","unstructured":"Ramakrishnan, R., Sridharan, B., Douceur, J.R., Kasturi, P., Krishnamachari-Sampath, B., Krishnamoorthy, K., Li, P., Manu, M., Michaylov, S., Ramos, R., Sharman, N., Xu, Z., Barakat, Y., Douglas, C., Draves, R., Naidu, S.S., Shastry, S., Sikaria, A., Sun, S., Venkatesan, R.: Azure data lake store: A hyperscale distributed file service for big data analytics. In SIGMOD, 2017, pages 51\u201363","DOI":"10.1145\/3035918.3056100"},{"key":"911_CR2","unstructured":"Apache Software Foundation. Apache parquet. parquet.apache.org. Accessed: 2024"},{"key":"911_CR3","unstructured":"Apache Software Foundation. Apache ORC. orc.apache.org. Accessed: 2024"},{"key":"911_CR4","unstructured":"Armbrust, M., Ghodsi, A., Xin, R., Zaharia, M.: Lakehouse: a new generation of open platforms that unify data warehousing and advanced analytics. In CIDR, 2021"},{"key":"911_CR5","unstructured":"Apache Software Foundation. Apache arrow. arrow.apache.org. Accessed: 2024"},{"key":"911_CR6","doi-asserted-by":"crossref","unstructured":"Rodriguez, S.A., Chackrabroty, J., Chu, A., Jimenez, I., LeFevre, J., Maltzahn, C., Uta, A.: Zero-cost, Arrow-enabled data interface for Apache Spark. In Big Data, 2021, pages 2400\u20132405","DOI":"10.1109\/BigData52589.2021.9671595"},{"key":"911_CR7","unstructured":"Dremio. dremio.com. Accessed: 2024"},{"issue":"5","key":"911_CR8","volume":"32","author":"T Ivanov","year":"2020","unstructured":"Ivanov, T., Pergolesi, M.: The impact of columnar file formats on SQL-on-Hadoop engine performance: A study on ORC and parquet. CCPE 32(5), e5523 (2020)","journal-title":"CCPE"},{"key":"911_CR9","unstructured":"Abadi, D.: Apache arrow versus parquet and ORC: do we really need a third apache project for columnar data representation? dbmsmusings.blogspot.com\/2017\/10\/apache-arrow-vs-parquet-and-orc-do-we.html. Accessed: 2024"},{"key":"911_CR10","unstructured":"McKinney, W.: Some comments to Daniel Abadi\u2019s blog about Apache Arrow. wesmckinney.com\/blog\/arrow-columnar-abadi, (Nov 2017). Accessed: 2024"},{"issue":"2","key":"911_CR11","doi-asserted-by":"publisher","first-page":"148","DOI":"10.14778\/3626292.3626298","volume":"17","author":"X Zeng","year":"2023","unstructured":"Zeng, X., Hui, Y., Shen, J., Pavlo, A., McKinney, W., Zhang, H.: An empirical evaluation of columnar storage formats. Proc. VLDB Endow. 17(2), 148\u2013161 (2023)","journal-title":"Proc. VLDB Endow."},{"issue":"4","key":"911_CR12","first-page":"534","volume":"14","author":"T Li","year":"2020","unstructured":"Li, T., Butrovich, M., Ngom, A., Lim, W.S., McKinney, W., Pavlo, A.: Mainlining databases: supporting fast transactional workloads on universal columnar data file formats. VLDB 14(4), 534\u2013546 (2020)","journal-title":"VLDB"},{"key":"911_CR13","unstructured":"Ferrari, A., Russo, M.: The definitive guide to DAX: Business intelligence with Microsoft Excel, SQL server analysis services, and Power BI. Microsoft Press, 2015"},{"issue":"3","key":"911_CR14","doi-asserted-by":"publisher","first-page":"197","DOI":"10.1561\/1900000024","volume":"5","author":"D Abadi","year":"2013","unstructured":"Abadi, D., Boncz, P.A., Harizopoulos, S., Idreos, S., Madden, S.: The design and implementation of modern column-oriented database systems. Found. Trends Databases 5(3), 197\u2013280 (2013)","journal-title":"Found. Trends Databases"},{"key":"911_CR15","unstructured":"Jain, P., Kraft, P., Power, C., Das, T., Stoica, I., Zaharia, M.: Analyzing and comparing lakehouse storage systems. In CIDR, 2023"},{"key":"911_CR16","doi-asserted-by":"crossref","unstructured":"Gracia-Tinedo, R., Sanchez-Artigas, M., Garcia-Lopez, P., Moatti, Y., Gluszak, F.: Lamda-flow: automatic pushdown of dataflow operators close to the data. CCGRID, 2019, pages 112\u2013121","DOI":"10.1109\/CCGRID.2019.00022"},{"issue":"11","key":"911_CR17","first-page":"2101","volume":"14","author":"Y Yang","year":"2021","unstructured":"Yang, Y., Youill, M., Woicik, M., Liu, Y., Yu, X., Serafini, M., Aboulnaga, A., Stonebraker, M.: FlexPushdownDB: hybrid pushdown and caching in a cloud DBMS. VLDB 14(11), 2101\u20132113 (2021)","journal-title":"VLDB"},{"key":"911_CR18","doi-asserted-by":"crossref","unstructured":"D.\u00a0J. Abadi, S.\u00a0R. Madden, and N.\u00a0Hachem. Column-stores versus row-stores: how different are they really? In SIGMOD, 2008, pages 967\u2013980","DOI":"10.1145\/1376616.1376712"},{"key":"911_CR19","doi-asserted-by":"crossref","unstructured":"Abadi, D., Madden, S., Ferreira, M.: Integrating compression and execution in column-oriented database systems. SIGMOD, 2006, pages 671\u2013682","DOI":"10.1145\/1142473.1142548"},{"key":"911_CR20","doi-asserted-by":"crossref","unstructured":"Zhang, F., Wan, W., Zhang, C., Zhai, J., Chai, Y., Li, H., Du, X.: CompressDB: Enabling efficient compressed data direct processing for various databases. In SIGMOD, 2022, pages 1655\u20131669","DOI":"10.1145\/3514221.3526130"},{"key":"911_CR21","doi-asserted-by":"crossref","unstructured":"Li, Y., Patel, J.M.: BitWeaving: fast scans for main memory data processing. In SIGMOD, 2013, pages 289\u2013300","DOI":"10.1145\/2463676.2465322"},{"key":"911_CR22","doi-asserted-by":"crossref","unstructured":"Hentschel, B., Kester, M.S., Idreos, S.: Column sketches: A scan accelerator for rapid and robust predicate evaluation. In SIGMOD, 2018, pages 857\u2013872","DOI":"10.1145\/3183713.3196911"},{"key":"911_CR23","doi-asserted-by":"crossref","unstructured":"Jiang, H., Elmore, A.J.: Boosting data filtering on columnar encoding with SIMD. In DaMoN, 2018, pages 1\u201310","DOI":"10.1145\/3211922.3211932"},{"issue":"7","key":"911_CR24","first-page":"807","volume":"12","author":"Z Wang","year":"2019","unstructured":"Wang, Z., Kara, K., Zhang, H., Alonso, G., Mutlu, O., Zhang, C.: Accelerating generalized linear models with MLWeaving: a one-size-fits-all system for any-precision learning. VLDB 12(7), 807\u2013821 (2019)","journal-title":"VLDB"},{"key":"911_CR25","doi-asserted-by":"crossref","unstructured":"Jiang, H., Liu, C., Paparrizos, J., Chien, A.A., Ma, J., Elmore, A.J.: Good to the last bit: data-driven encoding with CodecDB. In SIGMOD, 2021, pages 843\u2013856","DOI":"10.1145\/3448016.3457283"},{"issue":"11","key":"911_CR26","first-page":"2586","volume":"14","author":"C Liu","year":"2021","unstructured":"Liu, C., Jiang, H., Paparrizos, J., Elmore, A.J.: Decomposed bounded floats for fast compression and queries. VLDB 14(11), 2586\u20132598 (2021)","journal-title":"VLDB"},{"key":"911_CR27","unstructured":"Pindikura, R.: Gandiva. dremio.com\/blog\/announcing-gandiva-initiative-for-apache-arrow. Accessed: 2024"},{"key":"911_CR28","unstructured":"Graefe, G., Shapiro, L.D.: Data compression and database performance. University of Colorado, Boulder, Department of Computer Science, 1990"},{"issue":"3","key":"911_CR29","doi-asserted-by":"publisher","first-page":"31","DOI":"10.1145\/163090.163096","volume":"22","author":"MA Roth","year":"1993","unstructured":"Roth, M.A., Van Horn, S.J.: Database compression. SIGMOD 22(3), 31\u201339 (1993)","journal-title":"SIGMOD"},{"key":"911_CR30","unstructured":"Paparrizos, J., Liu, C., Barbarioli, B., Hwang, J., Edian, I., Elmore, A.J., Franklin, M.J., Krishnan, S.: VergeDB: A database for IoT analytics on edge devices. In CIDR, 2021"},{"key":"911_CR31","doi-asserted-by":"crossref","unstructured":"Deutsch P. et\u00a0al.: Gzip file format specification version 4.3. Technical report, RFC 1952, 1996","DOI":"10.17487\/rfc1952"},{"key":"911_CR32","unstructured":"Google. Snappy: a fast compressor\/decompressor. google.github.io\/snappy. Accessed: 2024"},{"key":"911_CR33","unstructured":"Gailly, J.-l., Adler, M.: Zlib compression library. 2004"},{"key":"911_CR34","doi-asserted-by":"crossref","unstructured":"Shi, J.: Column partition and permutation for run length encoding in columnar databases. In: SIGMOD, 2020, pages 2873\u20132874","DOI":"10.1145\/3318464.3384413"},{"key":"911_CR35","unstructured":"Liu, C.: Fast and effective compression for iot systems, 2022"},{"issue":"2","key":"911_CR36","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/3589263","volume":"1","author":"M Kuschewski","year":"2023","unstructured":"Kuschewski, M., Sauerwein, D., Alhomssi, A., Leis, V.: Btrblocks: efficient columnar compression for data lakes. Proceed. ACM Manag. Data 1(2), 1\u201326 (2023)","journal-title":"Proceed. ACM Manag. Data"},{"issue":"5","key":"911_CR37","doi-asserted-by":"publisher","first-page":"1245","DOI":"10.1109\/TVCG.2006.143","volume":"12","author":"P Lindstrom","year":"2006","unstructured":"Lindstrom, P., Isenburg, M.: Fast and efficient compression of floating-point data. IEEE Trans. Visual Comput. Graphics 12(5), 1245\u20131250 (2006)","journal-title":"IEEE Trans. Visual Comput. Graphics"},{"key":"911_CR38","doi-asserted-by":"crossref","unstructured":"Gupta, A., Agarwal, D., Tan, D., Kulesza, J., Pathak, R., Stefani, S., Srinivasan, V.: Amazon Redshift and the case for simpler data warehouses. In SIGMOD, 2015, pages 1917\u20131923","DOI":"10.1145\/2723372.2742795"},{"key":"911_CR39","doi-asserted-by":"crossref","unstructured":"Larson, P.-\u00c5., Clinciu, C., Hanson, E.N., Oks, A., Price, S.L., Rangarajan, S., Surna, A., Zhou, Q.: SQL Server column store indexes. In SIGMOD, 2011, pages 1177\u20131184","DOI":"10.1145\/1989323.1989448"},{"key":"911_CR40","doi-asserted-by":"crossref","unstructured":"Liu, C., Umbenhower, M., Jiang, H., Subramaniam, P., Ma, J., Elmore, A.J.: Mostly order preserving dictionaries. In ICDE, 2019, pages 1214\u20131225","DOI":"10.1109\/ICDE.2019.00111"},{"issue":"6","key":"911_CR41","first-page":"925","volume":"13","author":"H Jiang","year":"2020","unstructured":"Jiang, H., Liu, C., Jin, Q., Paparrizos, J., Elmore, A.J.: PIDS: attribute decomposition for improved compression and query performance in columnar storage. VLDB 13(6), 925\u2013938 (2020)","journal-title":"VLDB"},{"key":"911_CR42","doi-asserted-by":"crossref","unstructured":"Liu, C., Paparrizos, J., Elmore, A.J.: Adaedge: A dynamic compression selection framework for resource constrained devices. In 2024 IEEE 40th International Conference on Data Engineering (ICDE), 2024, pages 1506\u20131519","DOI":"10.1109\/ICDE60146.2024.00124"},{"key":"911_CR43","first-page":"2649","volume":"13","author":"P Boncz","year":"2020","unstructured":"Boncz, P., Neumann, T., Leis, V.: FSST: fast random access string compression. VLDB 13, 2649\u20132661 (2020)","journal-title":"VLDB"},{"key":"911_CR44","doi-asserted-by":"crossref","unstructured":"Zeng, X., Meng, R., Pavlo, A., McKinney, W., Zhang, H.: Nulls!: Revisiting null representation in modern columnar formats. In Proceedings of the 20th international workshop on data management on new hardware, 2024, pages 1\u201310","DOI":"10.1145\/3662010.3663452"},{"key":"911_CR45","unstructured":"Apache Software Foundation. Apache feather. arrow.apache.org\/docs\/python\/feather.html. Accessed: 2024"},{"issue":"1\u20132","key":"911_CR46","first-page":"330","volume":"3","author":"S Melnik","year":"2010","unstructured":"Melnik, S., Gubarev, A., Long, J.J., Romer, G., Shivakumar, S., Tolton, M., Vassilakis, T.: Dremel: interactive analysis of web-scale datasets. VLDB 3(1\u20132), 330\u2013339 (2010)","journal-title":"VLDB"},{"key":"911_CR47","unstructured":"What is the difference between apache drill\u2019s valuevectors and apache arrow? - stack overflow. stackoverflow.com\/questions\/53533506\/what-is-the-difference-between-apache-drills-aluevectors-and-apache-arrow. (Accessed on 09\/18\/2024)"},{"key":"911_CR48","unstructured":"Join Order Benchmark (JOB). github.com\/gregrahn\/join-order-benchmark. [Accessed: 2024]"},{"key":"911_CR49","unstructured":"Public BI benchmark. github.com\/cwida\/public_bi_benchmark. [Accessed: 2024]"},{"key":"911_CR50","unstructured":"Datasets. huggingface.co\/docs\/datasets\/index. (Accessed on 09\/11\/2024)"},{"key":"911_CR51","unstructured":"Nambiar, R.O., Poess, M.: The making of TPC-DS. In VLDB, 2006, pages 1049\u20131058"},{"key":"911_CR52","unstructured":"Li, X., Li, J.: Angle-optimized text embeddings, 2023. arXiv preprint arXiv:2309.12871"},{"key":"911_CR53","unstructured":"Rui\u00a0Meng, S.R.J.C.X.Y.Z.S.Y., Liu, Ye: Sfr-embedding-mistral: enhance text retrieval with transfer learning. Salesforce AI Research Blog, 2024"},{"key":"911_CR54","unstructured":"Pyarrow - apache arrow python bindings v17.0.0. arrow.apache.org\/docs\/python\/index.html. (Accessed on 09\/20\/2024)"},{"key":"911_CR55","unstructured":"lance. github.com\/lancedb\/lance. (Accessed on 09\/19\/2024)"},{"issue":"12","key":"911_CR56","first-page":"3372","volume":"15","author":"P Pedreira","year":"2022","unstructured":"Pedreira, P., Erling, O., Basmanova, M., Wilfong, K., Sakka, L.S., Pai, K., He, W., Chattopadhyay, B.: Velox: meta\u2019s unified execution engine. VLDB 15(12), 3372\u20133384 (2022)","journal-title":"VLDB"},{"key":"911_CR57","unstructured":"InfluxData. Querying Parquet with millisecond latency. influxdata.com\/blog\/querying-parquet-millisecond-latency, (December 2022). Accessed: 2024"},{"key":"911_CR58","unstructured":"Agarwal, R., Khandelwal, A., Stoica, I.: Succinct: Enabling queries on compressed data. In NSDI, 2015, pages 337\u2013350"},{"key":"911_CR59","unstructured":"Trivedi, A., Stuedi, P., Pfefferle, J., Schuepbach, A., Metzler, B.: Albis: High-performance file format for big data systems. In USENIX, 2018, page 615-629"},{"issue":"12","key":"911_CR60","first-page":"1295","volume":"7","author":"A Floratou","year":"2014","unstructured":"Floratou, A., Minhas, U.F., \u00d6zcan, F.: SQL-on-Hadoop: Full circle back to shared-nothing database architectures. VLDB 7(12), 1295\u20131306 (2014)","journal-title":"VLDB"},{"key":"911_CR61","doi-asserted-by":"crossref","unstructured":"Pirzadeh, P., Carey, M., Westmann, T.: A performance study of big data analytics platforms. In Big Data, 2017, pages 2911\u20132920","DOI":"10.1109\/BigData.2017.8258260"},{"issue":"1","key":"911_CR62","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1002\/spe.2203","volume":"45","author":"D Lemire","year":"2015","unstructured":"Lemire, D., Boytsov, L.: Decoding billions of integers per second through vectorization. Softw. Pract. Exp. 45(1), 1\u201329 (2015)","journal-title":"Softw. Pract. Exp."},{"key":"911_CR63","unstructured":"Comma-separated values. en.wikipedia.org\/wiki\/Comma-separated_values. Accessed: 2024"},{"key":"911_CR64","unstructured":"Json (javascript object notation). www.json.org\/json-en.html. Accessed: 2024"},{"key":"911_CR65","unstructured":"Apache Software Foundation. Apache carbonData. carbondata.apache.org. Accessed: 2024"},{"key":"911_CR66","doi-asserted-by":"crossref","unstructured":"Vohra, D.: Apache Avro. In Practical Hadoop Ecosystem, 2016, pages 303\u2013323","DOI":"10.1007\/978-1-4842-2199-0_7"},{"key":"911_CR67","unstructured":"pickle - python object serialization - python 3.12.6 documentation. docs.python.org\/3\/library\/pickle.html. (Accessed on 09\/18\/2024)"},{"key":"911_CR68","unstructured":"Saving and loading models for inference in pytorch. pytorch.org\/tutorials\/recipes\/recipes\/saving_and_loading_models_for_inference.html. (Accessed on 09\/18\/2024)"},{"key":"911_CR69","unstructured":"Npy format. numpy.org\/devdocs\/reference\/generated\/numpy.libformat.html. (Accessed on 09\/18\/2024)"},{"key":"911_CR70","unstructured":"Liao, G., Liu, Y., Chen, J., Abadi, D.J.: Bullion: A column store for machine learning. In Proceedings of the 15th Annual Conference on Innovative Data Systems Research (CIDR \u201925), Amsterdam, The Netherlands, Jan 19\u201322, 2025"},{"key":"911_CR71","unstructured":"Vortex. github.com\/spiraldb\/vortex. (Accessed on 02\/19\/2025)"},{"issue":"9","key":"911_CR72","doi-asserted-by":"publisher","first-page":"2132","DOI":"10.14778\/3598581.3598587","volume":"16","author":"A Afroozeh","year":"2023","unstructured":"Afroozeh, A., Boncz, P.: The fastlanes compression layout: Decoding> 100 billion integers per second with scalar code. Proceed. VLDB Endow. 16(9), 2132\u20132144 (2023)","journal-title":"Proceed. VLDB Endow."},{"key":"911_CR73","unstructured":"The nimble file format. github.com\/facebookincubator\/nimble. (Accessed on 02\/19\/2025)"},{"key":"911_CR74","unstructured":"The hdf5\u00ae library and file format. www.hdfgroup.org\/solutions\/hdf5\/. (Accessed on 09\/20\/2024)"},{"key":"911_CR75","unstructured":"Apache Software Foundation. ColumnIndex layout to support page skipping. github.com\/apache\/parquet-format\/blob\/master\/PageIndex.md. Accessed: 2024"},{"key":"911_CR76","doi-asserted-by":"crossref","unstructured":"Yang, Z., Chandramouli, B., Wang, C., Gehrke, J., Li, Y., Minhas, U.F., Larson, P.-\u00c5., Kossmann, D., Acharya, R.: Qd-tree: Learning data layouts for big data analytics. In SIGMOD, 2020, pages 193\u2013208","DOI":"10.1145\/3318464.3389770"},{"key":"911_CR77","unstructured":"Madden, S., Ding, J., Kraska, T., Sudhir, S., Cohen, D., Mattson, T., Tatbul, N.: Self-organizing data containers. Memory 1, 2 (2022)"},{"key":"911_CR78","doi-asserted-by":"crossref","unstructured":"Kang, D., Jiang, R., Blanas, S.: Jigsaw: A data storage and query processing engine for irregular table partitioning. In SIGMOD, 2021, pages 898\u2013911","DOI":"10.1145\/3448016.3457547"},{"key":"911_CR79","doi-asserted-by":"crossref","unstructured":"Bian, H., Ailamaki, A.: Pixels: An efficient column store for cloud data lakes. In ICDE, 2022, pages 3078\u20133090","DOI":"10.1109\/ICDE53745.2022.00276"}],"container-title":["The VLDB Journal"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s00778-025-00911-1.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s00778-025-00911-1\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s00778-025-00911-1.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,5,15]],"date-time":"2025-05-15T11:28:48Z","timestamp":1747308528000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s00778-025-00911-1"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,3,19]]},"references-count":79,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2025,5]]}},"alternative-id":["911"],"URL":"https:\/\/doi.org\/10.1007\/s00778-025-00911-1","relation":{},"ISSN":["1066-8888","0949-877X"],"issn-type":[{"type":"print","value":"1066-8888"},{"type":"electronic","value":"0949-877X"}],"subject":[],"published":{"date-parts":[[2025,3,19]]},"assertion":[{"value":"20 September 2024","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"20 February 2025","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"25 February 2025","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"19 March 2025","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}],"article-number":"30"}}