Entries |
Document | Title | Date |
20100125546 | SYSTEM AND METHOD USING SUPERKEYS AND SUBKEYS - Systems and methods for providing aggregated transaction level data for a particular user to multiple information requesters are disclosed. Subkeys are assigned to user inquiries from multiple information requesters and a super key is assigned to those subkeys to link them to one or more user identifiers such as a username or Social Security number. Account level data is provided based on the super key and the user identifiers. Duplicate requests for aggregated transaction level data contained in the user inquiries can be deleted. User inquiry response files containing transaction level aggregate data can be sent to the information requesters based on the assigned subkeys. | 05-20-2010 |
20100125547 | Transaction Aggregator - Systems and methods for determining and reporting aggregated transaction level data regarding a particular user are disclosed. Based on the requests of one or more information requesters, an aggregator server can request transaction level data for all accounts associated with a particular user or a group of users from a transaction database. The transaction database returns raw transaction level data for accounts associated with the particular user to the aggregator server. The aggregator server can then parse the raw transaction level data based on a number of transaction level data elements and information requester input. The parsed raw transaction level data can then be used to determine the number of predefined or information requester defined transaction level data aggregates. The resulting transaction level data aggregates can then be sent in a report to the one or more information requesters. | 05-20-2010 |
20100169268 | SYSTEM AND METHOD OF SECURING AND AUTHORIZING MULTIDIMENSIONAL TRANSACTIONAL DATA - In one embodiment the present invention includes a system for securing and authorizing access to multidimensional transactional data. The system includes online analytical processing (OLAP) system and a database system. The OLAP system accesses a selection of multidimensional transactional data from the database system according to a multidimensional request. The OLAP system aggregates the selection to form aggregated information. The OLAP system filters the selection according to the authorization for the user, to form a filtered selection. In this manner the user can see accurate aggregations yet not see unauthorized data. | 07-01-2010 |
20100198779 | DATA PROCESSING SYSTEM AND METHOD FOR SUPPLY CHAIN MANAGEMENT - The data processing system has an online transactional processing (OLTP) system for receiving of reporting data from work centers of a production line. The production line is logically divided into shop areas. At the exits of each shop area where an intermediate product is completed one reporting point serves as exit point in order to report the completion of an intermediate production step. This data is stored in the OLTP system and retrieved at a later point of time in order to generate a table containing aggregated intermediate product quantities per shop area. This table is transferred to a financial data server for calculation of the value of work in progress. | 08-05-2010 |
20100223227 | Statistical Applications in OLTP Environment - 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. | 09-02-2010 |
20110010331 | Community-Driven Relational Filtering of Unstructured Text - A method and apparatus for calculating a score for word selection, which may be used to preprocess sets of words prior to a dimensionality reduction process, employs information about relationships between words themselves (such as synonym relationships) or relationships between items with which the words are associated (such as products in a catalog). In some embodiments, the relationships are also community based; i.e., the relationships are established by a community of users. The relationships may be references to two or more word sets in which the word of interest is common. In one embodiment, the word sets are descriptions of products in an online catalog, the community is the group of people who view the catalog, and the relationships used for calculating the score for a particular word of interest are coreferences (e.g., viewing or purchasing) of pairs of products for which the catalog descriptions both include the particular word. | 01-13-2011 |
20110113007 | Flex Computing End-User Profiling - A system and method are disclosed for automatically providing a usage profile corresponding to a user of a plurality of information handling system resources. Survey information related to a user of IHS resources is collected and processed to generate survey information. IHS resources used by the user are determined and associated configuration and operational information is collected and processed to generate imported information. The survey information and the imported information are then processed to generate a set of user usage scores, which are in turn processed to produce a user usage model, which is likewise processed to generate a user usage fingerprint. Comparison operations are performed between the user usage fingerprint and a plurality of reference usage profiles and the reference usage profile most closely matching the user usage fingerprint is selected. Sizing, return on investment (ROI) and total cost of ownership (TCO) calculations are performed related to associating the user with the selected reference usage profile. | 05-12-2011 |
20110119228 | SELECTIVE FILE SYSTEM CACHING BASED UPON A CONFIGURABLE CACHE MAP - A method for implementing selective file system caching. The method includes receiving I/O requests from an application and comparing each of the I/O requests with a configurable cache map, wherein the configurable cache map controls a selective caching based on an I/O type and a file type. Each of the I/O requests are processed to render caching decisions based on the configurable cache map. Selective caching is then implemented on each of the I/O requests in accordance with the caching decisions. | 05-19-2011 |
20110131174 | SYSTEM AND METHOD FOR AN INTELLIGENT STORAGE SERVICE CATALOG - A method and system relate to data storage, and more particularly, to an intelligent storage service catalog. A method is implemented in a computer infrastructure having programming instructions. The programming instructions are operable to receive at least one definition of storage requirements for an organization for at least one data type and establish at least one data storage allocation rule based on the at least one data type. Additionally, the programming instructions are operable to receive a request for storage for the at least one data type and allocate data storage based on the request for storage and the at least one data storage allocation rule. | 06-02-2011 |
20110153552 | SYSTEM AND METHOD FOR STANDARDIZING IP TRANSACTIONS - A comprehensive platform for merchandising intellectual property (IP) and conducting IP transactions is disclosed. A standardized data collection method enables IP assets to be characterized, rated and valuated in a consistent manner. Project management, workflow and data security functionality enable consistent, efficient and secure interactions between the IP Marketplace participants throughout the IP transaction process. Business rules, workflows, valuation models and rating methods may be user defined or based upon marketplace, industry or technology standards. | 06-23-2011 |
20110153553 | Coordinated Location Aware Brokering of Social Networks - Social networking has become a significant aspect of many people's lives as they communicate with others who are members of the same social networking application. In many instances members who have joined these social networks to find other individuals with similar interests are unaware that people who have these same interests have not joined the same social network but are members of another social network. Today these social networks are discrete, jealously guarding their member profiles, and limiting their member's ability to achieve the goal they joined the social network for. Accordingly, the invention allows members to search and manage activities on multiple social networks through a brokering service, the partner social networks deriving benefit through providing expanded resources to their own members which they do not have to acquire and also from revenue flowing from the brokering service. | 06-23-2011 |
20110153554 | Method for summarizing data in unaggregated data streams - A method for producing a summary A of data points in an unaggregated data stream wherein the data points are in the form of weighted keys (a, w) where a is a key and w is a weight, and the summary is a sample of k keys a with adjusted weights w | 06-23-2011 |
20110161281 | Distributed Transaction Management in a Distributed Shared Disk Cluster Environment - Systems, methods, computer program product embodiments are provided for maintaining transaction consistency for distributed transactions in a distributed shared disk cluster environment. An embodiment includes utilizing broadcast messaging among the plurality of instances to identify at least one of a transaction and a transaction owner instance for a transaction request. Execution of the transaction occurs on an owner instance as found based on a response to the broadcast messaging. | 06-30-2011 |
20110161282 | SYSTEMS AND METHODS FOR DISTRIBUTION OF DATA IN A LATTICE-BASED DATABASE VIA PLACEHOLDER NODES - Embodiments relate to systems and methods for the distribution of data in a lattice-based database via placeholder nodes. A data store can store data in a lattice-based database or other three-dimensional hierarchical format. Higher-level data, such as yearly profit, may be desired to be spread from parent nodes at different levels or points in the lattice structure to lower nodes or locations, such as quarters. Parent nodes can be associated with a set of programmatic placeholder nodes. A spreading tool can insert child nodes representing quarters, months, or other insertion point(s) represented or encoded by a set of placeholder nodes, dividing, combining, or otherwise distributing quantities appropriately. In aspects, data can be spread from multiple parents and/or multiple target child nodes, at once. In aspects, the spreading tool can access or host sequence logic to ensure data spreading in an order that takes dependencies, formatting, or other factors into account. | 06-30-2011 |
20110178980 | DATA SOURCE INDEPENDENT INTERFACE FOR AN ELECTRONIC BILL PRESENTMENT AND PAYMENT SYSTEM - An electronic bill presentment and payment system including an extensible, customizable, data source independent data layer for accessing a business data repository for processing billing information. The business data repositories use one or more data source formats. A business logic module generating business data requests for data from the business data repository in order to carry out processing of billing information. The business data requests are independent of the one or more data source formats of the business data repository. A data layer descriptor repository stores customizable data source descriptions for generating the data layer. The data layer is generated from the customizable descriptors in the data layer descriptor repository. The data layer module receives the data source independent business data requests and based on the request, the data layer implements a data source specific method for fulfilling the request by accessing data in the business data repository. The data layer module further returns a result back to the business logic module in data source independent format. The data layer descriptor repository preferably includes top-level listings of data sources in the system. The data layer descriptor repository further includes customized data source specifications for the each of the data sources listed in the customized set of data sources. | 07-21-2011 |
20110202499 | Universal Traceability Strategy - This disclosure provides a system for designing a system in support of one or more business processes including a database, an interface, and a requirements platform. The database may include data associated with a plurality of operational systems for information handling systems that have been deployed. The interface may be configured to receive a request for a system design. The requirements platform may be configured to query the database for information about historical use of information handling systems in support of various business processes, to determine a set of metrics for analyzing a plurality of historical system designs, to apply the set of metrics to the data in the database to identify one or more potential related reports, to analyze the request to determine an appropriate format for the report, and to generate the report. | 08-18-2011 |
20110202500 | ANOMALOUS ACTIVITY DETECTION - The disclosure addresses the detection of anomalous activity. Some embodiments are directed towards consolidating information from multiple data feeds. Exemplary information may relate to: extrusion violations, failed logins, sensitive fields access, sensitive objects access, escalation of privileges, or activity during a specific time frame within a time period, and combinations of one or more of these. In one embodiment, duplicate data may be removed or consolidated. | 08-18-2011 |
20110302132 | INTEGRATED WORKFLOW AND DATABASE TRANSACTIONS - A computer-implemented method and system to integrate workflow and database transactions is provided. Also provided is a computer readable storage medium that includes a program. The computer-implemented method includes assigning a data structure stored in a database to one or more workflow processes. The computer-implemented method also includes automatically creating an instance of the workflow in response to the data structure being populated with a new record. | 12-08-2011 |
20120005154 | EFFICIENT RECOVERY OF TRANSACTIONAL DATA STORES - Approaches for recovering a node of a distributed transactional system. When a recovering node is being brought on-line, a copy of at least a portion of a first data store maintained by an existing node is created without ceasing to process transactions against the first data store at the existing node. The recovering node creates a second data store based on the copy of the first data store. While the recovering node creates the second data store, the recovering node stores committed transaction data received from a plurality of nodes. The committed transaction data describes transactions committed against data stores maintained by the sender of the committed transaction data. The recovering node may thereafter replay, against the second data store, any transactions identified by the committed transaction data that are associated with a global transaction number that is more recent than is a reference commit number. | 01-05-2012 |
20120030165 | SYSTEM AND METHOD FOR REAL-TIME TRANSACTIONAL DATA OBFUSCATION - A system and method for providing transactional data privacy while maintaining data usability, including the use of different obfuscation functions for different data types to securely obfuscate the data, in real-time, while maintaining its statistical characteristics. In accordance with an embodiment, the system comprises an obfuscation process that captures data while it is being received in the form of data changes at a first or source system, selects one or more obfuscation techniques to be used with the data according to the type of data captured, and obfuscates the data, using the selected one or more obfuscation techniques, to create an obfuscated data, for use in generating a trail file containing the obfuscated data, or applying the data changes to a target or second system. | 02-02-2012 |
20120041921 | MECHANISM FOR FACILITATING EFFICIENT BUSINESS RULES MANAGEMENT AND DATA PROCESSING - In accordance with embodiments, there are provided methods and systems for facilitating efficient business rules management and data processing. A method of embodiments includes generating, at a first computing system, configuration settings to customize business rules to process data transactions. The business rules are processed by a business rules engine at a second computing system. The method includes customizing one or more business rules by applying one or more configuration settings to the one or more business rules, and facilitating the business rules engine residing on the second computing system to process one or more data transactions based on the one or more customized business rules. The one or more customized business rules guide processing of the one or more data transactions and provide information relating to how one or more business rules are matched with the one or more data transactions. | 02-16-2012 |
20120084253 | TRANSACTION IN MEMORY OBJECT STORE - Techniques for rating and committing events in an event processing system are provided. Events can be rated at a rating system according to information that is stored locally on the rating system. Rated events can be stored in a database system with these rated events being utilized to, among other things, restore information that is stored locally on the rating system. | 04-05-2012 |
20120109881 | IDENTIFYING AND DEFINING INFORMATION SERVICES FOR DELIVERY IN A SERVICE ORIENTED ARCHITECTURE - A method for information service identification during service modeling of a service oriented architecture (SOA) architected computing system includes loading a business process defined by different business services in memory of a service modeling tool executing in a host computing platform. The method further includes identifying different information elements directed for access by the business services and determining a set of information transactions for the identified different information elements. The method yet further includes generalizing the set of information transactions into a candidate list of information services. The method even yet further includes selecting from amongst the candidate list a selection of information services for incorporation into the business process. Finally, the method includes refining the business services of the business process to invoke the selection of information services to access the identified different information elements. | 05-03-2012 |
20120109882 | Systems and methods to consolidate and communicate user profiles and modality preferences information for content delivery or interaction experiences - Computer-implemented systems and methods are provided whereby Users can dynamically configure and control the use of their preferences for both types and modality of interactions with multiple Provisioners. These inventive systems and methods also enable Provisioners to gain access to User preferences to establish or affect interactions and transactions with Users. Advantageously, these inventive systems and methods provide User control of the receipt of content, matter/substance, experiences and interactions, to enable consolidating management of the User's “interaction profile” into a unified system, while increasing the quality and depth of the relationship between the User and the Provisioner, including but not limited to the creation of emotional/affinity ties to the Provisioner. Furthermore, multiple instances of User profile data can be shared amongst multiple Provisioners in a way that creates affinity between Users and Provisioners and improves User experience, while maintaining User anonymity. | 05-03-2012 |
20120143816 | Method and System of Information Matching in Electronic Commerce Website - The present disclosure describes an information matching method and information system. The method collects characteristic data of category plurality of categories of network behavior of a plurality of network users; groups the network users into a plurality of clusters based on the characteristic data; sets weight of the characteristic data; receives a search request from one of the plurality of network users; obtains search results according to the search request; inquires a historical record of clicking operation on at least some of the search results made by at least some of the network users in one of the clusters which contains the one of the plurality of network users; calculates a respective rank value of each of the at least some of the search results based on the historical record of clicking operation of at least some of the network users and the weight of the characteristic data; sorts of the search results to arrange the search results according to the rank values of the search results in a descending order from high rank to low rank; and causes the sorted search results to be displayed. | 06-07-2012 |
20120150794 | CARD AUTHORIZATION TERMINAL SYSTEM AND CARD MANAGEMENT METHOD USING THE SAME - A card authorization terminal system of present invention includes a card identifying unit, a database management unit, and an authorization processing unit. The card identifying unit deciphers card property information stored in a card and determines whether the card is valid. The database management unit determines final card property information based on the card property information deciphered by the card identifying unit and property change information stored in the database management unit. The authorization processing unit calculates charges and processes card transactions based on the final card property information generated by the database management unit. The database management unit generates identification numbers sequentially assigned from a predetermined number with respect to respective card numbers corresponding to the property change information, stores the identification number and the property change information corresponding to the identification numbers, and determines the final card property information corresponding to the card property information based on the stored property change information. | 06-14-2012 |
20120158645 | WORK UNITS FOR CONTENT PROCESSING - A system may create work units, each work unit including at least one of an input port or output port, each work unit configured to modify data that is received via the input port. In addition, the system may compose a workflow by connecting an output port of a first of the work units to an input port of a second of the work units, receive a work order, select the workflow in response to the work order, decompose the workflow into constituent work units, instantiate tasks that correspond to the constituent work units, and execute a work unit process for each of the tasks. | 06-21-2012 |
20120158646 | WORK ORDER OPTIMIZATION - A method may include receiving an order associated with processing a media file, generating a work order associated with fulfilling the order and identifying tasks associated with the work order. The method may also include accessing information identifying previously processed orders and determining whether at least one stored asset associated with one of the previously processed orders is usable when processing the first order. The method may further include retrieving, when a first one of the stored assets is usable, the first stored asset, and using the first stored asset when processing the work order. | 06-21-2012 |
20120166386 | METHOD AND SYSTEM FOR CROSS-PLATFORM REAL TIME DECISION MAKING - According to some embodiments, a system includes a business data provider, collaboration platform, a user client device, and a web application server interfacing with the business data provider, the user client device, and the collaboration platform. In some embodiments, the user client device communicates with the web application using a markup language to request and receive business data and collaboration data from the business data provider and the collaboration platform, respectively. | 06-28-2012 |
20120173480 | DVIVD Match Audit System and 5 Star Event Data Recorder Method Thereof - 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. | 07-05-2012 |
20120179645 | TRANSACTION SUPPORT FOR DISTRIBUTED DATA - 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. | 07-12-2012 |
20120179646 | Multi-tenant audit awareness in support of cloud environments - A cloud enablement aggregation proxy (CEAP) receives and processes audit data from audited resources before such data is stored in a database. The CEAP manages log data for resources hosted in a multi-tenant shared pool of configurable computing resources (e.g., a compute cloud). A method for managing log data begins by the proxy aggregating and normalizing log information received from a plurality of the resources. The aggregated and normalized log information is then parsed to identify a tenant associated with each of a set of transactions. For each of the set of transactions, the CEAP annotates log data associated with the tenant and the particular transaction to include a tenant-specific identifier. An optional tenant separation proxy (TSP) separates the annotated log data on a per tenant basis prior to storage, and the tenant-specific log data may be stored in per tenant data structures or dedicated tenant log event databases to facilitate subsequent compliance or other analysis. | 07-12-2012 |
20120191643 | TRANSACTIONAL SERVICE PIPELINE - An approach for connecting the inputs and the outputs of multiple services in such a way that the entire transaction can be tracked from beginning to end and from service to service is provided. The pipeline architecture of the present invention passes information through a sequence of nodes, each node providing some processing or filtering before passing information to the next node in the pipe. A transaction's token passes down a pipe of services. The pipe can have forks and branches, so a transaction's token is passed from node to node carrying messages from one node to another. The overall transactional information is not lost from service to service; instead it is carried up and down the length of the pipeline. As the transaction's token is passed up and down the pipeline, its history passes with it. The pipe links a chain of nodes connected end-to-end. | 07-26-2012 |
20120265728 | Available-To-Promise on an In-Memory Column Store - A system and method of determining an earliest delivery date for a demand on the basis of a fact table stored in a database, where the demand indicates both a desired date and a desired quantity for items from a stock, where a fact time series is comprised by and/or deducible from the fact table, and where the fact time series comprises fact tuples indicating both a fact date and a change in quantity of stock items that occurred on this fact date. The method includes generating an aggregated time series from the fact time series by defining and/or obtaining discrete time intervals, and generating, for at least one discrete time interval, an aggregated tuple indicating both its corresponding discrete time interval and the aggregated change in quantity of stock items that occurred in its corresponding discrete time interval. | 10-18-2012 |
20130006917 | DATABASE, PROCESS FLOW DATA MANAGEMENT SERVER, AND PROCESS FLOW DATA MANAGING PROGRAM PRODUCT - A processing load required for updating and searching data is to be reduced in an ERP system. | 01-03-2013 |
20130006918 | Statistical Applications in OLTP Environment - 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. | 01-03-2013 |
20130054513 | METHOD AND SYSTEM FOR AUCTION INFORMATION MANAGEMENT - Foreclosure auction information received from each of a plurality of sources of such information via respective Internet bots, manual updates, or other sources, is used to populate a database according to a predefined schema and ruleset. The database is updated in near real time (from any or all of the datasources), and actionable auction information that meets user-determined criteria for accuracy, timeliness and/or relevancy is extracted from the database and presented for use by a user. | 02-28-2013 |
20130073518 | INTEGRATED TRANSACTIONAL AND DATA WAREHOUSE BUSINESS INTELLIGENCE ANALYSIS SOLUTION - A system, computer-implemented method, and computer program product for performing integrated transactional and data warehouse business intelligence analysis using a correlated report constructed from data correlations between current transactional data and historical data from a data warehouse. The method commences by retrieving a transactional data record from an online transactional processing (OLTP) system, the transactional data record comprising at least one OLTP business intelligence value of a particular business intelligence attribute, then receiving from a storage system, results of a query to a data warehouse, the results comprising a historical business intelligence value of the same business intelligence attribute. Modules within the system (e.g., a business intelligence application) perform processing to combine the OLTP business intelligence value with the historical business intelligence value to form a correlated report and transmit the correlated report for displaying on a single surface. | 03-21-2013 |
20130110766 | METHOD FOR PERFORMING TRANSACTIONS ON DATA AND A TRANSACTIONAL DATABASE | 05-02-2013 |
20130110767 | Online Transaction Processing | 05-02-2013 |
20130166499 | Determination of a Most Suitable Address for a Master Data Object Instance - The present disclosure involves computer-implemented methods, software, and systems for determining a most suitable address for a master data object instance for a given usage in a business transaction document, master data object, or business process. A computer-implemented method includes determining, using at least one computer, an address determination sequence, applying the address determination sequence to available address instances of a master data object instance, identifying a most suitable address from among the available instances, and retrieving an address value from the identified most suitable address instance. | 06-27-2013 |
20130166500 | EFFICIENT HANDLING OF ADDRESS DATA IN BUSINESS TRANSACTION DOCUMENTS - 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. | 06-27-2013 |
20130246342 | Multi-Source, Multi-Dimensional, Cross-Entity, Multimedia Centralized Personal Information Database Platform Apparatuses, Methods and Systems - THE MULTI-SOURCE, MULTI-DIMENSIONAL, CROSS-ENTITY, MULTIMEDIA CENTRALIZED PERSONAL INFORMATION DATABASE PLATFORM APPARATUSES, METHODS AND SYSTEMS (“CPDB”) transform data aggregated from various computer resources using CPDB components into updated entity profiles and/or social graphs. In one implementation, the CPDB aggregates data records including search results, purchase transaction data, service usage data, service enrollment data, and social data. The CPDB identifies data field types within the data records and their associated data values. From the data field types and their associated data values, the CPDB identifies an entity. The CPDB generates correlations of the entity to other entities identifiable from the data field types and their associated data values. The CPDB also associates attributes to the entity by drawing inferences related to the entity from the data field types and their associated data values. Using the generated correlations and associated attributes, the CPDB generates an updated profile and social graph of the entity. The CPDB provides the updated profile and social graph for an automated web form filling request. | 09-19-2013 |
20130262372 | COMPUTER-IMPLEMENTED METHODS AND SYSTEMS FOR FACILITATING BUSINESS-TO-BUSINESS TRANSACTIONS ON A COLLABORATIVE BUSINESS NETWORK AND FOR SYSTEM INTEGRATION MESSAGE ROUTING AND IDENTIFIER MAPPING UTILIZING A SHARED WORKSPACE MECHANISM - A computer-implemented method for facilitating business-to-business transactions on a collaborative business network among a plurality of entities. | 10-03-2013 |
20130275366 | LIFECYCLE MARKETING OBJECT ORIENTED SYSTEM AND METHOD - The present invention involves a server for providing remote users a Lifecycle marketing system based on information in a data store of the customer enterprise. The server includes a database storing customer enterprise data. The customer enterprise data includes rules, criteria, and stages. Query software is capable of accessing data in enterprise data stores. Lifecycle definition software accesses the database and is capable of creating a lifecycle framework in the database based on information on contacts included in the enterprise data stores. | 10-17-2013 |
20130290243 | METHOD AND SYSTEM FOR TRANSACTION REPRESENTATION IN APPEND-ONLY DATASTORES - A method, apparatus, and system, and computer program product for transaction representation in append-only data-stores. The system receives input from a user or agent and begins a transaction involving at least one datastore based on the received input. The system then creates, updates, and maintains a transaction state. The system ends the transaction and writes the state of the transaction to memory in an append-only manner, wherein the state comprises append-only key and value files. | 10-31-2013 |
20140032480 | FORM TEMPLATE REFACTORING - In some embodiments, a method includes receiving a command to update a form component within a set of one or more form templates. The method also includes receiving an alternative form component for the form component that is to be updated. The method includes performing a pattern matching across a number of form templates to identify the set of one or more form templates in the number of form templates. The method includes refactoring the set of one or more form templates. The refactoring includes changing a reference in the set of one or more form templates to reference the alternative form component. | 01-30-2014 |
20140032481 | COMMENTING DYNAMIC CONTENT - Apparatus, systems, and methods may operate to add opaque state information to a data file that includes dynamic content and is organized according to a page descriptive format. The opaque state information can be referenced to a comment and a comment state selected from a plurality of states associated with the dynamic content. In some embodiments, the apparatus, systems, and methods may operate to access the data file and the opaque state information to recreate the comment state associated with the dynamic content. Additional apparatus, systems, and methods are disclosed. | 01-30-2014 |
20140032482 | PACKAGE FILE PRESENTATION INCLUDING REFERENCE CONTENT - Various embodiments illustrated and described herein include one or more of systems, methods, software, and data structures for presentation of package files including a reference content item. Some embodiments include receiving a reference content item, such as an image, map, or calendar, and mappings of package files to locations within the reference item for display. Such embodiments may then publish the package file. Some other embodiments include generating visual representations of package files including a reference content item and one or more content items mapped to locations within a reference content item. Such a visual representation may include a view of the reference content item and a graphical element representative of the content item at the mapped location within the view of the reference content item. | 01-30-2014 |
20140032483 | ASSET DISTRIBUTION ARCHITECTURE AND TIMELINE HISTORY - A system receives contextual information regarding a context within which a device is operating. The contextual information is provided to an asset application that facilitates access to a plurality of assets, the contextual information to allow the asset application to interact with respective further asset applications executing on further devices within the context. | 01-30-2014 |
20140032484 | WEB SERVICE-BASED, DATA BINDING ABSTRACTION METHOD - A method for providing a data binding abstraction. The method includes serving an interactive document via a digital data communications network using a server. The method includes generating, with intelligence in the document, a data binding request to resolve a data value placeholder that has no static data location or source reference. With a data binding web service, the method includes generating a data dictionary request that includes a placeholder identifier. The method includes using the data binding web service to process a data dictionary response which includes placeholder content for the placeholder to determine a source of the data value. The method includes the data binding web service accessing the determined data source to obtain the data value and providing the interactive document with a response including the placeholder identifier and the resolved placeholder data value. The interactive document then replaces the placeholders with the returned data value. | 01-30-2014 |
20140067752 | AVAILABLE-TO-PROMISE ON AN IN-MEMORY COLUMN STORE - A system and method of determining an earliest delivery date for a demand on the basis of a fact table stored in a database, where the demand indicates both a desired date and a desired quantity for items from a stock, where a fact time series is comprised by and/or deducible from the fact table, and where the fact time series comprises fact tuples indicating both a fact date and a change in quantity of stock items that occurred on this fact date. The method includes generating an aggregated time series from the fact time series by defining and/or obtaining discrete time intervals, and generating, for at least one discrete time interval, an aggregated tuple indicating both its corresponding discrete time interval and the aggregated change in quantity of stock items that occurred in its corresponding discrete time interval. | 03-06-2014 |
20140074772 | METHOD AND SYSTEM FOR AUDITING TRANSACTION DATA FROM DATABASE OPERATIONS - A method for validating SRS registry transaction data includes receiving OLTP transaction data from a first database, parsing the OLTP transaction data, and comparing the parsed OLTP transaction data to one or more of a set of profiles. Each of the one or more of the set of profiles includes metadata in XML files. The method also includes caching the parsed OLTP transaction data in a first data cache, receiving log data associated with the OLTP transaction data; and caching the log data in a second data cache. The method further includes correlating the parsed transaction data cached in the first data cache with the log data cached in the second data cache. | 03-13-2014 |
20140114910 | METHOD AND SYSTEM FOR PARTITIONING DATABASE - The present invention relates to a method and system for partitioning a database. The method for partitioning a database comprises: grouping a plurality of entries in the database into one or more entry groups, so that entries in the same entry group are always accessed together by one or more transactions; and dividing the one or more entry groups into a set number of partitions, so that a total number of transactions that access across more than one partition is minimized. By means of the present invention, it is possible to obtain an efficient, flexible and convenient method for partitioning a database, thereby greatly improving the system performance. | 04-24-2014 |
20140122416 | SYSTEMS AND METHODS FOR A TRANSACTIONAL-BASED WORKFLOW COLLABORATION PLATFORM - A system and method to share data associated with a transaction are disclosed. In some embodiments, a database record may be associated with a transaction corresponding to a product. The database record may comprise a plurality of data fields and the transaction may be associated with a plurality of entities. The data fields of the record may be made available to each of the entities based on a role of the entities in the transaction. As such, different data fields may be displayed to different entities. Furthermore, various sharing techniques may be performed with the data fields of the record. | 05-01-2014 |
20140122417 | TRANSACTION PROCESSING METHOD, PROGRAM, AND SYSTEM - A method, system, and computer program product to solve the problem of consistency in processing when one server performs a transmission transaction and a reception transaction in an in-line processing manner. In a system according to this invention, a local buffer is generated at the time of starting a transmission transaction, and a message is inserted in the local buffer at the time of transmission processing. At the time of commitment of the transmission transaction, after reception transaction processing on all messages in the local buffer, processing for commitment to the data base is performed. Processing for the reception transaction is performed as a nested transaction in the transmission transaction. | 05-01-2014 |
20140129512 | SYSTEMS AND METHODS FOR ENHANCING USER DATA DERIVED FROM DIGITAL COMMUNICATIONS - A computer-implemented method for enhancing user data derived from digital communications includes (1) detecting a transaction request from a first computing device in response to an issue-specific invitation, (2) generating a first dataset based on the transaction request, the first dataset including an issue-specific data element corresponding to the issue-specific invitation, (3) associating the first dataset with a user of the first computing device, (4) identifying a second dataset associated with the user, and (5) appending the second dataset to the first dataset to generate an appended dataset. Various other methods, systems, and computer-readable media are also disclosed. | 05-08-2014 |
20140136473 | PARTIAL MERGE - A multi-level storage architecture and method of performing a partial merge are disclosed. A main store is partitioned into a passive main part and an active main part, the active main part being empty at a start of the partial merge, the passive main part storing encoded data records of the main store that are not subject to the partial merge. A values index corresponding to a sorted dictionary of the passive main part is set to a cardinality of n. The data records of a second level storage structure is merged into the active main part, the active main part having a dictionary that starts with a value of n+1, such that the merging into the active main part continues an encoding scheme according to the values index of the passive main part. | 05-15-2014 |
20140136474 | TRANSACTIONAL SERVICE PIPELINE - An approach for connecting the inputs and the outputs of multiple services in such a way that the entire transaction can be tracked from beginning to end and from service to service is provided. The pipeline architecture of the present invention passes information through a sequence of nodes, each node providing some processing or filtering before passing information to the next node in the pipe. A transaction's token passes down a pipe of services. The pipe can have forks and branches, so a transaction's token is passed from node to node carrying messages from one node to another. The overall transactional information is not lost from service to service; instead it is carried up and down the length of the pipeline. As the transaction's token is passed up and down the pipeline, its history passes with it. The pipe links a chain of nodes connected end-to-end. | 05-15-2014 |
20140181007 | TRADEMARK RESERVATION SYSTEM - A data processing system and method for assisting in searching items on Internet and to a method related to invoicing a user based on the action taken on the search results. An optimized transactional process for the selection of an appropriate parameter for action and the take decision on the basis of results obtained. For example in a robotic control, technical process control in an industrial environment, database searches and analysis in respect of trademarks, or in a control military defence hardware. The system offers a search service configured to check if a user took action on the search result it is configured to invoice the user for example, a searched new trademark was later registered by a searcher, and invoice the searcher later if the trademark was registered afterwards. | 06-26-2014 |
20140250057 | System of Centrally Managing Core Reference Data Associated with an Enterprise - A system is provided for centrally managing core enterprise reference data associated with an enterprise. A centralized master repository contains the core enterprise reference data. The internal services framework also provides internal services for managing the core enterprise reference data within the centralized master repository, one or more of the internal services having direct access to the core enterprise reference data stored in the centralized master repository for management purposes. An infrastructure services layer coupled to the centralized master repository provides for bulk data transfers of core enterprise reference data between the centralized master repository and one or more external operational systems according to one or more enterprise-level business workflows, the external operational systems permitted indirect access to the core enterprise reference data stored in the centralized master repository for operational purposes. | 09-04-2014 |
20140258212 | DYNAMIC IN-MEMORY DATABASE SEARCH - The disclosure generally describes computer-implemented methods, software, and systems for providing an in-memory database search mechanism without using an index table. A system for accessing at least one of multiple data elements that are stored as non-key fields in one or more application tables comprises: an in-memory database storing the one or more application tables that store the multiple data elements as non-key fields, the system configured to execute operations comprising: receiving a criterion, retrieving, without using an index table, at least one data element of the one or more application tables that fulfills the criterion. | 09-11-2014 |
20140279839 | INTEGRATION OF TRANSACTIONAL AND ANALYTICAL CAPABILITIES OF A DATABASE MANAGEMENT SYSTEM - Conventional approaches to transactional processing and analytics in database management systems have typically maintained a strict separation between these tasks, often resulting duplicate modeling, replication of data, usage of different infrastructure stacks, the need to integrate transactions and analytics on a layer that is very close to the end user, etc. Described herein are systems, methods, articles of manufacture, and the like relating to a central integration component that provides access to a core metamodel. Via the metamodel, metadata specify a data part of a business object and one or more information providers (e.g., an analytical view, an attribute view, etc.) that directly consume data from database tables underlying the business object. The central integration component responds to data access requests using the core metmodel. | 09-18-2014 |
20140279840 | Read Mostly Instances - According to one aspect of the invention, a read-write instance of a multiple-instance database system receives a database statement for execution. The multiple-instance database system comprises a database shared by a plurality read-mostly instances that request only read access to a plurality of user database objects in the database and a plurality of read-write instances that request both read access and write access to the plurality of user database objects. The read-write instance selects one or more read-mostly instances, in the plurality of read-mostly instances, to perform one or more operations that require no write access to the plurality of user data objects. | 09-18-2014 |
20140279841 | SYSTEM AND METHOD FOR STREAMING EVENTS IN A TRANSACTION-BASED SYSTEM - A system is provided that permits events to be propagated between systems in near real time for the purpose of ensuring consistency in a transaction-based environment. In one implementation, transactions are streamed between systems using a lightweight protocol shortly after they are processed, rather than being communicated in a one-way batch mode as is typically done in conventional retail store systems. | 09-18-2014 |
20140289184 | LICENSE STRUCTURE REPRESENTATION FOR LICENSE MANAGEMENT - Embodiments herein include a license provisioning application that organizes licensing information into a licensing data structure in a multi-application environment. The license provisioning application can use the licensing data structure to increase the efficiency of license management operations by representing complex licenses and their relationships, including locale-based licensing and flexible licensing frameworks. The license provisioning application includes a caching mechanism for faster performance, and facilitates ease of use for license management operations, such as activation, renewal, and deactivation (both in bulk and individually), handling subscription based licensing, trial licensing, and executing license queries. The license provisioning application can provide a graphical representation of licenses and relationships for performing various license management operations. | 09-25-2014 |
20140304219 | Hybrid Database Table Stored as Both Row and Column Store - A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result. | 10-09-2014 |
20140304220 | SYSTEM AND METHOD FOR RETRIEVING AND NORMALIZING PRODUCT INFORMATION - 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. | 10-09-2014 |
20140310236 | Out-of-Order Execution of Strictly-Ordered Transactional Workloads - 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. | 10-16-2014 |
20140317047 | ENHANCED TRANSACTIONAL CACHE WITH BULK OPERATION - 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. | 10-23-2014 |
20140317048 | ENHANCED TRANSACTIONAL CACHE - 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. | 10-23-2014 |
20140330767 | SCALABLE DISTRIBUTED TRANSACTION PROCESSING SYSTEM - 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. | 11-06-2014 |
20140351202 | APPARATUS AND METHOD FOR READ OPTIMIZED BULK DATA STORAGE - 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. | 11-27-2014 |
20140358846 | Apparatus and Method for Harmonizing Data Along Inferred Hierarchical Dimensions - 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. | 12-04-2014 |
20140365424 | SYSTEMS AND METHODS TO MANAGE ONLINE ANALYTICAL AND TRANSACTIONAL PROCESSING FOR AN IN-MEMORY COLUMNAR DATABASE - 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. | 12-11-2014 |
20140365425 | STATISTICAL APPLICATIONS IN OLTP ENVIRONMENT - 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. | 12-11-2014 |
20140379631 | TRANSACTIONAL KEY-VALUE DATABASE WITH SEARCHABLE INDEXES - 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. | 12-25-2014 |
20150012483 | OPEN DATABASE-BASED FAR-DISTANCE BICENTRIC ONLINE PROCESSING METHOD AND SYSTEM - 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. | 01-08-2015 |
20150039555 | HEURISTICALLY MODIFYING DBMS ENVIRONMENTS USING PERFORMANCE ANALYTICS - 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. | 02-05-2015 |
20150058281 | MANAGEMENT AND SYNCHRONIZATION OF BATCH WORKLOADS WITH ACTIVE/ACTIVE SITES OLTP WORKLOADS - 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. | 02-26-2015 |
20150066841 | TABLE-FORM PRESENTATION OF HIERARCHICAL DATA - 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. | 03-05-2015 |
20150074040 | DEFERRING DATA RECORD CHANGES USING QUERY REWRITING - 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. | 03-12-2015 |
20150074041 | DEFERRING DATA RECORD CHANGES USING QUERY REWRITING - 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. | 03-12-2015 |
20150081622 | DATASET INTERSECTION DETERMINATION - 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. | 03-19-2015 |
20150081623 | METHOD FOR PERFORMING TRANSACTIONS ON DATA AND A TRANSACTIONAL DATABASE - 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. | 03-19-2015 |
20150088810 | EFFICIENT COORDINATION ACROSS DISTRIBUTED COMPUTING SYSTEMS - 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. | 03-26-2015 |
20150088811 | MECHANISM TO RUN OLTP WORKLOAD ON IN-MEMORY DATABASE UNDER MEMORY PRESSURE - 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. | 03-26-2015 |
20150120645 | System and Method for Creating a Distributed Transaction Manager Supporting Repeatable Read Isolation level in a MPP Database - Embodiments are provided to provide a distributed transaction manager supporting repeatable read isolation level in Massively Parallel Processing (MPP) database systems without a centralized component. Before starting a transaction, a first node identifies a second node involved in the transaction, and requests from the second node a snapshot of current transactions at the second node. After receiving the snapshot from the second node, the first node combines into a reconciled snapshot the snapshot of transactions from the second node with current transactions at the first node. The first node then transmits the reconciled snapshot to the second node and starts the transaction using the reconciled snapshot. A branch transaction is then started at the second node in accordance with the reconciled snapshot. Upon ending the transaction and the branch transaction, the first node and the second node perform a two phase commit (2PC) protocol. | 04-30-2015 |
20150127602 | PATTERN MINING BASED ON OCCUPANCY - An example method of pattern mining includes identifying, via a logic circuit, a plurality of patterns present in a plurality of transactions, the transactions including sets of items, and selecting, via the logic circuit, one of the identified patterns based on an occupancy of the identified pattern in the transactions. | 05-07-2015 |
20150134598 | REPORTING AND SUMMARIZING METRICS IN SPARSE RELATIONSHIPS ON AN OLTP DATABASE - Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables. | 05-14-2015 |
20150134599 | REPORTING AND SUMMARIZING METRICS IN SPARSE RELATIONSHIPS ON AN OLTP DATABASE - Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables. | 05-14-2015 |
20150324439 | SYSTEM AND A PROCESS FOR SEARCHING MASSIVE AMOUNTS OF TIME-SERIES PERFORMANCE DATA USING REGULAR EXPRESSIONS - A system to collect and analyze performance metric data recorded in time-series measurements, converted into unicode, and arranged into a special data structure. The performance metric data is collected by one or more probes running on machines about which data is being collected. The performance metric data is also organized into a special data structure. The data structure at the server where analysis is done has a directory for every day of performance metric data collected with a subdirectory for every resource type. Each subdirectory contain text files of performance metric data values measured for attributes in a group of attributes to which said text file is dedicated. Each attribute has its own section and the performance metric data values are recorded in time series as unicode hex numbers as a comma delimited list. Analysis of the performance metric data is done using regular expressions. | 11-12-2015 |
20150331884 | PRIMARY KEY GENERATOR - Systems and methods for reclaiming and reusing primary key values are provided. According to one embodiment, multiple unused primary key values of a database application are reclaimed by a key generator by locating a gap in a sequence of a primary key column of the database application. Reuse of the reclaimed unused primary key values is facilitated by the key generator by returning a reclaimed unused primary key value responsive to a request from the database system for a new primary key value for the primary key column. | 11-19-2015 |
20150347483 | COMBINING ROW BASED AND COLUMN BASED TABLES TO FORM MIXED-MODE TABLES - Various ways of storing data in tabular form such that some records are stored in a row oriented manner and some data is stored in a column oriented manner. The records respectively stored in the row and column oriented manners may, or may not, overlap (in whole or in part. Some embodiments accomplish this dual orientation of data by: (i) using a range partition; (ii) using a union all view command; and/or (iii) using a first table, a staging table and a materialized query table. | 12-03-2015 |
20150347484 | COMBINING ROW BASED AND COLUMN BASED TABLES TO FORM MIXED-MODE TABLES - Various ways of storing data in tabular form such that some records are stored in a row oriented manner and some data is stored in a column oriented manner. The records respectively stored in the row and column oriented manners may, or may not, overlap (in whole or in part. Some embodiments accomplish this dual orientation of data by: (i) using a range partition; (ii) using a union all view command; and/or (iii) using a first table, a staging table and a materialized query table. | 12-03-2015 |
20150379060 | TRANSACTIONAL ACCESS TO RECORDS ON SECONDARY STORAGE IN AN IN-MEMORY DATABASE - Various technologies described herein pertain to accessing records of an in-memory database. A memory can include a primary storage and a data store can include a secondary storage. The primary storage includes a first subset of the records of the database, and the secondary storage includes a second subset of the records of the database. Moreover, the memory includes an update memo that includes timestamp notices. The timestamp notices specify statuses of records of the database having updates that span the primary storage and the secondary storage. The memory further includes a database management system that is executable by a processor. The database management system processes a transaction. Further, the database management system includes a storage interface component that accesses a record of the database for the transaction based on at least one of the timestamp notices of the update memo. | 12-31-2015 |
20160042028 | LOGLESS ATOMIC DATA MOVEMENT - A system and method of logless atomic data movement. An internal transaction is started within a multi-level storage architecture, the internal transaction to merge data from the first level storage structure to the second level storage structure. Committed data is read from a first level storage structure of the multi-level storage architecture as specified by the internal transaction. The committed data from the first level storage structure is inserted into a second level storage structure in a bulk insertion process, and the committed data is marked as being deleted from the first level storage. The internal transaction is then committed to the multi-level storage architecture when the committed data has been inserted into the second level storage structure. | 02-11-2016 |
20160098425 | HETEROGENEOUS DATABASE PROCESSING ARCHETYPES FOR HYBRID SYSTEM - A database processing system can support applications of an online transaction processing (OLTP) archetype and of an online analytical processing (OLAP) archetype. Hybrid archetypes can also be supported to implement hybrid scenarios. Requests for services are routed to an appropriate engine for fulfillment. User interface assets can be served by a shared infrastructure. Seamless navigation from one archetype to another can be supported in an insight-to-action scenario. | 04-07-2016 |
20160103860 | SUPPORTING TRANSIENT SNAPSHOT WITH COORDINATED/UNCOORDINATED COMMIT PROTOCOL - Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated. The method also includes consulting the in-page log for a recently updated one of the records or a recently deleted one of the records to determine a record status thereof. The method additionally includes spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full. The data pages include any of row-oriented data pages and column-oriented data pages. | 04-14-2016 |
20160125022 | EFFICIENT MAINTENANCE OF COLUMN STORE INDEXES ON MEMORY-OPTIMIZED TABLES - Techniques for improved update performance in transactional and data warehouse applications are disclosed herein. A request to store a modified version of the row is received. A first record indicative of a logically deleted state for values in the column store corresponding to the row is added to a first plurality of records. The modified version of the row is added to the row store. The identifier is modified to indicate that the column store does not contain a location corresponding to the modified version of the row. A second record indicative of the modified version of the row not having been propagated to the column is added to a second plurality of records store. | 05-05-2016 |
20160140206 | MECHANISM TO RUN OLTP WORKLOAD ON IN-MEMORY DATABASE UNDER MEMORY PRESSURE - 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. | 05-19-2016 |
20160147861 | Database System With Transaction Control Block Index - A plurality of transactions is handled in a database. Each transaction includes a plurality of operations on at least one record in the database with at least two of the transactions being handled concurrently. Thereafter, a temporary timestamp is assigned to each record. The temporary timestamp are based, at least in part, on the corresponding transaction. Further, a final timestamp is assigned to each record with a commit operation. It can later be determined, using a visibility function and based on the assigned temporary timestamps and final timestamps, which of the records are visible in a consistent view for a first transaction. Based on such determination, access can be provided to those records determined to be visible to be accessed to the first transaction. | 05-26-2016 |
20160147862 | Delegation of Database Post-Commit Processing - A plurality of transactions are handled in a database. Each transaction comprises a plurality of operations on at least one record in the database with at least two of the transactions being handled concurrently. Thereafter, a temporary timestamp is assigned to each record that is based, at least in part, on the corresponding transaction. A first transaction among the plurality of transactions is subsequently committed. Afterwards, re-stamping of at least one commit timestamp modified by the first transaction is delegated. Related apparatus, systems, techniques and articles are also described. | 05-26-2016 |
20160154842 | TRANSACTION MANAGEMENT SYSTEM | 06-02-2016 |
20160171069 | MAINTAINING TWO-SITE CONFIGURATION FOR WORKLOAD AVAILABILITY BETWEEN SITES AT UNLIMITED DISTANCES FOR PRODUCTS AND SERVICES | 06-16-2016 |
20160179918 | ASYNCHRONOUS DATA REPLICATION USING AN EXTERNAL BUFFER TABLE | 06-23-2016 |
20160196295 | RENDEZVOUS-BASED OPTIMISTIC CONCURRENCY CONTROL | 07-07-2016 |
20170235786 | Multi-Source, Multi-Dimensional, Cross-Entity, Multimedia Centralized Personal Information Database Platform Apparatuses, Methods and Systems | 08-17-2017 |
20220138184 | OBJECT RESOLUTION AMONG ACCOUNT-LEVEL NAMESPACES FOR DATABASE PLATFORMS - A database platform receives an object identifier from a client in association with a database session. The client is associated with a customer account of the database platform, and the database session is associated with the client. The customer account includes multiple disjoint account-level namespaces, each of which represents a distinct context for resolution of object identifiers, such that matching object identifiers in different account-level namespaces in the customer account do not collide with respect to object-identifier resolution. The database platform determines that the object identifier does not specify an account-level namespace, and responsively resolves the object identifier with reference to a current account-level namespace of the database session by identifying an object corresponding to the object identifier in the customer account. | 05-05-2022 |