| Sybase, Inc. Patent applications |
| Patent application number | Title | Published |
|---|
| 20120124045 | Parallel Partitioning Index Scan - System, methods and articles of manufacture for joining data in the database tables comprising, performing an index scan on a global index of a first database table, determining rows in the first database table that may be joined with a second database table based on a needed partitioning, wherein the needed partitioning is determined using an index scan, determining a number of partitions in the second database table, and joining each of the corresponding partitions in the first database table with a corresponding partitions in the second database table. | 05-17-2012 |
| 20120124040 | RANKING DATABASE QUERY RESULTS USING AN EFFICIENT METHOD FOR N-ARY SUMMATION - Ranking database query results using an efficient method for N-ary summation is provided. Such operation, referred to herein as “mid-fold N-ary summation” significantly reduces costs of computation for large numbers of queries, as are common in enterprise database applications. Thus, ranking query results using mid-fold N-ary summation offers improved runtime performance and reduced latency relative to using conventional N-ary summation. | 05-17-2012 |
| 20120084315 | Query Plan Optimization for Prepared SQL Statements - System, methods and articles of manufacture for optimizing a query plan reuse in a database server system accessible by a plurality of client connections. An embodiment comprises providing at least one global cache storage and a private cache storage to a plurality of client connections, and coordinating utilization of the at least one global cache storage and the private cache storage to share light weight stored procedures and query plans for prepared SQL statements across the plurality of client connections via the at least one global cache storage while avoiding a spinlock access for executing the prepared SQL statements. | 04-05-2012 |
| 20120078880 | Accelerating Database Queries Containing Bitmap-Based Conditions - Systems, methods and articles of manufacture for accelerating database queries containing bitmap-based conditions are described herein. An embodiment includes determining a bitmap, where the bitmap represents a set of rows that have satisfied one or more conjunctive conditions which preceded a conjunct that is a disjunction in a query expression and restricting evaluation of a disjunct within the disjunction to the set of rows represented by the bitmap. Another embodiment includes determining a satisfaction bitmap, where the bitmap represents the result of one or more preceding disjuncts in a disjunction within a query expression and restricting scope of evaluation of a disjunct to a set of rows that are not within the determined satisfaction bitmap. In this way, embodiments of the present invention enable the acceleration of queries containing disjunctions of conditions on a database table, as well as reduce the temporary resources consumed for such queries. | 03-29-2012 |
| 20120066263 | INCREMENTAL DATA TRANSFER IN A DATABASE MANAGEMENT SYSTEM - System, method, computer program product embodiments and combinations and sub-combinations thereof for incremental data transfer in a database management system (DBMS) are provided. In an embodiment, a database table enabled for partial export from a database management system is identified. Data within the database table to be exported is also identified, and the identified data is transferred in a chosen format from the database table to an export location. | 03-15-2012 |
| 20120059963 | Adaptive Locking of Retained Resources in a Distributed Database Processing Environment - System, method, computer program product embodiments and combinations and sub-combinations thereof for adaptive locking of retained resources in a distributed database processing environment are provided. An embodiment includes identifying a locking priority for at least a portion of a buffer pool, determining lock requests based upon the identified locking priority, and granting locks for the lock requests. | 03-08-2012 |
| 20120047176 | System and Method for Real-Time Content Aggregation and Syndication - A system and methodology for real-time content aggregation and syndication is described. In one embodiment, for example, a method is described for assisting a user with extracting items relevant to search queries from documents including items of various types, the method comprises steps of: receiving a search query specifying a search phrase and a particular item type; identifying documents matching the search phrase; for each matching document, determining whether the document includes an item having the particular item type; and extracting items having the particular item type from the matching documents for display to the user. The solution enables a user to aggregate and syndicate content without a professional content manager or complicated content management software tools. | 02-23-2012 |
| 20120023438 | Fisheye-Based Presentation of Information for Mobile Devices - Embodiments relate to a computer-implemented method for graphically displaying or presenting a fisheye-based view of a large data list on the limited content viewing area of a mobile device. At least a subset of data rows within the data list and graphical representations of a plurality of data fields of at least the subset of data rows are generated and graphically displayed using a graphical user interface of the mobile device. When a user selects a focus row from the displayed data rows, a fisheye-based view of the selected focus row is presented. The fisheye-based view and the graphical representations of the data fields provide the user with a focus-plus-context view of a large data list. Further, the graphical representations provide the user with meaningful information even when particular data items are too small to read specific values. | 01-26-2012 |
| 20120023064 | Parameter Value Binding for Mobile Business Objects - A system, method, and computer program product are provided for facilitating interaction between front-end mobile business objects and back-end enterprise information system data. The approaches described reduce the need for client-visible parameters needed by the enterprise information system, but that can be handled without being directly supplied by a developed of a client application on a mobile device interacting with the enterprise information system via a synchronization server. | 01-26-2012 |
| 20120011458 | Visualizing Expressions for Dynamic Analytics - Embodiments relate to a computer-implemented method for visualizing expressions for dynamic analytics. A graphical user interface control is generated for each of one or more variables of an expression. Each of the one or more variables is bound to the corresponding graphical interface control generated previously. Then, the generated graphical user interface control for each of the one or more variables of the expression is graphically output using a display device. A user may input an adjusted value of each of the one or more variables of the expression using the corresponding graphical user interface control. | 01-12-2012 |
| 20120005158 | Reducing Contention of Transaction Logging in a Database Management System - System, method, computer program product embodiments and combinations and sub-combinations thereof for reducing contention of transaction logging in a database management system (DBMS) are provided. An embodiment includes creating a dependency relationship among private log caches (PLCs) having individual associations with tasks in a DBMS. The dependency relationship is utilized to control buffer pinning and unpinning among the PLCs without involving a flushing of the PLCs during transactions of the tasks. | 01-05-2012 |
| 20110307885 | Enhanced Software License Management - Systems, methods, computer program product embodiments are provided for enhanced license management. An embodiment includes providing an asset management module for managing software license utilization in a computer processing environment, and allowing configuration of the asset management module to designate software license utilization based upon a containment level associated with virtualization capabilities of one or more computer processing systems within the computer processing environment. | 12-15-2011 |
| 20110307552 | Method and System for Moving a Project in a Complex Event Processing Cluster - System, method, computer program product embodiments and combinations and sub-combinations thereof for moving a project in a complex event processing cluster are provided. In an embodiment, project movement in a complex event processing cluster initiates once project persistence capability exists. A handoff of the project from a source node to a destination node in the complex event processing cluster is coordinated by a manager without losing messages and without relying on a message guarantee delivery protocol. | 12-15-2011 |
| 20110296376 | Dynamically Injecting Behaviors Into Flex View Components - Systems, methods and articles of manufacture for dynamically injecting behaviors into view components are described herein. In an embodiment, a view component resides in an MXML file, while its behavior code (e.g., ACTIONSCRIPT) is stored in a separate file (e.g., .as file). In this way, the view component can be reused in separate applications where different behaviors may be applied to the same view component. In addition, because the behavior code is stored in a separate file, the behavior code is easier to read and maintain. Furthermore, behaviors can be dynamically (i.e., at runtime) injected into and un-injected from the view component. Embodiments of the invention also allow multiple behaviors to be injected into the same view component. | 12-01-2011 |
| 20110289119 | METHODS AND SYSTEMS FOR MONITORING SERVER CLOUD TOPOLOGY AND RESOURCES - Systems, methods and articles of manufacture for monitoring server cloud topology and resources are described herein. An embodiment includes determining a topological relationship of the computing nodes in the server cloud and constructing a data structure representing the topological relationship. The constructed data structure includes a plurality of node managed objects (MOs), where each node managed object corresponds to a computing node in the server cloud. The constructed data structure also includes a plurality of link managed objects, where each link managed object corresponds to inter-node communications between two or more computing nodes represented by the node managed objects. The node managed objects and the link managed objects publish events corresponding to changes affecting computing nodes in the server cloud. Embodiments of the invention generate and display a topology view based on the topological relationship and update the displayed topology view (or portions thereof) based on the published events. | 11-24-2011 |
| 20110258688 | RESOURCE MONITORING USING A JMX MESSAGE BRIDGE - A system, method, and computer program product for monitoring managed resources by subscribing to broadcast notifications relayed by a Java Management Extensions (JMX) message bridge between JMX managed beans (JMX MBeans) and a client application with user interface (UI) components. In an embodiment, ADOBE™ FLEX™ user UI components subscribe to JMX broadcast notifications. The method generates messages destined for UI components using a JMX broadcaster. JMX MBeans are created in a JMX server and are subscribed to JMX broadcasts. The JMX MBeans are created with filter values identifying destination UI components. A JMX managed object name is passed to the UI during the creation of the UI components. The UI components become consumers of a message topic. A JMX message adapter dedicated to the communication with the JMX MBeans receives JMX broadcast notifications. Messages generated by the JMX broadcaster are relayed to the destination UI components through the JMX MBeans. | 10-20-2011 |
| 20110252400 | ADDING INHERITANCE SUPPORT TO A COMPUTER PROGRAMMING LANGUAGE - Methods, apparatus and computer program products for supporting inheritance in a programming language are provided. The method includes the steps of: 1) receiving a first programming object from a first file; 1) receiving inheritance information about the first programming object, the inheritance information being from second file; 2) analyzing the inheritance information; 3) creating a second programming object based on the first programming object and the inheritance information; 4) sending the second programming object to an editor for editing; 5) receiving a third programming object from the editor, wherein the third programming object was created by editing the second programming object; 6) creating a fourth programming object based on the first or second programming object, the third programming object and the inheritance information; and 7) storing the fourth programming object in a third file. | 10-13-2011 |
| 20110252124 | DATA REPLICATION TRACING - System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication tracing are provided. In an embodiment, the data replication tracing includes identifying a replication environment within a multi-tier infrastructure of an enterprise data processing network, and monitoring operational performance within the replication environment. A path is rendered on a topology to display data flow for the replication environment based upon a configuration of the replication environment. The data flow may be represented relative to a target data node, relative to a source data node, and/or relative to a replication server. | 10-13-2011 |
| 20110252020 | ENHANCED UTLIZATION OF QUERY OPTIMIZATION - System, method, computer program product embodiments and combinations and sub-combinations thereof for enhanced utilization of query optimization in a database system are provided. In an embodiment, query optimization of the database system is augmented to include statistics on temporary tables through an implicit update statistics option. Further, a statistics update is generated in the database system on a first optimizable query referencing at least one optimizable column of a temporary table when statistics for the at least one optimizable column are not already available. | 10-13-2011 |
| 20110246425 | Managing Data Backup of an In-Memory Database in a Database Management System - System, method, computer program product embodiments and combinations and sub-combinations thereof for backing up an in-memory database. In an embodiment, a backup server is provided to perform backup operations of a database on behalf of a database server. A determination is made as to whether the database is an in-memory database. Database server connections are utilized during data accesses for the backup operations when the database is an in-memory database. | 10-06-2011 |
| 20110238677 | Dynamic Sort-Based Parallelism - A system, method, and computer program product are provided for sorting a set of records in a sort run. As the records are sorted, metadata regarding the sort run is gathered, and subsequently used to determine bounds of two or more disjoint subsets of the sort run. This enables the parallelization of several tasks over the sort run data using efficient, dynamic bounds determination, such as the outputting of sorted data from the disjoint subsets in parallel. | 09-29-2011 |
| 20110238667 | B-Tree Ordinal Approximation - A system, method, and computer program product are provided for generating a range of ordinals corresponding to key values represented in a B-Tree data structure. This allows for a boundary point, usable, for example, for partitioning the B-Tree for parallel processing, to be specified using an ordinal value of the range of ordinals. Then an ordinal-to-key transformation can be performed in order to identify a key value corresponding to the boundary point. Additionally, ordinal values can be identified through the use of key-to-ordinal transformations, allowing for specification of ranges, for example, in terms of key values. | 09-29-2011 |
| 20110225430 | Secured database system with built-in antivirus protection - A secured database system with built-in antivirus protection is described. In one embodiment, for example, a method of the present invention is described for securing a database system, the method comprises steps of: provisioning storage from a storage device, for storing database information; generating an encryption key so that the database information is stored on the storage device in an encrypted manner; generating a decryption key for decrypting the database information stored on the storage device, wherein access to the decryption key is controlled by the database system based on user privileges; receiving a request from a user for access to the database information; determining whether the user has been granted sufficient privileges to access the database information; if the user has been granted sufficient privileges, automatically decrypting the database information to provide the access; and otherwise denying the request if the user has not been granted sufficient privileges. | 09-15-2011 |
| 20110208697 | Synchronization of Recurring Time-Scheduled Data Objects Between Incompatible Databases - Methods, apparatus and computer program products for storing a recurring time-scheduled data record in a calendaring application that does not support a pattern of recurrence of the record are described herein. The method includes the steps of: 1) receiving from a server, the recurring time-scheduled data record having a first recurrence pattern; 2) determining whether the first recurrence pattern is supported by the calendaring application; 3) if the pattern is not supported, then selecting a closest recurrence pattern supported by the calendaring application; 4) modifying the selected closest recurrence pattern by applying recurrence exceptions to create a second recurrence pattern; 5) modifying the recurring time-scheduled data record based on the second recurrence pattern to create a supported record; and 6) transferring the supported record to the calendaring application. | 08-25-2011 |
| 20110179152 | CONTROLLING LIFETIME OF SERVER ADD-INS - System, method, computer program product embodiments and combinations and sub-combinations thereof for controlling lifetimes of server add-ins are described herein. Embodiments of the invention enable a service module, located at a first server, to externally control lifetime of one or more process add-ins located at a second server. An embodiment includes instantiating the service module at the first server and instantiating, using the service module, a controller add-in at the second server. The service module can instantiate the controller add-in to control the lifetime of (i.e. instantiate or terminate) process add-ins at the second server. In an embodiment, such lifetime control can be performed without shutting down the second server or other operations running on the second server. | 07-21-2011 |
| 20110161983 | Dynamic Data Binding for MBOS for Container Based Application - Systems, methods and computer program products for dynamically binding data from a remote data source in a container-based mobile application are described herein. The method includes the steps of: 1) defining a metadata source that references both a mobile business object (MBO) and the mobile application, the MBO being connected to the remote data store; 2) binding an attribute from the MBO to the mobile application using the metadata source; and 3) changing, dynamically, the binding of the attribute while the mobile application is executing. | 06-30-2011 |
| 20110161383 | MESSAGE BASED MOBILE OBJECT WITH NATIVE PIM INTEGRATION - Systems, methods, and computer program products are provided for synchronizing data within a native PIM data store in a device an enterprise data. Data modifications generated by mobile applications on the device, or by an enterprise server, are identified and reflected into the native PIM data store. Additionally, a listener is provided to detect modifications to relevant data within the native PIM data store and reflect these modifications in the mobile applications and the enterprise server. The framework which accomplishes this further provides platform-independent access to the native PIM data store. | 06-30-2011 |
| 20110161349 | MESSAGE BASED SYNCHRONIZATION FOR MOBILE BUSINESS OBJECTS - A system, method, and computer program product are provided for executing a notification query derived from a download cursor for a business object to identify an updated subscription in order to provide updates to a client device in an import message. Additional systems, methods, and computer program products are provided for guaranteeing at-least-once delivery of a message. | 06-30-2011 |
| 20110161339 | PENDING STATE MANAGEMENT FOR MOBILE BUSINESS OBJECTS - A system, method, and computer program product are provided for invoking an operation to change a current data row of a table in a local database. As a result, a pending change data row is inserted in the table, distinguished by a primary key comprising a common key value and a pending change indicator. The pending change is then submitted for synchronization. | 06-30-2011 |
| 20110161290 | DATA CACHING FOR MOBILE APPLICATIONS - Systems, methods, computer program product embodiments and combinations and sub-combinations thereof for data caching and cache synchronization are described herein. An embodiment includes comparing data in a cache with data stored at a data source and determining database operations needed to synchronize one or more partitions of the cache with the data source. Each cache partition is associated with mobile business object (MBO) metadata of a distinct mobile device and the determined database operations are executed to synchronize the partitions with the data source. By refreshing only those partitions which are pertinent to a given device, embodiments of the invention may increase parallelism by allowing multiple partitions to refresh concurrently. The embodiment further comprises reviewing a caching policy associated with the cache. The caching policy may be selected in a manner that reduces data traffic and redundant requests on the data source. | 06-30-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 |
| 20110154287 | Visual Generation of Mobile Applications Based on Data Models - Systems, methods and computer program products for mobile device application design are described herein. The method accesses a data model corresponding to a selected mobile platform. The data model is used by a device application designer to generate, model, and debug a mobile application. The data model is used to take into consideration characteristics of the selected platform and a selected mobile device as the application is designed. The application is structured and generated for a selected platform that is independent of the data model, but is cognizant of the selected platform. A simulator models the application user interface (UI) as it will appear on the selected platform. The method performs platform-specific validation and allows for correction of various aspects of a generated application including platform-specific features. The tool generates a graphical image that can guide a developer to either generated code or help files corresponding to framework libraries. | 06-23-2011 |
| 20110153836 | DYNAMIC ATTRIBUTES FOR MOBILE BUSINESS OBJECTS - Embodiments of the present invention relate to system, method, computer program product embodiments and combinations and sub-combinations thereof for generating dynamic attribute elements and dynamic attributes for MBOs. An embodiment includes generating dynamic attribute elements for MBO metadata in a manner that enables a mobile application to directly access and modify dynamic attributes included within the dynamic attribute elements. In an embodiment, dynamic attributes are included within the dynamic attribute elements arbitrarily to synchronization sessions of a server and a mobile application. The embodiment also allows the mobile application to set a value associated with a dynamic attribute. Another embodiment includes embedding a dynamic attributes entity in generated client code and downloading dynamic MBO attributes and associated metadata when the client synchronizes with the server. | 06-23-2011 |
| 20110153568 | HIGH VOLUME, HIGH SPEED ADAPTIVE DATA REPLICATION - System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication in a database system environment are described. In an aspect, the data replication includes grouping, in-memory, a plurality of transactions to be replicated as a single transaction from a source database system to a target database system. A plurality of net row changes is compiled for the plurality of transactions, and data inconsistency detection and resolution within a command application order are performed. Further included is bulk application of the plurality of net row changes to the target database system. | 06-23-2011 |
| 20110138335 | THIN ANALYTICS FOR ENTERPRISE MOBILE USERS - A system, method, and computer program product are provided for creating expressions through the use of an expression builder. This allows the exploitation of additional views of data in a local data store without the need to rely on an enterprise server to push this data to a user device. Meta data descriptions of a local data source as properties are provided in order to generate an expression builder interface which can be used to combine these properties with mathematical expressions to derive new views of the local data. | 06-09-2011 |
| 20110138123 | Managing Data Storage as an In-Memory Database in a Database Management System - System, method, computer program product embodiments and combinations and sub-combinations thereof for managing data storage as an in-memory database in a database management system (DBMS) are provided. In an embodiment, a specialized database type is provided as a parameter of a native DBMS command. A database hosted entirely in-memory of the DBMS is formed when the specialized database type is specified. | 06-09-2011 |
| 20110131200 | COMPLEX PATH-BASED QUERY EXECUTION - Systems, methods, computer program product embodiments are provided for executing a function in a path-based query when extracting data from a markup language document for return as a relational table, the markup language document organized hierarchically into nodes. An embodiment includes receiving a path-based query including a complex row pattern and column definition, forming multiple sets of nodes based on a simplified row pattern and column definition, determining ancestor-descendent pairings for the nodes in the column definition set, and utilizing the ancestor-descendent pairings with the simplified row pattern to return a relational table satisfying the complex path-based query. An embodiment further includes extensible markup language (XML) as the markup language, and an XPath query expression as the complex path-based query. | 06-02-2011 |
| 20110131193 | On Demand Locking of Retained Resources in a Distributed Shared Disk Cluster Environment - Systems, methods, computer program product embodiments are provided for locking retained resources of database information in a distributed shared disk cluster environment. An embodiment includes providing a request on demand for physical access to a page by a task of a node among a cluster of nodes, managing selective bypassing of waiting access requests to the page at intranode and internode levels in response to the request on demand, and handling requests for page ownership to prioritize a request on demand. Further included are determining whether another node holds a lock on the page and identifying an access type for the waiting access requests in order to coordinate transfer of the lock to the node. | 06-02-2011 |
| 20110125709 | BOOKKEEPING OF DOWNLOAD TIMESTAMPS - Systems, methods and computer program products for bookkeeping of download stamps are described herein. An embodiment includes augmenting database table (or mobile business object) metadata with a synchronization (“sync”) key and assigning a unique identifier to each sync key. A sync key is assigned to one or more rows (or records) in the database table and a download timestamp is associated with each sync key. The embodiment further includes identifying a sync key associated with each row in the database table. Links between rows occurring in different database tables are maintained using sync keys. In this way, embodiments of the invention allow a server to record a download timestamp of database table subsets, where such subsets may include one or more rows in the database tables. This allows data to be downloaded by a client at subset granularity. | 05-26-2011 |
| 20110072008 | Query Optimization with Awareness of Limited Resource Usage - System, method, computer program product embodiments and combinations and sub-combinations thereof for tuning query execution performance in a database management system are described. In an aspect, query optimization in a database management system (DBMS) with awareness of limited resource usage includes identifying limited resource usage for each possible plan being considered for query execution by a query engine. A determination of whether any possible plan has limited resource usage that does not exceed a threshold level is made, and when at least one possible plan does not exceed the threshold level, the identified limited resource usage is included as a consideration during plan selection by the query engine. In an embodiment, temporary database usage is identified for each possible plan. | 03-24-2011 |
| 20110055800 | Extensible Template-Based Code Generator Builder - A system, method, and computer program product are provided for producing aspects of a generation model. These include a domain model having one or more elements, and templates defined for the elements. The generation model is used to compile a code generator, which can be used to generate code from an input conforming to the domain model. | 03-03-2011 |
| 20110041134 | PLUGGABLE COMPONENT INTERFACE - A system, method, and computer program product are provided for initiating an application in communication with a database management system via a bridge. Application memory is allocated to the application from a shared memory space within the database management system. | 02-17-2011 |
| 20110035369 | Query Optimization with Memory I/O Awareness - System, method, computer program product embodiments and combinations and sub-combinations thereof for tuning query execution performance in a database management system are described. In an aspect, query optimization in a database management system (DBMS) with memory I/O (input/output) awareness includes determining compensated physical I/O (PIO) values indicative of memory I/O operations, including an approximate cache occupancy level, of an executing query in a DBMS, and utilizing the compensated PIO values as feedback to a query optimizer of the DBMS for optimization of future query execution. | 02-10-2011 |
| 20100325169 | Representing Markup Language Document Data in a Searchable Format in a Database System - Systems, methods, computer program product embodiments for representing markup language document data in a searchable format in a database system are provided. An embodiment includes parsing a markup language document into a data stream, the data stream including a plurality of fields in a predefined format having a symbol table for at least one field of the data stream, and optimized field size based on a maximum value of data within each field, and storing the data stream in data storage. | 12-23-2010 |
| 20100325124 | TUNING QUERY EXECUTION PERFORMANCE OF A DATABASE SYSTEM - Methods, systems, and computer program products for tuning query execution performance in a database management system are described. In an embodiment, query performance issues of chosen database operational logic in a database management system are identified with an external utility provided for use on top of the database management system. The identified query performance issues are resolved selectively in the database management system without modifying the chosen database operational logic. | 12-23-2010 |
| 20100325094 | Data Compression For Reducing Storage Requirements in a Database System - A system, method, and computer program product for reducing data storage requirements in a database system are described herein. An embodiment includes identifying at least one data candidate of fixed length data type in at least one row of database data for compression based upon a predetermined threshold level and a boundary of compression, providing at least one bit within the at least one row for an identified data candidate according to the boundary of compression, and storing the at least one row as compressed data in the database system. For compression based on a row boundary, the identified data candidates for compression include fixed length columns having lengths that do not fall below the predetermined threshold level in a row of data and the at least one bit comprises a bitmap for a length of the identified data candidates following compression. For compression based on a page boundary, the identified data candidates for compression include redundant byte string data in a page of data, the redundant byte string data including matching data across columns having lengths that do not exceed the predetermined threshold level. | 12-23-2010 |
| 20100290623 | PROTECTION OF ENCRYPTION KEYS IN A DATABASE - System, method, computer program product embodiments and combinations and sub-combinations thereof for protection of encryption keys in a database are described herein. An embodiment includes a master key and a dual master key, both of which are used to encrypt encryption keys in a database. To access encrypted data, the master key and dual master key must be supplied to a database server by two separate entities, thus requiring dual control of the master and dual master keys. Furthermore, passwords for the master and dual master keys must be supplied separately and independently, thus requiring split knowledge to access the master and dual master keys. In another embodiment, a master key and a key encryption key derived from a user password is used for dual control. An embodiment also includes supplying the secrets for the master key and dual master key through server-private files. | 11-18-2010 |
| 20100229225 | SYSTEM AND METHOD FOR SECOND FACTOR AUTHENTICATION - As individuals increasingly engage in different types of transactions they face a growing threat from, possibly among other things, identity theft, financial fraud, information misuse, etc. and the serious consequences or repercussions of same. Leveraging the ubiquitous nature of wireless devices and the popularity of (Short Message Service, Multimedia Message Service, etc.) messaging, an infrastructure that enhances the security of the different types of transactions within which a wireless device user may participate through a Second Factor Authentication facility. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor. | 09-09-2010 |
| 20100169947 | SYSTEM AND METHOD FOR MOBILE USER AUTHENTICATION - As individuals increasingly employ their wireless devices to engage in different types of activities they face a growing threat from, possibly among other things, identity theft, financial fraud, information misuse, etc. and the serious consequences or repercussions of same. Leveraging the ubiquitous nature of wireless devices and the popularity of (Short Message Service, Multimedia Message Service, etc.) messaging, an infrastructure that enhances the security of the different types of activities within which a wireless device user may participate through dynamically configurable levels of authentication. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor. | 07-01-2010 |
| 20100114843 | Index Compression In Databases - Systems, methods and computer program products for compression of database indexes are described herein. A system embodiment includes a sequence determiner to scan a database index and to determine a start of a range and end of a range of consistently changing values in one or more index pages of said database index and an index updater to update said database index based on a sequence determined by said sequence determiner, while suspending writing of one or more values that lie within start of said range and end of said range of values. A method embodiment includes scanning an index, determining a pattern of changing values in one or more index pages of said index and selectively updating said index based on said determining step to minimize index insertions. The method embodiment further includes determining a start of a range of values and an end of said range of values in an index page, setting appropriate bits to identify said start of range of values and end of range of values, determining if an entry to be inserted can appended to at the end of said range of values, and compressing said index by suspending writing of one or more values that occur between said start of range of values and said end of range of values. | 05-06-2010 |
| 20100030824 | STATEMENT LOGGING IN DATABASES - System, method, computer program product embodiments and combinations and sub-combinations thereof for logging of data manipulation language (DML) statements are described herein. An embodiment includes a database engine, a replication agent and a replication server which replicates data from the database engine to one or more replicate databases. The database engine writes parsed query information into a transaction log so that a process of replication agent may read the parsed query information and forward it to the replication server. The database engine writes all log records associated with a statement in a manner that allows the replication server to distinguish if those log records belong to same statement. In another embodiment, replication agent selectively sends SQL statement information to the replication server based on the replication server architecture. | 02-04-2010 |
| 20100030817 | STATEMENT CATEGORIZATION AND NORMALIZATION - Systems, methods and computer program products for statement categorization and normalization are described herein. An embodiment includes a statement categorizer and a statement normalizer. The statement categorizer categorizes statements to reduce or even eliminate inconsistencies that may arise between primary and replicate databases as a result of executing certain statements. Categorized statements are normalized by the statement normalizer to generate normalized statements, which are provided to a replication server. Normalized statements assist replication server to regenerate a statement to be executed on a replicate database. | 02-04-2010 |
| 20100030783 | Metadata Driven Mobile Business Objects - A system, method, and computer program product are provided for abstracting data in a remote data source. A method operates by defining the data source, defining a data synchronization methodology for communication with the data source, and providing an abstraction layer for accessing data in the data source. The abstraction layer implements the data synchronization methodology when data is accessed through the abstraction layer is presented. | 02-04-2010 |
| 20100030730 | System, Method, and Computer Program Product for Determining SQL Replication Process - A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention. | 02-04-2010 |
| 20100029306 | Mobile Banking with Short Message Service - A system, method, and computer program product are provided for interfacing a user device to a transaction system. An instruction is received from an SMS gateway in an SMS message, and is parsed to obtain a corresponding transaction. A function on the transaction system for performing the transaction is called, and a response is received from the transaction system. The response is then transmitted to the user device in a response SMS message. | 02-04-2010 |
| 20100025460 | Mobile Banking Architecture - A system, method, and computer program product are provided for interfacing a user device to a transaction system. An interface is provided in order to call a function on the transaction system for performing the transaction. | 02-04-2010 |
| 20100017812 | Deploy Anywhere Framework For Heterogeneous Mobile Application Development - A system, method, and computer program product are provided for developing a portable software application. The method includes the steps of defining a project, adding a screen to the project, the screen being defined as a generic screen or a platform-specific screen, adding a component to the screen, the component being defined as a generic component or a platform-specific component, redefining the screen as a platform-specific screen when it is defined as a generic screen and one or more platform-specific components have been added to the screen, and defining an application flow from the screen to one or more additional screens. | 01-21-2010 |
| 20100010976 | Relocated Joins In A Distributed Query Processing System - A system, method, and computer program product are provided for performing a join operation between a local table at a local server and a remote table at a remote server. In accordance with an embodiment of the present invention, a query instruction to join the local table and the remote table is received at the remote server. Qualifying rows of the local table are then retrieved to the remote server, and the remote table is joined with the qualifying rows to generate a result table, which is then sent to the local server. | 01-14-2010 |
| 20100010962 | Deferred Compilation of Stored Procedures - A system, method, and computer program product are provided for compiling a stored procedure in a database. The compiling includes the steps of invoking the stored procedure, the stored procedure comprising one or more statements, substituting run-time values for one or more variables in the statements, and creating an access plan for the statements having the substituted run-time values. | 01-14-2010 |
| 20090327429 | COLLABORATIVE ALERT MANAGEMENT AND MONITORING - Methods, systems, and computer program products for dynamically monitoring, processing, and managing alerts are described herein. In an embodiment, the method operates by receiving messages that are either alerts or responses to existing alerts. The messages are parsed to determine if whether they are alerts or responses to alerts. Actions including updating alert states and storing alert data are executed, and then the method sends notifications regarding the alert messages and responses to a collaboration list of registered subscribers that dynamically expands over time based upon alert escalations. The method then determines whether additional messages have been received; and performs actions associated with these additional messages until there are no remaining alerts or alert responses to process. The method stores updated alert and response data in a repository so that the alerts and responses can be monitored and managed. | 12-31-2009 |
| 20090240739 | Optimizing Lock Acquisition on Transaction Logs - A system, method, and computer program product for improving physical lock acquisition for database transaction logs are described herein. In an embodiment, the method operates by receiving a request for a transaction log page and determining whether a requested log page is newly-allocated or already exists. A determination is made regarding whether the last log page is being modified. A physical lock is taken on the requested log page when it has been determined that the requested log page is not newly-allocated and that the last log page is not being modified. Operations on the last log page are synchronized without a physical lock when it is determined that the requested log page is newly-allocated or that the last log page is being modified. | 09-24-2009 |
| 20090171936 | System, Method, and Computer Program Product for Accelerating Like Conditions - A system, method, and computer program product are provided for optimizing LIKE-condition based queries on a table in a database system. | 07-02-2009 |
| 20090171921 | Accelerating Queries Based on Exact Knowledge of Specific Rows Satisfying Local Conditions - A method, computer program product, and system are provided for accelerating a query in a database system. For example, an embodiment of the method may include generating a data structure identifying a set of rows that satisfy conditions local to a table prior to an evaluation of a query and modifying the query based on the data structure. In addition, the method may include repeating the steps with respect to generating the data structure and modifying the query, if one or more additional local conditions are inferred from modifying the query based on the data structure. With respect to the step of modifying the query based on the data structure, in the case where no rows satisfy the local conditions in the data structure, an always false prefilter condition may be migrated as high as possible within the query. When only one row satisfies the local conditions in the data structure, a column may be replaced by a constant value from within that column in that one row. Further, in the case where a moderate number of rows satisfy the local conditions in the data structure and if sensible from a cost basis analysis, an IN condition may be inferred for each column from that table involved in a join condition. Application of these modifications prior to a determination of a query execution plan allows a query to be executed more efficiently and with far lower risk of applying a suboptimal execution plan. | 07-02-2009 |
| 20090171916 | Method For Accelerating Queries Containing Local Range Conditions Using Subtraction of Cumulative Bitmaps - A system, method, and computer program product are provided for optimizing a range-based query on a table in a database system. | 07-02-2009 |
| 20090150970 | Data Fading to Secure Data on Mobile Client Devices - Methods, systems, and computer program products to secure data stored on mobile client devices are provided. In an embodiment, the method operates by defining one or more security policies. Each security policy comprises a plurality of security policy parameters. The method stores the security policies in a data store, and selects a security policy from among the stored security policies for a mobile client device. The selected security policy is applied to the mobile client device. The mobile client device determines whether it is compliance with parameters of said selected security policy, and performs data fade actions if it is determined that it is out of compliance with said security policy parameters. | 06-11-2009 |
| 20090150680 | Data Security in Mobile Devices - Systems, methods for computer program products for securely storing data in a data store or in an external data store associated with a mobile device are described herein. Data that is being sent from an application module to a data store, on the mobile device or an external data store used by the mobile device is first encrypted by a security manager. The security manager encrypts data based on an encryption algorithm that may be selected by a user. Data received from an application module is thus stored in an encrypted form on a data store. When an application requests data from the data store, the security manager decrypts the data and provides the data to the application module in its decrypted form. All data that is transmitted to or received from a data store or an external data store is intercepted by the security manager for encryption and decryption respectively. | 06-11-2009 |
| 20090100004 | System And Methodology For Automatic Tuning Of Database Query Optimizer - System and methodology for automatic tuning of database query optimizer is described. In one embodiment, in a database system having an optimizer for selecting a query plan for executing a database query, a method of the present invention is described for automatically tuning query performance to prevent query performance regression that may occur during upgrade of the database system from a prior version to a new version, the method comprises steps of: in response to receiving a given database query for execution, specifying a query plan generated by the prior version's optimizer as a baseline best plan for executing the given database query; generating at least one new query plan using the new version's optimizer; learning performance for each new query plan generated by recording corresponding query execution metrics; if a given new query plan is observed to have better performance than the best plan previously specified, specifying that given new query plan to be the best plan for executing the given database query; if a given new query plan is observed to have worse performance than the best plan previously specified, specifying that given new query plan to be a bad plan to be avoided in the future; and automatically tuning future execution of the given database query by using the query plan that the system learned was the best plan. | 04-16-2009 |
| 20090037484 | Programming system for occasionally-connected mobile business applications - A system, method, and computer program product are provided for synchronizing a local database with a remote database. Additionally, a system, method, and computer program product are provided for performing a service operation on a database, the database located on a database system. | 02-05-2009 |
| 20090037430 | Unwired enterprise platform - Systems, methods and computer program products for inherently integrating mobility with an enterprise are described herein. Enterprise data is accessed from one or more data sources data sources, wherein such data sources may comprise structured and unstructured data sources. The data is transferred from the enterprise to a plurality of mobile devices over a plurality of diverse networks. In an embodiment, such transfer takes into consideration characteristics of the diverse networks. The enterprise receives data generated by mobile devices while performing enterprise-related operations at the wireless edge. The enterprise responds to environmental changes using the received data. | 02-05-2009 |
| 20090037395 | Persistent query system for automatic on-demand data subscriptions from mobile devices - A system, method, and computer program product are provided for creating a data subscription to a remote database. Additionally, a system, method, and computer program product are provided for creating a persistent query, wherein a table in a remote database is represented by a meta-data definition. | 02-05-2009 |
| 20090037367 | System and Methodology Providing Workload Management in Database Cluster - A system and methodology providing workload management in a database cluster. In one embodiment, for example, a method for allocating workload amongst a plurality of database servers sharing access to data comprises steps of: periodically collecting information about workload at each database server; distributing the workload information to each of the plurality of database servers; in response to a client connected to a first database server requesting that work be performed, examining the workload information to determine whether the requested work should be performed at a second database server having a lower workload than the first database server; if it is determined that the work should be performed at the second database server, automatically transferring the client connection to the second database server and performing the requested work at the second database server; and otherwise, performing the requested work at the first database server. | 02-05-2009 |
| 20090036102 | Context-Based Data Pre-Fetching and Notification for Mobile Applications - Methods, systems, and computer program products for context-based data pre-fetching and notification for applications are described herein. In an embodiment, the method operates by creating a context model that includes context variables and events. The method populates context variables based upon the context of an application and instantiates a context based upon the context model. The method determines whether the context is active or inactive and infers a likely set of data needed by the application. The method executes a data selection function to generate a dataset for the application. In an embodiment, the system includes a module to create and maintain a context model. The system includes modules to: populate context variables within the context model; calculate a dataset for the application; maintain an inference engine; subscribe to changes in the context variables; and generate notifications including a dataset with associated metadata that assists with display of the dataset. | 02-05-2009 |
| 20090024574 | System and Methodology for Extraction and Aggregation of Data from Dynamic Content - A system and methodology for extraction and aggregation of data from dynamic content is described. In one embodiment, for example, a method is described for extracting and structuring items of data from content available via the Internet, the method comprises steps of: receiving input of a user specifying at least one source of content available via the Internet, types of data to be extracted from the at least one source, and fields for structuring extracted items of data; retrieving content from the at least one source; parsing the retrieved content to extract items of data of the types specified by the user; and mapping the extracted items of data to the fields specified by the user so as to transform the extracted items of data into a structured format. | 01-22-2009 |
| 20080294648 | Distributed Database System Providing Data and Space Management Methodology - A distributed database system providing data and space management methodology. In one embodiment, for example, a method for transferring a data structure in cache at a first database server to a second database server in a distributed database system comprises steps of: determining a first database server having a data structure in cache in response to a request for the data structure from a second database server, the request including a request for a lock on the data structure; providing the request for the data structure to the first database server; in response, sending the data structure from the first database server to the second database server; and receiving and using the data structure at the second database server without waiting for the lock request to be explicitly granted. | 11-27-2008 |
| 20080294645 | System, method and computer program product for EDI-to-EDI translations - Systems, methods and computer program products for mapping an inbound EDI (Electronic Data Interchange) transaction to one or more outputs are described herein. An embodiment operates by receiving an inbound EDI transaction, and translating the inbound EDI transaction to any combination of EDI outbound transactions and non-EDI outbound transactions. Such translation is performed according to a map file, which is generated as follows. The inbound and any outbound EDI transactions are defined, and templates of the inbound and outbound EDI transactions are also defined. Then, mappings between the template of the inbound EDI transaction and the templates of the outbound EDI transactions are defined. A mapping between the inbound EDI transaction and application data may also be defined, where the application data may include a text file, a XML file, and/or a table of a database. Rules relating to or governing the mapping of the inbound EDI transaction to outputs may also be created. These definitions, mappings and rules are stored in the map file. | 11-27-2008 |
| 20080235298 | Distributed Database System Providing Data and Space Management Methodology - A distributed database system providing data and space management methodology. In a distributed database system having an allocation page for tracking allocation and deallocation of data pages including a deallocation bit for tracking data page deallocation, a method for determining when to clear the deallocation bit during recovery comprises: during runtime operation, generating log records recording allocation and deallocation of data pages, setting the deallocation bit during deallocation of a data page by a transaction, and clearing the deallocation bit after the transaction has committed; during recovery following a failure, identifying a particular log record corresponding to the deallocation bit set during deallocation of a given data page; determining whether the deallocation of the given data page recorded in the particular log record committed prior to the failure; and if the deallocation of the given data page committed prior to the failure, clearing the deallocation bit. | 09-25-2008 |
| 20080208938 | Distributed Database System Providing Data and Space Management Methodology - A distributed database system providing data and space management methodology. In a distributed system comprising a plurality of servers sharing access to data pages, a method for setting a timestamp indicating when modifications to data pages are made in a non-regressing fashion comprises steps of: maintaining a local sequence at each server and an allocation page timestamp on an allocation page; upon allocation of a data page, applying a timestamp to the data page which is greater than the allocation page timestamp; upon modification of a given data page at a particular server, setting the timestamp on the given data page to the greater of the local sequence at the particular server and an existing timestamp already on the given data page; and when data pages are deallocated, adjusting the allocation page timestamp to a value greater than the timestamp value on any deallocated data page. | 08-28-2008 |
