GB2466216A - Using Internet information server in a client - Google Patents

Using Internet information server in a client Download PDF

Info

Publication number
GB2466216A
GB2466216A GB0822694A GB0822694A GB2466216A GB 2466216 A GB2466216 A GB 2466216A GB 0822694 A GB0822694 A GB 0822694A GB 0822694 A GB0822694 A GB 0822694A GB 2466216 A GB2466216 A GB 2466216A
Authority
GB
United Kingdom
Prior art keywords
remote server
server
client device
database
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Withdrawn
Application number
GB0822694A
Other versions
GB0822694D0 (en
Inventor
Brendan Feeney
Margaret Christine Feeney
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Priority to GB0822694A priority Critical patent/GB2466216A/en
Publication of GB0822694D0 publication Critical patent/GB0822694D0/en
Publication of GB2466216A publication Critical patent/GB2466216A/en
Withdrawn legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/95—Retrieval from the web
    • G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
    • G06F16/972—Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

A method of processing data stored in a client device server operating an internet information server (IIS) environment, on a remote server in real time. Data is stored in an SQL database associated with the client device server. An active database connection is established with an SQL database associated with the remote server and data is transferred over the active database connection. An instruction is sent to the remote server database to execute a script and the transferred data is processed using a remote server application. The result of the processing is stored in the remote server for subsequent retrieval by the client device server.

Description

"A method of processing data"
Introduction
This invention relates to a method of processing data stored in a client device server operating an internet information server (uS) environment, on a remote server in real time.
The concept of distributed computing has been known for many years. There are numerous advantages to implementing distributed computing and spreading the computational burden over a number of distinct machines. These advantages include reducing the cost of processing power and capital expenditure required at each individual machine, reducing the computational burden on the individual machines and speeding up the processing of various tasks executed by the machines.
However, there are certain environments in which the benefits of distributed computing cannot be achieved to their fullest extent. For example, heretofore, it has not been possible to fully realise the benefits of distributed computing in architectures in which there is a client server operating an Internet information server (ItS) environment in combination with a Structured Query Language (SQL) database structure. This is due mainly to security restrictions imposed by the IIS environment.
It is an object of the present invention to provide a method that overcomes the obstacles to processing data stored in a client device server operating an Internet information server (IlS) environment, on a remote server in real time.
Statements of Invention
According to the invention there is provided a method of processing data stored in a client device server operating an internet information server (ItS) environment, on a remote server in real time; the client device server comprising a processor, a visual display unit, a data entry component, a structured query language (SQL) database having the data stored therein and a communication component for transmitting and receiving communications to and from the remote server over the internet and accessing world wide web pages through the internet; the remote server comprising a processor, an SQL database, a remote server application for processing received data, and a communication component for receiving data from and transmitting and receiving communications to and from the client device server; the method comprising the steps of: the client device server opening an active database connection with the remote server SQL database; the client device server transferring data stored in the client device server SQL database to be processed by the remote server to the remote server SQL database; the client device server instructing the remote server SQL database to process the transferred data using the remote server application by executing a script stored in the remote server SQL database; the remote server SQL database processing the transferred data using the remote server application by executing the script with the transferred data and storing the result in a file format in a folder on the remote server; the remote server transmitting the location of the results in the file format to the client device server; the ciient device server accessing the results in the file format and displaying the results in a web page format on the visual display unit of the client device server; and the client device server closing the active database connection with the remote server SQL database.
By having such a method, a client device server operating an internet information server (uS) environment, can have data that is stored in a local SQL database processed on a remote server SQL database in real time. This will reduce the computational burden at the client device server and speed up the processing of the data.
In one embodiment of the invention there is provided a method in which the step of the remote server SQL database executing the script with the transferred data further comprises the remote server SQL database executing a stored procedure.
In one embodiment of the invention there is provided a method in which the remote server application is a plotting application and the step of processing the data comprises plotting a chart with the plotting application.
In one embodiment of the invention there is provided a method as claimed in any preceding claim in which the step of the remote server transmitting the location of the results in the file format to the client device server comprises the remote server transmitting a URL to the client device server.
In one embodiment of the invention there is provided a method in which the step of the remote server SQL database storing the results in a file format in a folder on the remote server further comprises the remote server database storing the results in a publicly accessible folder on the remote server.
In one embodiment of the invention there is provided a method in which the client device server uses a local connection protocol to open an active database connection with the remote server SQL database.
Detailed Description of the Invention
The invention will now be more clearly understood from the following description of an embodiment thereof given by way of example only with reference to the accompanying drawing, in which there is shown a diagrammatic representation of a system in which the method according to the present invention may be carried out.
Referring to the drawing, there is shown a system, indicated generally by the reference numeral 1, comprising a plurality of client device servers 3(a)-3(e) and a remote server 5. The client device servers 3(a)-3(e) and the remote server 5 are in communication with each other through a communication network, in this case the Internet 7.
Each of the client device servers 3(a)-3(e) operates an Internet information server (115) environment, and comprises a processor 9, a visual display unit (VDU) 11, a data entry component 13 and an SQL database having data stored therein. The client device servers 3(a)-3(e) each further comprise a communication component (not shown) for transmitting and receiving communications to and from the remote server 5 over the internet 7 and accessing world wide web pages over the internet 7. The remote server 5 comprises a processor (not shown), an SQL database 17, a remote server application for processing received data and a communication component (not shown) for receiving data from and transmitting and receiving communications to and from the client device servers 3(a)-3(e).
In use, one of the client device servers 3(a)-3(e) will wish to have data processed by the remote server application residing on the remote server 5. In order to have the data processed by the remote server application, the client device server 3(a)-3(e) opens an active database connection with the remote server SQL database 17. In order to achieve this, the client database opens an SQL connection with the server database over an internet connection. The client server software opens an active connection to the server SQL database. The connection is made via asp using the SQL Native Client OLE DB Driver. The SQL Native Client OLE DB Driver is a standard component included in IIS and SQL Express 2005.
Once the active database connection has been created, the client device server 3(a)- 3(e) transfers the data to be processed that is stored in the client device server SQL database 15 to the remote server SQL database 17 over the active database connection. The client device server then instructs the remote server SQL database 17 to process the transferred data using the remote server application by executing a script stored in the remote server SQL database 17. The script is a program consisting of a set of instructions to the remote server application. The client device server then closes the active database connection with the remote server SQL database 17. Effectively therefore, data is gathered from the client device server database. Using the active db connection, the client device server executes a stored procedure on the remote server DB using the aforementioned gathered data as stored procedure parameters. The stored procedure, which can also be referred to as a script, uses the provided parameters to execute the desired process.
Once the remote server SQL database receives the instruction from the client device server, the remote server SQL database processes the transferred data using the remote server application by executing the script with the transferred data and stores the results in a file format in a folder on the remote server. The remote server 5 then transmits the location of the results in the file format to the client device server 3(a)-3(e) over the active database connection and thereafter the client device server 3(a)-3(e) accesses the results in the file format and displays the results in a file format in a web page format on the visual display unit 11 of the client device server.
For reasons of clarity, an exemplary implementation of the invention will be described in more detail herein. In the exemplary embodiment, the remote server application is a plotting application that receives data, manipulates the data if necessary and thereafter plots the data in a chart, thereby providing a graphical representation of the data.
Plotting software is notoriously computationally intensive and requires substantial processing resources to execute. Accordingly, it is highly undesirable to perform the plotting operation on the client server devices 3(a)-3(e). In the exemplary embodiment, data is inserted into the client device server SQL database 15 using the data entry component 13. The client device server 3(a)-3(e) then opens an active database channel with the remote server database 17 and the data to be processed is transferred from the client device server database 15 to the remote server database 17. Once the data is received as parameters by the remote server database 17, the client device server transmits an instruction to the remote server database 17 to process the transferred data using the remote server application by executing a script stored in the remote server SQL database 17. The script is effectively a stored procedure in the remote server SQL database 17.
The remote server SQL database 17 processes the data using the remote server plotting application and a chart is produced. This chart is then stored in a file format in a publicly accessible folder in the remote server. The result in a file format is essentially therefore an image that has been produced by the plotting software. The remote server transmits the address of the chart on the remote server to the client device server 3(a)-3(e) that sent the data to it initially using the active db connection. This address is in the form of a uniform resource locator (URL). The client device server uses the URL to access the chart and displays the chart in web page format on the VDU 11. The active database connection is then closed by the client device server. In this way, the client device server may operate an ItS environment and avail of the processing capability of the remote server.
It is proposed that the present invention is counterintuitive to the standard operation and use of ItS. The skilled addressee would envisage that it would be possible to build a script on the remote server which could be downloaded/executed each time a client requests to build a chart. This kind of functionality is commonly used in Microsoft � ItS using the include file command, for example, <!--#include flle="includejiles/fllejo execute.asp" -->.
Indeed, such an approach works when trying to execute scripts/files that reside on the same server/machine. However, it is not possible for a machine/server to request the execution of scripts/files that reside on another server/machine using Microsoft � IIS due to security restrictions enforced by Microsoft � IIS. The main issue with IIS is the access restrictions imposed. IIS only allows executable content to be run from the residing server/machine. For example, one cannot execute the following: <i--#include file= "http://www.anothersenier.com/include_flles/flle_to execute.asp" -->.
In order for clients to execute the scriptlfile to build charts, which resides on the remote server, another method of executing the relevant script/file is necessary. The present invention provides one such method to allow this functionality to be achieved using an IIS architecture.
In the embodiment described, the client device servers are built upon Microsoft (Registered Trademark (�)) uS technology using scripting languages such as ASP, HTML, JavaScript, CSS. It is envisaged that other scripting languages could be used if desired. Furthermore, the client device server database and the remote server database could be provided by other relational databases.
In the embodiment described above, the client device server connects to the remote server database as opposed to having a database to database connection. The connection is made using OLE DB drivers. Once the connection is authenticated, the client device server requests the execution of a stored procedure on remote server DB.
The aforementioned stored procedure is executed with parameters that have been supplied by the client device server and obtained from the client device server database, on the remote server DB. The active database connection is closed upon execution of all scripts/applications. Effectively therefore, when the client device server receives the URL of the resulting image back from the remote server database via the active db connection, the client device server terminates the connection.
In this specification the terms "comprise, comprises, comprised and comprising" and the terms "include, includes, included and including" are all deemed totally interchangeable and should be afforded the widest possible interpretation.
The invention is in no way limited to the embodiment hereinbefore described but may be varied in both construction and detail within the scope of the specification.

Claims (7)

  1. Claims 1) A method of processing data stored in a client device server operating an internet information server (uS) environment, on a remote server in real time; the client device server comprising a processor, a visual display unit, a data entry component, a structured query language (SQL) database having the data stored therein and a communication component for transmitting and receiving communications to and from the remote server over the internet and accessing world wide web pages through the internet; the remote server comprising a processor, an SQL database, a remote server application for processing received data, and a communication component for receiving data from and transmitting and receiving communications to and from the client device server; the method comprising the steps of: the client device server opening an active database connection with the remote server SQL database; the client device server transferring data stored in the client device server SQL database to be processed by the remote server to the remote server SQL database; the client device server instructing the remote server SQL database to process the transferred data using the remote server application by executing a script stored in the remote server SQL database; the remote server SQL database processing the transferred data using the remote server application by executing the script with the transferred data and storing the result in a file format in a folder on the remote server; the remote server transmitting the location of the results in the file format to the client device server; the client device server accessing the results in the file format and displaying the results in a web page format on the visual display unit of the client device server; and the client device server closing the active database connection with the remote server SQL database.
  2. 2) A method as claimed in claim 1 in which the step of the remote server SQL database executing the script with the transferred data further comprises the remote server SQL database executing a stored procedure.
  3. 3) A method as claimed in claim 1 or 2 in which the remote server application is a plotting application and the step of processing the data comprises plotting a chart with the plotting application.
  4. 4) A method as claimed in any preceding claim in which the step of the remote server transmitting the location of the results in the file format to the client device server comprises the remote server transmitting a URL to the client device server.
  5. 5) A method as claimed in any preceding claim in which the step of the remote server SQL database storing the results in a file format in a folder on the remote server further comprises the remote server database storing the results in a publicly accessible folder on the remote server.
  6. 6) A method as claimed in any preceding claim in which the client device server uses a local connection protocol to open an active database connection with the remote server SQL database.
  7. 7) A method of processing data stored in a client device server operating an internet information server (IIS) environment, on a remote server in real time substantially as hereinbefore described with reference to and as illustrated by the accompanying drawings.
GB0822694A 2008-12-12 2008-12-12 Using Internet information server in a client Withdrawn GB2466216A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
GB0822694A GB2466216A (en) 2008-12-12 2008-12-12 Using Internet information server in a client

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
GB0822694A GB2466216A (en) 2008-12-12 2008-12-12 Using Internet information server in a client

Publications (2)

Publication Number Publication Date
GB0822694D0 GB0822694D0 (en) 2009-01-21
GB2466216A true GB2466216A (en) 2010-06-16

Family

ID=40326012

Family Applications (1)

Application Number Title Priority Date Filing Date
GB0822694A Withdrawn GB2466216A (en) 2008-12-12 2008-12-12 Using Internet information server in a client

Country Status (1)

Country Link
GB (1) GB2466216A (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20010034733A1 (en) * 2000-03-03 2001-10-25 Michel Prompt System and method for providing access to databases via directories and other hierarchical structures and interfaces
US20030115572A1 (en) * 2001-08-28 2003-06-19 Clickmarks, Inc. System, method and computer program product for application development using a visual paradigm to combine existing data and applications
US6714928B1 (en) * 1999-03-19 2004-03-30 Sybase, Inc. Development system providing HTML database control object

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6714928B1 (en) * 1999-03-19 2004-03-30 Sybase, Inc. Development system providing HTML database control object
US20010034733A1 (en) * 2000-03-03 2001-10-25 Michel Prompt System and method for providing access to databases via directories and other hierarchical structures and interfaces
US20030115572A1 (en) * 2001-08-28 2003-06-19 Clickmarks, Inc. System, method and computer program product for application development using a visual paradigm to combine existing data and applications

Also Published As

Publication number Publication date
GB0822694D0 (en) 2009-01-21

Similar Documents

Publication Publication Date Title
US11675930B2 (en) Remoting application across a network using draw commands with an isolator application
EP3440542B1 (en) Applying bytecode obfuscation techniques to programs written in an interpreted language
US10567346B2 (en) Remote browsing session management
EP3097509B1 (en) Intercepting and supervising calls to transformed operations and objects
US10552639B1 (en) Local isolator application with cohesive application-isolation interface
JP4878627B2 (en) Initial server-side content rendering for client script web pages
US9563929B1 (en) Caching of content page layers
CA2237333C (en) A method and apparatus for making a hypermedium interactive
US9973563B2 (en) Implementing a java method
US9208316B1 (en) Selective disabling of content portions
KR20040089600A (en) Interacting with software applications displayed in a web page
US20020196279A1 (en) Interacting with software applications displayed in a web page
US9563928B1 (en) Bandwidth reduction through delivery of hardware-independent graphics commands for portions of content pages
WO2014153540A4 (en) Local server for synced online content management system
WO2007057006A1 (en) Method of performing web clipping, a web-clipping server and a system for web clipping
US11876854B2 (en) Network browser engine
CN106411880B (en) A kind of safe encryption and decryption method of game data and encryption, decryption device
WO2015080903A1 (en) Systems and methods for executing aspects of a document
JP7071379B2 (en) Deferring a call request from a remote object
US10165036B1 (en) Network resource remote process execution
CN109299331A (en) Air shows the method and device of the hypertext markup language HTML5 page
CN109218297B (en) Method and device for requesting data
WO2014120179A1 (en) Remote client application
GB2466216A (en) Using Internet information server in a client
JP5541160B2 (en) Program acquisition / execution client, program acquisition / execution method and program

Legal Events

Date Code Title Description
WAP Application withdrawn, taken to be withdrawn or refused ** after publication under section 16(1)