Patents Assigned to Sybase
  • Managing Data Storage as an In-Memory Database in a Database Management System
    Publication number: 20110138123
    Abstract: 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.
    Type: Application
    Filed: March 17, 2010
    Publication date: June 9, 2011
    Applicant: Sybase, Inc.
    Inventors: Aditya P. Gurajada, Amarnadh Sai Eluri, Vaibhav A. Nalawade, Jian Wu, Daniel Alan Wood, Yanhong Wang
  • THIN ANALYTICS FOR ENTERPRISE MOBILE USERS
    Publication number: 20110138335
    Abstract: 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.
    Type: Application
    Filed: December 8, 2009
    Publication date: June 9, 2011
    Applicant: Sybase, Inc.
    Inventors: Geogy Zacariah, Zhang Jie
  • On Demand Locking of Retained Resources in a Distributed Shared Disk Cluster Environment
    Publication number: 20110131193
    Abstract: 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.
    Type: Application
    Filed: December 1, 2009
    Publication date: June 2, 2011
    Applicant: Sybase, Inc.
    Inventors: Kantikiran Krishna PASUPULETI, Anantha Krian KANDUKURI
  • COMPLEX PATH-BASED QUERY EXECUTION
    Publication number: 20110131200
    Abstract: 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.
    Type: Application
    Filed: December 1, 2009
    Publication date: June 2, 2011
    Applicant: Sybase, Inc.
    Inventors: Xiao Ming ZHOU, Tat-Keong Loh, Mohyuddin Rehmattullah, Michelle Lim
  • Replication system with methodology for replicating stored procedure calls
    Patent number: 7953698
    Abstract: A replication system with methodology for replicating stored procedure calls is described. In one embodiment, for example, in a database system without support for logging stored procedure invocations, a method of the present invention is described for replicating invocation of a stored procedure from a primary database to a replicate database, the method comprises steps of: inserting table data into the primary database for storing information sufficiently characterizing the procedure's invocation to allow its replication, the table data being logged to a log file; reading the log file, for determining changes to apply to the replicate database for replicating the procedure's invocation; and reconstructing the procedure's invocation at the replicate database based on the determined changes.
    Type: Grant
    Filed: August 3, 2006
    Date of Patent: May 31, 2011
    Assignee: Sybase, Inc.
    Inventors: Wanda Beck, Derek G. Reiger
  • BOOKKEEPING OF DOWNLOAD TIMESTAMPS
    Publication number: 20110125709
    Abstract: 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.
    Type: Application
    Filed: November 24, 2009
    Publication date: May 26, 2011
    Applicant: Sybase, Inc.
    Inventors: Hemal PANDYA, Jitendra Kumar SINGH, Christopher Redvers JOBSON
  • Query Optimization with Awareness of Limited Resource Usage
    Publication number: 20110072008
    Abstract: 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.
    Type: Application
    Filed: September 22, 2009
    Publication date: March 24, 2011
    Applicant: Sybase, Inc.
    Inventors: Prateem MANDAL, Edwin Anthony Seputis
  • System and Method for Enhanced Content Access
    Publication number: 20110059743
    Abstract: A method and system for facilitating HLR access includes receiving a query request from a query entity, processing the query request to yield an SS7 request message, dispatching the SS7 request message to a HLR, receiving an SS7 response message from the HLR, constructing a query response, and returning the query response to the query entity.
    Type: Application
    Filed: November 12, 2010
    Publication date: March 10, 2011
    Applicant: SYBASE 365, INC.
    Inventor: Robert C. Lovell, JR.
  • Extensible Template-Based Code Generator Builder
    Publication number: 20110055800
    Abstract: 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.
    Type: Application
    Filed: August 31, 2009
    Publication date: March 3, 2011
    Applicant: Sybase, Inc.
    Inventor: Gabriel KEVORKIAN
  • Optimizing lock acquisition on transaction logs
    Patent number: 7899794
    Abstract: 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.
    Type: Grant
    Filed: March 20, 2008
    Date of Patent: March 1, 2011
    Assignee: Sybase, Inc.
    Inventors: Vadiraja Bhatt, Nitin Verma, Fei Zhou
  • Remote Electronic Payment System
    Publication number: 20110047082
    Abstract: The invention concerns a remote electronic payment system comprising an authentication device (300) with an authenticating server in a remote payment system, the authentication being performed prior to a transaction carried out by a user. The device (300) is characterised in that it comprises: means (310) for receiving a first authentication request, from the authenticating server; means (330) for verifying the validity of the authentication request; means (350) for validation, by the user, of the transaction; means (370) for controlling said user's identity; and means (380) for sending a return message of authentication, to the authenticating server (900).
    Type: Application
    Filed: November 5, 2010
    Publication date: February 24, 2011
    Applicant: SYBASE 365, INC
    Inventors: Eric Barbier, Christophe Dolique, Carles Guillot
  • Hybrid evaluation of expressions in DBMS
    Patent number: 7895187
    Abstract: A hybrid approach for evaluating expressions in database management systems is described herein. For each expression in an execution location (XL), an execution strategy is selected. The strategies considered are lazy, lazy with memoization, eager, and eager with memoization. The execution strategies are assigned in a way that minimizes the estimated cost of evaluation.
    Type: Grant
    Filed: December 21, 2006
    Date of Patent: February 22, 2011
    Assignee: Sybase, Inc.
    Inventor: Ivan Thomas Bowman
  • PLUGGABLE COMPONENT INTERFACE
    Publication number: 20110041134
    Abstract: 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.
    Type: Application
    Filed: August 17, 2009
    Publication date: February 17, 2011
    Applicant: Sybase, Inc.
    Inventors: Wiechert Wilhelm TEN HAVE, Christopher Hugh Rank, Rene Edward Alexander Quakkelaar, Michael Eugene Bryan, Alyson Denise Crabtree
  • Query Optimization with Memory I/O Awareness
    Publication number: 20110035369
    Abstract: 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.
    Type: Application
    Filed: August 4, 2009
    Publication date: February 10, 2011
    Applicant: Sybase, Inc.
    Inventors: Ramanujam Seshadri Halasipuram, Edwin Anthony Seputis
  • Intermediary system for interconnecting multiple IMS networks
    Patent number: 7886077
    Abstract: An intermediary infrastructure that facilitates the interconnection of multiple IP Multimedia Subsystem (IMS) networks. The interconnections may span one or more of the IMS logical planes Services Plane, Control Plane, and Network or Transport Plane. The intermediary offers among other things a process, routing, and switching complex that is able to among other things process incoming messages including using a comprehensive routing repository to complete message routing operations.
    Type: Grant
    Filed: April 30, 2008
    Date of Patent: February 8, 2011
    Assignee: Sybase 365, Inc.
    Inventors: William H. Dudley, Robert C. Lovell, Jr.
  • Database system with methodology for generating bushy nested loop join trees
    Patent number: 7882100
    Abstract: A database system with methodology for generating bushy nested loop join trees is described. In one embodiment, for example, an improved method is described for optimization of a query requesting data from a database, the method comprises steps of: generating a left deep operator tree for returning data requested by the query based on traversing a left deep operator tree search space; transforming the left deep operator tree into a semantically correct structure for returning data requested by the query; and building a query execution plan for returning data requested by the query based on the semantically correct structure.
    Type: Grant
    Filed: January 24, 2005
    Date of Patent: February 1, 2011
    Assignee: Sybase, Inc.
    Inventor: Mihnea Andrei
  • System and Method for Location Transparency
    Publication number: 20110014930
    Abstract: A service that augments a key element of Unified Messaging and Unified Communications initiatives—i.e., Mobile Subscriber Location Awareness—to enhance substantially the value, usefulness, etc. of the presence awareness, place shifting, etc. components of such initiatives. The service may optionally leverage the capabilities of a centrally-located, full-featured Messaging Inter-Carrier Vendor.
    Type: Application
    Filed: September 27, 2010
    Publication date: January 20, 2011
    Applicant: SYBASE 365, INC.
    Inventor: Robert C. Lovell, JR.
  • System and method for virtual carrier addressing and routing for global short message service
    Patent number: 7860498
    Abstract: Network system and methods for addressing and routing Short Message Service (SMS) messages from international callers to domestic callers using Global System for Mobile Communication (GSM) Mobile Application Part (MAP) Send Routing Info for Short Message (SRI for SM). The systems and methods create a virtual Home Location Register (HLR) and a virtual Mobile Switching Center (MSC) so that an intermediary, which is not itself a carrier, can handle such messages. The systems and methods generate and return an identifier associated with the intermediary as the location for an HLR and a MSC such that the international caller routes the SMS message to the intermediary.
    Type: Grant
    Filed: December 1, 2003
    Date of Patent: December 28, 2010
    Assignee: Sybase 365, Inc.
    Inventors: Robert C. Lovell, Jr., Eric Thomas Wimmer
  • TUNING QUERY EXECUTION PERFORMANCE OF A DATABASE SYSTEM
    Publication number: 20100325124
    Abstract: 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.
    Type: Application
    Filed: June 17, 2009
    Publication date: December 23, 2010
    Applicant: Sybase, Inc.
    Inventors: Juan Wu, Sudipto Rai Chowdhuri
  • Data Compression For Reducing Storage Requirements in a Database System
    Publication number: 20100325094
    Abstract: 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.
    Type: Application
    Filed: June 19, 2009
    Publication date: December 23, 2010
    Applicant: Sybase, Inc.
    Inventors: Xinjun YANG, Xudong Qian