Abstract: A first computer of a distributed computing system receives a request for a transaction. The transaction is an eXtended Architecture (XA) protocol based global transaction. The first computer generates a unique identifier for the request. The first computer sends the unique identifier to a second computer of the distributed computing system. The unique identifier enables the second computer to participate with the first computer as an XA protocol based resource participant.

Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

Abstract: Systems and methods for supporting metadata for work items stored in a web-based content management system with collaboration environment are disclosed. Users uploading work items to a folder are not required to provide metadata for the work items. Collaborators of the folder can provide metadata to work items within the folder.

Abstract: A system and method for storing and providing metadata. Metadata may be retrieved from multiple sources. The metadata is stored in facets in a repository and tagged to indicate one or more of the source, a time frame, or an associated data object. In response to receiving a request for metadata, a system selects metadata based on the specified object, source, or time frame. Access permissions corresponding to the requester are used to select and provide metadata for which the requester has permissions.

Abstract: Embodiments include an evaluator that can receive a query containing a predicate from an application executing on a client device. The evaluator can process the predicate using a tree structure containing nodes representing objects and edges representing relationships thereof. The processing can include applying filters to attributes of the relationships to identify a first set of objects relevant to the predicate and navigating along each incoming role of a relationship and from there via an outgoing role to other objects to identify a second set of objects relevant to the predicate. An object is relevant to the predicate if at least a value of a field of the object is equal or similar to a value of the predicate. Responsive to the query, the evaluator can return identifiers associated with a united set of the first set of objects and the second set of objects to the application.

Abstract: An item is determined to exist in a dataset by arranging the dataset into a plurality of subsets, each bounded by the minimum amount of memory that may be transferred between levels of memory in a memory configuration. The item and the subsets have attributes that allow for a determination of which subset the item would exist in if the item were in the dataset. A singular subset is transferred between levels of memory to determine whether the item exists in the transferred subset. If the item does not exist in the transferred subset, it is determined that the item does not exist in the dataset.

Abstract: Database management and security is implemented in a variety of embodiments. In one such embodiment, data sets containing sensitive data elements are analyzed using aliases representing sensitive data elements. In another embodiment, the sensitive data elements are stored in an encrypted form for use from a secure access, while the alias is available for standard access.

Abstract: A method and system for representing and deducing a multiplicity of predecessor relationships between a plurality of first objects and a second object in an OLAP system comprises configuring an extraction system to extract information for a plurality of sub-objects of the first and second objects and using the extracted information to deduce predecessor relationships between the first objects and the second object.

Abstract: The disclosure generally describes computer-implemented methods, software, and systems for providing a generic semantic layer for in-memory database reporting. One computer-implemented method for combining online transactional processing and online analytical processing in an in-memory database, comprises: retrieving two or more tables from an online transaction processing system; identifying related tables among the two or more tables; determining relationships between the related tables; determining a measure based on the relationships; and outputting the measure.

Abstract: Staging data record changes from a faster storage medium to a slower storage medium using data query rewriting is provided. In response to receiving a data query corresponding to a particular data record, it is determined whether the data query is one of a transactional data query or an analytical data query. In response to determining that the data query is a transactional data query, the transactional data query is rewritten to apply transactional delta changes to the particular data record on a storage-class memory of a computer. In response to determining that the data query is an analytical data query, the analytical data query is rewritten to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer.

Abstract: Staging data record changes from a faster storage medium to a slower storage medium using data query rewriting is provided. In response to receiving a data query corresponding to a particular data record, it is determined whether the data query is one of a transactional data query or an analytical data query. In response to determining that the data query is a transactional data query, the transactional data query is rewritten to apply transactional delta changes to the particular data record on a storage-class memory of a computer. In response to determining that the data query is an analytical data query, the analytical data query is rewritten to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer.

Abstract: A system for continuous analytics comprises an in-memory storage and a processor. The processor receives a query that indicates an analytic function to be performed on a combination of static data and real-time data. The processor loads the in-memory storage from a first source external to the processor with data that was stored as the static data. At the same time that the in-memory storage is already loaded with the static data, the processor continuously receives ephemeral real-time data as it is being generated by a second source external to the processor. The processor runs the analytic function from the query against the in-memory storage loaded with the first data and the real-time data that is being continuously received, in combination, to produce a result of the analytic function. The result is stored and time-stamped in the in-memory storage as an analytic cube.

Abstract: Various embodiments herein each include at least one of systems, methods, and software for table-form presentation of hierarchical data. Some such embodiments include aggregating a hierarchical dataset as it may be stored in several rows of each of one to many tables or other similar data storage structures, grouping data according to the hierarchy, and writing the data in hierarchical groups to a table structure.

Abstract: A computer system for managing a plurality of workloads executing on both a primary system and on a secondary system, and synchronizing both a plurality of software data and hardware data stored on the primary system with the secondary system is provided. The computer system may include receiving a region switch request and stopping the execution of the plurality of workloads on the primary system; suspending the replication of the plurality of software and hardware data stored on the primary system with the plurality of software and hardware data stored on the secondary system; and switching the replication of the plurality of software data and the plurality of hardware data that occurs from the primary system to the secondary system to occur from the secondary system to the primary system. The computer system may include activating the execution of and synchronizing the plurality of workloads on the secondary system.

Abstract: A temporal database system, method, and computer-readable storage medium in which a database is provided with sets of entities defined by initial tuples having a set ID, a unique timestamp, and a member increment. A write transaction is performed for sets of entities, wherein the write transaction designates the set by said set ID and produces an increment, wherein the increment is a number of entities to be added to or removed from the designated respective set of entities. New tuples including the set ID, the increment, and a new unique timestamp are created for the write transaction. Following the write transaction, an asynchronous compaction operation is performed on the new tuples. The compaction operation aggregates the increment of each new tuple into summary point counts. The compaction operation facilitates efficient queries without contention with write transactions.

Abstract: Providing diagnostics for a database system including at least one database, with the database system. The diagnostics include the following steps (not necessarily in the following order): (i) determining a contribution to system workload for each contributor of a plurality of contributors; and (ii) selecting a remedial action based, at least in part, upon the contributions to system workload of the contributors. The plurality of contributors are selected as one of the following: the plurality of data-base-related operations, or the plurality of database-related transactions.

Abstract: The problem of abuse of privileges at cloud-hosted service sites is addressed by associating each user, preferably across multiple cloud-hosted service sites, with an individual “suspiciousness” score that may vary over time as additional user actions are detected and evaluated. Knowledge of the user is employed to better analyze the appropriateness or acceptability of user actions on the site.

Abstract: A computer is programmed to compress data of a database in response to database modification language (DML) statements generated by on-line transaction processing (OLTP) systems. In several embodiments, data that is initially added to a database block is left uncompressed until a predetermined condition is satisfied, which happens infrequently (relative to OLTP transactions on the block). When satisfied, the computer automatically compresses all uncompressed data in the block, which increases the amount of unused space in the block. New data is thereafter added uncompressed to the partially compressed block, until satisfaction of a predetermined condition whereby the partially compressed block is again compressed, i.e. re-compressed. Adding of new data to a partially compressed block and its compression are repeated unless another predetermined condition is met, in response to which the block is not further re-compressed, thereby to recognize a limit on the benefit from compression.

Abstract: A data transformation system receives data from one or more external source systems and stores and transforms the data for providing to reporting systems. The data transformation system maintains multiple versions of data received from an external source system. The data transformation system can combine data from different versions of data and provide to the reporting system. As a result, external source systems that do not maintain data in a format appropriate for reporting systems and/or do not maintain sufficient historical data to generate different types of reports are able to generate these reports. The data transformation system can also enhance older versions of data stored in the system or exclude portions of data from reports. The data transformation system can purge older versions of data so that older data that is less frequently requested is maintained at a lower frequency than recent data.

Abstract: Techniques are described for managing aggregation of data in a distributed manner, such as for a particular client based on specified configuration information. The described techniques may include storing aggregated data values for an OLAP cube or other data structure in a distributed manner, such as in some situations in a distributed hash table. The aggregated data values to be stored may be generated in various manners, such as by performing multi-stage data manipulation operations—for example, a map-reduce architecture may be used, with a first stage involving the use of one or more specified map functions to be performed, and with at least a second stage involving the use of one or more specified reduce functions to be performed.

Abstract: In one embodiment, a method includes receiving a search query requesting first search results of a first object type. The search query includes an inner query requesting second search results of a second object type. The method includes accessing an inverted index of a data store corresponding to the second object type; retrieving the second search results requested by the inner query using the inverted index of the data store corresponding to the second object type; accessing a forward index of the data store corresponding to the second object type; retrieving the first search results requested by the search query using the second search results and the forward index of the data store corresponding to the second object type.

Abstract: An open database-based far-distance bicentric online processing method and system are disclosed. The method comprising: capturing a database access related information of an online transaction from an APP server; automatically recognizing update statements and query statements according to SQL statements in the database access related information and a type of a storage process; and directing the update statements and the query statements to database servers of a primary center and a backup center respectively for operation. The present invention routes the query statements to the backup center to realize an open system ultra-far-distance bicentric transaction processing, thereby breaking the limitation of the 30 km distance of the IBM GDPC and ORACLE Rac technologies, improving the processing capacity and usability of the production system, and sufficiently utilizing the resources of the backup centers in the same city.

Abstract: The present disclosure involves computer-implemented methods, software, and systems for efficiently handling address data in business transaction documents. A computer-implemented method includes receiving a modification to address data associated with an existing address instance, receiving, using at least one computer, an indication of a modification type, creating a new snapshot instance, associating the modified address data with the new snapshot instance, retrieving a unique reference value for the new address snapshot instance, and associating the unique reference value identifying the new address snapshot instance with the address instance.

Abstract: A system and method for creating a unique alias associated with an individual identified in a health care database such that health care data, and particularly pharmaceutical-related data, can be efficiently gathered and analyzed. The system has a first data store for storing at least one record where each record includes a plurality of identification fields which when concatenated uniquely identify an individual, and at least one health care field corresponding to health care data associated with the individual. The system also has a second data store, and a processor. The processor selects a record of the first data store, then selects a subset of the plurality of identification fields within the selected record, and concatenates the selected subset of identification fields. Then the processor stores the concatenated identification fields in a record in the second data store with the at least one health care field from the selected record of the first data store.

Abstract: Various embodiments of systems and methods for communicating with a plurality of remote systems are described herein. A remote data query is sent from a central data requesting system to remote systems. A query result is received asynchronously from at least one of the remote systems. The remote systems may include data pools which are independent of each other. In one embodiment, the remote systems include a responsive remote system and an unresponsive remote system, and the query result is received from the responsive remote system. In one embodiment, a predetermined timeout period is set at the central data requesting system and the query result obtained after the pre-determined timeout period is ignored by the central data requesting system.

Abstract: A listing tune-up system is provided. An example listing tune-up system may include a detection module configured to detect a listing of an online listing system. The listing may comprise a presentation configuration. The tune-up system may also include a determining module configured to analyze content of the listing, and a generating module configured to generate a recommendation for the listing based on the analyzing of the content of the listing. The recommendation may comprise a modification to a presentation of the item listing. The modification may comprise modifying a textual presentation of text included in the content of the listing or including a suggested picture in the listing.

Abstract: During a search technique, indexes associated with user accounts of users that are using the communication application are opened in memory from a transactional key-value database. These indexes encompass messages (such as emails) communicated using the communication application, and each of the users has at least one separate, associated index. When a search query associated with a target user account is received from the communication application, a search based on the search query is performed by reading the associated index in the memory from the transactional key-value database without managing the index using a file system. Then, a result for the search query is returned.

Abstract: A system for managing drug labeling information includes a repository comprising a network accessible database, the repository having an upload portion and a download portion, the repository being accessible to a plurality of users via client computers coupled to a wide area network. The repository includes drug labeling information on a plurality of drugs stored therein. The upload portion of the repository is accessible by a first set of users while the download portion of the repository is accessible by a second set of users. In one preferred aspect of the invention, drug manufactures are able to upload new or revised PDF files containing drug labeling information. The new or revised PDF files are then available for download by pharmacists or other authorized users.

Abstract: A method is provided in one example and includes generating a query for a database for information stored in the database. The information relates to data discovered through a capture system. The method further includes generating an Online Analytical Processing (OLAP) element to represent information received from the query. A rule based on the OLAP element is generated and the rule affects data management for one or more documents that satisfy the rule. In more specific embodiments, the method further includes generating a capture rule that defines items the capture system should capture. The method also includes generating a discovery rule that defines objects the capture system should register. In still other embodiments, the method includes developing a policy based on the rule, where the policy identifies how one or more documents are permitted to traverse a network.

Abstract: The present disclosure provides a method of statistical application in an OLTP environment to reduce the intensive computational load of invoking SQL statements for statistical calculations. The method introduces a time element into statistical records, and use the time element to determine the time status of previously computed statistical records. Upon receiving a query for a statistical record, the system first searches for an existing copy of the statistical record, and checks the time status of the statistical record if found. The system sends the statistical record to the inquirer if the record exists and is unexpired, and invokes an SQL statement to compute the statistical record only if the record does not exist or has expired. The statistical records may be placed in statistical table in a database and/or a cache of an application server. The disclosed strategy may also increase attack resistance of the system.

Abstract: According to some embodiments, a database, containing entries, may be stored across first and second storage medium, entries in the second storage medium being default invisible for online transactional processing. A central software layer processor between the database and an application may identify a subset of the entries stored in the first storage medium as being default visible for online transactional processing, wherein entries stored in the first storage medium that are not within the subset are default invisible for online transactional processing. Note that entries in the first storage medium may be accessible by the application more quickly as compared to entries in the second storage medium.

Abstract: A server includes a data processing module with executable instructions executed by a processor to produce a first inferred data type from first received data and a second inferred data type from second received data. The first inferred data type is utilized to augment the first received data with computed values that aggregate the first received data along a first hierarchical dimension. The second inferred data type is utilized to augment the second received data with computed values that aggregate the second received data along a second hierarchical dimension. The first hierarchical dimension and the second hierarchical dimension are harmonized to a lowest common unit value. A first visualization of the first received data is provided based upon the lowest common unit value. A second visualization of the second received data is provided based upon the lowest common unit value.

Abstract: A computer readable storage medium includes executable instructions to store load data in new rows of an append only table within a data warehouse, without updating or deleting existing rows in the append only table. The new rows are added in a database transaction that guarantees that the distributed reads and writes of all transactions are processed reliably and that the transactions obey snapshot isolation rules. Data changes associated with the load data are maintained in a separate update table. Data from the append only table is merged with data changes from the update table to supply read data.

Abstract: A data warehouse incorporates processing for creating, managing, and otherwise maintaining master data. The data warehouse may communicate with a master data manager to obtain services for handling master data. A surrogate master data identifier may be defined by the data warehouse to reference the master data, thereby decoupling any modifications of the master data identifier that may be made by the master data manager. The data warehouse may export the master data to an application system, and conversely import master data from an application system.

Abstract: Transactional data accesses are performed in a data storage system, where the data storage system is configured to store a plurality of data objects identified by respective key values. A request is received to modify the value of a particular data object. The request specifies a modified object value and a key value identifying the data object to be modified. In response to the request, a transactional data object is created, the transactional data object specifying a transaction identifier, the original object value and the modified object value. The transactional data object is stored in the data storage system, and associated with the key value.

Abstract: A live dual audit system and recorder method validating and independently verifying element effort event data, assigning audit levels to element effort reports displaying audit level icons whether effort event data is submitted by effort owner or generated by the system's dynamic method, and whether the effort is acknowledged by the project owner. A semi-automated first audit examines repository auditor input effortology decisions against provided effort exhibit data. A fully automated second audit examines dynamically generated system effort data against repository data. A DVIVD event data match audit recorder displays real time dynamic dual audit test reports with each effort audit level movement, and indicates any element effort audit mismatch data system location. An element's audited effort dataset level is displayed in the DVIVD event data match audit recorder until all dataset requirements are fulfilled and satisfy that element's highest audit level, and displays a “System Audit Certified” icon report.

Abstract: An integrated web-based dealership management system providing accounting, financial reporting, parts and service sales tracking, vehicle and parts inventory, vehicle sales tracking, and customer management software developed on a relational database on a web server and with web application tools.

Abstract: A database manager, computer program product and methods for managing a database utilized by multiple applications. In one embodiment, the database manager performs a database record change to database records by a first application. The database manager branches the database records such that the database record change is visible to the first application and is not visible to one or more other applications accessing the database. The database manager can merge database record changes made by the other applications such that database schema changes made by the other applications are visible to the first application.

Abstract: Disclosed is a flexible, multi-modal system useful in communications among users, capable of synchronizing real world and augmented reality, wherein the system is deployed in centralized and distributed computational platforms. The system comprises input devices to generate signals representing speech, gestures, pointing direction, and location of a user, and transmit the same to a multi-modal interface. A plurality of agents and one or more databases are integrated into the system, where at least some of the agents receive signals from the multi-modal interface, translate the signals into data, compare the same to a database, generate signals representing meanings as defined by the database, and transmit the signals to the multi-modal interface. Finally, a plurality of output devices are associated with the system to receive and process signals from the multi-modal interface, some of said signals representing messages to the user to be communicated by means of an output device.

Abstract: Described herein is a technology for providing enhanced transactional caching. In accordance with one aspect, a transactional cache associated with a database is configured. The enhanced cache may support write operation by partial key or index. Execution of a write operation on the database is delayed until a flush is determined to be necessary. The write operation is delayed by performing the write operation on the transactional cache. The flush is invoked by performing a row-wise bulk operation that updates the database based on the transactional cache.

Abstract: Described herein is a technology for providing enhanced transactional caching. In accordance with one aspect, a transactional cache associated with a database is configured. Execution of a write operation on the database is delayed until a flush is determined to be necessary. The write operation is delayed by writing to the transactional cache. The flush is invoked by writing inserted or updated records in the transactional cache to the database via a bulk operation.

Abstract: A distributed system with transaction support may have a transaction component and one or more data components. The transaction component may manage a transaction using a log sequence number for each operation, and then transmit operations to one or more data components with log sequence numbers. The data components may perform the data operations in an idempotent manner and return a reply. The transaction component may then write the operation, its log sequence number, and information from the reply message to its log. The transaction component is able to commit a transaction, as well as retry or undo portions of a transaction, by using the information stored on its log. This may be possible even when a single transaction uses multiple data components, which may be located on different devices or manage separate and independent data sources.

Abstract: A computer-implemented method for archiving information includes: executing a first application in a first process; determining that the first application is an archiving application configured to archive information stored in a transactional system; assigning, based on the determination, an archiving mode to the first process; receiving, from the first process and after assigning the archiving mode, a request to delete information; and processing the request to delete information according to the archiving mode.

Abstract: Approaches for processing an event in an objects store, such as an MySQL database management system or a memcached caching system, that are maintained on one or more solid state devices. A plurality of threads may be instantiated. Each of the threads may be configured to retrieve items from a queue of items. Each item in the queue of items may be associated with a particular event occurring within the object store. Each event is a message that indicates an activity requiring work has occurred within the object store. When a particular thread retrieves an item from the queue of items, the particular thread processes the particular event associated with the item retrieved by the particular thread. In this way, event handling in object stores such as MySQL and memcached may be performed more efficiently on a solid state device.

Abstract: A method of transaction processing includes receiving a plurality of transactions from an execution queue, acquiring a plurality of locks corresponding to data items needed for execution of the plurality of transactions, executing each transaction of the plurality of transactions upon acquiring all locks needed for execution of each transaction, and releasing the locks needed for execution of each transaction of the plurality of transactions upon committing each transaction. The plurality of transactions have a specified order within the execution queue, the plurality of locks are sequentially acquired based on the specified order of the plurality of transactions within the execution queue, and an order of execution of the plurality of transactions is different from the specified order of the plurality of transactions within the execution queue.

Abstract: An apparatus is provided that includes a processor and a memory storing executable instructions that in response to execution by the processor cause the apparatus to at least perform a number of functions. The apparatus is caused to direct presentation of a list for a plurality of patients and that is clustered by patient. The apparatus is caused to apply a keyword filter to identify a subset of the patient exams that match the keyword filter, and rank the respective exams by relevance to the keyword filter. The apparatus is caused to direct presentation of a filtered list of patient exams that is clustered by patient in the filtered list of patient exams. And for each patient having patient exams in the subset of the patient exams, the respective patient exams are in ranked order in the filtered list of patient exams according to the keyword filter.

Abstract: According to one embodiment of the present disclosure, a method and technique is disclosed for maintaining a network connection during transfer of the workload from a global environment of a logical partition to a workload partition of the logical partition and during any subsequent transfer(s).

Abstract: The present disclosure provides a method of statistical application in an OLTP environment to reduce the intensive computational load of invoking SQL statements for statistical calculations. The method introduces a time element into statistical records, and use the time element to determine the time status of previously computed statistical records. Upon receiving a query for a statistical record, the system first searches for an existing copy of the statistical record, and checks the time status of the statistical record if found. The system sends the statistical record to the inquirer if the record exists and is unexpired, and invokes an SQL statement to compute the statistical record only if the record does not exist or has expired. The statistical records may be placed in statistical table in a database and/or a cache of an application server. The disclosed strategy may also increase attack resistance of the system.

Abstract: A system and method for retrieving and normalizing product information is described. The system may collect product information from suppliers. The product information may relate to a product that is described differently by two or more of suppliers. The system may further provide a normalized representation of the product.

Abstract: The present invention is directed to an information management system. The information management system has a web server 110 and a database server 120. The database server 120 includes a business card information database 121, a relation database 122 and a user database 123. Therefore, by the present invention, a user distributes the business card information to designated receivers and the receiver transfers the business card information to the selected senders from the identified senders.