Abstract: Embodiments of the present disclosure provide a method, system and computer program product for single view presentation of multiple query. In an embodiment of the disclosure, a method for single view presentation of multiple query includes directing a query against a database along a selected dimension of multiple different elements. In response, a primary result set is received. The result set is then organized into a tabular view of cells according to the selected dimension and values for the selected dimension. Thereafter, a set of nested queries may be directed for each of the elements in the selected dimension against the result set utilizing a different dimension. In response to each directed set of nested queries, a corresponding result set is thus received. Finally, each corresponding result set is inserted into a cell associated with a common one of the elements.

Abstract: The technology disclosed relates to a platform for ultra-fast, ad-hoc data exploration and faceted navigation on integrated, heterogeneous data sets. The disclosed method of declarative specification of visualization queries, display formats and bindings represents queries, widgets and bindings combined on a dashboard in real time, with flexible display options for analyzing data and conveying analysis results.

Abstract: Lists of tradeable objects may be generated and displayed to enable a user to define a trading strategy having multiple legs. The lists of tradeable objects may be used to define and display different combinations of the tradeable objects that are included in each of the lists. Each combination of tradeable objects may define the different legs of a spread that may be tradeable on one or more exchanges. A combination of tradeable objects may be selected to display contract information associated with the different legs of the spread. The contract information for each leg may be used to define and display spread information for the legs of the trading strategy. The spread information may allow the user to view information related to the spreads for different combinations of tradeable objects in a display.

Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for generating pivot tables are provided. A pivot table service may receive an indication to generate a pivot table. The pivot table service may transform a plurality of fields in an existing table in a software application from a first order to a semantic hierarchical order by applying a set of cardinality relationship rules to the plurality of fields. The pivot table service may identify a plurality of blocks comprising one or more fields from the semantic hierarchical order. Fields from each block may be populated and positioned in a pivot table that is being generated based on a cardinality value of each block.

Abstract: The technology disclosed includes a spreadsheet application with a formula building capability that allows users to construct a complex multi-component formula piece by piece, seeing the evaluated result of each component on the way to building the whole formula. It replaces users building complex formulas in a number of separate cells, troubleshooting each part and then having to either recombine the formula parts in one cell via a frequently error borne process or creating a master cell using a hidden set of all the piece parts making it harder to then see and understand what the formula is doing and apply copy paste.

Abstract: A solution for spreadsheet table transformation is provided. In this solution, one or more header areas and a data area of a spreadsheet table are detected. A hierarchical structure of each of the header areas is determined by analysis of cell merging and/or indents in the header area, and/or a function relationship between data items in corresponding cells of the data area. The spreadsheet table can be transformed to a relational table based on recognition of the hierarchical structure of the header area. In this way, by facilitating understanding of header structures based on the header hierarchy, it is possible to achieve automated transformation from spreadsheet tables to relational tables.

Abstract: Systems and methods for digital property authentication and management are disclosed. A document representing a trade secret may be requested to be registered with a trade secret registry. A document obfuscation value corresponding to the document may be generated and may be registered with a blockchain. A record of the registration may be generated for the trade secret registry. The registry may be searchable and/or offer functionality such as valuation, insurance provision, and/or verification, among other benefits and functionalities.

Abstract: A system and method for generating visual representations of interesting plots of tabular data.

Abstract: In accordance with various embodiments, described herein are systems and methods for use of computer-implemented machine learning to automatically determine insights of facts, segments, outliers, or other information associated with a set of data, for use in generating visualizations of the data. In accordance with an embodiment, the system can use a machine learning process to automatically determine one or more outliers or findings within the data, based on, for example, determining a plurality of combinations representing pairs of attribute dimensions within a data set, from which a general explanation or pattern can be determined for one or more attributes, and then comparing particular values for attributes, with the determined pattern for those attributes. Information describing such outliers or findings can be graphically displayed at a user interface, as text, graphs, charts, or other types of visualizations, and used as a starting point for further analysis of the data set.

Abstract: Systems, methods, and non-transitory computer-readable media are disclosed for generating generate explanatory paths for column annotations determined using a knowledge graph and a deep representation learning model. For instance, the disclosed systems can utilize a knowledge graph to generate an explanatory path for a column label determination from a deep representation learning model. For example, the disclosed systems can identify a column and determine a label for the column using a knowledge graph (e.g., a representation of a knowledge graph) that includes encodings of columns, column features, relational edges, and candidate labels. Then, the disclosed systems can determine a set of candidate paths between the column and the determined label for the column within the knowledge graph. Moreover, the disclosed systems can generate an explanatory path by ranking and selecting paths from the set of candidate paths using a greedy ranking and/or diversified ranking approach.

Abstract: A system for provenance aware editing for propagating edits back to spreadsheets is provided. The system receives an indication of an operation to be performed at an output location. The operation indicates one or more input locations on a spreadsheet that each provides an input value. The input values are accessed and tagged with their corresponding input location on the spreadsheet. Based on the operation and the input value from each of the one or more input locations, the system derives and displays the result at the output location. A user edit to the result is received at the output location, which causes transmission of a propagation request to change the input value at one or more of the tagged input locations. Using where-provenance associated with the tagged input locations, the system propagates the user edit to one or more of the tagged input locations.

Abstract: Some examples relate to database systems for electronic spreadsheets. In one specific example, a system includes a relational database and a document database that is separate from the relational database. The system can retrieve structural data from the relational database, where the structural data describes a column configuration for a set of columns of the electronic spreadsheet, and where the structural data describes a row configuration for a set of rows of the electronic spreadsheet. The system can also retrieve cell data from the document database. The system can then generate the electronic spreadsheet based on the structural data and the cell data, such that the electronic spreadsheet has the column configuration and the row configuration defined in the structural data, and has the cell data positioned in a set of cells located at intersections of the set of rows and the set of columns.

Abstract: An embodiment of the present invention provides an information processing apparatus for detecting an attribute indicated in different tables in common and generating information about the attribute. An information processing apparatus as an embodiment of the present invention includes a detector and an information generator. The detector detects a common attribute indicated in a first table and a second table. The information generator generates information about the common attribute based on contents of the first table and the second table.

Abstract: This disclosure describes one or more embodiments of systems, non-transitory computer-readable media, and methods that intelligently and automatically analyze input data and generate visual data stories depicting graphical visualizations from data insights determined from the input data. For example, the disclosed systems automatically extract data insights utilizing an in-depth statistical analysis of dataset groups from data-attribute categories within the input data. Based on the data insights, the disclosed systems can automatically generate exportable visual data stories to visualize the data insights, provide textual or audio-based natural language summaries of the data insights, and animate such data insights in videos. In some embodiments, the disclosed systems generate a visual-data-story graph comprising nodes representing visual data stories and edges representing similarities between the visual data stories.

Abstract: Systems and methods extract flat data units from a non-flat input, such as a spreadsheet comprising tables organized according to a hierarchy. First, the non-flat input is read (e.g., using pandas in combination with openpyxl) to create a flat dataframe comprising the content of the non-flat input. Next, individual flat data units (e.g., spreadsheet tables) are recognized and split from the dataframe based upon the appearance of blank rows and/or columns. Headers present in the flat data units are determined (e.g., based upon alphabetic cell text, bolded cell text, and/or early position of the cell in a column), and then connections between the flat data units are identified. Based upon the connections, individual flat data units are merged together. The resulting merged flat data units are subsequently available for consumption, for example user reports of content, and/or conversion to a new non-flat format (e.g., relational database schema).

Abstract: Systems, methods, and computer-readable media for generating a hybrid table template pre-populated with data pulled from preexisting tables are disclosed. The systems and methods may involve storing a customized hybrid table-template definition, wherein the hybrid table-template definition includes a table format and at least one pre-population rule linking at least one cell of the hybrid table template with at least one cell of a preexisting table populated with data; receiving a request to generate a new table using the hybrid table template definition; and following receipt of the request, generating the new table, wherein generating includes following a link to access real-time cell data from the preexisting table, and migrating the real-time cell data to the new table.

Abstract: Nested pagination for presenting a data set in a graphical user interface (GUI) including receiving a request for the data set to present in a GUI, wherein the request comprises a group name identifying a nested group of rows in the data set; selecting an anchor point from the data set using the group name, wherein the anchor point is within the group of rows identified by the group name; selecting, using the anchor point, a subset of the data set for presentation in the GUI, wherein the subset of the data set comprises the anchor point; and presenting the subset of the data set in the GUI.

Abstract: The technology disclosed provides an interactive GUI driven by natural language questions and intuitive controls that support follow-up queries. One features a table-graph that links responsive series of data to graph elements. Individual rows of data in the table can be selected or deselected for display. The rows can be displayed in a single graph for individual graphs. Averages and other statistical measures can be calculated and graphed responsive to selectable controls, without formulas for series calculations. Another feature is so-called Liveboards that include multiple natural language questions and data views produced from executing queries derived from the questions, adapted to data available to a particular user, especially when the user's organization is different from an origin organization that generated the Liveboard.

Abstract: Aspects described herein may be used with local spreadsheet applications, web, and/or cloud-based spreadsheet solutions, to create complex custom software applications. Spreadsheets themselves lack the conceptual framework to be used as a platform tool to build custom or complex software applications. Using the methods and systems described herein using low-code/no-code techniques, a designer can create custom and/or complex software applications using one or more spreadsheets as the underlying blueprints for the software application. The resultant software application may be static/read-only, or may be interactive to allow users to dynamically add, delete, edit, or otherwise amend application data, e.g., via one or more online web pages or via a mobile application. Data transfer may be one-way or bi-directional between the blueprint spreadsheets and the resultant software application, thereby allowing amended data to be transferred from the software application back into spreadsheet form.

Abstract: The present disclosure provides a method for executing a query in a database, the method comprising receiving the query that comprises a query key; searching a data structure of the database to determine whether the query key includes a portion that corresponds to an entry in the database, wherein the data structure comprises a first sequence of values comprising information that indicates whether the database comprises data that corresponds to a portion of a key, and a second sequence of values comprising pointers pointing to data that corresponds to the key; in response to the query key including a portion that corresponds to an entry in the database, determining a location of a value in the first sequence, wherein the value corresponds to the portion of the query key; and determining a pointer in the second sequence of values according to the location, wherein the pointer points to data that corresponds to the query key.

Abstract: Provided are a method and apparatus for displaying table information, an electronic device and a non-transitory computer-readable storage medium. The method for displaying table information includes: acquiring a row information display instruction of a target table, where the row information display instruction includes information of a target content row; and displaying, in a portrait orientation, first information in a header row of the target table and second information in the target content row according to the row information display instruction, where a cell in which the first information is located and a cell in which the second information is located have a same column identifier.

Abstract: Methods, systems, and apparatus include computer programs encoded on a computer-readable storage medium for delivering content. A method includes: identifying an application that is installed on a user device; accepting a bid from a sponsor associated with the application for presenting customized content on the user device after installation of the application on the user device; identifying an opportunity to present content on the user device including receiving a request for content that identifies the user device; conducting an auction including evaluating the accepted bid along with other bids; determining that the accepted bid is the winning bid in the auction and providing, in response to the determining, a shell for the customized content; enabling the shell to be populated with data stored on the user device to produce the customized content; and providing the customized content for presentation on the user device in response to the identified opportunity.

Abstract: The technology disclosed relates to accessing external data in spreadsheet cells and includes spreadsheet cells that can use formulaically defined external data, allowing users to utilize many cells as if they were one cell and to simplify or expand the type of calculations possible within a cell. The disclosed technology further includes a spreadsheet application that can perform looped calculations within the spreadsheet cells without the need to use an embedded programming language. Additionally the disclosed spreadsheet application can use named variables and formulaic cell designators for cell operations in which formulaically defined non-spreadsheet cell data variables and their values can be exposed and multiple values can exist in a cell, and the user can step through and see those different values.

Abstract: A system provides for management of a managed infrastructure. A processor is coupled to various engines. An extraction engine is in communication with the managed infrastructure. The extraction engine in operation receives messages from the managed infrastructure, produces events that relate to the managed infrastructure and converts the events into words and subsets used to group the events into clusters that relate to failures or errors in the managed infrastructure, including managed infrastructure physical hardware. The managed infrastructure supports the flow and processing of information. A sigalizer engine includes one or more of an NMF engine, a k-means clustering engine and a topology proximity engine.

Abstract: Various embodiments of systems, computer program products, and methods to smart push values in spreadsheet instances are described herein. In an aspect, a spreadsheet instance is activated to receive at least one value, pushed within a process automation execution. The size of the data is calculated, including its dimensions. In another aspect, an active cell in the activated spreadsheet instance is determined. The active cell marks the position where the data will be entered, based on its size as determined, and further based on the orientation of the dimensions of the data. In yet another aspect, a new position of the active cell is calculated based on the data size. The cell at the position corresponding to the calculated new position is set as the new active cell of the spreadsheet instance.

Abstract: A system for updating a hypercube includes an interface and a processor. The interface is configured to receive an indication to update a cell of the hypercube. The processor is configured to determine a primary dimension value associated with the cell; determine a group of dependencies based at least in part on the primary dimension value, wherein a dependency of the group of dependencies comprises one or more primary dimension values and a pattern; for the dependency of the group of dependencies, determine a set of source locations based at least in part on the one or more primary dimension values and the pattern; and mark the set of source locations as invalid.

Abstract: Systems and methods are disclosed herein for editing a collaborative spreadsheets hosted on a server. Multiple users may edit the spreadsheet, resulting in situations of intersecting or conflicting edits. A change provided by one user may intersect the cells affected by a change provided by another user. In these cases, one user's change is transformed against the other user's change. In this manner, the conflict is resolved and both changes can be applied to the spreadsheet. Each user device may perform these transforms, and the server may also perform these transforms. This can result in transmission of a reduced volume of data over a network between the devices and the server, in comparison with other methods.

Abstract: A data profiling module receives user selection of spreadsheets, and the data from the selected spreadsheets is profiled. At least one matching column is identified among the spreadsheets selected. The data profiling module calculates a match metric for the at least one matching column, and unifies the spreadsheets into a single composite spreadsheet using the at least one identified matching column. A preview view of a composite spreadsheet is generated, visually indicating the at least one matching column, any non-matching columns between the spreadsheets, and the match metric for the matching columns. An action history module identifies spreadsheets for use in the procedure, and stores any action applied to the spreadsheets as a procedure template that can be applied to a plurality of other spreadsheets.

Abstract: A method displays a first data visualization according to user placement of data fields in shelves of a user interface. Each shelf specifies a property of the data visualization and the data visualization includes visual data marks corresponding to data values for data fields in a dataset. A user selects a subset of the visual data marks. A popup summary is displayed that includes data value distributions for several data fields. In the popup summary, a second user input is detected corresponding to a first data field whose data value distribution is displayed in the popup summary. In response, the method displays a moveable icon corresponding to the first data field. The method detects a third user input to place the interactive moveable icon in a shelf in the user interface. In response, a second data visualization is displayed according to placement of data fields, including the first data field.

Abstract: A capability to identify and visualize relationships and commonalities amongst record entities is provided. A plurality of entities are extracted from one or more records. Each extracted entity is associated with a respective feature vector within a vector space of a feature matrix. The feature vectors are distributed within the feature matrix based on semantic relationships amongst the entities of a corpus. Multidimensional coordinates within a dimensionally-reduced vector space of the feature matrix are generated for each extracted entity. One or more cells of a cellular presentation of the feature matrix are identified such that each identified cell represents one or more respective extracted entities. Each cell represents (i) a respective range of multidimensional coordinates within the dimensionally-reduced vector space of the feature matrix and (ii) one or more feature vectors of the plurality of feature vectors within the feature matrix.

Abstract: Systems and methods for digital property authentication and management are disclosed. A document representing a trade secret may be requested to be registered with a trade secret registry. A document obfuscation value corresponding to the document may be generated and may be registered with a blockchain. A record of the registration may be generated for the trade secret registry. The registry may be searchable and/or offer functionality such as valuation, insurance provision, and/or verification, among other benefits and functionalities.

Abstract: Provided is a method of providing a document editing service based on a block editor, and a server and a computer program for executing the same, and the method includes the steps of: setting, for a first block in which a cursor indicating an editing position is positioned among the plurality of blocks, an attribute of a content element corresponding to the first block to a first value; receiving a user input for the cursor and confirming a moving direction of the cursor; setting an attribute of a content element corresponding to a second block among blocks adjacent to the first block to a first value, and setting an attribute of a content element corresponding to a third block to a second value, based on the moving direction of the cursor; and processing to move the cursor to the second block on the edit screen.

Abstract: A system and methods for defining spreadsheet worksheet functions capable of returning more than one output value to a worksheet with the layout of the returned values being customizable through the use of named ranges on the worksheet. The mapping of an output value to a destination cell (or range) is achieved by using a naming convention, wherein the name of the output parameter as defined in the worksheet function or in an interactive coding environment is automatically mapped to a worksheet range having the same name.

Abstract: In general, embodiments of the invention relates to methods and systems generating accessible user interfaces or graphical user interfaces. More specifically, embodiments of the invention are directed to user interfaces that display data using combinations of graphical and non-graphical cells. The graphical cells may include both a graphical component as well as a data value component, where these components do not overlap within the cell. In this manner, embodiments of the invention may provide an additional layer of accessibility and interpretability of the data values in the graphical cells.

Abstract: Systems and methods for concept based searching or recommendation are disclosed. More particularly, embodiments of a concept based approach to the search and analysis of data, including the creation, update or use of concept networks in searching and analyzing data are disclosed, including embodiments of the usage of such concept networks in artificial intelligence systems that are capable of utilizing concepts expressed by users to return or evaluate associated destinations.

Abstract: Examples described herein include systems and methods for providing user-specific applications on a shared user device. The user device can receive a first instance of an application having a Package ID that includes an identification of a first user. When the first user is logged in, the user device can display an icon associated with the first instance of the application, based on the Package ID including an identification of the first user. When the first user is not logged in, the user device can hide the first instance of the application. When a second user is logged in, the device can display a second instance of the application based on the Package ID of the second instance including an identification of the second user. The user device can also display the same instance of a shared application to both the first and second user.

Abstract: A computer-implemented method for deploying a new artifact file in a database. The new artifact file provides specifications for one or more new run-time database objects to be created in the database by processing of the new artifact file by artifact-type specific conversion engines. The method includes assigning ownership of the one or more new run-time database objects to be created in the database to the new artifact file, and, when an existing database object in the database provided by another artifact file corresponds to a new run-time database object specified in the new artifact file, assigning ownership of the existing database object in the database to the new artifact file being deployed.

Abstract: Systems and techniques for indexing and/or querying a database are described herein. Multiple, large disparate data sources may be processed to cleanse and/or combine item data and/or item metadata. Further, attributes may be extracted from the item data sources. The interactive user interfaces allow a user to select one or more attributes and/or other parameters to present visualizations based on the processed data.

Abstract: Enhancement layers for data visualization over data sets are provided herein, as is a process for performing data visualization enhancement operations using enhancement layers. A data set may be received for display. A first display layer may be generated. The first display layer may include a base layer rendering the data set in a table. A plurality of data elements in the data set may be identified as having a relationship. The relationship may be identified by a machine-learning process. A second display layer may be generated. The second display layer may include an enhancement layer rendering the relationship between the identified plurality of data elements. The first display layer may be displayed. The second display layer may be displayed over the first display layer. The layers may be visually aligned based on the plurality of data elements.

Abstract: A method and system for displaying the comparison output of two versions of a spreadsheet document such that the source formatting of the spreadsheet can be selectively suppressed to enhance the legibility of the comparison output.

Abstract: Systems, methods, and non-transitory computer readable media for visualizing user spending data in an altered reality are provided. Spending data includes items purchased, budgets for specific rooms or categories, prices paid, dates of purchase, and amounts spent. The user may interact within the altered reality to manage spending and move budgets between rooms or categories.

Abstract: Embodiments of the present disclosure provide a method and an apparatus for opening a file, and an electronic device. Embodiments of the present disclosure receive the file opening request, obtain the format information of the file to be opened indicated by the file opening request, search for application information of the target application for opening the file to be opened according to the format information, provide the application entry of the target application in the current interface according to the application information, obtain the configuration file corresponding to the target application when the application entry is triggered, and generate the native interface of the target application according to the configuration file and open the file to be opened in the native interface.

Abstract: Provided are techniques for exploration and navigation of a content collection. A first window and a second window are created within the user interface displayed on the electronic display. A node graph visualization is displayed in the first window, wherein the node graph visualization comprises nodes representing individual content elements within the content, and wherein the nodes are clustered in proximity to each other according to topics associated with the individual content elements. A text-based topic visualization is displayed in the second window, wherein the text-based topic visualization comprises text elements representing topics associated with the individual content elements within the content. Selection is received of one or more text elements. Highlighting and zooming in is performed on a subset of nodes representing individual content elements associated with a union of the one or more text elements selected corresponding to the one or more topics of interest.

Abstract: An information processing apparatus includes an obtaining unit that obtains a number of times of data inputting required for each of plural input items to which operators are to input data and an input screen information generation unit that generates, for the operators on a basis of the obtained number of times of data inputting, input screen information to which the operators are to input data.

Abstract: Various systems and methods are described herein for an improved spreadsheet application that allows a user to generate, manipulate, and replicate data visualizations (e.g., sparklines, graphs, charts, etc.) using functions without importing data into cells of the application. For example, data is stored in one or more remote or local data stores accessible to the improved spreadsheet application. A user enters a function into a cell of the improved spreadsheet application. The improved spreadsheet application generates a query using the function, the query identifying a portion of a dataset to retrieve from the data store(s). The improved spreadsheet application then transmits the query to the data store(s) and retrieves the requested data. A renderer of the improved spreadsheet application then renders a sparkline using the retrieved data. The improved spreadsheet application displays the rendered sparkline in the cell in which the function was entered, or at another designated location.

Abstract: This disclosure describes techniques for intelligently grouping, ungrouping, collapsing, and/or expanding columns of data for effective presentation on a display screen. In one example, a method includes accessing, by a computing device, data organized into a plurality of columns, each column having one or more data characteristics; determining, by the computing device and based on at least some of the data characteristics of the columns, one or more column groups, each column group including a subset of the plurality of columns; determining, by the computing device and based on attributes of a window for presentation of the data, whether the plurality of columns will fit within the window; and in response to determining that the plurality of columns will not fit within the window, outputting a user interface presenting a column group as a single column within the window so that the plurality of columns fits within the window.

Abstract: A method prepares data for subsequent analysis. The method displays a user interface having a data flow pane, including a flow diagram having a plurality of nodes. Each node specifies one or more operations. The method receives user input to select an existing node in the flow diagram, receives user input to insert a new node into the flow diagram, and receives user input to select a first set of two or more columns of data values from a data set corresponding to the existing node. The method pivots the selected columns to form a modified data set having new rows and new columns. The user selects two or more additional columns, and the method pivots on the additional columns, resulting in a second new column added to the modified data set. Each data value from the additional columns is added to the second new column in a respective row.

Abstract: Disclosed and described herein are systems, methods and computer program products that enable converting a metafile to a spreadsheet file, editing the spreadsheet file, and then transforming the spreadsheet file back to an output metafile.

Abstract: An apparatus, computer-readable medium, and computer-implemented method for visualizing relationships between pairs of columns, comprising identifying a relationship classification corresponding to two columns in a plurality of columns based on a data type of each column in the two columns, applying one or more statistical measures to data in the two columns to generate association data quantifying a plurality of relationships between data values in a first column of the two columns and data values in a second column of the two columns, wherein the one or more statistical measures are determined based at least in part on the relationship classification, and transforming the association data into a visualization, wherein the visualization comprises one or more indicators corresponding to one or more relationships in the plurality of relationships and wherein a layout of the visualization is determined based on the relationship classification.

Abstract: Aspects of the present disclosure further provide the ability to define, among other features, the layout of the cell view of the cell in which the compound object is stored as well as the card view of the compound object. Aspects of the present disclosure further provide the ability to modify properties associated with the values stored in a compound object, including, but not limited to properties of calculated values, value formatting, and permissions.