Method and system for executing database insert calls in a MES system
View Patent ↗A method and a system execute database insert calls in a MES system. The data to be stored into the database are represented in XML tree formats according to the S95 hierarchy model. The method includes: a) receiving as input a given XML tree corresponding to a given S95 hierarchy data to stored into the database; b) processing the given XML tree in order to generate a corresponding parallel structure; c) getting a given S95 entity type and its given set of node references from the given parallel structure; d) if the given set of node references is not empty, composing a database insert call passing the information of the given set of node references; e) if the given set of node references is not empty, executing the composed database insert call; and executing items c) to e) for all the S95 entity types of the given parallel structure.
1. A method for executing database insert calls in a MES system, wherein data to be stored into a database are represented in XML tree formats according to a S95 hierarchy model in which each XML tree node is representing a specific S95 entity, which method comprises the steps of:
a) receiving as an input a given XML tree corresponding to given S95 hierarchy data to be stored into the database;
b) processing the given XML tree for generating a corresponding parallel structure, the processing step including the following sub-steps:
b1) grouping all tree nodes according to their MES type into a set of entity types;
b2) storing, for each entity type, a set of references pointing to each tree node of an entity type;
b3) generating the parallel structure corresponding to the given XML tree by storing the set of entity types and corresponding sets of node references;
c) getting a given S95 entity type and the corresponding set of node references from the parallel structure;
d) for the given S95 entity type, determining that the corresponding set of node references is not empty, composing a database insert call passing information of the given set of node references;
e) for the given S95 entity type, determining that the corresponding set of node references is not empty, executing the database insert call of step d); and
f) executing steps c) to e) for all the S95 entity types of the parallel structure.
2. The method according to claim 1 , wherein the method is implemented in software.
3. A system, comprising:
means for performing a method for executing database insert calls in a MES system, wherein data to be stored into a database are represented in XML tree formats according to a S95 hierarchy model in which each XML tree node is representing a specific S95 entity, said means programmed to:
a) receive as an input a given XML tree corresponding to given S95 hierarchy data to be stored into the database;
b) process the given XML tree for generating a corresponding parallel structure, the processing step including the following sub-steps:
b1) group all tree nodes according to an MES type into a set of entity types;
b2) store, for each entity type, a set of references pointing to each tree node of the entity type;
b3) generate the parallel structure corresponding to the given XML tree by storing the set of entity types and corresponding sets of node references;
c) get a given S95 entity type and the corresponding set of node references from the parallel structure;
d) for the given S95 entity type, determining that the corresponding set of node references is not empty, compose a database insert call passing information of the corresponding set of node references;
e) for the given S95 entity type, determining that the corresponding set of node references is not empty, execute the database insert call of step d); and
f) execute steps c) to e) for all the S95 entity types of the parallel structure.
4. A non-transitory computer readable medium having computer-executable instructions for performing a method for executing database insert calls in a MES system, wherein data to be stored into a database are represented in XML tree formats according to a S95 hierarchy model in which each XML tree node is representing a specific S95 entity, which method comprises the steps of:
a) receiving as an input a given XML tree corresponding to given S95 hierarchy data to be stored into the database;
b) processing the given XML tree for generating a corresponding parallel structure, the processing step including the following sub-steps:
b1) grouping all tree nodes according to an MES type into a set of entity types;
b2) storing, for each entity type, a set of references pointing to each tree node of the entity type;
b3) generating the parallel structure corresponding to the given XML tree by storing a set of entity types and corresponding sets of node references;
c) getting a given S95 entity type and the corresponding set of node references from the parallel structure;
d) for the given S95 entity type, determining that the corresponding set of node references is not empty, composing a database insert call passing information of the corresponding set of node references;
e) for the given S95 entity type, determining that the corresponding set of node references is not empty, executing (S 5 ) the database insert call of step d); and
f) executing steps c) to e) for all the S95 entity types of the parallel structure.