# US 11,907,781 B2 · Database system for marking codes for liquid food packages > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,907,781 B2 - Document ID: US11907781B2 - Status: Granted - Kind: B2 - Application number: 17/776,880 - Filed: 2020-11-12 - Published: 2022-10-27 - Granted: 2024-02-20 - Earliest claimed: 2019-11-14 - Assignees: Tetra Laval Holdings & Finance S.A. - Applicants: Tetra Laval Holdings & Finance S.A. - Inventors: Matteo Gazzadi Poggioli; Gaurav Naik; Biagio Roberti; Gregorio Occhiogrosso - Web page: https://patentgrep.com/patent/US11907781B2 ## CPC - G06K 19/06037: {multi-dimensional coding} - G06Q 30/0185: {Product, service or business identity fraud} - G06F 16/9017: {using directory or table look-up (use of a directory or look-up table in file systems G06F16/13)} - G06F 21/44: Program or device authentication - G06K 19/06028: {using bar codes} - G06Q 50/04: Manufacturing - H04L 63/123: {received data contents, e.g. message integrity} - H04L 67/02: based on web technology, e.g. hypertext transfer protocol [HTTP] - H04L 67/12: specially adapted for proprietary or special-purpose networking environments, e.g. medical networks, sensor networks, networks in vehicles or remote metering networks - H04L 61/4511: using domain name system [DNS] - G06K: GRAPHICAL DATA READING (image or video recognition or understanding G06V); PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M) ## Abstract A database system can comprise a plurality of code databases storing marking codes that uniquely identifies packages of liquid food and comprises package production data which uniquely identifies production of the individual package. The respective code database stores a respective subset of the marking codes. An input sub-system of the database system is configured to receive a current marking code. The database system comprises a set of resource locators. The respective resource locator is configured to: receive the current marking code from the input sub-system, extract the package production data from the current marking code, identify a current code database among the plurality of code databases based on the package production data, and re-direct the current marking code to the current code database. ## Claims ### Claim 1 A database system, comprising: an input sub-system configured to receive marking codes corresponding to data carriers on packages for liquid food, the respective marking code comprising package production data which uniquely identifies production of an individual package; a plurality of code databases configured to store the marking codes, wherein a respective code database among the plurality of code databases is configured to store a respective subset of the marking codes associated with the packages for liquid food; and a set of resource locators, wherein a respective resource locator in the set of resource locators is configured to: receive a current marking code from the input sub-system, extract the package production data from the current marking code, select a current code database among a subset of the plurality of code databases based on the package production data in order to minimize latency, wherein databases within the subset of the plurality of code databases store the current marking code, and re-direct the current marking code to the current code database. ### Claim 2 (depends on 1) The database system of claim 1, further comprising: a set of lookup databases, wherein the respective resource locator is configured for connection to a respective lookup database in said set of lookup databases, wherein the respective lookup database is arranged to associate different values of at least one data element in the package production data with different code databases among said plurality of code databases. ### Claim 3 (depends on 2) The database system of claim 2, wherein resource locators in said set of resource locators are connected in pairs with lookup databases in said set of lookup databases, wherein the respective lookup database is co-located with the respective resource locator in each of said pairs. ### Claim 4 (depends on 2) The database system of claim 2, wherein said set of lookup databases comprises a main lookup database and one or more replications of the main lookup database. ### Claim 5 (depends on 2) The database system of claim 2, wherein the respective resource locator is further configured to search the package production data for said at least one data element, extract a current value of said at least one data element, and identify, based on said at least one data element, the current code database in a lookup database in the set of lookup databases. ### Claim 6 (depends on 1) The database system of claim 1, wherein the respective code database has an address in the database system, said address including at least one predefined data element in the package production data. ### Claim 7 (depends on 6) The database system of claim 6, wherein the respective resource locator is configured to search the package production data for said at least one predefined data element, extract a current value of said at least one predefined data element, include the current value in an address template to generate the address for the current code database in the database system, and re-direct the current marking code to the address. ### Claim 8 (depends on 6) The database system of claim 6, wherein said at least one predefined data element comprises an identifier of a provider of one or more plants for producing the packages. ### Claim 9 (depends on 1) The database system of claim 1, wherein said set of resource locators comprises two or more resource locators which are arranged in different geographic regions. ### Claim 10 (depends on 1) The database system of claim 1, wherein the respective code database is located in a respective distribution region among a plurality of distribution regions, and wherein said respective subset of the marking codes in the respective code database corresponds to packages that are distributed at least partly within the respective distribution region. ### Claim 11 (depends on 10) The database system of claim 10, wherein the plurality of code databases comprises at least one main code database and one or more replications of the main code database. ### Claim 12 (depends on 1) The database system of claim 1, wherein the package production data is encrypted in the marking code, and wherein the respective resource locator is further configured to decrypt the marking code to extract the package production data. ### Claim 13 (depends on 1) A system, comprising: a package for liquid food, the package having a data carrier containing a marking code, the marking code comprising package production data which uniquely identifies production of the package; and the database system of claim 1. ### Claim 14 (depends on 1) The database system of claim 1, wherein the packages for liquid food are produced by different producers, and wherein the respective subset of the marking codes is associated with the packages for liquid food produced by different producers. ### Claim 15 A control method for a database system, said control method comprising: receiving, by an input sub-system of the database system, a current marking code which corresponds to a package of liquid food and comprises package production data which uniquely identifies production of the package; providing, by the input sub-system, the current marking code to a resource locator in the database system; and operating the resource locator to: extract the package production data from the current marking code, select among a subset of a plurality of code databases that store a respective subset of a plurality of marking codes associated with the packages of liquid food, a current code database based on the package production data in order to minimize latency, wherein databases within the subset of the plurality of code databases store the current marking code, and re-direct the current marking code to the current code database. ### Claim 16 (depends on 15) A non-transitory computer-readable medium comprising computer instructions which, when executed by a processing system, cause the processing system to perform the method of claim 15. ### Claim 17 (depends on 15) The method of claim 15, wherein the packages for liquid food are produced by different producers, and wherein the respective subset of the plurality of marking codes is associated with the packages of liquid food produced by different producers.