Настройки

Укажите год
-

Небесная энциклопедия

Космические корабли и станции, автоматические КА и методы их проектирования, бортовые комплексы управления, системы и средства жизнеобеспечения, особенности технологии производства ракетно-космических систем

Подробнее
-

Мониторинг СМИ

Мониторинг СМИ и социальных сетей. Сканирование интернета, новостных сайтов, специализированных контентных площадок на базе мессенджеров. Гибкие настройки фильтров и первоначальных источников.

Подробнее

Форма поиска

Поддерживает ввод нескольких поисковых фраз (по одной на строку). При поиске обеспечивает поддержку морфологии русского и английского языка
Ведите корректный номера.
Ведите корректный номера.
Ведите корректный номера.
Ведите корректный номера.
Укажите год
Укажите год
Применить Всего найдено 316. Отображено 100.
05-01-2012 дата публикации

Reducing Contention of Transaction Logging in a Database Management System

Номер: US20120005158A1
Автор: Bhatt Vadiraja Puttige, Pattipaka Subramanyam
Принадлежит: Sybase, Inc.

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. 1. A method for reducing contention of transaction logging in a database management system (DBMS) , the method comprising:creating a dependency relationship among private log caches (PLCs) having individual associations with tasks in a DBMS; andutilizing the dependency relationship to control buffer pinning and unpinning among the PLCs without involving a flushing of the PLCs during transactions of the tasks.2. The method of wherein creating a dependency relationship further comprises annotating the PLCs with synchronization markers.3. The method of wherein annotating further comprises marking the PLCs according to modifications of pages in the PLCs by unassociated tasks to synchronize an order for flushing of the PLCs.4. The method of wherein flushing of the PLCs occurs without contention between a PLC flusher and a user task appending log records claim 3 , and with a reduction in contention on buffer latches.5. The method of further comprising utilizing a counter to identify a level of dependency of a PLC as a result of the modifications.6. The method of further comprising performing PLC flushing to fulfill the dependency relationship.7. The method of further comprising utilizing a flusher task for performing PLC flushing.8. The method of where in utilizing a flusher task further comprising reducing PLC flushes in transaction code paths.9. A system for reducing contention of database transaction logging claim 7 , the system comprising:a computer processing ...

Подробнее
Номер записи: 1
12-01-2012 дата публикации

Visualizing Expressions for Dynamic Analytics

Номер: US20120011458A1
Автор: HO Yean Fee, XIA Steven Qian
Принадлежит: Sybase, Inc.

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. 1. A computer-implemented method for visualizing expressions for dynamic analytics , comprising:evaluating an expression having a plurality of variables using expression data corresponding to the variables;generating graphical user interface controls for the variables of the expression;binding each variable of the expression to one or more graphical user interface controls generated in the generating step;graphically displaying the bound graphical user interface controls for the variables of the expression;receiving from a user an adjusted value of at least one of the variables, the user having adjusted said at least one of the variables using graphical user interface controls bound to said at least one of the variables; andre-evaluating the expression using the adjusted value of the at least one of the variables.2. The method of claim 1 , wherein the evaluating comprises:retrieving the expression data corresponding to the variables; andevaluating the expression using the retrieved expression data.3. The method of claim 1 , wherein the generating comprises generating the graphical user interface controls for the variables of the expression based on a definition of each of the variables claim 1 , wherein the definition includes a type of graphical user interface control.4. The method of claim 1 , wherein the generating comprises generating the graphical user ...

Подробнее
Номер записи: 2
26-01-2012 дата публикации

Parameter Value Binding for Mobile Business Objects

Номер: US20120023064A1
Автор: IRELAND Evan
Принадлежит: Sybase, Inc.

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. 1. A method comprising:obtaining a specification for an enterprise information system operation comprising one or more parameters;identifying a mobile business object related to the enterprise information system operation; anddefining a binding for the one or more parameters.2. The method of claim 1 , wherein defining the binding comprises:defining a binding for one of the one or more parameters to a constant value.3. The method of claim 2 , further comprising:utilizing the constant value as a default for the one of the one or more parameters if an additional binding to the one of the one or more parameters comprises null data.4. The method of claim 1 , wherein defining the binding comprises:defining a binding for one of the one or more parameters to an expression.5. The method of claim 1 , wherein defining the binding comprises:defining a binding for one of the one or more parameters to a personalization parameter.6. The method of claim 1 , wherein defining the binding comprises:defining a binding for one of the one or more parameters to a foreign attribute of an additional mobile business object.7. The method of claim 1 , wherein defining the binding comprises:defining a binding for one of the one or more parameters to a value path, the value path comprising an attribute of the mobile business object.8. The method of claim 1 , further comprising:receiving a call to an operation of the mobile business object, the operation of the mobile business object corresponding to the enterprise ...

Подробнее
Номер записи: 3
26-01-2012 дата публикации

Fisheye-Based Presentation of Information for Mobile Devices

Номер: US20120023438A1
Автор:
Принадлежит: Sybase, Inc.

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. 1. A computer-implemented method for displaying a fisheye-based view of a data list on a mobile device , comprising:accessing said data list on the mobile device, said data list comprising data rows, wherein each data row has a plurality of data fields;generating graphical representations of the plurality of data fields for at least a subset of the data rows of said data list based on respective values of each of the plurality of data fields;graphically displaying at least the subset of data rows and the generated graphical representations using a graphical user interface of the mobile device;receiving a selection of a focus row from a user via the graphical user interface; andgraphically presenting the fisheye-based view of the selected focus row to the user, wherein the selected focus row is displayed at a higher level of detail than other graphically displayed data rows,wherein the user may determine relative values of the plurality of data fields by viewing the graphically displayed data rows and the graphical representations of the plurality of data fields even if sizes of the displayed data rows are too small to read ...

Подробнее
Номер записи: 4
16-02-2012 дата публикации

System and Method for Message-Based Interactive Services

Номер: US20120040638A1
Автор: Jr. Robert C., Lovell
Принадлежит: SYBASE 365, INC.

A method and system for providing message-based interactive services includes receiving a short code message from a mobile subscriber relating to a service desired by the mobile subscriber from an interactive service device, routing the short code message for processing, and instructing the interactive service device to operate in accordance with the short code message. 1. In a messaging intermediary , a server-based method for providing message-based interactive services , the server-based method comprising:receiving through a messaging construct a service request from a wireless device of a mobile subscriber relating to a service desired by the mobile subscriber from an interactive service device, the service request comprising (a) a destination address and (b) an indicia of the interactive service device; andprocessing the service request, including at least initiating a billing transaction, such that in due course the interactive service device is caused to operate to effect the service desired by the mobile subscriber,wherein the interactive service device (a) resides on a network and is assigned an address on same and (b) does not communicate via the messaging construct for purposes of being caused to operate to effect the service desired by the mobile subscriber.2. The server-based method of claim 1 , wherein the messaging construct is one of (a) Short Message Service (SMS) messaging or (b) Multimedia Messaging Service (MMS) messaging.3. The server-based method of claim 1 , wherein the destination address is a short code.4. The server-based method of claim 1 , wherein the billing transaction comprises a transfer of funds from a first account to a second account.5. The server-based method of claim 1 , wherein the processing the service request step further comprises:confirming that the interactive service device is available for use.6. The server-based method of claim 1 , further comprising:responsive to initiation of operation of the interactive service ...

Подробнее
Номер записи: 5
16-02-2012 дата публикации

System and Method for Advanced Interoperability

Номер: US20120042097A1
Автор: Dudley William H.
Принадлежит: SYBASE 365, INC.

Enhanced interoperability (e.g., connectivity, communication, processing, routing, billing, etc.) capabilities are provided through an IP eXchange (IPX) facility that among other things may offer a simple, consolidated, etc. interface mechanism and which may leverage various pools of data to expeditiously process and route a quanta of data (including conventional SMS, MMS, etc. messaging; VoIP and other audio/video data streams; SIP-addressed artifacts; signaling data; voice call data; application data; etc.). 1. Within an IP eXchange facility , a server-based method for directing a quanta of data , the server-based method comprising:receiving the quanta of data at a gateway, the quanta of data comprising an originating address, a destination address, and a content;performing a plurality of processing steps including at least:(a) creating an Internal Message Object (IMO) from at least aspects of the quanta of data,(b) characterizing aspects of the quanta of data including at least by a type, and(c) completing a routing operation, using at least a lookup facility and aspects of the destination address, yielding a delivery route; andselecting aspects of the IMO for dispatch via the delivery route.2. The server-based method of wherein the quanta of data is one of (a) a Short Message Service message claim 1 , (b) a Multimedia Message Service message claim 1 , (c) an IP Multimedia Subsystem message claim 1 , (d) an Extensible Markup Language document claim 1 , (e) audio data claim 1 , (f) video data claim 1 , (g) signaling data claim 1 , or (h) application data.3. The server-based method of wherein the plurality of processing steps further comprises one or more transcoding operations.4. Within an IP eXchange facility a processor-based system configured to direct a quanta of data claim 1 , the processor-based system comprising:a gateway configured to receive the quanta of data, the quanta of data comprising an originating address, a destination address, and a content; ...

Подробнее
Номер записи: 6
23-02-2012 дата публикации

System and Method for Real-Time Content Aggregation and Syndication

Номер: US20120047176A1
Автор: Timmons Michael
Принадлежит: Sybase, Inc.

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. 142-. (canceled)43. A method for generating a single document containing items of content retrieved from one or more Web pages , the method comprising:receiving a request for one or more items of content, the request comprising (a) one or more keywords and (b) one or more extended attributes;programmatically retrieving one or more Web pages based on at least the one or more keywords;parsing via software each of the one or more Web pages into one or more component objects, each component object (a) representing an item of content from the one or more Web pages and (b) yielding one or more feature extraction objects;selecting, based on different of (a) the one or more extended attributes and (b) the one or more feature extraction objects, particular component objects yielding selected component objects; andaggregating the selected component objects into a single document.44. The method of claim 43 , wherein the method is performed at a client device.45. The method of claim 44 , wherein the method is performed within a software application.46. The method of claim 45 , wherein the software application is a Web browser.47. The method of claim 43 , wherein the one or more extended attributes ...

Подробнее
Номер записи: 7
01-03-2012 дата публикации

System and Method for Subscription Management

Номер: US20120052890A1
Автор:
Принадлежит: SYBASE 365, INC.

A subscription manager module or message processing engine operating within a messaging inter-carrier vendor (MICV) provides value added services to both service users (e.g., mobile telephone users) and service providers (e.g., information brokers, vendors, news sources, etc.). The MICV is disposed between a plurality of service users and a plurality of service providers and messages sent between these parties are processed by a subscription manager module, or message processing engine, which is configured to, among other things, manage short codes, detect undesirable spam messages, operate service user opt-in and opt-out processes, and perform billing functions. 124-. (canceled)25. In a messaging intermediary , the messaging intermediary logically disposed between at least one wireless carrier and at least one service provider , a processor-based system on a server , the processor-based system comprising:a message highway that interconnects the at least one wireless carrier and the at least one service provider; anda plurality of message processors in communication with the message highway,wherein at least one of the message processors is a subscription manager that is configured to at least (a) manage short message service short codes on behalf of the at least one carrier and/or the at least one service provider and (b) operate on a message, the message being exchanged between the at least one wireless carrier and the at least one service provider, including at least identifying a keyword within a body of the message.26. In a messaging intermediary , the messaging intermediary logically disposed between at least one wireless carrier and at least one service provider , a server-based method , the server-based method comprising:receiving at a short message service message processing engine a message being exchanged between the at least one wireless carrier and the at least one service provider;operating on the message including at least (a) identifying a keyword ...

Подробнее
Номер записи: 8
08-03-2012 дата публикации

Adaptive Locking of Retained Resources in a Distributed Database Processing Environment

Номер: US20120059963A1
Автор: Jin Jihong, PASUPULETI Kantikiran Krishna, Sivananainthaperumal Anusha
Принадлежит: Sybase, Inc.

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. 1. In a distributed database processing environment comprising a plurality of nodes , a method for adaptive locking of retained resources , the method comprising:identifying a locking priority for at least a portion of a buffer pool;determining lock requests based upon the identified locking priority; andgranting locks for the lock requests.2. The method of wherein a client node sets the locking priority for physically locking at least one portion of the buffer pool.3. The method of wherein determining lock requests further includes determining conditional status of a lock request based upon the identified locking priority.4. The method of wherein the locking priority further comprises at least one of a mandatory part claim 1 , an optional part claim 1 , and a part of no interest of the buffer pool.5. The method of further comprising utilizing contention among the nodes to control buffer pool locking.6. The method of wherein granting locks further comprises requesting downgrading when needed from owner nodes.7. A distributed shared disk cluster database system comprising:disk storage having at least one database;memory providing a buffer pool for the at least one database; anda plurality of nodes networked in the cluster, the plurality of nodes adapting to contention for the at least one database by 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.8. The system of wherein a client node sets the locking priority for physically ...

Подробнее
Номер записи: 9
15-03-2012 дата публикации

INCREMENTAL DATA TRANSFER IN A DATABASE MANAGEMENT SYSTEM

Номер: US20120066263A1
Автор: Wildermuth Elton Philip
Принадлежит: Sybase, Inc.

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. 1. A method for incremental data transfer in a database management system (DBMS) , the method comprising:identifying a database table enabled for partial export from a database management system;identifying data within the database table to be exported; andtransferring the identified data in a chosen format from the database table to an export location.2. The method of wherein identifying a database table further comprises identifying a table name in a command requesting table transfer.3. The method of wherein the table name corresponds with a table name of a table created as an eligible table for table transfer.4. The method of further comprising identifying the chosen output format from the command.5. The method of wherein identifying data further comprises scanning for updated data.6. The method of wherein updated data further comprises rows that have been inserted or changed in the database table relative to a previous transfer.7. The method of further comprising annotating rows in the database table to allow tracking of updated data status.8. The method of wherein scanning further comprises scanning a data dictionary marking locations of updated data in the database table.9. The method of further comprising retaining a history of transfer of the database table.10. The method of wherein identifying data further comprises determining whether a level of transactional consistency is met for the data to manage when the data is transferred.11. The method of further comprising controlling modification of table ...

Подробнее
Номер записи: 10
29-03-2012 дата публикации

Accelerating Database Queries Containing Bitmap-Based Conditions

Номер: US20120078880A1
Автор: Kirk Steven A., Walrath David E.
Принадлежит: Sybase, Inc.

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. 1. A computer implemented method for query optimization , comprising:determining a bitmap, wherein said 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; andrestricting evaluation of a disjunct within said disjunction to said set of rows represented by said bitmap.2. The method of claim 1 , further comprising:determining cost savings based on said restricting; andcomparing said cost savings against a cost of additional bitmap operations before performing said restricting.3. The method of claim 1 , further comprising:analyzing each condition within said disjunction to determine whether cost savings for a condition justify said restricting for said condition.4. The method of claim 1 , further comprising:identifying disjunctive conditions that have used said restricting;determining a bitmap result of said disjunction; andwhen not all identified disjunctive conditions used said restricting, producing the ...

Подробнее
Номер записи: 11
05-04-2012 дата публикации

Query Plan Optimization for Prepared SQL Statements

Номер: US20120084315A1
Автор: SCHNEIDER Peter J., ZHANG Hui
Принадлежит: Sybase, Inc.

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. 1. A method for optimizing a query plan reuse in a database server system , comprising:providing at least one global cache storage and a private cache storage to a plurality of client connections; andcoordinating utilization of the at least one global cache storage and the private cache storage to share light weight stored procedures (LWPs) 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.2. The method of claim 1 , wherein coordinating utilization further comprises:initiating a Dynamic SQL Prepare process, wherein the Dynamic SQL Prepare process generates a first LWP entry that is accessible by the plurality of client connections; andinitiating a Dynamic SQL Execute process, wherein the Dynamic SQL Execute process uses the first LWP entry to determine if a query plan was generated by at least one client connection in the plurality of client connections.3. The method of claim 2 , wherein the Dynamic SQL Prepare process further comprises:receiving a prepared SQL statement;searching a first global cache storage for the first LWP entry associated with the prepared SQL statement;generating a second LWP entry in a local cache storage if the first LWP entry is found; andgenerating a new LWP entry, ...

Подробнее
Номер записи: 12
17-05-2012 дата публикации

RANKING DATABASE QUERY RESULTS USING AN EFFICIENT METHOD FOR N-ARY SUMMATION

Номер: US20120124040A1
Автор: Mungikar Shailesh Kamalakar
Принадлежит: Sybase, Inc.

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. 1. A computer-implemented method for ranking query results using mid-fold N-ary summation , comprising:receiving a first search phrase having a first plurality of search terms from a client device;executing a database query at a database based on the search phrase, wherein the database returns search results in response to the executing, and wherein each search result in the returned search results may contain one or more terms of the first plurality of search terms;computing a first relevance value for each search result in the returned search results using mid-fold N-ary summation based on a first value N, wherein the first value N is equivalent to a number of terms from the first plurality of search terms in each search result, and wherein the mid-fold N-ary summation is computed using a fixed number of operations regardless of a size of the first value N;ranking the returned search results from the database based on the computed first relevance value of each search result, wherein the ranking yields an exponential relationship between the number of search terms in each search result and the computed first relevance values of the returned search results; andtransmitting the ranked search results to the client device,wherein the receiving, the executing, the computing, the ranking, and the transmitting are performed using one or more computing devices.2. The method of claim 1 , wherein the computing further comprises:determining whether the first value N is an even number or an odd number;computing the first relevance value using ...

Подробнее
Номер записи: 13
17-05-2012 дата публикации

Parallel Partitioning Index Scan

Номер: US20120124045A1
Автор:
Принадлежит: Sybase, Inc.

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. 1. A method for joining 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 the index scan;determining a number of partitions in the second database table; andjoining each of the corresponding partitions in the first database table with a corresponding partitions in the second database table.2. The method of claim 1 , further comprising:performing the index scan using a number of threads that correspond to the number of partitions in the second database table.3. The method of claim 1 , wherein the global index is a useful index.4. The method of claim 1 , wherein the global index includes a superset of a joining attributes.5. The method of claim 2 , wherein the second database table is partitioned using range partitioning.6. The method of claim 5 , wherein at least one thread determines a lower bound and an upper bound of at least one partition in the second database table and applies the lower bound and the upper bound to the index scan on the first database table.7. The method of claim 2 , wherein the second database table is partitioned using hash partitioning.8. The method of claim 7 , wherein a hash function is applied to the global index in the first database table and a result of the hash ...

Подробнее
Номер записи: 14
14-06-2012 дата публикации

REPLICATION RESYNCHRONIZATION

Номер: US20120150803A1
Автор: Shepherd Stephen C., Zhu Jianbing
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof for replication resynchronization are provided. An embodiment includes providing a mode of operation in a replication control system for repopulating a replicated version of a primary database that does not affect an ability to continue activity in the primary database. Further included is managing the repopulating of the replicated version with attention to at least a resynchronization marker. 1. A method for database replication resynchronization comprising:providing a mode of operation in a replication control system for repopulating a replicated version of a primary database that does not affect an ability to continue activity in the primary database; andmanaging the repopulating of the replicated version with attention to at least a resynchronization marker.2. The method of claim 1 , wherein providing a mode of operation further comprises providing a mode of operation in the replication control system that supports skipping transactions and purging replication data from replication queues.3. The method of claim 1 , wherein managing the repopulating further comprises obtaining a dump from a trusted data source claim 1 , and determining transactions to apply to the replicated version.4. The method of claim 3 , wherein determining transactions to apply further comprises identifying committed and uncommitted transactions relative to the resynchronization marker and a dump end time.5. The method of claim 4 , wherein the trusted data source further comprises the primary database.6. The method of claim 3 , further comprising reestablishing replication following application of the data dump.7. An apparatus for data replication resynchronization comprising:a primary database; anda replication control system for providing a mode of operation to repopulate a replicated version of the primary database that does not affect an ability to continue activity in the primary ...

Подробнее
Номер записи: 15
21-06-2012 дата публикации

DISTRIBUTED DATA CACHE DATABASE ARCHITECTURE

Номер: US20120158650A1
Автор:
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof for a distributed data cache database architecture are provided. An embodiment includes providing a scalable distribution of in-memory database (IMDB) system nodes organized as one or more data fabrics. Further included is providing a plurality of data granularity types for storing data within the one or more data fabrics. Database executions are managed via the one or more data fabrics for a plurality of applications compatible with at least one data granularity type. 1. A method comprising:providing a scalable distribution of in-memory database (IMDB) system nodes organized as one or more data fabrics;providing a plurality of data granularity types for storing data within the one or more data fabrics; andmanaging database executions via the one or more data fabrics for a plurality of applications compatible with at least one data granularity type.2. The method of wherein managing database executions further comprises managing database transactions with ACID (Atomic Consistent Independent and Durable) consistency.3. The method of wherein managing database executions further comprises managing mapped execution of a stored procedure with eventual consistency.4. The method of further comprising managing read-write and read-only copies of the data based upon a number of fabrics storing the data and based upon the data granularity type.5. The method of further comprising asynchronously replicating committed changes on a read-write copy to read-only copies within a data fabric.6. The method of further comprising synchronously copying on at least a second node data changes of committed transactions of a first node.7. The method of further comprising supporting differing levels of application system scale-out in accordance with application compatibility with the plurality of data granularity types.8. The method of wherein the plurality of data granularity types further ...

Подробнее
Номер записи: 16
21-06-2012 дата публикации

Data Grid Advisor

Номер: US20120158723A1
Автор: Andre Mihnea, Du Haiyan, MacLeod Ian Scott, Wu Juan
Принадлежит: Sybase, Inc.

A system and method to generate an improved layout of a data grid in a database environment is provided. The data grid is a clustered in-memory database cache comprising one or more data fabrics, where each data fabric includes multiple in-memory database cache nodes. A data grid advisor capability can be used by application developers and database administrators to evaluate and design the data grid layout so as to optimize performance based on resource constraints and the needs of particular database applications. 1. A computer-implemented method to produce an improved layout of a data grid in a database environment comprising:capturing, by a computing device, a workload from a first database server and at least one client of the first database server, the workload comprising a set of queries and responses between the first database server and the at least one client;producing dependency and volume information for the captured workload based on the set of queries and responses in the captured workload;generating a layout of one or more data fabrics within the data grid in the database environment based on resource constraints associated with the data grid and the produced dependency and volume information associated with the captured workload, wherein each fabric in the one or more data fabrics comprises a plurality of cache nodes, and wherein each cache node in the plurality of cache nodes is an in-memory database server; andstoring the generated layout at the computing device.2. The method of claim 1 , further comprising:identifying a subset of queries from the set of queries in the captured workload based on the resource constraints associated with the data grid and the produced dependency and volume information associated with the captured workload, wherein one or more query-processing latency reduction techniques may be used for the subset of queries at runtime; andgenerating a workset for the data grid in the database environment, the workset comprising the ...

Подробнее
Номер записи: 17
21-06-2012 дата публикации

Client-Side Statement Cache

Номер: US20120158770A1
Автор:
Принадлежит: Sybase, Inc.

Embodiments include a method, apparatus and computer program product for providing instructions from a database client to a database server. The method includes the steps of receiving from a database a representation of a first instruction and an associated identifier. The representation of the first instruction and the associated identifier are stored in a cache. A second instruction, from an application, is matched with the representation of the first instruction stored in the cache. The associated identifier is retrieved from the cache based on the matching and the associated identifier is sent to the database server. Upon receipt of the associated identifier, the database server executes the first instruction. 1. A method of providing instructions from a database client to a database server , comprising:receiving, from a database server, a representation of a first instruction and an associated identifier;storing the representation of the first instruction and the associated identifier in a cache;receiving a second instruction from an application;matching the representation of the first instruction and the second instruction;retrieving the associated identifier from the cache based on the matching; andsending the associated identifier to the database server, wherein, upon receiving the associated identifier the database server executes the first instruction.2. The method of claim 1 , wherein the first instruction is dynamic structured query language (Dynamic SQL) and the second instruction is embedded SQL.3. The method of claim 1 ,wherein the second instruction has a parameter, andwherein the sending the associated identifier to the database server comprises sending the associated identifier and the parameter to the database server,wherein, upon receiving the identifier and the parameter, the database server executes the first instruction using the parameter.4. The method of claim 1 , wherein the cache is a client-side statement cache.5. The method of claim 1 , ...

Подробнее
Номер записи: 18
21-06-2012 дата публикации

ENTITY TRIGGERS FOR MATERIALIZED VIEW MAINTENANCE

Номер: US20120158795A1
Автор: IRELAND Evan
Принадлежит: Sybase, Inc.

A system, method, and computer program product are provided for implementing materialized views on a mobile device in synchronization with an enterprise information system. Changes to an underlying local database, on which the materialized view is based, may originate from the enterprise system or from the client. A solution needs to account for each of these potential sources of changes, and update the materialized view accordingly. 1. A method comprising:defining a mobile business object for a materialized view;defining triggers, within the mobile business object, for changes to a local database affecting the materialized view; andexecuting a code generator on the mobile business object definition.2. The method of claim 1 , wherein the changes to the local database comprise at least one of a create claim 1 , update claim 1 , or delete call.3. The method of claim 1 , wherein the changes to the local database comprise a bulk initial download.4. The method of claim 1 , further comprising:writing platform-specific code for the triggers to maintain the materialized view.5. The method of claim 1 , wherein the changes to the local database comprise a download claim 1 , and wherein defining triggers comprises defining a trigger activated upon saving the download to the local database.6. The method of claim 1 , wherein defining triggers comprises defining a trigger for a delete call configured to not fail if a source MBO for the delete call is not present.7. A computer-readable storage device having computer program logic recorded thereon claim 1 , execution of which claim 1 , by a computing device claim 1 , causes the computing device to perform operations comprising:defining a mobile business object for a materialized view;defining triggers, within the mobile business object, for changes to a local database affecting the materialized view; andexecuting a code generator on the mobile business object definition.8. The computer-readable storage device of claim 7 , wherein ...

Подробнее
Номер записи: 19
21-06-2012 дата публикации

NON-DISRUPTIVE DATA MOVEMENT AND NODE REBALANCING IN EXTREME OLTP ENVIRONMENTS

Номер: US20120158805A1
Автор:
Принадлежит: Sybase, Inc.

Systems and methods for non-disruptive cache startup, shutdown, data partition movement, and node rebalancing for a data fabric within a data grid in a database environment. The data grid is a clustered in-memory database (IMDB) cache comprising one or more data fabrics including multiple IMDB cache nodes. The method takes a time tag and moves data from source to destination nodes while allowing updates to data on the source nodes. The method propagates updates occurring after the time tag to destination nodes from source nodes and switches applications and ownership to the destination nodes. Another method slices data for a partitioned fabric and stores slices on nodes. Another method starts a data fabric by moving data from a grid backend to the nodes. In an embodiment, another method rebalances nodes in a non-disruptive manner. When a fabric is shutdown, the method saves data from the nodes to the grid backend. 1. A method for non-disruptive movement of data partitions in a data grid within a database environment , the method comprising:creating a time tag indicating the state of data at a point in time within a plurality of in-memory database (IMDB) system nodes organized as a data fabric of the data grid;moving data pages from a plurality of source nodes to a plurality of destination nodes, wherein changes by applications to data pages on the plurality of source nodes are allowed during the moving;propagating data changes from the plurality of source nodes to the plurality of destination nodes;freezing data page changes on the plurality of source nodes;instructing applications to perform future data page changes on the plurality of destination nodes; andswitching data page ownership to the plurality of destination nodes.2. The method of claim 1 , wherein the freezing further comprises:allowing current application transactions against the plurality of source nodes to complete;committing the allowed transactions on the plurality of source nodes;blocking new ...

Подробнее
Номер записи: 20
21-06-2012 дата публикации

BULK INITIAL DOWNLOAD OF MOBILE DATABASES

Номер: US20120158828A1
Автор: Donahue Brett, HE Xiong, IRELAND Evan, Zhang Guo-ping
Принадлежит: Sybase, Inc.

A system, method, and computer program product are provided for handling bulk initial downloads of databases to mobile devices. Rather than straining the resources of a mobile device to recreate the database locally, a server can construct the database to the mobile device's requirements at the server by impersonating the mobile device. The server can then send the database, compressed and over an encrypted session, to the mobile device. The mobile device can then decrypt and uncompress the pages received, and then encrypt them using a local key for secure storage on a local storage device. 1. A method comprising:receiving a subscription request from a client;impersonating the client to generate a temporary database file based on the subscription request; andtransmitting the temporary database file to the client.2. The method of claim 1 , wherein impersonating the client to generate a temporary database file based on the subscription request comprises:generating contents of the temporary database file based on contents of the subscription request.3. The method of claim 1 , wherein impersonating the client to generate a temporary database file based on the subscription request comprises:generating contents of the temporary database file specific to the client.4. The method of claim 1 , wherein impersonating the client to generate a temporary database file based on the subscription request comprises:selecting a bulk download program compatible with the client; andgenerating the temporary database file using the bulk download program.5. The method of claim 1 , wherein impersonating the client to generate a temporary database file based on the subscription request comprises:determining that a bulk download program compatible with the client does not exist;invoking a code generator to generate a compatible bulk download program emulating code for use on the client; andgenerating the temporary database file using the compatible bulk download program.6. A computer-readable ...

Подробнее
Номер записи: 21
21-06-2012 дата публикации

Efficiently Handling Large Data Sets on Mobile Devices

Номер: US20120159393A1
Автор: Sethi Raman
Принадлежит: Sybase, Inc.

A system, method, and computer program product are provided for efficiently fetching and displaying large datasets on mobile devices, such as devices running the iPhone™ operating system. The method fetches data for a mobile device from a server and displays a plurality of data rows in a ListView within a user interface on the mobile device. The method stores primary keys on the mobile device until their corresponding data rows are to be displayed. The method reacts to user inputs such as scrolling actions and touch screen gestures to efficiently fetch and display list view subsets of large datasets. The method facilitates quick response times when navigating through large lists of data on a mobile device by: fetching displayable or visible rows of data in a data list view, preloading the visible rows on the mobile device; and binding the visible rows to user interface elements on the mobile device. 1. A computer-implemented method for displaying a list view of a dataset on a mobile device , comprising:initializing a ListView for the mobile device;receiving data in response to a query, wherein the received data comprises a plurality of data rows from the dataset;binding the received data to a plurality of user interface (UI) elements for a UI of the mobile device;defining a logical data window;in response to detecting a direction and velocity of a scrolling input within the UI of the mobile device, adding pages to the logical data window;receiving a selection of an active view via the UI; anddisplaying a portion of the plurality of data rows corresponding to the active view using the UI of the mobile device.2. The method of claim 1 , further comprising dividing the ListView into virtual groups.3. The method of claim 2 , wherein virtual groups comprise records for scroll behind data pages and scroll ahead data pages.4. The method of claim 1 , wherein the mobile device runs an iPhone™ operating system.5. The method of claim 1 , wherein the ListView is a logical data ...

Подробнее
Номер записи: 22
05-07-2012 дата публикации

Accelerating Database Queries Comprising Positional Text Conditions Plus Bitmap-Based Conditions

Номер: US20120173540A1
Автор: Eflov Evguenia A., Goel Anil K., Kirk Steven A., McKenney Roland F.
Принадлежит: Sybase, Inc.

A system, method, and computer program product are provided for improving performance of positional text conditions in concert with bitmap-based conditions. This is accomplished, for example, by focusing positional text condition evaluation to candidate rows based on a bitmap resulting from application of a prior condition. Additionally, the result of a positional text condition may itself be provided in the form of a bitmap to accelerate further bitmap-based condition processing. 1. A method comprising:retrieving a search term bitmap representing rows in a database comprising a search term;identifying candidate rows based on the search team bitmap;evaluating position information for the search term for the candidate rows; andproviding a set of result rows satisfying a positional text condition based on the position information for the search term.2. The method of claim 1 , wherein providing the set of result rows comprises:providing a result bitmap representing the set of result rows.3. The method of claim 2 , further comprising:evaluating a subsequent condition restricted by the bitmap representing the set of result rows.4. The method of claim 1 , wherein identifying the candidate rows comprises:identifying the candidate rows based on intersection of the search term bitmap with a prior condition bitmap.5. The method of claim 1 , further comprising:retrieving an additional search term bitmap representing rows in a database comprising an additional search term, wherein identifying the candidate rows comprises identifying the candidate rows based on intersection of the search term bitmap and the additional search term bitmap.6. The method of claim 5 , further comprising:evaluating position information for the additional search term for the candidate rows.7. The method of claim 5 , further comprising:evaluating position information for the additional search term narrowed by position information for the search term, wherein the position information for the additional ...

Подробнее
Номер записи: 23
04-10-2012 дата публикации

System and Method for Dynamic Throttling During Bulk Message Delivery

Номер: US20120254331A1
Автор: Chuan Tan Chuan, Wah Clarence Ng Ching
Принадлежит: SYBASE 365, INC.

An flexible, extensible, and dynamically configurable intelligent throttling capability that among other things can support the bulk processing of a wide range of information (including inter alia Short Message Service, Multimedia Message Service, IP Multimedia Subsystem, etc. messages; E-Mail messages; Instant Messaging communications; Session Initiation Protocol-addressed artifacts; signaling, command-and-control, application, etc. data; etc.) that may result following for example service interruptions, system outages, bursts of traffic (for example in response to a tele-voting initiative, from a mass broadcast of alert or information messages in response to a news item or an emergency situation, etc.), equipment failures, etc. 1. A server-based method for dynamic message throttling , the server-based method comprising:identifying a message pool to be processed, the message pool comprising a plurality of messages;partitioning the message pool into a plurality of subdivisions; andperforming a plurality of processing steps while a delivery window is open, including at least:(a) opening a subdivision for processing, yielding an open subdivision,(b) selecting a message from the open subdivision, yielding a selected message,(c) performing one or more processing steps on the selected message,(d) dispatching through a gateway aspects of the selected message for subsequent delivery to a message recipient, and(e) pausing zero or more units of time.2. The server-based method of wherein the message is one of (a) a Short Message Service message claim 1 , (b) a Multimedia Message Service message claim 1 , (c) an Internet Protocol Multimedia Subsystem message claim 1 , or (d) an Unstructured Supplementary Service Data-based message.3. The server-based method of wherein the partitioning step employs one of (a) a uniform means claim 1 , (b) a random means claim 1 , or (c) an algorithmic means.4. The server-based method of wherein the delivery window is open based on one or more ...

Подробнее
Номер записи: 24
11-10-2012 дата публикации

SYSTEM AND METHOD FOR ENHANCED QUERY OPTIMIZER SEARCH SPACE ORDERING

Номер: US20120259840A1
Автор: NICA Anisoara
Принадлежит: Sybase, Inc.

In an optimizer within a Relational Database Management System improved ways in which a search space (the universe of possible join combinations) is generated and managed and improved ways in which the elements of a search space are evaluated so that among other things unpromising elements are efficiently dropped (pruned).

Подробнее
Номер записи: 25
01-11-2012 дата публикации

System and Method for Enhanced UAProfile Management

Номер: US20120276869A1
Автор: Jr. Robert C., Lovell
Принадлежит: SYBASE 365, INC.

Given the growing number of Wireless Devices, and the increasingly varied characteristics (including for example screen size, color depth support, audio and video support, etc.) that Wireless Device vendors or manufacturers provide within their Wireless Devices, an infrastructure that various entities (such as for example Content Providers, Service Providers, etc.) may use to quickly retrieve a quality-controlled User Agent Profile based just on a Wireless Device's Telephone Number. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor. 1. Within a messaging ecosystem entity a server-based method for accessing a descriptor of a wireless device , the server-based method comprising:receiving at a gateway a descriptor request message from a requestor, the descriptor request message including at least an address of the wireless device;performing one or more processing steps on the descriptor request message including at least querying, based on the address, a local descriptor repository yielding a retrieved descriptor, the retrieved descriptor comprising characteristics of the wireless device;generating a descriptor response message, the descriptor response message including at least aspects of the retrieved descriptor; andreturning by the gateway the descriptor response message to the requestor.2. The server-based method of claim 1 , wherein the descriptor request message and/or the descriptor response message are an Extensible Markup Language document.3. The server-based method of claim 1 , wherein the descriptor request message is received through and the descriptor response message is returned through one of (a) the World Wide Web claim 1 , (b) a wireless message claim 1 , (c) electronic mail claim 1 , (d) a data feed claim 1 , or (e) an Application Programming Interface.4. The server-based method of claim 3 , wherein the wireless message is one of (a) a Short Message Service message or (b) a Multimedia ...

Подробнее
Номер записи: 26
15-11-2012 дата публикации

Certificate Blobs for Single Sign On

Номер: US20120290833A1
Автор: Clegg David Lyndon, IRELAND Evan, Schmidt Bradley Edward
Принадлежит: Sybase, Inc.

A system, method and a computer-readable medium for generating an authentication password for authenticating a client to a server. A digital certificate that includes private key, and a public key is provided. A hash of a content of a digital certificate is generated. The hash is also encrypted with a private key. The encrypted hash and the content of the digital certificate are encoded into a certificate blob, which is utilized as an authorization password. 1. A computer-implemented method for generating an authentication password for authenticating a client to a server , comprising:accessing a digital certificate that includes a private key, and a public key;generating a hash of a content of the digital certificate;encrypting the hash with the private key;encoding the encrypted hash and the content of the digital certificate into a certificate blob; andutilizing the certificate blob as the authorization password.2. The method of claim 1 , wherein encoding includes a binary encoding of the encrypted hash and the content of the certificate.3. The method of claim 2 , wherein the binary encoding includes utilizing an ASN.1 encoding.4. The method of claim 2 , wherein the binary encoding includes utilizing a binary-to-string encoding.5. The method of claim 4 , wherein the binary-to-string encoding includes utilizing a base64 encoding.6. The method of claim 1 , further comprising:sending the certificate blob to the server for authentication, prior to accessing data.7. The method of claim 1 , wherein the certificate blob authenticates a mobile device.8. A system for generating an authentication password for authenticating a client to a server claim 1 , comprising: receive a digital certificate with a public key, and a public key; and', 'generate a hash of a content of the digital certificate;, 'a hash generator configured toan encryption module configured to encrypt the hash with the private key;an encoder configured to encode the encrypted hash and the content of the ...

Подробнее
Номер записи: 27
15-11-2012 дата публикации

Hybrid Web Container for Cross-Platform Mobile Applications

Номер: US20120290914A1
Автор: Alberti Johannes, Brandow David John, LEE Andrew Wai
Принадлежит: Sybase, Inc.

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. 1. A method for generating a cross-platform mobile application , comprising:providing a plurality of web files;generating the cross-platform mobile application using the web files, wherein the cross-platform mobile application receives data from a data source and manipulates data on a plurality of mobile devices;packaging the web files for distribution; anddistributing the web files to the plurality of mobile devices.2. The method of claim 1 , wherein at least one web file is an HTML file claim 1 , a JavaScript file and a CSS file.3. The method of claim 1 , further comprising:creating one or more display screens for the cross-platform mobile application using at least one web file.4. The method of claim 2 , wherein the at least one web file is an HTML file and each screen is displayed using a form within the HTML file.5. The method of claim 1 , further comprising:customizing the cross-platform mobile application with business logic using at least one web file.6. The method of claim 4 , wherein the at least one web file is a JavaScript file.7. The method of claim 1 , further comprising:using one or more web files to access a feature native to a mobile device.8. The method of claim 1 , wherein the cross-platform mobile application ...

Подробнее
Номер записи: 28
15-11-2012 дата публикации

ELASTIC RESOURCE PROVISIONING IN AN ASYMMETRIC CLUSTER ENVIRONMENT

Номер: US20120291088A1
Автор: Goel Anil Kumar, SRIVASTAVA Ajay Kumar
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof for elastic resource provisioning are provided. An embodiment includes grouping physical resources in an asymmetric distributed cluster of data processing nodes logically into one or more provisions. Further included are configuring access to the physical resources with the one or more provisions, and managing adjustment of operations among the data processing nodes in correspondence with adjustment to the physical resources through the one or more provisions and transparently to an application utilizing the physical resources. 1. A method for elastic resource provisioning , the method comprising:grouping physical resources in an asymmetric distributed cluster of data processing nodes logically into one or more provisions;configuring access to the physical resources with the one or more provisions; andmanaging adjustment of operations among the data processing nodes in correspondence with adjustment to the physical resources through the one or more provisions and transparently to an application utilizing the physical resources.2. The method of further comprising controlling whether a connection attempt to a data processing node is allowed based upon a login policy.3. The method of wherein an allowed connection comprises a data processing node of a provision associated with the login policy.4. The method of further comprising determining a logical server context automatically based upon the login policy and an included logical server access configuration.5. The method of farther comprising examining the login policy to identify a list of assigned logical servers claim 4 , and determining whether the data processing node is an effective member of any one from the list to control acceptance of the connection.6. The method of wherein the connection attempt specifies the provision to be connected to and is redirected to a node in the specified provision if needed.7. The ...

Подробнее
Номер записи: 29
06-12-2012 дата публикации

Auto-Correction in Database Replication

Номер: US20120310885A1
Автор: Shepherd Stephen C., XU Chengzi
Принадлежит: Sybase Inc.

Systems, methods and computer program product embodiments for auto-correction in database replication are disclosed herein. An embodiment includes receiving a log record of one or more database row changes on a table marked for replication. From the received log record, one or more insert operations on the marked table are identified. Each identified insert operation is automatically replaced with a first pair of operations, where each first pair comprises a delete operation associated with a new insert operation. Each first pair, when executed at a replicate database, acts to delete data at a first location identified by each identified insert operation prior to inserting data of the new insert operation at the first location. The embodiment further includes identifying, from the log record, one or more update operations on the marked table, and automatically replacing each identified update operation with a second pair of operations, where each second pair comprises a new delete operation associated with a new insert operation. 1. A method for auto-correction in database replication , comprising:identifying, from a log record, one or more predetermined operations on a database table marked for replication;automatically replacing each identified predetermined operation with a first pair of operations; andgenerating an auto-corrected replicated table corresponding to said marked database table based upon said first pair of operations,wherein said predetermined operations comprise one or more insert operations andwherein each first pair further comprises a delete operation associated with a new insert operation, each first pair acting to delete data at a first location identified by said each identified insert operation prior to inserting data of said new insert operation at said first location.2. The method of claim 1 , further comprising:providing auto-corrected operations, including first pairs of operations each associated with respective identified insert ...

Подробнее
Номер записи: 30
13-12-2012 дата публикации

Replication Support for Procedures with Arguments of Unsupported Types

Номер: US20120317073A1
Автор: Shepherd Stephen, Zhou Ping
Принадлежит: Sybase, Inc.

A method, system and computer readable storage medium for replicating procedures with unsupported table data type arguments such as Boolean arguments. The method includes identifying the argument of an unsupported table data type in a procedure to be replicated, mapping the argument to an equivalent supported value, and creating a table containing a column representing the argument as the supported table data type and sending data corresponding to the unsupported table data type argument to a replication server. 1. A method of replicating a procedure from a primary database to a replicate database , comprising:identifying an argument of a supported argument data type that is also an unsupported table column type in a procedure to be replicated;mapping said argument to an equivalent value of a supported table column type; andrepresenting said mapped argument with said supported table column type.2. The method of claim 1 , wherein said procedure has a plurality of arguments of an unsupported table column type and wherein each of the plurality of arguments is mapped to an equivalent value of a supported table column type at said mapping step.3. The method of claim 1 , further including sending data representing said mapped argument to a replication server claim 1 , wherein said sent data is of a supported table column type.4. The method of claim 1 , wherein the supported data type that is also an unsupported table column type is Boolean.5. The method of claim 1 , wherein the representing said mapped argument further comprises creating a table containing a column with a data type of said supported table column type.6. A system for replicating a procedure from a primary database to a replicate database claim 1 , comprising:a primary database reader configured to identify an argument of a supported data type that is also an unsupported table column type in a procedure to be replicated;an argument mapper configured to map said argument to an equivalent value of a supported ...

Подробнее
Номер записи: 31
13-12-2012 дата публикации

DDL Command Filtering

Номер: US20120317076A1
Автор: Jianbing Zhu, Stephen Shepherd
Принадлежит: Sybase Inc

System, method and articles of manufacture for filtering a data definition language (DDL) command. The method includes providing a filtering function with one or more rules for filtering the DDL command. The method further includes receiving the DDL command for replication. The method also includes filtering the DDL command from replication based on the one or more rules.

Подробнее
Номер записи: 32
13-12-2012 дата публикации

Replication Support for Structured Data

Номер: US20120317078A1
Автор:
Принадлежит: Sybase, Inc.

A method, system and computer readable storage medium for replicating structured data stored in a database. The method includes identifying the stored structured data, mapping the data to an unstructured data type, and sending the mapped data to one or more replicate databases as unstructured data. 1. A method of replicating data of a structured data type and stored in a primary database to a replicate database , comprising:(a) identifying data stored on said primary database that is to be replicated to said replicate database, wherein said identified data is of said structured data type;(b) mapping said identified data to an unstructured data type; and(c) sending said mapped data to said replicate database as said unstructured data type.2. The method of claim 1 , wherein said mapping includes mapping said identified data to a hidden column.3. The method of claim 1 , wherein said structured data type comprises an extensible markup language (XML) data type.4. The method of claim 1 , wherein said unstructured data type comprises one of text claim 1 , large object (LOB) claim 1 , and character large object (CLOB) data type.5. The method of claim 1 , wherein said sending includes generating a log transfer language (LTL) message and sending said LTL message to said replicate database.6. The method of claim 1 , wherein said mapping includes generating a replication definition.7. The method of claim 1 , further comprising causing the replicate database to update a database table based of said replicated data.8. The method of claim 7 , further comprising marking the database table to indicate that it contains structured data.9. A replication system for replicating a data of a structured data type stored in a primary database to a replicate database claim 7 , comprising:(a) a database reader configured to identify data to be replicated from the primary database, said data being stored as a structured data type, wherein said identified data is of said structured data type;(b) ...

Подробнее
Номер записи: 33
20-12-2012 дата публикации

OPTIMIZING DATA STORAGE AND ACCESS OF AN IN-MEMORY DATABASE

Номер: US20120323971A1
Автор: PASUPULETI Kantikiran Krishna
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof are provided for optimizing data storage and access of an in-memory database in a database management system. Embodiments include utilizing in-memory storage for hosting an entire database, and storing objects of the database individually in separate portions of the in-memory storage, wherein a portion size is based upon an object element size. 1. A computer-implemented method for optimizing data storage and access of an in-memory database in a database management system , the method comprising:utilizing in-memory storage for hosting an entire database; andstoring objects of the database individually in separate portions of the in-memory storage, wherein a portion size is based upon an object element size.2. The computer-implemented method of wherein the portion size comprises a multiple of a row size.3. The computer-implemented method of further comprising utilizing a row header to synchronize physical access to the rows and allow access concurrency.4. The computer-implemented method of further comprising utilizing separate portions for fixed and variable parts of an object element.5. The computer-implemented method of wherein a portion further comprises a contiguous section of the in-memory storage.6. The computer-implemented method of further comprising specifying the portion size when creating the object element.7. A system for optimizing data storage and access in a distributed database system claim 1 , the system comprising:a database server including a memory for temporarily storing data objects; anda database server engine forming a database hosted entirely in the memory, and storing data objects of the database individually in separate portions with a portion size based upon an object element size.8. The system of wherein the portion size comprises a multiple of a row size.9. The system of wherein the database server engine further utilizes a row header to ...

Подробнее
Номер записи: 34
27-12-2012 дата публикации

Information Messaging and Collaboration System

Номер: US20120331044A1
Автор: Timmons Michael
Принадлежит: Sybase, Inc.

An information messaging and collaboration system is described. In one embodiment, for example, a method is described for interactive content retrieval and display, the method comprises steps of: providing a plurality of portlets for retrieval of content for display in a user interface; mapping a message action to a first portlet to create a messaging portlet for sending a message in response to user interaction with the messaging portlet; creating a listener portlet by registering a second portlet to receive messages from the messaging portlet; and in response to user interaction with the messaging portlet, retrieving particular content for display in the user interface based on the message received by the listener portlet from the messaging portlet. 1. A method for interactive content retrieval and display , the method comprising:providing a plurality of portlets for retrieval of content for display in a user interface;mapping a message action to a first portlet to create a messaging portlet for sending a message in response to user interaction with the messaging portlet;creating a listener portlet by registering a second portlet to receive messages from the messaging portlet; andin response to user interaction with the messaging portlet, retrieving particular content for display in the user interface based on the message received by the listener portlet from the messaging portlet.259-. (canceled) The present application is related to and claims the benefit of priority of the following commonly-owned, presently-pending provisional application(s): application Ser. No. 60/481,287 (Docket No. SYB/0094.00), filed Aug. 25, 2003, entitled “Information Messaging and Collaboration System”, of which the present application is a non-provisional application thereof. The present application is related to the following commonly-owned, presently-pending application(s): application Ser. No. 09/780,993 (Docket No. SYB/0090.03), filed Feb. 8, 2001, entitled “System and Method for ...

Подробнее
Номер записи: 35
28-02-2013 дата публикации

MULTICAST DATABASE REPLICATION

Номер: US20130054526A1
Автор: DI VINCENZO James John
Принадлежит: Sybase, Inc.

Systems, methods and computer program products for multicast database replication are described herein. An embodiment includes creating a replication group for replication of data. One or more replicate (or target) databases are subscribed to the replication group and the replication group may include one or more subscribed replicate databases. The replication group is associated with a replication group address. Embodiments send (or publish) data that is to be replicated to the replication group multicast address causing automatic replication of the data to the subscribed replicate databases. In this way, by sending data to be replicated once to a replication group address, the data is automatically replicated to several subscribed replicate databases and a replication server need not establish distinct point-to-point connections with each replicate database. 1. A computer-implemented method for database replication , comprising:creating a replication group for replication of data, said replication group associated with a replication group address;subscribing one or more databases to said replication group; andtransmitting said data to said replication group address to cause replication of said data to said databases subscribed to said replication group,wherein said creating, said subscribing and said sending are performed using one or more processors.2. The method of claim 1 , wherein performance of said replication is independent of a change in a number of said databases.3. The method of claim 1 , the transmitting comprising:transmitting said data to said replication group address as data packets, each data packet comprising a replication data payload and header, said header comprising a packet sequence number.4. The method of claim 3 , further comprising:incrementing said sequence number for each data packet transmitted to said replication group address.5. The method of claim 1 , further comprising:maintaining a list of said databases subscribed to said ...

Подробнее
Номер записи: 36
28-02-2013 дата публикации

MODELING AND CODE GENERATION FOR SQL-BASED DATA TRANSFORMATIONS

Номер: US20130055197A1
Автор: BALAN AJAY N., Doucette Michael, Hughes Randall L.
Принадлежит: Sybase, Inc.

System, method and computer program product for modeling and code generation for SQL-based data transformations. A selection, by a user, of a component to include in a visual representation of a data transformation model (DTM) is received. Logic corresponding to the selected component is arranged in the DTM, wherein the selected component and the logic are compatible with a plurality of implementations of SQL. SQL code corresponding to the logic is generated, wherein the generated SQL code is specific to a selected one of the plurality of SQL implementations. Responsive to the selection, the generated SQL code is provided for rendering in association with the visual representation of the DTM including the selected component. 1. A system comprising:a model viewer configured to receive a selection, by a user, of a component to include in a visual representation of a data transformation model (DTM);a model builder configured to arrange logic corresponding to the selected component in the DTM, wherein the selected component and the logic are compatible with a plurality of implementations of SQL (structured query language);a code generator configured to generate SQL code corresponding to the logic, wherein the generated SQL code is specific to a selected one of the plurality of SQL implementations; andthe model viewer being further configured to provide the generated SQL code for rendering substantially simultaneously with the visual representation of the DTM including the selected component.2. The system of claim 1 , further comprising an execution engine configured toextract data from a source database,transform the data based on an SQL script comprising the generated SQL for one or more selected components in the visual representation of the DTM, andpublish the transformed data to a target database.3. The system of claim 2 , wherein the execution engine is further configured toload the extracted data onto one or more staging tables, andtransform the loaded data based ...

Подробнее
Номер записи: 37
21-03-2013 дата публикации

Text-to-Visual Switching and Mapping

Номер: US20130069952A1
Автор: Frantz Andrew
Принадлежит: Sybase, Inc.

System, methods and computer-readable mediums for generating a visual representation of a continuous computation language (CCL) document. The CCL document includes one or more CCL statements. For each CCL statement, a text-to-visual mapping module converts each CCL statements to visual objects as a representation of instruction logic of the CCL document graphically on a display device. 1. A computer-implemented method for generating a visual representation of a continuous computation language (CCL) document , comprising:accessing the CCL document, the CCL document including one or more CCL statements; andconverting the CCL statements to visual objects as a representation of instruction logic of the CCL document graphically on a display device.2. The computer-implemented method of claim 1 , wherein the converting further comprises:for each CCL statement, generating parent nodes based on CCL statement keywords;identifying one or more connection types between a plurality of parent nodes; anddrawing one or more connections between the plurality of parent nodes based on the one or more connection types, wherein the plurality of parent nodes and the one or more connections represent the instruction logic associated with the CCL document.3. The computer-implemented method of claim 2 , further comprising generating a child node for a parent node claim 2 , the child node representing an instruction in each CCL statement.4. The computer-implemented method of claim 2 , wherein the parent node represents a schema.5. The computer-implemented method of claim 2 , wherein the parent node represents a stream.6. The computer-implemented method of claim 2 , wherein the parent node represents a window.7. The computer-implemented method of claim 2 , wherein the parent node represents a store.8. The computer-implemented method of claim 2 , wherein the parent node represents a module claim 2 , the module including logic for manipulating data.9. The computer-implemented method of claim 8 , ...

Подробнее
Номер записи: 38
28-03-2013 дата публикации

EXTREME LARGE SPACE ALLOCATION

Номер: US20130080481A1
Автор: Chakravarty Shampa, Wang Yanhong, Wildermuth Elton Philip, ZHOU Panfeng
Принадлежит: Sybase, Inc.

Methods, systems, and computer program products are provided to efficiently allocate extremely large storage spaces for use by dynamic hash tables. A contiguous storage space is designated from which dynamic hash tables can be created. These dynamic hash tables benefit from rapid allocation by being able to reserve many allocation units (each potentially comprising a large number of pages, e.g., 256 pages) within a short span of time, rather than resorting to reserving individual pages. The efficiency from allocation and the contiguous space significantly improves performance for databases in the 50 GB-100 GB size range. 1. A method comprising:creating a dynamic hash table segment on a database; andcreating a dynamic hash table within the dynamic hash table segment, the dynamic hash table comprising one or more contiguous allocation units having a plurality of contiguous pages and allocated on a per-allocation unit basis.2. The method of claim 1 , further comprising:determining availability of the contiguous allocation units from a global allocation manager, the global allocation manager tracking the availability of the contiguous allocation units in a sequence based on their location in contiguous storage space.3. The method of claim 2 , further comprising:locking access to the global allocation manager by other threads of execution prior to access thereof; andunlocking access to the global allocation manager.4. The method of claim 1 , further comprising:logging records for the contiguous pages, the records comprising old and new timestamp information, wherein the records are usable to recover a failed transaction to create the dynamic hash table.5. The method of claim 4 , further comprising:flushing the records to disk.6. The method of claim 1 , further comprising: initializing the contiguous pages.7. The method of claim 6 , wherein initializing the contiguous pages comprises:storing address information in an object allocation management page of the dynamic hash ...

Подробнее
Номер записи: 39
09-05-2013 дата публикации

SNAPSHOT ISOLATION SUPPORT FOR DISTRIBUTED QUERY PROCESSING IN A SHARED DISK DATABASE CLUSTER

Номер: US20130117307A1
Автор: FLORENDO Colin, VISHNOI Surendra Kumar
Принадлежит: Sybase, Inc.

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. 1. A method for snapshot isolation support for distributed query processing in a shared disk database cluster , the method comprising:forming object identification data in a leader node of query execution in a shared disk database cluster;distributing at least one fragment of the query execution to at least one worker node in the shared disk database cluster; andutilizing the object identification data for multiversion concurrency control during query execution by the leader node and at least one worker node.2. The method of claim 1 , wherein the object identification data further comprises an object identifier claim 1 , an object version identifier claim 1 , and an update identifier.3. The method of claim 1 , wherein utilizing further comprises utilizing the object identification data to select an object version for the at least one fragment.4. The method of claim 3 , wherein selecting an object version further comprises selecting a version based on at least one of a worker object catalog claim 3 , a database object catalog claim 3 , and a leader node version.5. The method of claim 4 , wherein the worker object catalog and database object catalog include hash tables based on the object identification data.6. The method of claim 4 , further comprising requesting version metadata of the leader node version when the version is not available locally ...

Подробнее
Номер записи: 40
09-05-2013 дата публикации

SHARED TEMPORARY STORAGE MANAGEMENT IN A SHARED DISK DATABASE CLUSTER

Номер: US20130117526A1
Автор: FLORENDO Colin Joseph
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof for temporary storage management in a shared disk database cluster are provided. Included is the reserving of units on-demand and of variable size from shared temporary storage space in the SDC. The utilization of the reserved units of the shared temporary storage space is tracked, and the shared temporary storage space is administered based on the tracking. 1. A method for shared temporary storage management in a shared disk database cluster (SDC) , the method comprising:reserving units on-demand and of variable size from shared temporary storage space in the SDC;tracking utilization of the reserved units of the shared temporary storage space; andadministering the shared temporary storage space based on the tracking.2. The method of wherein reserving units further comprises controlling a size of the reserved units based upon configuration of the SDC claim 1 , remaining space of the shared temporary storage space claim 1 , and a number of configured nodes.3. The method of wherein tracking utilization of reserved units further comprises tracking bitmaps within coordinator and secondary nodes of the SDC.4. The method of wherein tracking further comprises updating the bitmaps with respect to space allocation activity for chains of reserved units.5. The method of wherein tracking further comprises updating the bitmaps with respect to timed expiration periods.6. The method of wherein administering further comprises utilizing a garbage collection event.7. The method of wherein the garbage collection event handles expired reserved units and deallocated temporary storage space for reuse in the SDC.8. A shared disk database cluster (SDC) system with temporary storage management comprising:shared-disk storage; anda plurality of data processing nodes reserving units on-demand and of variable size from shared temporary storage space of the shared-disk storage and administering the ...

Подробнее
Номер записи: 41
16-05-2013 дата публикации

Multi-Path Replication in Databases

Номер: US20130124464A1
Автор: Lora Gallardo Elena Isabel, Pieczonka Martin Stanley, Quakkelaar Rene Eduard Alexander, Rank Christopher Hugh, Yu Shuying
Принадлежит: Sybase, Inc.

Systems, methods and computer program products for multi-path replication in databases are described herein. A non-limiting embodiment includes instantiating a plurality of replicate connections to a replicate database, providing transactions to the replicate database through a plurality of transaction streams, where the transaction streams associated with respective instantiated replicate connections. Transactions occurring in distinct transaction streams are applied, in parallel, at the replicate database. Another non-limiting embodiment includes instantiating a plurality of replication sender threads, where the replication sender threads communicate in parallel with respective replication servers over respective replication paths. Data sharing one or more attributes can be bound to a replication path in communication with the respective replication servers. 1. A computer-implemented method for database replication , comprising:instantiating a plurality of replicate connections to a replicate database;providing transactions to said replicate database through a plurality of transaction streams, said transaction streams associated with respective instantiated replicate connections; andapplying, in parallel at said replicate database, transactions occurring in distinct transaction streams.2. The method of claim 1 , further comprising:applying transactions in distinct transaction streams, at said replicate database, in a commit order distinct from said transactions' commit order at a primary database.3. The method of claim 1 , further comprising:applying transactions sharing a transaction stream in a primary database commit order.4. The method of claim 1 , wherein said providing is performed in accordance with one or more replication subscriptions.5. The method of claim 1 , further comprising:instantiating a plurality of connections to replication agent threads associated with a primary database.6. The method of claim 1 , further comprising:selectively assigning a ...

Подробнее
Номер записи: 42
23-05-2013 дата публикации

Replication Support For Heterogeneous Data Types

Номер: US20130132345A1
Автор: Chen Hai-Yan, Shepherd Stephen
Принадлежит: Sybase, Inc.

A method, system and computer readable storage medium for replicating database data of heterogeneous data type are disclosed. The method includes determining the data type of an element of heterogeneous data type to be replicated. The element is packed into a predetermined transfer format as an opaque data type, based on the determined data type, and replicated to a replication server. The replication server is instructed to not modify the element noted as opaque. 1. A method for replicating database data of heterogeneous data type , comprising:determining a data type for an element of heterogeneous data type to be replicated;packing the element into a predetermined transfer format, based on the determined data type, such that the element is not modified during replication; andreplicating the packed element.2. The method of claim 1 , wherein the packing further comprises packing the element with a type prefix and type postfix based on the determined data type.3. The method of claim 1 , further comprising determining whether replication of the data type of the element is supported.4. The method of claim 3 , further comprising transmitting an error message if replication of the data type of the element is unsupported.5. The method of claim 3 , further comprising replicating false data if replication of the data type of the element is unsupported.6. The method of claim 3 , further comprising ignoring the element if replication of the data type of the element is unsupported.7. The method of claim 1 , further comprising replicating the packed element to a replication server.8. A replication system for replicating database data of heterogeneous data type claim 1 , comprising:a memory configured to store one or more log transfer language syntaxes; determine a data type for an element of heterogeneous data type to be replicated;', 'pack the element into a predetermined transfer format, based on the determined data type, such that the element is not modified during ...

Подробнее
Номер записи: 43
30-05-2013 дата публикации

INDEX-BASED EVALUATION OF PATH-BASED QUERIES

Номер: US20130138629A1
Автор: REHMATTULLAH Mohyuddin
Принадлежит: Sybase, Inc.

Systems, methods, and computer program product embodiments are provided for path-based query evaluation. The embodiments include representing a markup language document as a descriptive catalog, and capturing relationships in the descriptive catalog as an index summary. The index summary is utilized for evaluating a path-based query. 1. A computer-implemented method for path-based query evaluation , the method comprising:representing a markup language document as a descriptive catalog comprising an index of paths;capturing relationships from the index of paths in the descriptive catalog as an index summary, including mapping a path to a next path, wherein the next path is lexically next to the path but is not a descendent of the path; andutilizing the index summary for evaluating a path-based query.2. The computer-implemented method of claim 1 , further comprising mapping the path included in the index of paths to a child path.3. The computer-implemented method of wherein the index summary comprises arrays for mapping each path to child paths and next paths based on the index of paths.4. The computer-implemented method of further comprising utilizing the index summary to traverse forward and reverse tree axes.5. The computer-implemented method of wherein the markup language comprises extensible markup language (XML).6. The computer-implemented method of wherein the path based query comprises an XPath query expression.7. A system capable of path-based query evaluation claim 1 , the system comprising:storage for storing a markup language document; and represent the markup language document as a descriptive catalog comprising an index of paths,', 'capture relationships in the descriptive catalog as an index summary, including mapping a path to a next path, wherein the next path is lexically next to the path but is not a descendent of the path; and', 'utilize the index summary for evaluating a path-based query., 'a processor coupled to the storage and configured to8. ...

Подробнее
Номер записи: 44
06-06-2013 дата публикации

System and Method for Intelligent Caching

Номер: US20130142117A1
Автор: Goldin Vadim
Принадлежит: SYBASE 365, INC.

As mobile subscribers increasingly employ their wireless devices to perform an ever expanding range of activities, it has become more and more important for all of the different entities in a wireless ecosystem (e.g., wireless carriers, intermediaries, service providers, etc.) to complete their processing activities in the most efficient, expeditious, flexible, etc. manner possible. An intelligent caching mechanism, through which for example various of the results of a preparatory step may be preserved for subsequent reuse, can inter alia incrementally reduce processing time, reduce system and network resource consumption, save money, etc. 1. A method , performed on a server computing device , for directing a quanta of data , the method comprising:receiving the quanta of data at a gateway, the quanta of data comprising an originating address, a destination address, and content;performing a plurality of processing steps including at least:(a) creating an Internal Message Object (IMO) from at least aspects of the quanta of data,(b) characterizing aspects of the quanta of data including at least by a type,(c) resolving the destination address, and(d) obviating the need to complete a preparatory step, involving a query external to the server and associated with conveying aspects of the IMO to a given destination derived from the resolving step, by retrieving at least an identifying value from a cache; andutilizing the identifying value to convey selected aspects of the IMO to the given destination.2. The method of claim 1 , wherein the quanta of data is one of (a) a Short Message Service message claim 1 , (b) a Multimedia Message Service message claim 1 , (c) an IP Multimedia Subsystem message claim 1 , (d) video data claim 1 , (e) signaling data claim 1 , or (f) application data.3. The method of claim 1 , wherein an entry in the cache is populated with aspects of a SendRoutingInfo response.4. The method of claim 3 , wherein the entry in the cache is (a) removed and/or ...

Подробнее
Номер записи: 45
20-06-2013 дата публикации

System and Method for Enhanced Information Gathering

Номер: US20130159051A1
Автор: Timmons Michael
Принадлежит: SYBASE 365, INC.

A flexible, extensible, and dynamically configurable Content Collection, Aggregation, and Enhancement Facility (CCAEF) that a (e.g., small or mid-size) merchant may employ and which would leverage aspects of the merchant's existing infrastructure (such as for example a merchant's Web site)—with for example no or minimal effort or intervention on the part of the merchant—to inter alia develop all of the required data so that the merchant can fully engage a Real-Time Offer Management System (RTOMS), or other such system, and thus more effectively compete with large merchants in the world of commerce. 1. A method , performed on a computing device , that implements a Content Collection , Aggregation , and Enhancement Facility (CCAEF) , the method comprising:receiving a first set of data from a merchant system;processing the first set of data including at least extracting one or more details therefrom, parsing the one or more extracted details, and generating one or more Feature Tags (FTs) based on the extracted details; andsending a second set of data to a Real-Time Offer Management System (RTOMS), the second set of data being based, at least in part on the first set of data.2. The method of claim 1 , wherein the merchant system comprises a web site.3. The method of claim 1 , wherein the first set of data is in a HyperText Markup Language (HTML) form or an eXtensible Markup Language (XML) form.4. The method of claim 1 , wherein the one or more details comprise an inventory quantity and a unit price.5. The method of claim 1 , wherein the processing further includes a comparison to one or more previously generated FTs.6. The method of claim 1 , wherein the second set of data is in a text form or an eXtensible Markup Language (XML) form. This application claims the benefit of U.S. Provisional Patent Application Ser. No. 61/570,895, filed on 15 Dec. 2011, which is incorporated herein in its entirety.1. Field of the InventionThe present invention relates generally to ...

Подробнее
Номер записи: 46
20-06-2013 дата публикации

Method for Exchanging Data Concerning an Electronic Transaction

Номер: US20130159109A1
Автор: Guillot Carles
Принадлежит: SYBASE 365, INC.

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. 18-. (canceled)9. A method for exchanging data relating to an electronic transaction , comprising:(a) receiving at a first entity a transaction definition message, the transaction definition message indicative of the electronic transaction and including at least an identifier of the electronic transaction and an identifier of a second entity;(b) performing, by a device of the first entity, one or more processing steps on at least the transaction definition message including at least (i) determining and reserving an available address from a plurality of predetermined addresses, yielding a reserved address, and (ii) creating an offer message, the offer message indicative of the electronic transaction and including at least a description of the electronic transaction, the reserved address, and the identifier of the second entity;(c) sending, by a first gateway of the first entity, the offer message towards the second entity;(d) receiving, by a second gateway of the first entity, a response message from the second entity; and(e) releasing the reserved address for use in a subsequent offer message.10. The method of claim 9 , wherein the first entity is a messaging intermediary.11. The method of claim 9 , wherein the second entity is a mobile device.12. The method of ...

Подробнее
Номер записи: 47
20-06-2013 дата публикации

System and Method for Enhanced Mobile Wallet

Номер: US20130159181A1
Автор: Hueck Markus
Принадлежит: SYBASE 365, INC.

A flexible, extensible, and dynamically configurable Mobile Wallet (mWallet) facility that inter alia leverages the ubiquitous nature of wireless devices to inter alia ‘store’ a quanta of value (including inter alia an amount of money, coupons, vouchers, credits, points, rewards/awards, etc.) on a wireless device so that a user of such a device may subsequently employ just their ever-present wireless device to among other things complete the payment portion of a transaction. 1. A method , performed on a computing device , that implements a Mobile Wallet (mWallet) facility for a plurality of users , the method comprising:receiving a unique identifier that is associated with the mWallet facility;ascertaining, using the unique identifier, information about the mWallet facility including at least a quanta of value that was previously added; andsending aspects of the information to at least one of a merchant or a user.2. The method of claim 1 , wherein the unique identifier is a telephone number.3. The method of claim 1 , wherein the information comprises details defined by a user of the mWallet facility during a registration process.4. The method of claim 3 , wherein the details defined during the registration process includes one or more of Identifying Information claim 3 , Financial Information claim 3 , and Billing Information.5. The method of claim 3 , wherein the details defined during the registration process are preserved through a Mobile Subscriber (MS) Profile.6. The method of claim 3 , wherein the registration process is web-based.7. The method of claim 3 , wherein the registration process includes a billing component.8. The method of claim 1 , further comprising receiving a Personal Identification Number (PIN) from one of the users as part of a mobile commerce transaction.9. The method of claim 8 , wherein the PIN was provided to the one of the users during a prior registration process.10. The method of claim 1 , further comprising interacting with a ...

Подробнее
Номер записи: 48
20-06-2013 дата публикации

HYBRID DATA REPLICATION

Номер: US20130159249A1
Автор: DEWALL Rhett Dondi, Shang Heping
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof for hybrid data replication are described. Aspects include identifying a type of database data replication, the type including a combination of replication approaches, and managing replication based on the identified type, including coordinated switching from one replication approach to another automatically with transactional consistency maintained among source and target databases. 1. A computer-implemented method for hybrid data replication in a database system environment , the method comprising:identifying a type of database data replication, the type including a combination of replication approaches; andmanaging replication based on the identified type, including coordinated switching from one replication approach of the combination of replication approaches to another automatically using replication process marker signaling for auto-switching activities to occur during the replication with transactional consistency maintained among source and target databases.2. The computer-implemented method of wherein a type further comprises a combination of log-based followed by non-log-based claim 1 , complete non-log-based followed by incremental non-log-based claim 1 , and non-log-based followed by log-based replication.3. The computer-implemented method of wherein managing further comprises managing components for publishers and subscribers claim 1 , including compensating components.4. The computer-implemented method of further comprising utilizing the compensating components for replication without complete suspension.5. The computer-implemented method of wherein a type is variable among a table of database data claim 1 , a publisher of database data claim 1 , and a subscriber of database data.6. The computer-implemented method of wherein a type is variable among tables of a same source database.7. The computer-implemented method of wherein coordinated switching for ...

Подробнее
Номер записи: 49
20-06-2013 дата публикации

DIRECTING A DATA REPLICATION ENVIRONMENT THROUGH POLICY DECLARATION

Номер: US20130159253A1
Автор: DEWALL Rhett Dondi, Shang Heping
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof for directing a data replication environment through policy declaration are described. Aspects include identifying a policy declaration defining a replication environment, and processing the policy declaration to instantiate the replication environment according to parameters established in the policy declaration. 1. A computer-implemented method for directing data replication in a database system environment , the method comprising:identifying a policy declaration defining a replication environment declared in a hierarchical policy declaration document; andprocessing the policy declaration to instantiate the replication environment according to parameters, including precedence among replication entities, established in the policy declaration.2. The computer-implemented method of wherein identifying further comprises identifying parameters for at least one of replication strategy claim 1 , replication behavior claim 1 , and replication quality of service.3. The computer-implemented method of wherein identifying replication strategy parameters further includes identifying parameters for at least one of continuous replication and snapshot replication strategies.4. The computer-implemented method of wherein identifying replication behavior parameters further includes identifying parameters for at least one of materialization claim 2 , dematerialization claim 2 , and a level of transactional consistency achieved.5. The computer-implemented method of wherein identifying replication quality of service parameters further includes identifying parameters related to compliance to performance boundaries and thresholds claim 2 , including at least one of the group comprising latency claim 2 , throughput claim 2 , uptime claim 2 , response time claim 2 , processor usage claim 2 , and prioritization.6. The computer-implemented method of wherein processing further comprises ...

Подробнее
Номер записи: 50
20-06-2013 дата публикации

Dynamic Load Balancing for Complex Event Processing

Номер: US20130160024A1
Автор: Sarmah Dilip, Shtilman Gregory, Theiding Mark
Принадлежит: Sybase, Inc.

Disclosed herein are methods, systems, and computer readable storage media for performing load balancing actions in a complex event processing system. Static statistics of a complex event processing node, dynamic statistics of the complex event processing node, and project statistics for projects executing on the complex event processing node are aggregated. A determination is made as to whether the aggregated statistics satisfy a condition. A load balancing action may be performed, based on the determination. 1. A computer-implemented method in a complex event processing cluster manager , comprising:aggregating one or more static statistics of a complex event processing node, one or more dynamic statistics of the complex event processing node, and one or more project statistics for one or more projects executing on the complex event processing node;determining whether the aggregated statistics satisfy a condition; andcausing a load balancing action to be performed, based on the determination.2. The method of claim 1 , wherein the static statistics of the complex event processing node include one or more of a CPU clock rate claim 1 , a memory amount claim 1 , a disk space amount claim 1 , an operating system claim 1 , a CPU architecture claim 1 , a number of cores claim 1 , a geographic location claim 1 , a network interface speed claim 1 , a network interface type claim 1 , a graphics processing unit type claim 1 , a graphics processing unit speed claim 1 , a storage type claim 1 , a storage speed claim 1 , and a user configured capacity.3. The method of claim 1 , wherein the one or more dynamic statistics of the complex event processing node include one or more of a CPU utilization percentage claim 1 , a memory usage amount claim 1 , a memory usage percentage claim 1 , a number of threads amount claim 1 , a disk input rate claim 1 , a disk output rate claim 1 , a network input rate claim 1 , a network output rate claim 1 , and an available disk space amount.4. The ...

Подробнее
Номер записи: 51
27-06-2013 дата публикации

Multiphase Approach To Data Availability

Номер: US20130166508A1
Автор: ELURI Amarnadh Sai, Gottapu Sasikanth Simhachala
Принадлежит: Sybase, Inc.

Embodiments include a method, apparatus and computer program product for providing access to a database data source during database maintenance. The method includes initiating maintenance of the database data source and managing the database maintenance to allow concurrent access to the database data source. 1. A method of providing access to a database data source during database maintenance , comprising:initiating maintenance of the database data source; andmanaging the database maintenance to allow concurrent access to the database data source.2. The method of claim 1 , wherein managing the database maintenance comprises:creating a data structure based on a first set of data that is locked in the database data source;while the first set of data is unlocked and being first modified by a database client, populating the data structure with data from the first set of data, the populating resulting in a second set of data;performing database maintenance operations on the second set of data;while the first set of data is unlocked and being second modified by the database client, updating the second set of data based on the first modifications made by the database client; andwhile the first set of data is locked, updating the second set of data based on the second modifications to the first set of data.3. The method of claim 2 , further comprising:deactivating the first data set as the database client data source; andactivating the second data set as the database data source.4. The method of claim 2 , wherein:updating the second set of data based on the first modifications made by the database client comprises updating the second set of data based on entries in a first portion of a database log, andupdating the second set of data based on the second modifications to the first data set comprises updating the second set of data based on entries in a second portion of the database log.5. The method of claim 2 , wherein updating the second set of data based on the first ...

Подробнее
Номер записи: 52
27-06-2013 дата публикации

Parallel Execution In A Transaction Using Independent Queries

Номер: US20130166523A1
Автор: Mittal Rahul, PATHAK Amit, Sayyaparaju Sunil
Принадлежит: Sybase, Inc.

Embodiments include a method, apparatus and computer program product for executing a database transaction in parallel using subtransactions. The method includes receiving a transaction at an application, the transaction having a first statement and a second statement, and determining whether operation of the first statement is independent from operation of the second statement. When it is determined that operation of the first statement is independent from operation of the second statement, assigning the first statement to a first subtransaction and the second statement to a second subtransaction, the first and second subtransactions being part of a transaction group. The method further includes executing the subtransactions using resources of the database. Finally, when execution of all of the subtransactions have successfully completed, committing all of the subtransactions. 1. A method of executing a database transaction in parallel using subtransactions , comprising:receiving a transaction at an application, wherein the transaction has a first statement and a second statement:determining whether operation of the first statement is independent from operation of the second statement;when it is determined that operation of the first statement is independent from operation of the second statement, assigning the first statement to a first subtransaction and the second statement to a second subtransaction, wherein the first and second subtransactions are part of a transaction group;performing coordinated execution of the transaction group using resources of a database; andwhen coordinated execution of all of the subtransactions of the transaction group has successfully completed, the subtransactions are committed.2. The method of claim 1 , wherein receiving a transaction at an application comprises receiving a transaction at a database client coupled to the database.3. The method of claim 1 , wherein receiving a transaction at an application comprises receiving a ...

Подробнее
Номер записи: 53
27-06-2013 дата публикации

Method and System for Data Exchange and Exception Handling in a Data Processing Environment

Номер: US20130166630A1
Автор: Hu Joseph W.
Принадлежит: Sybase, Inc.

System, method, computer program product embodiments and combinations and sub-combinations thereof for data exchange and exception handling in a data processing environment are described. Aspects include providing a generic data structure to store a value object and a collection of value Objects based upon built-in programming capabilities of a client system and a server system that achieve a rich Internet application experience within a data processing network, and utilizing the generic data structure to exchange data between the client system and the server system of the data processing network. A specialized result form of the generic data structure is also provided and utilized to manage generated exceptions of the data exchanges. 1. A method for data exchange and exception handling comprising:providing a generic data structure to store a value object and a collection of value objects based upon built-in programming capabilities of a client system and a server system that achieve a rich Internet application experience within a data processing network;utilizing the generic data structure to exchange data between the client system and the server system of the data processing network;providing a specialized result form of the generic data structure; andutilizing the specialized result form to manage generated exceptions of the data exchanges.2. The method of further comprising utilizing the specialized result form to communicate at least one of result data claim 1 , status data claim 1 , and error message data.3. The method of wherein the generic data structure stores a generic hash map representing at least one of an object and a generic collection of generic hash maps representing multiple objects for a Java-capable server system.4. The method of wherein the generic data structure stores an associative array representing at least one of an object and an array of associative arrays representing multiple objects for an Adobe FLEX-capable client system.5. The method ...

Подробнее
Номер записи: 54
04-07-2013 дата публикации

Monitoring Distributed Task Execution Using a Chained Text Messaging System

Номер: US20130173686A1
Автор: French Blaine Carlton, Hu Joseph Weizhen, Santurkar Vinay
Принадлежит: Sybase, Inc.

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. 1. A method for monitoring task processing in a distributed system , comprising:distributing a task as a plurality of subtasks to a plurality of computing devices within the distributed system for execution, wherein a respective computing device executes a subtask, the subtask including a remote method invocation (RMI) object that invokes a callback function;monitoring execution of the plurality of subtasks using at least one message generated by the RMI object on the respective computing device; anddetermining a progress and status information of the task based on the at least one message.2. The method of claim 1 , further comprising:using a callback function, transmitting the progress and status information for the plurality of subtasks for display on a client device.3. The method of claim 1 , wherein the call back function invocation is chained to another call back function for relaying the at least one message.4. The method of claim 1 , further comprising:invoking the callback function when a subtask in the plurality of subtasks enters a distinct processing phase.5. The method of claim 1 , wherein the at least one message includes the progress and status information in a message header.6. The method of ...

Подробнее
Номер записи: 55
04-07-2013 дата публикации

Optimized Approach to Parallelize Writing to a Shared Memory Resource

Номер: US20130173866A1
Автор: PASUPULETI Kantikiran Krishna, Sakhalkar Ameya, Tiwari Anunay, Wood Daniel Alan
Принадлежит: Sybase, Inc.

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.

Подробнее
Номер записи: 56
01-08-2013 дата публикации

System and Method for Message Service Gateway

Номер: US20130196627A1
Автор: Kam-Hon Ng, Marina E. Giverts, Steven J. Dantzer
Принадлежит: Sybase Inc

A flexible, extensible, and dynamically configurable message service gateway that offers inter alia a façade through which a Content Provider (CP), among others, may invoke services to simply and easily complete among other things opt-in and opt-out activities in connection with a CP campaign or initiative. Among other things such a façade may hide various of the complexities, technical aspects, etc. of different communication paradigms including for example Short Message Service, Multimedia Message Service, Internet Protocol Multimedia Subsystem, Wireless Application Protocol, Electronic Mail, Instant Messaging, Unstructured Supplementary Service Data, etc. Such a façade may be offered by a centrally-located, full-featured Messaging Inter-Carrier Vendor.

Подробнее
Номер записи: 57
22-08-2013 дата публикации

Universal Short Code Administration Facility

Номер: US20130217425A1
Автор: Chava Venkatesh, Jr. Robert C., Lovell, Sweatman Phillip J., Zimmern Christian
Принадлежит: SYBASE 365, INC.

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. 1. Within a message processing entity , a server-based method for routing a Short Message Service (SMS) message towards an Application Provider (AP) , the server-based method comprising:receiving at a first gateway the SMS message, the SMS message (1) having a Universal Short Code (USC) as a destination address and (2) having been originated by a Mobile Subscriber;processing aspects of the SMS message including at least using information received from a USC administrator to identify from the USC the AP associated with the USC; andsending from a second gateway aspects of the SMS message towards the identified AP,wherein the information received from the USC administrator comprises information regarding the temporal association of respective USCs to APs.2. The server-based method according to claim 1 , wherein processing further includes issuing a routing request claim 1 , comprising the USC claim 1 , and receiving a routing response claim 1 , comprising an indicia of the AP associated with the USC.3. The server-based method according to claim 1 , wherein receiving comprises receiving the SMS message from a wireless carrier.4. The server-based method according to claim 1 , wherein the message processing entity is optimized with respect to a type of messaging protocol.5. The server-based method according to claim 4 , wherein the messaging protocol is ...

Подробнее
Номер записи: 58
19-09-2013 дата публикации

System and Method for Item Identification and Purchase

Номер: US20130246205A1
Автор: Jr. Robert C., Lovell
Принадлежит: SYBASE 365, INC.

A method and system for handling message-based requests for information about items, and for handling optional message-based purchases of same, includes receiving a request message from a mobile subscriber relating to an item that is of interest to the mobile subscriber, routing the request message for processing, performing one or more activities in accordance with the request message, and returning one or more response messages to the mobile subscriber. 1. A method for facilitating a purchase of an item of interest by a user of a wireless device , comprising:receiving a purchase message, designating the item of interest, from a wireless carrier associated with the wireless device user at a messaging inter-carrier vendor, the purchase message having been initiated by the user of the wireless device and addressed to a destination address of a service provider associated with the item of interest;extracting data elements from the purchase message;validating the extracted data elements; and forwarding the purchase message from the messaging inter-carrier vendor to the service provider,wherein the destination address was provided to the user of the wireless device by the service provider in a connection with a world wide web-based prior registration process between the user of the wireless device and the service provider, and wherein the service provider is different from the wireless carrier.2. The method of claim 1 , further comprising routing the purchase message to a service access subsystem of the messaging inter-carrier vendor.3. The method of claim 1 , further comprising:retrieving user information related to the user of the wireless device received in the registration process;forwarding the user information and the extracted data elements to a billing interface; andcompleting a billing transaction related to the item.4. The method of claim 3 , wherein the billing transaction comprises one of a line item charge from the wireless carrier claim 3 , a charge on a ...

Подробнее
Номер записи: 59
07-11-2013 дата публикации

Character Data Compression for Reducing Storage Requirements in a Database System

Номер: US20130297573A1
Автор: Qian Xu-dong, Xiong ZhiPing
Принадлежит: Sybase Inc.

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. 1. A method for reducing data storage requirements in a relational database system through character data encoding , comprising:determining a usage frequency of a character in a full data page;grouping the character into a first set of characters, the first set representing most frequently used characters in the full data page;encoding the first set of characters based on the usage frequency, comprising mapping characters of the first set of characters to a first range of bits;encoding a second set of characters, comprising mapping characters of the second set of characters to a second range of bits, the second range of bits differing from the first range of bits; andstoring the first and second set of encoded characters.2. The method of claim 1 , wherein the character is an American Standard Code for Information Interchange claim 1 , (ASCII) character type.3. The method of claim 1 , wherein the determining a usage frequency further comprises collecting all character data from columns with data of a particular character type.4. The method of claim 3 , further comprising identifying a predetermined number of most frequently used characters in the collected character data.5. (canceled)6. The method of claim 1 , further comprising encoding each character of the first set with half a number of bits used to encode each character of the second set.7. The method of claim 6 , further including encoding each character of the first set with one-third a number of bits used to encode each character of a ...

Подробнее
Номер записи: 60
14-11-2013 дата публикации

System and Method for Dynamic Spam Detection

Номер: US20130303204A1
Автор: Dudley William H.
Принадлежит: SYBASE 365, INC.

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. 1. Within a message processing entity a computer-implemented method for detecting spam , the computer-implemented method comprising:receiving, at a gateway, a Short Message Service (SMS) message, the SMS message comprising an originating address and a destination address; updating, in a cache, an entry for the originating address, including at least incrementing by one a first counter in the cache entry when the destination address is unique for the originating address within a first time window representative of a first period of time,', 'evaluating a value of the first counter for the cache entry;', 'evaluating a value of a second counter that was operative within a second time window representative of a second period of time prior to the first period of time and incremented by one when, upon receipt of another SMS message, the destination address thereof was unique for the originating address, and', 'when the value of the first counter and the value of the second counter exceed respective defined thresholds setting a spam indicator; and, 'processing the SMS message, including at leastresponsive to the spam indicator being set, performing one or more ...

Подробнее
Номер записи: 61
28-11-2013 дата публикации

CACHE CONFLICT DETECTION

Номер: US20130318055A1
Автор: Alberti Johannes, Lorenz Brian Keith, Waterman Lance
Принадлежит: Sybase, Inc.

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. 1. A computer-implemented method for performing cache conflict detection , comprising:providing a partial graph of data to an application executing on a mobile device, wherein 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, wherein the modified partial graph includes one or more changes to the partial graph; anddetermining a document version used to derive the partial graph is no longer a most recent version of the document.2. The method of claim 1 , further comprising:receiving information about the most recent version of the document from a data source.3. The method of claim 1 , further comprising:receiving the most recent version of the document from the data source.4. The method of claim 3 , further comprising:automatically merging one or more of the changes introduced by the modified partial graph with the most recent version of the document when producing a new version of the document.5. The method of claim 3 , further comprising:merging one or more of the changes introduced by the modified partial graph with the most recent version of the document based on at least one instruction received from the mobile application when producing a new version of the document.6. The method of claim 3 , further comprising:sending an alert to the mobile application indicating at least one of the ...

Подробнее
Номер записи: 62
28-11-2013 дата публикации

Plan Caching Using Density-Based Clustering

Номер: US20130318069A1
Автор: AluÇ Günes, Bowman Ivan T., Dehaan David E.
Принадлежит: Sybase, Inc.

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. 1. A method comprising:receiving, by at least one processing device, a query instance according to a query template having a set of parameters;determining, by the at least one processing device, a plan space point for the query instance, the plan space point based upon the set of parameters; andpredicting, by the at least one processing device, a predicted query plan for the plan space point, the predicted query plan selected from a map of query plans according to a confidence threshold from a plan cache that includes at least one histogram, each histogram representative of a cached query plan in the plan cache combined with a previously-selected locality-sensitive hashing function, the histogram storing a frequency distribution of a mapping of sample plan points for the cached query plan by the locality-sensitive hashing function.2. The method of claim 1 , further comprising:adding the plan space point to the frequency distribution of the sample plan points.3. The method of claim 2 , further comprising:executing the query instance using the predicted query plan and receiving query results.4. The method of claim 1 , further comprising:predicting the predicted query plan by selecting a query plan with a highest density of the sample ...

Подробнее
Номер записи: 63
28-11-2013 дата публикации

COMPOSITE GRAPH CACHE MANAGEMENT

Номер: US20130318192A1
Автор: Alberti Johannes, Lorenz Brian Keith, Waterman Lance
Принадлежит: Sybase, Inc.

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. 1. A computer-implemented method for synchronizing data between a mobile application and an enterprise data source , comprising:receiving a request for data from an application executing on a mobile device;receiving a document including the requested data from a data source, wherein the document represents a graph of data having a plurality of nodes; andproviding a partial graph of data to the application, wherein the partial graph is derived from the received document and at least includes the requested data.2. The method of claim 1 , further comprising:requesting the data from the data source on behalf of the application.3. The method of claim 2 , further comprising:determining whether the received document exists in local cache.4. The method of claim 3 , further comprising:persisting the received document in the local cache based on a determination that the received document does not exist in the local cache.5. The method of claim 3 , further comprising:replacing an existing document in the local cache with the received document based on a determination that the received document is a more recent version.6. The method of claim 1 , further comprising:receiving a modified partial graph from the application; andproviding a new version of the document to the data source, wherein the new version includes one or more changes introduced by the modified partial graph.7. The method of claim 6 , further comprising ...

Подробнее
Номер записи: 64
05-12-2013 дата публикации

System and Method for Intelligent Routeback

Номер: US20130324134A1
Автор: Dar Ilan, Hasan Yusuf, Ruparelia Mitul, Saez Alexandre
Принадлежит: SYBASE 365, INC.

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. 1. Within an intermediary facility a server-based method for directing a quanta of data , the server-based method comprising:receiving the quanta of data from a sending entity, the quanta of data comprising a source address, a destination address, and a content;identifying from the content a type indicator;sending to an external entity a routing request message, the routing request message comprising aspects of the quanta of data;receiving from the external entity a routing response message, the routing response message comprising a routing indicia;identifying, using at least aspects of the quanta of data and the routing indicia, a receiving entity; andbased on at least (a) a set of rules comprising delivery routes available to the sending entity, (b) the routing indicia, and (c) the type indicator, returning aspects of the quanta of data to the sending entity.2. The server-based method of wherein the quanta of data is one of (a) a Short Message Service message claim 1 , (b) a Multimedia Message Service message claim 1 , (c) an IP Multimedia Subsystem message claim 1 , (d) an E-Mail message claim 1 , (e) audio data claim 1 , (f) video data claim 1 , (g) signaling data claim 1 , or (h) application data.3. The server-based method of claim 1 , wherein at least one of the sending entity and the receiving entity is a wireless carrier.4. The server-based method of claim 1 , wherein the ...

Подробнее
Номер записи: 65
12-12-2013 дата публикации

Non-Periodic Check-Pointing for Fine Granular Retry of Work in a Distributed Computing Environment

Номер: US20130332938A1
Автор: COX William Harrison, DESCHLER Kurt Wilhelm, JOHNSON Curtis Grant, JR. Victor, MESENZEFF, MITTAL Kaushal
Принадлежит: Sybase, Inc.

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. 1. A method of distributing work in a distributed computing environment , comprising:receiving a work assignment;dividing the work assignment into a plurality of work units;distributing a first work unit to a first worker node; andre-distributing at least a portion of the first work unit to a second worker node in response to determining that the first worker node has experienced a re-distribution condition with respect to the first work unit.2. The method of claim 1 , further comprising: receiving at least a portion of a result of the first work unit from the first worker node.3. The method of claim 1 , further comprising:distributing a second work unit to the second worker node; andreceiving a result of the second work unit from the second worker node.4. The method of claim 3 , wherein the re-distributing at least a portion of the first work unit to the second worker node occurs following the receiving the result of the second work unit from the second computer.5. The method of claim 1 , wherein the re-distribution condition comprises an elapsed time from when the first work unit was distributed to the first worker node that exceeds a pre-determined threshold.6. The method of claim 1 , wherein the step of distributing the first work unit to the first worker node occurs in response to receiving an indication from the first worker node that the first worker node is available to receive a work unit.7. The method of claim 1 , wherein the work assignment is a database query.8. The method of claim 1 , ...

Подробнее
Номер записи: 66
06-03-2014 дата публикации

Single Producer, Single Consumer Lockless FIFO/LIFO Queue

Номер: US20140064291A1
Автор: BISWAS Shubhra Sankar
Принадлежит: Sybase, Inc.

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. 1. A method for managing a lockless queue comprising:receiving data elements having individual priority types for placement in a queue; andutilizing 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.2. The method of claim 1 , further comprising:determining whether the queue is empty;when the queue is determined to be empty, inserting a received data element at the initial location in the queue; andwhen the queue is determined to be not empty, determining whether the received data element is of a first priority type or a second priority type, when the received data element is determined to be of the first priority type, inserting the received data element in the queue after each existing data element of the first priority type in the queue; and', 'when the received data element is determined to be of the second priority type, inserting the received data element in the queue before each existing data element of the first priority type after the initial location in the queue., 'wherein the utilizing the priority types includes3. The method of claim 1 , wherein the utilizing the priority types of the received data elements to determine placement in the queue includes inserting the received data elements into a linked list.4. The method of claim 2 , wherein the data element at the initial location in the queue is an oldest data ...

Подробнее
Номер записи: 67
06-03-2014 дата публикации

EXTENSIBLE EXECUTABLE MODELING

Номер: US20140068576A1
Автор: Babkin Sergey, Dohring Kyle James, Gandhi, Garofalo Vincent Roy, JR. Palaniappan, Kohli Manbeen P., Kucharczyk Andrzej, Pendap Santosh Dattu, REHMATTULLAH Mohyuddin, Shtilman Gregory L., Skrzypczak Joseph Michael, Sutton Raphael Hercules
Принадлежит: Sybase, Inc.

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. 1. A computer-implemented method for generating executable computer code in an extensible format , comprising:receiving computer source code for compilation; andcompiling the source code, to generate executable computer code in an extensible format, wherein the executable computer code includes instructions to be executed by a computer system configured to process the instructions in the extensible format.2. The method of claim 1 , further comprising:providing the executable computer code in the extensible format to the computer system for execution.3. The method of claim 1 , wherein the source code contains at least one data flow configured to implement event stream processing.4. The method of claim 3 , further comprising:determining, during the compiling, that two or more different event processing queries in a data flow are used to define a same state.5. The method of claim 4 , further comprising:coalescing, during the compiling, the different event processing queries in the data flow, based on the determination that the queries are used to define the same state.6. The method of claim 5 , wherein the generated executable computer code includes the different event processing queries as coalesced.7. The method of claim 1 , wherein the computer system includes a Complex Event Processing (CEP) engine configured to execute the executable computer code in the extensible format.8. A system for generating executable computer code in an extensible format claim 1 , comprising:one or more processors;a module configured to receive, using the one or ...

Подробнее
Номер записи: 68
05-01-2017 дата публикации

Database Logging Using Storage Class Memory

Номер: US20170004317A1
Автор: Peter Bumbulis
Принадлежит: Sybase Inc

A plurality of reserve and commit log operations are initiated in a database system. Thereafter, at least a portion of the database operations are logged in a log such that transient data structures are kept in-memory of the database system and persistent data structures are kept in byte-addressable memory. Next, each of one or more clients concurrently accessing the log are registered to enable such clients to access the log.

Подробнее
Номер записи: 69
15-01-2015 дата публикации

Providing Durability of In-Memory Columnar Datastores Using Multile Logs

Номер: US20150019516A1
Автор: Anil Goel, Colin FLORENDO, David Wein
Принадлежит: Sybase Inc

Embodiments described herein generally relate to providing durability of in memory columnar datastores using multiple logs. A computer-implemented method is described. The method includes receiving a request to perform a transaction involving multiple tables in a column-oriented database system. The method further includes performing the transaction on each of the two or more database tables. Performance of the transaction generates two or more commit fragments corresponding to each of the two or more database tables. The method further includes writing each commit fragment to a transaction log for each of the two or more database tables. The method also includes writing a commit record for the transaction to a commit log after all commit fragments have been written.

Подробнее
Номер записи: 70
22-01-2015 дата публикации

In-Memory Bitmap for Column Store Operations

Номер: US20150026141A1
Автор: ANDREI Mihnea, Blanco Rolando, Goel Anil Kumar
Принадлежит: Sybase, Inc.

Disclosed herein are system, method, and computer program product embodiments for implementing a bitmap for a column store database. An embodiment operates by creating, by at least one processor, a bitmap identifying rows in a column store database. The bitmap may include a list of bit chunks, a bit chunk including an offset being a natural number indicating a chunk size, and a bit specification including one of an ordered row id list, a contiguous row id sequence, and a bit vector. In addition, the embodiment includes performing database operations using the bitmap. 1. A method , comprising:creating, by at least one processor, a bitmap identifying rows in a column store database, flat bitmap comprising a list of hit chunks, a bit chunk comprising an offset comprising a natural number indicating a chunk size, and a bit specification comprising one of an ordered row id list, a contiguous row id sequence, and a bit vector; andperforming database operations using the bitmap.2. The method of claim 1 , the bitmap further comprising:a first chunk reference indicating a first chunk in the list of bit chunks; anda last chunk reference indicating a last chunk in the list of bit chunks.3. The method of claim 1 , the bit specification further comprising:a first row id indicating a first bit in the bit specification; anda last row id indicating a last bit in the bit specification.4. The method of claim 1 , the bit chunk further comprising:a next chunk reference indicating a next chunk in the list of bit chunks; anda previous chunk reference indicating a previous chunk in the list of bit chunks.5. The method of claim 1 , further comprising:adding new row ids to the bitmap; anddynamically transforming the list of bit chunks to minimize memory used to represent the bitmap.6. The method of claim 1 , further comprising:removing existing row ids from the bitmap; anddynamically transforming the list of bit chunks to minimize memory used to represent the bitmap.7. The method of claim 1 ...

Подробнее
Номер записи: 71
29-01-2015 дата публикации

High Performance Index Creation

Номер: US20150032758A1
Автор: Pendap Santosh, Rui Ming-li, Schneider Peter, Xiong Leon
Принадлежит: Sybase, Inc.

High performance index creation using parallel query plans with repartitioning scan and vector-based repartitioning scan is described. An example method includes extracting index key columns from data rows of the database table to build a set of index rows, wherein the index on the database table is defined by a plurality of index key columns including a first index key column and a second index key column. Partition boundary values are generated to divide up the index rows into range-partitioned sets, and the index rows are sorted based on values of the index key columns. A repartitioning scan, including a SARG-based or a vector-based partitioning scan is performed on the index rows, using a plurality of worker threads executing in parallel to build sub-indexes. Subsequently, each range-partitioned set of index rows are assigned to a worker thread in the plurality of worker threads. Accordingly, the sub-indexes generated from the plurality of work threads are merged to build the index for the database table. 1. A computer-implemented method for creating an index on a database table , comprising:extracting index key columns from data rows of the database table to build a set of index rows, wherein the index on the database table is defined by a plurality of index key columns including a first index key column and a second index key column;generating partition boundary values to divide up the index rows into range-partitioned sets, wherein the index rows are sorted based on values of the index key columns;performing a repartitioning scan on the index rows of the database table, using a plurality of worker threads executing in parallel to build sub-indexes, wherein each range-partitioned set of index rows are assigned to a worker thread in the plurality of worker threads; andmerging the sub-indexes from the plurality of work threads to generate the index for the database table.2. The method of claim 1 , wherein the repartitioning scan is a vector-based repartitioning ...

Подробнее
Номер записи: 72
02-02-2017 дата публикации

Rollover Strategies in a N-Bit Dictionary Compressed Column Store

Номер: US20170031964A1
Автор: Anil Kumar Goel, Minhnea Andrei, Muhammed Sharique
Принадлежит: Sybase Inc

Disclosed herein are system, method, and computer program product embodiments for rollover strategies in an n-bit dictionary compressed column store. An embodiment operates by receiving a new value for addition to a compressed column store. It is determined that a maximum storage capacity for tokens in the compressed column store has been reached for the data dictionary. The compressed column store is converted into a composite store including the existing compressed column store and a newly created flat store. The new value is stored in the flat storage portion of the composite store.

Подробнее
Номер записи: 73
18-03-2021 дата публикации

Partition level operation with concurrent activities

Номер: US20210081395A1
Автор: Amit PATHAK, Nikhil Jamadagni, Paresh Rathod, Swati Sharma
Принадлежит: Sybase Inc

Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.

Подробнее
Номер записи: 74
09-04-2015 дата публикации

Freeing Memory Safely with Low Performance Overhead in a Concurrent Environment

Номер: US20150100730A1
Автор: Kandiyanallur Vivek
Принадлежит: Sybase, Inc.

Freeing memory safely with low performance overhead in a concurrent environment is described. An example method includes creating a reference count for each sub block in a global memory block, and each global memory block includes a plurality of sub blocks aged based on respective allocation time. A reference count for a first sub block is incremented when a thread operates a collection of data items and accesses the first sub block for a first time. Reference counts for the first sub block and a second sub block are lazily updated. Subsequently, the sub blocks are scanned through in the order of their age until a sub block with a non-zero reference count is encountered. Accordingly, one or more sub blocks whose corresponding reference counts are equal to zero are freed safely and with low performance overhead. 1. A computer-implemented method for memory management , comprising:creating a reference count for each sub block in a global memory block, wherein the global memory block includes a plurality of sub blocks aged based on respective allocation time;incrementing a reference count for a first sub block when a thread operates a collection of data items and accesses the first sub block for a first time;lazily updating reference counts for the first sub block and a second sub block when the thread returns with a new collection of data items and accesses the second sub block different from the first sub block, wherein the reference count for the first sub block is decremented and the reference count tor the second sub block is incremented; andfreeing one or more sub blocks in the order of their age, wherein reference counts of the sub blocks to be freed are equal to zero.2. The method of claim 1 , wherein freeing further comprises:scanning through the one or more sub blocks in the order of their age until encountering a sub block with a non-zero reference count.3. The method of claim 2 , further comprising:scanning through the one or more sub blocks whose ...

Подробнее
Номер записи: 75
16-06-2016 дата публикации

Data replication among portable electronic devices

Номер: US20160173591A1
Автор: Hemanth Basrur, Keshav Gupta
Принадлежит: Sybase Inc

Various embodiments of systems and methods for replicating data included in a portable electronic device to a new portable electronic device are described herein. Initially a copy of data, including an application, stored in the portable electronic device is generated. Next a determination is made whether the application is included in an application distribution platform corresponding to an operating system of the new portable electronic device. Finally based on the determination, the application is downloaded from the application distribution platform to the new portable electronic device.

Подробнее
Номер записи: 76
02-07-2015 дата публикации

Set-oriented locking based on in-memory bitmaps for a column-oriented database

Номер: US20150186448A1
Автор: Anil Kumar Goel, David Wein, Mark DELAFRANIER, Mihnea Andrei, Rolando Blanco
Принадлежит: Sybase Inc

A set-oriented locking based on in-memory bitmap for a column store database is described. An example method includes establishing a column-based in-memory database including a main store and a delta store, where the delta store has a plurality of row-visibility lock bitmaps visible to transactions at various points in time. The lock bitmaps represent a bit encoding to indicate whether there are granted row locks tables in the database. A delete or an update statement is executed with a transaction on a table. A set of row locks on rows of the table manipulated by the delete or the update statement are requested to preclude other transactions from currently deleting or updating the same rows. Accordingly, set operations are performed on the lock bitmap to manage the set of row locks associated with the transaction.

Подробнее
Номер записи: 77
06-08-2015 дата публикации

SAFE SYNCRHONIZATION OF PARALLEL DATA OPERATOR TREES

Номер: US20150220611A1
Автор: Eflov Elmi, Farrar Daniel James
Принадлежит: Sybase, Inc.

An operator tree is formed for a data processing plan, the operator tree containing a plurality of interconnected nodes and including a grouping of two or more duplicative portions, each of the two or more duplicative portions having identical nodes and structure such that when the operator tree is executed, operators executed in a first duplicative portion using a first thread perform same functions use different data than operators in a second duplicative portion using a second thread. One or more operators in the first portion and one or more operators in the second portion to be synchronized with each other are identified. A synchronization point is created for the identified operators in the first thread and one or more subsequent threads, wherein the synchronization point receives information from each of the identified operators to build an artifact to deliver to one or more operators that depend on the artifact. 1. A method for performing data processing operations in parallel , the method comprising:forming an operator tree for a data processing plan, the operator tree containing a plurality of interconnected nodes, the operator tree including a grouping of two or more duplicative portions, each of the two or more duplicative portions having identical nodes and structure such that when the operator tree is executed, operators executed in a first duplicative portion using a first thread perform same functions as operators executed in a second duplicative portion using a second thread, wherein operators executed in the first duplicative portion use different data than operators executed in the second duplicative portion;identifying one or more operators in the first duplicative portion and one or more operators in the second duplicative portion to be synchronized with each other; andcreating a synchronization point for the identified operators in the first thread and one or more subsequent threads, wherein the synchronization point receives information from ...

Подробнее
Номер записи: 78
09-10-2014 дата публикации

Continuous Change Data Capture Without Disruption of DDL

Номер: US20140304229A1
Автор: Reiger Derek, Zhu Jianbing
Принадлежит: Sybase, Inc.

A system, method and computer-readable medium for data capture for replication are provided. A data record from a transaction log of a source database indicative of a data element change is retrieved. A DDL command is generated from the retrieved data record. Once generated, the DDL command is distributed for replication to a target database such that the source database and the target database are synchronized. 1. A method for data capture for replication , comprising:retrieving a data record from a log of a source database, wherein the data record is indicative of a data element change; andgenerating a data definition language (DDL) command compatible with a target database using the retrieved data record.2. The method of claim 1 , further comprising:distributing the DDL command to the target database to synchronize the source database and the target database.3. The method of claim 1 , wherein retrieving the data record further comprises using an application programming interface associated with the source database.4. The method of claim 1 , wherein the data record includes a change in at least one column in the data element claim 1 , wherein the data element includes at least a table or a schema.5. The method of claim 1 , wherein the data record includes a change in quantity of columns or schemas in the source database.6. The method of claim 1 , wherein the retrieving further comprises retrieving a plurality of data records from the source database claim 1 , wherein at least one data record is retrieved from a first log and at least one data record is retrieved from a second log claim 1 , and wherein the generating further comprises generating the DDL command from the at least one record in the first log and the at least one record in the second log.7. The method of claim 6 , wherein the first log is a data management system log and the second log is a data object manager log.8. The method of claim 1 , further comprising:storing the generated DDL command.10. The ...

Подробнее
Номер записи: 79
30-10-2014 дата публикации

UNIVERSAL SHORT CODE ADMINISTRATION FACILITY

Номер: US20140323169A1
Автор: Chava Venkatesh, Lovell Robert C., Sweatman Phillip J., Zimmern Christian
Принадлежит: SYBASE 365, INC.

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. 120-. (canceled)21. Within a message processing entity , a server-based method for routing a Short Message Service (SMS) message towards an Application Provider (AP) , the server-based method comprising:receiving, at a first gateway, the SMS message, the SMS message (1) having a Universal Short Code (USC) as a destination address and (2) having been originated by a Mobile Subscriber;processing aspects of the SMS message including at least using information received from a USC administrator, comprising information regarding the temporal association of respective USCs to APs, to identify the AP associated with the USC; andsending, from a second gateway, aspects of the SMS message towards the identified AP.22. Within a Universal Short Code (USC) administration entity , a server-based method for administering USCs , the server-based method comprising:receiving a USC lease request, the USC lease request comprising (1) an indicia of an Application Provider (AP) and (2) a specified period of time;determining from the USC lease request a specific USC;determining a current status of the specific USC through at least a lookup against a repository;assigning the specific USC to the AP for the specified period of time, provided the current status of the specific USC is available, by at least updating the repository to associate the AP indicia with the specific ...

Подробнее
Номер записи: 80
17-09-2015 дата публикации

Systems and methods for reducing load database time

Номер: US20150261620A1
Автор: Carlos Ruiz, Graham Ivey
Принадлежит: Sybase Inc

Systems and methods are presented for reducing load database time in a database backup process. In some embodiments, a computer-implemented method may include marking a checkpoint in a log of the database; generating a backup of the database for data up to the checkpoint; recording first changes in the database while generating the backup of the database; adding to the backup of the database an additional backup of the recording of the first changes; recording second changes in the database while adding the additional backup; determining if a number of second changes satisfies a criterion; and if the number of second changes satisfies the criterion, then adding to the backup of the database a backup of the recorded second changes. Recording these changes can enable a database dump process to contain more recent page images, so that the amount of recovery at load time is reduced.

Подробнее
Номер записи: 81
19-05-1998 дата публикации

Maximum receive capacity specifying query processing client/server system replying up to the capacity and sending the remainder upon subsequent request

Номер: US5754771A
Автор: David W. Van Couvering, Dirk Epperson
Принадлежит: Sybase Inc

An Interactive Television (ITV) Client/Server system comprises one or more Clients (e.g., set top boxes or "STBs") connected to a Server module, via a Broadband Communication Network, is described. The system provides a generic mechanism for deciding how much or how little data is to be sent in response to a request from a Client. Specifically, each Client is allowed to describe ahead of time how much memory (approximately or exactly) it is allowing for the query result. This is communicated by the Client as part of the query itself. Regardless of what other activity the Client undertakes, the server maintains the context of the original query, until the Client terminates the connection. In a similar manner, when other simultaneous queries are open, the context is maintained for each query until the connection is dropped (or the query terminates). The Client can ask for more data (i.e., rows) on any open query. To optimize operation of the environment, requests from the Clients (i.e., queries) are de-multiplexed down to a set of worker threads, available at the server, which carry out the actual work of query processing. Because of this approach, a request for more data from a Client (i.e., set top box) can "land" on any worker thread. This gives queries the ability to "jump" from one thread of execution to another. In this manner, a finite number of threads may be employed to service a large query pool, with maximum throughput.

Подробнее
Номер записи: 82
27-12-2016 дата публикации

Efficiently handling large data sets on mobile devices

Номер: US9529866B2
Автор: Raman SETHI
Принадлежит: Sybase Inc

A system, method, and computer program product are provided for efficiently fetching and displaying large datasets on mobile devices, such as devices running the iPhone™ operating system. The method fetches data for a mobile device from a server and displays a plurality of data rows in a ListView within a user interface on the mobile device. The method stores primary keys on the mobile device until their corresponding data rows are to be displayed. The method reacts to user inputs such as scrolling actions and touch screen gestures to efficiently fetch and display list view subsets of large datasets. The method facilitates quick response times when navigating through large lists of data on a mobile device by: fetching displayable or visible rows of data in a data list view, preloading the visible rows on the mobile device; and binding the visible rows to user interface elements on the mobile device.

Подробнее
Номер записи: 83
23-12-2010 дата публикации

Tuning query execution performance of a database system

Номер: US20100325124A1
Автор: Juan Wu, Sudipto Rai Chowdhuri
Принадлежит: Sybase Inc

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.

Подробнее
Номер записи: 84
05-11-1996 дата публикации

Secure multi-level system for executing stored procedures

Номер: US5572673A
Автор: Scott A. Shurts
Принадлежит: Sybase Inc

A database management system is provided for security of database objects. These objects may be passive elements such as tables, rows, views, the databases themselves, etc., or they may be executable items such as stored procedures or triggers. A mechanism is provided for "certifying" that certain types of objects such as stored procedures, triggers, and views can be safely used to access other, sensitive objects in the database. Certification indicates that (1) a security officer has evaluated and certified the object, and (2) the now certified object has not undergone a defined security-relevant change since certification. Certification is particularly important in the context of a "trusted" stored procedure or a "trusted" stored trigger. "Trusted" executable objects can be executed at sensitivity levels that exceed that of a user or subject. Thus, the subject may use a trusted stored procedure or trigger to access certain objects having higher sensitivity levels than his or her own. If the certified object changes in a security-relevant manner, its "certification state" changes from certified to "suspect" which causes the object to become unexecutable.

Подробнее
Номер записи: 85
25-10-2011 дата публикации

System and method for measuring latency in a continuous processing system

Номер: US8046744B1
Автор: Aleksey Sanin, Ian D. Marshall, Mark Tsimelzon, Robert B. Hagmann
Принадлежит: Sybase Inc

The present invention provides a system and method for measuring latency in a continuous processing system. The invention involves generating “tracer” messages that are specifically designed for measuring latency. A tracer message is configured to pass through and be outputted by each primitive in the tracer message's path regardless of the function of the primitive and without changing the state of the primitive. Tracer messages are not filtered by filter primitives or delayed by time-delay primitives. Tracer messages are detected and discarded within loops. These rules provide for predictable behavior of tracer messages, thereby making them reliable indicators of latency and liveness in the continuous processing system. A tracer message is inserted into the continuous processing system at a desired start point for measuring latency. At a desired end point for measuring latency, latency is measured by calculating the amount of time the tracer message took to travel from the start point to the end point.

Подробнее
Номер записи: 86
14-03-2017 дата публикации

Append-only b-tree cursor

Номер: US9594786B2
Автор: Blaine French, Nandan MARATHE
Принадлежит: Sybase Inc

Existing algorithms to build balanced tree structures (“b-trees”) compare a data element (e.g., a key) to be inserted with the data elements that have already been inserted to find the correct position to insert the data element. Additionally, the algorithms balance and/or rebalance the b-tree when any individual node gets over-filled. As part of this balancing, data elements stored in the various nodes are moved to other nodes. These operations can incur both time and resource costs. We propose an algorithm to build a b-tree in a bottom up manner and a technique to modify trees built using the aforementioned algorithm so that they are balanced. We also propose a method to allow for adding more data into the thus-built b-tree as long as it follows a certain set of pre-conditions.

Подробнее
Номер записи: 87
04-10-2016 дата публикации

Enhanced real-time messaging

Номер: US9462532B2
Автор: Joseph Hardy LIPSCOMB, Michael Daragh O'SULLIVAN, Russell Green, Stephen Kwan
Принадлежит: Sybase Inc

A system includes a gateway that is configured to receive a message from a source for transmission to a destination and multiple communication channels on which to transmit the message to the destination, where the communication channels include different types of communication channels. The system includes a decision engine that is operably coupled to the gateway and the communication channels. The decision engine is configured to select a first communication channel from the communication channels to route the message for transmission to the destination. The decision engine is configured to select a second communication channel from the communication channels to route the message for transmission to the destination in response to a period of time expiring without receiving an acknowledgement from the destination via the first communication channel, where the second communication channel is a different type of communication channel than the first communication channel.

Подробнее
Номер записи: 88
17-03-2015 дата публикации

Index-based evaluation of path-based queries

Номер: US8983931B2
Автор: Mohyuddin Rehmattullah
Принадлежит: Sybase Inc

Systems, methods, and computer program product embodiments are provided for path-based query evaluation. The embodiments include representing a markup language document as a descriptive catalog, and capturing relationships in the descriptive catalog as an index summary. The index summary is utilized for evaluating a path-based query.

Подробнее
Номер записи: 89
28-07-2020 дата публикации

Accelerating database queries using enhanced partition elimination

Номер: US10726008B2
Автор: Roland F. McKenney, Steven A. Kirk
Принадлежит: Sybase Inc

Increasing the efficiency of performing queries on databases by eliminating partitions during a database query. The database query configured to access a database table having one or more columns and one or more rows, the database query including a condition on a specified basis column. The database table being partitioned on the basis of the specified column, the specified column having one or more distinct values and the partitioning including mapping, by the at least one programmable processor, individual ones of the one or more distinct values to individual partitions causing each row in the table to be mapped to a specific partition. Candidate partitions and guaranteed partitions can be identified. The database query can be applied only to candidate partitions. All rows which satisfy the database query and all the rows of the guaranteed partition can be forward for processing.

Подробнее
Номер записи: 90
23-12-2010 дата публикации

Representing Markup Language Document Data in a Searchable Format in a Database System

Номер: US20100325169A1
Автор: Michelle Lim, Mohyuddin Rehmattullah, Tat-Keong Loh, Xiao Ming Zhou
Принадлежит: Sybase Inc

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.

Подробнее
Номер записи: 91
17-10-2012 дата публикации

Message based mobile object with native PIM integration

Номер: CN102742303A
Автор: 埃文·爱尔兰, 珍·刘, 约翰内斯·阿尔贝蒂, 迈克尔·弘
Принадлежит: Sybase Inc

本发明提供了用于对企业数据设备中的本地PIM数据存储中的数据进行同步的系统、方法和计算机程序产品。识别由设备上的移动应用程序或企业服务器生成的数据修改并将其反映到本地PIM数据存储中。此外，提供侦听器以检测对本地PIM数据存储中的相关数据的修改并在移动应用程序和企业服务器中反映这些修改。实现这一点的框架进一步提供了独立于平台的对本地PIM数据存储的访问。

Подробнее
Номер записи: 92
12-07-2007 дата публикации

Real-Time Messaging System for Bridging RDBMSs and Message Buses

Номер: US20070162421A1
Автор: Elena Lora-Gallardo, Francis Pang, Kannan Ananthanarayanan, Olwen Tam
Принадлежит: Sybase Inc

A SQL language interface for a messaging system, such as IBM MQ, is described. In one embodiment, for example, in a database system, a method is described for providing real-time message support for improved database connectivity, the method comprises steps of: defining Structured Query Language (SQL) extensions having commands that provide message-based connectivity for databases; receiving an SQL statement including a command specifying that a message be sent for communicating particular database data; upon execution of the SQL statement by the database system, creating an outbound message for communicating the particular database data to a destination; and posting the outbound database to a message bus, whereupon the particular database data is communicated asynchronously to the destination.

Подробнее
Номер записи: 93
08-11-2016 дата публикации

High performance index creation

Номер: US9489411B2
Автор: Leon Xiong, Ming-li Rui, Peter Schneider, Santosh PENDAP
Принадлежит: Sybase Inc

High performance index creation using parallel query plans with repartitioning scan and vector-based repartitioning scan is described. An example method includes extracting index key columns from data rows of the database table to build a set of index rows, wherein the index on the database table is defined by a plurality of index key columns including a first index key column and a second index key column. Partition boundary values are generated to divide up the index rows into range-partitioned sets, and the index rows are sorted based on values of the index key columns. A repartitioning scan, including a SARG-based or a vector-based partitioning scan is performed on the index rows, using a plurality of worker threads executing in parallel to build sub-indexes. Subsequently, each range-partitioned set of index rows are assigned to a worker thread in the plurality of worker threads. Accordingly, the sub-indexes generated from the plurality of work threads are merged to build the index for the database table.

Подробнее
Номер записи: 94
26-06-2008 дата публикации

Tcp over sms

Номер: WO2008076293A1
Автор: David L. Clegg
Принадлежит: Sybase, Inc.

A system, method, and computer program product for forming and transmitting a TCP/SMS message are presented. Steps for forming a TCP message, encoding the TCP message, and wrapping the TCP message in an SMS message are disclosed.

Подробнее
Номер записи: 95
04-02-1997 дата публикации

Object oriented dispatch and supercall process and arrangement

Номер: US5600838A
Автор: James M. Leask, Juan Guillen
Принадлежит: Sybase Inc

Method and arrangement for dispatching messages between instance specific dispatch tables of objects, when a particular object does not have resident the method called for execution in response to a message directed toward it. When a message is sent to a first object and the method called for execution is not resident or associated with the first object, the first object may expressly reference another object of the same class which may contain the required method. The message is according dispatched to another instance specific dispatch table associated with an object which may be able to execute the method called for by the message initially transmitted. Upward chaining between instance, class, and superclass level dispatch tables, and method supercalls canceling the effect of method overriding by instance level methods are included in the method and arrangement.

Подробнее
Номер записи: 96
08-11-2016 дата публикации

Rollover strategies in a N-bit dictionary compressed column store

Номер: US9489409B2
Автор: Anil Kumar Goel, Minhnea Andrei, Muhammed Sharique
Принадлежит: Sybase Inc

Disclosed herein are system, method, and computer program product embodiments for rollover strategies in an n-bit dictionary compressed column store. An embodiment operates by receiving a new value for addition to a compressed column store, determining that a current memory block of a most recently added token to the compressed column store is the insertion block. It is determined that the maximum token value has been reached for the current memory block. A new virtual memory block is created using the current insertion block, and a token corresponding to the new value is stored in the new virtual memory block. In another embodiment, when it is determined a maximum number of token values that may be stored in a compressed column store has been reached for a data dictionary, the compressed column store is converted into a composite store include a flat store where the new value is stored.

Подробнее
Номер записи: 97
28-09-2006 дата публикации

System and Methodology for Parallel Query Optimization Using Semantic-Based Partitioning

Номер: US20060218123A1
Автор: Mihnea Andrei, Sudipto Chowdhuri
Принадлежит: Sybase Inc

A system and methodology for parallel query optimization using semantic-based partitioning is described. In one embodiment, for example, in a database system comprising a database storing data in database tables, a method is described for improving query performance by dynamically partitioning the data, the method comprises steps of: receiving a query requesting data from the database; generating a plurality of subplans for executing the query, each subplan including one or more operators for performing relational operations; adding operators for partitioning data and performing a given relational operation in parallel to at least some of the plurality of subplans; and building a plan for execution of the query based, at least in part, upon selecting subplans having favorable execution costs

Подробнее
Номер записи: 98
05-03-2013 дата публикации

Adaptive locking of retained resources in a distributed database processing environment

Номер: US8392388B2
Автор: Anusha Sivananainthaperumal, Jihong Jin, Kantikiran Krishna Pasupuleti
Принадлежит: Sybase Inc

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.

Подробнее
Номер записи: 99
24-07-2001 дата публикации

Component transaction server for developing and deploying transaction- intensive business applications

Номер: US6266666B1
Автор: David W. Van Couvering, Evan Ireland
Принадлежит: Sybase Inc

A Component Transaction Server (CTS) is described, which provides a framework for deploying the middle-tier logic of distributed component-based applications. The CTS simplifies the creation and administration of Internet applications that service thousands of simultaneous clients. The CTS components, which execute on the middle-tier between end-user client applications and remote databases, provide efficient management of client sessions, security, threads, third-tier database connections, and transaction flow, without requiring specialized knowledge on the part of the component developer. The system's scalability and platform independence allows one to develop application on inexpensive uniprocessor machines, then deploy the application on an enterprise-grade multiprocessor server. In its Result Set module, the CTS provides tabular result sets, thus making the environment very desirable for business applications. In most component-based systems, a component interface returns an object. CTS components can return either an object or a collection of objects called a “result set.” The format of a result set is based on the standard ODBC result set, and it is roughly equivalent to a database cursor. Because they return a result set, CTS components are much simpler and more efficient to work with. In this fashion, graphic user interface (GUI) development with CTS is nearly identical to traditional two-tier systems.

Подробнее
Номер записи: 100