Abstract: A configurable application includes a domain model having one or more model entities. Representation entities provide representations of model entities and can include input definitions, output definitions, and structure definitions. Input definitions can define a grid having cells that can be bound, based on states, to various model entity attributes.

Abstract: A cloud-centric platform is used for generating virtual three-dimensional (3D) content, that allows users to collaborate online and that can be connected to different software tools (applications). Using the platform, virtual environments (e.g., scenes, worlds, universes) can be created, accessed, and interacted with simultaneously by multiple collaborative content creators using varying content creation or development applications.

Abstract: An enhanced user experience is disclosed herein that provides for gesture-based configuring of pivot tables. In various implementations, a pivot table includes query areas associated with fields of a data table being summarized by the pivot table. Gestures made with respect to an area of the pivot table drive changes in the association of the fields of the data table with the query areas of the pivot table. As user input is received with respect to an area of the pivot table, relevant fields are identified, and new associations are made between the query areas and the fields. The pivot table may then be updated accordingly based on the new associations.

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: Maintaining cardinality of rows while joining worksheets from a database including receiving a request to join, to a first worksheet, a second worksheet from the database; for each row in the first worksheet: generating a join row for data from the second worksheet on the database; in response to determining that there is at least one matching row in the second worksheet on the database: compare a maximum value and a minimum value for each column in each row of the at least one matching row; if the maximum value and the minimum value match, store a matching value in a corresponding column of the join row; and if the maximum value and the minimum value do not match, store a multiple value indication in the corresponding column of the join row; and presenting the join row adjacent to a corresponding row in the first worksheet.

Abstract: The present disclosure involves systems, software, and computer implemented methods for automatically identifying table locations and table cell types of located tables. One example method includes receiving a request to detect tables. Features are extracted from an input spreadsheet and provided to a trained table detection model trained to predict whether worksheet cells are table cells or background cells and to a cell classification model that is trained to classify worksheet cells by cell structure type. The table detection model generates binary classifications that indicate whether cells are table cells or background cells. A contour detection process is performed on the binary classifications to generate table location information that describes at least one table boundary in the spreadsheet. The trained cell classification model generates a cell structure type classification for each cell that is included in a table boundary generated by the contour detection process.

Abstract: A system to generate a chart recommendation based on machine understanding of spreadsheet data, including a memory and a processing device coupled to the memory to identify a set of data that each include content of a cell of one or more cells in a column of a spreadsheet presented to a user of a user device; add, to metadata of the cell, an annotation associated with an entity type representing the semantic meaning of the data in the cell; determine, based on the annotation, an entity type representing a semantic meaning of the set of data in the column; identify at least one of a plurality of charts that is relevant to at least one of the entity type associated with the column, a user device characteristic associated with the user device, or a user class characteristic; and provide the identified chart for presentation to the user.

Abstract: In some embodiments, apparatuses and methods are provided herein useful to validating migrated data. In some embodiments, there is provided a system for validating migrated data including a control circuit configured to migrate data from a first database platform to a second database platform and validate the migrated data. The control circuit configured to transmit a message indicating a mismatch in response to a determination that a first single aggregated hash value does not match with a second single aggregated hash value.

Abstract: Editing and sharing spreadsheets of a spreadsheet editor system are disclosed. Interactions pertaining to requests of users of the spreadsheet editor system may be treated via natural language queries that are received at an interface of said system. When a first user attempts to share a spreadsheet with a second user, various spreadsheet filtering techniques may cause a new version of the given spreadsheet to be generated for the second user depending on permissions and metadata of one or both users of the editable spreadsheet system. References of the second user may additionally be used to modify a spreadsheet for viewing by the second user.

Abstract: Systems, methods, and computer-readable storage devices are disclosed for improved table identification in a spreadsheet. One method including: receiving a spreadsheet including at least one table; identifying, using machine learning, one or more classes of a plurality of classes for each cell of the received spreadsheet, wherein the plurality of classes include corners and not-a-corner; and inducing at least one table in the received spreadsheet based on the one or more identified classes for each cell of the received spreadsheet.

Abstract: A method of data input via a user interface is described. According to the method, a set of input fields may be provided at the user interface which correspond to respective columns or to respective rows of a data table. A data input may be received at the user interface within an input field of the set of input fields which corresponds to a first column or to a first row of the data table. An applicability indication may then be received at the user interface which indicates that the data input is applicable to a subset of the rows or a subset of the columns. Based on receiving the data input within the input field and based on the applicability indication, multiple instances of the data input may be applied to the data table.

Abstract: The present invention relates generally to the field of wearable devices and transaction banking and more particularly to a smart wearable contact lens (4) based wireless (3) transaction system and method thereof which has capability to works at both point of sale (PoS) system (2) and/or at automated teller machine (ATM) (1) centers for our purchases as well as for ATM transactions. Accordingly, an aspect of the present invention is to a smart wearable contact lens having encapsulated circuitry (304) for wireless communication like NFC, WiFi (Wireless Fidelity), Bluetooth, RFID and other short-range wireless communication technologies, VLSI chip, sensors like iris scanner and transceiver which is embedded in the smart wearable contact lens to initiate/perform at least one transaction.

Abstract: Linking data sets, including receiving a selection of a first column of a first data set related to a second column of a second data set; in response to the selection, generating a query based on a relationship between the first column of the first data set and the second column of the second data set; and presenting a third data set based on a response to the query.

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.