Computer program, information processing device, and information processing method

Abstract

To provide a computer program, an information processing apparatus, and an information processing method which can further easily realize software development.SOLUTION: A computer program causes a computer to execute processing of acquiring a code relating to described database processing, accepting designation of any one of a plurality of functions including error check, creating an instruction sentence for use in obtaining a reply relating to the code according to the designated function, transmitting the acquired code and the created instruction sentence to a leaned language model, and, based on a reply from the language model, outputting data corresponding to the designated function.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a computer program, an information processing apparatus, and an information processing method that can facilitate software development. [Background technology]

[0002] Various services have been proposed to support software development related to databases (Patent Document 1, etc.). Software development using SQL (Structured Query Language) for databases requires knowledge of SQL, such as understanding the contents of the database and its definition. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2012-113373 Summary of the Invention [Problem to be solved by the invention]

[0004] Databases are becoming huge and SQL statements are becoming more complex. Software development and database management, including SQL for databases, are essential for many web-based services. There is a demand for an environment that allows development even without extensive knowledge of large and complex databases and SQL.

[0005] The present disclosure aims to provide a computer program, an information processing device, and an information processing method that enable software development to be more easily realized. [Means for solving the problem]

[0006] A computer program according to one embodiment of the present disclosure causes a computer to acquire code relating to database processing that has already been written, accept the specification of one of a number of functions including error checking, create an instruction statement for obtaining an answer relating to the code according to the specified function, send the acquired code and the created instruction statement to a trained language model, and execute a process of outputting data corresponding to the specified function based on the answer from the language model.

[0007] In the computer program of the present disclosure, the "code related to database processing" is, for example, written SQL or a predefined structure when writing SQL. The "code related to database processing" may also be part of a software program related to SQL. [Effects of the Invention]

[0008] According to the present disclosure, database-related software development can be more easily realized. [Brief explanation of the drawings]

[0009] [Figure 1] FIG. 1 is a schematic diagram of an information processing system. [Figure 2] FIG. 1 is a block diagram showing a configuration of an information processing device. [Figure 3] FIG. 2 is a block diagram showing the configuration of a terminal device. [Figure 4] 10 is a flowchart showing an example of a processing procedure in a development process based on a development software program. [Figure 5] 10 is a flowchart showing an example of a processing procedure in a development process based on a development software program. [Figure 6] 10 is a flowchart illustrating an example of a processing procedure in an information processing device. [Figure 7] 10 is a flowchart illustrating an example of an automatic generation process procedure in an information processing device. [Figure 8] 10 is a flowchart illustrating an example of an SQL formatting process procedure in the information processing device. [Figure 9] 10 is a flowchart illustrating an example of an error check processing procedure in the information processing device. [Figure 10] FIG. 10 is an explanatory diagram of the function of processing. [Figure 11] FIG. 10 is an explanatory diagram of the function of processing. [Figure 12] FIG. 10 is an explanatory diagram of the function of processing. [Figure 13] FIG. 10 is an explanatory diagram of the function of processing. [Figure 14] FIG. 10 is an explanatory diagram of the function of automatic generation processing. [Figure 15] FIG. 10 is an explanatory diagram of the function of automatic generation processing. [Figure 16] FIG. 10 is an explanatory diagram of the function of automatic generation processing. [Figure 17] FIG. 10 is an explanatory diagram of the function of SQL formatting processing. [Figure 18] FIG. 10 is an explanatory diagram of the function of SQL formatting processing. [Figure 19] FIG. 10 is an explanatory diagram of the function of error check processing. [Figure 20] FIG. 10 is an explanatory diagram of the function of error check processing. [Figure 21] FIG. 10 is an explanatory diagram of the function of error check processing. DETAILED DESCRIPTION OF THE INVENTION

[0010] The present disclosure will be specifically described with reference to the drawings showing embodiments thereof.

[0011] FIG. 1 is a schematic diagram of an information processing system 100. The information processing system 100 in this embodiment includes an information processing device 1 and a terminal device 2. The information processing device 1 and the terminal device 2 can communicate with each other via a network N. The network N is a wired or wireless network including a public communication network such as the Internet, a carrier network, etc. The information processing device 1 can send and receive data to and from the terminal device 2 by communication via the network N, and can also send and receive data to and from other server devices that provide external services (for example, large-scale language models (LLMs)) via the network N.

[0012] The information processing device 1 is operated by a business that provides support services for software program development. The information processing device 1 provides a software program development support platform related to SQL for databases.

[0013] The terminal device 2 is used by a development engineer developing a database software program. The terminal device 2 can communicate with a database DB that the terminal device 2 has access and read / write rights to, and can provide services using the database DB by using a software program developed on the terminal device 2.

[0014] A development engineer using a terminal device 2 edits, corrects, and tests SQL-related code on a software program development support platform provided by the information processing device 1. The information processing system 100 disclosed herein provides a function for proposing code revisions and a function for automatically creating code on the software program development support platform. The configuration and processing for realizing the function for proposing code revisions and the function for automatically creating code will be described below.

[0015] 2 is a block diagram showing the configuration of information processing device 1. Information processing device 1 is a server computer. In the following explanation, information processing device 1 is described as a single server computer, but it may be configured as multiple computers, with processing operations distributed according to content, function, etc.

[0016] The information processing device 1 includes a processing unit 10, a storage unit 11, and a communication unit 12. The processing unit 10 is a processor using a CPU (Central Processing Unit) and / or a GPU (Graphics Processing Unit). The processing unit 10 controls each component and executes processing using built-in memories such as a ROM (Read Only Memory) and a RAM (Random Access Memory). The processing unit 10 may be configured as a single piece of hardware (SoC: System On a Chip) that integrates a processor, memory, communication devices, etc. Based on an information processing program (program product) P1 stored in the storage unit 11, the processing unit 10 communicates with the terminal device 2 to receive code and outputs suggestions for error checking, processing, creation, and formatting of the code to the terminal device 2.

[0017] The storage unit 11 uses a nonvolatile storage medium such as an SSD (Solid State Drive) or a hard disk, and stores programs and data referenced by the processing unit 10. The storage unit 11 stores an information processing program P1. The information processing program P1 stored in the storage unit 11 may be an information processing program P9 stored in the storage medium 9 that the processing unit 10 reads, copies, and installs. The information processing program P1 may also be an information processing program P1 that the processing unit 10 downloads from a program server (not shown), stores in the storage unit 11, and installs.

[0018] The information processing program P1 stored in the memory unit 11 accepts an HTTPS communication connection or an HTTP communication connection from the terminal device 2, and accepts input of a request and executes processing as described below via a development software program P2 that displays an interface in a web browser launched on the terminal device 2.

[0019] The communication unit 12 is a communication device that realizes communication with the terminal device 2 via the network N. The communication unit 12 uses a network card for wired communication, a wireless communication device for carrier communication, or a wireless LAN device. The processing unit 10 can be connected to the terminal device 2 via the network N for communication via the communication unit 12.

[0020] Based on the information processing program P1, the processing unit 10 accepts requests regarding the development target program on the development software program P2, as described below, and outputs proposed information for the development target program based on the accepted request via the development software program P2.

[0021] 3 is a block diagram showing the configuration of the terminal device 2. The terminal device 2 is a laptop or desktop personal computer used by a software development engineer. The terminal device 2 may also be a smartphone or a tablet terminal.

[0022] The terminal device 2 includes a processing unit 20, a storage unit 21, a communication unit 22, a display unit 23, and an operation unit 24.

[0023] The processing unit 20 is a processor that uses a CPU and / or a GPU. The processing unit 20 controls each component unit and executes processing using built-in memories such as ROM and RAM. The processing unit 20 may be configured as a single piece of hardware (SoC) that integrates a processor, memory, and a communication unit 22 (described later). The processing unit 20 transmits and receives data to and from the information processing device 1 based on a development software program P2 stored in the storage unit 21, and accepts operations from a development engineer. Details will be described later.

[0024] The storage unit 21 uses a non-volatile memory such as a hard disk, flash memory, or SSD. The storage unit 21 stores programs and data referenced by the processing unit 20. The storage unit 21 stores a development software program (program product) P2. The development software program P2 includes a GUI that accepts code creation and editing operations. The development software program P2 can use various functions provided by a software program development support platform provided by the information processing device 1 during code creation or editing operations. The development software program P2 stored in the storage unit 21 may be a development software program P8 stored in the storage medium 8 that the processing unit 20 reads, copies, and installs. The development software program P2 may also be a development software program P8 that the terminal device 2 downloads from a program server (not shown), stores in the storage unit 21, and installs.

[0025] The communication unit 22 is a communication device that realizes communication via the network N. The communication unit 22 is, for example, a network card compatible with the network N. The communication unit 22 may also realize wireless communication. The processing unit 20 can send and receive data between the information processing device 1 and the database DB via the communication unit 22.

[0026] The display unit 23 is a display such as a liquid crystal display or an organic EL (Electro Luminescence) display. The display unit 23 displays a GUI (Graphical User Interface) based on the development software program P2. For information output, an audio output unit including a speaker may be used.

[0027] The operation unit 24 is a user interface such as a keyboard and a mouse that can input and output data to and from the processing unit 20. The operation unit 24 may be a touch panel built into the display unit 23. The operation unit 24 may be a physical button, or the operation unit 24 may be an audio input / output unit including a microphone.

[0028] In the information processing system 100 configured as above, a process of using the functions of the software program development support platform during development of a development target program relating to SQL to the development target database DB using the development software program P2 will be described.

[0029] 4 and 5 are flowcharts showing an example of a processing procedure in a development process based on the development software program P2. When a development engineer starts the development software program P2 and opens an editing screen (page, window) for the program to be developed, the following processing procedure is executed based on the operation received by the terminal device 2.

[0030] The processing unit 20 of the terminal device 2 displays an interface for calling a plurality of functions including error checks on the edit screen for the code relating to the SQL being displayed based on the development software program P2 (step S201).

[0031] The processing unit 20 determines whether or not an interface for any function has been designated from the interfaces for calling the multiple functions displayed in step S201 (step S202).

[0032] If it is determined that the interface of any of the functions is not specified (S202: NO), the processing unit 20 returns the process to step S202 and continues accepting edits of the code.

[0033] If it is determined that an interface of any function has been designated (S202: YES), the processing unit 20 identifies the designated function (step S203).The processing unit 20 transmits the code entered on the editing screen and data indicating the designated function to the information processing device 1 (step S204).

[0034] If the specified function identified in step S203 is automatic generation, the processing unit 20 acquires the definition of the target database (part) set on the editing screen and the purpose of creation in step S204 and transmits them to the information processing device 1.

[0035] The processing unit 10 of the information processing device 1 receives the code being edited and data indicating the designated function inputted at the terminal device 2 (step S101). The processing unit 10 determines whether the designated function is a processing instruction (step S102).

[0036] In step S102, if it is determined that the specified function is a processing instruction (S102: YES), the processing unit 10 executes the processing (step S103), and transmits the processed code to the terminal device 2 (step S104).

[0037] If it is determined that the specified function is not a processing instruction (S102: NO), the processing unit 10 determines whether the specified function is automatic generation (step S105). If it is determined that the specified function is automatic generation (S105: YES), the processing unit 10 executes automatic generation processing (step S106) and transmits the processed code to the terminal device 2 (S104).

[0038] If it is determined that the specified function is not automatically generated (S105: NO), the processing unit 10 determines whether the specified function is SQL formatting (step S107). If it is determined that the specified function is SQL formatting (S107: YES), the processing unit 10 executes SQL formatting processing (step S108) and transmits the processed code to the terminal device 2 (S104).

[0039] If it is determined that the specified function is not SQL formatting (S104: NO), the processing unit 10 executes the error check process (step S109), which is one of the remaining functions, and transmits the processed code to the terminal device 2 (S104).

[0040] The processing unit 20 of the terminal device 2 receives the code transmitted from the information processing device 1 according to the function (step S205), displays the content of the received code on the editing screen (step S206), and ends the process.

[0041] 6 is a flowchart showing an example of a processing procedure in the information processing device 1. The processing procedure shown in FIG. 6 corresponds to details of the processing in step S103 of the processing procedures shown in FIGS.

[0042] The processing unit 10 of the information processing device 1 creates a directive requesting the large-scale language model to propose code to be added (modified) regarding the code acquired (received) in step S101 (step S301).

[0043] In step S301, the processing unit 10 assigns a role to the large-scale language model such as "SQL code development engineer" and creates a prompt that includes the text of the code obtained in step S101, such as "Please output the results of processing this SQL statement to suit the following purpose" or "The purpose is ****."

[0044] The processing unit 10 provides the created directive to a large-scale language model (LLM) provided by an external service or a large-scale language model trained within the information processing device 1 (step S302). The processing unit 10 acquires the text output from the large-scale language model, i.e., the processed code (step S303).

[0045] The processing unit 10 sets the acquired processed code as the processed code (step S304), ends the processing, and returns the process to step S104 in the flowchart of FIG.

[0046] 7 is a flowchart showing an example of an automatic generation processing procedure in the information processing device 1. The processing procedure shown in FIG. 7 corresponds to details of the processing in step S105 of the processing procedures shown in FIGS.

[0047] The processing unit 10 of the information processing device 1 uses the definition of the database acquired (received) in step S101 and the purpose of automatic generation to create a directive requesting the large-scale language model to generate an SQL statement (step S501).

[0048] In step S501, the processing unit 10 assigns a role to the large-scale language model such as "SQL code development engineer," and creates a prompt that includes the definition of the database acquired in step S101 and the purpose of automatic generation, and includes text such as "For this definition, please output an SQL statement (code) that meets the following purpose" and "The purpose is *****."

[0049] The processing unit 10 provides the created instruction sentence to a large-scale language model provided by an external service or a large-scale language model trained within the information processing device 1 (step S502). The processing unit 10 acquires text output from the large-scale language model, i.e., an SQL sentence (step S503).

[0050] The processing unit 10 sets the acquired SQL statement as the processed code (step S504), ends the automatic generation process, and returns the process to step S104 in the flowchart of FIG.

[0051] 8 is a flowchart showing an example of the SQL formatting processing procedure in the information processing device 1. The processing procedure shown in FIG. 8 corresponds to the details of the processing in step S108 of the processing procedures shown in FIGS.

[0052] The processing unit 10 of the information processing device 1 creates a directive for requesting the large-scale language model to format the code acquired (received) in step S101 (step S801).

[0053] In step S801, the processing unit 10 assigns a role to the large-scale language model such as "SQL code development engineer" and creates a prompt including the text of the code obtained in step S101, such as "Please format this SQL statement according to the following rules."

[0054] The processing unit 10 provides the created directive sentence to a large scale language model (LLM) provided by an external service or a large scale language model trained within the information processing device 1 (step S802). The processing unit 10 acquires the text output from the large scale language model, i.e., the formatted SQL sentence (step S803).

[0055] The processing unit 10 sets the acquired formatted SQL statement as the processed code (step S804), ends the SQL formatting process, and returns the process to step S104 in the flowchart of FIG.

[0056] 9 is a flowchart showing an example of an error check processing procedure in the information processing device 1. The processing procedure shown in FIG. 9 corresponds to details of the processing in step S109 of the processing procedures shown in FIGS.

[0057] The processing unit 10 of the information processing device 1 creates a directive requesting the large-scale language model to perform an error check on the code acquired (received) in step S101 (step S901).

[0058] In step S901, the processing unit 10 assigns a role to the large-scale language model such as "SQL code development engineer," and creates a prompt including the text of the code obtained in step S101, such as "Please correct this SQL statement after checking for errors using the following rules."

[0059] The processing unit 10 provides the created directive to a large-scale language model (LLM) provided by an external service or a large-scale language model trained within the information processing device 1 (step S902). The processing unit 10 acquires the text output from the large-scale language model, i.e., the error check result and the proposed correction for the SQL (step S903).

[0060] The processing unit 10 sets the acquired error check result and proposed correction for the SQL as the processed code (step S904), ends the error check process, and returns the process to step S104 in the flowchart of FIG.

[0061] 10 to 13 are explanatory diagrams of the processing functions. FIG. 10 shows an example of an editing screen 230 in the development software program P2. The editing screen 230 includes buttons (interfaces) 231 for selecting various menus (functions). The editing screen 230 includes an editing area 232 for accepting input of SQL code via operation using the keyboard of the operation unit 24. The editing screen 230 of FIG. 10 uses buttons 231 for calling functions to be used during editing in the editing area 232, and allows editing operations such as switching the editing target, copy, paste, UNDO, and REDO. In the editing screen 230 of FIG. 10, a draft of the SQL statement has already been entered in the editing area 232. The button 231 may not be displayed, and may be displayed as a menu by right-clicking the mouse of the operation unit 24 or pressing a specific key on the keyboard during editing in the editing area 232.

[0062] Fig. 11 shows an example of the display when the "Edit" button 231 is selected from among the function buttons 231 on the editing screen 230 shown in Fig. 10. In the editing screen 230 of Fig. 11, when the development engineer selects the "Edit" button 231, an input field 233 in which the purpose of the editing can be entered in natural language, and a button 234 for requesting the editing, are displayed in an area next to the editing area 232. In the example of Fig. 11, the request "to convert reserved words to uppercase and everything else to lowercase" is entered in the input field 233 as the purpose of the editing.

[0063] When the development engineer selects button 234, the terminal device 2 transmits the SQL code displayed in the editing area 232, the purpose of the processing entered in the input field 233, and data indicating the function of "processing" to the information processing device 1 (S204).

[0064] The information processing device 1 assigns the role "SQL code development engineer" to the large-scale language model. Next, based on the SQL code and processing purpose sent from the terminal device 2, the information processing device 1 creates instruction statements such as "Please output the results of processing this SQL statement in a way that suits the following purpose" and "The purpose is to convert reserved words to uppercase and everything else to lowercase," and assigns this to the large-scale language model (S302).

[0065] Fig. 12 shows an example of the display when button 234 for requesting processing is selected on edit screen 230 shown in Fig. 11. Edit screen 230 in Fig. 12 displays processed code that has been applied in accordance with the processing purpose "convert reserved words to upper case, others to lower case" that was entered for the SQL code being edited in edit area 232 in Fig. 11. In the SQL statement shown on edit screen 230 in Fig. 12, the reserved words "SELECT," "CASE," "WHEN," "THEN," "ELSE," "END," "FROM," and "WHERE" are all converted to upper case, and other variables, defined items, etc. are all converted to lower case.

[0066] 12, an interface 235 is displayed next to the editing area 232, which allows the development engineer to choose whether to reflect (save) or cancel the code that has been processed using the large-scale language model. If the development engineer selects the interface 235 to reflect, the processed code in the editing area 232 is saved as the SQL statement being edited.

[0067] The interface 235 for selecting whether to reflect (save) or cancel the code processed using the large-scale language model may be replaced with a confirmation screen 241 that accepts confirmation of whether to reflect or cancel the code. FIG. 13 shows an example of the confirmation screen 241 superimposed on the editing screen 230 shown in FIG. 11. The confirmation screen 241 shown in FIG. 13 is superimposed on the editing screen 230 when the button 234 for requesting processing is selected on the editing screen 230 shown in FIG. 11. The confirmation screen 241 includes a display field 242 for the code processed using the large-scale language model and a button 243 for selecting whether to reflect (save) or cancel the processed code. When the "reflect" button 243 is selected, the terminal device 2 reflects the code processed using the large-scale language model displayed in the display field 242 in the editing area 232. When the "cancel" button 243 is selected, the code is discarded. In this way, displaying the confirmation screen 241 can prevent unintended corrections or processing and also allows the user to compare the SQL statement suggested by the large-scale language model with the SQL statement before processing.

[0068] 12 are not essential, and when button 234 for requesting processing is selected on the editing screen shown in Fig. 11, the processing may be reflected in editing area 232 without confirmation. In this case, it is preferable that the user can restore the original state or re-reflect the processing by performing an editing operation such as UNDO in the editing menu.

[0069] 14 to 16 are explanatory diagrams of the function of the automatic generation process. Like the editing screen 230 shown in Fig. 10, Fig. 14 includes a button 231 and an editing area 232. The editing area 232 of the editing screen 230 in Fig. 14 is blank, but the database (Sales_YYMM) that is the target of the development target program being edited is specified. The button 231 may be displayed as a menu by right-clicking or pressing a specific key.

[0070] Fig. 15 shows an example of a display when the "auto-generation" button 231 is selected from among the buttons 231 for each function on the editing screen 230 shown in Fig. 14. On the editing screen 230 of Fig. 15, when the development engineer selects the "auto-generation" button 231, an input field 236 in which the purpose of auto-generation can be entered in natural language, and a button 237 for requesting auto-generation, are displayed in an area next to the editing area 232. In the example of Fig. 15, the purpose of auto-generation, "I want to know the top 5 sales figures" from the target database, is entered in the input field 236.

[0071] When the development engineer selects button 237, the terminal device 2 transmits the code of the defined table, the purpose of automatic generation entered in input field 236, and data indicating the "automatic generation" function to the information processing device 1 (S204).

[0072] The information processing device 1 assigns the role "SQL code development engineer" to the large-scale language model. Next, based on the table code and the purpose of automatic generation transmitted from the terminal device 2, the information processing device 1 creates instructions such as "Please output an SQL statement (code) that satisfies the following purpose for the following table definition" and "The purpose is to know the top 5 sales," and assigns these to the large-scale language model (S502). The definitions are, for example, a product table "PRODUCT_MST" that includes "product name," "product category," etc., and an order list table "ORDER_TRN" that includes "ORDER NO.", "ORDER DATE," etc.

[0073] Fig. 16 shows an example of the display when button 237 for requesting automatic generation is selected on edit screen 230 shown in Fig. 15. Edit screen 230 in Fig. 16 displays a code output by a large-scale language model in response to the purpose of automatic generation "I want to know the top 5 sales figures" entered in input field 236 in Fig. 15.

[0074] 16, an interface 238 is displayed next to the editing area 232, which allows the developer to choose whether to reflect (save) or cancel (revert) the code that was automatically generated using the large-scale language model. If the development engineer selects the interface 238 to reflect, the processed code in the editing area 232 is saved as the SQL statement being edited.

[0075] 17 and 18 are explanatory diagrams of the SQL formatting processing function. Fig. 17 includes a button 231 and an editing area 232, similar to the editing screen 230 shown in Fig. 10. In the editing screen 230 of Fig. 17, a draft of the SQL statement has already been entered in the editing area 232. The button 231 may be displayed as a menu by right-clicking or by pressing a specific key.

[0076] When the development engineer selects the "format" button 231, the terminal device 2 transmits the SQL code being edited displayed in the editing area 232 and data indicating the "SQL format" function to the information processing device 1 (S204). The terminal device 2 transmits options (indentation setting, line break setting, comma position, uppercase or lowercase conversion of reserved words, uppercase or lowercase conversion of database items, right or left alignment, etc.) that have been set in advance for the "SQL format" function as conditions, together with the data indicating the "SQL format" function.

[0077] The information processing device 1 assigns the role "SQL code development engineer" to the large-scale language model. Next, based on the draft SQL statement and formatting conditions sent from the terminal device 2, the information processing device 1 creates instruction statements such as "I would like to format the SQL statement according to the following rules. The indentation is 4. Please start a new line after each comma. The comma should be at the beginning of the line..." and "Please format the following SQL statement based on the above rules," and assigns this to the large-scale language model (S802).

[0078] Fig. 18 shows an example of the display when the "Format" button 231 is selected from among the function buttons 231 on the edit screen 230 shown in Fig. 17. On the edit screen 230 of Fig. 18, the draft SQL statement that was input in the edit area 232 of Fig. 17 has been formatted by processing with a large-scale language model in accordance with the set options.

[0079] 19 to 21 are explanatory diagrams of the error check processing function. Fig. 19 includes a button 231 and an editing area 232, similar to the editing screen 230 shown in Fig. 10. In the editing screen 230 of Fig. 19, a draft of an SQL statement has already been entered in the editing area. Button 231 may be displayed as a menu by right-clicking or by pressing a specific key.

[0080] When the development engineer selects the "Check" button 231 corresponding to "Error Check," the terminal device 2 transmits the code of the SQL being edited displayed in the editing area 232 and data indicating the "Error Check" function to the information processing device 1 (S204).

[0081] The information processing device 1 assigns the role "SQL code development engineer" to the large-scale language model. Next, based on the SQL code sent from the terminal device 2, the information processing device 1 creates an instruction statement saying, "Are there any errors in the following SQL? If there are any errors, please output 'the erroneous parts' and 'the corrected SQL.' If there are multiple errors, please output the 'erroneous parts' in itemized form. If there are no errors, please output 'There are no errors in this SQL.' (SQL code)," and assigns this instruction to the large-scale language model (S902).

[0082] Fig. 20 shows an example of a display when button 231 for requesting an error check is selected on edit screen 230 shown in Fig. 19. Superimposed on edit screen 230 in Fig. 20 is a confirmation screen 245 that displays the error check results output from the large-scale language model for the SQL code being edited in edit area 232 in Fig. 19. Confirmation screen 245 in Fig. 20 includes a result area 246 that displays the presence or absence of errors as the error check results, and a revision suggestion area 247 that displays a revision suggestion for the SQL.

[0083] In the confirmation screen 245 shown in Fig. 20, the result area 246 lists multiple errors in bullet points. The proposed corrections output from the large-scale language model are displayed in the proposed corrections area 247. The confirmation screen 245 in Fig. 20 includes a button 248 for selecting whether to reflect (save) the processed code or cancel it. When the reflect button 248 is selected, the terminal device 2 reflects the proposed corrections output from the large-scale language model displayed in the proposed corrections area 247 in the edit area 232, and when the cancel button 248 is selected, the proposed corrections are discarded.

[0084] 21 shows the edit screen 230 when the button 248 to reflect the proposed revision is selected on the confirmation screen 245. The SQL statement displayed in the edit area 232 of the edit screen 230 in FIG. 21 has been revised from the SQL statement already entered in the edit area 232 of the edit screen 230 shown in FIG.

[0085] By using the terminal device 2 that uses the development software program P2, development engineers, regardless of their level of expertise, can more easily develop database-related software. The large-scale language model can propose optimal code combinations based on the vast SQL development history. The information processing device 1 of the information processing system 100 can create directives in the back office to ensure appropriate output from the large-scale language model and propose appropriate support.

[0086] The embodiments disclosed above are illustrative in all respects and are not restrictive. The scope of the present invention is defined by the claims, and includes all modifications within the meaning and scope of the claims. [Explanation of symbols]

[0087] 100 Information Processing Systems 1. Information processing equipment 10 Processing section 11 Storage section 12 Communications Department 2. Terminal Device 20 Processing section 21 Memory section P2 Development Software Program 23 Display section 230 Editing screen 241,245 Confirmation screen

Claims

1. On the computer, Get the code for the database processing that you have written, It accepts the specification of one of several functions, including error checking, Create instructions for obtaining answers about the code according to the specified function; The acquired code and the created instructions are sent to the trained language model, Based on the response from the language model, output data corresponding to the specified function. A computer program that executes a process.

2. The function includes a processing instruction for the code, The computer When the processing instruction is accepted, a text requesting a suggestion of SQL code to be added is created as the instruction.

2. The computer program of claim 1.

3. the functionality includes automatic generation of further code based on the code; The computer When the designation of the automatic generation is accepted, a text is generated as the instruction statement, which includes the acquired code, definition, and condition, and requests the generation of further code necessary for database processing.

2. The computer program of claim 1.

4. The functionality includes automatic formatting of the code; The computer When the specification of the automatic formatting is accepted, a text requesting a proposal for formatting the SQL is created as the instruction.

2. The computer program of claim 1.

5. The computer Upon receiving an answer from the language model, comparing the answer with the obtained code and displaying it; outputting a screen for accepting confirmation as to whether or not the correction code or additional code included in the response should be reflected in the acquired code; When it is confirmed that the correction code will be reflected on the screen, the acquired code is rewritten with the correction code, or the additional code is added to the acquired code and output.

2. The computer program of claim 1.

6. Get the code for the database processing that you have written, It accepts the specification of one of several functions, including error checking, Create instructions for obtaining answers about the code according to the specified function; The acquired code and the created instructions are sent to the trained language model, Based on the response from the language model, output data corresponding to the specified function. An information processing device including a processing unit that executes processing.

7. The computer Get the code for the database processing that you have written, It accepts the specification of one of several functions, including error checking, Create instructions for obtaining answers about the code according to the specified function; The acquired code and the created instructions are sent to the trained language model, Based on the answer from the language model, output data corresponding to the specified function. Information processing methods.

Images