Generating floating desktop representation of extracted model object

Information

  • Patent Grant
  • 9105006
  • Patent Number
    9,105,006
  • Date Filed
    Friday, May 29, 2009
    16 years ago
  • Date Issued
    Tuesday, August 11, 2015
    10 years ago
Abstract
Embodiments relate to systems and methods for generating a floating desktop representation of an extracted model object. Aspects relate to object-based modeling using modeling objects that can be extracted from spreadsheet cells, database entries, or other sources. A modeling client can host modeling logic and an application programming interface (API) to create, access, manipulate, and import/export modeling objects used in modeling applications, such as engineering, medical, financial, and other modeling platforms. In aspects, the source data can be accepted into the modeling client from consumer or business-level applications, whose cell, database, or other data content can be extracted and encapsulated in object-oriented format, such as extensible markup language (XML) format. An icon or other desktop representation can be generated to present the extracted model object for selection and use in the local environment of the modeling client. The extracted model object can also be exchanged with other applications or platforms.
Description
FIELD

The present teachings relate to systems and methods for generating a floating desktop representation of extracted model object, and more particularly to platforms and techniques for dedicated modeling of technical, medical, financial, and other systems which are configured to extract spreadsheet cells, database entries, or other data along with associated functions, to generate a floating icon or other desktop representation of that model object.


BACKGROUND OF RELATED ART

A spectrum of modeling platforms and options exist today for engineers, managers, developers and other professionals. In the case of engineering, medical, technical, financial, and other advanced modeling resources, a range of platforms are available for users interested in setting up, running and maintaining financial modeling systems. For example, organizations interested in relatively sophisticated modeling applications, such as geophysical models for detecting oil reserves or other geologic features or equity market analysis based on Black-Sholes option pricing models, a company or other organization may choose to install advanced modeling software on mainframe-class computers to run those classes of models and obtain various projections, reports, and other results. Such mainframe platform and related installations, however, can involve costs on the order of millions of dollars or more, and may require the full time attention of highly skilled professionals, including programmers and managers with advanced training. As a consequence, putting a mainframe-based ERP modeling operation into place may not be practical or possible for many organizations or users.


On the other end of the spectrum, managers, engineers and others may employ widely available entry-level applications to capture operational data and attempt to develop predictive models for engineering, financial, medial, and other applications. That class of applications can include, for example, consumer or business-level spreadsheet, database, or data visualization programs for technical, financial, and other purposes. For instance, a manager of a manufacturing facility may use a commercially available spreadsheet application to enter production numbers, schedules, and other details of that site. However, attempting to extract useful modeling outputs from those classes of applications can be difficult or impossible. For one, spreadsheet, database, and other widely available applications are typically built to produce reports based on already existing data, but not to generate modeling outputs or objects that represent predictive outputs or scenarios. For another, existing spreadsheet, database, and other applications typically involve limitations on cell size, number of dimensions, overall storage capacity, and other program parameters which, in the case of large-scale modeling operations, may be insufficient to operate on the data sets necessary to produce and run meaningful models.


For another, the data structures and outputs of existing spreadsheet, database and other entry-level or commonly available applications are typically arranged in proprietary format, rather than a widely interoperable object-based or other universal format. As still another drawback, the cells, rows, columns, and other data elements within commonly available spreadsheets, databases, and other entry-level programs can not be extracted as separate units and exported to other modeling or analytic tools. In short, the use of spreadsheet, database, and other consumer or business-level applications to conduct modeling operations involves significant shortcomings, due in part to the fact that those classes of platforms are not designed to reliable handle modeling functionality.


At present, therefore, a manager, developer, engineer, or other professional or user with modeling requirements is faced with a choice between installing a large and expensive mainframe-based ERP solution with its attendant infrastructure, a spreadsheet or database-based entry level solution with its attendant limitations on power and data handling, or a combination of those two types of platforms. It may be desirable to provide object-based or object-compatible modeling platforms capable of generating modeling objects which encapsulate various modeling features, and which are exportable to other external modeling tools.





DESCRIPTION OF THE DRAWINGS

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the present teachings and together with the description, serve to explain the principles of the present teachings. In the figures:



FIG. 1 illustrates an overall system for a modeling network including various hardware and connectivity resources that can be used in systems and methods for generating floating desktop representation of an extracted model object, according to various embodiments of the present teachings;



FIG. 2 illustrates an exemplary modeling network including a modeling server and connectivity resources, according to various embodiments;



FIG. 3 illustrates an exemplary hardware configuration for a modeling server that can be used in systems and methods for generating floating desktop representation of extracted model object, according to various embodiments;



FIG. 4 illustrates a flow diagram of overall modeling processing for systems and methods for generating a floating desktop representation of an extracted model object, according to various embodiments;



FIG. 5 illustrates exemplary operations to extract and generate a floating desktop representation of an extracted model object, according to various embodiments; and



FIG. 6 illustrates a flow diagram of processing to generate a floating desktop representation of an extracted model object, according to various embodiments.





DESCRIPTION OF EMBODIMENTS

Embodiments of the present teachings relate to systems and methods for a floating desktop representation of an extracted model object. More particularly, embodiments relate to platforms and techniques that can access, extract, and generate modeling objects in a native object-based or object-compatible format, and generate an icon or other representation of those objects on a local desktop or other user interface. The modeling objects produced via a modeling client or other modeling tool according to the present teachings can encapsulate both source data describing a physical, medical, technical, financial, or other process or phenomena, and modeling attributes that relate the source data to predictive scenarios, specific models, and other features. In embodiments, the modeling objects can be extracted or “lifted” from data sources such as spreadsheet or database programs, and an icon or other representation of those objects can be placed on the desktop or other user interface of a local modeling client. These and other embodiments described herein address the various noted shortcomings in known modeling technology, and provide a user or operator with enhanced modeling power on a desktop or other client, while allowing seamless generation, local storage, and communication of model objects to backend mainframe platforms, data centers, middleware servers, other modeling clients, and/or other local or remote modeling, storage, or data processing resources.


Reference will now be made in detail to exemplary embodiments of the present teachings, which are illustrated in the accompanying drawings. Where possible the same reference numbers will be used throughout the drawings to refer to the same or like parts.



FIG. 1 illustrates an overall network 100 in which systems and methods for generating a floating desktop representation of an extracted model object can be implemented, consistent with various embodiments of the present teachings. In embodiments as shown, a modeling client 102 can communicate with a variety of local and remote resources, including a mainframe platform 202 via one or more network 112. Client 102 can be or include, for instance, a personal computer, a server, a dedicated workstation, a mobile device, or other machine, device, hardware, or resource. One or more network 112 can be or include, for example, the Internet, a virtual private network (VPN), a local area network such as an Ethernet™ network, or other public or private network or networks. mainframe platform 202 can be or include commercially available platforms or installations, such as, merely for example, enterprise platforms available from SAP Inc. of Walldorf, Germany, and other sources.


Mainframe platform 202 can include modules, logic, and functionality to perform an array of computation and data storage tasks, including data warehousing, data mining, statistical analyses, financial planning, inventory management, customer resource management, engineering design, and other applications. In implementations as shown, mainframe platform 202 can host or communicate with a variety or resources including, merely illustratively, a mainframe data store 206, and logic or applications including an analytic module 204. Mainframe platform 202 can contain, host, support, or interface to other data processing hardware, software, and other resources. In embodiments, modeling client 102 can likewise communicate with other local or remote resources, such as a middleware server 208 hosting or interfacing to a set of data stores for online analytical processing (OLAP) or other functions. Modeling client 102 can also communicate or interface with other local or remote servers, services, data stores, or other resources.


In embodiments as shown, modeling client 102 can operate under an operating system 118, such as a distribution of the Linux™, Unix™, or other open source or proprietary operating system. Modeling client 102 can present a user interface 130, such as a graphical user interface or command line interface, operating under operating system 118 to receive commands and inputs from a user, and operate modeling client 102. Modeling client 102 can communicate with storage resources including a modeling store 104, such as a local or remote database or data store. Modeling store 104 can store a set of modeling objects 106, in which data, functions, procedures, attributes, and/or other information related to one or more modeling object 110 can be encapsulated and stored. In embodiments, modeling object 110 can be encoded in extensible markup language (XML) format. In embodiments, modeling object 110 can be encoded in other object-based or object-compatible formats or data structures. Modeling client 102 can communicate with mainframe platform 202 via a modeling application programming interface (API) 108. Modeling application programming interface (API) 108 can include, for instance, defined function calls or calls to other routines, calculations, or features, as well as data structures and parameters associated with modeling operations. For example, modeling application programming interface (API) 108 can include a function call to invoke a Monte Carlo simulation model based on a set of supplied data, such as an identified set of dimensions extracted from a spreadsheet or database. Other functions, routines, resources, and features can be called, invoked, or instantiated via modeling application programming interface (API) 108. According to embodiments in various regards, one or more local or remote modeling packages, modules, or other supporting applications can be instantiated via modeling module 120 and modeling application programming interface (API) 108 to manipulate source data and resulting one or more modeling object 110.


In embodiments, a user of modeling client 102 can access, modify, or add data modeling objects to a set of data modeling object 106 via a modeling module 120 hosted in modeling client 102. Set of data modeling objects 106 can include data objects that the user of modeling client 102 has directly entered, or, in aspects, which the user of modeling client has imported or extracted from sources such as consumer or business-level spreadsheet, database, and/or other applications or platforms. Modeling module 120 can itself be or include applications, software modules or hardware modules, or other logic or resources to operate on set of modeling objects 106. Modeling module 120 can, merely illustratively, include or access logic or modules for invoking and manipulating a variety of scientific, technical, engineering, medical, financial, manufacturing, or other modeling operations. For instance, modeling module 120 can be or include applications or logic for performing Monte Carlo simulations, finite element analyses, Black-Scholes option pricing or other market analyses, epidemiological projections, geophysical models or simulations, or other simulations, models, trend mappings, projections, or other predictive processes. In embodiments in one regard, after invoking modeling module 120 and performing any modeling task, the user of modeling client 102 can locally store and/or export one or more modeling object 110 to external platforms or resources.


In embodiments as shown, the user of modeling client 102 can for instance export or communicate one or more modeling object 110 to mainframe platform 202 via modeling application programming interface (API) 108, for storage and use at a local or remote location from within that platform. In aspects, mainframe platform 202 can receive modeling object 110 directly, without a necessity for translation, re-formatting, or invoking any spreadsheet, database, or other application from which data encapsulated in one or mode modeling object 110 originated. In aspects, mainframe platform 202 can operate on one or more modeling object 110, and transmit or return that data or other results to modeling client 102 via modeling application programming interface (API) 108. Thus, according to aspects of the present teachings, modeling objects can be exchanged directly and programmatically between modeling client 102, mainframe platform 202 or other larger-scale or remote platforms, including for instance middleware server 208 or other comparatively large-scale or higher-capacity modeling or analytic tools.


In terms of operating on source data and generating one or more modeling object 110 for local storage and/or exchange with mainframe platform 202 or other platforms, and as shown for instance in FIG. 2, according to various embodiments, a user of modeling client 102 can invoke modeling module 120 to manipulate a set of source data 114 to identify, configure, and/or extract the functional objects, attributes, or other features of a set of data to produce a modeling output. In embodiments as shown, modeling module 120 can access a set of source data 114, from which data, attributes, and/or other metadata can be extracted to generate one or more modeling object 110. In aspects, set of source data 114 can be generated, hosted, or stored by or in a local application 134, such as a spreadsheet, database, accounting, word processing, presentation, or other application or software. In aspects, set of source data 114 can comprise data previously or newly generated in the form of an object-based modeling object, such as a modeling object entered, imported, or specified by the user of modeling client 102. In aspects, set of source data 114 can comprise data originally stored or generated in a consumer or business-level spreadsheet, database, and/or other application or software. In aspects, set of source data 114 can be initially formatted or encoded in a non-object oriented format, such as in a cellular array or in a relational database format. In aspects, set of source data 114 can be initially formatted or encoded in an object-oriented format, such as extensible markup language (XML) format. In aspects, a user of modeling client 102 can highlight, select, or otherwise specify all or a portion of set of source data 114 to generate one or more extracted functional object 116. For instance, a user can highlight a column of set of source data 114 to identify and extract data as well as functional relationships of interest, to the user, as a unified object. Thus, purely illustratively and as shown, a user may wish to obtain a view on a current month's sales figures including gross sales, tax, production or delivery costs, and cost basis, as well as other parameters related to sales activity. In aspects as shown, a user can, for instance, highlight those functional relationships by dragging a cursor or otherwise selecting a set of cells to group together, and form one or more extracted functional object 116. In aspects, selection can include the extraction of set of data elements 136, such as values stored in spreadsheet cells or database entries. In aspects, once a set of data elements 136 are selected, the functional, computational, or other modeling parameters associated with that data can be stored or associated with one or more extracted functional object 116. For instance, modeling module 120 can store associated routines, computations, processes, or other attributes or functional specifications for one or more extracted functional object 116 in set of attributes 122, which can be stored or associated with one or more extracted functional object 116. In aspects, set of attributes 122 can include the identification of or linkage to any routines, interfaces, or other functional or computational resources that will be associated with one or more extracted functional object.


According to various embodiments, analytic module 204 of mainframe platform 202, or other resource or platform receiving one or more extracted functional object 116 from modeling client 102 can thereby obtain both data values derived or obtained from set of source data 114, as well as functional or procedural resources and relationships associated with that data. One or more extracted functional object 116 along with any associated set of attributes 122 can be encoded or stored in one or more modeling object 110, which can thereby be transparently exported to mainframe platform 202, middleware server 208, or other platforms or destinations for further modeling operations.



FIG. 3 illustrates an exemplary diagram of hardware, software, connectivity, and other resources that can be incorporated in a modeling client 102 configured to communicate with one or more network 112, including to interface with mainframe platform 202, middleware server 208, and/or other local or remote resources. In embodiments as shown, modeling client 102 can comprise a processor 124 communicating with memory 126, such as electronic random access memory, operating under control of or in conjunction with operating system 118. Operating system 118 can be, for example, a distribution of the Linux™ operating system, the Unix™ operating system, or other open-source or proprietary operating system or platform. Processor 124 also communicates with a model store 104, such as a database stored on a local hard drive, which may store or host set of modeling objects 106. Processor 124 further communicates with network interface 128, such as an Ethernet or wireless data connection, which in turn communicates with one or more networks 112, such as the Internet, or other public or private networks. Processor 124 also communicates with modeling module 120 along with modeling application programming interface (API) 108 and/or other resources or logic, to execute control and perform modeling calculation, translation, data exchange, and other processes described herein. Other configurations of the network modeling client 102, associated network connections, and other hardware and software resources are possible. While FIG. 3 illustrates modeling client 102 as a standalone system comprises a combination of hardware and software, modeling client 102 can also be implemented as a software application or program capable of being executed by a conventional computer platform. Likewise, modeling client 102 can also be implemented as a software module or program module capable of being incorporated in other software applications and programs. In either case, modeling client 102 can be implemented in any type of conventional proprietary or open-source computer language.



FIG. 4 illustrates a flow diagram of overall processing that can be used in systems and methods for generating a floating desktop representation of an extracted model object, according to various embodiments. In 402, processing can begin. In 404, a user of modeling client 102 or other client or device can invoke or instantiate modeling module 120 or other logic, to perform modeling operations. In 406, modeling module 120 can access model store 104 and extract one or more modeling object 110 from set of modeling objects 106. In 408, modeling computations or other operations can be performed on one or more modeling object 110. For example, a modeling operation can be performed to project or predict the output of a factory based on various supply scenarios for parts, materials, energy costs, or other variables. In 410, the values, functions, linkages, or other attributes of one or more data modeling object 110 that were accessed, produced, or modified by the modeling operations can be captured, fixed, or locked down by modeling module 120. For instance, the resulting one or more modeling object 110 can be stored to set of modeling objects 106 in model store 104, or other databases or data stores.


In 412, modeling application programming interface (API) 108 can be invoked by modeling module 120, by mainframe platform 202, or other resources to transfer one or mode modeling object 110 to mainframe platform 202. In embodiments, one or more modeling object 110 can for instance be communicated to mainframe platform 202 via a secure connection or channel, such as a secure socket layer (SSL) connection, via a channel encrypted using a public/private key infrastructure, or other channel or connection. In 414, one or more model object 110 can be received in modeling module 120 from mainframe platform 202 or other resource, as appropriate. For example, an updated version of one or more model object 110 reflecting new data, new modeling results, or other information can be received in modeling module 120. In 416, the resulting new, updated, or modified one or more model object 110 can be stored to set of modeling objects 106 in model store 104, as appropriate. In embodiments, one or more model objects 110 can in addition or instead be stored to mainframe data store 206, to middleware server 208, to another modeling client or other client, or other site or destination. In 418, modeling module 120 can convert one or more model objects 110 to spreadsheet, database, or other format, and export any converted data as a set of cell-formatted information, or data encoded in other formats. For instance, modeling module 120 can convert or translate one or more model objects to cell data values or database entries, and export that data to client-level applications on modeling client 102 or other local or remote devices or storage. In 420, processing can repeat, return to a prior processing point, jump to a further processing point, or end.


According to various embodiments of the present teachings, and as for example generally illustrated in FIG. 5, in addition to or instead of generating one or more model object to transmit that object to another local or remote destination for consumption by a separate modeling platform, in implementations modeling module 120 can generate modeling objects for output to the desktop or other native or local interface of modeling client 102. In embodiments as shown, a user of modeling client 102 can manipulate a local application 134, such as a database, spreadsheet, word processing, presentation, or other application, and/or modeling module 120 to access, view, and operate on set of source data 14, for instance to identify, highlight, and extract an extracted functional object 116, such as a portion of a column of a spreadsheet or database, including constituent data and functional attributes. The attributes or other metadata of extracted functional object 116 can be stored in set of attributes 122, or encoded in other fashion for association with the selected data. In embodiments in various regards, once extracted functional object 116 is extracted, modeling module can capture and store, or lock down, the data content of that object along with any attributes or other metadata. Moreover, according to various embodiments, modeling module 120 can generate an icon or other representation of the model object, and store that association between extracted functional object 116, set of attributes 122, and the local icon or other representation to generate a selectable local model object 132.


In aspects, local model object 132 can comprise an icon, snapshot, gadget, or other reduced or compact representation of the underlying extracted functional object 116 and any associated set of attributes, for instance, via a selectable icon presented on user interface 130 of modeling client 102. In embodiments as shown, therefore, local model object 132 can reside on the desktop or other user interface 130, for independent access and use by local application 134, modeling module 120, and/or other software, services, or logic. In aspects in various regards, any one or more selected portion of data from set of source data 114 can thereby be extracted or lifted from its original storage or associated application, and become directly available for independent access by modeling or other applications. It may be noted that while local model object 132 is illustrated as residing on a desktop or other user interface 130 of modeling client 102, in embodiments, local model object 132 can also or instead be transmitted to other local or remote platforms, such as mainframe platform 202, middleware servers, other modeling or other clients, or other destinations.



FIG. 6 illustrates a flow diagram of overall processing to generate and manipulate one or more local model object 132, according to various embodiments. In 602, processing can begin. In 604, a user can invoke or initiate one or more local application 134, such as, for instance, a spreadsheet application, a database application, a word processing application, a presentation application, or other application or software. In 606, a user can select data in local application 134 to form or provide a set of source data 114, such as by selecting a set of cells in a spreadsheet, or a column in a database. In 608, modeling module 120 or other logic can capture or lock down the set of data elements 136 as well as the attributes of the set of source data 114 to generate local model object 132. In 610, local model object 132 can be stored to local storage of modeling client 102, such as model store 104 or other local storage. In 612, modeling module 120 can generate an icon or other representation of local model object 132, and present that icon or other representation of local model object 132 via user interface 130 of modeling client 102. For example, a selectable icon depicting a column header of local model object 132 can be placed on a desktop, or other user interface 130 of modeling client 102.


In 614, modeling module 120 or other logic can retrieve and/or instantiate local model object 132 upon selection or activation of the associated icon or other representation of local model object 132. For instance, a user may highlight or click the associated icon or other representation of local model object 132 to activate that object and related processes. In 616, local model object 132 can be manipulated or updated via local application 134, modeling module 120, or other application or software. For instance, new data values for variables embedded in local model object 132 can be imported, or new predictive modeling runs can be executed. In 618, updated local model object 132 can be stored to local data storage of modeling client 102, such as model store 104 or other local storage, as appropriate. In 620, local model object 132 can be transmitted to mainframe platform 202 or other local or remote platform or other destination, as appropriate. In 622, processing can repeat, return to a prior processing point, jump to a further processing point, or end.


The foregoing description is illustrative, and variations in configuration and implementation may occur to persons skilled in the art. For example, while embodiments have been described wherein one or more model object 110 is accessed and manipulated via one modeling client 102, in embodiments, one or more users can use multiple modeling clients, or networks including modeling clients or other resources, to operate on model object data. For further example, while embodiments have been described in which modeling client 102 may interact with one mainframe platform 202 and/or one middleware server 208, in embodiments, one or more modeling client 102 can interact with mainframe platforms, data centers, middleware servers, and/or other resources, in various combinations. Yet further, while embodiments have been described in which a modeling client 102 interacts with a mainframe platform 202 and/or middleware server 208, in embodiments, rather than interact with large-scale enterprise platforms or middleware servers, modeling client 102 can interact with other local or remote modeling clients, networks of those clients, or, in embodiments, can operate to perform modeling operations on a stand-alone basis, without necessarily communicating with other modeling platforms. Other resources described as singular or integrated can in embodiments be plural or distributed, and resources described as multiple or distributed can in embodiments be combined. The scope of the present teachings is accordingly intended to be limited only by the following claims.

Claims
  • 1. A method comprising: executing an instance of an application on a client computer system, the application comprising a set of source data;selecting a portion of the set of source data from the instance of the application to extract a data element and an attribute of the selected portion of source data;encapsulating the selected portion of source data in a model object, the selected portion of source data comprising the extracted data element and attribute;generating a snapshot representation of the model object on an interface of the client computer system, wherein the snapshot representation is a compact visual representation of the extracted data element and attribute and comprises a column header corresponding to the extracted data element and attribute;receiving user input selecting the snapshot representation;accessing, by a processor executing the application, the selected portion of the source data encapsulated in the model object in response to the user input, wherein the application comprises a user application; andchanging, by the application, a value for the data element to update the data element in the selected portion of the source data encapsulated in the model object to create an updated model object, wherein the snapshot representation corresponds to the updated model object in response to changing the value.
  • 2. The method of claim 1, wherein the set of source data comprises at least one of spreadsheet data, database data, word processing data, or presentation data.
  • 3. The method of claim 1, wherein the model object is encoded in extensible markup language (XML) format.
  • 4. The method of claim 1, wherein the attribute comprises at least one of a function call parameter or a linkage parameter.
  • 5. The method of claim 1, wherein the interface of the client computer system comprises a graphical user interface.
  • 6. The method of claim 1, wherein the model object is importable into at least one application other than the application comprising the set of source data via the snapshot representation.
  • 7. The method of claim 1, wherein the set of source data is hosted in at least one of local storage of the client computer system or remote storage.
  • 8. The method of claim 1, wherein the snapshot representation comprises a column including one or more rows, each row including a value corresponding to the extracted data element and attribute.
  • 9. A client computer system comprising: an interface to a set of source data; anda processor, to communicate with the set of source data via the interface, the processor to: execute an instance of an application on a client computer system, the application comprising a set of source data,select a portion of the set of source data from the instance of the application to extract a data element and an attribute of the selected portion of source data,encapsulate the selected portion of source data in a model object, the model object comprising the extracted data element and attribute,generate a snapshot representation of the model object on an interface of the client system, wherein the snapshot representation is a compact visual representation of the extracted data element and attribute and comprises a column header corresponding to the extracted data element and attribute,receive user input selecting the snapshot representation;access, by the application, the selected portion of the source data encapsulated in the model object in response to the user input, wherein the application comprises a user application; andchange, by the application, a value for the data element to update the data element in the selected portion of the source data encapsulated in the model object to create an updated model object, wherein the snapshot representation corresponds to the updated model object in response to changing the value.
  • 10. The system of claim 9, wherein the set of source data comprises at least one of spreadsheet data, database data, word processing data, or presentation data.
  • 11. The system of claim 9, wherein the model object is encoded in extensible markup language (XML) format.
  • 12. The system of claim 9, wherein the attribute comprises at least one of a function call parameter or a linkage.
  • 13. The system of claim 9, wherein the interface of the client computer system comprises a graphical user interface.
  • 14. The system of claim 9, wherein the model object is importable into at least one application other than the application comprising the set of source data via the snapshot representation.
  • 15. The system of claim 9, wherein the set of source data is hosted in at least one of local storage of the client computer system or remote storage.
  • 16. The system of claim 9, wherein the snapshot representation comprises a column including one or more rows, each row including a value corresponding to the extracted data element and attribute.
  • 17. A non-transitory computer-readable storage medium including instructions that, when executed by a processor, cause the processor to: execute an instance of an application on a client computer system, the application comprising a set of source data;select a portion of the set of source data from the instance of the application to extract a data element and an attribute of the selected portion of source data;encapsulate the selected portion of source data in a model object, the model object comprising the extracted data element and attribute;generate a snapshot representation of the model object on an interface of the client computer system, wherein the snapshot representation is a compact visual representation of the extracted data element and attribute and comprises a column header corresponding to the extracted data element and attribute;receive user input selecting the snapshot representation;access, by a processor executing the application, the selected portion of the source data encapsulated in the model object in response to the user input, wherein the application comprises a user application; andchange, by the application, a value for the data element to update the data element in the selected portion of the source data encapsulated in the model object to create an updated model object, wherein the snapshot representation corresponds to the updated model object in response to changing the value.
US Referenced Citations (119)
Number Name Date Kind
5491353 Kean Feb 1996 A
5890167 Bridge, Jr. et al. Mar 1999 A
5978796 Malloy et al. Nov 1999 A
6035300 Cason et al. Mar 2000 A
6360188 Freidman et al. Mar 2002 B1
6366922 Althoff Apr 2002 B1
6430539 Lazarus et al. Aug 2002 B1
6434435 Tubel et al. Aug 2002 B1
6434544 Bakalash et al. Aug 2002 B1
6594672 Lampson et al. Jul 2003 B1
6609123 Cazemier et al. Aug 2003 B1
6735590 Shoup et al. May 2004 B1
6851089 Erickson et al. Feb 2005 B1
6931418 Barnes Aug 2005 B1
7039871 Cronk May 2006 B2
7093194 Nelson Aug 2006 B2
7139766 Thomson et al. Nov 2006 B2
7152062 Draper et al. Dec 2006 B1
7177329 Kobayashi Feb 2007 B2
7240067 Timmons Jul 2007 B2
7299241 Reed et al. Nov 2007 B2
7657545 Bird Feb 2010 B2
7660822 Pfleger Feb 2010 B1
7702615 Delurgio et al. Apr 2010 B1
7716257 Thomson et al. May 2010 B2
8365195 Williamson Jan 2013 B2
8417734 Williamson Apr 2013 B2
8417739 Williamson Apr 2013 B2
8606827 Williamson Dec 2013 B2
8694540 Lin et al. Apr 2014 B1
8930487 Williamson Jan 2015 B2
20010049678 Yaginuma Dec 2001 A1
20020029207 Bakalash et al. Mar 2002 A1
20020035562 Roller et al. Mar 2002 A1
20020070936 Oikawa et al. Jun 2002 A1
20020083034 Orbanes et al. Jun 2002 A1
20020087516 Cras et al. Jul 2002 A1
20020169658 Adler Nov 2002 A1
20030100972 Andersh et al. May 2003 A1
20030114950 Ruth et al. Jun 2003 A1
20030115194 Pitts et al. Jun 2003 A1
20030115207 Bowman et al. Jun 2003 A1
20030120372 Ruth et al. Jun 2003 A1
20030126114 Tedesco Jul 2003 A1
20030184585 Lin et al. Oct 2003 A1
20030225736 Bakalash et al. Dec 2003 A1
20040039736 Kilmer et al. Feb 2004 A1
20040133552 Greenfield et al. Jul 2004 A1
20040139061 Colossi et al. Jul 2004 A1
20040199497 Timmons Oct 2004 A1
20040205617 Light Oct 2004 A1
20040252136 Bhatt et al. Dec 2004 A1
20050004904 Kearney et al. Jan 2005 A1
20050010566 Cushing et al. Jan 2005 A1
20050015220 Ramchandi Jan 2005 A1
20050060252 Doddington Mar 2005 A1
20050060382 Spector et al. Mar 2005 A1
20050091206 Koukerdjinian et al. Apr 2005 A1
20050096590 Gullickson et al. May 2005 A1
20050102127 Crowe et al. May 2005 A1
20050257125 Roesner et al. Nov 2005 A1
20060004833 Trivedi et al. Jan 2006 A1
20060024653 Battagin et al. Feb 2006 A1
20060036707 Singh et al. Feb 2006 A1
20060112050 Miikkulainen et al. May 2006 A1
20060136462 Campos et al. Jun 2006 A1
20060173906 Chu et al. Aug 2006 A1
20060190844 Binder et al. Aug 2006 A1
20060262145 Zhang et al. Nov 2006 A1
20070006139 Rubin et al. Jan 2007 A1
20070022093 Wyatt et al. Jan 2007 A1
20070027904 Chow et al. Feb 2007 A1
20070073748 Barney Mar 2007 A1
20070088757 Mullins et al. Apr 2007 A1
20070094236 Otter et al. Apr 2007 A1
20070150820 Salvo Jun 2007 A1
20070208721 Zaman et al. Sep 2007 A1
20070211056 Chakraborty et al. Sep 2007 A1
20070256058 Marfatia et al. Nov 2007 A1
20070266308 Kobylinski Nov 2007 A1
20080028288 Vayssiere et al. Jan 2008 A1
20080140696 Mathuria Jun 2008 A1
20080172405 Feng et al. Jul 2008 A1
20080243778 Behnen et al. Oct 2008 A1
20080294596 Xiong Nov 2008 A1
20080320023 Fong Dec 2008 A1
20090006992 Gilboa Jan 2009 A1
20090018996 Hunt et al. Jan 2009 A1
20090172042 Bracha et al. Jul 2009 A1
20090193039 Bradley et al. Jul 2009 A1
20090222470 Kemp et al. Sep 2009 A1
20090254572 Redlich et al. Oct 2009 A1
20100057700 Williamson Mar 2010 A1
20100057777 Williamson Mar 2010 A1
20100131456 Williamson May 2010 A1
20100169299 Pollara Jul 2010 A1
20100180220 Becerra, Jr. Jul 2010 A1
20100305922 Williamson Dec 2010 A1
20100306254 Williamson Dec 2010 A1
20100306255 Williamson Dec 2010 A1
20100306272 Williamson Dec 2010 A1
20100306281 Williamson Dec 2010 A1
20100306340 Williamson Dec 2010 A1
20100306682 Williamson Dec 2010 A1
20100309228 Mattos et al. Dec 2010 A1
20110050728 Williamson Mar 2011 A1
20110054854 Williamson Mar 2011 A1
20110055680 Williamson Mar 2011 A1
20110055681 Smialek et al. Mar 2011 A1
20110055761 Williamson Mar 2011 A1
20110055850 Williamson Mar 2011 A1
20110078199 Williamson Mar 2011 A1
20110078200 Williamson Mar 2011 A1
20110131176 Williamson Jun 2011 A1
20110131220 Williamson Jun 2011 A1
20110158106 Williamson Jun 2011 A1
20110161282 Williamson Jun 2011 A1
20110161374 Williamson Jun 2011 A1
20110161378 Williamson Jun 2011 A1
Non-Patent Literature Citations (64)
Entry
Using OLAP and Multi-Dimensional data for decision making, Hasan et al, IEEE 2001.
A new OLAP aggregation based on the AHC technique, Massaoud of al, DOLAP'04 Nov. 12-13, 2004.
Interactive hierarchical dimension ordering, spacing and filtering for exploration of high dimension datasets, Yang et al, IEEE symposium on information visualization 2003.
Williamson, “Systems and Methods for Interpolating Conformal Input Sets Based on A Target Output”, U.S. Appl. No. 12/872,779, flied Aug. 31, 2010.
Williamson, “Systems and Methods for Interpolating Alternative Input Sets Based on User-Weighted Variables”, U.S. Appl. No. 12/951,881, filed Nov. 22, 2010.
Williamson, “Systems and Methods for Tracking Differential Changes in Conformal Data Input Sets”, U.S. Appl. No. 12/951,937, filed Nov. 22, 2010.
Williamson, “Systems and Methods for Training A Self-Learning Network Using Interpolated Input Sets Based on a Target Output”, U.S. Appl. No. 12/872,935, filed Aug. 31, 2010.
Williamson, “Systems and Methods for Embedding Interpolated Data Object in Application Data File”, U.S. Appl. No. 12/955,717, filed Nov. 29, 2010.
Williamson, “Systems and Methods for Generating Interpolated Input Data Sets Using Reduced Input Source Objects”, U.S. Appl. No. 12/955,768, filed Nov. 29, 2010.
Williamson, “Systems and Methods for Filtering Interpolated Input Data Based on User-Supplied or Other Approximation Constraints”, U.S. Appl. No. 12/955,790, filed Nov. 29, 2010.
Williamson, “Systems and Methods for Binding Multiple Interpolated Data Objects”, U.S. Appl. No. 12/955,811, filed Nov. 29, 2010.
Williamson, “Systems and Methods for Generating Portable Interpolated Data Using Object Based Encodig of Interpolated Results”, U.S. Appl. No. 13/037,322, filed Feb. 28, 2011.
Williamson, “Systems and Methods for Generating Interpolation Data Template to Normalize Analytic Runs”, U.S. Appl. No. 13/037,332, filed Feb. 28, 2011.
Williamson, “Systems and Methods for Generating Interpolation Data Sets Converging to Optimized Results Using Iterative Overlapping Inputs”, U.S. Appl. No. 13/037,341, filed Feb. 28, 2011.
Williamson, “Systems and Methods for Validating Interpolation Results Using Monte Carlo Simulations on Interpolated Data Inputs”, U.S. Appl. No. 13/037,344, filed Feb. 28, 2011.
ASPFAQ.com, “What are the valid styles for converting datetime to string?”, (2006) http://database.aspfaq.com/database/what-are-the-valid-styles-for-converting-datetime-to-string.html.
Answering Joint Queries from Multiple Aggregate OLAP Databases, Pourabbas et al, LNCS 2737, pp. 24-34, 2003.
Office Action for U.S. Appl. No. 12/475,439 mailed Apr. 29, 2011.
Office Action for U.S. Appl. No. 12/475,439 mailed Nov. 10, 2010.
Office Action for U.S. Appl. No. 12/475,441 mailed Jul. 25, 2011.
Office Action for U.S. Appl. No. 12/475,459 mailed Jun. 6, 2011.
Office Action for U.S. Appl. No. 12/475,458 mailed Jul. 5, 2011.
Office Action for U.S. Appl. No. 12/475,458 mailed Nov. 25, 2011.
Office Action for U.S. Appl. No. 12/475,452 mailed Aug. 12, 2011.
USPTO Office Action for U.S. Appl. No. 12/475,441 mailed May 7, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,459 mailed Feb. 28, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,419 mailed Feb. 22, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,458 mailed Mar. 9, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,452 mailed May 16, 2012.
USPTO Office Action for U.S. Appl. No. 12/551,428 mailed Mar. 30, 2012.
USPTO Office Action for U.S. Appl. No. 12/551,393 mailed Dec. 27, 2011.
USPTO Office Action for U.S. Appl. No. 12/551,330 mailed Dec. 7, 2011.
Chandler et al., “Sharing Metadata: Building Collections and Communities”, May 9, 2009, UC San Diego Libraries, pp. 1-130.
USPTO Office Action for U.S. Appl. No. 12/475,439 mailed Feb. 22, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,439 mailed Dec. 5, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,439 mailed Feb. 11, 2014.
USPTO Notice of Allowance for U.S. Appl. No. 12/475,439 mailed Aug. 13, 2014.
USPTO Notice of Allowance for U.S. Appl. No. 12/8475,441, mailed Aug. 15, 2013.
USPTO Office Action for U.S. Appl. No. 12/475,459 mailed Aug. 22, 2013.
USPTO Office Action for U.S. Appl. No. 12/475,459 mailed Dec. 17, 2013.
USPTO Office Action for U.S. Appl. No. 12/475,459 mailed Apr. 4, 2014.
USPTO, Final Office Action for U.S. Appl. No. 12/475,459 mailed Jul. 15, 2014.
USPTO Office Action for U.S. Appl. No. 12/475,419 mailed Nov. 28, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,419, mailed on Jun. 5, 2014.
USPTO Notice of Allowance for U.S. Appl. No. 12/475,419, mailed on Dec. 15, 2014.
USPTO Notice of Allowance for U.S. Appl. No. 12/475,458 mailed Dec. 6, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,452 mailed Oct. 9, 2012.
USPTO Office Action for U.S. Appl. No. 12/475,452 mailed May 13, 2013.
USPTO Office Action for U.S. Appl. No. 12/475,452 mailed Dec. 18, 2014.
USPTO Office Action for U.S. Appl. No. 12/551,476 mailed Jan. 4, 2013.
USPTO Office Action for U.S. Appl. No. 12/551,476 mailed Mar. 11, 2014.
USPTO Office Action for U.S. Appl. No. 12/551,476 mailed Jan. 30, 2015.
USPTO Office Action for U.S. Appl. No. 12/551,442 mailed Nov. 21, 2012.
USPTO Office Action for U.S. Appl. No. 12/551,442 mailed Jun. 10, 2013.
USPTO Office Action for U.S. Appl. No. 12/551,442 mailed Jan. 29, 2015.
USPTO Notice of Allowance for U.S. Appl. No. 12/551,428 mailed Sep. 25, 2012.
USPTO Office Action for U.S. Appl. No. 12/551,393 mailed May 23, 2012.
USPTO Notice of Allowance for U.S. Appl. No. 12/551,393 mailed Dec. 6, 2012.
USPTO Office Action for U.S. Appl. No. 12/551,330 mailed Jun. 13, 2012.
USPTO Office Action for U.S. Appl. No. 12/551,330 mailed Nov. 7, 2012.
USPTO Office Action for U.S. Appl. No. 12/551,330 mailed Mar. 27, 2013.
USPTO Office Action for U.S. Appl. No. 12/551,330 mailed Sep. 17, 2013.
USPTO Office Action for U.S. Appl. No. 12/551,330 mailed Jan. 8, 2014.
USPTO, Office Acton for U.S. Appl. No. 12/551,330 mailed Aug. 21, 2014.
Related Publications (1)
Number Date Country
20100306682 A1 Dec 2010 US