{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,11]],"date-time":"2026-03-11T16:41:30Z","timestamp":1773247290893,"version":"3.50.1"},"reference-count":7,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2022,2,18]],"date-time":"2022-02-18T00:00:00Z","timestamp":1645142400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2022,2,18]],"date-time":"2022-02-18T00:00:00Z","timestamp":1645142400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"name":"Technische Hochschule Rosenheim"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Datenbank Spektrum"],"published-print":{"date-parts":[[2022,7]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>Recently, the SQL standardization Committee published a\u00a0specification for support of the concept called Row Pattern Recognition in SQL. That way, the focus for the members of the Committee turned back to a\u00a0kernel issue of the language, after standardizing the storage and manipulation of data formats, such as XML and JSON. In this paper we discuss the specified features using several examples and show to what extent different relational database systems as well as Data Analytics tools have integrated them. At the end of the paper, we describe the main inaccuracies of the proposal and the ways how to solve them. From our point of view, the following should be modified in one of the future proposals of the standard in relation to this concept: (a)\u00a0Naming of several pattern navigation operations is inappropriate and should be changed; (b)\u00a0The concept of implicit definition for row pattern variables in DEFINE should be changed to explicit; (c)\u00a0The set of existing functions should be extended.<\/jats:p>","DOI":"10.1007\/s13222-022-00404-3","type":"journal-article","created":{"date-parts":[[2022,2,18]],"date-time":"2022-02-18T15:16:24Z","timestamp":1645197384000},"page":"163-174","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["Specification of Row Pattern Recognition in the SQL Standard and its Implementations"],"prefix":"10.1007","volume":"22","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-5188-2811","authenticated-orcid":false,"given":"Du\u0161an","family":"Petkovi\u0107","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2022,2,18]]},"reference":[{"key":"404_CR1","unstructured":"ISO\/IEC TR 19075-5:2016 Information technology\u2014Database languages\u2014SQL Technical Reports\u2014Part 5: Row Pattern Recognition in SQ. https:\/\/standards.iteh.ai\/catalog\/standards\/iso\/2521dd59-7047-4938-a25a-2617fde630df\/iso-iec-tr-19075-5-2016. Accessed 8 Aug 2021"},{"key":"404_CR2","unstructured":"ISO\/IEC TR 19075-5:2016 Information technology\u2014Database languages\u2014SQL Technical Reports\u2014Part 2. https:\/\/www.iso.org\/standard\/63556.html. Accessed 15 Aug 2021"},{"key":"404_CR3","doi-asserted-by":"publisher","DOI":"10.1145\/3299887.3299897","author":"J Michels","year":"2018","unstructured":"Michels\u00a0J et\u00a0al (2018) The New and Improved SQL:2016 Standard. Sigmod Rec. https:\/\/doi.org\/10.1145\/3299887.3299897","journal-title":"Sigmod Rec"},{"key":"404_CR4","volume-title":"Mastering regular expressions","author":"J Friedl","year":"2006","unstructured":"Friedl\u00a0J (2006) Mastering regular expressions"},{"key":"404_CR5","unstructured":"Oracle 12c MATCH_RECOGNIZE. https:\/\/docs.oracle.com\/cd\/E28280_01\/apirefs.1111\/e12048\/pattern_recog.htm#CQLLR1531. Accessed 9 Jan 2021"},{"key":"404_CR6","unstructured":"MS Stream Analytics MATCH_RECOGNIZE. https:\/\/docs.microsoft.com\/en-us\/stream-analytics-query\/match-recognize-stream-analytics. Accessed 30 July 2021"},{"key":"404_CR7","unstructured":"Snowflake MATCH_RECOGNIZE. https:\/\/docs.snowflake.com\/en\/sql-reference\/constructs\/match_recognize.html. Accessed 9 Sept 2021"}],"container-title":["Datenbank-Spektrum"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-022-00404-3.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s13222-022-00404-3\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-022-00404-3.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,7,29]],"date-time":"2022-07-29T11:23:25Z","timestamp":1659093805000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s13222-022-00404-3"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,2,18]]},"references-count":7,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2022,7]]}},"alternative-id":["404"],"URL":"https:\/\/doi.org\/10.1007\/s13222-022-00404-3","relation":{},"ISSN":["1618-2162","1610-1995"],"issn-type":[{"value":"1618-2162","type":"print"},{"value":"1610-1995","type":"electronic"}],"subject":[],"published":{"date-parts":[[2022,2,18]]},"assertion":[{"value":"13 September 2021","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"24 January 2022","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"18 February 2022","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}