Invention Grant
- Patent Title: Manipulating a table with an XML column in a database
-
Application No.: US16407220Application Date: 2019-05-09
-
Publication No.: US11860939B2Publication Date: 2024-01-02
- Inventor: Xin Peng Liu , Shuo Li , Xiaobo Wang , ShengYan Sun , Kwai Hing Man
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Tihon Poltavets
- Main IPC: G06F16/832
- IPC: G06F16/832 ; G06F16/81 ; G06F16/22 ; G06F16/835

Abstract:
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.
Information query