CN112541718A - Material processing method and device - Google Patents
Material processing method and device Download PDFInfo
- Publication number
- CN112541718A CN112541718A CN201910895303.7A CN201910895303A CN112541718A CN 112541718 A CN112541718 A CN 112541718A CN 201910895303 A CN201910895303 A CN 201910895303A CN 112541718 A CN112541718 A CN 112541718A
- Authority
- CN
- China
- Prior art keywords
- information
- message queue
- auditing
- character string
- main key
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/546—Message passing systems or structures, e.g. queues
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a material processing method and a device, and the specific implementation scheme is that material attribute information and position information of a material are obtained from a message queue; constructing an information storage table based on the material attribute information and the position information; the material attribute information comprises a plurality of identity information of the material; generating a first main key of the material by using at least one piece of identity information; and storing the first primary key into the database in association with the information storage table. According to the method and the device, the first main key is generated by adopting the identity information of the material, and the first main key and the information storage table are stored in the database in a correlation mode, so that the generated first main key can be used as the identification of the material, and the technical effects of quickly searching the information storage table of the material from the database by using the first main key and quickly searching the information of the required material by using the information storage table are achieved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for processing a material.
Background
In the current material auditing process, all auditing states of the material are printed to a local file system through logs for recording. However, some materials, such as advertising materials, have a large audit volume. Even if the audit states of all materials at all stages are recorded through logs, the information of the materials to be inquired is difficult to be inquired and positioned from a plurality of logs quickly.
Disclosure of Invention
The embodiment of the application provides a material processing method and device, which are used for solving one or more technical problems in the prior art.
In a first aspect, an embodiment of the present application provides a material processing method, including:
acquiring material attribute information and position information of a material from a message queue;
constructing an information storage table based on the material attribute information and the position information; the material attribute information comprises a plurality of identity information of the material;
generating a first main key of the material by using at least one piece of identity information;
and storing the first primary key into the database in association with the information storage table.
In this embodiment, because the first primary key is generated by using the identity information of the material, the generated first primary key can be used as the unique identifier of the material, and the associated information storage table can be quickly and accurately found from the database through the first primary key. And the information storage table is constructed based on the material attribute information and the position information, but not all information of the material, so that the processing performance of the data is not influenced.
In one embodiment, obtaining material attribute information and location information of a material from a message queue includes:
and acquiring material attribute information and position information of the material in the corresponding message queue from at least one of the input message queue, the output message queue, the audit message queue and the audit abnormal message queue.
According to the method and the device for searching the material attribute information, the material attribute information and the position information of the material in the corresponding message queue are obtained, so that the material attribute information and the position information in the corresponding message queue can be utilized to search the related material information of the material in different stages. The material information includes any information related to the material.
In one embodiment, the material processing method further comprises:
subscribing at least one of an input message queue, an output message queue, an audit message queue and an audit exception message queue;
the input message queue is used for storing material information input into the auditing unit, the output message queue is used for storing material auditing information output by the auditing unit, the auditing message queue is used for storing material auditing information for performing secondary auditing on the material auditing information output by the auditing unit, and the auditing abnormal message queue is used for storing abnormal material information audited by the auditing unit.
According to the embodiment, the different message queues are subscribed, so that the related material information of the material at different stages can be quickly and accurately acquired from each message queue.
In one embodiment, generating a first primary key for a material using at least one identity information includes:
converting at least one piece of identity information into a character string format to obtain a first character string;
and carrying out system conversion on the first character string to generate a first main key.
In the embodiment, the length of the first primary key character string can be compressed by carrying out the binary conversion on the identity information, so that the storage space of the database is saved.
In one embodiment, the material processing method further comprises:
acquiring at least one target identity information from a plurality of identity information of a material to be inquired;
generating a second main key of the material to be inquired by using the target identity information;
searching a first primary key corresponding to the second primary key from a database;
and acquiring an information storage table of the material to be inquired from the database according to the first main key corresponding to the second main key.
The second primary key of this embodiment is generated by using the target identity information of the material to be queried, so that the first primary key generated by the identity information can be found by using the second primary key, and the information storage table of the material to be queried associated with the first primary key is obtained according to the first primary key.
In one embodiment, the material processing method further comprises:
acquiring material attribute information and position information of a material to be inquired according to an information storage table of the material to be inquired;
and acquiring the information of the material to be inquired from the target message queue according to the material attribute information and the position information of the material to be inquired.
According to the information storage table, the information queue required to be queried can be determined according to the material attribute information in the information storage table, and all information related to the material to be queried can be accurately acquired from the corresponding information queue according to the position information.
In one embodiment, generating the second primary key of the material to be queried by using the target identity information includes:
converting the target identity information into a character string format to obtain a second character string;
and carrying out binary conversion on the second character string to generate a second main key.
In this embodiment, the second character string converted from the target identity information is subjected to binary conversion, so that the generated second primary key can keep a uniform format with the first primary key, and it is ensured that the corresponding first primary key can be found according to the second primary key.
In a second aspect, an embodiment of the present application provides a material processing apparatus, including:
the first acquisition module is used for acquiring material attribute information and position information of the material from the message queue;
the building module is used for building an information storage table based on the material attribute information and the position information; the material attribute information comprises a plurality of identity information of the material;
the first generation module is used for generating a first main key of the material by utilizing at least one piece of identity information;
and the storage module is used for storing the first main key and the information storage table into the database in a correlation manner.
In one embodiment, the first obtaining module includes:
and the obtaining sub-module is used for obtaining material attribute information and position information of the material in the corresponding message queue from at least one of the input message queue, the output message queue, the audit message queue and the audit abnormal message queue.
In one embodiment, the material handling apparatus further comprises:
the subscription module is used for subscribing at least one of the input message queue, the output message queue, the audit message queue and the audit abnormal message queue;
the input message queue is used for storing material information input into the auditing unit, the output message queue is used for storing material auditing information output by the auditing unit, the auditing message queue is used for storing material auditing information for performing secondary auditing on the material auditing information output by the auditing unit, and the auditing abnormal message queue is used for storing abnormal material information audited by the auditing unit.
In one embodiment, the first generating module comprises:
the first conversion submodule is used for converting at least one piece of identity information into a character string format to obtain a first character string;
and the first generation submodule is used for carrying out system conversion on the first character string to generate a first main key.
In one embodiment, the material handling apparatus further comprises:
the second acquisition module is used for acquiring at least one target identity information from the plurality of identity information of the material to be inquired;
the second generation module is used for generating a second main key of the material to be inquired by utilizing the target identity information;
the searching module is used for searching a first main key corresponding to the second main key from the database;
and the third acquisition module is used for acquiring the information storage table of the material to be inquired from the database according to the first main key corresponding to the second main key.
In one embodiment, the material handling apparatus further comprises:
the fourth acquisition module is used for acquiring the material attribute information and the position information of the material to be inquired according to the information storage table;
and the fifth acquisition module is used for acquiring the information of the material to be inquired from the target message queue according to the material attribute information and the position information of the material to be inquired.
In one embodiment, the second generating module comprises:
the second conversion submodule is used for converting the target identity information into a character string format to obtain a second character string;
and the second generation submodule is used for carrying out binary conversion on the second character string to generate a second main key.
In a third aspect, an embodiment of the present application provides an electronic device, where functions of the electronic device may be implemented by hardware, or may be implemented by hardware executing corresponding software. The hardware or software includes one or more modules corresponding to the above-described functions.
In one possible design, the electronic device includes a processor and a memory, the memory is used for storing a program for supporting the electronic device to execute the material processing method, and the processor is configured to execute the program stored in the memory. The electronic device may also include a communication interface for communicating with other devices or a communication network.
In a fourth aspect, embodiments of the present application provide a non-transitory computer-readable storage medium storing computer instructions for an electronic device and computer software instructions for the electronic device, which include a program for executing the above material processing.
One embodiment in the above application has the following advantages or benefits: according to the method and the device, the first main key is generated by adopting the identity information of the material, and the first main key and the information storage table are stored in the database in a correlation mode, so that the generated first main key can be used as the identification of the material, the technical effects that the information storage table of the material is quickly searched from the database by using the first main key, the information of the required material is quickly searched by using the information storage table are achieved, and the technical problem that the information of the material cannot be quickly acquired is solved.
Other effects of the above-described alternative will be described below with reference to specific embodiments.
Drawings
The drawings are included to provide a better understanding of the present solution and are not intended to limit the present application. Wherein:
FIG. 1 is a schematic flow diagram of a method of material handling according to a first embodiment of the present application;
FIG. 2 is a schematic flow diagram of another method of material handling according to a first embodiment of the present application;
FIG. 3 is a schematic flow diagram of another method of material handling according to a first embodiment of the present application;
FIG. 4 is a diagram illustrating an application example of a material processing method according to a first embodiment of the present application;
FIG. 5 is a diagram illustrating an application example of a material processing method according to a first embodiment of the present application;
FIG. 6 is a diagram illustrating an application example of a material processing method according to a first embodiment of the present application;
FIG. 7 is a schematic flow chart diagram illustrating step S300 of a material processing method according to a first embodiment of the present application;
FIG. 8 is a schematic flow chart diagram of another method of material handling according to the first embodiment of the present application;
FIG. 9 is a schematic flow chart diagram of another method of material handling according to the first embodiment of the present application;
FIG. 10 is a flow chart illustrating a step S700 of a material processing method according to a first embodiment of the present application;
FIG. 11 is a schematic view of a material handling apparatus according to a second embodiment of the present application;
FIG. 12 is a schematic view of a first acquisition module of a material handling apparatus according to a second embodiment of the present application;
FIG. 13 is a schematic view of another material handling apparatus according to a second embodiment of the present application;
FIG. 14 is a schematic diagram of a first generation module of a material handling apparatus according to a second embodiment of the present application;
FIG. 15 is a schematic view of another material handling apparatus according to a second embodiment of the present application;
FIG. 16 is a schematic view of another material handling apparatus according to a second embodiment of the present application;
FIG. 17 is a schematic diagram of a second generation module of a material handling apparatus according to a second embodiment of the present application;
fig. 18 is a block diagram of an electronic device for implementing a material handling method according to an embodiment of the present application.
Detailed Description
The following description of the exemplary embodiments of the present application, taken in conjunction with the accompanying drawings, includes various details of the embodiments of the application for the understanding of the same, which are to be considered exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the present application. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
According to a first embodiment of the present application, there is provided a material handling method, as shown in fig. 1, comprising:
s100: and acquiring material attribute information and position information of the material from the message queue.
A message queue may be understood as a container for storing information data during the processing of a material. Information data of a plurality of materials can be stored in one message queue.
The material may include advertising material, film material, news material, etc. The material property information may include a plurality of information associated with the material. For example, the material attribute information may include a plurality of identification information (id) associated with the material, version information of the material, content information of the material, name information of the material, and the like. The location information of the material may include a pipe index (pielet index), a message id, a sequence id, and the like. The position of the material in the message queue can be accurately obtained through the pipe let index, the message id and the sequence id.
S200: and constructing an information storage table based on the material attribute information and the position information. The material attribute information comprises a plurality of identity information of the material.
The plurality of identity information for the item may include any identity information associated with the item retrieved from the message queue. For example, the identity information may include a product id, a user id, a version id, etc. of the item.
In one example, to ensure that the generated first primary key can serve as a unique identifier representing the item, the first primary key for the item may be generated using a plurality of selected identity information. The specific required identity information and the quantity of the identity information can be selected and adjusted according to the type of the material.
S300: generating a first primary key (row key) of the material by using the at least one identity information. The first primary key may be a string of a certain length.
S400: and storing the first primary key into the database in association with the information storage table. The first main key is used for indexing and distinguishing information storage tables of various materials. The information storage table of the corresponding material can be indexed through all character strings or partial character strings of the first main key.
In the embodiment, the first main key of the material is generated through the identity information, so that the generated first main key can be used as the identification of the material. In this embodiment, the first main key and the information storage table are stored in the database in a correlated manner, so that the information storage table can be quickly acquired from the database by the first main key. And because the material attribute information and the position information are stored in the information storage table, but not all the information of the materials, the data processing performance is not influenced. And moreover, all information of the materials can be quickly obtained by indexing to the corresponding message queue through the material attribute information and the position information.
In one embodiment, as shown in fig. 2, the obtaining material attribute information and location information of a material from a message queue includes:
s110: and acquiring material attribute information and position information of the material in the corresponding message queue from at least one of the input message queue, the output message queue, the audit message queue and the audit abnormal message queue.
In this embodiment, by obtaining the material attribute information and the position information of the material in the corresponding message queue, it is possible to search all information of the material at different stages by using the material attribute information and the position information in the corresponding message queue.
In one embodiment, as shown in fig. 3, the material processing method further includes:
s500: subscribing to at least one of the input message queue, the output message queue, the audit message queue, and the audit exception message queue.
The input message queue is used for storing material information input into the auditing unit, the output message queue is used for storing material auditing information output by the auditing unit, the auditing message queue is used for storing material auditing information for performing secondary auditing on the material auditing information output by the auditing unit, and the auditing abnormal message queue is used for storing abnormal material information audited by the auditing unit.
According to the embodiment, the message queue is subscribed, so that the material information related to the material can be quickly and accurately acquired from the message queue.
In one example, the material information stored by the input message queue may include: material attribute information, position information, and the like. The material audit information stored by the output message queue may include: material attribute information, position information, material auditing information generated by auditing the material through a machine, and the like. The material audit information stored by the audit message queue may include: material attribute information, position information, material auditing information generated by manually carrying out secondary auditing on machine auditing results, and the like. The auditing of the abnormal material information stored by the abnormal message queue may include: material attribute information, position information, specific abnormality reason information and the like of the abnormal material.
In one example, the material audit process as shown in fig. 4 includes a material input, material audit, and material write back (i.e., material output) process. The material input process may include a process of inputting material into an audit unit. The material auditing process can comprise a process of auditing the material by the material auditing unit. The material write-back process can comprise a process of outputting material audit information by the audit unit.
In one example, a method of material processing includes:
and synchronously subscribing the input message queue, the output message queue, the audit message queue and the audit abnormal message queue.
And respectively acquiring material attribute information and position information of all audit materials in the input message queue, the output message queue, the audit message queue and the audit abnormal message queue.
And packaging the material attribute information and the position information of all the checking materials in each message queue (an input message queue, an output message queue, a checking message queue and a checking abnormal message queue) into a protocol buffer form, and sending the protocol buffer form to a downstream parser module for processing.
After the parser module obtains the data of the upstream subscription, deserializing the serialized pb (protobuf). And positioning and tracking a type of target material needing tracking (trace). And then extracting the material information of each material in the target material, acquiring the identity information and the position information in each message queue, packaging into a new protobuf format only recording key information, and sending to a downstream trace-export module for processing.
the trace-exporter module is mainly responsible for warehousing of material information, and since each material in a class of target materials sent upstream is subscribed from different message queues, information of the same material from different message queues needs to be aggregated. And constructing an information storage table of the material according to a plurality of identity information of the same material from different message queues, and material attribute information and position information from different message queues.
In one example, as shown in FIG. 5, the constructed information storage table includes at least five columns of information. The information of the id information of the material, the information of the input message queue, the information of the output message queue, the information of the audit message queue and the information of the audit abnormal message queue. Wherein, the id information of the material may include: multiple identity information of the material or all identity information of the material. The information of the input message queue may include: the method comprises the following steps of obtaining a plurality of identity information of materials in an input message queue, material attribute information of the materials in the input message queue and position information of the materials in the input message queue. The information of the output message queue may include: the method comprises the following steps of obtaining a plurality of identity information of materials in an output message queue, material attribute information of the materials in the output message queue, position information of the materials in the output message queue and additional information (texts, pictures, rejected texts and rejected images in the materials) of the materials. The information of the audit message queue may include: and the machine audits and sends a plurality of identity information of the manually audited materials, material attribute information of the materials in the audit message queue and position information of the materials in the audit message queue. The information for auditing the exception message queue may include: the method comprises the following steps of obtaining a plurality of identity information of abnormal materials, material attribute information of the abnormal materials, position information of the materials in an audit abnormal message queue and specific abnormal information of the abnormal materials. Since the amount of abnormal materials is usually small, recording specific abnormal information into the information storage table hardly has any influence on the information processing performance.
In one example, in a material auditing process, if a material is abnormal, the material is directly recorded into an auditing abnormal message queue, but not recorded into an output message queue or an auditing message queue.
In one example, as shown in FIG. 6, the information in the audit exception message queue is typically recorded material exception information that occurred at the machine audit. The machine auditing module specifically includes a first auditing module (e.g., a server module), a second auditing module (e.g., a pair auditing module), and a third auditing module (e.g., an lp (mapping page) editor module, a landing page auditing module). After the materials are processed in failure, the three modules can carry out back-plugging processing on the failed materials, and the materials can be clamped on a machine for checking as a result, so that the checking result cannot be obtained. And the information of the material in the abnormal audit message queue can be obtained by extracting the back-blocking information of each module. The extracted echo information is finally generated into an information storage table and stored into a database.
In one embodiment, as shown in fig. 7, generating a first primary key for a material using at least one identity information includes:
s310: and converting at least one piece of identity information into a character string format to obtain a first character string.
S320: and carrying out system conversion on the first character string to generate a first main key.
In the embodiment, the length of the first primary key character string can be compressed by carrying out the binary conversion on the identity information, so that the storage space of the database is saved.
In one example, although different materials may have the same type of identity information, even identity information with the same content, if multiple identity information of the same material are combined, the situation that the identical information exists after the combination does not occur. Therefore, the plurality of identity information of the material are respectively converted into a character string format and spliced according to a preset sequence to form a first character string. A first string unique to the item may be obtained and a unique first primary key generated.
In one example, when the material is advertising material, the plurality of identity information utilized to generate the first primary key may include: product id, user id, idea id, mc id, unit id, plan id, and version id.
In one example, the plurality of identity information of the material is a numeric id, and each numeric id is converted into a decimal character string format and is spliced together to form a first character string of the material. And then the first character string is converted into characters from 32 to 126 in ASCII (American Standard Code for Information Interchange) Code, thereby realizing the purpose of converting decimal numbers into printable characters with 94 systems, and effectively shortening the length of the character string of the first main key.
In one embodiment, as shown in fig. 8, the material processing method further includes:
s600: at least one target identity information is obtained from a plurality of identity information of the material to be inquired.
S700: and generating a second main key of the material to be inquired by using the target identity information.
S800: and searching the first primary key corresponding to the second primary key from the database.
S900: and acquiring an information storage table of the material to be inquired from the database according to the first main key corresponding to the second main key.
The second primary key of this embodiment is generated by using the target identity information of the material to be queried, so that the first primary key generated by the identity information can be found by using the second primary key, and the information storage table of the material to be queried associated with the first primary key is obtained according to the first primary key.
In one example, finding a first primary key corresponding to a second primary key from the database may be understood as: the database comprises a first primary key which is identical to the second primary key, or the database comprises the first primary key containing all information of the second primary key.
In one embodiment, as shown in fig. 9, the material processing method further includes:
s1000: and acquiring material attribute information and position information of the material to be inquired according to the information storage table of the material to be inquired.
S1100: and acquiring the information of the material to be inquired from the target message queue according to the material attribute information and the position information of the material to be inquired.
According to the information storage table, the information queue required to be queried can be determined according to the material attribute information in the information storage table, and all information related to the material to be queried can be accurately acquired from the corresponding information queue according to the position information.
In one embodiment, as shown in fig. 10, generating the second primary key of the material to be queried by using the target identity information includes:
s710: and converting the target identity information into a character string format to obtain a second character string.
S720: and carrying out binary conversion on the second character string to generate a second main key.
In this embodiment, the second character string converted from the target identity information is subjected to binary conversion, so that the generated second primary key can keep a uniform format with the first primary key, and it is ensured that the corresponding first primary key can be found according to the second primary key.
In one example, the target identity information of the material to be queried utilized may include the same type of identity information utilized in generating the first primary key of the material. Therefore, the second primary key generated by the target identity information can be indexed to the corresponding first primary key from the database.
In one example, the number of target identity information utilized to form the second primary key may be less than the number of identity information forming the first primary key. So that the second primary key is formed to contain only a portion of the character string in the first primary key. The first primary key which corresponds uniquely can also be found from the database by this partial character conversion. For example, when the identity information utilized to construct the first primary key includes product id, user id, idea id, mc id, unit id, plan id, and version id. The identity information utilized to construct the second primary key may include only product id, user id, and idea id.
In another example, the number of target identity information utilized to form the second primary key may be equal to the number of identity information forming the first primary key. So that the character string of the second primary key is formed to coincide with the character string in the first primary key. Therefore, the unique corresponding first main key can be quickly and accurately found from the database through the character string of the second main key. For example, when the identity information utilized to construct the first primary key includes product id, user id, idea id, mc id, unit id, plan id, and version id. The identity information utilized to construct the second primary key may also include product id, user id, idea id, mc id, unit id, plan id, and version id.
According to a second embodiment of the present application, there is provided a material handling apparatus, as shown in fig. 11, the material handling apparatus 1000 comprising:
the first obtaining module 10 is configured to obtain material attribute information and position information of a material from the message queue.
The building module 20 is used for building an information storage table based on the material attribute information and the position information; the material attribute information comprises a plurality of identity information of the material.
The first generating module 30 is configured to generate a first primary key of the material by using the at least one identity information.
And the storage module 40 is used for storing the first main key into the database in association with the information storage table.
In one embodiment, as shown in fig. 12, the first obtaining module 10 includes:
the obtaining sub-module 11 is configured to obtain material attribute information and position information of the material in the corresponding message queue from at least one of the input message queue, the output message queue, the audit message queue, and the audit exception message queue.
In one embodiment, as shown in fig. 13, the material processing apparatus 1000 further comprises:
the subscription module 50 is configured to subscribe at least one of the input message queue, the output message queue, the audit message queue, and the audit exception message queue.
The input message queue is used for storing material information input into the auditing unit, the output message queue is used for storing material auditing information output by the auditing unit, the auditing message queue is used for storing material auditing information for performing secondary auditing on the material auditing information output by the auditing unit, and the auditing abnormal message queue is used for storing abnormal material information audited by the auditing unit.
In one embodiment, as shown in FIG. 14, the first generation module 30 includes:
the first converting submodule 31 is configured to convert at least one piece of identity information into a character string format, so as to obtain a first character string.
The first generating submodule 32 is configured to perform binary conversion on the first character string to generate a first main key.
In one embodiment, as shown in fig. 15, the material processing apparatus 1000 further comprises:
the second obtaining module 60 is configured to obtain at least one target identity information from the plurality of identity information of the material to be queried.
And a second generating module 70, configured to generate a second primary key of the material to be queried by using the target identity information.
And a searching module 80, configured to search the database for the first primary key corresponding to the second primary key.
And a third obtaining module 90, configured to obtain an information storage table of the material to be queried from the database according to the first primary key corresponding to the second primary key.
In one embodiment, as shown in fig. 16, the material processing apparatus 1000 further comprises:
a fourth obtaining module 100, configured to obtain material attribute information and position information of the material to be queried according to the information storage table;
a fifth obtaining module 110, configured to obtain information of the material to be queried from the target message queue according to the material attribute information and the position information of the material to be queried.
In one embodiment, as shown in fig. 17, the second generating module 70 includes:
the second converting sub-module 71 is configured to convert the target identity information into a character string format, so as to obtain a second character string.
And the second generating submodule 72 is configured to perform binary conversion on the second character string to generate a second main key.
According to an embodiment of the present application, an electronic device and a readable storage medium are also provided.
Fig. 18 is a block diagram of an electronic device of a method of material handling according to an embodiment of the present application. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the present application that are described and/or claimed herein.
As shown in fig. 18, the electronic apparatus includes: one or more processors 901, memory 902, and interfaces for connecting the various components, including a high-speed interface and a low-speed interface. The various components are interconnected using different buses and may be mounted on a common motherboard or in other manners as desired. The processor may process instructions for execution within the electronic device, including instructions stored in or on the memory to display Graphical information for a Graphical User Interface (GUI) on an external input/output device, such as a display device coupled to the Interface. In other embodiments, multiple processors and/or multiple buses may be used, along with multiple memories and multiple memories, as desired. Also, multiple electronic devices may be connected, with each device providing portions of the necessary operations (e.g., as a server array, a group of blade servers, or a multi-processor system). Fig. 18 illustrates an example of a processor 901.
The memory 902 may include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the electronic device for material handling, and the like. Further, the memory 902 may include high speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, memory 902 may optionally include memory located remotely from processor 901, which may be connected to the material handling electronics via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The electronic device of the method of material handling may further comprise: an input device 903 and an output device 904. The processor 901, the memory 902, the input device 903, and the output device 904 may be connected by a bus or other means, and fig. 18 illustrates an example of connection by a bus.
The input device 903 may receive input numeric or character information and generate key signal inputs related to user settings and function controls of the material handling electronic device, such as a touch screen, keypad, mouse, track pad, touch pad, pointer stick, one or more mouse buttons, track ball, joystick, or other input device. The output devices 904 may include a display device, auxiliary lighting devices (e.g., LEDs), tactile feedback devices (e.g., vibrating motors), and the like. The Display device may include, but is not limited to, a Liquid Crystal Display (LCD), a Light Emitting Diode (LED) Display, and a plasma Display. In some implementations, the display device can be a touch screen.
Various implementations of the systems and techniques described here can be realized in digital electronic circuitry, Integrated circuitry, Application Specific Integrated Circuits (ASICs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
These computer programs (also known as programs, software applications, or code) include machine instructions for a programmable processor, and may be implemented using high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. As used herein, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, apparatus, and/or device (e.g., magnetic discs, optical disks, memory, Programmable Logic Devices (PLDs)) used to provide machine instructions and/or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term "machine-readable signal" refers to any signal used to provide machine instructions and/or data to a programmable processor.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (Cathode Ray Tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), and the internet.
The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other.
This application embodiment is owing to generate the first primary key of material through identity information, consequently makes the only sign that first primary key that generates can regard as the material. In this embodiment, the first main key and the information storage table are stored in the database in a correlated manner, so that the information storage table can be quickly acquired from the database by the first main key. And because the material attribute information and the position information are stored in the information storage table, but not all the information of the materials, the data processing performance is not influenced. And moreover, all necessary state information of the materials can be quickly obtained by indexing to the corresponding message queue through the material attribute information and the position information, the traditional log recording mode is broken, the materials are checked and obtained by standing at the periphery of the system, and the checking state is reversely deduced.
According to the embodiment, the unique first main key corresponding to the material can be acquired by splicing the plurality of identity information, so that the information storage table corresponding to the material can be acquired from the database quickly and accurately according to the first main key. And the first character string forming the first main key is subjected to binary conversion, so that the length of the character string of the first main key can be compressed, and the storage space of the database is saved.
According to the technical scheme of the embodiment of the application, the technical means that the behavior tracks are constructed in the space-time coordinate system by utilizing the position information and the time information and the similarity of the two behavior tracks is calculated based on the minimum editing distance are adopted, so that the technical problem that the time factor is ignored when the behavior tracks are constructed and analyzed in the two-dimensional plane coordinate system is solved, and the technical effect of more accurately obtaining the behavior track similarity of the target object is achieved.
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the present application may be executed in parallel, sequentially, or in different orders, and the present invention is not limited thereto as long as the desired results of the technical solutions disclosed in the present application can be achieved.
The above-described embodiments should not be construed as limiting the scope of the present application. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (16)
1. A method of material handling, comprising:
acquiring material attribute information and position information of a material from a message queue;
constructing an information storage table based on the material attribute information and the position information; the material attribute information comprises a plurality of identity information of the material;
generating a first primary key of the material by using at least one piece of identity information;
and storing the first primary key into a database in association with the information storage table.
2. The method of claim 1, wherein obtaining material property information and location information for the material from the message queue comprises:
and acquiring material attribute information and position information of the material in the corresponding message queue from at least one of the input message queue, the output message queue, the audit message queue and the audit abnormal message queue.
3. The method of claim 2, further comprising:
subscribing at least one of the input message queue, the output message queue, the audit message queue and the audit exception message queue;
the input message queue is used for storing material information input into an auditing unit, the output message queue is used for storing material auditing information output by the auditing unit, the auditing message queue is used for storing material auditing information for performing secondary auditing on the material auditing information output by the auditing unit, and the auditing abnormal message queue is used for storing abnormal material information audited by the auditing unit.
4. The method of claim 1, wherein generating a first primary key for the material using at least one of the identity information comprises:
converting at least one piece of identity information into a character string format to obtain a first character string;
and carrying out binary conversion on the first character string to generate the first main key.
5. The method of claim 1, further comprising:
acquiring at least one target identity information from a plurality of identity information of a material to be inquired;
generating a second main key of the material to be inquired by using the target identity information;
searching a first primary key corresponding to the second primary key from the database;
and acquiring an information storage table of the material to be inquired from the database according to the first main key corresponding to the second main key.
6. The method of claim 5, further comprising:
acquiring material attribute information and position information of the material to be inquired according to the information storage table of the material to be inquired;
and acquiring the information of the material to be inquired from a target message queue according to the material attribute information and the position information of the material to be inquired.
7. The method of claim 5, wherein generating a second primary key of the material to be queried using the target identity information comprises:
converting the target identity information into a character string format to obtain a second character string;
and carrying out binary conversion on the second character string to generate the second main key.
8. A material handling apparatus, comprising:
the first acquisition module is used for acquiring material attribute information and position information of the material from the message queue;
the building module is used for building an information storage table based on the material attribute information and the position information; the material attribute information comprises a plurality of identity information of the material;
the first generation module is used for generating a first main key of the material by utilizing at least one piece of identity information;
and the storage module is used for storing the first main key and the information storage table into a database in a correlation manner.
9. The apparatus of claim 8, wherein the first obtaining module comprises:
and the obtaining sub-module is used for obtaining material attribute information and position information of the material in the corresponding message queue from at least one of the input message queue, the output message queue, the audit message queue and the audit abnormal message queue.
10. The apparatus of claim 9, further comprising:
a subscription module, configured to subscribe at least one of the input message queue, the output message queue, the audit message queue, and the audit exception message queue;
the input message queue is used for storing material information input into an auditing unit, the output message queue is used for storing material auditing information output by the auditing unit, the auditing message queue is used for storing material auditing information for performing secondary auditing on the material auditing information output by the auditing unit, and the auditing abnormal message queue is used for storing abnormal material information audited by the auditing unit.
11. The apparatus of claim 8, wherein the first generating module comprises:
the first conversion submodule is used for converting at least one piece of identity information into a character string format to obtain a first character string;
and the first generation submodule is used for carrying out binary conversion on the first character string to generate the first main key.
12. The apparatus of claim 8, further comprising:
the second acquisition module is used for acquiring at least one target identity information from the plurality of identity information of the material to be inquired;
the second generation module is used for generating a second main key of the material to be inquired by utilizing the target identity information;
the searching module is used for searching a first main key corresponding to the second main key from the database;
and the third acquisition module is used for acquiring the information storage table of the material to be inquired from the database according to the first main key corresponding to the second main key.
13. The apparatus of claim 12, further comprising:
the fourth acquisition module is used for acquiring the material attribute information and the position information of the material to be inquired according to the information storage table;
and the fifth acquisition module is used for acquiring the information of the material to be inquired from the target message queue according to the material attribute information and the position information of the material to be inquired.
14. The apparatus of claim 12, wherein the second generating module comprises:
the second conversion submodule is used for converting the target identity information into a character string format to obtain a second character string;
and the second generation submodule is used for carrying out binary conversion on the second character string to generate the second main key.
15. An electronic device, comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-7.
16. A non-transitory computer readable storage medium having stored thereon computer instructions for causing the computer to perform the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910895303.7A CN112541718B (en) | 2019-09-20 | 2019-09-20 | Material processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910895303.7A CN112541718B (en) | 2019-09-20 | 2019-09-20 | Material processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112541718A true CN112541718A (en) | 2021-03-23 |
| CN112541718B CN112541718B (en) | 2023-09-01 |
Family
ID=75012651
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910895303.7A Active CN112541718B (en) | 2019-09-20 | 2019-09-20 | Material processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112541718B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113947349A (en) * | 2021-09-28 | 2022-01-18 | 安徽云星空信息科技有限公司 | Material data processing method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110320019A1 (en) * | 2010-04-22 | 2011-12-29 | Ebay Inc. | Data mining system |
| US20120330954A1 (en) * | 2011-06-27 | 2012-12-27 | Swaminathan Sivasubramanian | System And Method For Implementing A Scalable Data Storage Service |
| CN105069665A (en) * | 2015-09-06 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Sorting and display method and apparatus of multi-channel off-site advertisement report data |
| CN107783975A (en) * | 2016-08-24 | 2018-03-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of distributed data base synchronization process |
| CN109376204A (en) * | 2018-11-27 | 2019-02-22 | 五八有限公司 | Message configuring method, message acquisition method, device, equipment and storage medium |
-
2019
- 2019-09-20 CN CN201910895303.7A patent/CN112541718B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110320019A1 (en) * | 2010-04-22 | 2011-12-29 | Ebay Inc. | Data mining system |
| US20120330954A1 (en) * | 2011-06-27 | 2012-12-27 | Swaminathan Sivasubramanian | System And Method For Implementing A Scalable Data Storage Service |
| CN105069665A (en) * | 2015-09-06 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Sorting and display method and apparatus of multi-channel off-site advertisement report data |
| CN107783975A (en) * | 2016-08-24 | 2018-03-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of distributed data base synchronization process |
| CN109376204A (en) * | 2018-11-27 | 2019-02-22 | 五八有限公司 | Message configuring method, message acquisition method, device, equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 杨艳梅;朱养鹏;: "长庆油田物料管理库存优化系统的分析与设计", 科技视界, no. 36 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113947349A (en) * | 2021-09-28 | 2022-01-18 | 安徽云星空信息科技有限公司 | Material data processing method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112541718B (en) | 2023-09-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111581216A (en) | Data processing method, device, equipment and storage medium | |
| CN111639027B (en) | Test method and device and electronic equipment | |
| CN112506479B (en) | Page editing method, device, equipment and storage medium | |
| CN110633281A (en) | Method and device for processing multi-type data sources | |
| CN111737965A (en) | Document comparison method and device, electronic equipment and readable storage medium | |
| CN112115113B (en) | Data storage system, method, device, equipment and storage medium | |
| CN112104734A (en) | Method, device, equipment and storage medium for pushing information | |
| CN112541359A (en) | Document content identification method and device, electronic equipment and medium | |
| CN111475164A (en) | Component dependency relationship detection method and device and electronic equipment | |
| CN112269706A (en) | Interface parameter checking method and device, electronic equipment and computer readable medium | |
| CN112395333A (en) | Method and device for checking data exception, electronic equipment and storage medium | |
| CN112491617A (en) | Link tracking method, device, electronic equipment and medium | |
| CN112541718B (en) | Material processing method and device | |
| CN111985760A (en) | Data content evaluation method and device, electronic equipment and storage medium | |
| CN112015845A (en) | Method, device and equipment for map retrieval test and storage medium | |
| KR20150136338A (en) | Method of creating multi tenancy history, server performing the same and storage media storing the same | |
| CN111596897B (en) | Code multiplexing processing method and device and electronic equipment | |
| CN111026916A (en) | Text description conversion method and device, electronic equipment and storage medium | |
| US9146958B2 (en) | System and method for report to report generation | |
| EP3992866A2 (en) | Method and apparatus for annotating data | |
| CN114661747A (en) | Index calculation method and device, storage medium and computer equipment | |
| CN108153834B (en) | Method and device for querying data by commercial intelligent application and electronic equipment | |
| CN110580322B (en) | Independent visitor information processing method and device, electronic equipment and storage medium | |
| CN112381167A (en) | Method for training task classification model, and task classification method and device | |
| CN111694931A (en) | Element acquisition method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |