Abstract: A system, method, and computer program product for processing a database query are presented. Steps for identifying a value expression comprising information needed in order to resolve a query, associating enumerated values with the set of distinct values for the value expression, evaluating the query utilizing the enumerated values, and deleting the association are disclosed.

Abstract: Network system and method for facilitating message exchange between mobile subscribers belonging to the same or different public land mobile networks, possibly incorporating different standards. Message exchange between two subscribers of the same or different networks may involve one or more lookups on subscription data, zero or more message transformations, one or more routing decisions including application of costing functions, and, storage and propagation of the message in one or more Core or Intermediary networks. The messages may be of type, among others, SMS (Short Message Service), MMS (Multimedia Message Service), or EMAIL. An aspect of the present invention provides a message routing subsystem that facilitates destination determination and delivery channel selection.

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 system, method, and computer program product are provided for interfacing a user device to a transaction system. An instruction is received from an SMS gateway in an SMS message, and is parsed to obtain a corresponding transaction. A function on the transaction system for performing the transaction is called, and a response is received from the transaction system. The response is then transmitted to the user device in a response SMS message.

Abstract: A system, method, and computer program product are provided for interfacing a user device to a transaction system. An interface is provided in order to call a function on the transaction system for performing the transaction.

Abstract: A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention.

Abstract: Systems, methods and computer program products for statement categorization and normalization are described herein. An embodiment includes a statement categorizer and a statement normalizer. The statement categorizer categorizes statements to reduce or even eliminate inconsistencies that may arise between primary and replicate databases as a result of executing certain statements. Categorized statements are normalized by the statement normalizer to generate normalized statements, which are provided to a replication server. Normalized statements assist replication server to regenerate a statement to be executed on a replicate database.

Abstract: A system, method, and computer program product are provided for abstracting data in a remote data source. A method operates by defining the data source, defining a data synchronization methodology for communication with the data source, and providing an abstraction layer for accessing data in the data source. The abstraction layer implements the data synchronization methodology when data is accessed through the abstraction layer is presented.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for logging of data manipulation language (DML) statements are described herein. An embodiment includes a database engine, a replication agent and a replication server which replicates data from the database engine to one or more replicate databases. The database engine writes parsed query information into a transaction log so that a process of replication agent may read the parsed query information and forward it to the replication server. The database engine writes all log records associated with a statement in a manner that allows the replication server to distinguish if those log records belong to same statement. In another embodiment, replication agent selectively sends SQL statement information to the replication server based on the replication server architecture.

Abstract: A system for enabling exchange of content over a communications network is disclosed having a first category of users comprising wireless carriers and a second category of users comprising content providers. A content gateway platform is provided having a database for storage of content. The content providers supply content to the database for use by the wireless carriers and the content is ultimately offered to end-user customers of the wireless carriers.

Abstract: A system, method, and computer program product are provided for developing a portable software application. The method includes the steps of defining a project, adding a screen to the project, the screen being defined as a generic screen or a platform-specific screen, adding a component to the screen, the component being defined as a generic component or a platform-specific component, redefining the screen as a platform-specific screen when it is defined as a generic screen and one or more platform-specific components have been added to the screen, and defining an application flow from the screen to one or more additional screens.

Abstract: A system, method, and computer program product are provided for compiling a stored procedure in a database. The compiling includes the steps of invoking the stored procedure, the stored procedure comprising one or more statements, substituting run-time values for one or more variables in the statements, and creating an access plan for the statements having the substituted run-time values.

Abstract: A system, method, and computer program product are provided for performing a join operation between a local table at a local server and a remote table at a remote server. In accordance with an embodiment of the present invention, a query instruction to join the local table and the remote table is received at the remote server. Qualifying rows of the local table are then retrieved to the remote server, and the remote table is joined with the qualifying rows to generate a result table, which is then sent to the local server.

Abstract: Systems and methods for assigning a 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.

Abstract: Methods, systems, and computer program products for dynamically monitoring, processing, and managing alerts are described herein. In an embodiment, the method operates by receiving messages that are either alerts or responses to existing alerts. The messages are parsed to determine if whether they are alerts or responses to alerts. Actions including updating alert states and storing alert data are executed, and then the method sends notifications regarding the alert messages and responses to a collaboration list of registered subscribers that dynamically expands over time based upon alert escalations. The method then determines whether additional messages have been received; and performs actions associated with these additional messages until there are no remaining alerts or alert responses to process. The method stores updated alert and response data in a repository so that the alerts and responses can be monitored and managed.

Abstract: System and method for providing augmented billing services. Where a billing system cannot keep pace with new services being marketed and the specialized pricing associated with such new services, a system and method are provided that generate a billing augmentation messages that are sent to the billing entity and that cause an incremental increase of a bill for the handling of a particular message type. The incremental increase is equivalent to a charge that the billing system is already configured to bill. In a preferred embodiment of the invention, the message is an electronic message such as an SMS message and the billing augmentation messages are generated by and sent from an intercarrier vendor.

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: The ubiquitous nature of wireless devices has given rise to among other things an explosive growth in messaging including, among other categories of messaging, Application-to-Peer messaging. It is inevitable that various errors (e.g., misspellings, typographic errors, transpositions, etc.) will occur as a mobile subscriber adds one or more keywords, codes, indicators, responses, etc. to an Application-to-Peer message. An error-laden message will likely be dropped, discarded, ignored, etc. when it is processed contributing to among other things a poor user experience. An infrastructure that offers possibly among other things an intelligent syntax matching capability accommodates (by, for example, automatically identifying, correcting or otherwise resolving, etc.) such errors so that messages containing such errors may be processed. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: A system, method, and computer program product for improving physical lock acquisition for database transaction logs are described herein. In an embodiment, the method operates by receiving a request for a transaction log page and determining whether a requested log page is newly-allocated or already exists. A determination is made regarding whether the last log page is being modified. A physical lock is taken on the requested log page when it has been determined that the requested log page is not newly-allocated and that the last log page is not being modified. Operations on the last log page are synchronized without a physical lock when it is determined that the requested log page is newly-allocated or that the last log page is being modified.

Abstract: Systems and methods for assigning a 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.