WO1997015017A1 - Accessing databases - Google Patents
Accessing databases Download PDFInfo
- Publication number
- WO1997015017A1 WO1997015017A1 PCT/GB1996/002572 GB9602572W WO9715017A1 WO 1997015017 A1 WO1997015017 A1 WO 1997015017A1 GB 9602572 W GB9602572 W GB 9602572W WO 9715017 A1 WO9715017 A1 WO 9715017A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- database
- user
- processing device
- data
- remote
- Prior art date
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Definitions
- the present invention relates to accessing relational database systems from remote terminals.
- Distributed data access systems are known that require a central authority responsible for defining a rigid set of conventions, known as a global schema, to control the way in which data is structured and represented at the various sites that make up the system.
- the existence of the global schema restricts the autonomy of the local sites and results in rigidity and delay with regard to when and how data is stored and accessed.
- a simple database system which may be accessed remotely is described in GB 1581136, which describes an information handling system and terminal apparatus therefore.
- Information may be displayed as an index and selections may be made by operators by operation of a keypad to indicate which item of a displayed index is required.
- the system effectively describes an arrangement of linked flat pages where a selection made on the top level page will result in a lower level page being supplied to a user.
- the database structure of this type only allows pre-stored information to be supplied to users.
- the present invention is directed towards the problem of accessing central relational database systems, where database specific commands are required to be activated in response to local selections. These types of commands may involve complex filtering combining and displaying commands so as to derive optimum benefit from relational databases containing a plurality of tables.
- no provision is made for activating commands of this type, given that all data supplied to users is predefined. Such an arrangement would therefore have serious limitations and access is to be provided to relational databases.
- SQL SQL
- SQL SQL may be directed at the database. These may cause undesirable operations to be effected upon the database which may corrupt data or, more likely, may consume significant amounts of processing time as re-indexing operations are performed. It is therefore desirable to provide the power of relational database environments while at the same time providing a level of restriction upon the extent to which some users may given access to certain procedural systems.
- a method of accessing a relational database system from user terminals comprising steps of establishing a communication channel between a user terminal and said database system; supplying data from said connected system to said terminal to identify available data mappings; selecting a data mapping at said terminal; supplying an indication of said selection to the database system; and activating database specific instructions upon said relational database in response to said user selection.
- the invention provides a mechanism by which powerful database enquiries may be effected, using database specific instructions while maintaining a simple user interface presenting a plurality of possibilities from which a selection may be made.
- highly powerful instructions may be implemented upon the database, the extent to which said instructions may be defined is limited, thereby preventing undesirable instruction sets being applied directly to the database.
- database specific instructions are defined in accordance with Standard Query Language (SQL) and said SQL may be generated by execution of a predefined script, possibly defined in accordance with the PERL language.
- SQL Standard Query Language
- a user terminal programmed to access a remote relational database, said terminal comprising a processing device and a memory device arranged to supply commands to said processing device, wherein said commands establish a communication channel to a remote database system and said memory device receives new commands inviting a user to select a data mapping; and in response to a mapping being selected, said processor issues a command to said database such that said database activates database specific instructions in response to the local selection.
- a database system comprising a processing device and a memory device arranged to supply commands to said processing device, wherein said commands instruct said processing device to interpret requests received from user terminals, such that said database system provides an indication of available values to said terminals and provides data relating selected values to selected mappings in response to commands received from terminals, wherein database specific instructions are activated locally upon said database.
- a first processing device is configured to communicate with remote users and a second processing device is configured to maintain said relational database, wherein a communications link is established between said first processing device and said second processing device.
- the first processing device and the second processing device are configured to communicate in accordance with JAVA protocols.
- the database system is configured to communicate with remote users by the generation of universal resource locators over the World Wide Web.
- the identification and selection of data using World Wide Web technology is known, as described in the precedings of the SCERN School of Computing in an article by H. W. Lie entitled "World Wide Web Technology".
- the use of uniform or universal resource locators is described in the publication EDPACS, for example in the article by M. Hahn number 6 of volume 23.
- the tools available within internet and intranet applications are also described in the article by K. Obraczka published in the Journal "Computer” on 01 September 1993, volume 26 number 9.
- Figure 1 is a diagrammatic representation of the international distribution network known as the world wide web, forming part of the intemet; having local user sites and remote databases connected thereto;
- Figure 2 details a remote database of the type shown in Figure 1 , having a database computer and a network access computer;
- Figures 3A, 3B, 3C and 3D illustrate database tables of the type stored on the database computer shown in Figure 2;
- FIG. 4 details equipment contained within the database computer shown in Figure 2 and illustrates processes executed by said computer;
- FIG. 5 illustrates procedures executed by the equipment shown in Figure 4.
- Figure 6 illustrates an accessing computer of the type shown in Figure 1 , including a processor for executing application programs received from the network and a monitor for displaying information in response to these application programs;
- Figure 7 illustrates a graphical user interface displayed by the display device shown in Figure 5, including fields for specifying data requests and fields for displaying information received from the remote database;
- Figures 8a and 8b illustrate displays arranged to receive user instructions as shown in Figure 7 and
- Figure 9 illustrates the data display identified in Figure 7.
- URLs of this type may be generated manually by an operator, or, alternatively they may be generated automatically as programs are executed.
- pages of data are supplied to users in a structured form, specified using "hyper-text mark-up language” (HTML) and servers of this type are identified as operating in accordance with "hyper-text transport protocol” (HTTP).
- HTML hyper-text mark-up language
- HTTP hyper-text transport protocol
- a HTTP server may issue a formatted HTML page to the requesting user, thereby allowing information to be displayed to the user in a structured way.
- executable programs identified as "common gateway interface binary" programs (CGI. BIN programs) so as to further enhance the functionality of the interactive world wide web environment.
- a session may be initiated by a local user requesting access to a remote station, whereafter, embedded within an HTML page, JAVA code is supplied back to the requesting user such that an application program is effectively loaded into local memory. The user may then interact with that application, allowing transactions to be made over the network, effectively under the control of the remote station.
- a platform of this type is used within the present embodiment in order to provide remote access to databases and to allow database queries to be made.
- Standard query language is widely used, usually referred to as SQL, configured to allow queries to be made to many different proprietary database systems.
- SQL Standard query language
- a database in combination with a terminal or terminals for providing access to said database would be considered as an isolated self-contained system, where the data volume and the type of enquiries that can be made to that volume remain substantially constant.
- database systems include database specific commands contained as sets of commands or program files which may be stored at the remote databases or constructed at said remote database when required.
- the essential feature of databases is that they facilitate data mappings such that data of a first type may be associated with data of a second type. For example, a customer may be identified with a unique customer identification. This would often make up the primary key in database systems such that all associated data within a particular table would be indexed to this key; given the identification number other data can be retrieved extremely quickly without performing resource- demanding searches.
- Associated with this entry other data may be included, such as a customer's name, address, post code, number of telephone Iines, equipment requirements, customer age, date of installation and so on.
- another table or another database may include on-going account information associating the customer's identification with financial details relating to the customer's account.
- fields may exist identifying the amount of the customer's last bill, the extent of any discounts given to that customer, a credit rating for that customer, an indication of the customers history of bill payments and so on.
- the customer identification is unique and by aligning customer identification with customer name on the first table, it is possible to relate this to a second table that maps customer identification to financial details.
- a relational link may be provided between customer names and amount outstanding, although this actual mapping does not exist in any one table. This approach forms the basis for relational databases.
- each remote database contains a directory identifying particular mappings that may be provided by that database.
- a user may wish to relate data of type A to data of type C.
- the database may be capable of mapping data of type A to data of type B.
- another database may be capable of mapping data of type B to data of type C.
- the database also includes mechanisms for activating database specific commands so that the data may be examined as required by a user.
- the user is now capable, from a local station, of making effective database enquiries at the remote database, without requiring detailed information concerning the way in which SQL enquiries must be configured for that particular database.
- a communication channel is established between the user's terminal and the database system. In the preferred embodiment, this consists of the terminal issuing a URL to the database system, which in turn results in JAVA code being supplied back to the user which, when executed at the user's terminal, results in an application-type environment being provided to the user so as to facilitate further interaction with the remote database system.
- the user is encouraged to select a data mapping and once selected, an indication of this mapping is supplied to the remote database.
- the user's environment has been provided by JAVA instructions, therefore the data sent back to the remote database will again be in a form consistent with the known JAVA protocols.
- These protocols identify specific program files within the remote database which, in the present embodiment, are defined under the interactive language PERL.
- a PERL program is executed, resulting in the generation of an SQL enquiry specific to the particular database concemed.
- SQL enquiries may be stored and selected as required. In either event, the process involves the activation of a database specific command at the database systems, in response to user selection, resulting in appropriate information being supplied back to the local requesting users.
- An Oracle relational database is retained on a database computer 110 and access to this database computer is provided via a remote network computer 111 having a connection to the world wide web 101.
- a local user terminal 112 is connected to the world wide web 101 and is thereby given access to the remote database computer 110.
- the remote network computer 111 executes program instructions licensed by Sun Microsystems Inc. under the trademark "JAVA".
- JAVA code is embedded within HTML pages supplied to the local user terminal 112 so as to effectively provide an application program to the local terminal allowing it to gain access to the remote database 110.
- the extent to which local users may gain access to the remote database is constrained to operations that are facilitated within the JAVA environment. In this way, database suppliers retain a level of control as to how users may exploit the information available from their database.
- Computer 110 essentially provides a conventional database environment allowing direct connection of associated terminals 201 , 202, 203 etc.
- the database retained on database computer 110 is a relational database, comprising a plurality data tables of the type illustrated in Figures 3A, 3B, 3C and 3D.
- This database has been created as a result of the promotional campaign and retains a record of levels of expenditure, made on a region by region basis.
- the database also includes basic arithmetic functions, similar to those provided within conventional spreadsheet environments, allowing columns of figures to summed, thereby effectively providing totals of costs over a plurality of geographical regions.
- a second database retains information relating to product sales and a third database includes information relating to customers.
- a table for recording product sales is illustrated in Figure 3B.
- a customer identification is entered in column 303, followed by the value for the sale being added in column 304 and a product identification being placed in column 305.
- a table of this type may be constructed over a pre-determined time duration, thereby the total values accrued in column 304 gives a figure for the total sales made during that period.
- each sale in the table is only mapped against a customer identification and a product identification, therefore, it is not possible, using this table, to divide sales on a regional basis.
- a third database contains information relating to customers and a table from this database is illustrated in Figure 3C.
- a table from this database is illustrated in Figure 3C.
- this database includes a second table, illustrated in Figure 3D in which each city is entered in a column 310 with its corresponding geographical region specified in column 311. From the table shown in figure 3B, it is possible to derive sales values on a customer by customer basis. This table may then be related to that shown in Figure 3C allowing the customer-by-customer based figures to be converted to city-by-city based figures.
- this data may then be related to the table shown in Figure 3D so as to show total sales on a region- by-region basis.
- a mapping of total sales on a region by region basis may be derived, which could then be compared to advertising costs derived from the data shown in table 3A, that is also recorded on a region-by-region basis.
- Enquiries for relating the information contained in tables 3B, 3C and 3D are well known in the art and are generally constructed using the SQL language. However, the extent to which this language may be used within a particular environment depends upon the structure of the data contained within that environment. In known systems, it would not be possible for local users to gain access to remote databases unless they had an in depth knowledge of the database structure. However, in the present embodiment, remote access is achieved by effectively inviting a local user to make requests within an environment defined by the remote system.
- a local user issues a URL from their local user terminal 112 to the remote network computer 111 , via the local user terminal 112.
- the URL is received by the remote network computer 111 and processed to provide access to the remote database computer 110.
- Operational functionality of the remote network computer 111 and the remote database computer 110 are illustrated in Figure 4.
- a session initiating URL is received by an HTTP interpreter 401 , which in turn relays a request to a JAVA inte ⁇ reter 402.
- the JAVA inte ⁇ reter 402 determines whether the requesting user may be given access to the system and once so determined, HTML pages are returned to the HTTP interpreter 401 having executable code (in the form of CIG. BIN programs) embedded therein.
- the HTTP interpreter 401 dynamically assembles appropriate HTML pages and directs these via the world wide web 101 to the requesting local user via their respective terminal, such as local terminal 112.
- the HTML page is received and the JAVA codes embedded within the HTML pages are effectively loaded into the local memory of the local user terminal for local execution therein, in a way substantially similar to that performed when local application programs are executed.
- the execution of this JAVA code results in a graphical user interface being displayed at the local user terminal 112 in a form which allows the local user to access the remote database and to perform operations upon said database.
- the environment does not allow a user to supply SQL or similar enquiries.
- the environment allows particular types of operations to be performed on the basis that enquiry programs are already available to the remote site.
- the graphical user interface supported by the JAVA code effectively allows a user to select pre-defined SQL instructions such that all actual enquiries to the database are made using SQL enquiries held under the control of the remote database station.
- a local user interacts with the graphical user interface defined by the
- JAVA code resulting in further URLs being supplied to the HTTP inte ⁇ reter 401 via the world wide web 101.
- the embedded JAVA instructions are derived that are, in turn, supplied to the JAVA interpreter 402.
- the JAVA inte ⁇ reter 402 communicates via an ethernet link 403, with a JAVA interface module 404 executed by the database computer
- the graphical user interface provided for local users is initially created under instructions derived exclusively from the remote network computer 111.
- their associated remote network computer will be substantially similar to computer 111 and provide substantially similar graphical user interfaces.
- the graphical user interface merely provides a "desktop" upon which specific database-related values and dimensions may be manipulated.
- the database computer 110 is therefore provided with a networking store 405 containing database meta ⁇ data, that is data about the data contained within the database.
- the JAVA interpreter 402 packages the information for embedding within an HTML page and the construction of the HTML page is made under the control of the HTTP inte ⁇ reter (or Daemon) 401.
- the HTTP Daemon 401 supplies the HTML page to the local terminal via the world wide web so that, when received, the JAVA code is identified and used to provide the user with a graphical representation of the data derived from the networking store 405, representing the structure of the actual data contained within the database.
- the data contained within the database 406 may be considered as being contained in the form of tables.
- All operations performable upon the data contained with the database 406 are specified by respective enquiry programs defined using the language PERL.
- the PERL programs are stored within a PERL program store 408 and a selected PERL program is supplied to a PERL inte ⁇ reter 409 that is arranged to execute the PERL instructions and thereby generate SQL queries.
- enquiries in a platform independent way with appropriate PERL inte ⁇ reters being provided so as to generate SQL instructions in a form that is appropriate for the particular platform being used.
- SQL instructions generated by the PERL interpreter 409 are supplied to an SQL processor 410 arranged to execute the SQL instructions and thereby perform operations upon the database 406.
- SQL instructions will be executed by the SQL processor 410 resulting in particular mappings of data entries being examined within the database 406.
- the system maintains a record of the actual mappings that have been requested and this list of mappings is retained within a mapping store 408.
- Operations executed within the environment shown in Figure 4 are illustrated in Figure 5.
- the HTTP interpreter 401 is configured to continually examine an intemet port in order to detect the arrival of a URL. A question is asked at step 501 as to whether a URL has been received and if answered in the affirmative a question is asked at step 502 as to whether the URL in valid.
- control is returned to step 501 and the system continues to wait for received URLs.
- step 502 If the question asked at step 502 is answered in the affirmative, to the effect that a valid URL has been received, embedded JAVA code is supplied back to the requesting user effectively supplying the JAVA platform to the user, as identified at step 503.
- This JAVA platform is generated by the JAVA inte ⁇ reter 402, whereafter a connection to the database computer 110 is established over the ethernet 403.
- the database meta-data is supplied to the user from the networking store 405 illustrated by link 411 in Figure 4.
- the local user Upon receive the meta-data, the local user is now in a position to make the database requests supplied to the network computer via appropriate URLs.
- the system waits for database instructions and asks a question as to whether a database instruction has been received. If answered in the affirmative, a question is asked at step 506 as to whether the instruction is valid and if either of the questions asked at step 505 or step 506 is answered in the negative, control is returned to step 505.
- a PERL program from the PERL program store 408 is selected at step 507 and at step 508 the selected PERL program is executed by the PERL interpreter 409 to generate an SQL enquiry.
- the SQL enquiry is processed by the SQL processor 410 and as new mappings are defined, the mapping store 408 is updated at step 509.
- the SQL enquiry is executed by the SQL processor 410 and database results are returned, via the SQL processor 410 to the JAVA interface 404, indicated by link 412 in Figure 4.
- results from the database enquiry are supplied over the ethernet 403 to the JAVA inte ⁇ reter 402 and are then supplied to the HTTP interpreter 401 , resulting in an HTML page being issued at step 512.
- control is returned to step 505 in anticipation of further database instructions being received.
- a local user terminal 112 is details in Figure 6.
- the user terminal typically comprising a SUN work station, has a processor 601 , a monitor 602, a keyboard 603 and a mouse 604.
- the processor 601 accesses the world wide web via modem 605.
- modem 605 When a connection is established to the remote database, JAVA code is returned to the processor 601 via the modem 605, resulting in a graphical user interface 606 being displayed on the monitor 602.
- the user communicates via the graphical user interface by operation of the mouse 604. Conventional techniques of dragging, clicking and selecting soft buttons result in the generation of appropriate URLs generated in response to the meta-data received from the mapping store 408.
- the information contained in the database may be considered as representing names of quantifiable values.
- the environment provided by the graphical user interface 606 effectively allows particular types of queries to be executed upon the remote database. By restraining the number of operations that can be performed on the database, the actual steps involved by an operator in order to gain access are substantially simplified and made much more intuitive.
- the actual query programs are generated at the remote platform and an environment is created, via the world wide web, allowing different databases to be accessed in a similar way.
- links to databases may be established, particularly via the URL mechanism, implementing a stored program at the remote location, such that the access to data is effectively extended outside the local data environment.
- hyper-text a database environment with links to other databases, presented in a substantially transparent way as provided by the present embodiment, may be referred to as "hyper-data”.
- the graphical user interface 606 is detailed in Figure 7. Clearly the exact nature of the graphical user interface will change as operations are perform and it should be understood that the representation shown in Figure 7 reflects an example of an interaction with the database; although similar interactions would take on a similar topology within the graphical user interface (GUI) environment.
- GUI graphical user interface
- quantifiable values of this type include the advertising expenditure and the associated product sales.
- accessible quantifiable values are displayed in a value display region 701. The actual values displayed will depend upon the nature of the information available from the database.
- the value of sales may be considered within the dimension of customers, within the dimension of cities or within the dimension of regions.
- the available dimensions are illustrated in a dimension display region 702.
- the results obtained from viewing a selected value within a selected dimension are displayed within a data grid 703.
- the GUI is completed by a plurality of soft buttons 704, 705 and 706.
- the value display region 701 is detailed in Figure 8A for a typical session involving the data identified in Figures 3A, 3B, 3C and 3D. From this data, it is possible to examine values for expenditure and for sales.
- the dimension display region 702 is detailed in Figure 8B.
- the sales value 802 is displayed in the dimension display region within a value box 804.
- three available dimensions are displayed consisting of the customer dimension displayed in a box 805, the city dimension displayed in a box 806 and the region dimension displayed within a box 807.
- the operator in this example, is interested in viewing sales on a region by region basis, so that these regional sales may be compared against regional advertising expenditure.
- the operator therefore moves the displayed cursor, shown as arrow 808, over box 807 and effects a double mouse click, thereby selecting this dimension.
- the selection of dimension 807 has been identified by the outer box 809 positioned around the inner box 807.
- a query represented in accordance with the JAVA protocol, is supplied to the remote database resulting in SQL queries being generated and indications supplied to the mapping store 408 identifying a selection of the sales value and the region dimension.
- a figure representing the total sales is derived from the database and returned to the local user such that the information is displayed in display box 901 of the data grid shown in Figure 9.
- the selected value name "Sales" is displayed at 902 beneath the value box 901.
- the database has been interrogated in order to provide dimension data showing sales on a region by region basis.
- the total sales expenditure displayed in a value box 906
Abstract
Description
Claims
Priority Applications (5)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/043,644 US6035298A (en) | 1995-10-19 | 1996-10-18 | Accessing plural independent databases having plural database schemas |
EP96935047A EP0856177A1 (en) | 1995-10-19 | 1996-10-18 | Accessing databases |
AU73147/96A AU713437B2 (en) | 1995-10-19 | 1996-10-18 | Accessing databases |
CA002235320A CA2235320C (en) | 1995-10-19 | 1996-10-18 | Accessing databases |
JP9515630A JPH11514477A (en) | 1995-10-19 | 1996-10-18 | Accessing the database |
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
EP95307469 | 1995-10-19 | ||
EP95307469.7 | 1995-10-19 | ||
US60904496A | 1996-02-29 | 1996-02-29 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO1997015017A1 true WO1997015017A1 (en) | 1997-04-24 |
Family
ID=8221377
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/GB1996/002572 WO1997015017A1 (en) | 1995-10-19 | 1996-10-18 | Accessing databases |
Country Status (5)
Country | Link |
---|---|
EP (1) | EP0856177A1 (en) |
JP (1) | JPH11514477A (en) |
AU (1) | AU713437B2 (en) |
CA (1) | CA2235320C (en) |
WO (1) | WO1997015017A1 (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
GB2325762A (en) * | 1997-03-31 | 1998-12-02 | Ibm | Development environment for internet-based relational databse access programs |
WO1999023580A1 (en) * | 1997-11-05 | 1999-05-14 | Ericsson Inc. | Method and apparatus for updating databases |
US6448981B1 (en) | 1997-12-09 | 2002-09-10 | International Business Machines Corporation | Intermediate user-interface definition method and system |
US6636845B2 (en) | 1999-12-02 | 2003-10-21 | International Business Machines Corporation | Generating one or more XML documents from a single SQL query |
US7117433B1 (en) | 1998-09-29 | 2006-10-03 | International Business Machines Corporation | HTML mapping substitution graphical user interface for display of elements mapped to HTML files |
JP2012194980A (en) * | 1998-04-08 | 2012-10-11 | Access Co Ltd | Wireless communication device with markup language based man-machine interface |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5263167A (en) * | 1991-11-22 | 1993-11-16 | International Business Machines Corporation | User interface for a relational database using a task object for defining search queries in response to a profile object which describes user proficiency |
US5410693A (en) * | 1994-01-26 | 1995-04-25 | Wall Data Incorporated | Method and apparatus for accessing a database |
-
1996
- 1996-10-18 AU AU73147/96A patent/AU713437B2/en not_active Ceased
- 1996-10-18 JP JP9515630A patent/JPH11514477A/en active Pending
- 1996-10-18 CA CA002235320A patent/CA2235320C/en not_active Expired - Fee Related
- 1996-10-18 EP EP96935047A patent/EP0856177A1/en not_active Withdrawn
- 1996-10-18 WO PCT/GB1996/002572 patent/WO1997015017A1/en not_active Application Discontinuation
Non-Patent Citations (3)
Title |
---|
DUNLOP A ET AL: "PROVIDING ACCESS TO A MULTIMEDIA ARCHIVE USING THE WORLD WIDE WEB AND AN OBJECT-RELATIONAL DATABASE MANAGEMENT SYSTEM", COMPUTING & CONTROL ENGINEERING JOURNAL, vol. 7, no. 5, October 1996 (1996-10-01), pages 221 - 226, XP000613675 * |
OBRACZKA K ET AL: "INTERNET RESOURCE DISCOVERY SERVICES", COMPUTER, vol. 26, no. 9, 1 September 1993 (1993-09-01), pages 8 - 22, XP000395673 * |
SINGLETON A: "WIRED ON THE WEB", BYTE, vol. 21, no. 1, 1 January 1996 (1996-01-01), pages 77/78, 80, XP000567281 * |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6069627A (en) * | 1995-11-01 | 2000-05-30 | International Business Machines Corporation | Extender user interface |
GB2325762B (en) * | 1997-03-31 | 2002-06-05 | Ibm | Programming development environments performed by computers and in particular to an extender user interface |
GB2325762A (en) * | 1997-03-31 | 1998-12-02 | Ibm | Development environment for internet-based relational databse access programs |
US6898591B1 (en) | 1997-11-05 | 2005-05-24 | Billy Gayle Moon | Method and apparatus for server responding to query to obtain information from second database wherein the server parses information to eliminate irrelevant information in updating databases |
AU753377B2 (en) * | 1997-11-05 | 2002-10-17 | Optis Wireless Technology, Llc | Method and apparatus for updating databases |
WO1999023580A1 (en) * | 1997-11-05 | 1999-05-14 | Ericsson Inc. | Method and apparatus for updating databases |
US6448981B1 (en) | 1997-12-09 | 2002-09-10 | International Business Machines Corporation | Intermediate user-interface definition method and system |
JP2012194980A (en) * | 1998-04-08 | 2012-10-11 | Access Co Ltd | Wireless communication device with markup language based man-machine interface |
US7117433B1 (en) | 1998-09-29 | 2006-10-03 | International Business Machines Corporation | HTML mapping substitution graphical user interface for display of elements mapped to HTML files |
US6636845B2 (en) | 1999-12-02 | 2003-10-21 | International Business Machines Corporation | Generating one or more XML documents from a single SQL query |
US6643633B2 (en) | 1999-12-02 | 2003-11-04 | International Business Machines Corporation | Storing fragmented XML data into a relational database by decomposing XML documents with application specific mappings |
US6721727B2 (en) | 1999-12-02 | 2004-04-13 | International Business Machines Corporation | XML documents stored as column data |
US7174327B2 (en) | 1999-12-02 | 2007-02-06 | International Business Machines Corporation | Generating one or more XML documents from a relational database using XPath data model |
Also Published As
Publication number | Publication date |
---|---|
CA2235320A1 (en) | 1997-04-24 |
JPH11514477A (en) | 1999-12-07 |
CA2235320C (en) | 2002-06-18 |
EP0856177A1 (en) | 1998-08-05 |
AU7314796A (en) | 1997-05-07 |
AU713437B2 (en) | 1999-12-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US6035298A (en) | Accessing plural independent databases having plural database schemas | |
US6401096B1 (en) | Method and apparatus for generating user profile reports using a content menu | |
US6526406B1 (en) | Database access system to deliver and store information | |
US6072491A (en) | Method and computer program product for accessing a web site | |
US7640548B1 (en) | Task based user interface | |
US5819267A (en) | Know-how management apparatus, and method | |
US7505913B2 (en) | Method and system for customizing marketing services on networks communicating with hypertext tagging conventions | |
JP3798709B2 (en) | Server, information providing method, and program | |
US6820071B1 (en) | Knowledge management system and method | |
US20020059264A1 (en) | Method and system for the display of business data from multiple sources | |
US20020103789A1 (en) | Interface and system for providing persistent contextual relevance for commerce activities in a networked environment | |
US20060036954A1 (en) | Web services based portlet catalog | |
KR100380842B1 (en) | Method and apparatus for providing network based counselling service | |
CN101208692A (en) | Automatically moving multidimensional data between live datacubes of enterprise software systems | |
WO2005041032A1 (en) | System for supporting introduction/operation of integrating job software | |
US20040210468A1 (en) | System and method for providing a territory management tool | |
US7032185B1 (en) | Graphical method and system for accessing information on a communications network | |
US20020123898A1 (en) | System and method for managing business to business customer extranet | |
AU713437B2 (en) | Accessing databases | |
WO2002027601A2 (en) | E-commerce sales support system using a vendor-specific product decision questionnaire | |
KR100424144B1 (en) | Web-based multi-dimensional information analyzing method and system | |
CN1493981A (en) | Component element guiding network page making method and its device | |
US20020109713A1 (en) | Intelligent internet site method and system | |
WO2001055937A2 (en) | Method and system for the display of business data from multiple sources | |
JP2002279109A (en) | Map-related contents providing system and method therefor |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A1 Designated state(s): AU CA JP US |
|
AL | Designated countries for regional patents |
Kind code of ref document: A1 Designated state(s): AT BE CH DE DK ES FI FR GB GR IE IT LU MC NL PT SE |
|
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
ENP | Entry into the national phase |
Ref country code: JP Ref document number: 1997 515630 Kind code of ref document: A Format of ref document f/p: F |
|
WWE | Wipo information: entry into national phase |
Ref document number: 09043644 Country of ref document: US |
|
WWE | Wipo information: entry into national phase |
Ref document number: 1996935047 Country of ref document: EP |
|
ENP | Entry into the national phase |
Ref document number: 2235320 Country of ref document: CA Ref country code: CA Ref document number: 2235320 Kind code of ref document: A Format of ref document f/p: F |
|
WWP | Wipo information: published in national office |
Ref document number: 1996935047 Country of ref document: EP |
|
WWW | Wipo information: withdrawn in national office |
Ref document number: 1996935047 Country of ref document: EP |