Abstract: Various systems, processes, and products may be used to manage remote data replication. In particular implementations, a system and process for managing remote data replication may include the ability to store versions of a disk at a first site, a second site, and a third site. The version of the disk at the first site may store input/output for a host system, the version at the second site may be a synchronous replication of the version at the first site, and the version at the third site may be an asynchronous replication of the version at the first site. The system and process may also include the ability to synchronize the version at the first site with the version at the third site if the second site is unavailable and synchronize the version at the second site with the version at the third site if the first site is unavailable.

Abstract: Various systems, processes, and products may be used to manage remote data replication. In particular implementations, a system and process for managing remote data replication may include the ability to store versions of a disk at a first site, a second site, and a third site. The version of the disk at the first site may store input/output for a host system, the version at the second site may be a synchronous replication of the version at the first site, and the version at the third site may be an asynchronous replication of the version at the first site. The system and process may also include the ability to synchronize the version at the first site with the version at the third site if the second site is unavailable and synchronize the version at the second site with the version at the third site if the first site is unavailable.

Abstract: A computer-implemented method for determining a query execution plan based on transaction state may include determining that a first set of database values in a database table are in a committed transaction state and that a second set of database values in the database table are in an uncommitted transaction state. In response to the determining, the first set of database values may have a first set of statistics generated and the second set of database values may have a second set of statistics generated. The first and second set of statistics may be for use in determining a query execution plan.

Abstract: A distributed storage system called StorFS that performs distributed data deduplication is described. In an exemplary embodiment, a storage controller server determines if there is duplicative data in a distributed storage system. In this embodiment, the storage controller server determines if an entity is duplicated in the distributed storage system in line with an incoming input/output operation. The storage controller server determines if the entity is duplicated in the distributed storage system by receiving the entity and looking up the entity in a data deduplication table. If the entity exists in the data deduplication table, the storage controller server updates the metadata for the entity to point to the duplicate entity.

Abstract: The MULTI-SOURCE, MULTI-DIMENSIONAL, CROSS-ENTITY, MULTIMEDIA ANALYTICAL MODEL SHARING DATABASE PLATFORM APPARATUSES, METHODS AND SYSTEMS (“AMSDB”) transform data aggregated from various computer resources using AMSDB components into updated entity profiles and/or social graphs. In one implementation, the AMSDB aggregates data records including search results, purchase transaction data, service usage data, service enrollment data, and social data. The AMSDB identifies data field types within the data records and their associated data values. From the data field types and their associated data values, the AMSDB identifies an entity. The AMSDB generates correlations of the entity to other entities identifiable from the data field types and their associated data values. The AMSDB also associates attributes to the entity by drawing inferences related to the entity from the data field types and their associated data values.

Abstract: Techniques for query optimization for group-by extensions and distinct aggregate functions are provided. A query has an extended group-by clause with an extended group-by operator and a first set of group-by columns. The query has one or more distinct aggregate functions and one or more non-distinct aggregate functions. An initial subquery is constructed that generates a partially aggregated initial temporary (PAIT) table when executed. The initial subquery includes a GROUP BY clause with a second set of group-by columns that includes the first set of group-by columns of the extended group-by clause of the query and one or more columns specified by the one or more distinct aggregate functions. One or more subqueries are computed that compute groupings indicated by the extended group-by operator based on the PAIT table generated by the initial subquery.

Abstract: This disclosure is directed to automated methods and systems for calculating hard thresholds used to monitor time-series data generated by data-generating entity. The methods are based on determining a cumulative distribution that characterizes the probability that data values of time-series data generated by the data-generating entity violate a hard threshold. The hard threshold is calculated as an inverse of the cumulative distribution based on a user defined risk confidence level. The hard threshold may then be used to generate alerts when time-series data generated later by the data-generating entity violate the hard threshold.

Abstract: An approach is provided for a more efficient and user friendly mechanism for determining and presenting status updates associated with elements in a media item. The approach includes a method for processing and/or facilitating a processing of one or more media items to determine one or more elements present in the one or more media items. The method further includes determining a current status information associated with the one or more elements. The method also includes causing, at least in part, a presentation of one or more representations of the current status information.

Abstract: A data management apparatus is provided. In the data management apparatus, a real-time database stores data collected from a power system; a power system data recording (PSDR) server reads and stores data stored in the real time database and creates policy data and a data file on the basis of the stored data and a PSDR history file storage unit backs up data processed by the PSDR server.

Abstract: Technologies are described herein for executing queries expressed with reference to a structured query language against unstructured data. A user issues a structured query through a traditional structured data management (“SDM”) application. Upon receiving the structured query, an SDM driver analyzes the structured query and extracts a data structure from the unstructured data, if necessary. The structured query is then converted to an unstructured query based on the extracted data structure. The converted unstructured query may then be executed against the unstructured data. Results from the query are reorganized into structured data utilizing the extracted data structure and are then presented to the user through the SDM application.

Abstract: A method and system for fuzzy full text search is disclosed. The system includes an inverted index where tokens are organized in a Next Valid Character (NVC) tree. Each path through the tree defines a token. The document lists for the tokens are stored at leaf nodes. When performing a fuzzy full text search, the system uses an edit distance greater than zero. After receiving search tokens, the system traverses the NVC tree to generate document error lists. The system then compares the error lists to identify relevant document identifiers and provides a result set.

Abstract: Various embodiments may be generally directed to techniques and an apparatus to generate a plurality of rate indices from the historical rate information for one or more products, each of the rate indices associated with a different lead time, and determine a rate index from the plurality of rate indices associated with an optimal lead time based on a maximum correlation between the rate index and a reputation index, the reputation index based on the historical reputation information for the one or more products. In addition, a multiple linear regression model comprising one or more parameters may be generated using the rate index, the reputation index, and one or more indicator values, the multiple linear regression model may be used to determine a reputation impacted rate for a product.

Abstract: A method for storing XML data into a relational database, including the following steps: splitting an XML Schema into one or more mapping configuration files, each mapping configuration file corresponding to a relational database table; parsing an XML text, and according to the associative relationship in the mapping configuration files, inserting the data in the XML text into the multiple relational database tables; and accessing the database to read the data in the XML text. The method stores XML file data into a relational database, and accelerates data reading and access speed.

Abstract: Techniques are presented herein to monitor a plurality of big data sources in order to dynamically identify keywords. The big data sources are analyzed to classify the keywords as related to either a technical problem or to a solution to the technical problem. In addition, data associated with the keywords is weighted based on one or more attributes of the data and stored in a database in a problem-solution format.

Abstract: Data entities in a client-server system are accessed. The client-server system comprises a set of clients, a server system, and a repository for storing a plurality of data entities. The server system comprises an inter-transactional cache, the inter-transactional cache being accessible for each client of the set of clients. A first client of the set of clients comprises a first intra-transactional cache. If a copy of a first data entity is in the inter-transactional cache, a version identifier of the original first data entity is read from the repository. If the copy of the first data entity is to be accessed with an exclusive lock, a copy of the copy of the first data entity is added to the first intra-transactional cache. The copy of the copy of the first data entity in the first intra-transactional cache is accessed for further processing of the first data entity by the first client.

Abstract: A computer-based system and related method are provided for migrating data associated with a website from a first Web content management (WCM) platform to a second WCM platform. The data migrated can include templates, user and group data files, content files (media, texts and others), workflows, authorizations, among others. The system and related method can further include a transformation capability that enables modifications to website data elements during migration, including but not limited to templates, HTML, users, metadata, file assets, and content such as images, links, and text during migration. In this manner, web administrators can modify the website design during migration to a new WCM platform within an integrated process.

Abstract: The disclosed computer-implemented method for efficiently extracting contents of container files may include (1) receiving a container file that includes (a) an additional container file that includes (i) a constituent file and (ii) metadata of the constituent file and (b) metadata of the additional container file, (2) creating, before the constituent file is extracted from the additional container file, a content hierarchy for the container file that includes (a) the metadata of the constituent file, (b) hierarchical metadata that indicates that the container file includes the additional container file, and (c) additional hierarchical metadata that indicates that the additional container file includes the constituent file, (3) querying, after the content hierarchy is created, the content hierarchy to locate the constituent file within the additional container file, (4) extracting the constituent file, and (5) performing an action on the constituent file.

Abstract: An example process for selecting chart scalings for plotting two time-series datasets includes determining a first log difference between a logarithm of a maximum value of a first dataset and a logarithm of a minimum value of the first dataset. The process also includes determining a second log difference between a logarithm of a maximum value of a second dataset and a logarithm of a minimum value of the second dataset. The process also includes selecting, based at least in part on the first and second log differences, between a linear chart scaling and a logarithmic chart scaling for the first dataset. The process also includes selecting, based at least in part on the first and second log differences, between a linear chart scaling and a logarithmic chart scaling for the second dataset.

Abstract: A method and apparatus for presenting a search result. The method comprises: receiving a current search term input by a user; determining user information about a user, and determining a pre-established first model corresponding to the user according to user information, the first model recording historical data of the user, and the historical data comprising a historical search term and a corresponding historical selection result; determining, in the historical data, a historical search term matched with the current search term, determining a historical selection result corresponding to the matched historical search term, and determining an online recommendation result according to the historical selection result; and presenting a search result to the user, the search result comprising the online recommendation result or a result obtained by processing the online recommendation result. The disclosed method can provide a personalized search service, so that the search result better meets the user's needs.

Abstract: An approach for joining operations on document-oriented databases. The approach consists of receiving database identifiers, common attributes and results attributes for core and target databases being joined. Common attributes are searched for in the databases. The searches performed include string, expansive, character and nested. Common attribute join conflicts are identified and input is received to resolve attribute join conflicts. Resolved join conflicts are updated in a join substitution database for subsequent use and joined data results are output to virtual table(s).