Method for enabling rapid modification of a display controlled by a computer program

[0002] The present application is a divisional application of and claims the benefit of U.S. patent application Ser. No. 08/991,570, filed on Dec. 16, 1997 now pending U.S. Pat. No. 6,088,028.

[0003] The present invention relates generally to methods for processing information via graphical user interfaces in a client-server environment, and more particularly to a method for processing information via a graphical user interface in a client-server environment, in which data displayed on the client can be rapidly changed to accommodate changing user requirements.

[0004] Often, programs to control a Graphical User Interface (GUI) are written in a high level programming language, such as Visual Basic, to create a GUI on which a variety of data is displayed. This software can reside either in the server or the client in a client-server environment. In the case where the software resides in the client, the distribution and version of the software is tightly controlled to prevent proliferation of different versions of the software, and hence the inherent problems associated with maintaining multiple versions of software.

[0005] While desirable, the result of this control can lead to significant delays in implementing user requested changes, even if the changes are relatively insignificant. For example, to reorder the appearance of data that is displayed on the user's screen may require several weeks or months, depending upon the available resources and size of the underlying program. Especially in today's environment, programming resources are scarce, and often they are dedicated to bringing new systems online, rather than implementing minor changes to existing systems that are operating satisfactorily. In fact, modifications are not usually made to systems that are operating unless problems are detected, at which time the minor modifications can also be implemented with a new code version. Therefore, users can often be forced to work with a system that operates satisfactorily but is still less than optimum

[0006] The present invention is therefore directed to the problem of developing a method for enabling rapid modification of a graphical user interface in a way that does not require detailed understanding of the underlying program or even technical knowledge so that it can be implemented by a non-software engineer, or a user of the system.

[0007] The present invention solves this problem by providing a layer of abstraction between the presentation layer and the graphical user interface.

[0008] For example, in a program written in Visual Basic, the commands normally used to create various displays would include the precise names and order of the data to be displayed. But, according to the present invention, these values are replaced with calls to a “Meta Data Table,” which includes the values to insert in these commands. As a result, by simply editing the Meta Data Table, it becomes possible to revise the display without chancing the underlying code. Because the Meta Data Table is maintained in a centralized location, it is easy to control the version of this data and it instantly modifies the display for every client that accesses the Meta Data Table.

[0009] FIG. 1 depicts one possible implementation of the present invention in a system for processing credit card applications.

[0010] FIG 2 depicts another implementation of the present invention in an Internet application.

[0011] FIG. 3 depicts an opening screen in the embodiment of FIG. 1, which enables a user to select a particular credit card application to open for processing according to the present invention.

[0012] FIG. 4 depicts a second screen in the embodiment of FIG. 1, after the user selects a particular credit application as in FIG. 3 according to the present invention.

[0013] FIGS. 5A-E depict a tree meta data table for use in determining the tree structure depicted in FIG. 4 according to the present invention.

[0014] FIGS. 6A-F depict a meta data table for use in creating the grid display depicted in FIG. 4 according to the present invention.

[0015] To enable rapid modification of the program that controls a graphical user interface, the present invention uses generic statements in the commands in the underlying computer program that reference a series of tables (termed “Meta Data Tables”), in which are stored the values necessary to effect the desired command. For example, the English equivalent to a variable used in the program is defined in these tables, which then display the English equivalent to the user so that the user never needs to know the cryptic computer coded language. In addition, the translation from the cryptic code to English can be easily changed by editing the Meta Data Table to account for changing user desires. These tables are known as Meta Data Tables because they store Meta Data, which is defined herein as data or information about other data. An example of Meta Data is the number of fields designated for the name in a credit card processing system. Another example could, be the order in which the fields are presented on the display. Even the color in which the data is displayed constitutes Meta Data.

[0016] An even more powerful example of the use of the Meta Data Table is to define the nodes within the tree of screens presented to the user in a Graphical User Interface (GUI). By defining the nodes in the tree in a Meta Data Table, these nodes can be changed easily, but even more significant, the underlying Visual Basic code can be significantly reduced in size. In one example, the Visual Basic program was reduced to about one-third its normal size. Making the code that executes on the client as small as possible obviously speeds up the execution, but also reduces potential errors in the code and reduces the maintenance of the code. As GUIs have become more and more complex, the present invention significantly reduces the complexity of GUIs while simultaneously reducing the design requirements and the time from the requirements phase to the final version.

[0017] FIG. 1 depicts the overall block diagram of one embodiment in which the present invention is applied, which is a credit card application processing system 10. An OLE server 1 is coupled to a client 4, and several other clients (not shown, but which are identical to client 4) via a network 13. The OLE server 1 includes a database 3, which stores credit applications. The database operating system is “ACCESS” by Microsoft, for example, which is managed by a Database Management System, such as Oracle.

[0018] The user accesses system 10 via the client workstation 2. The graphical user interface 7 for the work station 2 includes a series of processors—a queue processor 5a, a query processor 5b, a security processor 5c, a calculated field processor 5d, and a display controller 5e—and two interfaces, an ODBC interface 6aand an OLE interface 6b. In addition, the client includes pre edits 8. The workstation accesses several meta data tables 9—the GUI Tree Meta Data Table 9a, the GUI Meta Data Table 9b, and the GUI Search Meta Data Table 9c. The GUI is controlled by the Visual Basic program (the “presentation layer”) interacting with the Meta Data Tables 9a-9c.

[0019] FIG. 2 depicts the present invention being applied in an Internet or Intranet environment. An OLE server 21 is coupled to a client 24, and several other clients (not shown, but which are identical to client 24) via a standard Internet connection 33. The OLE server 21 includes a database 23, which stores data for the particular application. The database operating system could be “ACCESS” by Microsoft, for example, and the database could be managed by a Database Management System, such as Oracle.

[0020] The user accesses system 20 via the client workstation 22. The graphical user interface 27 for the work station 22 includes a series of processors—a queue processor 25a, a query processor 25b, a security processor 25c, a calculated field processor 25d, and a display controller 25e—and two interfaces, an ODBC interface 26aand an OLE interface 26b. In addition, the client includes pre edits 28 and a context processor 31. The workstation accesses several meta data tables 29—the GUI Tree Meta Data Table 29a, the GUI Meta Data Table 29b, and the GUI Search Meta Data Table 29c. The GUI 27 is controlled by the Visual Basic program (the “presentation layer”) interacting with the Meta Data Tables 29a-29c.

[0021] Turning to FIG. 3, shown therein is a screen 30 that is part of a GUI presented to the user of the system depicted in FIG. 1. This screen 30 is one of the initial screens presented to the user that enables the user to open a particular credit card application. The column 32 labeled AppID includes the Application Identification number that is associated with each credit card application. Other columns include the name of the applicant 33, the type of the application 34 and the response date 35. Moving the cursor 37 and highlights the selected application; by then clicking on the “OK” button 36, the user proceeds to the next screen within the GUI for the selected application.

[0022] The next screen 40 presented to the user is depicted in FIG. 4. This screen 40 shows the selected branch 41 on the tree 42 whose contents is dropped on the grid 43 to the right of the tree 42. At the top of the screen 40 is the particular credit card application 44 selected in FIG. 3. Underneath the title 44 of the screen are three tabs—Decision 45a, Application 45band Credit 45c. In the screen selected by the user, Application 45bhas been selected.

[0023] The area labeled 46 includes the tree structure 42 within the application selection. Both the tree structure 42 and nodes in the tree are determined from a Tree Meta Data Table 50, which is depicted in FIGS. 5A-E. To the right Of the tree 42 is the grid 43 shown the selection underneath “Addresses/Phone #s that has been highlighted by the user. This grid 43 includes two columns—one for the field 46 and another for the value 47 associated with the field.

[0024] The fields 46, 47 are also defined by a Meta Data Table 60, which is depicted in FIGS. 6A-F. The values 47 are read from a database that stores the credit card application data. As shown in FIGS. 6A-F, the column name includes the order in which the data are displayed to the user. In this column, the formal computer codes are used, which link the data to be displayed and the underlying executing program.

[0025] For example, shown in FIG. 5C in the column labeled “ND_DSC” 51 in the third row is the entry Solicited (SSOL) Application 52. Directly below this row are the nodes within the tree for Solicited (SSOL) Application, i.e., Applicant, Co-Applicant, Authorized Users, Addresses/Phone #s, etc. By editing these rows, one can modify the tree structure without requiring changes to the underlying code.

[0026] In FIG. 6D with the label “DSPLY_LBL_NM” 67eare the English names used to label these fields on the screen for the user, i.e., the translation from computer code to English. By editing the column “DSPLY_LBL_NM” 67eone can modify the labels displayed to the user. By editing the column “COLUMN_NAME” 62 one can modify the order and number of fields display ed to the user. For example, by switching the first row 63 with the 13th row labeled “Home Addr Unparsed Line 1” 64 one can present the complete address first rather than the parsed address.

[0027] Turning now to the Meta Tables, FIGS. 5A-E depict the Tree Meta Data Table 50. Each figure in FIGS. 5A-E represent successive columns in a matrix, but have been separated to fit on a page. The first column labeled “APP_TYP_CD” (Application Type Code) 57aindicates the type of application. This is a field specific to the given application, i.e., a solicited application, or a credit application or a blank application for data entry.

[0028] The second column labeled “ND_ID” 57bis the node identification, which is followed by the Frame Identification (“FRM_ID”) 57c. Next, is the Tree Type Code 57d; each tree is assigned a unique code. For example, the third row 72 beginning with SSOL is the SSOL tree. There is also a Credit Person Tree (see row 73) and a Credit Detection Tree (see row 74), and an Application Entry Tree (row 75).

[0029] Next, are five columns 58a-58dthat are navigational aid for the tree. These are shown in FIG. 5B. That is, these columns tell how to navigate within the data model of the current system.

[0030] FIG. 5C includes three columns 59a, 51 and 59b. The first column 59ais the check calculation number (“CHK_CALC_NM”), which controls the icon that appears to the left of the leaf in the node, such as the ✓ or the x. The next column 51 is the node description, which is the English text that appears in the leaf. The last column 59bis the formal description of the node.

[0031] FIG. 5D includes five columns 70a-70e. The first 70aindicates the parent node identification. The second column 70bdetermines whether the node is expandable or not. The third 70cis the count calculation number. The fourth 70dis the display format code, which determines whether the node is displayed as a file or as a paper. The last column 70eis the node type code. The code “X” indicates it is not displayable; “F” is a heading type; “M” is multiple rows; and “C” is a vertical grid.

[0032] FIG. 5E includes three columns 71a-71c. The first column 71aindicates the splitter position number, which determines how to scroll the columns in the grid. For example, a zero indicates that all columns to the left of the zero column scroll. A one indicates that the first column always remains in the first column and the remaining columns scroll. The next column 71bindicates whether the item is draggable. The last column 71cindicate, whether the item is manually selectable or not.

[0033] FIGS. 6A-F depict the GUI Meta Data Table 60. As with FIGS. 5A-E, these FIGs should be placed side by side, as they represent a single matrix, which has been split into different pages to enable it to fit.

[0034] FIG. 6A includes five columns 64a-64e. The first column 64ais the application type code. The second column 64bis the node identification. The third column 64cis the display (merely a number). The fourth column 64dis the parent entity name, and the fifth column 64eis the parent determinant field name. These are navigational aids for navigating through the data model.

[0035] FIG. 6B includes three columns 65a-65c. The first column 65ais the parent condition code. The second column 65bis the parent instance value description. The third column 65cis the entity name.

[0036] FIG. 6C includes four columns 66a-66d. The first column 66ais the column name, i.e., the formal name used within the presentation layer program. Next, is the determinant field name 66d, the condition code 66cand the instance value description 66d, which are aids for navigating through the data model.

[0037] FIG. 6D includes five columns 67a-67e, the first 67aof which is the instance number. The second column 67bindicates whether this item is updatable. The third 67cindicates whether this item is a critical field. If so, then certain steps are required. The fourth column 67dis the display edit code, which determines the format of the data. The last column 67eis the display label name, i.e., the English text displayed on the screen.

[0038] FIG. 6E includes four columns 68a-68d. The first column 68ais the display help text that appears on the bottom scroll bar if the cursor rests on the particular item. This enables easy entry of messages to the users or quick notes to correct common misunderstandings. The next column 68bdetermines the column size. The third column 68cdetermines whether this is an enumerated field, i.e., there are only certain possible states for this field. The last 68dis the security calculation name, which indicates whether this field can be updated by the user, or requires further authorization.

[0039] FIG. 6F includes two columns 69a-69b, the first 69aof which is the display control type code. The second column 69bis the parent instance number.

[0040] The present invention enables rapid changes to the displays in a GUI. Furthermore, the present invention makes it possible to begin coding of the GUI without knowing the exact displays because the Meta Data Table can be modified later. Often, a large software project is delayed due to the delays in determining the user requirements, especially where there are many users. According to the present invention, a prototype can be created and then the software coding can begin. If the prototype requires changes, the Meta Data Table can be modified to account for the required changes.

[0041] Furthermore, the present invention is applicable to Internet applications, in which it is desirable to modify the Web site quickly and without requiring a technician (or engineer).