KR20050034237A - Web sheet component for enhancemant of developing performance of business application using by active-x - Google Patents

Abstract

The present invention relates to a web sheet component suitable for developing a business application that has innovatively improved execution performance of application development using Microsoft's Active-X technology. , Dynamic sheet creation function by Visual Basic, Java Script and HTML Script,

The ability to provide methods at the framework level (FrameWork Level) for inquiry, transaction, and data processing;

The ability to process arithmetic operations, numerical calculations, functions, conditional expressions into on-line data,

It is to provide a function that a number of developers can jointly develop and maintain an application.

The present invention provides the functions as described above to increase the processing speed and transaction execution speed when a large amount of data inquiries in developing applications in the web environment, guarantees excellent network performance and system operating performance, work system Providing basic concepts and functions of development standards, techniques, and programs necessary for development to improve development productivity and convenience

Description

Web Sheet Component for enhancemant of developing performance of business application using by Active-X}

        The present invention is a sheet that can innovatively improve execution performance using Microsoft's Active-X technology when developing applications in web and client server environments. It is about a component.

        In particular, data communication by XML can be implemented to cope with dynamic data change, supports dynamic sheet generation method by scripter, and develops business application. Provides various methods needed for.

        In general, a technology related to sheet components is a Java applet that supports sheet operations on the web. Applet method by Java can be executed by Java Virtual Machine (JVM) which helps to execute Java program in Windows environment. Since Java programs are executed on the running Java virtual machine, sheet support by applets is incompatible with various functions such as speed, resource requirements, and event support. It's happening.

        The static object creation method allows any program that supports Microsoft's COM (infrastructure for developing and supporting component objects of a program) to be written in a language, either as a component or as an independent program. It supports Web sheet components in a way by Active-X technology that can be created and reused by many application programs in a computer or distributed network environment.

        However, there are many problems in execution performance because it is a structure that downloads and operates application components created before execution time, both Java-based or Active-X-based, or both. Have

        As described above, a sheet component using a Java-based component and a static object generation method are generally used.

        From the aspect of business development, the above-mentioned general technologies have been the business approach of the exchange of technical information with the introduction of the web system, but as the Internet became popular, it started to meet the demands of the general public rather than the business approach. The approach of parts became mainstream. In other words, existing business applications are gradually being redeveloped as web systems.

This trend is active in human resources / benefit systems, customer service and finance, and is gradually spreading to the telecommunications, manufacturing and public sectors. In particular, the company is building a work system based on web system as the next generation system while promoting the redevelopment of the system. In order to meet the demand of the public, the web system should provide an environment suitable for work system development. However, it is insufficient to meet the demand of the public, and as a solution for this, a component that operates on a plurality of web systems is required. Was done.

Conventional Component does not have the function of Component suitable for on-line harmony and transaction, lacks interface with Windows program, reporting function, graph function, and Online Analytical Processing (OLAP) Application There is a problem that does not support various functions.

When retrieving a large amount of data from HTML sheet, it is cumbersome to rewrite the screen, complicated to write code, and difficult to debug. It has the disadvantage of requiring screen and rewriting screen to inquire data after transaction. In addition, when processing various data, the server must process the data in advance and there is no method that can be implemented in the client. That is, the HTML sheet must produce various programs according to the data coming from the server.

In the above-described conventional technology, applets such as speed and resource requirement events support in terms of systems are incompatible with various functions, and static object generation methods also include a large number of applications. The larger the number, the larger the number and size of application components that must be received from the server system as a client.

SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and its object is to develop a component that is suitably used for the development of a business application, and to provide a function suitable for the task.

As a technical idea for achieving the above-described present invention, an application using Microsoft's Component definition (Active-X) technology using the present technology (Web) and the client server (C) / S: Client Server) has the characteristics that can be operated identically without changing the program. In addition, if the program is developed using this technology in the web environment, the execution speed of the application is improved and the user interface provides the same convenience as that provided in the client server (C / S: Client Server) environment. Web development is possible even in the past, where the web was not used due to speed or interface inconvenience. The present invention uses Active-X technology, so that an application field accessible to the web environment can be easily operated.

Data communication between the present invention and the server is implemented by data communication by XML (XML), by processing the communication data format between the server and the client by XML, it is possible to respond to dynamic data changes. It is possible to operate the program without changing the client program even if the data processing part and the communication part of the server program are changed.

In general, at least one download per screen is generated when one or more Active-X components are generated and executed when using an Active-X component. In the present invention, the screen definition is generated as a script file without generating an Active-X component. In other words, when the program using the present invention is executed, it downloads only once and downloads and executes only a script written for each screen, thereby having excellent communication performance and execution speed of the system.

In addition, general sheet components are specialized for numerical data processing or character data processing methods, and provide only general methods that do not assume server system services such as database operations. However, the present invention not only provides an interface supporting transactions such as data inquiry, data change, deletion, new, etc., but also for query / transaction so that a database operation can be developed in a server. Provides methods and methods that are useful for general numerical data processing and character data processing and output. Suitable for development not only for business applications but also for general data processing applications. It provides a function of.

The configuration for achieving the object of the present invention is as follows. 1 is a block diagram illustrating the functionality of a Web Sheet Component to innovatively improve the execution performance of application development in accordance with the present invention.

The multi-record search 101 is a record-based data inquiry function that enables selection of a record in a desired position with a scroll bar when a large amount of data is inquired and is a convenient programming interface function. In other words, by providing a method function for inquiry, various functions can be implemented, and data processing such as amount, date, time, telephone number, etc. is possible with various types of data formatting functions. In addition to the above-described functions, before and after the retrieval by the scroll bar, the re-inquiry and the re-inquiry screen is not re-created, but before and after the record retrieval function to adjust only the size of the scroll bar and must input must There is a function to express mandatory input condition that can be displayed on the screen for data column, and to set whether to input row or cell that can express a limited type of input condition.

The multi record transaction 102 provides the same interface as the client server (C / S: Client Server) environment and does not require a separate screen, and handles new / change / delete operations in the record inquiry screen. It also has an automatic transaction state management function to reduce coding load by automatically managing the change state of records separately in the. It also provides a transaction method to automatically extract state changed records to provide a method for service invocation to the server, and a debugging / logging method to smoothly handle transaction errors. do.

Generally, when using Active-X Component, one or more Active-X Component is created per screen, and when executed, at least one download per screen occurs. The speed-up run 103 generates screen definitions as script files without generating Active-X components when defining screens, and executes only one download to download scripts written for each screen. It is very easy to receive and execute, so the system's communication performance and execution speed is very good.

The programming method 104 presents programming model techniques of client and server systems, and suggests and uses standard method application programming interfaces (APIs), and presents standard screen design methods, various components, and programming naming rules. The basic concepts and functions of the program for the construction of client and server systems are presented, and the basic concepts and functions of the program are presented. In addition, based on the existing accumulated experience, a method library consisting of various application programming interfaces (APIs) is proposed, and the programming method 104 proposes a standardization method according to system development.

The interface 105 for EUC (End User Computing) and the standard interface providing 106 for interworking support a peripheral program and a standard interface. In other words, it supports Windows program interface such as Excel (uploading and downloading of data) and also supports file creation of data and sheet upload of existing files. These functions are essential elements for EUC (End User Computing) and are essential elements for separate processing or reporting of data.

The event processing 107 supports the event script editor so that the events of the sheet are provided for each purpose, and each event can be scripted with an action. It is generated by the CTI program. It also provides a script viewer for viewing the entire script.

Web & Back-End interface 108 provides a flexible interface of server platform, server service, DB service, and Microsoft's Application interface 109 provides a Windows program interface such as Excel.

The client server level interface 110 provides a function that can be used equally for the web and the client server for one application.

      2 is a flowchart illustrating a service process of a web sheet component according to the present invention.

      The web designer 201 designs the content to be composed in Html, and the web sheet component, javascript and visual on the designed Html screen. It will be developed with development programs such as Visual Basic Script, Java Server Page / Active Server Page, and Enterprise Java Beans / Active Data Objeccts. After deploying the developed web content 204 to the web server 205, the user 206 may process a task in a system developed as a web sheet component. At this time, the web sheet component is executed in the downloaded state only once, and when changed, the web sheet component is downloaded again. Here, Html script is downloaded and executed like a normal web application.

The execution method of the application confirms that the user has the latest version of the web sheet component by checking the version of the web sheet component. In addition, it executes Java Server Page to draw the screen of web application server, refers to various server contents, delivers Html code to user, and inquires to server with query condition to user. When a request comes in to run a service, it executes a servlet for data processing. The servlet now invokes Enterprise Java Beans to execute data operations and then delivers the results to the user's Web Sheet Component. The web sheet component outputs the received data on the screen and when the user executes the transaction on the screen, the web sheet component is transmitted to the servlet along with the transaction data to the server, and the servlet is now available. Calling Enterprise Java Beans will execute the database transaction.

As described above, the present invention uses Microsoft's Active-X technology to innovatively improve the execution performance of application development so that the development standards, techniques, and program skeletons for application development are basic. Concepts and functionality), and multiple developers can work together to develop and maintain applications.

In addition, the present invention improves the processing speed and transaction execution speed when a large amount of data is inquired in developing an application in a web environment, guarantees excellent network performance and system operating performance, and is required for development of a business system. It provides development concepts and functions to improve development productivity and convenience by providing basic concepts, functions, and programs.

       1 is a block diagram illustrating the function of a web sheet component for innovatively improving the execution performance of application development according to the present invention.

       2 is a flowchart illustrating a service process of a web sheet component according to the present invention.

       Explanation of symbols on the main parts of the drawings

       101: Multi Record Retrieval

       102: Multi Record Transaction

       103: Execution Speed Up

       104: programming methods

       105: Provide an interface for EUC (End User Computing)

       106: Provide standard interface for interworking

       107 Event Processing

108: Web & Back-End Interface

       109: Microsoft's application interface

       110: client server level interface

201: Web Designer Group

       202: Web Sheet Component

       203: Development Program

       204: Web content

       205: Web server and web application server

206: user group

Claims (2)

When defining a sheet by Visual Basic, Java Script and Html script, the sheet definition is not created without creating an Active-X component. Means for dynamically creating sheets by generating a dynamic screen, which is generated as a script file;  Means for providing methods at the framework level for inquiry, transaction, and data processing; Means for processing arithmetic operations, numerical calculations, functions, conditional expressions into on-line data, A web sheet component composed of a means by which multiple developers can jointly develop and maintain an application. The method of claim 1, wherein the method of providing a method of a framework level for inquiry, transaction, and data processing is a means of providing a method function suitable for a business application. Web Sheet Component.