Method and system for storing and retrieving packaging and re-packaging relations

1. A method for storing and retrieving packaging and re-packaging hierarchical code relations ( 304 ) of traceable physical items ( 350 ), comprising the steps of:

in a first computer system ( 101 ) in a track and trace system ( 100 ),

generating ( 1 ) a set of unique codes ( 200 ),

each unique code ( 200 ) comprising a first identifier ( 201 ) and a second identifier ( 202 ), and encrypting said unique codes ( 200 );

transferring ( 2 ) said unique codes ( 200 ) from said first computer system ( 101 ) to a packaging computer system ( 301 ) at an item marking location ( 300 );

at said item marking location ( 300 ),

marking ( 3 ) two or more physical items ( 350 ) while establishing a physical packaging hierarchy ( 305 ), each physical item ( 350 ) with a said unique code ( 200 );

registering ( 4 ) packaging relations ( 303 ) in an aggregate data file ( 302 ) in said packaging computer system ( 301 ) during packaging of said marked physical items ( 350 ), said packaging relations ( 303 ) being relations between said code ( 200 ) of each containing marked physical item ( 350 ) and said code ( 200 ) of each contained marked physical items ( 350 ), and registering an initial item parameter ( 120 ) comprising time and place for the marking ( 3 );

transferring ( 5 ) said aggregate data file ( 302 ) with said packaging relations ( 303 ) between said codes ( 200 ) of said marked physical items ( 350 ) and said initial item parameters ( 120 ) from said packaging computer system ( 301 ), to said first computer system ( 101 );

in said first computer system ( 101 ),

decrypting said codes ( 200 ) to identify said first and second identifiers ( 201 , 202 );

identifying and generating ( 6 ) for each said code ( 200 ) in said packaging relations ( 303 ) in said aggregate data file ( 302 ), an initial hierarchical code relation ( 304 ) expressed as a sequence of codes including a current code ( 200 ),

a parent code ( 200 , P) relative to said current code ( 200 ), and

one or more child codes ( 200 , C) relative to said current code ( 200 ), based on said packaging relations ( 303 ); and

identifying said initial item parameter ( 120 ) for said current code ( 200 ), and

storing ( 7 ), for each said code ( 200 ), said parent code ( 200 , P) and said one or more child codes ( 200 , C) of said initial hierarchical code relations ( 304 ), and said initial item parameter ( 120 ), in a section ( 111 ) of a data storage location ( 110 ) of said first computer system ( 101 ), wherein a start position ( 112 ) of said section ( 111 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of said code ( 200 ) of said marked physical item ( 350 );

in a re-packaging location ( 400 ),

re-packaging ( 10 ) two or more of said physical items ( 350 ) into updated packaging relations ( 403 ) and registering updated item parameters ( 120 );

transferring ( 12 ) said updated packaging relations ( 403 ) with said updated item parameters ( 120 ) to said first computer system ( 101 ) of said track and trace system ( 100 );

in said track and trace system ( 100 ),

decrypting said codes ( 200 ) to identify said first and second identifiers ( 201 , 202 );

identifying and generating ( 13 ), for each said code ( 200 ) in said updated packaging relations ( 403 ), an updated hierarchical code relation ( 304 ) expressed as a sequence of codes including a current code ( 200 ), a parent code ( 200 , P) relative to said current code ( 200 ) and/or one more child codes ( 200 , C) relative to said current code ( 200 ) based on the updated packaging relations ( 403 ), and identifying said updated item parameter ( 120 ) for said current code ( 200 ); and

adding ( 14 ), for each said code ( 200 ), said parent code ( 200 , P) and/or said one more child codes ( 200 , C) of said updated hierarchical code relations ( 304 ), and said updated item parameter ( 120 ) to said section ( 111 ) of said data storage location ( 110 ) as an appendix to the previously stored sequence of codes representing said initial hierarchical code relation ( 304 ) and said initial item parameter ( 120 ),

 such that after re-packaging, for each code ( 200 ) of said two or more of said physical items ( 350 ), said section ( 111 ) of said data storage location ( 110 ) stores an updated sequence of codes ( 200 ) including both said initial hierarchical code relation ( 304 ), said initial item parameter ( 120 ), said updated hierarchical code relation ( 304 ), and said updated item parameter ( 120 ),

 wherein said method further comprises the step of retrieving ( 23 a ) one or more tracking records ( 130 ) for a parent marked physical item ( 350 ), wherein said tracking records ( 130 ) are stored in a second storage location ( 150 ) of said first computer ( 101 ) in said track and trace system ( 100 ), and wherein a position of said tracking records ( 130 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of a code ( 200 ) of a parent marked physical item ( 350 ) obtained in said step of retrieving ( 23 ) said packaging relationships ( 303 ) and updated packaging relationships ( 403 ).

2. The method according to claim 1 , said item parameter ( 120 ) further comprising

validity status about said marked physical item ( 350 ) such as not being for sale, said marked physical item ( 350 ) being withdrawn, or static information such as a serial number, or a time stamp, a flag or status such as recalled, rejected, quarantined, quality passed, returned, taxes paid,

a tracing location ( 500 ) that the code ( 200 ) is at currently;

during entering ( 20 ) for tracing ( 20 ) at a tracing location ( 500 ),

registering time and place for the marking, re-packaging or reading ( 20 ) as part of the item parameter ( 120 ), and storing ( 7 , 14 , 23 ) said item parameter ( 120 ) with said updated hierarchical code relations ( 304 ) in said section ( 111 ).

3. The method according to claim 1 , further comprising the steps of:

at a tracing location ( 500 );

entering ( 20 ) one or more codes ( 200 ) in a computer based terminal ( 501 ) in said tracing location ( 500 );

transferring ( 21 ) said codes ( 200 ) from said computer based terminal ( 501 ) to said track and trace system ( 100 );

in said track and trace system ( 100 );

decrypting said codes ( 200 ) to identify said first and second identifiers ( 201 , 202 );

identifying ( 22 ) said first and second identifiers ( 201 , 202 ) of said codes ( 200 )

determining said start position ( 112 ) of said section ( 111 ) of said storage location ( 110 ) in said track and trace system ( 100 );

retrieving ( 23 ) said hierarchical code relations ( 304 ), said initial item parameters ( 120 ), said updated hierarchical code relations ( 304 ), and said updated item parameters ( 120 ) stored in said section ( 111 ) for said codes ( 200 ); and

transferring ( 24 ) said hierarchical code relations ( 304 ), said initial item parameters ( 120 ), said updated hierarchical code relations ( 304 ), and said updated item parameters ( 120 ) for said codes ( 200 ) back to said computer based terminal ( 501 ).

4. The method according to claim 3 , said item parameter ( 120 ) further comprising:

at said tracing location ( 500 );

while transferring ( 21 ) said codes ( 200 ) from said computer based terminal ( 501 ) to said track and trace system ( 100 ), transferring a tracing location ( 500 ) that the code ( 200 ) is at currently;

in said track and trace system ( 100 );

adding said tracing location ( 500 ) that the code ( 200 ) is at currently, as part of said item parameter ( 120 ) in said section ( 111 ).

5. A track and trace system ( 100 ) arranged for storing ( 7 ) and retrieving ( 23 ) hierarchical code relations ( 304 ) during packaging and re-packaging of traceable physical items ( 350 ), comprising:

a first computer system ( 101 ) with one or more data storage locations ( 110 ), each with one or more sections ( 111 );

said first computer system ( 101 ) being configured to:

receive packaging relationships ( 303 ) between unique codes ( 200 ) marked on said physical items ( 350 ) at a packaging location ( 300 ), said packaging relationships ( 303 ) being pairwise relations between said code ( 200 ) of each containing marked physical item ( 350 ) and said code ( 200 ) of each contained marked physical items ( 350 ), from a packaging computer system ( 301 ) wherein each code ( 200 ) comprises at least a first identifier ( 201 ) and a second identifier ( 202 );

identify ( 6 ) hierarchical code relations ( 304 ) expressed as parent and/or one or more child codes ( 304 , P, C), said parent code ( 200 , P) being relative to said current code ( 200 ), and said one or more child codes ( 200 , C) being relative to said current code ( 200 ), for each said code ( 200 ) in said packaging relationships ( 303 ); and

store ( 7 ) said hierarchical code relations ( 304 , P, C) for each said code ( 200 ) in said section ( 111 ),

wherein said first computer system ( 101 ) is arranged for receiving an aggregate data file ( 302 ) comprising said packaging relationships ( 303 ) and identifying said hierarchical code relations ( 304 ) from said aggregate data file ( 302 ), and

wherein a start position ( 112 ) of said section ( 111 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of said code ( 200 ) of said marked physical item ( 350 ),

said first computer system ( 101 ) being further configured to:

receive updated packaging relationships ( 403 ) being transferred ( 12 ) from a re-packaging location ( 400 ), said updated packaging relationships ( 403 ) arising from re-packaging ( 10 ) of two or more said physical items ( 350 );

identify ( 13 ) for each said code ( 200 ) in said updated packaging relationships ( 403 ), updated hierarchical code relations ( 304 ) expressed as parent and/or child codes ( 200 , P, C); and

for each said code ( 200 ), add ( 14 ) said updated hierarchical code relations ( 304 ) to said section ( 111 ) of said data storage location ( 110 ),

wherein said track and trace system is further configured to retrieve ( 23 a ) one or more tracking records ( 130 ) for a containing “parent” marked physical item ( 350 ),

wherein said tracking records ( 130 ) are stored in a second storage location ( 150 ) of said first computer ( 101 ) in said track and trace system ( 100 ), and

wherein a position of said tracking records ( 130 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of a code ( 200 , P) of said containing “parent” marked physical item ( 350 ) obtained in said step of retrieving ( 23 ) said packaging relationships ( 303 ) and updated packaging relationships ( 403 ).

6. The system according to claim 5 , wherein said first computer system is further configured to:

transfer an item parameter ( 120 ) for each marked physical item ( 350 ) in said packaging relationships ( 303 ) in said aggregate data file ( 302 ),

identify said item parameter ( 120 ), and

store said item parameter ( 120 ) in said section ( 111 ).

7. The system according to claim 6 , wherein said first computer system is further configured to:

encrypt (E) said codes ( 200 ) with a unique key ( 303 ) before said codes ( 200 ) are marked on said physical items ( 350 ); and

decrypt (D) said codes ( 200 ) with said unique key ( 303 ).

8. A method for storing and retrieving packaging and re-packaging hierarchical code relations ( 304 ) of traceable physical items ( 350 ), comprising the steps of:

at an item marking location ( 300 ),

marking ( 3 ) two or more physical items ( 350 ) to be packaged in a packaging hierarchy ( 305 ), each with a unique code ( 200 ) comprising at least a first identifier ( 201 ) and a second identifier ( 202 );

registering ( 4 ), packaging relations ( 303 ) in an aggregate data file ( 302 ) in a packaging computer system ( 301 ) during packaging of said marked physical items ( 350 ), said packaging relationships ( 303 ) being relations between said code ( 200 ) of each containing marked physical item ( 350 ) and said code ( 200 ) of each contained marked physical items ( 350 ); and

transferring ( 5 ) said aggregate data file ( 302 ) with said packaging relationships ( 303 ) between said codes ( 200 ) of said marked physical items ( 350 ) from a packaging computer system ( 301 ), to a first computer system ( 101 ) of a track and trace system ( 100 );

in said first computer system ( 101 ),

identifying ( 6 ) for each said code ( 200 ) in said packaging relationships ( 303 ) in said aggregate data file ( 302 ), hierarchical code relations ( 304 ) expressed as parent and/or one or more child codes ( 200 , P, C), said parent code ( 200 , P) being relative to said current code ( 200 ), and said one or more child codes ( 200 , C) being relative to said current code ( 200 ); and

storing ( 7 ), for each said code ( 200 ), said hierarchical code relations ( 304 ) in a section ( 111 ) of a data storage location ( 110 ) of said first computer system ( 101 ), wherein a start position ( 112 ) of said section ( 111 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of said code ( 200 ) of said marked physical item ( 350 );

in a re-packaging location ( 400 ),

re-packaging ( 10 ) two or more said physical items ( 350 ) into updated packaging relationships ( 403 );

transferring ( 12 ) said updated packaging relationships ( 403 ) to said first computer system ( 101 ) of said track and trace system ( 100 );

in said track and trace system ( 100 ), identifying ( 13 ) for each said code ( 200 ) in said updated packaging relationships ( 403 ), updated hierarchical code relations ( 304 ) expressed as parent and/or child codes ( 200 , P, C); and

for each said code ( 200 ), adding ( 14 ) said updated hierarchical code relations ( 304 ) to said section ( 111 ) of said data storage location ( 110 ), in a tracing location ( 500 ),

entering ( 20 ) one or more codes ( 200 ) in a computer based terminal ( 501 );

transferring ( 21 ) said codes ( 200 ) from said tracing location ( 500 ) to said track and trace system ( 100 );

identifying ( 22 ) said first and second identifiers ( 201 , 202 ) of said codes ( 200 ) in said track and trace system ( 100 );

determining said start position ( 112 ) of said section ( 111 ) of said storage location ( 110 ) in said track and trace system ( 100 );

retrieving ( 23 ) said hierarchical code relations ( 304 ) and said updated hierarchical code relations ( 304 ) stored in said section ( 111 ) for said codes ( 200 ); and

transferring ( 24 ) said hierarchical code relations ( 304 ) and said updated hierarchical code relations ( 304 ) back to said computer based terminal ( 501 ),

wherein said method further comprises the step of retrieving ( 23 a ) one or more tracking records ( 130 ) for a containing “parent” marked physical item ( 350 ), wherein said tracking records ( 130 ) are stored in a second storage location ( 150 ) of said first computer ( 101 ) in said track and trace system ( 100 ), and wherein a position of said tracking records ( 130 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of a code ( 200 , P) of said containing “parent” marked physical item ( 350 ) obtained in said step of retrieving ( 23 ) said packaging relationships ( 303 ) and updated packaging relationships ( 403 ).

9. The method according to claim 8 , wherein the step of transferring ( 5 ) further comprises transferring an item parameter ( 120 ) for each marked physical item ( 350 ) in said packaging relationship structure ( 302 ), and said step of identifying ( 6 ) further comprises identifying said item parameter ( 120 ), and said step of storing ( 7 ) further comprises storing said item parameter ( 120 ) in said section ( 111 ).

10. The method according to claim 8 , further comprising the steps of:

encrypting (E) said codes ( 200 ) with a unique key ( 303 ) before said codes ( 200 ) are marked ( 3 ) on said physical items ( 350 ); and

decrypting (D) said codes ( 200 ) with said unique key ( 303 ).

11. A track and trace system ( 100 ) arranged for storing ( 7 ) and retrieving ( 23 ) packaging code relations ( 304 ) and re-packaging hierarchical code relations ( 304 ) of traceable physical items ( 350 ) in a packaging hierarchy ( 305 ), comprising:

an item marking location ( 300 ) configured to:

mark ( 3 ) two or more physical items ( 350 ) being packaged in said packaging hierarchy ( 305 ), each with a unique code ( 200 ) comprising at least a first identifier ( 201 ) and a second identifier ( 202 ),

register ( 4 ), in a packaging computer system ( 301 ), packaging relations ( 303 ) in an aggregate data file ( 302 ) during packaging of said marked physical items ( 350 ), said packaging relationships ( 303 ) being relations between said code ( 200 ) of each containing marked physical item ( 350 ) and said code ( 200 ) of each contained marked physical items ( 350 ), and

transfer ( 5 ) said aggregate data file ( 302 ) with said packaging relations ( 303 ) from said packaging computer system ( 301 ), to a first computer system ( 101 ) of the track and trace system ( 100 );

said first computer system ( 101 ) being configured to:

identify ( 6 ) for each said code ( 200 ) in said packaging relationships ( 303 ) in said aggregate data file ( 302 ), hierarchical code relations ( 304 ) expressed as parent and/or one or more child codes ( 200 , P, C), said parent code ( 200 , P) being relative to said current code ( 200 ), and said one or more child codes ( 200 , C) being relative to said current code ( 200 ); and

store ( 7 ), for each said code ( 200 ), said hierarchical code relations ( 304 ) in a section ( 111 ) of a data storage location ( 110 ) of said first computer system ( 101 ), wherein a start position ( 112 ) of said section ( 111 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of said code ( 200 ) of said marked physical item ( 350 );

a re-packaging location ( 400 ) being configured to:

re-package ( 10 ) two or more of said physical items ( 350 ) into updated packaging relationships ( 403 ),

transfer ( 12 ) said updated packaging relationships ( 403 ) to said first computer system ( 101 );

identify ( 13 ), in said track and trace system ( 100 ), for each said code ( 200 ) in said updated packaging relationships ( 403 ), updated hierarchical code relations ( 304 ) expressed as parent and/or child codes ( 200 , P, C); and

for each said code ( 200 ), add ( 14 ) said updated hierarchical code relations ( 304 ) to said section ( 111 ) of said data storage location ( 110 ); and

a tracing location ( 500 ) being configured to:

enter ( 20 ) one or more codes ( 200 ) in a computer based terminal ( 501 );

transfer ( 21 ) said codes ( 200 ) from said tracing location ( 500 ) to said track and trace system ( 100 ),

identify ( 22 ) said first and second identifiers ( 201 , 202 ) of said codes ( 200 ) in said track and trace system ( 100 ),

determine said start position ( 112 ) of said section ( 111 ) of said storage location ( 110 ) in said track and trace system ( 100 ),

retrieve ( 23 ) said hierarchical code relations ( 304 ) and said updated hierarchical code relations ( 304 ) stored in said section ( 111 ) for said codes ( 200 ); and

transfer ( 24 ) said hierarchical code relations ( 304 ) and said updated hierarchical code relations ( 304 ) back to said computer based terminal ( 501 ),

wherein said system is further configured to retrieve ( 23 a ) one or more tracking records ( 130 ) for a containing “parent” marked physical item ( 350 ),

wherein said tracking records ( 130 ) are stored in a second storage location ( 150 ) of said first computer ( 101 ) in said track and trace system ( 100 ), and

wherein a position of said tracking records ( 130 ) is determined by a combination of said first and second identifiers ( 201 , 202 ) of a code ( 200 , P) of said containing “parent” marked physical item ( 350 ) obtained in said step of retrieving ( 23 ) said packaging relationships ( 303 ) and updated packaging relationships ( 403 ).

12. The system according to claim 11 , wherein the system is further configured to

encrypt (E) said codes ( 200 ) with a unique key ( 303 ) before said codes ( 200 ) are marked on said physical items ( 350 ); and

decrypt (D) said codes ( 200 ) with said unique key ( 303 ).