Script construction method, device and equipment of information system and storage medium

Abstract

The application discloses a script construction method, device and equipment of a database of an information system and a storage medium. The script construction method can include: obtaining a pre-defined extended cache index and a data operation script related to a business operation; determining an insertion content script corresponding to the extended cache index based on a data set corresponding to the business operation; and determining a target index corresponding to the business operation based on the extended cache index, the data operation script and the insertion content script.

Description

Technical Field

[0001] This application relates to the field of data processing, and in particular to a script construction method, apparatus, device and storage medium for an information system. Background Technology

[0002] A key function of information systems is to use databases for data storage and processing. To improve data processing efficiency, clustered indexes and various non-clustered indexes are created for data tables in the database. When writing scripts for querying, modifying, and deleting operations, these indexes are utilized as much as possible to improve the efficiency of database operations.

[0003] Currently, in the design, development, and actual operation of information systems, when some data tables have excessively large amounts of data and require different indexes to support different operations, the indexes often fail to achieve the expected results and instead become a burden on the database. Summary of the Invention

[0004] To address the aforementioned problems, this application discloses a script construction method, device, storage medium, and program product for an information system. The script construction method can significantly reduce the number of indexes created in the database by using extended cache indexes, thereby reducing the difficulty of database maintenance and improving the overall performance of the database.

[0005] This application discloses a script construction method for an information system. The script construction method may include: obtaining a predefined extended cache index and an initial operation script related to a business operation; determining an insertion content script corresponding to the extended cache index based on the dataset corresponding to the business operation; and determining a target operation script corresponding to the business operation based on the extended cache index, the initial operation script, and the insertion content script.

[0006] According to some embodiments of this application, the extended cache index can be constructed based on the data table index columns and the dependency columns of the business operation.

[0007] According to some embodiments of this application, the initial operation script may reference the extended cache index.

[0008] According to some embodiments of this application, determining the target operation script corresponding to the business operation may include: concatenating the extended cache index, the initial operation script, and the inserted content script in a predetermined order to obtain the target operation script.

[0009] According to some embodiments of this application, the predetermined arrangement order includes the extended cache index first, the inserted content script in the middle, and the initial operation script last.

[0010] According to some embodiments of this application, the data access management component embedded in the system framework of the information system can be used to concatenate the extended cache index, the initial operation script, and the inserted content script to obtain the target index.

[0011] According to some embodiments of this application, the extended cache index and the initial operation script can be predefined and stored through the data access management component.

[0012] This application, in another aspect, provides a script construction apparatus for an information system. The index setting system may include: an acquisition module configured to acquire a predefined extended cache index and an initial operation script related to a business operation; a determination module configured to determine an insertion content script corresponding to the extended cache index based on a dataset corresponding to the business operation; and a construction module configured to determine a target operation script corresponding to the business operation based on the extended cache index, the initial operation script, and the insertion content script.

[0013] This application also provides a script building device for an information system. The script building device may include: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program, when executed by the processor, implements the steps of the method described above.

[0014] In another aspect, this application provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the steps of the script construction method for the information system described above.

[0015] In another aspect, this application provides a computer program product comprising a computer program that, when executed by the processor, implements the steps of the script construction method for the information system described above. Attached Figure Description

[0016] This application will be further described by way of exemplary embodiments, which will be described in detail with reference to the accompanying drawings. These embodiments are not limiting; in these embodiments, the same reference numerals denote the same structures, wherein:

[0017] Figure 1 These are exemplary schematic diagrams of an index setting system according to some embodiments of this application;

[0018] Figure 2 These are exemplary schematic diagrams of a processing apparatus according to some embodiments of this application;

[0019] Figure 3This is an exemplary flowchart of a script construction method according to some embodiments of this application;

[0020] Figure 4 This is an exemplary structural diagram of the target operation script shown according to some embodiments of this application;

[0021] Figure 5 These are exemplary block diagrams of a script building apparatus according to some embodiments of this application;

[0022] Figure 6 This is an exemplary structural diagram of an information system according to some embodiments of this application. Detailed Implementation

[0023] To make the above-mentioned objectives, features, and advantages of this application more apparent and understandable, the specific embodiments of this application are described in detail below with reference to the accompanying drawings. Many specific details are set forth in the following description to provide a thorough understanding of this application. However, this application can be implemented in many other ways different from those described herein, and those skilled in the art can make similar modifications without departing from the spirit of this application. Therefore, this application is not limited to the specific embodiments disclosed below.

[0024] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. The terms “and / or” or “and / or” as used herein include any and all combinations of one or more of the associated listed items.

[0025] Currently, creating indexes for data tables in an information system's database can reduce database I / O costs. By creating unique indexes, the uniqueness of each row of data in a database table can be guaranteed, and joins between data tables can be accelerated. At the same time, index creation can significantly reduce the time spent on grouping and sorting in queries, thus reducing computational power consumption.

[0026] However, creating and maintaining indexes is time-consuming, and this time increases with the amount of data. Indexes also require disk space; in addition to the space occupied by the data table, each index occupies a certain amount of physical space stored on disk. With a large number of indexes, the index files may reach their maximum file size faster than the data files. Furthermore, while indexes significantly improve query speed, they simultaneously reduce the speed of table updates. When data in a table is added, deleted, or modified, the indexes also need to be dynamically maintained, thus slowing down data maintenance.

[0027] The script construction method for information systems disclosed in this application, by using target operation scripts built with extended cache indexes, can meet the operational efficiency requirements of the database, reduce the dependence on data table indexes, simplify the index settings of the database, and thus improve the overall performance of the information system and the database.

[0028] The following description, with reference to the accompanying drawings, illustrates some preferred embodiments of the present application. It should be noted that the following description is for illustrative purposes only and is not intended to limit the scope of protection of this application.

[0029] Figure 1 This is an exemplary schematic diagram of an index setting system according to some embodiments of this application. In some embodiments, this is a data access system 100 used for the standardization of data querying and operations on a database of an information system. Figure 1 As shown, the script building system 100 may include a processing device 110, a storage device 120, a terminal 130, and a network 140.

[0030] Processing device 110 can be used to process information and / or data related to script construction to perform one or more functions disclosed in this application. For example, processing device 110 can obtain a predefined extended cache index and an initial operation script related to a business operation. As another example, processing device 110 can determine an insertion content script corresponding to the extended cache index based on the dataset corresponding to the business operation. Yet another example, processing device 110 can determine a target operation script corresponding to the business operation based on the extended cache index, the initial operation script, and the insertion content script. In some embodiments, processing device 110 can also be part of an information system. In some embodiments, processing device 110 can be implemented by a single server or a group of servers. Processing device 110 can be a single server or a group of servers. The server group can be centralized or distributed. In some embodiments, processing device 110 can be local or remote. For example, processing device 110 can access information and / or data stored on storage device 120 via network 140. As another example, processing device 110 can directly connect to storage device 120 to access stored information and / or data. In some embodiments, the processing device 110 may be implemented on a cloud platform. As merely an example, the cloud platform may include a private cloud, public cloud, hybrid cloud, community cloud, distributed cloud, multi-cloud, or any combination thereof. In some embodiments, the processing device 110 may be implemented in conjunction with this application. Figure 2 This is implemented on the computing device shown. For example, the processing device 110 can be implemented on, for example, a computing device such as... Figure 2 Implemented on a computing device 200, as shown, including one or more components in the computing device 200.

[0031] In some embodiments, the processing device 110 may include one or more processing engines (e.g., a single-core processing engine or a multi-core processor). By way of example only, the processing device 110 may include one or more combinations of a central processing unit (CPU), an application-specific integrated circuit (ASIC), a special-purpose instruction set processor (ASIP), a graphics processing unit (GPU), a physical processing unit (PPU), a digital signal processor (DSP), a field-programmable gate array (FPGA), a programmable logic device (PLD), a controller, a microcontroller unit, a reduced instruction set computer (RISC), a microprocessor, etc.

[0032] Storage device 120 can store data and / or instructions. In some embodiments, storage device 120 can store data and / or instructions for execution or use by processing device 110, which can implement the exemplary methods of this application by executing or using the data and / or instructions. In some embodiments, storage device 120 can be part of processing device 110. In some embodiments, storage device 120 can include mass storage, removable storage, volatile read-write storage (RAM), read-only storage (ROM), etc., or any combination thereof. Exemplary mass storage can include disks, optical disks, solid-state drives, etc. Exemplary removable storage can include flash drives, floppy disks, optical disks, memory cards, compact disks, magnetic tapes, etc. Exemplary RAM can include dynamic RAM (DRAM), double-rate synchronous dynamic RAM (DDR SDRAM), static RAM (SRAM), thyristor RAM (T-RAM), and zero-capacitance RAM (Z-RAM), etc. Exemplary ROMs may include mask ROMs (MROMs), programmable ROMs (PROMs), erasable programmable ROMs (PEROMs), electronically erasable programmable ROMs (EEPROMs), optical disc ROMs (CD-ROMs), and digital universal disk ROMs (DVMs). In some embodiments, storage device 120 may be a distributed storage system. In some embodiments, storage device 120 may be implemented on a cloud platform. As an example only, the cloud platform may include private clouds, public clouds, hybrid clouds, community clouds, distributed clouds, internal clouds, multi-layered clouds, etc., or any combination thereof. For example, some algorithms or data in this application may be stored on a cloud platform and updated periodically. Processing device 110 accesses these algorithms or data via a network to achieve the unification and interaction of algorithms or data across the entire platform.

[0033] Terminal 130 can be the operation front end of processing device 110, and can also be referred to as user terminal in this application. It may include, but is not limited to, mobile device 130-1, tablet computer 130-2, laptop computer 130-3, desktop computer 130-4, or any combination thereof. For example, a user or operator can perform corresponding operations on terminal 130, such as data editing or data import / export. In some embodiments, terminal 130 can be integrated with processing device 110. For example, the computing power (e.g., CPU, GPU, etc.) of terminal 130 can be used to implement the functions of processing device 110. The input ports of terminal 130 (e.g., the touch virtual keyboard of mobile device 130-1 and tablet computer 130-2, such as a smartphone, and the mouse and keyboard of laptop computer 130-3 and desktop computer 130-4) can be used for inputting operation commands. In some embodiments, terminal 130 can be part of processing device 110.

[0034] Network 140 can facilitate the exchange of information and / or data. In some embodiments, one or more components of the script building system 100 (e.g., processing device 110, storage device 120, and terminal 130) can transmit information to other components of the script building system 100 via network 140. For example, processing device 110 can obtain operation instructions from terminal 130 via network 140. In some embodiments, network 140 can be any form of wired or wireless network, or any combination thereof. By way of example only, network 140 can be a wired network, fiber optic network, telecom network, intranet, Internet, local area network (LAN), wide area network (WAN), wireless local area network (WLAN), metropolitan area network (MAN), wide area network (WAN), public switched telephone network (PSTN), Bluetooth network, PayPal network, near field communication (NFC) network, Global System for Mobile Communications (GSM) network, code division multiple access (CDMA) network, time division multiple access (TDMA) network, general packet radio service (GPRS) network, etc. The network 140 may include one or more combinations of the following: GPRS network, Enhanced Data Rate GSM Evolution (EDGE) network, Wideband Code Division Multiple Access (WCDMA) network, High-Speed ​​Downlink Packet Access (HSDPA) network, Long Term Evolution (LTE) network, User Datagram Protocol (UDP) network, Transmission Control Protocol / Internet Protocol (TCP / IP) network, Short Message Service (SMS) network, Wireless Application Protocol (WAP) network, Ultra Wideband (UWB) network, mobile communication (1G, 2G, 3G, 4G, 5G) network, Wi-Fi, Li-Fi, Narrowband Internet of Things (NB-IoT), and infrared communication. In some embodiments, network 140 may include one or more network access points. For example, network 140 may include wired or wireless network access points such as base stations and / or internet switching points. Through these network access points, one or more components of the script building system 100 may connect to network 140 to exchange information and / or data.

[0035] Figure 2 This is a block diagram illustrating an exemplary processing device according to some embodiments of this application. The processing device 200 may include any components used to implement the system described in the embodiments of this application. For example, the processing device 200 may be implemented using hardware, software programs, firmware, or a combination thereof. For convenience, only one processing device is shown in the figure; however, the computational functions related to the script building apparatus 100 described in the embodiments of this application may be implemented in a distributed manner by a set of similar platforms to distribute the system's processing load.

[0036] In some embodiments, the processing device 200 may include a processor 210, a memory 220, an input / output component 230, and a communication port 240. In some embodiments, the processor (e.g., CPU) 210 may execute program instructions as one or more processors. In some embodiments, the memory 220 may include different forms of program memory and data memory, such as a hard disk, read-only memory (ROM), random access memory (RAM), etc., for storing various data files processed and / or transmitted by a computer. In some embodiments, the input / output component 230 may be used to support input / output between the processing device 110 and other components. In some embodiments, the communication port 240 may be connected to a network for data communication. Exemplary processing devices may include program instructions executed by the processor 210 stored in read-only memory (ROM), random access memory (RAM), and / or other types of non-transitory storage media. The methods and / or processes of the embodiments of this application may be implemented as program instructions. The processing device 110 may also receive programs and data disclosed in this application via network communication.

[0037] For ease of understanding, Figure 2 Only one processor is illustrated in the illustration. However, it should be noted that the processing device 200 in this embodiment may include multiple processors, and therefore the operations and / or methods implemented by one processor as described in this embodiment may also be implemented jointly or independently by multiple processors. For example, if, in this application, the processor of processing device 200 executes operations A and B, it should be understood that operations A and B may also be executed jointly or independently by two different processors of processing device 110 (e.g., the first processor executes operation A, the second processor executes operation B, or the first and second processors jointly execute operations A and B).

[0038] This application discloses a script construction method for an information system. (Reference) Figure 3 , Figure 3 This is an exemplary flowchart illustrating a script construction method according to some embodiments of this application. Figure 3 As shown, script construction method 300 may include the following operations.

[0039] Step 310: Obtain the predefined extended cache index and the initial operation script related to the business operation.

[0040] In some embodiments, the extended cache index can be composed of data table index columns of the information system's database and the dependent columns of the business operations. The data table index can be a primary index already established in the database. For example, for a relational database, this index can be a clustered index. The business operations can be operations corresponding to various business services provided by the information system. For example, assuming the information system can be used for attendance management, the business operations can include various operations related to employee attendance data, such as viewing, adding, modifying, and deleting attendance records. For each business operation, there can be a corresponding table in the database (e.g., as the operation object). The columns in the table can be considered as the dependent columns of the business operation.

[0041] In some embodiments, the extended cache index may be a temporary table, a table variable, or a memory-optimized temporary table or table variable. As an example, assuming the database stores an employee attendance table, an exemplary structure of this table could be as follows:

[0042] Create Table Emp_CheckTime(

[0043] CheckID VarChar(50) not null,

[0044] EmployeeID VarChar(50)not null,

[0045] CheckTime DateTime not null,

[0046] …other columns…)

[0047] CheckTime and EmployeeID are the main indexes (e.g., composite clustered indexes) already established in the database table, but these indexes are not unique (e.g., due to duplicate employee clock-in records). CheckID is unique, but the table contains a huge amount of data, and CheckID is a GUID primary key. If an index is created for CheckID, it will have to bear all the disadvantages of indexes.

[0048] Therefore, the extended cache index is created based on the data table content as follows (example is a table variable type): Declare@ExCheckTimeIndex Table(

[0049] CheckID VarChar(50),

[0050] EmployeeID VarChar(50),

[0051] CheckTime DateTime)

[0052] In some embodiments, the initial operation script for the business operation may be used to perform the corresponding operation in the database. For example, data update, data query, data deletion, etc. In some embodiments, the initial operation script may be a reference to the extended cache script. For example, the SQL scripts for various business operations directly reference the extended cache index as a table. For example, the structure of the update script corresponding to the initial update operation may be as follows:

[0053] Update T_1Set

[0054] [Column1] = @Value1, --Example column

[0055] [Column2] = @Value2 - Example Column

[0056] From Emp_CheckTime T_1,@ExCheckTimeIndex T_2

[0057] Where T_1.CheckID=T_2.CheckID

[0058] And T_1.EmployeeID=T_2.EmployeeID

[0059] And T_1.CheckTime=T_2.CheckTime

[0060] For example, the structure of a query script corresponding to a data query operation can be as follows:

[0061] Select T_1.CheckID,T_1.EmployeeID,T_1.CheckTime,T_1.Column1,T_1.Column2

[0062] From Emp_CheckTime T_1,@ExCheckTimeIndex T_2

[0063] Where T_1.CheckID=T_2.CheckID

[0064] And T_1.EmployeeID=T_2.EmployeeID

[0065] And T_1.CheckTime=T_2.CheckTime

[0066] For example, the structure of a deletion script corresponding to a data deletion operation can be as follows:

[0067] Delete T_1

[0068] From Emp_CheckTime T_1,@ExCheckTimeIndex T_2

[0069] Where T_1.CheckID=T_2.CheckID

[0070] And T_1.EmployeeID=T_2.EmployeeID

[0071] And T_1.CheckTime=T_2.CheckTime

[0072] In some embodiments, the predefined extended cache index and the initial operation script can be implemented through a data access management component embedded within the system framework of the information system, and stored in the data access management component. The data access management component can be embedded within the system framework of the information system during its development. The data access management component can store a uniformly designed dataset structure, scripts for data access, and script parameters related to the scripts. Data access can include the aforementioned various data operations, such as data query, data update, data modification, and data deletion. The dataset structure can include tables and columns defined for the business operations of the information system. The scripts (including the aforementioned data operation scripts) can be determined based on the defined format of the dataset structure and are used to implement various operations on data in the database. For example, the aforementioned data query, data update, and data deletion. Using the data access management component to predefine the extended cache index and data operation scripts enables more professional and focused development / design of the information system, making data access standardized, manageable, and iterative, thereby reducing the impact of changes in requirements and personnel, and ultimately reducing costs.

[0073] Step 320: Based on the dataset corresponding to the business operation, determine the insertion content script corresponding to the extended cache index.

[0074] It is understood that the business operations will generate data sets during execution. For example, the execution of a data query operation will produce corresponding tables and columns. These data sets will constitute the dataset. Other business operations, such as adding, modifying, and deleting data, will generate rows in the dataset with the status of being added, modified, or deleted. This can be used to write back to the database to implement the corresponding data processing in the database.

[0075] As an example, assuming the dataset corresponding to the business operation has three records, the insertion script determined by the determining module 520 based on the extended cache index can be as follows:

[0076] Insert into@ExCheckTimeIndex(CheckID,EmployeeID,CheckTime)

[0077] Values('CheckID1','EmployeeID1','CheckTime1')

[0078] Insert into@ExCheckTimeIndex(CheckID,EmployeeID,CheckTime)

[0079] Values('CheckID2','EmployeeID2','CheckTime2')

[0080] Insert into@ExCheckTimeIndex(CheckID,EmployeeID,CheckTime)

[0081] Values('CheckID2','EmployeeID2','CheckTime2')

[0082] Since the insertion script is generated based on the dataset, even if the dataset changes (e.g., the table changes) and the established indexes (e.g., clustered indexes) are modified, it will not cause any problems, such as rendering the insertion script generated based on the extended cache index unusable (because the extended cache index depends on the data table indexes already established in the database).

[0083] Step 330: Based on the extended cache index, the initial operation script, and the inserted content script, determine the target operation script corresponding to the business operation.

[0084] In some embodiments, the extended cache index, the initial operation script, and the inserted content script can be concatenated in a predetermined order to obtain the target operation script. The predetermined order includes the extended cache index first, the inserted content script in the middle, and the initial operation script last. For example, taking a data update script as the target operation script for the business operation, its structure can be as follows:

[0085]

[0086]

[0087] In the example above, the target operation script only uses the clustered index of the Emp_CheckTime table and takes advantage of the uniqueness of the CheckID column, but does not need to create an index for CheckID in the data table, thus avoiding the disadvantage of too many indexes for large data tables.

[0088] refer to Figure 4 , Figure 4 This is an exemplary structural diagram of the target operation script shown in some embodiments of this application, which more clearly illustrates the structure and generation of the target operation script. For example... Figure 4 As shown, the dataset of business operations in the information system will be used to generate the insertion content script. Subsequently, the extended cache index, the insertion content script, and the data operation script (i.e., the initial operation script) are concatenated according to their order to obtain the final target operation script, which applies the extended cache index. This target operation script will be executed by the database to perform the corresponding business operation.

[0089] In some embodiments, the generation of the inserted content script and the construction of the target operation script can also be performed within the data access management component. The data access management component enables unified design and management of various scripts, improving the standardization of information system design and development.

[0090] It should be noted that the above-mentioned Figure 3 The descriptions of the various steps in this specification are for illustrative purposes only and do not limit the scope of this specification. Those skilled in the art can, under the guidance of this specification, [perform certain tasks / activities]. Figure 3 Various modifications and changes have been made to the steps described herein. However, these modifications and changes remain within the scope of this specification.

[0091] The script construction method disclosed in this application significantly reduces the number of indexes created in the database by using extended cached indexes. Only clustered indexes need to be created based on the characteristics of the data tables, along with some necessary non-clustered indexes. This reduces the difficulty of database maintenance and improves overall database performance. Furthermore, with concise indexes, the maintenance time for the database is greatly reduced, while also improving data processing efficiency.

[0092] This application also discloses a script building apparatus for an information system. (Reference) Figure 5 , Figure 5 This is an exemplary block diagram of a script building apparatus according to some embodiments of this application. The aforementioned script building method 300 can be provided by... Figure 5The script construction device 500 executes the script. For example, the script construction method 300 can be stored in a storage device (such as the built-in storage unit of the script construction device 500 or an external storage device) in the form of a program or instructions, which, when executed, can implement the script construction method 300. Figure 5 As shown, the script construction device 500 may include an acquisition module 510, a determination module 520, and a construction module 530.

[0093] The acquisition module 510 can be configured to acquire a predefined extended cache index and an initial operation script related to the business operation. The extended cache index can be composed of data table index columns from the information system's database and the dependent columns of the business operation. The data table index can be a primary index already established in the database. The extended cache index can be a temporary table, a table variable, or a memory-optimized temporary table or table variable, etc. The initial operation script for the business operation can be used to implement the corresponding operation in the database. The initial operation script can reference the extended cache script.

[0094] The determination module 520 can be configured to determine the insertion content script corresponding to the extended cache index based on the dataset corresponding to the business operation.

[0095] The construction module 530 can be configured to determine a target operation script corresponding to the business operation based on the extended cache index, the initial operation script, and the inserted content script. The construction module 530 can concatenate the extended cache index, the initial operation script, and the inserted content script in a predetermined order to obtain the target operation script. The predetermined order includes the extended cache index first, the inserted content script in the middle, and the initial operation script last.

[0096] In some embodiments, the script building apparatus 500 may be part of a data access management component embedded within the system framework of the information system. The predefined extended cache index and the initial operation script may be implemented and stored through the data access management component. The generation of the inserted content script and the concatenation of the target operation script may also be performed within the data access management component.

[0097] refer to Figure 6 A brief description of the data access management component is provided below. Figure 6 These are exemplary structural diagrams of an information system according to some embodiments of this application. Figure 6As shown, the information system 600 may include a data processing program 610, a data access execution module 620, a database 630, and a data access management component 640 embedded in the system framework of the information system 600.

[0098] The data processing program 610 can be a module in the information system 600 used to perform various business operations. In this application, it can also be referred to as a functional module. For example, assuming the information system 600 is used for contract management, attendance management, payroll management, etc., then the data processing program 610 (or functional module) is used to implement the corresponding functions, including the processing of company contracts, employee attendance, and payroll-related data.

[0099] The data access execution module 620 can be a component used to implement data reading and writing in the data processing program 610. In this application, the data access execution module 620 can perform logical processing on the relevant business of the information system 600. Specifically, the data access execution module 620 can obtain the execution script corresponding to the business operation (i.e., the aforementioned target operation script) from the data access management component 640 to implement the corresponding data processing operation.

[0100] The data access management component 640 can store at least the operation scripts for various business operations and the script parameters associated with these scripts. For example, the aforementioned extended cache index and initial operation script. Furthermore, the data access management component 640 can also generate the insertion content script and, based on the generated insertion content script and the pre-stored extended cache index and initial operation script, concatenate them to obtain the target operation script. This target operation script can be called by the data access execution module 620 to perform the corresponding business operation.

[0101] The data access management component 640 can serve as the operating terminal (or user terminal) of the information system 600. By uniformly defining and / or designing scripts for the information system 600 on the operating terminal, the development specifications and unified management of the information system 600 can be achieved. Database read / write performance optimization can also be achieved through the operating terminal of the information system 600.

[0102] Further description of the script construction device 500 can be found in the flowchart section of this application, for example... Figure 3 This will not be elaborated upon here.

[0103] It should be understood that Figures 5-6The script building apparatus 500 and information system 600 shown can be implemented in various ways. For example, in some embodiments, the script building apparatus 500 and information system 600 can be implemented in hardware, software, or a combination of both. The hardware portion can be implemented using dedicated logic; the software portion can be stored in memory and executed by an appropriate instruction execution system, such as a microprocessor or dedicated-design hardware. Those skilled in the art will understand that the methods and systems described above can be implemented using computer-executable instructions and / or included in processor control code, for example, such code provided on a carrier medium such as a disk, CD, or DVD-ROM, a programmable memory such as read-only memory (firmware), or a data carrier such as an optical or electronic signal carrier. The systems and modules of this application can be implemented not only with hardware circuits such as very large-scale integrated circuits or gate arrays, semiconductors such as logic chips and transistors, or programmable hardware devices such as field-programmable gate arrays and programmable logic devices, but also with software executed by various types of processors, or with a combination of the aforementioned hardware circuits and software (e.g., firmware).

[0104] It should be noted that the above description of the script building device 500 and the information system 600 is for ease of description only and should not be construed as limiting this application to the scope of the embodiments described. It is understood that those skilled in the art, after understanding the principle of the system, may arbitrarily combine the sub-components and units in the script building device 500 and the information system 600, or construct subsystems connected to other modules, without departing from this principle. Such modifications are all within the protection scope of this application.

[0105] The basic concepts have been described herein. It is obvious that the detailed disclosure above is merely illustrative and does not constitute a limitation of this application. Although not explicitly stated herein, various modifications, improvements, and corrections may be made to this application by those skilled in the art. Such modifications, improvements, and corrections are suggested in this application and therefore remain within the spirit and scope of the exemplary embodiments of this application.

[0106] Furthermore, this application uses specific terms to describe its embodiments. For example, "an embodiment," "one embodiment," and / or "some embodiments" refer to a particular feature, structure, or characteristic related to at least one embodiment of this application. Therefore, it should be emphasized and noted that "an embodiment," "one embodiment," or "an alternative embodiment" mentioned twice or more in different locations in this application do not necessarily refer to the same embodiment. In addition, certain features, structures, or characteristics in one or more embodiments of this application can be appropriately combined.

[0107] Furthermore, those skilled in the art will understand that aspects of this application can be described and illustrated through several patentable types or situations, including any new and useful combination of processes, machines, products, or substances, or any new and useful improvements thereof. Accordingly, aspects of this application can be implemented entirely by hardware, entirely by software (including firmware, resident software, microcode, etc.), or by a combination of hardware and software. All of the above hardware or software may be referred to as a “data block,” “module,” “engine,” “unit,” “component,” or “system.” Furthermore, aspects of this application may manifest as a computer product located on one or more computer-readable media, the product including computer-readable program code.

[0108] Computer storage media may contain a propagated data signal containing computer program code, for example, on baseband or as part of a carrier wave. This propagated signal may take various forms, including electromagnetic, optical, and suitable combinations thereof. Computer storage media can be any computer-readable medium other than a computer-readable storage medium, which can be connected to an instruction execution system, apparatus, or device to enable communication, propagation, or transmission of a program for use. The program code located on the computer storage medium can be propagated through any suitable medium, including radio, cable, fiber optic cable, RF, or similar media, or any combination of the above media.

[0109] The computer program code required for the operation of each part of this application can be written in any one or more programming languages, including object-oriented programming languages ​​such as Java, Scala, Smalltalk, Eiffel, JADE, Emerald, C++, C#, VB.NET, Python, etc., conventional procedural programming languages ​​such as C, Visual Basic, Fortran 3003, Perl, COBOL 3002, PHP, ABAP, dynamic programming languages ​​such as Python, Ruby, and Groovy, or other programming languages. This program code can run entirely on the user's computer, or as a standalone software package on the user's computer, or partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the latter case, the remote computer can be connected to the user's computer through any network, such as a local area network (LAN) or wide area network (WAN), or connected to an external computer (e.g., via the Internet), or in a cloud computing environment, or used as a service such as Software as a Service (SaaS).

[0110] Furthermore, unless expressly stated in the claims, the order of processing elements and sequences, the use of numbers and letters, or other names described in this application are not intended to limit the order of the processes and methods of this application. Although the foregoing disclosure has discussed some currently considered useful embodiments of the invention through various examples, it should be understood that such details are for illustrative purposes only, and the appended claims are not limited to the disclosed embodiments; rather, the claims are intended to cover all modifications and equivalent combinations that conform to the substance and scope of the embodiments of this application. For example, while the system components described above can be implemented using hardware devices, they can also be implemented solely through software solutions, such as installing the described system on existing servers or mobile devices.

[0111] Similarly, it should be noted that, in order to simplify the description of the present application and thus aid in the understanding of one or more embodiments of the invention, the foregoing description of the embodiments of the present application sometimes combines multiple features into a single embodiment, drawing, or description thereof. However, this disclosure method does not imply that the subject matter of the application requires more features than those mentioned in the claims. In fact, the embodiments contain fewer features than all the features of the single embodiments disclosed above.

[0112] In some embodiments, numbers describing the quantity of components and attributes are used. It should be understood that such numbers used in the description of embodiments are modified in some examples with the terms "approximately," "approximately," or "generally." Unless otherwise stated, "approximately," "approximately," or "generally" indicates that the numbers are allowed to vary by ±20%. Accordingly, in some embodiments, the numerical parameters used in the specification and claims are approximate values, which may be changed depending on the characteristics required by individual embodiments. In some embodiments, numerical parameters should take into account specified significant digits and employ a general method of digit reservation. Although the numerical ranges and parameters used to confirm their breadth of scope in some embodiments of this application are approximate values, in specific embodiments, such values ​​are set as precisely as feasible.

[0113] For each patent, patent application, patent application publication, and other material such as articles, books, specifications, publications, and documents referenced in this application, the entire contents of that patent are incorporated herein by reference. This excludes historical application documents that are inconsistent with or conflict with the content of this application, as well as documents that limit the broadest scope of the claims in this application (currently or subsequently appended to this application). It should be noted that if there are any inconsistencies or conflicts between the descriptions, definitions, and / or terminology used in the supplementary materials of this application and the content of this application, the descriptions, definitions, and / or terminology used in this application shall prevail.

[0114] Finally, it should be understood that the embodiments described in this application are merely illustrative of the principles of the embodiments of this application. Other modifications may also fall within the scope of this application. Therefore, alternative configurations of the embodiments of this application are considered as examples and not limitations, and are regarded as consistent with the teachings of this application. Accordingly, the embodiments of this application are not limited to the embodiments explicitly described and illustrated in this application.

Claims

1. A script construction method for an information system, characterized in that, The script construction method includes: S1, obtain the predefined extended cache index and the initial operation script related to the business operation; The extended cache index is composed of the data table index columns of the information system's database and the dependency columns of the business operations; the data table index is the main index already established in the database; the business operations are the operations corresponding to the various services that the information system can provide. For a given business operation, there is a corresponding table in the database; the columns in the table are considered to be the dependent columns of the business operation; the initial operation script of the business operation is used to implement the corresponding operation in the database. The predefined extended cache index and the initial operation script are implemented and stored in a data access management component embedded within the system framework of the information system. The data access management component is embedded within the system framework of the information system during its development. It stores a uniformly designed dataset structure, scripts for data access, and script parameters related to these scripts. Data access includes various data operations, including but not limited to data querying, updating, modifying, and deleting. The dataset structure defines the tables and columns required for the business operations of the information system. The scripts are determined based on the defined format of the dataset structure and are used to implement various operations on data in the database. S2, based on the dataset corresponding to the business operation, determine the insertion content script corresponding to the extended cache index; The business operations will generate data sets during execution; these data sets will constitute the dataset; other business operations will generate rows for adding status, modifying status, and deleting status in the dataset; this can be used to write back to the database to implement the corresponding data processing in the database; the script for inserting content is generated based on the dataset; S3, based on the extended cache index, the initial operation script, and the inserted content script, determine the target operation script corresponding to the business operation; The extended cache index, the initial operation script, and the inserted content script are concatenated in a predetermined order to obtain the target operation script; the predetermined order includes the extended cache index first, the inserted content script in the middle, and the initial operation script last. The target operation script will be executed by the database to perform the corresponding business operation; The generation of the inserted content script and the construction of the target operation script are also carried out in the data access management component; the data access management component realizes the unified design and management of various scripts, and improves the standardization of information system design and development.

2. A script building apparatus for an information system, based on the script building method of claim 1, characterized in that, include: The acquisition module is configured to acquire a predefined extended cache index and initial operation scripts related to business operations; The determination module is configured to determine the insertion content script corresponding to the extended cache index based on the dataset corresponding to the business operation; The building module is configured to determine the target operation script corresponding to the business operation based on the extended cache index, the initial operation script, and the inserted content script.

3. A script building device for an information system, characterized in that, include: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program, when executed by the processor, implements the steps of the method as described in claim 1.

4. A computer-readable storage medium, characterized in that, The storage medium stores a computer program, which, when executed by a processor, implements the steps of the method as described in claim 1.

Images