Patents Assigned to Sybase, Inc.
  • Patent number: 8769553
    Abstract: 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.
    Type: Grant
    Filed: December 15, 2008
    Date of Patent: July 1, 2014
    Assignee: Sybase, Inc.
    Inventor: Samir Nigam
  • Patent number: 8762533
    Abstract: 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.
    Type: Grant
    Filed: June 14, 2010
    Date of Patent: June 24, 2014
    Assignee: Sybase, Inc.
    Inventor: Dilip Sarmah
  • Patent number: 8751441
    Abstract: 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.
    Type: Grant
    Filed: July 31, 2008
    Date of Patent: June 10, 2014
    Assignee: Sybase, Inc.
    Inventors: Heping Shang, Elena Lora-Gallardo, Andrzej Sarapuk
  • Patent number: 8745012
    Abstract: An event stream processing system includes a versioned data structure layered over a log-structured store. A first address handle points to a first version of data in the versioned data structure. A stream of data updates from a data source create a second version of data in the versioned data structure, addressed using a second address handle.
    Type: Grant
    Filed: August 8, 2008
    Date of Patent: June 3, 2014
    Assignee: Sybase, Inc.
    Inventors: Jack Rusher, Scott J. Kolodzieski
  • Patent number: 8745352
    Abstract: Reducing contentions between processes or tasks that are trying to access shared resources is described herein. According to embodiments of the invention, a method of writing a set of data associated with a task to a memory resource is provided. The method includes calculating the amount of memory required to write said data to the memory resource and updating an expected end marker to reflect the amount of memory required to write the data to the memory resource. A flag is then set to an incomplete state, and the data is written to the memory resource. The flag can be set to a complete state and an end marker is updated. The end marker indicates the end of the data stored in the memory resource.
    Type: Grant
    Filed: December 30, 2011
    Date of Patent: June 3, 2014
    Assignee: Sybase, Inc.
    Inventors: Ameya Sakhalkar, Anunay Tiwari, Daniel Alan Wood, Kantikiran Krishna Pasupuleti
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Patent number: 8560495
    Abstract: A system and method to synchronize the processing of messages in areas of an execution graph affected by primitives with potential for substantial delay is provided. A continuous processing system identifies primitives with potential for substantial delay. For each potentially-delayed primitive that is not in a loop, the continuous processing system creates a “timezone” downstream of such primitive. The output(s) of the potentially-delayed primitive is an input to the timezone. The continuous processing system then identifies all other inputs to the timezone and places a synchronizer across such inputs. In cases where the potentially-delayed primitive is within a loop, the timezone includes such primitive, as well all primitives downstream of such primitive.
    Type: Grant
    Filed: June 18, 2007
    Date of Patent: October 15, 2013
    Assignee: Sybase, Inc.
    Inventors: Aleksey Sanin, Ian D. Marshall