Classifications

• • G—PHYSICS
  • G06—COMPUTING OR CALCULATING; 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/24—Querying
  • G06F16/248—Presentation of query results
• • G—PHYSICS
  • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
  • G06F16/9566—URL specific, e.g. using aliases, detecting broken or misspelled links
• • G—PHYSICS
  • G06—COMPUTING OR CALCULATING; COUNTING
  • G06F—ELECTRIC DIGITAL DATA PROCESSING
  • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
  • G06F3/14—Digital output to display device ; Cooperation and interconnection of the display device with other functional units
• • G—PHYSICS
  • G06—COMPUTING OR CALCULATING; COUNTING
  • G06F—ELECTRIC DIGITAL DATA PROCESSING
  • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
  • G06F3/14—Digital output to display device ; Cooperation and interconnection of the display device with other functional units
  • G06F3/147—Digital output to display device ; Cooperation and interconnection of the display device with other functional units using display panels
• • G—PHYSICS
  • G06—COMPUTING OR CALCULATING; COUNTING
  • G06F—ELECTRIC DIGITAL DATA PROCESSING
  • G06F9/00—Arrangements for program control, e.g. control units
  • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
  • G06F9/44—Arrangements for executing specific programs
  • G06F9/451—Execution arrangements for user interfaces

Definitions

• database management programs allow developers to create database applications for performing certain functions with respect to a database.
• a database application might be created that allows a user to track donations to a school or charity. Users typically access database applications such as this through the database management program (referred to herein as a “database client application program” or simply a “database client”) utilized to create the database application or a runtime version of the database client.
• database client application program referred to herein as a “database client application program” or simply a “database client”
• database client database client
• the database services URL utilized by the database application can be updated programmatically by program code executing within or under the control of the database server application program.
• a macro action may be executed for opening a form in a Web browser. Execution of the macro action will update the database services URL to properly reflect the database services URL of the opened form.
• macro actions for opening reports, showing records, displaying a form or report, browsing to a database object in-place, and for performing other functions may update the database services URL appropriately.
• selection of user interface controls provided for navigating the database application such as a navigation control, may also cause the database services URL to be updated.
• a macro action refers to macros provided by the database application. It should be appreciated that other types of executable components may also be utilized to provide similar functionality.
• a macro action is provided herein for use in conjunction with a database server application that provides functionality for displaying a database object, such as a form or report, in-place in a Web browser.
• the BrowserTo macro action the current view of a form or report can be changed while maintaining the context of the database application.
• the BrowseTo macro action takes parameters identifying a path to a sub form control, identifying a name of the database object to be displayed, and identifying the type of database object.
• parameters identifying a page of the database object that should be displayed as the current page, identifying a data mode for the database object, and for specifying a WHERE condition for a record source of the database object to be displayed by the BrowseTo macro action may also be supplied and utilized when displaying the database object in- place.
• FIGURE 2 is a user interface diagram showing aspects of a navigation control utilized in one embodiment presented herein;
• FIGURES 5-7 are flow diagrams showing various routines that illustrate aspects of embodiments presented herein for processing a request for a database services uniform resource locator, updating a database services uniform resource locator, and executing a macro action for browsing to a form or report, respectively, according to embodiments presented herein;
• FIGURE 8 is a computer architecture diagram showing an illustrative computer hardware and software architecture for a computing system capable of implementing aspects of the embodiments presented herein.
• FIGURE 1 is merely illustrative and that additional computing systems and networks not shown in FIGURE 1 may be utilized in various embodiments presented herein.
• network 118 is described herein as being a wide area network ("WAN"), such as the Internet, other types of local and WANs may also be utilized by the embodiments presented herein.
• WAN wide area network
• the client computer 102 is equipped to execute an operating system and appropriate application program software.
• the client computer 102 is configured to execute a database client application program 106.
• the database client application program 106 which may be referred to herein simply as the "database client,” comprises a database application program configured for execution on a client computer 102.
• the database client application program 106 comprises the ACCESS database client application program from MICROSOFT CORPORATION of Redmond, Washington. It should be appreciated, however, that database client application programs from other vendors might also be utilized in conjunction with the software components presented herein.
• the database client application program 106 is configured in embodiments to allow a user to create a database application 108.
• the database application 108 may be executed by the database client application program 106 or a runtime version of the database client. Through the use of the database application 108, a user of the client computer 102 can interact with a database in various ways supported by the database application 108. It should be appreciated that, in one embodiment, the database application 108 is self contained, including the actual database upon which the database application 108 operates.
• the database client application program 106 is further configured to allow a user to define a navigation form 200 as part of database application 108.
• the navigation form 200 may include a navigation control 202.
• the navigation control 202 includes selectable tabs that can each be associated with a target, such as a form 124A or a database report 124B.
• a target such as a form 124A or a database report 124B.
• the target associated with the selected tab is displayed by the database application 108 in the navigation form 200.
• Multiple navigation controls 202 may be added to the same navigation form 200.
• the database services URL 120 may also be updated following the selection of other user interface controls provided for navigating the database application 108 and in response to the execution of programmatic components by the database application 108. Details regarding this functionality will be provided below with respect to FIGURES 3-7.
• FIGURE 3 a data structure diagram illustrating aspects of a database services URL 120 provided in some embodiments will be described.
• the database services URL 120 includes an address 302A and several parameters 302B-302G.
• the address 302A is formatted with a server address and an indication that the remainder of the URL 120 is a bookmark into the requested page. This allows the URL 120 to change without the Web browser application program 110 reloading the page.
• HTTP hypertext transport protocol
• the address 302C may take the form of
• the database services URL 120 further includes a number of parameters 302B-302G.
• the parameters 302B-302G are specified in the order illustrated in FIGURE 3. It should be appreciated however, that the order of the parameters 302B-302G may be different in other embodiments and that some of the parameters may not be utilized in every request.
• the database services URL 120 includes a first parameter 302B that identifies a path to a subform control 206.
• this parameter identifies a path from a main form of the database application 108 to a target subform control 206 that loads a specified database object.
• the main form of the database application 108 is a form that is loaded directly into the browser window provided by the Web browser 110.
• the term "database object" may refer to a form 124A, a report 124B, or another type of object provided by the database application 108.
• the parameter 302B may be utilized to load subforms other than the object that is identified by the parameter 302D.
• routine 600 proceeds to operation 614, where the database services URL 120 is updated to reflect the recently opened form. If the OpenForm() macro action 122A has not been executed, the routine 600 proceeds from operation 602 to operation 604, where a determination is made as to whether the OpenReport() macro action 122B has been executed. If so, the routine 600 proceeds to operation 614, where the database services URL 120 is updated to reflect the correct path to the recently opened report. If a report has not been opened, the routine 600 proceeds from operation 604 to operation 606. [0046] At operation 606, a determination is made as to whether the GoToRecord() macro action 122C has been executed.
• FIGURE 7 shows one illustrative routine 700 illustrating the operation of the BrowseTo macro action 122D.
• the routine 700 begins at operation 702, where the subform control 206 to be updated is identified based upon a parameter supplied with the BrowseTo macro action 122D. Once the subform control 206 has been identified, the routine 700 proceeds to operation 704, where the target form 124A or report 124B is loaded into the identified subform control 206. The routine 700 then proceeds to operation 706, where the WHERE clause of the target form 124A or report 124B is set to the WHERE clause passed into the BrowseTo macro action 122D.
• FIGURE 8 shows an illustrative computer architecture for a computer 800 capable of executing the software components described herein.
• the computer 800 may comprise other types of computing devices, including hand-held computers, embedded computer systems, personal digital assistants, and other types of computing devices known to those skilled in the art. It is also contemplated that the computer 800 may not include all of the components shown in FIGURE 8, may include other components that are not explicitly shown in FIGURE 8, or may utilize an architecture completely different than that shown in FIGURE 8.

Landscapes

• Engineering & Computer Science (AREA)
• Theoretical Computer Science (AREA)
• Databases & Information Systems (AREA)
• Physics & Mathematics (AREA)
• General Engineering & Computer Science (AREA)
• General Physics & Mathematics (AREA)
• Data Mining & Analysis (AREA)
• Human Computer Interaction (AREA)
• Software Systems (AREA)
• Computational Linguistics (AREA)
• Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
• Information Transfer Between Computers (AREA)

Priority Applications (11)

Applications Claiming Priority (2)

Publications (2)

Family

ID=43125270

Family Applications (1)

Country Status (16)

Cited By (1)

Families Citing this family (7)

Family Cites Families (27)

• 2009
  • 2009-05-19 US US12/468,067 patent/US8312048B2/en not_active Expired - Fee Related
• 2010
  • 2010-05-12 MX MX2011011746A patent/MX2011011746A/es active IP Right Grant
  • 2010-05-12 JP JP2012511892A patent/JP5255156B2/ja not_active Expired - Fee Related
  • 2010-05-12 SG SG2011072188A patent/SG175049A1/en unknown
  • 2010-05-12 EP EP10778123.9A patent/EP2433224A4/en not_active Ceased
  • 2010-05-12 WO PCT/US2010/034617 patent/WO2010135121A2/en not_active Ceased
  • 2010-05-12 AU AU2010249975A patent/AU2010249975B2/en not_active Ceased
  • 2010-05-12 BR BRPI1011380-0A patent/BRPI1011380B1/pt not_active IP Right Cessation
  • 2010-05-12 KR KR1020117027374A patent/KR101629054B1/ko not_active Expired - Fee Related
  • 2010-05-12 CN CN201080022500.5A patent/CN102428460B/zh not_active Expired - Fee Related
  • 2010-05-12 RU RU2011147049/08A patent/RU2544774C2/ru active
  • 2010-05-12 CA CA2758385A patent/CA2758385C/en active Active
  • 2010-05-12 MY MYPI2011005320A patent/MY158947A/en unknown
• 2011
  • 2011-09-30 ZA ZA2011/07188A patent/ZA201107188B/en unknown
  • 2011-10-23 IL IL215752A patent/IL215752A/en active IP Right Grant
  • 2011-11-17 CL CL2011002889A patent/CL2011002889A1/es unknown

Non-Patent Citations (1)

Also Published As

Similar Documents

Legal Events