EP4670095A1 - Systèmes et procédé de mise à jour d'une donnée représentative du poids d'un produit dans une base de données informatique - Google Patents
Systèmes et procédé de mise à jour d'une donnée représentative du poids d'un produit dans une base de données informatiqueInfo
- Publication number
- EP4670095A1 EP4670095A1 EP24706120.3A EP24706120A EP4670095A1 EP 4670095 A1 EP4670095 A1 EP 4670095A1 EP 24706120 A EP24706120 A EP 24706120A EP 4670095 A1 EP4670095 A1 EP 4670095A1
- Authority
- EP
- European Patent Office
- Prior art keywords
- product
- weight
- value
- captured
- validity
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- 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
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- 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
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0877—Inventory or stock management, e.g. order filling, procurement or balancing against orders by inventory control or reporting using inventory tracking or counting
- G06Q10/08772—Inventory counting methods
Definitions
- the present invention relates to systems for updating data representative of the weight of a product in a computer database and a method for updating data representative of the weight of a product in a computer database. It applies, in particular, to the field of warehouse management and logistics.
- a weight value is associated with any product so as to ensure compliance control between an order and a set containing at least one product, or item, to be shipped.
- This compliance is achieved, simply, by calculating the arithmetic sum of the weights measured by an operator of the products of an order being processed and by comparing them with the arithmetic sum of the theoretical weights of the products. This assumes that the association between product and theoretical weight of the products is correctly set. However, for several reasons, this association is often erroneous.
- FIG. 1 represents, schematically, a particular embodiment of the system which is the subject of the invention
- Figure 2 schematically represents a particular embodiment of a computer system that is the subject of the invention
- Figure 3 represents, and in the form of a flowchart, a particular succession of steps of the method that is the subject of the invention
- Figure 4 schematically represents a set of weight values captured from a product and implemented by a system or method that is the subject of the invention
- Figure 5 represents, in the form of a flowchart, a particular succession of steps that is complementary or subsidiary to that of the method that is the subject of the invention.
- the present invention aims to remedy all or part of these drawbacks.
- All of the embodiments disclosed and claimed herein are directed to computer-implemented methods that interact with digital data to provide a practical application of computer technology to the problem of unreliability in identifying the nature of a batch or product by the weight of said batch or product, considering fluctuations in weight related to actions of the manufacturers of such batches or products.
- the disclosure is not intended to encompass techniques of organizing human activity, performing mental processes, or executing a mathematical concept, and any interpretation of the claims to encompass such techniques would be unreasonable based on the disclosure as a whole.
- the invention relates to a system according to claim 1. Thanks to these provisions, the reference weight of the products, articles or batches changes according to the modifications of this weight by the manufacturers, these modifications not being transmitted reliably to the storage and distribution warehouses using the weight of the products as a control measure in the execution of order processing.
- the implementation of validity intervals for weight captures makes it possible to guarantee the adaptive nature of the system, by favoring recent captures at the expense of older captures.
- the system which is the subject of the invention comprises a software module for automatic classification of products in the database, associating with at least one product identifier a product class, at least one value among:
- the system object of the invention comprises a machine learning module configured to associate a product class with at least one product identifier.
- the learning module is an automatic learning classification module configured to associate a product class with at least one product identifier based on:
- the system object of the invention comprises a software module for filtering captured weight values according to a validity limit value of the capture, the filtered values being implemented by the determination software module and/or by the machine learning module.
- the system that is the subject of the invention comprises an update module of the filtering software module, configured to update the validity limit value, according to a statistical parameter representative of a distribution of captured weight values and reference weight values associated with at least one product identifier.
- the statistical parameter is formed from the sum of:
- the invention relates to a method for updating data representative of the weight of a product in a computer database, which comprises:
- a timestamp step to associate a timestamp value with a weight value capture of a product represented, in a database, by a product identifier
- This method has the same advantages as the system which is the subject of the first aspect of the invention.
- the invention aims at a system for updating data representative of the weight of a product in a computer database, which comprises:
- At least one computing system comprising at least one processor and at least one memory
- a timestamp step to associate a timestamp value with a weight value capture of a product represented, in a database, by a product identifier
- This system has the same advantages as the system which is the subject of the first aspect of the invention.
- inventive concepts may be implemented by one or more methods or devices described hereinafter, several examples of which are provided herein.
- the actions or steps performed in carrying out the method or device may be ordered in any appropriate manner. Accordingly, it is possible to construct embodiments in which the actions or steps are performed in a different order than that illustrated, which may include performing certain acts simultaneously, even if they are presented as sequential acts in the illustrated embodiments.
- a reference to "A and/or B", when used in conjunction with open language such as “comprising” may refer, in one embodiment, to A only (optionally including elements other than B); in another embodiment, to B only (optionally including elements other than A); in yet another embodiment, to A and B (possibly including other elements); etc.
- the expression "at least one”, in reference to a list of one or more elements, is to be understood to mean at least one element selected from one or more elements in the list of elements, but not necessarily including at least one of each element specifically enumerated in the list of elements and not excluding any combination of elements in the list of elements.
- This definition also allows for the optional presence of elements other than the elements specifically identified in the list of elements to which the expression “at least one” refers, whether or not related to those specifically identified elements.
- “at least one of A and B” may refer, in one embodiment, to at least one, optionally including more than one, A, without B present (and optionally including elements other than B); in another embodiment, to at least one, optionally including more than one, B, without A present (and optionally including elements other than A); in yet another embodiment, to at least one, optionally including more than one, A, and at least one, optionally including more than one, B (and optionally including other elements); etc.
- FIG. 2 is a block diagram illustrating an exemplary computer system with which an embodiment may be implemented.
- a computer system 205 and instructions for implementing the disclosed technologies in the hardware, software, or combination of hardware and software are schematically depicted, such as as boxes and circles, at the same level of detail that is commonly used by those of ordinary skill in the art to which this disclosure pertains to communicate computer architecture and computer system implementations.
- the computer system 205 includes an input/output (I/O) subsystem 220 that may include a bus and/or one or more other communication mechanisms for communicating information and/or instructions between components of the computer system 205 over electronic signal paths.
- the input/output subsystem 220 may include an input/output controller, a memory controller, and at least one input/output port.
- the electronic signal paths are shown schematically in the drawings, for example, as lines, one-way arrows, or two-way arrows.
- At least one processor 210 is coupled to the I/O subsystem 220 to process information and instructions.
- the processor 210 may include, for example, a general purpose microprocessor or microcontroller and/or a special purpose microprocessor such as an embedded system or graphics processing unit (GPU) or a digital signal processor or an ARM processor.
- the processor 210 may include an integrated arithmetic logic unit (ALU) or may be coupled to a separate ALU.
- the computer system 205 includes one or more memories 225, such as a main memory, that is coupled to the I/O subsystem 220 to electronically digitally store data and instructions to be executed by the processor 210.
- the memory 225 may include volatile memory such as various forms of random access memory (RAM) or other dynamic storage devices.
- the memory 225 may also be used to store temporary variables or other intermediate information during execution of the instructions to be executed by the processor 210. Such instructions, when stored in a non-transitory computer-readable storage medium accessible to the processor 210, may transform the computer system 205 into a special purpose machine that is customized to perform the operations specified in the instructions.
- the computer system 205 further includes non-volatile memory such as a read only memory (ROM) 230 or other static storage device coupled to the I/O subsystem 220 for storing information and instructions for the processor 210.
- the ROM 230 may include various forms of programmable ROM (PROM) such as erasable PROM (EPROM) or electrically erasable PROM (EEPROM).
- a persistent storage unit 215 may include various forms of non-volatile random access memory (NVRAM), such as FLASH memory, or solid state storage, a magnetic disk, or an optical disk such as a CD-ROM or DVD-ROM and may be coupled to the I/O subsystem 220 for storing information and instructions.
- NVRAM non-volatile random access memory
- Memory 215 is an example of a non-transitory computer-readable medium that can be used to store instructions and data that, when executed by processor 210, cause execution of computer-implemented methods for performing the techniques of this document.
- the instructions in memory 225, ROM 230, or storage 215 may comprise one or more sets of instructions that are organized into modules, methods, objects, functions, routines, or calls.
- the instructions may be organized as one or more computer programs, operating system services, or application programs, including mobile applications.
- the instructions may comprise an operating system and/or system software; one or more libraries to support multimedia, programming, or other functions; data protocol instructions or stacks to implement TCP/IP, HTTP, or other communication protocols; file format processing instructions to parse or render files encoded using HTML, XML, JPEG, MPEG, or PNG; user interface instructions to render or interpret commands for a graphical user interface (GUI), command line interface, or text-based user interface; application software such as an office suite, Internet access applications, design and manufacturing applications, graphics applications, audio applications, software engineering applications, educational applications, games, or miscellaneous applications.
- the instructions may implement a web server, a web application server, or a web client.
- the instructions may be organized as a presentation layer, an application layer, and a data storage layer such as a relational database system using Structured Query Language (SQL) or no SQL, an object store, a graph database, a flat file system, or other data storage.
- SQL Structured Query Language
- object store e.g., a graph database
- flat file system e.g., a flat file system
- the computer system 205 may be coupled via the I/O subsystem 220 to at least one output device 235.
- the output device 235 is a digital computer display.
- Exemplary displays that may be used in various embodiments include a touch screen or a light emitting diode (LED) display or a liquid crystal display (LCD) or an e-paper display.
- the computer system 205 may include one or more other types of output devices 235, either in place of or in addition to a display device.
- Exemplary other output devices 235 include printers, ticket printers, plotters, projectors, sound cards or video cards, speakers, buzzers or piezoelectric or other audible devices, LED or LCD lights or indicators, haptic devices, actuators, or servos.
- At least one input device 240 is coupled to the I/O subsystem 220 for communicating signals, data, command selections, or gestures to the processor 210.
- Examples of input devices 240 include touch screens, microphones, digital still and video cameras, alphanumeric and other keys, keyboards, graphics tablets, image scanners, joysticks, clocks, switches, buttons, dials, sliders.
- the input device is a control device 245, which may perform cursor control or other automated control functions such as navigating a graphical interface on a display screen, alternatively or in addition to input functions.
- the control device 245 may be a touchpad, mouse, trackball, or cursor direction keys to communicate direction information and control selections to the processor 210 and to control movement of the cursor on the display 235.
- the input device may have at least two degrees of freedom in two axes, a first axis (e.g., x) and a second axis (e.g., y), which allows the device to specify positions in a plane.
- An input device is a wired, wireless, or optical control device, such as such as a joystick, wand, console, steering wheel, pedal, gear shift mechanism, or other type of control device.
- An input device 240 may include a combination of several different input devices, such as a video camera and a depth sensor.
- the computer system 205 may include an Internet of Things (IoT) device in which one or more of the output device 235, the input device 240, and the control device 245 are omitted.
- IoT Internet of Things
- the input device 240 may include one or more cameras, motion detectors, thermometers, microphones, seismic detectors, other sensors or detectors, measuring devices, or encoders
- the output device 235 may include a special purpose display such as a single-line LED or LCD display, one or more indicators, a display panel, a meter, a valve, a solenoid, an actuator, or a servo motor.
- the output device 235 may include hardware, software, firmware, and interfaces to generate position report packets, notifications, pulse or heartbeat signals, or other recurring data transmissions that specify a position of the computer system 205, alone or in combination with other application-specific data, directed to the host 250 or server 255.
- the computer system 205 may implement the techniques described herein using custom hardwired logic, at least one ASIC (Application-specific integrated circuit) or FPGA (Field-programmable gate array), firmware, and/or program instructions or logic that, when loaded and used or executed in combination with the computer system, cause or program the computer system to operate as a special purpose machine.
- the techniques described herein are performed by the computer system 205 in response to the processor 210 executing at least one sequence of at least one instruction contained in the main memory 225. These instructions may be read into the main memory 225 from another storage medium, such as the memory 215. Execution of the sequences of instructions contained in the main memory 225 causes the processor 210 to perform the process steps described herein.
- hardwired circuits may be used in place of or in combination with software instructions.
- Non-volatile media include, for example, optical or magnetic disks, such as memory 215.
- Volatile media include dynamic memory, such as memory 225.
- Common forms of storage media include, for example, a hard disk, a solid-state drive, a flash drive, a magnetic data storage medium, any optical or physical data storage medium, a memory chip, etc.
- Storage media are distinct from, but may be used in conjunction with, transmission media.
- Transmission media assist in the transfer of information between storage media.
- transmission media include coaxial cables, copper wires, and optical fibers, including the wires that make up a bus of the I/O subsystem 220.
- Transmission media may also take the form of acoustic or light waves, such as those generated during radio and infrared data communications.
- the instructions may initially be transported on a magnetic disk or solid state drive of a remote computer.
- the remote computer may load the instructions into its dynamic memory and send the instructions over a communications link such as a fiber optic or coaxial cable or a telephone line using a modem.
- a modem or router local to the computer system 205 may receive the data over the communications link and convert the data into a format that can be read by the computer system 205.
- a receiver such as a radio frequency antenna or an infrared detector may receive the data transported in a wireless or optical signal and suitable circuitry may provide the data to the I/O subsystem 220, for example by placing the data on a bus.
- the I/O subsystem 220 transports data to memory 225, from which the processor 210 retrieves and executes instructions. Instructions received by memory 225 may optionally be stored on memory 215 before or after execution by processor 210.
- the computer system 205 also includes a communications interface 260 coupled to a bus 220.
- the communications interface 260 provides bidirectional data communications coupling to the one or more network links 265 that are directly or indirectly connected to at least one communications network, such as a network 270 or a public or private cloud on the Internet.
- the communications interface 260 may be an "Ethernet”® network interface, an Integrated Services Digital Network (ISDN) card, a cable modem, a satellite modem, or a modem to provide a data communication connection to a corresponding type of communication line, for example an "Ethernet”® cable or a metallic cable of any type or a fiber optic line or a telephone line.
- ISDN Integrated Services Digital Network
- the network 270 broadly represents a local area network (LAN), a wide area network (WAN), a campus network, an Internet network, or any combination thereof.
- the communication interface 260 may include a LAN card to provide a data communication connection to a compatible LAN, or a cellular radiotelephone interface that is wired to send or receive cellular data according to cellular radiotelephone wireless network standards, or a satellite radio interface that is wired to send or receive digital data according to satellite wireless network standards.
- the communications interface 260 sends and receives electrical, electromagnetic, or optical signals over signal paths that carry digital data streams representing various types of information.
- the network link 265 typically provides electrical, electromagnetic, or optical data communication directly or via at least one network to other data devices, using, for example, satellite, cellular, "Wi-Fi”®, or "BLUETOOTH”® technology.
- the network link 265 may provide a connection through a network 270 to a host computer 250.
- the network link 265 may provide a connection via the network 270 or to other computing devices via interconnect devices and/or computers that are operated by an Internet service provider (ISP) 275.
- the ISP 275 provides data communication services via a global packet data communication network represented by the Internet 280.
- a server computer 255 may be coupled to the Internet 280.
- the server 255 broadly represents any computer, data center, virtual machine or virtual computing instance with or without a hypervisor, or computer running a containerized program system such as "DOCKER”® or "KU BERN ETES”®.
- the server 255 may represent an electronic digital service that is implemented using more than one computer or instance and that is accessed and used by transmitting web service requests, Uniform Resource Locator (URL) strings with parameters in Hypertext Transfer Protocol (HTTP) payloads, application programming interface (API) calls, application service calls, or other service calls.
- the computer system 205 and the server 255 may form elements of a distributed computing system that includes other computers, a processing cluster, a server farm, or other organization of computers that cooperate to perform tasks or run applications or services.
- the server 255 may include one or more sets of instructions that are organized as modules, methods, objects, functions, routines, or calls. The instructions may be organized as one or more computer programs, operating system services, or application programs, including mobile applications.
- the instructions may include an operating system and/or system software; one or more libraries to support multimedia, programming, or other functions; and data protocol stacks or instructions to implement TCP/IP (Transmission control protocol/Internet protocol), HTTP, or other communication protocols; file format processing instructions for parsing or rendering files encoded using HTML (for Hypertext Markup Language), XML (for Extensible Markup Language), JPEG (for Joint Photographie Experts Group), MPEG (for Moving Picture Experts Group), or PNG (for Portable Networks Graphie); user interface instructions for rendering or interpreting commands for a graphical user interface (GUI), command line interface, or text-based user interface; application software such as an office suite, Internet access applications, design and manufacturing applications, graphics applications, audio applications, software engineering applications, educational applications, games, or miscellaneous applications.
- GUI graphical user interface
- the server 255 may include a web application server that hosts a presentation layer, an application layer, and a data storage layer such as a relational database system using Structured Query Language (SQL) or no SQL, an object store, a graph database, a flat file system, or other data storage.
- SQL Structured Query Language
- object store an object store
- graph database a graph database
- flat file system a flat file system
- the computer system 205 may send messages and receive data and instructions, including program code, via the network(s), network link 265, and communications interface 260.
- a server 255 may transmit requested code for an application program via the Internet 280, ISP 275, local area network 270, and communications interface 260.
- the received code may be executed by the processor 210 as it is executed. of its reception, and/or stored in memory 215, or in other non-volatile memory for later execution.
- Execution of instructions as described in this section may implement a process as an instance of a computer program that is currently executing and consists of program code and its current activity.
- a process may consist of multiple threads that execute instructions concurrently.
- a computer program is a passive collection of instructions, while a process may be the actual execution of those instructions.
- Multiple processes may be associated with the same program; for example, having multiple instances of the same program open often means that more than one process is currently executing. Multitasking may be implemented to allow multiple processes to share the processor 210.
- each processor 210 or processor core executes only one task at a time
- the computer system 205 may be programmed to implement multitasking to allow each processor to switch between currently executing tasks without having to wait for each task to complete.
- the switches may be performed when tasks perform input/output operations, when a task indicates that it can be switched, or upon hardware interrupts.
- Time sharing may be implemented to enable rapid response to user interactive applications by rapidly performing context switches to give the appearance of multiple processes running simultaneously.
- an operating system may prevent direct communication between independent processes, by providing strictly mediated and controlled interprocess communication functionality.
- order refers to a set of at least one product having a specific recipient
- batch refers to a set of at least two similar products grouped together in a single packaging
- product or “article” refers to an object that can be grouped together in a batch or set to form an order.
- Figure 1 shows a schematic view of an embodiment of the system 100 that is the subject of the invention.
- This system 100 for updating data representing the weight of a product in a computer database 105 comprises:
- a timestamp module 115 configured to associate a timestamp value with a weight value capture of a product represented, in a database, by a product identifier, - a 120 software module for determining data representative of the weight of a product based on at least:
- a software module 125 for updating a weight value of a product in a computer database based on the average value determined.
- the system 100 comprises a sensor 111 of a product reference.
- a reference is associated in a computer database of products in the form of an identifier, for example alphanumeric.
- the sensor 111 of a reference representative of a batch or a product is, for example, an image sensor configured to detect a two-dimensional or four-dimensional bar code (known as a “QR code”, for “Quick Response code”).
- QR code for “Quick Response code”.
- the senor 111 is a barcode scanner.
- the sensor 111 implements an I/O subsystem 220, associating a keyboard or a mouse with a user interface so as to allow the manual entry, in a batch or product control computer system, of an alphanumeric reference representative of a batch or a product.
- the sensor 110 of a value representative of the weight of a product is, for example, a scale.
- the weight of a product can be associated with each type of product (or each product reference), so as to compare the theoretical weight of a product and the weight captured, so as to avoid obvious errors in sending products.
- the capture of the reference of a product and the weight of said product allow a double verification of the identification of a product to be sent.
- the time stamp module 115 is, for example, an internal clock of the computing system 205.
- This time stamping means 130 is configured, for example, to provide information date and time. Such information is implemented, for example, when actuating a sensor 110 of a value representative of the weight of a product.
- the time stamp module 115 may be integrated into the sensor 110 of a value representative of the weight of a product or into a computer server 255 associated with the database 105 of captured product weight values.
- the time stamp module 115 may be a dedicated third-party system with which a calculation system 205 interacts when capturing a value representative of the weight of a product by the sensor 110.
- the software module 120 is, for example, formed of a set of instructions stored in a memory 215 of a calculation system 205 and configured to be executed by a processor 210, this set of instructions being integrated into dedicated software or not. Such instructions are representative of a programmed processing algorithm. Such an algorithm is, for example, configured to perform at least one of the following processing operations:
- the product weight update is abandoned.
- the values implemented by the 120 software module such as:
- the maximum validity period of capturing weight values captured for a product identifier can be determined, calculable or learned by automatic training.
- the determination software module 120 may, in variants, be configured to determine another value representative of a statistical distribution of a sample of captured weight values, such as the median for example.
- the mean determined by the 120 determination software module can be an arithmetic or weighted average, in particular depending on the date of the weight value captured.
- this value can be initialized and adapted by a user by the implementation of a human-machine interface (such as a keyboard and a mouse associated with a user interface) associated with the 220 I/O subsystem.
- a human-machine interface such as a keyboard and a mouse associated with a user interface
- a calculation formula can be entered and adapted by a user by implementing a human-machine interface (such as a keyboard and mouse associated with a user interface) associated with the I/O subsystem 220.
- a human-machine interface such as a keyboard and mouse associated with a user interface
- such a calculation formula is predetermined by a computer developer.
- the system 100 comprises a software module 130 for automatic classification of products in the database 105, associating with at least one product identifier a product class, at least one value among:
- Such a classification may result from the application of an algorithm, predetermined or defined by a user, for example via the entry of a calculation formula which may be entered and adapted by a user by the implementation of a human-machine interface (such as a keyboard and a mouse associated with a user interface) associated with the 220 I/O subsystem.
- a human-machine interface such as a keyboard and a mouse associated with a user interface
- the representative value of the minimum number of weight values captured for a product identifier, said product belonging to a given product class may be equal to the maximum value between 10 days and the sum of the maximum deviation between two captures of weight values in number of calendar days and the standard deviation of the determined deviation values.
- the representative value of a capture validity time interval for a product identifier, said product belonging to a given product class may be equal to the maximum value between 5 days and the average difference between two captures of weight values in number of calendar days.
- the maximum validity period for a product identifier may be equal to the maximum value between 3 and a maximum number of weight value captures recorded per day of weight value captures.
- Such a classification may correspond, for example, to a classification representative of the frequency of capturing weight values for different classes of products. Indeed, some products are ordered more regularly than others, which implies a higher frequency of capturing weights. Thus, for such products, the duration of the capture validity interval to be implemented by the determination software module 120 may be reduced. Conversely, some products are rarely ordered and therefore the capture of their weight is rare, thus, the maximum duration of capture validity for such products may be increased.
- the classification makes it possible to divide the products into homogeneous classes sharing on average the same statistical characteristics.
- the number of classes of such products depends on the implementation of the system 100 and, in particular, on the products stored in a particular warehouse. Thus, it is complex to determine, a priori, a universal classification rule, applicable to any warehouse.
- the system 100 which is the subject of the invention comprises a machine learning module 135 configured to associate a product class with at least one product identifier.
- Such a learning module 135 implements, for example, a neural network.
- a learning module 135 implements, for example, a hierarchical classification algorithm called “HCPC” (for “Hierarchical Clustering - Partitional Clustering”, translated into French as hierarchical grouping - partitioned grouping) which aims to identify groups of similar objects in a data set.
- HCPC hierarchical classification algorithm
- the HCPC approach makes it possible to combine three standard methods used in multivariate analysis, namely, the PCA principal component methods, hierarchical ascending classification and k-means partitioning.
- the learning module 135 uses a history of weight value captures to allow the classification algorithm to have enough information to characterize the behavior of each product.
- the algorithm takes as input all the data of weight value captures of each product.
- the collected data informs weight value captures or constants, for example: the actual weight recorded and the capture date.
- This data does not describe the behavior of the products, namely the number of weight value captures per day, the number of total weight value captures or the duration between two successive weight value captures.
- all this information makes it possible to calculate variables intended to identify behaviors and characterize products.
- a product characterization function can be implemented.
- This function takes as input the data of weight value captures from the database and calculates the variables that best describe the products.
- the behavior of a product over time is defined in the table below.
- the learning module 135 is an automatic classification module by learning configured to associate a product class with at least one product identifier based on:
- the classification algorithm can then proceed to group products that share the same characteristics on average.
- the classes are thus defined by discriminating variables, the values of these variables being able to be of the mean and standard deviation type. These variables make it possible to know the behavior of each class, in order to adapt the setting of the update of the reference weight of each product, according to its characteristics.
- the variable "Ecart_moyen” which represents the average difference in calendar days between two captures of weight values, amounts to 22 days. This means that on average, at least one weight value capture is performed every 22 days.
- the deviation between weight value captures is an important parameter in the characterization of product classes.
- the determination software module 120 preferentially implements a parameterization rule based on a product class indicator associated with the products in the database.
- the update algorithm can be executed.
- the number of product classes can be determined automatically, manually or semi-automatically, i.e. automatically and adjusted by a user.
- a product class can be assigned to any new product identifier added to the computer database.
- the machine learning module 135 may be implemented periodically, according to a manually or automatically defined period, of 15 days, for example.
- the machine learning module 135 may be implemented manually or automatically, for example according to a number of product identifiers added to the computer database and not yet classified or classified by default.
- a product identifier added to the computer database is assigned to a given product class and then a principal component analysis is performed to extract and visualize the important information contained in a multivariate data table. Then, the calculation of the “cos2” metric on each axis is performed. This metric expresses the quality of representation of the product on the dimensions of the principal component analysis. If the sum of the two “cos2” metrics is greater than 0.5, the function accepts the new product and proceeds to predict its class. Otherwise, the product remains in the class assigned by default while waiting to acquire more data.
- the update software module 125 is, for example, formed of a set of instructions stored in a memory 215 of a calculation system 205 and configured to be executed by a processor 210, this set of instructions being integrated into dedicated software or not.
- the update software module 125 is configured to edit or add an entry representative of the weight determined by the module 120 for determining a weight for a product.
- the theoretical weight to which the captured weight of a product is compared to ensure its conformity, is updated.
- the method 100 which is the subject of the invention comprises a software module 140 for filtering captured weight values according to a capture validity limit value, the filtered values being implemented by the determination software module 120 and/or by the automatic learning module 135.
- the filtering software module 140 is, for example, formed of a set of instructions stored in a memory 215 of a calculation system 205 and configured to be executed by a processor 210. Such a filtering software module 140 may be of the manual or automatic type.
- a manual type filtering software module 140 implements, for example, a human-machine interface (such as a keyboard and a mouse associated with a user interface) associated with the I/O subsystem 220. In this user interface, an operator can set a validity threshold value for the captured weight values.
- An automatic type filtering software module 140 implements, for example, a statistical processing computer algorithm configured to filter the outliers of a sample.
- Such a filter can be based on the following parameters, for example:
- a captured weight value can thus be filtered if this captured weight value meets the following condition:
- qnorm is the inverse of the cumulative distribution function of the sample.
- a weight value is filtered if that value is less than 0.
- a weight value is filtered if the quantity of an associated product is less than or equal to 0.
- a weight value is filtered if the above condition associated with a weight value of an associated product is true.
- Figure 4 illustrates, for example, for a given product, a set of captured weight values 405, defined on the abscissa by a capture date and on the ordinate by a captured weight value.
- a weight value 410 located outside a validity interval defined by an average 415 of weight captured during a given period of time and a given tolerance margin 420, applied in subtraction and addition to the average 415.
- Tolerance Constant + (GroupRefWeight * Tolerance%, RefWeight * Unit %)
- - WeightRef.Group represents the weight of a product, in a grouped form
- - Tolerance% represents the tolerance percentage for products in a grouped form
- WeightRef represents the unit weight of a product
- - %Unit represents the tolerance percentage for unit products.
- Such a filtering module aims in particular to not consider, in a sample, so-called “forced” values, i.e. values overloaded by computer by a warehouse operator, in particular in the event of a mismatch between the theoretical weight and the captured weight of a product.
- the number of forced values is a performance metric of the method 100 which is the subject of the invention. Indeed, an aberrant value, by feedback, degrades the adaptive nature of the updating of the weight values.
- a weight value is said to be "forced” if this value meets the following condition: Abs Actual weight — theoretical weight * quantity > Tolerance
- the method 100 which is the subject of the invention comprises a module 145 for updating the filtering software module 140, configured to update the validity limit value, according to a statistical parameter representative of a distribution of captured weight values and reference weight values associated with at least one product identifier.
- the update module 145 is, for example, formed of a set of instructions stored in a memory 215 of a calculation system 205 and configured to be executed by a processor 210, this set of instructions being integrated into dedicated software or not.
- the statistical parameter is formed from the sum of:
- Inter variance represents the variability of the weight of the entire population of captures of selected weight values during the update period
- Intra variance represents the intra-group variance which describes the variance of weight values of a given product with quantity greater than 1.
- This variance can be implemented to determine the tolerance interval of weight values according to the following equation:
- - n represents the number of weight values captured over a given sampling period, for example 6 months and
- - a represents an assumed or tolerated prediction error, for example 1%.
- this variance can be implemented to determine the tolerance interval of weight values according to the following equation:
- - Coeff Var represents the variance adjustment coefficient, for example equal to 2, aiming to overestimate the intra-group variance in order to get as close as possible to the total variance.
- the variance may be estimated on a small population of captured weight values, for example: over six months of history, only 3 values are available.
- the estimated variance is often very low and gives a very narrow tolerance interval, which can encourage the appearance of unjustified forcing during future updates.
- a safety tolerance corresponding to a proportion of the reference weight of a product, can be set up. This safety allows for a minimum acceptable tolerance. Its default value is 5% of the reference weight of a product.
- the safety tolerance can be configurable, depending on the absolute maximum deviation, according to the following equation for example:
- the determination of the tolerance interval of weight values can be calculated according to the following equation:
- This method 300 for updating data representing the weight of a product in a computer database comprises:
- a timestamp step 310 for associating a timestamp value with a weight value capture of a product represented, in a database, by a product identifier
- This system 200 for updating data representative of the weight of a product in a computer database comprises:
- At least one calculation system 205 comprising at least one processor 210 and at least one memory 215, and
- a timestamp step to associate a timestamp value with a weight value capture of a product represented, in a database, by a product identifier
- - a step of determining data representative of the weight of a product based on at least: - a minimum number of weight values captured for a product identifier,
- FIG. 5 we observe a succession 500 of particular steps complementary or subsidiary to that of the method 300.
- This method 500 allows the dynamic counting of products, the automatic validation of an order preparation line and/or preventive maintenance of a scale of the weighing device.
- the method 500 comprises:
- Steps 545 to 555 are performed upon triggering (by the operator or supplier of the device) or on a regular basis, to allow preventive maintenance of the device.
- the software calculates, for at least one sensor 110, an average deviation between its weight measurements and the weight values for the same products, updated as explained with respect to FIG. 3. This average deviation is expressed in weight units and/or as a percentage.
- the absolute value of the average deviation of the sensor in question is compared with a predetermined limit value, for example one gram and/or one thousandth.
- steps 545 to 555 can each be performed locally or remotely.
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| FR2301558A FR3146001A1 (fr) | 2023-02-20 | 2023-02-20 | Systèmes et procédé de mise à jour d’une donnée représentative du poids d’un produit dans une base de données informatique |
| PCT/EP2024/054291 WO2024175596A1 (fr) | 2023-02-20 | 2024-02-20 | Systèmes et procédé de mise à jour d'une donnée représentative du poids d'un produit dans une base de données informatique |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| EP4670095A1 true EP4670095A1 (fr) | 2025-12-31 |
Family
ID=86851745
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| EP24706120.3A Pending EP4670095A1 (fr) | 2023-02-20 | 2024-02-20 | Systèmes et procédé de mise à jour d'une donnée représentative du poids d'un produit dans une base de données informatique |
Country Status (3)
| Country | Link |
|---|---|
| EP (1) | EP4670095A1 (fr) |
| FR (1) | FR3146001A1 (fr) |
| WO (1) | WO2024175596A1 (fr) |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| FR220E (fr) | 1898-02-03 | 1902-11-21 | Jensen | Perfectionnements aux cisailles, clés anglaises, pinces el autres outils analogues |
| US8037969B2 (en) * | 2007-03-06 | 2011-10-18 | Power Monitors, Inc. | Method and apparatus for a drive-thru product delivery verifier |
-
2023
- 2023-02-20 FR FR2301558A patent/FR3146001A1/fr active Pending
-
2024
- 2024-02-20 EP EP24706120.3A patent/EP4670095A1/fr active Pending
- 2024-02-20 WO PCT/EP2024/054291 patent/WO2024175596A1/fr not_active Ceased
Also Published As
| Publication number | Publication date |
|---|---|
| FR3146001A1 (fr) | 2024-08-23 |
| WO2024175596A1 (fr) | 2024-08-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11263241B2 (en) | Systems and methods for predicting actionable tasks using contextual models | |
| JP6383170B2 (ja) | 一般化された状況判断知能プラットフォーム | |
| US10761965B2 (en) | Detecting method calls based on stack trace data | |
| US10700935B1 (en) | Automatic configuration and operation of complex systems | |
| US12061632B2 (en) | Interactive adaptation of machine learning models for time series data | |
| EP3506094A1 (fr) | Procédé et système pour l'optimisation de l'ordonnancement de traitements par lot | |
| EP3471356B1 (fr) | Dispositif et procede d'acquisition de valeurs de compteurs associes a une tache de calcul | |
| EP3846091A1 (fr) | Procede et systeme de conception d'un modele de prediction | |
| US11522625B1 (en) | Predicting regional viewership for broadcast media events | |
| WO2024175596A1 (fr) | Systèmes et procédé de mise à jour d'une donnée représentative du poids d'un produit dans une base de données informatique | |
| FR3146000A3 (fr) | Systèmes et procédé de mise à jour d’une donnée représentative du poids d’un produit dans une base de données informatique | |
| EP3506566B1 (fr) | Procédé et dispositif pour la surveillance à distance d'objets connectés multiples | |
| US12248824B2 (en) | Prediction and automatic performance of computer-related activities | |
| FR3076642A1 (fr) | Facilitation de la génération d’essais normalisés pour l’évaluation de gestes sur un écran tactile en fonction de données de modèles générés informatiquement | |
| FR3146531A3 (fr) | Dispositif et procédé de contrôle d’intégrité et/ou de conformité d’une préparation logistique d’une commande | |
| FR3146530A1 (fr) | Dispositif et procédé de contrôle d’intégrité et/ou de conformité d’une préparation logistique d’une commande | |
| EP3662392A1 (fr) | Systeme informatique pour la visualisation de parcours logistique d'entites dans le temps | |
| EP3853784B1 (fr) | Procédé d'analyse des dysfonctionnements d'un système et dispositifs associés | |
| FR3148345A3 (fr) | Procédé et dispositif de prédiction de demande de connectivité locale au réseau | |
| FR3142585A3 (fr) | Méthode mise en oeuvre par ordinateur et système informatique pour la surveillance de l'automatisation de l'exécution de logiciels | |
| FR3146748A3 (fr) | Procédé et dispositif de génération automatique d’au moins deux ensembles d’instructions informatiques | |
| FR3146747A1 (fr) | Procédé et dispositif de génération automatique d’au moins deux ensembles d’instructions informatiques | |
| EP2534642A1 (fr) | Dispositif pour mettre a jour un modele photometrique | |
| US20260067169A1 (en) | Autoencoder based anomaly detection and efficient storage of metrics data within a cloud environment | |
| FR3163218A3 (fr) | Procédé et système de constitution dynamique de réseaux électriques locaux |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: UNKNOWN |
|
| STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: THE INTERNATIONAL PUBLICATION HAS BEEN MADE |
|
| PUAI | Public reference made under article 153(3) epc to a published international application that has entered the european phase |
Free format text: ORIGINAL CODE: 0009012 |
|
| STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: REQUEST FOR EXAMINATION WAS MADE |
|
| 17P | Request for examination filed |
Effective date: 20250808 |
|
| AK | Designated contracting states |
Kind code of ref document: A1 Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC ME MK MT NL NO PL PT RO RS SE SI SK SM TR |
|
| DAV | Request for validation of the european patent (deleted) | ||
| DAX | Request for extension of the european patent (deleted) | ||
| STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: EXAMINATION IS IN PROGRESS |
|
| 17Q | First examination report despatched |
Effective date: 20260611 |