System and method for determining an index of an object in a sequence of objects

A non-transitory computer-readable storage medium having embedded thereon computer-readable code for determining an index of an object in a sequence of objects forming a result set of a computer database query, the computer-readable code comprising program code for:

• obtaining a unique identifier value of a given object O;
• obtaining a query definition Q of a sequence, the Q query including an order definition according to a parameter of the O object;
• constructing a Q′ query based on the Q query, the Q′ query being different from the Q query by having a reversed ordering of results, with respect to the Q query, and providing results having said parameter value of objects preceeding or matching the parameter value of the object O in the sequence of objects in the Q query result set;
• executing the Q′ query by a query execution engine;
• checking whether the object O is present as the first item in Q′ result set and in case it is, obtaining the index of the O object in Q sequence by retrieving objects count of the Q′ result set.

A system for determining an index of an object in a sequence of objects forming a result set of a computer database query, the system comprising:

• an object O register configured to store a unique identifier value of a given object O;
• a source query Q register configured to store a query definition Q of a sequence, the Q query including an order definition according to a parameter of the O object;
• a destination query register configured to store a newly constructed Q′ query based on the Q query;
• wherein a source query order inverter is configured to reverse ordering of results, with respect to the Q query;
• a controller configured to obtain the output of the source query order inverter and define the Q′ query, the Q′ query being different from the Q query by, providing results having parameter's value of objects preceding or matching the parameter value of the object O in the sequence of objects in the Q query result set;
• the controller being further configured to:
• request execution of the Q′ query by a query execution engine and check whether the object O is present as the first item in Q′ result set, and if it is, “obtain the index of the O object in Q sequence by retrieving objects count of Q′ result set.