A portion of the disclosure of this patent document contains material which is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure, as it appears in the Patent and Trademark Office patent file or records, but otherwise reserves all copyright rights whatsoever.
The present disclosure relates generally to configuring the visual appearance of web documents and more specifically to techniques for generating source code for a webpage, where the source code includes containers that represent different sections of the webpage.
Modern websites are often the product of work contributed by different users with varying levels of web design expertise. For instance, a webpage may be generated by a site creator using software that provides a graphical user interface for building the page in a non-programmatic manner and without requiring the site creator to be knowledgeable about HyperText Markup Language (HTML) or other web document languages. The software may allow the site creator to configure a general color scheme that is limited in scope, e.g., a site-wide scope covering a background color and a contrast color for text rendered against the background. The software may also allow the site creator to add to the site components (e.g., radio buttons, dropdown lists, and the like) that are created by component authors who may or may not be part of the same organization as the site creator.
The included drawings are for illustrative purposes and serve only to provide examples of possible structures and process operations for the disclosed techniques. These drawings in no way limit any changes in form and detail that may be made to implementations by one skilled in the art without departing from the spirit and scope of the disclosure.
Examples of systems and methods for configuring the visual appearance of webpages are described herein with reference to certain implementations. These examples are being provided solely to add context and aid in the understanding of the present disclosure. It will thus be apparent to one skilled in the art that the techniques described herein may be practiced without some or all of these specific details. In other instances, well known process operations have not been described in detail in order to avoid unnecessarily obscuring the present disclosure. Other applications are possible, such that the following examples should not be taken as definitive or limiting either in scope or setting.
The described subject matter may be implemented in the context of any computer-implemented system, such as a software-based system, a database system, a multi-tenant environment, or the like. Moreover, the described subject matter may be implemented in connection with two or more separate and distinct computer-implemented systems that cooperate and communicate with one another. One or more examples may be implemented in numerous ways, including as a process, an apparatus, a system, a device, a method, a computer readable medium such as a computer readable storage medium containing computer readable instructions or computer program code, or as a computer program product comprising a computer usable medium having a computer readable program code embodied therein.
To make a website visually pleasing and representative of brand identity, a site creator or another user contributing to the site may desire to configure multiple color schemes for use with different portions of the website (e.g., sections of a webpage). This can be done programmatically if the user is sophisticated, but difficult to do via options available in software that is configured to permit a user to create a webpage in a non-programmatic manner. For example, What You See Is What You Get (WYSIWYG) software can provide a drag-and-drop user interface for building a website and may permit a user to specify a general color scheme for the entire website. Because the color scheme is applied across the entire website, each webpage within the website will have the same color scheme, for example, the same color background and the same color text. Using a single color scheme can make a website difficult to read if the colors selected have poor contrast, adversely impacting end-user accessibility.
Additionally, it is desirable to have site components share the same color schemes as the site without relying on component authors to set the colors. Site components may include plugin components that can be placed onto webpages, e.g., by dropping the site components into a section of a webpage, using WYSIWGY software. In some implementations, site components are configured to automatically consume the color scheme of the section in which they appear. In this manner, a component author need not specify the colors for the component that they are creating but can instead leave the choice of colors to the site creator.
In some implementations, a set of predefined color schemes are made available in software to a site creator or other user creating a webpage. The color schemes can be generated by another user and may, for example, be defined programmatically by a user with a higher level of web design expertise than the site creator. Alternatively, the software operated by the site creator may provide an option to create a custom color scheme. Once the color schemes have been defined, the site creator can be provided with access to the color schemes and an option to choose a color scheme for use with a particular section of a webpage. Based on the site creator's choices, a computer system with a compiling engine can generate source code that reflects the colors schemes which have been assigned to different sections. The source code includes scoped containers and Cascading Style Sheets (CSS) custom properties that define the various color attributes for the scope containers. Because each container has a specific scope, the color scheme(s) assigned are applied uniformly across every element included in the corresponding section of the webpage. Additionally, containers can be nested so that a child container has a different color scheme than its parent container but may at the same time inherit one or more visual attributes of its parent such as a background color or foreground color.
The disclosed implementations may include a method for generating scoped containers. The method involves providing, by a computer system, access to a first color scheme and a second color scheme through a user interface of a software application. The first color scheme and the second color scheme each include a foreground color paired with a background color that contrasts the foreground color. At least one of the foreground color of the first color scheme or the background color of the first color scheme differs from that of the second color scheme. The method further involves assigning, by the computer system, the first color scheme to a first section of a webpage based on input at the user interface; and assigning, by the computer system, the second color scheme to a second section of the webpage based on further input at the user interface. The method further involves generating, by the computer system after the assigning of the first color scheme and the second color scheme, source code representing the webpage. The source code includes a first container corresponding to the first section and a second container corresponding to the second section. Due to the first container being separate from the second container, a scope of the first container includes the first color scheme applied to one or more elements within the first section, and a scope of the second container includes the second color scheme applied to one or more elements within the second section.
The disclosed implementations may include a system that includes one or more processors and memory storing instructions that, when executed, cause the one or more processors to provide access to a first color scheme and a second color scheme through a user interface of a software application. The first color scheme and the second color scheme each include a foreground color paired with a background color that contrasts the foreground color. At least one of the foreground color of the first color scheme or the background color of the first color scheme differs from that of the second color scheme. The instructions further cause the one or more processors to assign the first color scheme to a first section of a webpage based on input at the user interface; and assign the second color scheme to a second section of the webpage based on further input at the user interface. The instructions further cause the one or more processors to generate, after the assigning of the first color scheme and the second color scheme, source code representing the webpage. The source code includes a first container corresponding to the first section and a second container corresponding to the second section. Due to the first container being separate from the second container, a scope of the first container includes the first color scheme applied to one or more elements within the first section, and a scope of the second container includes the second color scheme applied to one or more elements within the second section.
The disclosed implementations may include a non-transitory computer-readable medium storing program code, the program code including instructions that are executable by one or more processors of a computer system to perform any of the methods disclosed herein.
Any of the above implementations may be used alone or together with one another in any combination. The one or more implementations encompassed within this specification may also include examples that are only partially mentioned or alluded to or are not mentioned or alluded to at all in this brief summary or in the abstract. Although various implementations may have been motivated by various deficiencies with the prior art, which may be discussed or alluded to in one or more places in the specification, the implementations do not necessarily address any of these deficiencies. In other words, different implementations may address different deficiencies that may be discussed in the specification. Some implementations may only partially address some deficiencies or just one deficiency that may be discussed in the specification, and some implementations may not address any of these deficiencies.
Computer system 110 may be configured to provide a web development platform through which computing resources are made available to users (e.g., site creators 102 and 104) for building a webpage such as webpage 112. In this respect, users of the computer system 110 may include users associated with an organization that is a customer of an organization operating the computer system 110. As shown in
Source code 177 can be generating using metadata 119 describing a configuration of the webpage 112. The metadata 119 describes the various attributes of the webpage 112, for instance, page layout, the contents of each section of the webpage (e.g., text, images, plugin components, and/or other elements), text size, text color, background color, and other visual attributes. In some implementations, compiling engine 116 may include one or more processing units configured to convert the metadata 119 into the source code 117, e.g., based on execution of a compiler program. As part of generating the source code 117, the compiling engine 116 may generate a set of scoped containers, where each container includes a list of attributes and their corresponding values. In some instances, a container includes CSS custom properties that define colors that have been assigned to the section represented by the container for use by elements (e.g., text, images, or components from component authors) of the section.
Computer system 110 can be a cloud-based computer system and, in some implementations, may support execution of software applications deployed using a Platform as a Service (PaaS) or through Software as a Service (SaaS). Platform as a service (PaaS) is a category of cloud computing services that provides a platform allowing developers and companies to develop, deploy and manage applications without the complexity of building and maintaining the infrastructure typically required to support such applications. SaaS is a software licensing and delivery model in which software applications are centrally hosted and accessed through a client application (e.g., a web browser or other thin client) by remote users.
Computing environment 100 is an example of a distributed computing environment in which tasks are performed by remote processing devices that are linked through a communications network (e.g., one or more networks 124). In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices. For instance, program code may be stored and executed locally on one or more user computer systems 120 and/or on computer system 110. In the case of a cloud-based computer system 110, program code may be executed on the computer system 110 in response to input from a client application executed on a user computer system 120.
Network(s) 124 can include one or more communications networks that couple user computer systems 120A, 120B, and 120C to the computer system 110. Although shown separately from the network 122, the networks 122 and 124 may overlap and, in some instances, may be the same network, e.g., the Internet. In addition as an alternative to the Internet, network(s) 124 can include another public network, a private network such as a Local Area Network (LAN), a Wide Area Network (WAN), and/or other types of communications networks.
User computer system 120A may be configured to generate a graphical user interface through which the site creator 102 can design the webpage 112. The graphical user interface may be provided by a WYSIWYG application executed locally on the user computer system 120A. In some implementations, the application providing the graphical user interface may be a cloud application executed on the computer system 110. The site creator 102 may be a user with a lower level of web design expertise than the site creator 104. As such, the site creator 102 may not have the ability or desire to configure the webpage 112 programmatically. Instead, the site creator 102 may choose to build the webpage 112 by choosing from a limited set of options for page configuration, for example, a set of templates that define possible column layouts. The options are provided through the graphical user interface and can include an option to associate a color scheme with a user-selected section of the webpage 112. Colors schemes can be configured by another user, e.g., by the site creator 104. However, the application providing the graphical user interface may also provide an option for the site creator 102 to specify a custom color scheme. Based on the configuration performed by the site creator 102, the user computer system 120B may generate site configuration information 140 for communication to computer system 110. The site configuration information 140 can include, as part of the metadata 119, data describing the layout of the webpage 112 and the elements in each section of the webpage 112, including metadata describing visual attributes of each section.
User computer system 120B may be configured to execute an application that permits the site creator 104 to define one or more color schemes for use with the webpage 112. This application can be same application that provides the graphical user interface to the site creator 102. Alternatively, the application used by the site creator 104 may be a separate application with a different user interface that presents a metadata or source code view of the webpage 112. As indicated above, the site creator 104 may have a higher level of web design expertise than the site creator 102. Accordingly, the site creator 104 may define color schemes programmatically. The color schemes defined by the site creator 104 can be encoded as property sets 130 that form part of the metadata 119 communicated to the computer system 110. A property set (also referred to herein as a “branding set”) includes one or more color combinations. The color combinations are typically expressed as color pairs, for example, a background color paired with a foreground color that contrasts the background color. Thus, each property set may include one or more color pairings. When applied to a section of the webpage 112, a branding set will define the visual appearance of any elements appearing within that section, subject to the scope of the container representing the section. The property sets 130 can be maintained by the computer system 110 (e.g., stored in memory 114) and are made available to the site creator 102 via the user computer system 120B and/or available to the site creator 104 via the user computer system 120A.
User computer system 120C is operated by the component author 106 to create one or more site components 160 for possible inclusion in the webpage 112. A webpage can include different types of interactive or non-interactive components (e.g., radio or other buttons, checkboxes, progress indicators, tables, and the like) that are created by component authors and incorporated into a webpage by site creators or other users tasked with building the webpage. Although only one component author is shown, the webpage 112 may be a result of contributions from multiple component authors. Component authors can include first-party authors who are users associated with the computer system 110, second-party authors who are users external to the organization associated with the computer system 110 (e.g., a vendor company contracted to design a particular component), and third-party authors associated with an organization that owns the webpage 112 (e.g., the organization to which the site creators 102 and 104 belong).
As part of creating a component 160, the component author 106 may configure the visual appearance of the component, e.g., the size and shape of a button. However, in order to have a consistent look and feel across webpage 112, it may not always be desirable for the component author 106 to specify the color(s) of the component 160. Instead, the component 160 may be configured to consume the color scheme of the section in which the component appears. For instance, the component 160 may reference CSS custom properties specified for whichever container the component is put into, thereby adopting the same color scheme as another element in the same container. Thus, the component author 106 could specify that the component 160 has a first color in a first (e.g., default) state and a second color in a second state (e.g., on-click or hover) but without specifying which colors to use as the first color and the second color.
In
In addition to color schemes 222, a property set 220 may include one or more derived color schemes 224, which are system-generated color schemes derived from color schemes 222. For example, computer system 110 may be configured to generate a derived color scheme 224A based on one or more colors specified in the color scheme 222A. Similarly, computer system 110 may generate a derived color scheme 224B based on one or more colors specified in the color scheme 222B. The derived color schemes 224A and 224B may correspond to colors used during certain situations that are likely to occur as part of viewing and interacting with a webpage. For example, each of the property sets 220 may include one or more system-generated color pairings for each of the following color categories:
To generate a derived color scheme 224, the computer system 110 may select from a set of colors and determine an appropriate shade of the selected color based on the shade of a color in a color scheme 222. In some instances, the colors that can be chosen are a subset of all possible colors, e.g., destructive colors may be limited to being red paired with white. Thus, computer system 110 may select a shade of red as a background color of a first color pair in a destructive color scheme and to achieve a sufficient level of contrast (e.g., a threshold contrast ratio) with the background color of the color scheme 222A. Further, the computer system 110 can vary the shade of red for use as a background color of a second color pair in the destructive color scheme (e.g., a darker red background paired with a white foreground). Another option is to invert the foreground and background colors to define yet another color pairing (e.g., a white background paired with a red foreground). Accordingly, a button used to communicate a warning might be a red button that includes white text and/or includes a white image (e.g., a stop icon or X mark), whereas a mandatory input field for which an end-user initially supplied an invalid value might be a white box with a red border and the words “you must complete this field” in red. In this manner, each property set 220 can be configured with its own set of system-generated colors that supplement the user-configured colors of the property set.
Metadata 200 may further include metadata representations of scoped containers 230 in the source code 117. Each metadata container 210 includes data describing a corresponding scoped container 230. For instance, a metadata container 210 can include, among other things, data indicating CSS custom properties that determine the color scheme for a corresponding scoped container 230. Additionally, metadata 200 may include other metadata 240 describing a web site, for example, metadata describing a column layout of the webpage 112, what components or other web elements are included in each section of the webpage 112, an order in which sections or elements within a section are arranged, and so on.
Source code 117 corresponds to metadata 200 after undergoing a compilation process (e.g., by the compiling engine 116). Source code 117 can be parsed by a web browser or other application configured to display webpages and can include, in addition to the scoped containers 230, JavaScript 232 and HTML code 234. JavaScript 232 includes JavaScript code that defines the interactive behavior for one or more elements of a website. For instance, the JavaScript 232 may include code defining the on-click behavior of a component 160 included in the webpage 112. The HTML code 234 may include one or more HTML documents for various parts of the website including webpage 112. The HTML code 234 may reference the scoped containers 230. In some implementations, the scoped containers 230 may be integrated into the HTML code 234.
Scope 2 includes a black root paired with a white root contrast. Since the root color relationship is the inverse of the root pairing in Scope 1, the background of the second container 320 contrasts the background of the first container 310. Additionally, Scope 2 includes a pale blue accent paired with a black accent contrast. Scope 3 includes a pink root paired with a green root contrast, and a purple accent paired with a white accent contrast.
The right side of
From the example of
Although described with respect to color, inheritance between parent and child containers can occur with other types of visual attributes, e.g., text size or font. Any visual attribute that has been specified for a parent container can be inherited by a child container when no corresponding visual attribute has been specified for the child container.
Color menu 410 includes a list of configurable colors. For example,
For each configurable color, the color menu 410 may display an option to configure the color and a color swatch 422 of what the color looks like when displayed on a webpage. For instance, the color menu 410 can include an option 420 to configure the background color and a color swatch 422A to display the color currently set for the background. Color menu 410 can include similar options 430, 440, and 450 for the text color, accent color, and accent contrast color, respectively, together with corresponding color swatches 422B, 422C, and 422D.
User interface 400 may further include a section menu 460 for configuring a selected section of a webpage. The section menu 460 includes an option 470 (e.g., a dropdown list) to select a color scheme from among a set of predefined (i.e., existing) color schemes for associating with the selected section. For instance, option 470 may be configured to permit the user to associate one of the property sets 220 in
Section menu 460 may include one or more options to configure a layout of the selected section of the webpage. For instance, section menu 460 can include an option 480 to choose from among a set of predefined column layouts (e.g., single column, two columns, three uniform columns, three non-uniform columns, and so on). Further, section menu 460 can include an option 490 to configure column distribution. For example, if the user selects a two-column layout through the option 480, a window of the option 490 may refresh to show a visual representation of each of the two columns, together with an indication of the relative widths of the columns and slider bars or other interactive controls for adjusting column width.
CSS code 810 can be generated as a result of processing metadata such as the metadata 800 through a compiling engine. In the example of
At 902, the computer system provides access to multiple predefined color schemes including a first color scheme and a second color scheme. The multiple color schemes can include user-configured color schemes (e.g., created using the user interface 400 of
Providing access to a color scheme may involve outputting an indicating of available color schemes (e.g., a list of color schemes/property sets saved in the memory 114). The indication can be output through a user interface of a software application executed on or accessed via a user computer system (e.g., option 470 of the user interface 400). Providing access to a color scheme may further involve granting a user of the software application permission to associate an available color scheme with a section of a webpage selected by the user. In some implementations, the granting of permission may be based on a role of the user and/or an identity of the user, with different users or user roles having access to different color schemes. For example, an administrative user may have access to all color schemes/property sets stored in the memory 114, whereas a non-administrative user may only have access to a subset of color schemes/property sets.
Each color scheme includes at least one color pairing (e.g., a foreground color paired with a background color). In the case of the first color scheme and the second color scheme in 902, the foreground colors and/or the background colors may differ between the first color scheme and the second color scheme.
At 904, the computer system assigns the first color scheme to a first section of a webpage and the second color scheme to a second section of the webpage, based on input at the user interface. For instance, the assigning in 904 may be in response to the user choosing the first color scheme while working on the first section and then choosing the second color scheme while working on the second section. As part of assigning the first color scheme and the second color scheme, the computer system may generate or collect from the user computer system metadata describing the first section and the second section, including metadata that references the first color scheme and the second color scheme in connection with their corresponding sections.
At 906, the computer system generates source code representing the webpage. The generating of the source code may involve converting the metadata from 904 into containers that include CSS custom properties. Depending on the how the first section and the second section are arranged on the webpage, a first container corresponding to the first section and a second container corresponding to the second section may or may not be nested. If the containers are nested, the generating of the source code may involve configuring a child container (e.g., the second container) to inherit one or more colors that are specified in a parent container (e.g., the first container) but not specified in the child container. Alternatively or additionally, the generating of the scope code may involve configuring a child container to override a color specified in its parent container using the color scheme of the child container. Irrespective of whether the containers are nested, each container will have a specific scope that encompasses the color scheme assigned to its corresponding section. Because the first container and the second container are separate, a scope of the first container will include the first color scheme applied to one or more elements within the first section, and a scope of the second container will include the second color scheme applied to one or more elements within the second section.
At 908, the computer system publishes the webpage, making the webpage accessible to one or more end-users. For instance, publishing may involve uploading a copy of the source code to one or more servers that are accessible via the Internet.
As shown in
Moreover, one or more of the devices in the on-demand service environment 1000 may be implemented on the same physical device or on different hardware. Some devices may be implemented using hardware or a combination of hardware and software. Thus, terms such as “data processing apparatus,” “machine,” “server” and “device” as used herein are not limited to a single hardware device, but rather include any hardware and software configured to provide the described functionality.
The cloud 1004 is intended to refer to a data network or plurality of data networks, often including the Internet. Client machines located in the cloud 1004 may communicate with the on-demand service environment to access services provided by the on-demand service environment. For example, client machines may access the on-demand service environment to retrieve, store, edit, and/or process information.
In some implementations, the edge routers 1008 and 1012 route packets between the cloud 1004 and other components of the on-demand service environment 1000. The edge routers 1008 and 1012 may employ the Border Gateway Protocol (BGP). The BGP is the core routing protocol of the Internet. The edge routers 1008 and 1012 may maintain a table of IP networks or ‘prefixes’ which designate network reachability among autonomous systems on the Internet.
In one or more implementations, the firewall 1016 may protect the inner components of the on-demand service environment 1000 from Internet traffic. The firewall 1016 may block, permit, or deny access to the inner components of the on-demand service environment 1000 based upon a set of rules and other criteria. The firewall 1016 may act as one or more of a packet filter, an application gateway, a stateful filter, a proxy server, or any other type of firewall.
In some implementations, the core switches 1020 and 1024 are high-capacity switches that transfer packets within the on-demand service environment 1000. The core switches 1020 and 1024 may be configured as network bridges that quickly route data between different components within the on-demand service environment. In some implementations, the use of two or more core switches 1020 and 1024 may provide redundancy and/or reduced latency.
In some implementations, the pods 1040 and 1044 may perform the core data processing and service functions provided by the on-demand service environment. Each pod may include various types of hardware and/or software computing resources. An example of the pod architecture is discussed in greater detail with reference to
In some implementations, communication between the pods 1040 and 1044 may be conducted via the pod switches 1032 and 1036. The pod switches 1032 and 1036 may facilitate communication between the pods 1040 and 1044 and client machines located in the cloud 1004, for example via core switches 1020 and 1024. Also, the pod switches 1032 and 1036 may facilitate communication between the pods 1040 and 1044 and the database storage 1056.
In some implementations, the load balancer 1028 may distribute workload between the pods 1040 and 1044. Balancing the on-demand service requests between the pods may assist in improving the use of resources, increasing throughput, reducing response times, and/or reducing overhead. The load balancer 1028 may include multilayer switches to analyze and forward traffic.
In some implementations, access to the database storage 1056 may be guarded by a database firewall 1048. The database firewall 1048 may act as a computer application firewall operating at the database application layer of a protocol stack. The database firewall 1048 may protect the database storage 1056 from application attacks such as structure query language (SQL) injection, database rootkits, and unauthorized information disclosure.
In some implementations, the database firewall 1048 may include a host using one or more forms of reverse proxy services to proxy traffic before passing it to a gateway router. The database firewall 1048 may inspect the contents of database traffic and block certain content or database requests. The database firewall 1048 may work on the SQL application level atop the TCP/IP stack, managing applications' connection to the database or SQL management interfaces as well as intercepting and enforcing packets traveling to or from a database network or application interface.
In some implementations, communication with the database storage system 1056 may be conducted via the database switch 1052. The multi-tenant database system 1056 may include more than one hardware and/or software components for handling database queries. Accordingly, the database switch 1052 may direct database queries transmitted by other components of the on-demand service environment (e.g., the pods 1040 and 1044) to the correct components within the database storage system 1056. In some implementations, the database storage system 1056 is an on-demand database system shared by many different organizations. The on-demand database system may employ a multi-tenant approach, a virtualized approach, or any other type of database approach. An on-demand database system is discussed in greater detail with reference to
In some implementations, the application servers 1088 may include a hardware and/or software framework dedicated to the execution of procedures (e.g., programs, routines, scripts) for supporting the construction of applications provided by the on-demand service environment 1000 via the pod 1044. Some such procedures may include operations for providing the services described herein. The content batch servers 1064 may handle requests internal to the pod. These requests may be long-running and/or not tied to a particular customer. For example, the content batch servers 1064 may handle requests related to log mining, cleanup work, and maintenance tasks.
The content search servers 1068 may provide query and indexer functions. For example, the functions provided by the content search servers 1068 may allow users to search through content stored in the on-demand service environment. The Fileforce servers 1086 may manage requests for information stored in the Fileforce storage 1098. The Fileforce storage 1098 may store information such as documents, images, and basic large objects (BLOBs). By managing requests for information using the Fileforce servers 1086, the image footprint on the database may be reduced.
The query servers 1082 may be used to retrieve information from one or more file systems. For example, the query system 872 may receive requests for information from the app servers 1088 and then transmit information queries to network file systems (NFS) 1096 located outside the pod. The pod 1044 may share a database instance 1090 configured as a multi-tenant environment in which different organizations share access to the same database. Additionally, services rendered by the pod 1044 may require various hardware and/or software resources. In some implementations, the ACS servers 1080 may control access to data, hardware resources, or software resources.
In some implementations, the batch servers 1084 may process batch jobs, which are used to run tasks at specified times. Thus, the batch servers 1084 may transmit instructions to other servers, such as the app servers 1088, to trigger the batch jobs. For some implementations, the QFS 1092 may be an open source file system available from Sun Microsystems® of Santa Clara, Calif. The QFS may serve as a rapid-access file system for storing and accessing information available within the pod 1044. The QFS 1092 may support some volume management capabilities, allowing many disks to be grouped together into a file system. File system metadata can be kept on a separate set of disks, which may be useful for streaming applications where long disk seeks cannot be tolerated. Thus, the QFS system may communicate with one or more content search servers 1068 and/or indexers 1094 to identify, retrieve, move, and/or update data stored in the NFS 1096 and/or other storage systems.
In some implementations, one or more query servers 1082 may communicate with the NFS 1096 to retrieve and/or update information stored outside of the pod 1044. The NFS 1096 may allow servers located in the pod 1044 to access information to access files over a network in a manner similar to how local storage is accessed. In some implementations, queries from the query servers 1082 may be transmitted to the NFS 1096 via the load balancer 1028, which may distribute resource requests over various resources available in the on-demand service environment. The NFS 1096 may also communicate with the QFS 1092 to update the information stored on the NFS 1096 and/or to provide information to the QFS 1092 for use by servers located within the pod 1044.
In some implementations, the pod may include one or more database instances 1090. The database instance 1090 may transmit information to the QFS 1092. When information is transmitted to the QFS, it may be available for use by servers within the pod 1044 without requiring an additional database call. In some implementations, database information may be transmitted to the indexer 1094. Indexer 1094 may provide an index of information available in the database 1090 and/or QFS 1092. The index information may be provided to Fileforce servers 1086 and/or the QFS 1092.
An on-demand database service, such as system 1116, is a database system that is made available to outside users that do not need to necessarily be concerned with building and/or maintaining the database system, but instead may be available for their use when the users need the database system (e.g., on the demand of the users). Some on-demand database services may store information from one or more tenants stored into tables of a common database image to form a multi-tenant database system (MTS). Accordingly, “on-demand database service 1116” and “system 1116” will be used interchangeably herein. A database image may include one or more database objects. A relational database management system (RDBMS) or the equivalent may execute storage and retrieval of information against the database object(s). Application platform 1118 may be a framework that allows the applications of system 1116 to run, such as the hardware and/or software, e.g., the operating system. In an implementation, on-demand database service 1116 may include an application platform 1118 that enables creation, managing and executing one or more applications developed by the provider of the on-demand database service, users accessing the on-demand database service via user systems 1112, or third party application developers accessing the on-demand database service via user systems 1112.
One arrangement for elements of system 1116 is shown in
The users of user systems 1112 may differ in their respective capacities, and the capacity of a particular user system 1112 might be entirely determined by permissions (permission levels) for the current user. For example, where a call center agent is using a particular user system 1112 to interact with system 1116, the user system 1112 has the capacities allotted to that call center agent. However, while an administrator is using that user system to interact with system 1116, that user system has the capacities allotted to that administrator. In systems with a hierarchical role model, users at one permission level may have access to applications, data, and database information accessible by a lower permission level user, but may not have access to certain applications, database information, and data accessible by a user at a higher permission level. Thus, different users may have different capabilities with regard to accessing and modifying application and database information, depending on a user's security or permission level.
Network 1114 is any network or combination of networks of devices that communicate with one another. For example, network 1114 can be any one or any combination of a LAN (local area network), WAN (wide area network), telephone network, wireless network, point-to-point network, star network, token ring network, hub network, or other appropriate configuration. As the most common type of computer network in current use is a TCP/IP (Transfer Control Protocol and Internet Protocol) network (e.g., the Internet), that network will be used in many of the examples herein. However, it should be understood that the networks used in some implementations are not so limited, although TCP/IP is a frequently implemented protocol.
User systems 1112 might communicate with system 1116 using TCP/IP and, at a higher network level, use other common Internet protocols to communicate, such as HTTP, FTP, AFS, WAP, etc. In an example where HTTP is used, user system 1112 might include an HTTP client commonly referred to as a “browser” for sending and receiving HTTP messages to and from an HTTP server at system 1116. Such an HTTP server might be implemented as the sole network interface between system 1116 and network 1114, but other techniques might be used as well or instead. In some implementations, the interface between system 1116 and network 1114 includes load sharing functionality, such as round-robin HTTP request distributors to balance loads and distribute incoming HTTP requests evenly over a plurality of servers. At least as for the users that are accessing that server, each of the plurality of servers has access to the MTS' data; however, other alternative configurations may be used instead.
In some implementations, system 1116, shown in
Each user system 1112 could include a desktop personal computer, workstation, laptop, PDA, cell phone, or any wireless access protocol (WAP) enabled device or any other computing system capable of interfacing directly or indirectly to the Internet or other network connection. User system 1112 typically runs an HTTP client, e.g., a browsing program, such as Microsoft's Internet Explorer® browser, Mozilla's Firefox® browser, Opera's browser, or a WAP-enabled browser in the case of a cell phone, PDA or other wireless device, or the like, allowing a user (e.g., subscriber of the multi-tenant database system) of user system 1112 to access, process and view information, pages and applications available to it from system 1116 over network 1114.
Each user system 1112 also typically includes one or more user interface devices, such as a keyboard, a mouse, trackball, touch pad, touch screen, pen or the like, for interacting with a graphical user interface (GUI) provided by the browser on a display (e.g., a monitor screen, LCD display, etc.) in conjunction with pages, forms, applications and other information provided by system 1116 or other systems or servers. For example, the user interface device can be used to access data and applications hosted by system 1116, and to perform searches on stored data, and otherwise allow a user to interact with various GUI pages that may be presented to a user. As discussed above, implementations are suitable for use with the Internet, which refers to a specific global internetwork of networks. However, it should be understood that other networks can be used instead of the Internet, such as an intranet, an extranet, a virtual private network (VPN), a non-TCP/IP based network, any LAN or WAN or the like.
According to some implementations, each user system 1112 and all of its components are operator configurable using applications, such as a browser, including computer code run using a central processing unit such as an Intel Pentium® processor or the like. Similarly, system 1116 (and additional instances of an MTS, where more than one is present) and all of their components might be operator configurable using application(s) including computer code to run using a central processing unit such as processor system 1117, which may include an Intel Pentium® processor or the like, and/or multiple processor units.
A computer program product implementation includes a machine-readable storage medium (media) having instructions stored thereon/in which can be used to program a computer to perform any of the processes of the implementations described herein. Computer code for operating and configuring system 1116 to intercommunicate and to process webpages, applications and other data and media content as described herein are preferably downloaded and stored on a hard disk, but the entire program code, or portions thereof, may also be stored in any other volatile or non-volatile memory medium or device, such as a ROM or RAM, or provided on any media capable of storing program code, such as any type of rotating media including floppy disks, optical discs, digital versatile disk (DVD), compact disk (CD), microdrive, and magneto-optical disks, and magnetic or optical cards, nanosystems (including molecular memory ICs), or any type of media or device suitable for storing instructions and/or data. Additionally, the entire program code, or portions thereof, may be transmitted and downloaded from a software source over a transmission medium, e.g., over the Internet, or from another server, or transmitted over any other conventional network connection (e.g., extranet, VPN, LAN, etc.) using any communication medium and protocols (e.g., TCP/IP, HTTP, HTTPS, Ethernet, etc.). It will also be appreciated that computer code for carrying out disclosed operations can be implemented in any programming language that can be executed on a client system and/or server or server system such as, for example, C, C++, HTML, any other markup language, Java™, JavaScript®, ActiveX®, any other scripting language, such as VBScript, and many other programming languages as are well known may be used. (Java™ is a trademark of Sun Microsystems®, Inc.).
According to some implementations, each system 1116 is configured to provide webpages, forms, applications, data and media content to user (client) systems 1112 to support the access by user systems 1112 as tenants of system 1116. As such, system 1116 provides security mechanisms to keep each tenant's data separate unless the data is shared. If more than one MTS is used, they may be located in close proximity to one another (e.g., in a server farm located in a single building or campus), or they may be distributed at locations remote from one another (e.g., one or more servers located in city A and one or more servers located in city B). As used herein, each MTS could include logically and/or physically connected servers distributed locally or across one or more geographic locations. Additionally, the term “server” is meant to include a computing system, including processing hardware and process space(s), and an associated storage system and database application (e.g., OODBMS or RDBMS) as is well known in the art.
It should also be understood that “server system” and “server” are often used interchangeably herein. Similarly, the database object described herein can be implemented as single databases, a distributed database, a collection of distributed databases, a database with redundant online or offline backups or other redundancies, etc., and might include a distributed database or storage network and associated processing intelligence.
User system 1112, network 1114, system 1116, tenant data storage 1122, and system data storage 1124 were discussed above in
Application platform 1118 includes an application setup mechanism 1238 that supports application developers' creation and management of applications, which may be saved as metadata into tenant data storage 1122 by save routines 1236 for execution by subscribers as tenant process spaces 1204 managed by tenant management process 1210 for example. Invocations to such applications may be coded using PL/SOQL 1234 that provides a programming language style interface extension to API 1232. A detailed description of some PL/SOQL language implementations is discussed in commonly assigned U.S. Pat. No. 7,730,478, titled METHOD AND SYSTEM FOR ALLOWING ACCESS TO DEVELOPED APPLICATIONS VIA A MULTI-TENANT ON-DEMAND DATABASE SERVICE, by Craig Weissman, filed Sep. 21, 2007, which is hereby incorporated by reference in its entirety and for all purposes. Invocations to applications may be detected by system processes, which manage retrieving application metadata 1216 for the subscriber making the invocation and executing the metadata as an application in a virtual machine.
Each application server 1200 may be communicably coupled to database systems, e.g., having access to system data 1125 and tenant data 1123, via a different network connection. For example, one application server 1200 might be coupled via the network 1114 (e.g., the Internet), another application server 1200 might be coupled via a direct network link, and another application server 1200 might be coupled by yet a different network connection. Transfer Control Protocol and Internet Protocol (TCP/IP) are typical protocols for communicating between application servers 1200 and the database system. However, other transport protocols may be used to optimize the system depending on the network interconnect used.
In certain implementations, each application server 1200 is configured to handle requests for any user associated with any organization that is a tenant. Because it is desirable to be able to add and remove application servers from the server pool at any time for any reason, there is preferably no server affinity for a user and/or organization to a specific application server 1200. In some implementations, therefore, an interface system implementing a load balancing function (e.g., an F5 Big-IP load balancer) is communicably coupled between the application servers 1200 and the user systems 1112 to distribute requests to the application servers 1200. In some implementations, the load balancer uses a least connections algorithm to route user requests to the application servers 1200. Other examples of load balancing algorithms, such as round robin and observed response time, also can be used. For example, in certain implementations, three consecutive requests from the same user could hit three different application servers 1200, and three requests from different users could hit the same application server 1200. In this manner, system 1116 is multi-tenant, wherein system 1116 handles storage of, and access to, different objects, data and applications across disparate users and organizations.
As an example of storage, one tenant might be a company that employs a sales force where each call center agent uses system 1116 to manage their sales process. Thus, a user might maintain contact data, leads data, customer follow-up data, performance data, goals and progress data, etc., all applicable to that user's personal sales process (e.g., in tenant data storage 1122). In an example of a MTS arrangement, since all of the data and the applications to access, view, modify, report, transmit, calculate, etc., can be maintained and accessed by a user system having nothing more than network access, the user can manage his or her sales efforts and cycles from any of many different user systems. For example, if a call center agent is visiting a customer and the customer has Internet access in their lobby, the call center agent can obtain critical updates as to that customer while waiting for the customer to arrive in the lobby.
While each user's data might be separate from other users' data regardless of the employers of each user, some data might be organization-wide data shared or accessible by a plurality of users or all of the users for a given organization that is a tenant. Thus, there might be some data structures managed by system 1116 that are allocated at the tenant level while other data structures might be managed at the user level. Because an MTS might support multiple tenants including possible competitors, the MTS should have security protocols that keep data, applications, and application use separate. Also, because many tenants may opt for access to an MTS rather than maintain their own system, redundancy, up-time, and backup are additional functions that may be implemented in the MTS. In addition to user-specific data and tenant specific data, system 1116 might also maintain system level data usable by multiple tenants or other data. Such system level data might include industry reports, news, postings, and the like that are sharable among tenants.
In certain implementations, user systems 1112 (which may be client machines/systems) communicate with application servers 1200 to request and update system-level and tenant-level data from system 1116 that may require sending one or more queries to tenant data storage 1122 and/or system data storage 1124. System 1116 (e.g., an application server 1200 in system 1116) automatically generates one or more SQL statements (e.g., SQL queries) that are designed to access the desired information. System data storage 1124 may generate query plans to access the requested data from the database.
Each database can generally be viewed as a collection of objects, such as a set of logical tables, containing data fitted into predefined categories. A “table” is one representation of a data object and may be used herein to simplify the conceptual description of objects and custom objects according to some implementations. It should be understood that “table” and “object” may be used interchangeably herein. Each table generally contains one or more data categories logically arranged as columns or fields in a viewable schema. Each row or record of a table contains an instance of data for each category defined by the fields. For example, a CRM database may include a table that describes a customer with fields for basic contact information such as name, address, phone number, fax number, etc. Another table might describe a purchase order, including fields for information such as customer, product, sale price, date, etc. In some multi-tenant database systems, standard entity tables might be provided for use by all tenants. For CRM database applications, such standard entities might include tables for account, contact, lead, and opportunity data, each containing pre-defined fields. It should be understood that the word “entity” may also be used interchangeably herein with “object” and “table”.
In some multi-tenant database systems, tenants may be allowed to create and store custom objects, or they may be allowed to customize standard entities or objects, for example by creating custom fields for standard objects, including custom index fields. U.S. Pat. No. 7,779,039, titled CUSTOM ENTITIES AND FIELDS IN A MULTI-TENANT DATABASE SYSTEM, by Weissman, et al., and which is hereby incorporated by reference in its entirety and for all purposes, teaches systems and methods for creating custom objects as well as customizing standard objects in a multi-tenant database system. In some implementations, for example, all custom entity data rows are stored in a single multi-tenant physical table, which may contain multiple logical tables per organization. In some implementations, multiple “tables” for a single customer may actually be stored in one large table and/or in the same table as the data of other customers.
These and other aspects of the disclosure may be implemented by various types of hardware, software, firmware, etc. For example, some features of the disclosure may be implemented, at least in part, by machine-program product that include program instructions, state information, etc., for performing various operations described herein. Examples of program instructions include both machine code, such as produced by a compiler, and files containing higher-level code that may be executed by the computer using an interpreter. Examples of machine-program product include, but are not limited to, magnetic media such as hard disks, floppy disks, and magnetic tape; optical media such as CD-ROM disks; magneto-optical media; and hardware devices that are specially configured to store and perform program instructions, such as read-only memory devices (“ROM”) and random access memory (“RAM”).
While one or more implementations and techniques are described with reference to an implementation in which a service cloud console is implemented in a system having an application server providing a front end for an on-demand database service capable of supporting multiple tenants, the one or more implementations and techniques are not limited to multi-tenant databases nor deployment on application servers. Implementations may be practiced using other database architectures, i.e., ORACLE®, DB2® by IBM and the like without departing from the scope of the implementations claimed.
Any of the above implementations may be used alone or together with one another in any combination. Although various implementations may have been motivated by various deficiencies with the prior art, which may be discussed or alluded to in one or more places in the specification, the implementations do not necessarily address any of these deficiencies. In other words, different implementations may address different deficiencies that may be discussed in the specification. Some implementations may only partially address some deficiencies or just one deficiency that may be discussed in the specification, and some implementations may not address any of these deficiencies.
While various implementations have been described herein, it should be understood that they have been presented by way of example only, and not limitation. Thus, the breadth and scope of the present application should not be limited by any of the implementations described herein but should be defined only in accordance with the following and later-submitted claims and their equivalents.