KR20020004924A - An Exchange Method Of ActiveX Documnets View For Remote Database Service and Windows Documents View - Google Patents

Abstract

PURPOSE: A method for converting a remote database service and a window document view into an Active X document view is provided to easily make up a web application program by converting a document view of a client/server program using a remote database service technology. CONSTITUTION: An automation technology is applied using an automation controller in order to convert an application program to be converted into an Active X document(S100). The automation controller converts the application program using a Tegoweb express(S200). The application program converted is displayed to an Internet explorer(S300). The application program converted is activated in the Internet explorer(S400). Therefore, a remote database service and a window document view are converted into the Active X document.

Description

An Exchange Method Of ActiveX Documnets View For Remote Database Service and Windows Documents View} How to Convert a Remote Data Service and a Window Document View to an ActiveX Document View

The present invention is based on a distributed application having a three-tiered method to which a remote database service is applied to create an ActiveX component using an Automation Controller program, thereby enabling remote data service and window document view. On how to switch to an ActiveX document view.

In general, conventional programmers have created web applications using many development tools and languages such as ASP, JSP, PEAL, and PHP. Existing programmers have been burdened with the need to learn and apply completely new development languages and tools. This is a limited problem because the functions are web browser based.

Accordingly, the present invention has been made in view of the above-described conventional problems, and the first object of the present invention is to make an ActiveX component using the Automation Controller program, thereby enabling a remote data service and a window. It provides a way to convert a document view into an ActiveX document view.

In addition, the second object of the present invention is ActiveX using an Automation Controller program based on a distributed application having a three-tiered method in which a remote database service is applied in the database access. It's a component that provides a way to convert remote data service and window document views into ActiveX document views.

The object of the present invention is to apply an automation technique using an Automation Controller to convert an application to be converted into an ActiveX document;

The Automation Controller may include converting an application program using TegoWeb Express;

Displaying the converted application program in Internet Explorer using the TegoWeb Express; And

It is achieved by a method of converting a remote data service and a window document view into an ActiveX document view, comprising the step of activating the converted application in Internet Explorer.

The TegoWeb Express includes ActiveX document migration for almost all kinds of applications having a user interface in Windows regardless of a development language.

In addition, the application is characterized in that the database access method having a three-layer method applying a remote database (Remote Database Service).

Other objects, specific advantages and novel features of the present invention will become more apparent from the following detailed description and the preferred embodiments associated with the accompanying drawings.

1 is a flowchart illustrating a technique for converting a window form into a web form according to the present invention;

2A is an exemplary view of a Word document window according to the present invention;

Figure 2b is an illustration of an ActiveX document window according to the present invention,

3 is an overall system diagram of traditional client and server programming in accordance with the present invention;

4 is a schematic diagram of a web application development method according to the present invention.

<Description of the code according to the main part of the drawing>

100: Active X document 110: Word document

200: web server 205: OLE DB

210: web application development tool 220: traditional client / server

230: remote data service 240: database

250: Independent program 260: Switch document view

270: HTTP protocol 280: web browser

Hereinafter, the present invention will be described in more detail with reference to the accompanying drawings.

1 is a flowchart of a method of converting a remote data service and a window document view into an ActiveX document view according to the present invention.

As shown in FIG. 1, the database access is based on a distributed application having a three-tiered method in which a remote database service is applied, and an activex using the Automation Controller program is used. Component to convert remote data service and window document views into ActiveX document views.

The following describes how to convert an application implemented in such a window form from a remote data service and a window document view to an ActiveX document view.

First, in order to convert an application program to be converted into an ActiveX document 110, an Automation technology is applied using an Automation Controller (S100), and the Automation Controller Converts the application using TegoWeb Express (S200). In addition, the application converted using the TegoWeb Express is displayed in Internet Explorer (S300), and the converted application is activated in Internet Explorer (S400). ).

The method of converting the remote data service and the window document view into the ActiveX document view is based on the following technique.

First, Automation technology is supported for Visual Basic or Microsoft Office applications and works with other application objects.

Automation is a Component Object Model (COM) -based technology that enables developers to create custom applications for tasks that need to be frequently performed, and exposes their functionality for use in other scripting languages or other interpreter languages. There is a function to expose. In addition, the automation may allow a user to modify and access properties and methods of an object by using VBscript and JAVAscript.

The COM stands for (Component Object Model) and refers to a communication protocol between objects defined by Microsoft. In addition, it refers to the most basic model created by OLE (Object Linking and Embedding), and represents a mechanism for assembling and using parts that are a unit of a program.

Objects are represented in English as Objects, which contain various meanings such as objects, objects, objects, objects, and goals. For example, the keyboard you're hitting, the monitor you're watching, and the yakult you're drinking right now can all be Objects.

In addition, the object is composed of a property representing a property or property of the object and a method for causing the object to operate. And the method is to make the object do something, and it can change the property value.

Next, the remote database service will be described.

The remote database service 230 basically consists of a client-side component and a server-side component, and the client component is a Hypertext Transfer Protocol (HTTP) protocol 270 in a Visual Basic program or Internet Explorer. ) To communicate with server-side components.

The remote database service 230 is used to transmit an Active Data Object (AD0) record set from a server to a client computer. The remote database service 230 allows remote data storage to be accessed on the web as ADO is used in Visual Basic, and the client may be a web browser 280. This can be a component in the middle.

The method of accessing and modifying data sources directly in an application using Active Data Objects (ADO) is called a two-tier system. The data source can also be indirectly connected through an intermediate medium such as a web server (Microsoft Internet Infomation Server (IIS) 200. The method is called a three-tier system, and the web server (IIS) 200 can be local, client, or application. Provides an effective way for programs to call remote or server programs over the Internet or intranets.

The ADO (Active Data Object) object uses OLE DB 205 and functions to refer to and control extended data such as spreadsheet files, text files, etc. as well as various existing databases 240. Object that provides. In addition, the OLE DB 205 was developed to use a provider for various materials such as text, spreadsheet, as well as the general database 240.

Finally, here is a description of the ActiveX documentation.

ActiveX document 110 allows non-HTML documents to be viewed within a web browser host, ie, Microsoft Internet Explorer. The ActiveX document 110 technology enables viewing of various types of documents consisting of multiple sources within a single ActiveX document 110 host.

In addition, the ActiveX document 110 is a special form of a document embedded with an OLE (Object Linking and Embedding) 205, the host when the ActiveX document 110 is represented in the entire client area of the host It is also possible to combine the menu. And the ActiveX document (110) is a complete frame, it is characterized in that it is always activated in the position.

In addition, the ActiveX document 110 was created to effectively implement an object connection in the Internet, and provides an object that can be jointly used on the Internet and an intranet to developers who are familiar with the Windows environment. I can make it.

In addition, because they are used in a variety of programming languages and applications, developers can create various types of applications, including small applications that can be distributed over the Internet or other computer networks only when needed.

In addition, the ActiveX document 110 has a function of providing the developer or the webmaster with the option of using the investment in the existing software and computer system as it is while ensuring complete security.

In addition, the ActiveX document 110 is divided into three categories consisting of ActiveX Controls, ActiveX Scripting, and ActiveX Documents.

First, ActiveX Controls allow developers to embed various software components such as graphics, animations, credit card transaction objects, or spreadsheet applets directly into HTML documents.

It supports everything before ActiveX document 110 and allows programmers to use code developed in a variety of languages, including Java, Visual C ++, Visual Basic, Borland's Delphi, and more.

ActiveX Scripting also allows combined controls to be linked together in an HTML document. Scripts can be written in either Visual Script (VB Script) or Javascript (JavaScript), allowing simple processing tasks to be executed quickly.

In addition, ActiveX Documents allows formatted documents (word processor documents, spreadsheet documents) to be viewed on client systems. In such an environment, anyone can enter the same content on the same home page, and can inspect the budget spreadsheet, query the sales database 240, and take notes without specially calling a specific software (Excel, Word). You can also make documents created on your network available to organizations or individuals using desktop software.

And, like ActiveX Controls, ActiveX document 110 cannot be used independently, and ActiveX document 110 must exist in a container and the container itself is one. It is an object.

In addition, the ActiveX document 110 is an application program that provides an object or an ActiveX document 110 that provides an object that is an actual container of the ActiveX document 110.

ActiveX Container is divided into Microsoft Internet Explorer (since version 3.0), Microsoft Office Binder (since version 1.0), and Visual Basic development environment tool window.

Figure 2a is an illustration of a word document window according to the present invention, Figure 2b is an illustration of an activex document window according to the present invention.

As shown in Figures 2a and 2b, creating a project based on the ActiveX document 110 means that you are creating a 'document' of an application that can be included in the Activex container. .

Converting to ActiveX document 110 creates a document file (.exe) of the application and a server that matches this document file, which becomes the ActiveX.dll, ActiveX.exe and ActiveX.cab files.

And while the Word document 100 contains the actual content, the Word application (Winword.exe) is used to create the document. The user can also view the Word document 100 through another container. In this case, the Word application will provide an object that can be used to view and activate another ActiveX container document, such as Internet Explorer.

The same mechanism used here applies to ActiveX documents 110 written using Visual Basic, and furthermore, existing Windows forms using TegoWeb Express. You can also apply it to converting to a web form.

3 is an overall system diagram of traditional client and server programming in accordance with the present invention.

As shown in FIG. 3, the system consists of a web server 200, a database 240, an OLE DB 205, a Hypertext Transfer Protocol (HTTP) protocol 270, and a web browser (client) 280. .

The web server 200 is a personal web server (PWS) or a Microsoft Internet Information Server (IIS), and serves as an intermediate medium when an application accesses a data source. It also has the ability for local, client or application programs to invoke remote or server programs over the Internet or intranets.

The OLE DB 205 is a technology that provides a path to access a relational database management system (RDBMS), and can access non-relational data in addition to the RDBMS.

In addition, heterogeneous relational databases 270 can be accessed, as well as non-relational data. That is, you can access not only SQL servers and RDBMSs like Oracle, but also such non-relational hierarchical data such as mail folders, each mail itself, directory, and Web site. It is OLE DB 205 technology that serves to provide such original data for us to use, and most database 240 companies provide OLE DB 205 suppliers.

In addition, the HTTP (Hypertext Transfer Protocol) protocol 270 is used to transfer a document between the web server 200 and the client browser 280 on the Internet. By linking together organically, even different documents appear to be one document and are easy to refer to.

A browser (client) 280 is a member of a class that uses a service of another class that is not relevant in object-oriented programming, and is a process (program or task) that requires a service provided by another program in computer processing. It is a document processor that requires sort routines built into other programs.

It may also mean a computer that accesses a network shared resource provided by another computer on a local area information network.

4 is a schematic diagram of a web application development method according to the present invention.

As shown in FIG. 4, based on a traditional client / server 220 accessible by the HTTP protocol 270 using the program development tool 210, a remote database service 230 access technology. When applied, logic such as presentation logic and local data validation is implemented on the web browser (client) 280 side. In addition, the business logic is implemented by an object installed in the web server 200 and a user defined handler of the object, and distributed in three layers in which the database 240 logic is implemented in the database 240 server. Develop your application.

And, the client and server (Clients and Server) web application development tool 210 produced in the above manner is usually produced as a stand-alone program 250 is executed on the user's computer, ActiveX (ActiveX) control or ActiveX ( ActiveX) Once the document is switched to the document view (260) can be implemented in a web browser (client) 280.

In addition, the method can be used to implement both the stand-alone window program 250 and the web program as one source.

As described above, according to the technology for converting a window form to a web form according to the present invention, since both stand-alone window programs and web programs can be implemented as one source than a conventional conventional technology, it is economically and time-consuming. You can get

In addition, by simply switching the document view of the Client and Server program to which the Remote Database Service service technology is applied, the web application program can be produced very easily because it is implemented in the web browser as it is. It has an effect.

In addition, it is possible to produce web applications while maintaining the traditional client and server development language, human resources, and program development methodologies. Therefore, technical advantages and economic effects can be expected.

Although the present invention has been described in connection with the above-mentioned preferred embodiments, various other modifications and variations may be made without departing from the spirit and scope of the invention. Accordingly, it is intended that the appended claims cover such modifications and variations as fall within the true scope of the invention.

Claims (3)

Applying an automation technique using an Automation Controller to convert the application program to be converted into an ActiveX document 110 (S100); The automation controller (Station) to convert the application program using Tego Web Express (S200); Displaying the converted application program using the TegoWeb Express in Internet Explorer (S300); And And converting the converted application into Internet Explorer (S400). The method of claim 1, further comprising converting the remote data service and the window document view into an ActiveX document view. The method of claim 1, wherein TegoWeb Express includes ActiveX document 110 migration for almost any kind of application having a user interface in Windows regardless of a development language. How to convert the remote data service and window document view to an ActiveX document view, characterized in that. 3. The active document of claim 2, wherein the application is a database access method having a three-tiered method in which a remote database service 230 is applied. How to switch to view.