An information processing method and apparatus

Abstract

The application discloses an information processing method and device, and relates to the technical field of computers. A specific implementation manner of the method comprises the following steps: acquiring attribute information of a new object, wherein the attribute information indicates attributes of the new object and corresponding attribute values; adding corresponding metadata information in a metadata configuration table according to the attribute information, wherein the metadata information indicates logical information and physical information corresponding to the attributes; storing the physical information and the attribute values corresponding to the attributes in a database according to the metadata information; and processing the physical information and the attribute values stored in the database based on the logical information in the case that the attribute information of the new object changes. The implementation manner realizes quick access and subsequent maintenance of the new object, and avoids the problem of database and underlying business code modification caused by different attributes of the new object.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to an information processing method and apparatus. Background Technology

[0002] In the process of asset management or securitization, when new assets need to be issued, it is necessary to connect the new assets to the corresponding service platform. This means storing an attribute table in the database that records the attributes of the new assets. Currently, there are two main ways to connect new assets: adapting to existing attribute tables; and generating new attribute tables.

[0003] In the process of realizing this invention, the inventors discovered that the prior art has at least the following problems: adapting to the existing attribute table will cause the meaning of the fields in the attribute table to not correspond one-to-one with the attributes of the new assets, and it may even be necessary to add new attribute fields to the existing attribute table; whether to directly generate a new attribute table or add attribute fields to the existing attribute table, the database needs to be modified; and in order to further realize the subsequent maintenance of new assets, the underlying business code also needs to be modified, which is cumbersome, costly and has poor scalability. Summary of the Invention

[0004] In view of this, embodiments of the present invention provide an information processing method and apparatus that can quickly access newly added objects, avoiding the problem of modifying the database and underlying business code due to different attributes of newly added objects; at the same time, it can maintain the corresponding information of newly added objects in the database based on the correspondence between the physical information and logical information of attributes, without having to pay attention to the underlying physical fields.

[0005] To achieve the above objectives, according to one aspect of the present invention, an information processing method is provided, comprising:

[0006] Obtain the attribute information of the newly added object, wherein the attribute information indicates the attributes of the newly added object and the corresponding attribute values;

[0007] Based on the attribute information, corresponding metadata information is added to the metadata configuration table. The metadata information indicates the logical and physical information corresponding to the attribute.

[0008] Based on the metadata information, the physical information and attribute values ​​corresponding to the attribute are stored in the database.

[0009] When the attribute information of the newly added object changes, the physical information and attribute values ​​stored in the database are processed based on the logical information.

[0010] Optionally, adding corresponding metadata information to the metadata configuration table based on the attribute information includes:

[0011] Select one or more attributes from the attribute information;

[0012] Determine the metadata information corresponding to the selected attribute, wherein the metadata information indicates the physical and logical information corresponding to the selected attribute;

[0013] The metadata information is stored in the metadata configuration table.

[0014] Optionally, processing the physical information and attribute values ​​stored in the database based on the logical information includes:

[0015] Write one or more first database command statements based on the business scenario. The first database command statements indicate the logical information and attribute values ​​corresponding to the attributes to be processed.

[0016] Based on the logical and physical information corresponding to the attribute to be processed, the first database command statement is converted into a second database command statement, which indicates the physical information and attribute value corresponding to the attribute to be processed.

[0017] The second database command statement is executed in batches to process the attribute to be processed.

[0018] Optionally, based on the processing operation performed by the first database command statement, the first database command statement can be modularized to generate one or more functional modules, the functional modules including at least one of the following: an attribute addition module, an attribute deletion module, and an attribute update module;

[0019] One or more of the aforementioned functional modules are selected and combined to process the attribute to be processed based on the combined functional modules.

[0020] Optionally, during the batch execution of the second database command statements, if any second database command statement fails to execute, the successfully executed second database command statements are rolled back to re-execute the second database command statements in batches.

[0021] Optionally, storing the physical information and attribute value corresponding to the attribute in the database based on the metadata information includes:

[0022] Determine whether the logical field corresponding to the physical field in the physical information in the metadata information is consistent with the logical field corresponding to the physical field in the database:

[0023] If they match, the physical field and attribute value corresponding to the attribute are written into the database; if they do not match, the physical field and logical field indicated by the metadata information are reconfigured.

[0024] Optionally, the first database command statement and the second database command statement can be written using a structured query language.

[0025] To achieve the above objectives, according to another aspect of the present invention, an information processing apparatus is provided, characterized in that it comprises: an information acquisition unit, an information configuration unit, an information storage unit, and an information processing unit; wherein,

[0026] The information acquisition unit is used to acquire the attribute information of the newly added object, wherein the attribute information indicates the attributes of the newly added object and the corresponding attribute values.

[0027] The information configuration unit is used to add corresponding metadata information to the metadata configuration table according to the attribute information, wherein the metadata information indicates the logical field and physical field corresponding to the attribute;

[0028] The information storage unit is used to store the physical fields and attribute values ​​corresponding to the attribute in the database according to the metadata information;

[0029] The information processing unit is used to process the physical fields and attribute values ​​stored in the database based on the logical fields when the attribute information of the newly added object changes.

[0030] Optionally, adding corresponding metadata information to the metadata configuration table based on the attribute information includes:

[0031] Select one or more attributes from the attribute information;

[0032] Determine the metadata information corresponding to the selected attribute, wherein the metadata information indicates the physical and logical information corresponding to the selected attribute;

[0033] The metadata information is stored in the metadata configuration table.

[0034] Optionally, processing the physical information and attribute values ​​stored in the database based on the logical information includes:

[0035] Write one or more first database command statements based on the business scenario. The first database command statements indicate the logical information and attribute values ​​corresponding to the attributes to be processed.

[0036] Based on the logical and physical information corresponding to the attribute to be processed, the first database command statement is converted into a second database command statement, which indicates the physical information and attribute value corresponding to the attribute to be processed.

[0037] The second database command statement is executed in batches to process the attribute to be processed.

[0038] Optionally, the information processing unit is further configured to modularize the first database command statement to generate one or more functional modules based on the processing operation performed by the first database command statement, wherein the functional modules include at least one of the following: an attribute addition module, an attribute deletion module, and an attribute update module.

[0039] One or more of the aforementioned functional modules are selected and combined to process the attribute to be processed based on the combined functional modules.

[0040] Optionally, the information processing unit is further configured to, during the process of batch executing the second database command statements, if there is a failure in the execution of a second database command statement, roll back the second database command statements that have been successfully executed, so as to re-execute the second database command statements in batches.

[0041] Optionally, storing the physical information and attribute value corresponding to the attribute in the database based on the metadata information includes:

[0042] Determine whether the logical field corresponding to the physical field in the physical information in the metadata information is consistent with the logical field corresponding to the physical field in the database:

[0043] If they match, the physical field and attribute value corresponding to the attribute are written into the database; if they do not match, the physical field and logical field indicated by the metadata information are reconfigured.

[0044] Optionally, the information processing unit is further configured to write the first database command statement and the second database command statement using a structured query language.

[0045] To achieve the above objectives, according to another aspect of the present invention, an electronic device for information processing is provided, comprising: one or more processors; and a storage device for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors implement any of the information processing methods described above.

[0046] To achieve the above objectives, according to another aspect of the present invention, a computer-readable medium is provided having a computer program stored thereon, which, when executed by a processor, implements any of the information processing methods described above.

[0047] One embodiment of the above invention has the following advantages or beneficial effects: By configuring metadata information and directly storing the physical information and attribute values ​​corresponding to the attributes in the database, the rapid access of new objects is realized, avoiding the problem of modifying the database and underlying business code due to different attributes of new objects, improving the universality and scalability of the new object access method; at the same time, based on the correspondence between physical information and logical information in the metadata information, it is possible to maintain the attribute information of new objects in the database without having to pay attention to the underlying physical fields, thereby improving operational efficiency and reducing maintenance costs.

[0048] The further effects of the aforementioned unconventional alternative methods will be explained below in conjunction with specific implementation methods. Attached Figure Description

[0049] The accompanying drawings are provided to better understand the invention and are not intended to unduly limit the scope of the invention. Wherein:

[0050] Figure 1 This is a schematic diagram of the main flow of the information processing method according to an embodiment of the present invention;

[0051] Figure 2 This is a schematic diagram of the main flow of another information processing method according to an embodiment of the present invention;

[0052] Figure 3 This is a schematic diagram of the main units of an information processing apparatus according to an embodiment of the present invention;

[0053] Figure 4 This is an exemplary system architecture diagram in which embodiments of the present invention can be applied;

[0054] Figure 5 This is a schematic diagram of the structure of a computer system suitable for implementing terminal devices or servers of the present invention. Detailed Implementation

[0055] The following description, in conjunction with the accompanying drawings, illustrates exemplary embodiments of the present invention, including various details to aid understanding. These details should be considered merely exemplary. Therefore, those skilled in the art will recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of the invention. Similarly, for clarity and brevity, descriptions of well-known functions and structures are omitted in the following description.

[0056] Figure 1 This is a schematic diagram of the main flow of the information processing method according to an embodiment of the present invention, such as... Figure 1 As shown, the information processing method may specifically include the following steps:

[0057] Step S101: Obtain the attribute information of the newly added object, wherein the attribute information indicates the attributes of the newly added object and the corresponding attribute values.

[0058] New assets refer to different types of assets that need to be connected to the asset management platform for securitization or management, including but not limited to: bank claims such as auto loans, personal housing mortgage loans, and consumer loans, as well as corporate claims such as rental income, infrastructure fees, ticket revenue, real estate investment trusts, microloans, margin trading claims, and trust beneficiary rights. Attribute information is used to describe or define the information of the new assets. For example, taking microloans as a new asset, the attribute information includes, but is not limited to, principal, interest, final repayment date, repayment method, and corresponding attribute values.

[0059] Step S102: Based on the attribute information, add corresponding metadata information to the metadata configuration table. The metadata information indicates the logical and physical information corresponding to the attribute.

[0060] Metadata information refers to the information used to describe the attributes of newly added objects. It's understandable that a new object may have multiple attributes, but not all attributes need to be stored in the database to enable the integration of new objects. Therefore, attributes can be selected according to actual business needs, and only the metadata information corresponding to the selected attributes can be added to the metadata configuration table.

[0061] Specifically, adding corresponding metadata information to the metadata configuration table based on the attribute information includes: selecting one or more attributes from the attribute information; determining the metadata information corresponding to the selected attributes, wherein the metadata information indicates the physical information and logical information corresponding to the selected attributes; wherein the physical information may include: physical fields and the physical table name corresponding to the physical fields; the logical information may include: logical fields, the logical table name corresponding to the logical fields, the meaning of the fields, and the type of the fields; and storing the metadata information in the metadata configuration table. More specifically, see the metadata configuration table described in Table 1 below.

[0062] Table 1. Example of metadata configuration

[0063]

[0064] Step S103: Based on the metadata information, store the physical information and attribute value corresponding to the attribute in the database.

[0065] Specifically, a fixed script is written to read metadata information from the metadata configuration table and write it into the database to enable the integration of new objects. For example, a fixed script composed of multiple SQL statements is written using Structured Query Language (SQL) to retrieve all metadata information corresponding to the new object from the metadata configuration table, query and summarize the physical fields corresponding to all attributes, ensuring the comprehensiveness and reliability of the physical fields corresponding to attributes written into the database. More specifically, the physical information and attribute values ​​stored in the physical table Table1 of the database are shown in Table 2 below.

[0066] Table 2 shows examples of physical information and attribute values ​​stored in the database.

[0067] physical field a b c …… Attribute value 100 10 2022-04-01 ……

[0068] Therefore, in this embodiment of the invention, only the physical fields and attribute values ​​from the metadata information are stored in the database, and no logical fields are stored. This allows for the adaptation of attributes of different newly added objects based on the inherent physical fields in the database physical table, without modifying the database structure; furthermore, database command statements can be directly written based on logical fields to maintain the attribute information of newly added objects, without needing to concern themselves with the meaning of the physical fields in the database, simplifying operations and improving maintenance efficiency.

[0069] In another embodiment of the present invention, storing the physical information and attribute value corresponding to the attribute in the database according to the metadata information includes: determining whether the logical field corresponding to the physical field in the physical information in the metadata information is consistent with the logical field corresponding to the physical field in the database; if consistent, writing the physical field and attribute value corresponding to the attribute into the database; if inconsistent, reconfiguring the physical field and logical field indicated by the metadata information. This ensures a one-to-one correspondence between physical fields and logical fields in the same physical table of the database, avoiding errors or confusion caused by repeatedly using the same physical field to represent different logical fields in the same physical table, and improving the accuracy of the stored physical fields.

[0070] Step S104: If the attribute information of the newly added object changes, the physical information and attribute values ​​stored in the database are processed based on the logical information.

[0071] It is understandable that, since this embodiment of the invention only stores physical fields and attribute values ​​in the database, and not logical fields, database command statements can be directly written based on logical fields to maintain the attribute information of newly added objects without needing to concern themselves with the meaning of physical fields in the database, thus achieving isolation between data in the physical table and data in the logical table. However, since the database stores physical fields, database command statements written directly based on logical fields cannot be executed directly. Therefore, it is necessary to convert them based on the correspondence between logical fields and physical fields before they can be executed.

[0072] Specifically, the step of processing the physical information and attribute values ​​stored in the database based on the logical information includes: writing one or more first database command statements based on a business scenario, wherein the first database command statements indicate the logical information and attribute values ​​corresponding to the attribute to be processed; converting the first database command statements into second database command statements according to the logical information and physical information corresponding to the attribute to be processed, wherein the second database command statements indicate the physical information and attribute values ​​corresponding to the attribute to be processed; and executing the second database command statements in batches to process the attribute to be processed.

[0073] More specifically, in this embodiment of the invention, the first database command statement and the second database command statement are written using Structured Query Language (SQL).

[0074] In another embodiment of the present invention, based on the processing operation performed by the first database command statement, the first database command statement is modularized to generate one or more functional modules. These functional modules may include: an attribute addition module, an attribute deletion module, an attribute update module, etc.; one or more of these functional modules are selected and combined to process the attribute to be processed based on the combined functional modules. Thus, by modularizing the SQL statement, the repetitive writing of SQL statements with the same function can be avoided, improving the efficiency of subsequent processing and maintenance of newly added objects.

[0075] In another embodiment of the present invention, during the batch execution of the second database command statements, if any second database command statement fails to execute, the successfully executed second database command statements are rolled back to re-execute the second database command statements in batches. This ensures data consistency and reliability of results during the batch execution of the second database commands.

[0076] Based on the above embodiments, by configuring metadata information and directly storing the physical information and attribute values ​​corresponding to attributes in the database, the rapid access of new objects is achieved. This avoids the problem of modifying the database and underlying business code due to different attributes of new objects, improves the versatility and scalability of the new object access method, and at the same time, based on the correspondence between physical information and logical information in the metadata information, it is possible to maintain the attribute information of new objects in the database without having to pay attention to the underlying physical fields, thereby improving operational efficiency and reducing maintenance costs.

[0077] See Figure 2 Based on the above embodiments, this invention provides another information processing method, which specifically includes the following steps:

[0078] Step S201: Obtain the attribute information of the newly added object, wherein the attribute information indicates the attributes of the newly added object and the corresponding attribute values.

[0079] Step S202: Based on the attribute information, add corresponding metadata information to the metadata configuration table. The metadata information indicates the logical and physical information corresponding to the attribute.

[0080] Step S203: Based on the metadata information, store the physical information and attribute value corresponding to the attribute in the database.

[0081] Step S204: Write one or more first database command statements based on the business scenario. The first database command statements indicate the logical information and attribute values ​​corresponding to the attributes to be processed.

[0082] Specifically, taking the metadata information shown in Table 1 as an example, after storing the physical fields and attribute values ​​of the newly added object in the database, the first database command statement can be written based on the business logic "which fields need to be added to the object to be sold (waitsale) and the corresponding values ​​of the fields": insert into waitsale(principal,intst,limitRepayDate)values(100,10,'2022-04-01').

[0083] Based on this, the first database command statement for adding data is modularized, meaning its structure is fixed and its attribute values ​​are retrieved in real time, forming the following add module: `insert into waitsale(principal, intst, limitRepayDate) values(,,),`. Thus, when additional fields for attributes such as principal, interest, and final repayment date need to be added to the waitsale object, the first database command statement to be executed can be retrieved directly by assigning values ​​to the above add module, simplifying the maintenance of information stored in the database.

[0084] Step S205: Based on the logical and physical information corresponding to the attribute to be processed, the first database command statement is converted into a second database command statement, whereby the second database command statement indicates the physical information and attribute value corresponding to the attribute to be processed.

[0085] Since the database stores physical fields rather than logical fields, the first database command statement "insert into waitsale(principal,intst,limitRepayDate)values(100,10,'2022-04-01')" cannot be executed directly. Therefore, it is necessary to convert it into a second database command statement "insert into table1(a,b,c)values(100,10,'2022-04-01')" based on the correspondence between logical fields and physical fields configured in the metadata configuration table.

[0086] Step S206: Execute the second database command statements in batches to process the attributes to be processed.

[0087] During the batch execution of second database command statements, to ensure data consistency, in the event of a second database command statement failure, successfully executed second database command statements are rolled back and re-executed in batches. For example, if the first second database command statement decrements data A by 100 and the second second database command statement adds 100 to data A, and the first second database command statement succeeds while the second fails, the first second database command statement is rolled back to restore data A to its value before the decrement. Then, both second database command statements are re-executed in batches. This prevents data loss due to deletion alone or duplication due to addition alone, thus ensuring the reliability and accuracy of the execution results for data A.

[0088] Based on the above embodiments, by directly writing first database command statements based on logical information, and then converting the first database command statements into second database command statements based on the correspondence between physical and logical information in metadata, it is possible to maintain the attribute information of newly added objects without having to concern themselves with the underlying physical fields, thus improving operational efficiency and reducing maintenance costs. Furthermore, during the batch execution of second database command statements, if the execution of a second database command statement fails, the successfully executed second database command statements can be rolled back and re-executed in batches, ensuring data consistency and the reliability of processing results.

[0089] See Figure 3 Based on the above embodiments, this invention provides an information processing device 300, including: an information acquisition unit 301, an information configuration unit 302, an information storage unit 303, and an information processing unit 304; wherein,

[0090] The information acquisition unit 301 is used to acquire the attribute information of the newly added object, wherein the attribute information indicates the attributes of the newly added object and the corresponding attribute values.

[0091] The information configuration unit 302 is used to add corresponding metadata information to the metadata configuration table according to the attribute information, wherein the metadata information indicates the logical field and physical field corresponding to the attribute;

[0092] The information storage unit 303 is used to store the physical field and attribute value corresponding to the attribute in the database according to the metadata information;

[0093] The information processing unit 304 is used to process the physical fields and attribute values ​​stored in the database based on the logical fields when the attribute information of the newly added object changes.

[0094] In another embodiment of the present invention, adding corresponding metadata information to the metadata configuration table based on the attribute information includes:

[0095] Select one or more attributes from the attribute information;

[0096] The metadata information corresponding to the selected attribute is determined. The metadata information indicates the physical information and logical information corresponding to the selected attribute. The physical information includes: physical fields and the physical table name corresponding to the physical fields. The logical information includes: logical fields, the logical table name corresponding to the logical fields, the meaning of the fields, and the type of the fields.

[0097] The metadata information is stored in the metadata configuration table.

[0098] In another embodiment of the present invention, the processing of the physical information and attribute values ​​stored in the database based on the logical information includes:

[0099] Write one or more first database command statements based on the business scenario. The first database command statements indicate the logical information and attribute values ​​corresponding to the attributes to be processed.

[0100] Based on the logical and physical information corresponding to the attribute to be processed, the first database command statement is converted into a second database command statement, which indicates the physical information and attribute value corresponding to the attribute to be processed.

[0101] The second database command statement is executed in batches to process the attribute to be processed.

[0102] In another embodiment of the present invention, the information processing unit 304 is further configured to modularize the first database command statement to generate one or more functional modules according to the processing operation performed by the first database command statement. The functional modules may include at least one of the following: an attribute addition module, an attribute deletion module, and an attribute update module.

[0103] One or more of the aforementioned functional modules are selected and combined to process the attribute to be processed based on the combined functional modules.

[0104] In another embodiment of the present invention, the information processing unit 304 is further configured to, during the process of batch executing the second database command statements, roll back the second database command statements that have been successfully executed in the event that the second database command statements fail to execute, so as to re-execute the second database command statements in batch.

[0105] In another embodiment of the present invention, storing the physical information and attribute value corresponding to the attribute in the database according to the metadata information includes:

[0106] Determine whether the logical field corresponding to the physical field in the physical information in the metadata information is consistent with the logical field corresponding to the physical field in the database:

[0107] If they match, the physical field and attribute value corresponding to the attribute are written into the database; if they do not match, the physical field and logical field indicated by the metadata information are reconfigured.

[0108] In another embodiment of the present invention, the information processing unit 304 is further configured to use a structured query language to write the first database command statement and the second database command statement.

[0109] Based on the above embodiments, this invention also provides an electronic device for information processing, including: one or more processors; and a storage device for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors implement any of the information processing methods described above.

[0110] Based on the above embodiments, this invention also provides a computer-readable medium having a computer program stored thereon, wherein the program, when executed by a processor, implements any of the information processing methods described above.

[0111] Figure 4 An exemplary system architecture 400 is shown for which the information processing method or information processing apparatus of the present invention can be applied.

[0112] like Figure 4 As shown, system architecture 400 may include terminal devices 401, 402, and 403, a network 404, and a server 405. Network 404 serves as the medium for providing communication links between terminal devices 401, 402, and 403 and server 405. Network 404 may include various connection types, such as wired or wireless communication links, or fiber optic cables, etc.

[0113] Users can use terminal devices 401, 402, and 403 to interact with server 405 via network 404 to receive or send messages, etc. Various communication client applications, such as web browsers and securities investment software, can be installed on terminal devices 401, 402, and 403.

[0114] Terminal devices 401, 402, and 403 can be various electronic devices with displays that support web browsing, including but not limited to smartphones, tablets, laptops, and desktop computers.

[0115] Server 405 can be a server providing various services, such as a back-end management server supporting the asset securitization webpages browsed by users using terminal devices 401, 402, and 403. The back-end management server can analyze and process data such as received product information query requests, and feed back the processing results (such as new asset information, asset sale status, etc.) to the terminal devices.

[0116] It should be noted that the information processing method provided in the embodiments of the present invention is generally executed by server 405, and correspondingly, the information processing device is generally set in server 405.

[0117] It should be understood that Figure 4The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.

[0118] The following is for reference. Figure 5 It shows a schematic diagram of the structure of a computer system 500 suitable for implementing a terminal device of the present invention. Figure 5 The terminal device shown is merely an example and should not impose any limitations on the functionality and scope of use of the embodiments of the present invention.

[0119] like Figure 5 As shown, the computer system 500 includes a central processing unit (CPU) 501, which can perform various appropriate actions and processes based on programs stored in read-only memory (ROM) 502 or programs loaded from storage section 508 into random access memory (RAM) 503. The RAM 503 also stores various programs and data required for the operation of the system 500. The CPU 501, ROM 502, and RAM 503 are interconnected via a bus 504. An input / output (I / O) interface 505 is also connected to the bus 504.

[0120] The following components are connected to I / O interface 505: an input section 506 including a keyboard, mouse, etc.; an output section 507 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and speakers, etc.; a storage section 508 including a hard disk, etc.; and a communication section 509 including a network interface card such as a LAN card, modem, etc. The communication section 509 performs communication processing via a network such as the Internet. A drive 510 is also connected to I / O interface 505 as needed. A removable medium 511, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on drive 510 as needed so that computer programs read from it can be installed into storage section 508 as needed.

[0121] In particular, according to the embodiments disclosed in this invention, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments disclosed in this invention include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication section 509, and / or installed from removable medium 511. When the computer program is executed by central processing unit (CPU) 501, it performs the functions defined above in the system of this invention.

[0122] It should be noted that the computer-readable medium shown in this invention can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In this invention, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media can also be any computer-readable medium other than computer-readable storage media, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.

[0123] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of the present invention. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, may be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0124] The units described in the embodiments of the present invention can be implemented in software or hardware. The described units can also be housed in a processor; for example, a processor can be described as including: an information acquisition unit, an information configuration unit, an information storage unit, and an information processing unit. The names of these units do not necessarily limit the specific unit; for example, an information acquisition unit can also be described as "a unit for acquiring attribute information of a newly added object."

[0125] In another aspect, the present invention also provides a computer-readable medium, which may be included in the device described in the above embodiments; or it may exist independently and not assembled into the device. The computer-readable medium carries one or more programs, which, when executed by the device, cause the device to include: acquiring attribute information of a newly added object, the attribute information indicating the attributes of the newly added object and corresponding attribute values; adding corresponding metadata information to a metadata configuration table based on the attribute information, the metadata information indicating logical and physical information corresponding to the attribute; storing the physical information and attribute values ​​corresponding to the attribute in a database based on the metadata information; and processing the physical information and attribute values ​​stored in the database based on the logical information when the attribute information of the newly added object changes.

[0126] According to the technical solution of the present invention, by configuring metadata information and directly storing the physical information and attribute values ​​corresponding to the attributes in the database, the rapid access of new objects is realized, avoiding the problem of modifying the database and underlying business code due to different attributes of new objects, improving the versatility and scalability of the new object access method; at the same time, based on the correspondence between physical information and logical information in the metadata information, it is possible to maintain the attribute information of new objects in the database without having to pay attention to the underlying physical fields, thereby improving operational efficiency and reducing maintenance costs.

[0127] The specific embodiments described above do not constitute a limitation on the scope of protection of this invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can occur depending on design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this invention.

Claims

1. An information processing method characterized by comprising: The method comprises the following steps: acquiring attribute information of a new object, the attribute information indicating attributes of the new object and corresponding attribute values; adding corresponding metadata information in a metadata configuration table according to the attribute information, the metadata information indicating logical information and physical information corresponding to the attributes; the physical information comprises a physical field and a physical table name corresponding to the physical field; the logical information comprises a logical field, a logical table name corresponding to the logical field, field meaning and field type; storing the physical information and the attribute values corresponding to the attributes in a database according to the metadata information; in the case that the attribute information of the new object changes, one or more first database command statements are written based on a business scenario, the first database command statements indicating logical information and attribute values corresponding to to-be-processed attributes; the first database command statements are converted into second database command statements according to the logical information and the physical information corresponding to the to-be-processed attributes, the second database command statements indicating physical information and attribute values corresponding to the to-be-processed attributes; and the second database command statements are executed in batches to process the to-be-processed attributes.

2. The information processing method according to claim 1, characterized by, The adding of the corresponding metadata information in the metadata configuration table according to the attribute information comprises the following steps: selecting one or more attributes from the attribute information; determining metadata information corresponding to the selected attributes, the metadata information indicating physical information and logical information corresponding to the selected attributes; storing the metadata information into the metadata configuration table.

3. The information processing method of claim 1, wherein: the first database command statements are modularized to generate one or more function modules according to a processing operation performed by the first database command statements, the function modules comprising at least one of an attribute adding module, an attribute deleting module and an attribute updating module; one or more of the function modules are selected and combined to process to-be-processed attributes based on the combined function modules.

4. The information processing method of claim 1, wherein: in the process of executing the second database command statements in batches, if there is a second database command statement execution failure, the second database command statements that have been successfully executed are rolled back to re-execute the second database command statements in batches.

5. The information processing method according to claim 2, characterized by, The storing of the physical information and the attribute values corresponding to the attributes in the database according to the metadata information comprises the following steps: judging whether a physical field in the physical information corresponding to a logical field in the metadata information is consistent with a logical field in the database corresponding to the physical field: if consistent, the physical field and the attribute values corresponding to the attributes are written into the database; if not consistent, the physical field and the logical field indicated by the metadata information are reconfigured.

6. The information processing method of any one of claims 1-5, wherein: the first database command statements and the second database command statements are written by using a structured query language.

7. An information processing apparatus, characterized by comprising: The method comprises the following steps: The information acquisition unit is configured to acquire attribute information of the new object, the attribute information indicating attributes of the new object and corresponding attribute values. The information configuration unit is configured to add corresponding metadata information in a metadata configuration table according to the attribute information, the metadata information indicating logical information and physical information corresponding to the attributes; the physical information includes a physical field and a physical table name corresponding to the physical field; the logical information includes a logical field, a logical table name corresponding to the logical field, a field meaning, and a field type. The information storage unit is configured to store the physical information and the attribute values corresponding to the attributes in a database according to the metadata information. The information processing unit is configured to, in a case where the attribute information of the new object changes, compile one or more first database command statements based on a business scenario, the first database command statements indicating logical information and attribute values corresponding to to-be-processed attributes; convert the first database command statements into second database command statements according to the logical information and the physical information corresponding to the to-be-processed attributes, the second database command statements indicating physical information and attribute values corresponding to the to-be-processed attributes; and batch execute the second database command statements to process the to-be-processed attributes. The one or more processors are configured to implement a method according to any one of claims 1-6.

8. An electronic device for information processing, characterized by comprising: The program is executed by the processor to implement a method according to any one of claims 1-6. The program is executed by the processor to implement a method according to any one of claims 1-6. ​ ​ 9. A computer readable medium having stored thereon a computer program, characterized in that ​

Images