- 专利标题: Manipulating a table with an XML column in a database
-
申请号: US16407220申请日: 2019-05-09
-
公开(公告)号: US11860939B2公开(公告)日: 2024-01-02
- 发明人: Xin Peng Liu , Shuo Li , Xiaobo Wang , ShengYan Sun , Kwai Hing Man
- 申请人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 代理商 Tihon Poltavets
- 主分类号: G06F16/832
- IPC分类号: G06F16/832 ; G06F16/81 ; G06F16/22 ; G06F16/835
摘要:
Embodiments of the disclosure provide methods, systems, computer program products for manipulating a table with an XML column in database. According to the method, a SQL statement for a table is received first, wherein the table comprises an XML column which is a representation of a plurality of logical columns of the table, there is at least one XML element in at least one row and in the XML column of the table, and each of the at least one XML element corresponds to a non-null value in a specific row and in a logical column of the plurality of logical columns of the table. Then the SQL statement is parsed. And then the SQL statement is transformed into a hybrid statement being able to process the XML column in response to the parsing result indicating that the SQL statement relates to at least one logical column of the plurality of logical columns. At last the hybrid statement is executed.
信息查询