Abstract: A search key is generated (S20). A key relationship array is transmitted (S11). If an element matching the key relationship array is present, the found search key is held (S21). A key relationship index is transmitted (S22). A record read out using the key relationship index is transmitted (S12). If the record matches the search key, the found search key is held (S23). The found search key is set for an empty element of the key relationship array and is transmitted (S24). A data array is transmitted (S13). If an element matching the data array is present, the found data is held (S25). A data index is transmitted (S26). A record read out using the data index is transmitted (S14). If the record matches the search key, the found data is held (S27). Desired data is set for an empty element of the data array and is transmitted (S28).

Abstract: The present disclosure involves systems, software, and computer implemented methods for processing correlated calculated fields in correlated subqueries. One example method includes receiving a request to process a database query that includes at least one subquery and processing each subquery. A determination is made as to whether each subquery includes a correlated calculated field that is a calculated field that is not included in a first datasource queried by the subquery but is included in a second datasource queried by an outer query that includes the subquery. If the subquery does not include a correlated calculated field, the subquery is processed without modification. If the subquery includes a correlated calculated field, metadata is retrieved for the outer query of the subquery that queries the second datasource and includes the correlated calculated field. The subquery is rewritten using the metadata and the rewritten subquery is processed.

Abstract: Technologies are provided for dynamically reconfiguring a database system of a tenant that is part of a multi-tenant database system based on risk profile(s) of the tenant. The database system includes database and an application server of the tenant. When a request is received from a client of the tenant, a database transaction having one or more query language patterns can be automatically detected. Query language pattern(s) can be automatically associated with a corresponding transaction category for that tenant, and a corresponding risk profile for that tenant can be determined based on the corresponding transaction category. Based on the corresponding risk profile, it can be determined if a dynamic reconfiguration process should be performed, and if so, system parameter(s) of the database system can be dynamically reconfigured to take action(s) to address one or more risks associated with the corresponding risk profile.

Abstract: An apparatus comprises at least one processing device comprising a processor coupled to a memory. The at least one processing device is configured to simulate a first data set stored in a first database to create a second data set, wherein the second data set maintains one or more query impacting characteristics of the first data set such that performing a query on the second data set yields a performance result similar to another performance result that would occur when the query is performed on the first data set. The at least one processing device is further configured to load the second data set into a second database, and then perform the query on the second data set stored in the second database to obtain the performance result.

Abstract: A method for database syncing is provided. The method includes receiving database change indicators indicating changes to a database. For each database change indicator, the method also includes determining whether the respective change to the database corresponds to a single change to a single version of the database, one of multiple changes to a common version of the database, or one of multiple changes to different versions of the database. The method further includes generating a change log compaction data structure comprising entries. Each entry includes an exact entry defining a corresponding single change to a corresponding single version of the database, a range entry defining corresponding multiple changes to a corresponding common version of the database, or an interval entry defining corresponding multiple changes to corresponding different versions of the database.

Abstract: Systems and methods for processing data are provided. The system may include at least a processor and a non-transient data memory storage, the data memory storage containing machine-readable instructions for execution by the processor, the machine-readable instructions configured to, when executed by the processor, provide an information delivery platform configured to: extract raw data from a plurality of source systems; load and store the raw data at a non-transient data store; receive a request to generate data for consumption for a specific purpose; In response to the request, select a set of data from the raw data based on a data map; transform the selected set of data into a curated set of data based on the data map; and transmit the curated set of data to a channel for consumption.

Abstract: A method for parsing log data according to an embodiment of the present disclosure includes loading a plurality of unit logs identified by first parsing log data into a memory in a two-dimensional matrix, wherein the unit log includes a plurality of items and constitutes one row, determining a target item to be second parsed among the items loaded into the memory, dividing data of the target item into a plurality of sub-items by second parsing the data of the target item, among the items loaded into the memory in the two-dimensional matrix and storing a second parsing result including the plurality of sub-items.

Abstract: Systems and methods for presenting information, messages, sound recordings and video to a user via content cards embedded in a software application includes generating content card data sets at the time that the software application is started and run. The software application requests content card data sets upon startup, and a data service then generates content card data sets at that time. The software application uses the newly created content card data sets to display information, messages, images, sound recordings and video to a user within the embedded contact cards.

Abstract: A method and system are disclosed for ontology-based dynamic learning and knowledge integration from measurement data and text. A method and system are disclosed for inferring relationships between entities and entity states from data, text and users inputs and for actively searching, integrating, visualizing and comparing relations to extract domain-specific knowledge.

Abstract: Techniques and mechanisms described herein provide for global deduplication in a cloud-based storage system. According to various embodiments, a global segment reference map can be created for data segments when a data segment has not been previously added to the global segment reference map. For each data segment not added to the global segment reference map, those data segments can be deleted from a cloud storage location.

Abstract: A first request to initiate a memory access transaction is received by a processing device of a memory sub-system from a host system. One or more host data items are received from the host system. The one or more host data items are stored in a memory buffer residing on a volatile memory device of the memory sub-system. In response to an initiation of one or more operations to commit the memory access transaction, the one or more data items are migrated from the memory buffer to a persistent memory device.

Abstract: Systems and methods for determining a heath status of a patient through an automated interview. One of the systems include one or more computers in one or more locations and one or more storage devices storing instructions that, when executed by one or more computers, cause the one or more computers to perform operations including: providing, to a user interface of a user device, questions for a user to respond to in an interactive manner, in which each of the questions following the first questions is adaptive based on the user's response to one or more of the previous questions; capturing motion and appearance of the user in a video sequence while the user is responding to the questions; and analyzing the motion of the user in the video sequence to determine one or more indications of a disease or of a change in a disease progression.

Abstract: A method for adding dimensions to a visual representation is disclosed. In one embodiment, such a method obtains a data set containing data in a plurality of rows and columns (i.e., dimensions). The method divides the dimensions into a plurality of groups and determines a coordinate system for each group. For each row in the data set, the method determines data points for each group in the corresponding coordinate system. The method then connects the data points for each row with lines to create a visual representation for the data set. In certain embodiments, each group in the data set utilizes a two-dimensional coordinate system. In other embodiments, each group in the data set utilizes a three-dimensional coordinate system. In yet other embodiments, a mix of two-dimensional coordinate systems and three-dimensional coordinate systems are used. A corresponding system and computer program product are also disclosed.

Abstract: One example method includes identifying a column of a table, and the column includes multiple entries, setting a proposed uniqueness for the column, setting a confidence tolerance for the proposed uniqueness, estimating a sub-sample size for the column based on the proposed uniqueness and the confidence tolerance, based on the sub-sample size, sampling a subset of the entries in the column and, based on the sampling, determining whether or not the column is a primary key for the table.

Abstract: A method includes receiving a data reconciliation request requesting data reconciliation for a first dataset and a second dataset. The method also includes obtaining the first dataset including one or more dimensions each having a plurality of dimension members and obtaining the second dataset including one or more dimensions each having a plurality of dimension members. For each dimension of the first dataset, the method includes obtaining a bridge member that associates the respective dimension of the first dataset with a dimension of the second dataset. The method includes generating a first and second set of combination dimension members and refreshing the first and second set of combination dimension members using an execution delimiter value. The method includes generating, using the refreshed first and second set of combination dimension members, a third set of combination dimension members to generate a data reconciliation report.

Abstract: Embodiments of the invention relate to generating backups of applications. The user or administrator that monitors the backup is notified of those files and/or folders that have not been backed up in the most recent backup. Further, embodiments of the invention enable alerts to be initiated when a particular file or folder has not been backed up over multiple backups or over a predetermined period. As a result, the user or administrator can have a better understanding of the protection and lack of protection that the present backups are providing.

Abstract: A device, system, and computer implemented method for storing segmented data in a computer memory, the segmented data indicating which of a plurality of entities belong to which of a plurality of segments, each segment accommodating entities sharing a single binary characteristic. A computer receives a list of entity identifiers selected from a sequence of entity identifiers, each entity identifier in the list representing an entity which belongs to a segment; the computer uses the list to create a bitmap in which each bit has a bit position in a bit sequence corresponding to the sequence of entity identifiers. The state of each bit indicates whether the entity identifier representing that position in the sequence identifies an entity belonging in the segment or not; and the bitmap is stored in a memory in association with a segment identifier, as the segmented data.

Abstract: A method for delivering multimedia content during a communal session at a media system commutatively coupled with a streaming application. The method includes authenticating access to multimedia content for user devices participating in a communal session, receiving a first recording from a first user device, the first recording being generated from a first set of cameras of the first user device, receiving social media content generated the user devices, the social media content including a second recording generated simultaneously with the first recording on the first user device, the second recording being generated from a second set of cameras of the first user device, and synchronizing delivery of the first recording and the social media content by exchanging playback control messages with the streaming application to direct synchronized transmissions of the first recording and the social media content to the user devices.

Abstract: Generating a location-specific three-dimensional model in response to a location query can provide users with a better understanding of a location through providing better interactivity, better perspective, and better understanding of dimensionality. Generation of the models can be enabled by leveraging a three-dimensional asset database and segmentation methods. The location-specific models can provide further utility by further including situation specific simulated effects, such as simulated weather or traffic.

Abstract: Systems and methods include determination of first constraints on columns of database tables of a test tenant system based on metadata associated with the columns of database tables, determination of second constraints on the columns of database tables based on data stored in the columns of database tables of the test tenant system, identification of inconsistent data stored in columns of database tables of a plurality of tenant systems based on the first constraints and the second constraints, adding of records to the database tables of the test tenant system based on the identified inconsistent data, and execution of a test based on the database tables of the test tenant system including the added records.

Abstract: A cloud-native global file system used to provide primary file storage for enterprise data is augmented to provide “direct-to-cloud” (D2C) migration of an initial data set. In addition to providing a filer, the service provider configures a direct-to-cloud migration tool, typically as a downloadable virtual machine (VM), that is executed in association with the hardware of the enterprise filesystem whose data set is being migrated. The migration tool reads the existing filesystem, transforms the data into a format consistent with that done by a filer, and pushes the result (a single version) directly to an object store in the cloud. In a first pass (run), typically a large bulk of the data is moved and, depending on how the migration tool is configured, one or more additional passes may then be carried out. When migration is complete (or substantially complete), the filer then is activated to complete the migration (if need be) and take over the go-forward operations.

Abstract: Computer-readable media, methods, and systems are disclosed for database table partition pruning based on statistical information associated with non-partition columns. A tree partition specification is received defining partitions for a plurality of computed column statistics. Respective partitions are created for the plurality of computed column statistics based on the tree partition specification. A request is received to compute statistics for a plurality of columns of the plurality of computed column statistics to result in a plurality of computed column statistics. In response to determining that one or more modifications have been made to the partitioned database, the plurality of computed column statistics is marked as invalid. The computed column statistics are refreshed in response to modifications of the partitioned table. Thereafter, the statistics are marked as valid. Unnecessary table partitions are pruned based on the statistics, and the associated query is executed.

Abstract: A cloud-based data protection service is disclosed. In an embodiment, the data protection service may support backup of data sets from one or more sites associated with one or more organizations. In an embodiment, deduplication of backup data across multiple sites of an organization and/or multiple sites associated with different organizations may be supported. In an embodiment, backup data may be post-processed in the cloud to insert fingerprints corresponding to data blocks that did not change since a previous backup was performed, to scan the backup for security threats such as viruses, other malware, personally identifiable information, etc. In an embodiment, restore may be supported from the cloud, where restore blocks may be larger than backup data blocks. In another embodiment, restore may be based on blocks that have changed since the most recent backup (or a user-selected backup).

Abstract: A data analysis system includes a computer configured to set a selected column selected from a plurality of columns contained in a first data set and an attribute value range selected from a plurality of attribute values contained in the selected column; extract, from the first data set, a second data set corresponding to the selected column or to the selected column and the attribute value range; analyze the second data set; and display a data image provided by visualizing the second data set and an analysis result image provided by visualizing an analysis result of the second data set.

Abstract: Methods, systems, and apparatuses that enable a Service Layer (SL) to support analysis of internet of things (IoT) data and enable shared access to information generated by the analysis. An analytics management service may allow SL entities to configure analytics functions for many different IoT sources of data and organize the results in a customizable manner. The SL may support coordinating the analysis of IoT data from multiple independent sources and organizing the results of the analysis.

Abstract: A selective database rollback method includes identifying a table, identifying a root key, storing a target rollback date, retrieving schema information including keys, ordering the table, iterating over the table, storing the current table state, obtaining a transaction journal, and reverse-applying the transaction journal to generate an output file. A method or system for identifying database key includes iterating over a table's columns and rows, generating similarity metrics by comparing column-wise and/or row-wise data, and comparing the generated similarity metrics to a threshold value. A server includes a processor and a memory storing instructions that, when executed by the one or more processors, cause the server to identify a table, identify a root key, store a target rollback date, retrieve schema information including keys, order the table, iterate over the table, store the current table state, obtain a transaction journal, and reverse-apply the transaction journal to generate an output file.

Abstract: A distributed system responds to a request to enable restoration capability for a database instance by beginning a process for monitoring configuration changes made to a first operating environment of a first database instance. The system identifies a configuration change on which the database instance is dependent, and stores a record of the configuration change. The record is provided to a second operating environment. The second operating environment is configured, based on the record of the configuration change, to have configuration settings corresponding to the first operating environment as of the restoration point in time. The database instance is restored to the second operating environment.

Abstract: A method comprises storing a plurality of entity profiles; applying a predetermined first set of rules to a plurality of attribute-value pairs of the plurality of entity profiles; identifying a first set of entity profiles that satisfy the predetermined first set of rules; identifying a second set of entity profiles that satisfy the predetermined second set of rules; and updating a first attribute-value pair of the first and second sets of entity profiles by adding a first label to the first attribute-value pair responsive to determining the first set of entity profiles and the second set of entity profiles share a common entity profile.

Abstract: A system and method are disclosed associated with a cloud platform as a service provider. A monitoring agent, associated with a database service instance running on a client database virtual machine, periodically executes a performance throttling detection engine. The performance throttling detection engine gathers database statistics based on metrics and features of the database service using a rule-based approach. When it is determined that a pre-determined condition is met, the system may transmit the gathered database statistics to an external application. For example, the external application might comprise a database tuning service and the pre-determined condition may be associated with a decision that the database service may potentially need to tune knob configuration parameters (associated with memory knobs, background writer knobs, asynchronous knobs, etc.).

Abstract: A container group is created using a database deployment infrastructure (DI) administrator (HA). API privileges for the container group are granted, using the HA, to a container group administrator (GA). API privileges for a container created in the container group using the GA are granted, using the GA, to a container administrator (CA). API privileges for the container are granted, using the CA, to a container developer (CD). Schema privileges for the container are granted, using the CA, to a container consumer (CC). API privileges for the container group are revoked, using the HA, from the GA. The container group is dropped using the HA.

Abstract: A system and method is provided to selectively process and store tables of a relational database by calculating an overall data sensitivity score for each table based on predefined attribute rules; performing column-wise splitting of at least one of the tables into a first table and a second table based on the overall data sensitivity score of each table, thereby generating a total number of relational database tables; storing a first subset of the total number of relational database tables in a private cloud storage database in a distributed storage environment based on the overall data sensitivity scores of each of the total number of relational database tables; and storing a second subset of the total number of relational database tables in a public cloud storage database of the distributed storage environment based on the overall data sensitivity scores of each of the total number of relational database tables.

Abstract: Techniques described herein propose a ROWID Elimination Rewrite that uses functional dependencies to substitute and/or eliminate ROWID pseudo-columns referenced in a query in order to reduce memory pressure and speed up processing.

Abstract: A modular approach is provided for sensing and responding to detected activity or an event in a region that can be implemented quickly and easily using existing city infrastructure to establish a grid of sensors and detectors to provide localized or wide area coverage. The approach provides a turnkey solution or smart city in a box that can be adapted to different situations and needs to provide communications functionality and/or a desired or customized functionality for a wide range of different applications.

Abstract: A memory system has a controller (e.g., CPU, FPGA, or GPU) and recording segments in a non-volatile memory (e.g., a flash memory device) used by the controller to store data. The controller is configured to: maintain data write counters for the recording segments; select a first segment of the recording segments for recording data from a host system, wherein selecting the first segment comprises scanning the data write counters to identify a first data write counter corresponding to the first segment; receive, from the host system, data to be recorded by the non-volatile memory; and write the received data to the selected first segment.

Abstract: Enhanced metadata with optimized output. In an embodiment, a content object is received. First metadata to be associated with the content object is determined. At least one metadata field to be acquired is determined based on an association, within a stored knowledge structure, of the at least one metadata field with the first metadata. Second metadata to be associated with the content object is acquired based on the at least one metadata field. A metadata structure and markup format for the content object are determined. The metadata structure incorporates both the first metadata and the second metadata. The content object is output with the metadata structure and in the markup format.

Abstract: A method for vehicle maintenance at a service center is provided. A set of vehicular datasets for a set of vehicles, at a service center, is retrieved from a database. Based on the set of vehicular datasets, a service schedule for servicing the set of vehicles is determined. The service schedule is indicative of a first sequence for servicing the set of vehicles. The servicing of a first subset of the set of vehicles is initiated based on the first sequence. A progress of the servicing of the first subset of the set of vehicles is monitored based on status reports. Based on the monitored progress, the service schedule for a second subset of the set of vehicles is updated. Based on the updated service schedule, the servicing of the second subset of the set of vehicles is initiated based on a second sequence.

Abstract: A system or persistent table may be generated storing changelog information of a primary base table. The system table may then be used to create streams of relevant information. In some examples, the streams may read from the system table for information past a retention period of the primary table while reading from the primary table information in the retention period.

Abstract: A data processing system for discovering a semantic meaning of a field included in one or more data sets is configured to identify a field included in one or more data sets, with the field having an identifier. For that field, the system profiles data values of the field to generate a data profile, accesses a plurality of label proposal tests, and generates a set of label proposals by applying the plurality of label proposal tests to the data profile. The system determines a similarity among the label proposals and selects a classification. The system identifies one of the label proposals as identifying the semantic meaning. The system stores the identifier of the field with the identified one of the label proposals that identifies the semantic meaning.

Abstract: A technique for data sharing among multiple filers that share a volume in a private or public cloud object store is implemented. In this approach, a mechanism is provided to enable a local filer to determine whether other filers that are sharing the volume have a consistent view of new data being written to the cloud object store by the local filer. The begins by associating together a collection of one or more files in a “push class.” On demand, a push operation for the push class is initiated on the local filer. Preferably, the push is managed according to one or more push criteria associated with the push class. Typically, the push operation pushes file data and metadata associated with the one or more files of the push class in respective phases, with the file data being pushed to the cloud during a first phase and the metadata associated with that file data being pushed during a second phase that follows the first phase.

Abstract: Systems and methods for a bouncing replication protocol are described herein. The system can include a replication cluster including a plurality of servers and a master controller that can receive a first request to replicate a first transaction and execute a batching process to replicate the first transaction. The batching process can include selecting a first server for replication of the first transaction, determining that a pending acknowledgement from the selected first server has not been identified, adding the first transaction to a first batch for the first server, and sending the first batch including only the first transaction.

Abstract: Partial initial construction of a deferred object model. This is done using a map that correlates positions of a hierarchically structured definition and corresponding hierarchical positions within an object model. The map is accessed and used to initially construct a deferred object model that even leaves some of the deferred objects unpopulated. The map is used to determine which parts of the hierarchical object definition no longer need to be parsed in order to construct this initial form of the deferred object model. If a request for an object is detected at some point after the initial construction, and that requested object is not represented even in deferred form in the deferred object model, the system uses the map to find the position of the corresponding object definition in the hierarchical object definition. At that point, the system parses that position, and constructs the object.

Abstract: There is provided a system of generating a bitmap filter as part of a join operation. A query comprising a filter parameter is received and a first data source associated with the filter parameter is queried to identify an entry therein with an identifier corresponding to the filter parameter. Each entry of the first data source is identified by a corresponding identifier to differentiate the entries from one another. The system generates a bitmap filter corresponding to the filter parameter by identifying a single bit location in the bitmap filter that corresponds to an identifier of the entry corresponding to the filter parameter. Each identifier has a numerical value used to identify the bit location. A single bit location is assigned to the identifier and a bit is set at the assigned bit location such that there is one-to-one mapping between the identifier and the assigned bit location.

Abstract: A computer-implemented method for translating time between calendar systems is described herein. The method includes accessing a first tree structure for a first calendar system, where data corresponding to the first tree structure include time intervals for the first calendar system that are arranged into layers of nodes, and where the layers of nodes are mapped to universal time. The method also includes scheduling a calendar content item corresponding to a time fragment relative to the universal time. The method further includes translating the calendar content item to a first human-readable time fragment for the first calendar system by traversing the first tree structure corresponding to the first calendar system to convert the time fragment to the first human-readable time fragment based on the mapping of the layers of nodes of the first tree structure to the universal time.

Abstract: Generating semantic names for a data set is described. An example method can include retrieving data from a data set, the data organized in a plurality of columns. The method may also include generating one or more candidate semantic categories for that column, wherein each of the one or more candidate semantic categories has a corresponding probability for each of the columns. The method may also further include creating a feature vector for each column from the one or more column candidate semantic categories and the corresponding probabilities. Additionally, the method may also include selecting, for each column, a column semantic category from the one or more candidate semantic categories using at least the feature vector and a trained machine learning model.

Abstract: A power plant controlling method includes: receiving a beacon signal from a location beacon or a device information beacon, wherein the location beacon is mounted in a region of a power plant area requiring monitoring and controlling, the region including an employee circulation path, and the device information beacon is mounted at a device requiring identification; tracking a location of the beacon that transmitted the received beacon signal; and receiving information about devices within a radius set by a user based on the tracked location.

Abstract: Storage level query processing may be implemented for processing database queries. Nodes that can access a database may perform parallel processing for at least a portion of a database query. An indication may be received that specifies parallel processing for the database query. The nodes can then be caused to perform the portion of the query as part of providing a result in response to the database query instead of a node, such as a query engine node, that received the database query.

Abstract: A system and method for efficient query processing using multiple indices in a join operation are described. In one embodiment, a join query including a join operation on a first table and a second table and including a first condition and a second condition is received, wherein the first condition is based on a first index of the second table, and the second condition based on a second index of the second table; a first result set is determined by index scanning the second table using the first index as an index key; a second result set is determined by index scanning the second table using the second index as the index key; a third result set is determined by applying a set operation to the first result set and the second result set; and the third result set is provided in response to the join query.

Abstract: A database management system (DBMS) tracking system tracks location and status of DBMSs running on servers, for example, servers of an organization connected by a network. The DBMS tracking system periodically receives information describing servers from a directory service. The DBMS tracking system maintains a DBMS tracking table. The DBMS tracking system installs database agents on DBMSs. The database agents send tracking messages and status messages to the DBMS tracking system. The DBMS tracking system updates the information stored in the DBMS tracking table based on the tracking messages and status messages.

Abstract: A method for data provisioning a serverless computing cluster. A plurality of user defined functions (UDFs) are received for execution on worker nodes of the serverless computing cluster. For a first UDF, one or more data locations of UDF data needed to execute the first UDF are determined. At a master node of the serverless computing cluster, a plurality of worker node tickets are received, each ticket indicating a resource availability of a corresponding worker node. The one or more data locations and the plurality of worker node tickets are analyzed to determine eligible worker nodes capable of executing the first UDF. The master node transmits a pre-fetch command to one or more of the eligible worker nodes, causing the eligible worker nodes to become a provisioned worker node for the first UDF by storing a pre-fetched first UDF data before the first UDF is assigned for execution.

Abstract: A specification of a client-side user interface behavior for a view of a computer application is received from a representative of an organization. The received specification is stored. A request for content of the view is received via a network from the computer application associated with a user that belongs to the organization. The received specification is identified as being associated with the requested content of the view. The requested content of the view and an identifier of the identified specification of the client-side user interface behavior are provided via the network. The computer application utilizes the received identifier of the identified specification of the client-side user interface behavior to modify the view of the computer application.