Patents Assigned to Sybase
  • Query optimization with memory I/O awareness
    Patent number: 8732163
    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: Grant
    Filed: August 4, 2009
    Date of Patent: May 20, 2014
    Assignee: Sybase, Inc.
    Inventors: Ramanujam Seshadri Halasipuram, Edwin Anthony Seputis
  • Universal short code administration facility
    Patent number: 8718691
    Abstract: Systems and methods for assigning short codes to provide uniformity among wireless carriers. In the systems and methods, a Universal Short Code (USC) Administrator maintains a list of short codes and their lease status so that SMS messages sent to a particular short code may be routed to the proper holder of the short code. A network facilitator is in communication with both the USC Administrator and at least one wireless carrier to route the SMS message to the proper holder of the short code. The short code may be leased for a specified period of time so that the short code can be reassigned after expiration of the lease.
    Type: Grant
    Filed: March 29, 2013
    Date of Patent: May 6, 2014
    Assignee: Sybase 365, Inc.
    Inventors: Philliip J. Sweatman, Robert C. Lovell, Jr., Venkatesh Chava, Christian Zimmern
  • Method for exchanging data concerning an electronic transaction
    Patent number: 8712865
    Abstract: A method for exchanging data concerning an electronic transaction between two entities, includes: a step which consists in determining and booking an origin address (TPOA) in conformity with a bidirectional mobile telephony (GSM) digital messaging service protocol (SMS); a step which consists in sending in accordance with the protocol (SMS), an offer message (OFFRE_SMS) of the transaction (TR), the offer message (OFFRE_SMS) being sent from the first entity (MW) and addressed to the second entity (CL); and a step which consists in sending, from the second entity (CL) and addressed to the first entity (MW), a reply message comprising an information (REP) representing acceptance or rejection of the transaction.
    Type: Grant
    Filed: January 21, 2013
    Date of Patent: April 29, 2014
    Assignee: Sybase 365, Inc.
    Inventor: Carles Guillot
  • System and method for enhanced transaction payment
    Patent number: 8712375
    Abstract: An infrastructure that leverages established wireless messaging paradigms (such as, possibly inter alia, Short Message Service, Multimedia Message Service, Wireless Application Protocol, IP Multimedia Subsystem, etc.) to provide, in new and creative ways, an enhanced level of security for the payment element or portion of a transaction—for example, a transaction within Mobile Commerce (M-Commerce, which, broadly speaking, encompasses the buying and selling of merchant-supplied products, goods, and services through wireless devices), a purchase in the checkout lane of a brick-and-mortar store, a purchase at a (fast-food or other) restaurant, etc. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.
    Type: Grant
    Filed: January 21, 2008
    Date of Patent: April 29, 2014
    Assignee: Sybase 365, Inc.
    Inventor: Robert C. Lovell, Jr.
  • Query optimization with awareness of limited resource usage
    Patent number: 8712972
    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: Grant
    Filed: September 22, 2009
    Date of Patent: April 29, 2014
    Assignee: Sybase, Inc.
    Inventors: Prateem Mandal, Edwin Anthony Seputis
  • Snapshot isolation support for distributed query processing in a shared disk database cluster
    Patent number: 8713046
    Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for snapshot isolation support for distributed query processing in a shared disk database cluster are provided. The embodiments include the forming of object identification data in a leader node of query execution in the shared disk database cluster. At least one fragment of the query execution is distributed to at least one worker node in the shared disk database cluster, and the object identification data is utilized for multiversion concurrency control during query execution by the leader node and at least one worker node.
    Type: Grant
    Filed: December 2, 2011
    Date of Patent: April 29, 2014
    Assignee: Sybase, Inc.
    Inventors: Surendra Kumar Vishnoi, Colin Florendo
  • Data compression for reducing storage requirements in a database system
    Patent number: 8706727
    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: Grant
    Filed: June 19, 2009
    Date of Patent: April 22, 2014
    Assignee: Sybase, Inc.
    Inventors: Xinjun Yang, Xudong Qian
  • Statement logging in databases
    Patent number: 8676749
    Abstract: 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.
    Type: Grant
    Filed: July 31, 2008
    Date of Patent: March 18, 2014
    Assignee: Sybase, Inc.
    Inventors: Heping Shang, Elena Isabel Lora-Gallardo, Andrzej Sarapuk
  • Single Producer, Single Consumer Lockless FIFO/LIFO Queue
    Publication number: 20140064291
    Abstract: A query inserter receives data elements having individual priority types for placement in a queue, and utilizes the priority types of the received data elements to determine placement in the queue relative to an initial location established when a first data element is placed in an empty queue in order to manage the queue with a combination of first-in first-out and last-in first-out queue functionality.
    Type: Application
    Filed: August 30, 2012
    Publication date: March 6, 2014
    Applicant: Sybase, Inc.
    Inventor: Shubhra Sankar BISWAS
  • EXTENSIBLE EXECUTABLE MODELING
    Publication number: 20140068576
    Abstract: Methods, systems, and computer program products for generating executable computer code in an extensible format are provided. A computer-implemented method may include receiving computer source code for compilation and compiling the source code, to generate executable computer code in an extensible format that includes instructions for execution by a computer system configured to process the instructions in the extensible format.
    Type: Application
    Filed: August 30, 2012
    Publication date: March 6, 2014
    Applicant: Sybase, Inc.
    Inventors: Santosh Dattu Pendap, Sergey Babkin, Palaniappan Gandhi, JR., Mohyuddin Rehmattullah, Manbeen P. Kohli, Gregory L. Shtilman, Andrzej Kucharczyk, Joseph Michael Skrzypczak, Kyle James Dohring, Vincent Roy Garofalo, Raphael Hercules Sutton
  • Monitoring distributed task execution using a chained text messaging system
    Patent number: 8650280
    Abstract: Embodiments of a system, method, and computer program product for monitoring task processing in a distributed system are provided. A task controller is provided with a task. The task controller generates a plurality of subtasks from the provided task, where each subtask includes a callback function. The subtasks are distributed for execution to multiple computing devices in the distributed system. As each subtask is executed by a computing device, the callback function is invoked, the invocation generating a message. The message includes the process and status information of the executing subtasks. The process and status information included in the message for each subtask is monitored, analyzed and aggregated, and is transmitted for a display on a client device.
    Type: Grant
    Filed: December 28, 2011
    Date of Patent: February 11, 2014
    Assignee: Sybase, Inc.
    Inventors: Joseph Weizhen Hu, Blaine Carlton French, Vinay Santurkar
  • Hybrid web container for cross-platform mobile applications
    Patent number: 8635522
    Abstract: The systems, methods and computer program products for designing cross-platform mobile applications that execute on multiple operating platforms. The mobile application is activated with a workflow that includes data from a data source. The mobile application includes a plurality of web files configured to cause the mobile application to manipulate data from the data source. At least one web file in the plurality of web files is configured to display one or more screens of the mobile application. At least one file in the plurality of web files is configured to implement business logic of the mobile application. The mobile application also includes a container service configured to communicate data between the mobile device and a data source.
    Type: Grant
    Filed: May 12, 2011
    Date of Patent: January 21, 2014
    Assignee: Sybase, Inc.
    Inventors: Andrew Wai Lee, David John Brandow, Johannes Alberti
  • System and method for enhanced message delivery
    Patent number: 8620359
    Abstract: Coincident with the evolution, maturation, etc. of wireless messaging ecosystems an infrastructure that provides for intelligent and dynamic alternate Multimedia Message Service (MMS) message delivery channels. Occasions may arise where a Mobile Subscriber would like to use their Wireless Device to exchange (for example, MMS) messages but circumstances may prohibit or limit same. On such occasions the MMS messages may be appropriately processed and then routed through one or more alternate message delivery channels such as, possibly inter alia, E-Mail. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.
    Type: Grant
    Filed: October 23, 2008
    Date of Patent: December 31, 2013
    Assignee: Sybase 365, Inc.
    Inventors: William H. Dudley, Marc Rhone Landrum, Robert C. Lovell, Jr.
  • Non-Periodic Check-Pointing for Fine Granular Retry of Work in a Distributed Computing Environment
    Publication number: 20130332938
    Abstract: Distributing work in a distributed computing environment that includes multiple nodes. An individual node can receive a work assignment, which can then be divided into a plurality of work units. A first work unit can then be distributed to a first worker node. At least a portion of the first work unit can be re-distributed to a second worker node in response to determining that the first worker node has experienced a failure condition with respect to the first work unit.
    Type: Application
    Filed: June 7, 2012
    Publication date: December 12, 2013
    Applicant: Sybase, Inc.
    Inventors: Kurt Wilhelm DESCHLER, Kaushal MITTAL, Curtis Grant JOHNSON, Victor MESENZEFF, JR., William Harrison COX
  • System and Method for Intelligent Routeback
    Publication number: 20130324134
    Abstract: An intelligent routeback mechanism that may inter alia receive from an entity (such as for example a wireless carrier) aspects of the entity's messaging traffic, data, etc. with the intelligent routeback mechanism aiding the (1) return (optionally augmented, optionally transformed, etc.) to the entity of that portion of the traffic, data, etc. that the entity is able to deliver itself and (2) delivery of that portion of the traffic, data, etc. that the entity is unable to deliver itself. Such an intelligent routeback mechanism may reside in inter alia a Messaging Inter-Carrier Vendor.
    Type: Application
    Filed: June 21, 2013
    Publication date: December 5, 2013
    Applicant: Sybase 365, Inc.
    Inventors: Mitul Ruparelia, Ilan Dar, Yusuf Hasan, Alexandre Saez
  • COMPOSITE GRAPH CACHE MANAGEMENT
    Publication number: 20130318192
    Abstract: Methods, systems, and computer program products for synchronizing data between a mobile application and an enterprise data source are provided. A computer-implemented method may include receiving a request for data from an application executing on a mobile device, receiving a document including the requested data from a data source where the document represents a graph of data having a plurality of nodes, and providing a partial graph of data to the application where the partial graph is derived from the received document and at least includes the requested data.
    Type: Application
    Filed: May 23, 2012
    Publication date: November 28, 2013
    Applicant: Sybase, Inc.
    Inventors: Brian Keith Lorenz, Johannes Alberti, Lance Waterman
  • CACHE CONFLICT DETECTION
    Publication number: 20130318055
    Abstract: Methods, systems, and computer program products for cache conflict detection are provided. A computer-implemented method may include providing a partial graph of data to an application executing on a mobile device where the partial graph is derived from a document comprising a graph of data having a plurality of nodes, receiving a modified partial graph from the application where the modified partial graph includes one or more changes to the partial graph, and determining a document version used to derive the partial graph is no longer a most recent version of the document.
    Type: Application
    Filed: May 23, 2012
    Publication date: November 28, 2013
    Applicant: Sybase, Inc.
    Inventors: Brian Keith Lorenz, Johannes Alberti, Lance Waterman
  • Plan Caching Using Density-Based Clustering
    Publication number: 20130318069
    Abstract: A query plan predictor receives a query instance according to a query template having a set of parameters. The query plan predictor determines a plan space point for the query instance which is based upon the set of parameters. The query plan predictor predicts a predicted query plan for the plan space point, which is selected from a map of query plans according to a confidence threshold from a plan cache that includes at least one histogram. Each histogram is representative of a cached query plan in the plan cache combined with a previously-selected locality-sensitive hashing function. The histogram stores a frequency distribution of a mapping of sample plan points for the cached query plan by the locality-sensitive hashing function.
    Type: Application
    Filed: May 24, 2012
    Publication date: November 28, 2013
    Applicant: Sybase, Inc.
    Inventors: Günes AluÇ, David E. Dehaan, Ivan T. Bowman
  • System and Method for Dynamic Spam Detection
    Publication number: 20130303204
    Abstract: A flexible, extensible, and dynamically configurable anti-spam facility that operates on a general quanta of data (such as for example a Short Message Service message, a Multimedia Message Service message, an Internet Protocol Multimedia Subsystem message, a Wireless Application Protocol stream, an Electronic Mail message, an Instant Messaging exchange, streaming (audio, video, etc.) data, etc.), innovatively analyzes various attributes of same (such as for example originating address and destination address), and—when an instance of spam is identified—performs one or more remediation activities (such as for example updating a blacklist, updating a greylist, dropping a message, issuing an alert, etc.). The facility may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.
    Type: Application
    Filed: May 8, 2012
    Publication date: November 14, 2013
    Applicant: SYBASE 365, INC.
    Inventor: William H. Dudley
  • Character Data Compression for Reducing Storage Requirements in a Database System
    Publication number: 20130297573
    Abstract: A system, method, and computer program product for character data compression for reducing data storage requirements in a database system are described. Embodiments include identifying data of a particular character type in a full data page, and identifying usage frequency of each character of the particular character type. Each character is encoded based on the identified usage frequency and stored, with storage requirements for most frequently used characters are reduced.
    Type: Application
    Filed: May 7, 2012
    Publication date: November 7, 2013
    Applicant: Sybase Inc.
    Inventors: Xu-dong QIAN, ZhiPing Xiong