Techniques for automatically developing a web site

• US 8,321,457 B2
• Filed: 05/31/2001
• Issued: 11/27/2012
• Est. Priority Date: 09/08/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Tan, Dean, Sero, Pascal, Walsh, Kevin
• Primary Examiner(s): Trjillo, James
• Assistant Examiner(s): Black, Linh
• Application Number:
  US09/873,061
• Publication Number:
  US 20090043798A1
• Time in Patent Office: 4,198 Days
• Field of Search: 707 1-1041, 707/779, 707/609, 709/203, 715/501.1, 715505-508, 715/513, 715/526, 715234-237, 715/239
• US Class Current: 707/779
• CPC Class Codes: G06F 11/1446 Point-in-time backing up or restoration of persistent data
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 8/61 Installation
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: H04L 63/02 for separating internal from external traffic, e.g. firewalls

Abstract

Techniques for building a web site with database components include a web site building appliance having a processor, a computer readable medium, and a special purpose operating system. The computer-readable medium carries a web site wizard including a template and instructions. The template holds data indicating a first arrangement of components associated with a first type of web site. The instructions configure the processor for presenting a user with a series of one or more user interfaces including controls for modifying the first arrangement of components. The instructions also configure the processor for receiving input from the user in response to user interaction with the controls indicating a modified arrangement. The instructions further configure the processor for building the web site automatically in response to the input from the user. The web site is based on the modified arrangement. The special purpose operating system has features and configuration dictated by the web site wizard and supporting program components.

Claims

1. A method comprising:

storing one or more XML templates that specify a structure of a multi-page web site;

wherein the one or more XML templates collectively define;

(a) relationships between web pages of the multi-page web site, (b) contents for the web pages of the multi-page web site, and (c) database objects to create for storing data used by components of the multi-page web site;

storing XML definitions for a plurality of components that are available for use in the web site;

presenting a user with a series of one or more user interfaces for modifying the multi-page web site;

wherein the one or more user interfaces include controls for adding one or more components of said plurality of components to the multi-page web site;

receiving through the controls user input that adds a particular component of said plurality of components to said multi-page web site;

in response to the user input, adding a particular XML definition associated with the particular component to the one or more XML templates to produce a modified set of one or more XML templates that define the multi-page web site to include said particular component;

based on the modified set of one or more XML templates, generating one or more database commands instructing a database server to create at least;

a database for storing data belonging to the multi-page web site, and, within the database, a particular database object indicated by the XML definition to store data for the particular component; and

in response to one or more requests directed to the web site, generating markup language code for the web site based at least on data stored in the particular database object.

2. The method of claim 1, further comprising:

creating an extensible stylesheet language transformation (XSLT) document for forming a web page; and

generating the markup language code for the web site based in part on applying a particular XML template of the modified set of one or more XML templates to the XSLT document.

3. The method of claim 1, wherein a particular component, of the plurality of components, is dynamically generated at a different computer than a computer storing the modified set of one or more XML templates.

4. The method of claim 1, wherein a particular user interface, of the one or more user interfaces, includes a link to another web site for generating the particular component.

5. The method of claim 1, further comprising receiving, at the database that was created based on the modified set of one or more XML templates, one or more commands to update the database to store web site data that changes over time.

6. The method of claim 1, wherein the particular database object is a table.

7. The method of claim 1, wherein the particular database object is a row of a table, the row comprising information about the particular component.

8. The method of claim 1, further comprising generating the markup language code in response to a request for a particular page, the generating comprising:

determining that the particular page comprises the particular component;

determining that the particular component is provided by a particular executable service;

executing the particular executable service based at least on one or more arguments stored in the database in association with the particular component;

inserting code returned by executing the particular executable service into the particular page.

9. The method of claim 1, wherein the particular database object is a stored procedure.

10. The method of claim 1, wherein the markup language code is formatted as HyperText Markup Language (HTML).

11. The method of claim 1, wherein the particular component is a discussion forum.

12. The method of claim 1, further comprising translating one or more elements in the one or more XML templates into database statements to create or modify the database.

13. The method of claim 1, wherein the modified set of one or more templates includes a site map element that describes a hierarchy of folders, the hierarchy of folders corresponding to a hierarchy of pages for the web site.

27. The method of claim 1, further comprising receiving, at the database that was created based on the modified set of one or more XML templates, one or more commands to update the database to store web site data that differs for different users of the web site.

28. The method of claim 5, further comprising receiving, at the database that was created based on the modified set of one or more XML templates, one or more commands from the user to update the database to store one or more of:

a product or service description, a product or service price, a list of products or services, a component for searching for a product or service among the list of products, a hierarchical list of products or services within categories and subcategories, a component for searching products or services falling within a category or subcategory, support contact information, personnel lists, an item to search a personnel list, a map of the web site, links to related web sites, a calendar of appointments or events, a banner advertisement, or shopping cart data.

14. One or more non-transitory machine-readable media comprising instructions that, when executed by one or more computing devices, cause:

storing one or more XML templates that specify a structure of a multi-page web site;

wherein the one or more XML templates collectively define;

(a) relationships between web pages of the multi-page web site, (b) contents for the web pages of the multi-page web site, and (c) database objects to create for storing data used by components of the multi-page web site;

storing XML definitions for a plurality of components that are available for use in the web site;

presenting a user with a series of one or more user interfaces for modifying the multi-page web site;

wherein the one or more user interfaces include controls for adding one or more components of said plurality of components to the multi-page web site;

receiving through the controls user input that adds a particular component of said plurality of components to said multi-page web site;

in response to the user input, adding a particular XML definition associated with the particular component to the one or more XML templates to produce a modified set of one or more XML templates that define the multi-page web site to include said particular component;

based on the modified set of one or more XML templates, generating one or more database commands instructing a database server to create at least;

a database for storing data belonging to the multi-page web site, and, within the database, a particular database object indicated by the XML definition to store data for the particular component; and

in response to one or more requests directed to the web site, generating markup language code for the web site based at least on data stored in the particular database object.

15. The one or more non-transitory machine-readable media of claim 14, further comprising:

creating an extensible stylesheet language transformation (XSLT) document for forming a web page; and

generating the markup language code for the web site based in part on applying a particular XML template of the modified set of one or more XML templates to the XSLT document.

16. The one or more non-transitory machine-readable media of claim 14, wherein a particular component, of the plurality of components, is dynamically generated at a different computer than a computer storing the modified set of one or more XML templates.

17. The one or more non-transitory machine-readable media of claim 14, wherein a particular user interface, of the one or more user interfaces, includes a link to another web site for generating the particular component.

18. The one or more non-transitory machine-readable media of claim 14, wherein the instructions, when executed by the one or more computing devices, further cause receiving, at the database that was created based on the modified set of one or more XML templates, one or more commands to update the database to store web site data that changes over time.

19. The one or more non-transitory machine-readable media of claim 14, wherein the particular database object is a table.

20. The one or more non-transitory machine-readable media of claim 14, wherein the particular database object is a row of a table, the row comprising information about the particular component.

21. The one or more non-transitory machine-readable media of claim 14, wherein the instructions, when executed by the one or more computing devices, further cause generating the markup language code in response to a request for a particular page, the generating comprising:

determining that the particular page comprises the particular component;

determining that the particular component is provided by a particular executable service;

executing the particular executable service based at least on one or more arguments stored in the database in association with the particular component;

inserting code returned by executing the particular executable service into the particular page.

22. The one or more non-transitory machine-readable media of claim 14, wherein the particular database object is a stored procedure.

23. The one or more non-transitory machine-readable media of claim 14, wherein the markup language code is formatted as HyperText Markup Language (HTML).

24. The one or more non-transitory machine-readable media of claim 14, wherein the particular component is a discussion forum.

25. The one or more non-transitory machine-readable media of claim 14, wherein the instructions, when executed by the one or more computing devices, further cause translating one or more elements in the one or more XML templates into database statements to create or modify the database.

26. The one or more non-transitory machine-readable media of claim 14, wherein the modified set of one or more templates includes a site map element that describes a hierarchy of folders, the hierarchy of folders corresponding to a hierarchy of pages for the web site.

29. The one or more non-transitory machine-readable media of claim 14, wherein the instructions, when executed by the one or more computing devices, further cause receiving, at the database that was created based on the modified set of one or more XML templates, one or more commands to update the database to store web site data that differs for different users of the web site.

30. The one or more non-transitory machine-readable media of claim 18, wherein the instructions, when executed by the one or more computing devices, further cause receiving, at the database that was created based on the modified set of one or more XML templates, one or more commands from the user to update the database to store one or more of:

a product or service description, a product or service price, a list of products or services, a component for searching for a product or service among the list of products, a hierarchical list of products or services within categories and subcategories, a component for searching products or services falling within a category or subcategory, support contact information, personnel lists, an item to search a personnel list, a map of the web site, links to related web sites, a calendar of appointments or events, a banner advertisement, or shopping cart data.

31. A method comprising:

storing one or more XML templates that specify a structure of a multi-page web site;

wherein the one or more XML templates collectively define;

(a) relationships between web pages of the multi-page web site, (b) contents for the web pages of the multi-page web site, and (c) database objects to create for storing data used by components of the multi-page web site in one or more databases of a database system;

storing XML definitions for a plurality of components that are available for use in the web site;

presenting a user with a series of one or more user interfaces for modifying the multi-page web site;

wherein the one or more user interfaces include controls for adding one or more components of said plurality of components to the multi-page web site;

receiving through the controls user input that adds a particular component of said plurality of components to said multi-page web site;

in response to the user input, adding a particular XML definition associated with the particular component to the one or more XML templates to produce a modified set of one or more XML templates that define the multi-page web site to include said particular component;

based on the modified set of one or more XML templates, sending one or more database commands to a database server of the database system that instruct the database server to create at least;

a database for storing data belonging to the multi-page web site, and, within the database, a particular database object indicated by the particular XML definition to store data for the particular component, wherein the particular database object is not one of the templates from the modified set of one or more XML templates; and

in response to one or more requests directed to the web site;

sending one or more queries to the database server to cause the database server to retrieve particular data from the particular database object; and

generating markup language code for the web site based at least on the particular data that was retrieved from the particular database object.

32. One or more non-transitory machine-readable media comprising instructions that, when executed by one or more computing devices, cause:

storing one or more XML templates that specify a structure of a multi-page web site;

wherein the one or more XML templates collectively define;

(a) relationships between web pages of the multi-page web site, (b) contents for the web pages of the multi-page web site, and (c) database objects to create for storing data used by components of the multi-page web site in one or more databases of a database system;

storing XML definitions for a plurality of components that are available for use in the web site;

presenting a user with a series of one or more user interfaces for modifying the multi-page web site;

wherein the one or more user interfaces include controls for adding one or more components of said plurality of components to the multi-page web site;

receiving through the controls user input that adds a particular component of said plurality of components to said multi-page web site;

in response to the user input, adding a particular XML definition associated with the particular component to the one or more XML templates to produce a modified set of one or more XML templates that define the multi-page web site to include said particular component;

based on the modified set of one or more XML templates, sending one or more database commands to a database server of the database system that instruct the database server to create at least;

a database for storing data belonging to the multi-page web site, and, within the database, a particular database object indicated by the particular XML definition to store data for the particular component, wherein the particular database object is not one of the templates from the modified set of one or more XML templates; and

in response to one or more requests directed to the web site;

sending one or more queries to the database server to cause the database server to retrieve particular data from the particular database object; and

generating markup language code for the web site based at least on the particular data that was retrieved from the particular database object.

33. A system comprising:

a database system comprising at least a database server and a plurality of database devices storing a plurality of databases;

one or more computer-readable memories storing one or more XML templates that specify a structure of a multi-page web site and XML definitions for a plurality of components that are available for use in the web site;

wherein the one or more XML templates collectively define;

(a) relationships between web pages of the multi-page web site, (b) contents for the web pages of the multi-page web site, and (c) database objects to create for storing data used by components of the multi-page web site in one or more databases of the database system;

one or more computing devices configured to execute a server that;

presents a user with a series of one or more user interfaces for modifying the multi-page web site;

wherein the one or more user interfaces include controls for adding one or more components of said plurality of components to the multi-page web site;

receives through the controls user input that adds a particular component of said plurality of components to said multi-page web site;

in response to the user input, adds a particular XML definition associated with the particular component to the one or more XML templates to produce a modified set of one or more XML templates that define the multi-page web site to include said particular component; and

based on the modified set of one or more XML templates, sends one or more database commands to the database server of the database system that instruct the database server to create at least;

a database for storing data belonging to the multi-page web site, and, within the database, a particular database object indicated by the particular XML definition to store data for the particular component, wherein the particular database object is not one of the templates from the modified set of one or more XML templates; and

one or more computing devices configured to execute a web server that, in response to one or more requests directed to the web site;

sends one or more queries to the database server to cause the database server to retrieve particular data from the particular database object; and

generates markup language code for the web site based at least on the particular data that was retrieved from the particular database object.