The invention relates to the technical field of
aviation, in particular to an order data creation, query and modification method and device, and the method comprises the steps: receiving
data information of an order created by a passenger for the first time; generating order data in an
XML format containing the SPNRID by using the
data information of the order created for the first time; the method comprises the following steps: splitting order data in an
XML format into a plurality of
XML node fragments taking SPNRID as a
primary key according to business meanings; each XML node segment with the SPNRID as the
primary key is stored in an
XML DATA field of a CLOB type of a specified data table, and each data table takes the SPNRID as the
primary key. The super passenger reservation
record SPNR is created by using a standardized XML format, the SPNR is split and then stored in each
database table, a data table does not need to be newly added in a
database along with the increase of order types, a field does not need to be independently added for each piece of new order information, the design of the
database is simplified, and the efficiency is improved. And the complexity and the
coupling degree of the
system are greatly reduced, so that the maintenance of the
system is simpler and more convenient.