Abstract: A system and method for facilitating electronic communication between people who speak different languages. An SMS message including content in a first language is received at a network node. It is then determined whether the content in a first language is received at a network node. It is then determined whether the content of the SMS message is to be translated to a second language before being sent to a recipient. This determination can be based on an embedded code or on the fact that a bounded session has been previously established. The content is then translated from the first language to the second language, and the SMS message is thereafter sent to the recipient directly from the network node at which the translating step was performed.

Abstract: A service that leverages established wireless messaging paradigms such as, possibly inter alia, Short Message Service, Multimedia Message Service, and IP Multimedia Subsystem to yield an infrastructure that synergistically provides, possibly inter alia, (1) a full-featured alternative (e.g., non-voice telephone call) emergency notification, reporting, etc. channel that (2) works across (i.e., provides ubiquitous access to) the full universe of Wireless Devices that are carried by Mobile Subscribers. The service may optionally leverage the capabilities of a Value-Added Service Provider.

Abstract: System and method for assignment of unique identifiers in a distributed environment. In a distributed system having a plurality of nodes, a method for allocating identifiers comprises steps of: allocating a pool of identifiers for use; maintaining lists of free identifiers in the pool at participating nodes; obtaining at a first node permission to update the lists of free identifiers; upon receiving permission to update the lists, allocating for the first node a set of identifiers from the lists; updating the lists of free identifiers to reflect allocation of the set of identifiers for the first node; sending the updated lists from the first node to other participating nodes; upon receiving the updated lists of free identifiers at each other participating node, updating each other participating node's respective copy of the lists of free identifiers; and relinquishing the first node's permission to update the lists of free identifiers.

Abstract: A system and methodology for database migration between platforms is described. In one embodiment, for example, a method is described for migrating a database across platforms having different byte order formats (e.g., big-endian and little-endian), the method comprises steps of: when the database is loaded on a given platform, determining whether the database requires conversion to match the byte order format of the given platform; identifying particular portions of the database to be converted if the database is determined to require conversion; and converting the particular portions of the database to the byte order format of the given platform.

Abstract: An Operator Charging Gateway (OCG) facility within a Mobile Commerce environment that, among other things, provides a bearer-independent and delivery-agnostic charging platform that, inter alia, (a) uncouples all of the particulars of the delivery of content, services, etc. from the myriad of activities, challenges, etc. of charging and (b) adds substantial value to each of the involved parties (including, for example, Mobile Subscribers, Operators, Merchants, etc.). Within a wireless messaging ecosystem an OCG may leverage the capabilities of a centrally-located, full-featured Value-Added Service Provider.

Abstract: A service that leverages established wireless messaging paradigms such as, possibly inter alia, Short Message Service and Multimedia Message Service to allow Mobile Subscribers to use their Wireless Devices to fully interoperate with Community Alarm, and other similarly-situated, facilities. The service may optionally leverage the capabilities of a Messaging Inter-Carrier Vendor.

Abstract: A system and method for facilitating electronic communication between people who speak different languages. An SMS message including content in a first language is received at a network node. It is then determined whether the content of the SMS message is to be translated to a second language before being sent to a recipient. This determination can be based on an embedded code or an the fact that a bounded session has been previously established. The content is then translated from the first language to the second language, and the SMS message is thereafter sent to the recipient directly from the network node at which the translating step was performed.

Abstract: A secured database system with built-in antivirus protection is described. In one embodiment, for example, a method of the present invention is described for securing a database system, the method comprises steps of: provisioning storage from a storage device, for storing database information; generating an encryption key so that the database information is stored on the storage device in an encrypted manner; generating a decryption key for decrypting the database information stored on the storage device, wherein access to the decryption key is controlled by the database system based on user privileges; receiving a request from a user for access to the database information; determining whether the user has been granted sufficient privileges to access the database information; if the user has been granted sufficient privileges, automatically decrypting the database information to provide the access; and otherwise denying the request if the user has not been granted sufficient privileges.

Abstract: 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.

Abstract: A system and methodology for extraction and aggregation of data from dynamic content is described. In one embodiment, for example, a method is described for extracting and structuring items of data from content available via the Internet, the method comprises steps of: receiving input of a user specifying at least one source of content available via the Internet, types of data to be extracted from the at least one source, and fields for structuring extracted items of data; retrieving content from the at least one source; parsing the retrieved content to extract items of data of the types specified by the user; and mapping the extracted items of data to the fields specified by the user so as to transform the extracted items of data into a structured format.

Abstract: Systems and methods for exchanging a short message service (SMS) message between networks operating in accordance with different standards. An intermediary system operates between a first network operating in accordance with a first standard and a second network operating in accordance with a second standard. A routing information request for an SMS message is received, at the intermediary, from the first network and the intermediary sends, in response to the routing information request, an acknowledgement message to the first network. The SMS message is thereafter received at the intermediary and an acknowledgement of receipt of the SMS message is generated in the intermediary and then sent to the first network. The SMS message is then sent from the intermediary to the second network. In a preferred embodiment, the intermediary is an entity distinct from the first and second networks, but operates as a virtual MSC from the perspective of the first and second networks.

Abstract: A system and methodology for generating bushy trees using a left-deep tree join enumeration strategy for optimizing execution of a database query is described. In response to receipt of a query specifying at least one join condition between two or more database tables, each query block comprising an atomic portion of the query is identified and subplans are created for each query block based on grouping portions of each query block. At least one favorable access plan is determined for each subplan of each query block based, at least in part, on estimated execution costs. An optimal access plan for each query block is generated based upon at least one favorable access plan determined for each subplan. A query execution plan is then constructed based upon the optimal access plan generated for each query block.

Abstract: A development system with methodology providing optimized message parsing and handling is described. In one embodiment, for example, a computer-implemented method is described for improved processing of certain types of messages, the method comprises steps of: loading metadata at design time, the metadata characterizing a particular message type; based on the metadata, automatically generating source code for creating runtime components highly optimized for the particular message type; compiling the source code into the runtime components, for deployment in a runtime environment; and at runtime, processing messages of the particular message type with the runtime components, so that messages are processed in a manner that is highly optimized for the particular message type.

Abstract: System and methods for providing multimedia message service (MMS) interoperability between an initiating carrier and a destination carrier. A transcoding facility receives an MMS message from an initiating carrier and accesses a number portability database to determine an identity of a destination carrier to which the MMS message is intended to be sent and a carrier profile repository to obtain a carrier profile for the destination carrier, the carrier profile including information regarding an MMS format acceptable to the destination carrier.

Abstract: A method for cloning of prepared statements for execution against a database is described. In one embodiment, for example, a method for executing a database statement comprises steps of: preparing at least one template for execution of a statement against a database; storing the at least one template in a shared cache available to a plurality of database connections; in response to a request to execute a particular statement on a given database connection, determining whether a template for the particular statement is available in the shared cache; if the template is available in the shared cache, creating a database statement based on the template for execution on the given database connection; and executing the database statement on the given database connection.

Abstract: A hierarchical entitlement system, method, and computer program product with integrated inheritance and limit checks are described.

Abstract: 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.

Abstract: A system and methodology for parallel query optimization using semantic-based partitioning is described.

Abstract: A system and methodology for database migration between platforms is described. In one embodiment, for example, a method is described for migrating a database across platforms having different byte order formats (e.g., big-endian and little-endian), the method comprises steps of: when the database is loaded on a given platform, determining whether the database requires conversion to match the byte order format of the given platform; identifying particular portions of the database to be converted if the database is determined to require conversion; and converting the particular portions of the database to the byte order format of the given platform.

Abstract: A database system with methodology for generating bushy nested loop join trees is described. In one embodiment, for example, an improved method is described for optimization of a query requesting data from a database, the method comprises steps of: generating a left deep operator tree for returning data requested by the query based on traversing a left deep operator tree search space; transforming the left deep operator tree into a semantically correct structure for returning data requested by the query; and building a query execution plan for returning data requested by the query based on the semantically correct structure.