Abstract: A unique application within Video that allows for user generated Meta-tagging to be delivered in real time to individual clips is provided. This meta-tag creates its own tail based upon the user generated words population, which is searchable via a “spider network” that runs invisible behind the web pages of the site. These same “tagged” words are broadcast over various delivery networks including but not limited to live feeds from SMS, MMS, News Feeds within Community Web Sites, Video Sharing Web Sites, Widget applications any other forms of electronic communication that will be dropped in real time to identified users and friends of users.

Abstract: Methods and systems for using algorithms in relational database management systems (RDBMSs) for incremental maintenance of materialized views with outerjoins are disclosed. The algorithms achieve the following goals with respect to a class of materialized outerjoin views and the performance of update operations: relax the requirement for the existence of the primary key attributes in a select list of the view to only some of the relations (i.e., the relations referenced as a preserved side in an outerjoin); relax null-intolerant property requirements for some predicates used in the view definition (i.e., predicates referencing relations which can be null-supplied by more than one outerjoin); and implement maintenance of outerjoin views by using one update statement (e.g., MERGE, UPDATE, INSERT, or DELETE) per view for each relation referenced in the view. The algorithms allow design and implementation of the incremental maintenance of materialized views with outerjoins to be integrated into an RDBMS.

Abstract: A data stream management system (DSMS) is designed to support a new user-defined function, by creating and using at least two structures as follows. A first structure (“metadata entry”) is created in response to a command for creation of the new function, and maps a single instance of a class to the function's name. A second structure is created with creation of an operator on receipt of each new continuous query that uses the new function. The second structure (“operator specific data structure”) contains a path to the newly-created instance, which path is obtained by looking up the first structure. Additional second structures are created on receipt of additional continuous queries which use the new function, but all second structures contain the same path. All continuous queries use the same instance. Repeated use of a single instance to compile and execute multiple queries eliminates repeated instantiation of the same function.

Abstract: Data is recursively migrated during uptime from a first table to a second table in a first schema in a database while taking into account changes to the first table in a change table. The database has first and second application servers respectively connecting to the database using first and second schemas and running first and second versions of a software program. Downtime can be initiated to migrate the remaining entries in the change table to the second table, delete the first table, and rename the second table to have a same name as the first table prior to deletion so that during uptime the second application server connects to the second table and runs the second version of the software program. Related apparatus, systems, techniques and articles are also described.

Abstract: A method, computer program product, and system for collecting and processing feedback information in organizational communications. The system includes an information processing apparatus, a communications mechanism, a database, and a mechanism for collecting data. The communications mechanism operates with the information processing apparatus for providing communications to a user of the information processing apparatus. The database operates in conjunction with the information processing apparatus and the communications mechanism. The database stores data. The mechanism for collecting the data operates in response to the communications related to the user by the communications mechanism.

Abstract: Systems and methods for providing notifications of changes made in a database table to a remote application is presented. The system and methods manage change notification of a table in a database by notifying an application registered to receive notifications of changes made to a database table. A database manager executing on a device may receive a request to register an application to be notified when a first table of a plurality of tables in a database is changed. The database manager may establish a notification table comprising fields of the first table and one or more additional fields for managing notification. The database manager may establish a trigger on the first table to invoke a trigger procedure to copy a changed row of the first table to the notification table.

Abstract: Discrepancies in two sets of asset data for an organization are identified and automatically reconciled. One set of asset data may be compiled using automatic physical discovery software while the other set is from a financial system of the organization. Automatic reconciliation is performed according to user-configurable rules and corresponding user-configurable actions.

Abstract: Systems, methods, and other embodiments associated with event recording are described. One example method includes locally locking a record in an event data store corresponding to an event having a same event type as a given event when a prior occurrence of the given event has not yet been recorded. The event data store is updated to record the given event while the record is locked. One example system includes an event data store configured to store records corresponding to events, an event recorder configured to record event data in the event data store and a local lock actuable by the event recorder. The event recorder is configured to update the locked record to correspond to a received event.

Abstract: File mapping and converting for dynamic disk personalization for multiple platforms are provided. A volatile file operation is detected in a first platform. The file supported by the first platform. A determination is made that the file is sharable with a second platform. The volatile operation is performed on the file in the first platform and the modified file is converted to a second file supported by the second platform. The modified file and second file are stored in a personalized disk for a user. The personalized disk is used to modify base images for VMs of the user when the user accesses the first platform or second platform. The modified file is available within the first platform and the second file is available within the second platform.

Abstract: Techniques for implementing secure normal forms are provided. In one embodiment, in response to a request for data from a client, a database server is operable to enforce a column-level security policy that is defined for a particular column of some, but not necessarily all, rows of a table stored in a database. After retrieving a set of rows from the table and before returning a result set of rows to the client, the database server modifies the retrieved set of rows into the result set of rows by applying the security policy to each row of the retrieved set of rows, where applying the security policy to a row comprises: determining whether the security policy is satisfied for the particular column of that row; replacing, in the result set of rows, a data value in the particular column of that row with a security-NULL value when the security policy is not satisfied; and including the data value in the particular column of that row into the result set of rows when the security policy is satisfied.

Abstract: A data stream management system (DSMS) is designed to support a new user-defined function, by creating and using at least two structures as follows. A first structure (“metadata entry”) is created in response to a command for creation of the new function, and maps a single instance of a class to the function's name. A second structure is created with creation of an operator on receipt of each new continuous query that uses the new function. The second structure (“operator specific data structure”) contains a path to the newly-created instance, which path is obtained by looking up the first structure. Additional second structures are created on receipt of additional continuous queries which use the new function, but all second structures contain the same path. All continuous queries use the same instance. Repeated use of a single instance to compile and execute multiple queries eliminates repeated instantiation of the same function.

Abstract: Techniques are disclosed for protecting a computer environment. The technique comprises providing an index; comparing a first event with the index; determining whether the first event is unusual; and determining whether a security incident associated with the first event has occurred.

Abstract: A method and apparatus for efficient and consistent validation/conflict detection in a Software Transactional Memory (STM) system is herein described. A version check barrier is inserted after a load to compare versions of loaded values before and after the load. In addition, a global timestamp (GTS) is utilized to track a latest committed transaction. Each transaction is associated with a local timestamp (LTS) initialized to the GTS value at the start of a transaction. As a transaction commits it updates the GTS to a new value and sets versions of modified locations to the new value. Pending transactions compare versions determined in read barriers to their LTS. If the version is greater than their LTS indicating another transaction has committed after the pending transaction started and initialized the LTS, then the pending transaction validates its read set to maintain efficient and consistent transactional execution.

Abstract: A unique application within Video that allows for user generated Meta-tagging to be delivered in real time to individual clips is provided. This meta-tag creates its own tail based upon the user generated words population, which is searchable via a “spider network” that runs invisible behind the web pages of the site. These same “tagged” words are broadcast over various delivery networks including but not limited to live feeds from SMS, MMS, News Feeds within Community Web Sites, Video Sharing Web Sites, Widget applications any other forms of electronic communication that will be dropped in real time to identified users and friends of users.

Abstract: Techniques are described to allow a query to be registered as a persistent stored entity within the database, and to generate notifications as and when the query result changes continuously as long as the query continues to be registered with the database. According to one aspect, for a table referenced in a query, a filter condition is generated based, at least in part, on a predicate of the query. Then, the database server determines whether the filter condition is satisfied by either a before image of a row, or an after image of the row, that was modified by a transaction. If the filter condition is satisfied by either the before image or the after image, then the query is added to a first set of queries whose result sets may have been affected by the transaction. From among the first set of queries, a second set of queries that have result sets that were actually affected by the transaction is determined. Notifications are then sent based on the second set of queries.

Abstract: Programmers typically like operating with databases through use of classes. Classes allow a user to function with a database through use of a non-database programming language. To ease use of the classes, a class context is generated at runtime that does not force a programmer to handle various source files that are a product of class generation. Therefore, the user can have the ease of using classes without having to perform extra actions.

Abstract: A mechanism is disclosed for enabling new task types to be added to a management server without changing the source code of the management server. To add a new task type, a descriptor file is provided. This descriptor file specifies all of the particulars of the new task type. Any mechanisms referred to in the descriptor file are also provided. At startup time, the management server processes the descriptor file and forms associations between the various aspects of the task type with the mechanisms that are responsible for implementing those various aspects. At runtime, these associations are used to manage the definition and execution of tasks of that task type. By doing so, the management server enables new task types to be added, and enables task instances of the new task types to be defined and executed, without changing the source code of the management server.

Abstract: The present invention discloses a method for characteristic string matching based on discreteness, cross and non-completeness, comprising the steps of: A. a user setting discrete number, cross number and non-complete number in the user interface, or an information processing device automatically setting the discrete number, cross number and non-complete number, and inputting the retrieval keywords; B. the information processing device performing the characteristic string matching based on the three characters, with the discrete number, cross number and non-complete number set in step A as matching constraints, for a designated text according to the keywords input by user, and output the matching result of one of the eight retrieval modes, including precise retrieval, discrete retrieval, cross retrieval and cross and discrete retrieval, non-complete retrieval, discrete and non-complete retrieval, cross and non-complete retrieval, discrete and non-complete retrieval.

Abstract: The Best Practices Analyzer scans one or more instances of the database server for conformance to a set of guidelines and recommendations (“best practices” or “best practice rules”). Best practice rules may be defined by the user and/or may be provided. The Best Practices Analyzer performs analysis of usage of database programming (query) language and conformance to guidelines. Best Practices Analyzer may check for correct execution of common administrative tasks. Rules may be implemented as procedural code in any language.

Abstract: A method and system for optimizing data storage in a storage device. A trigger corresponding to predefined events is received, initiating the optimization of file storage in a storage device. The files are sorted into a list of candidate files according to metadata corresponding to each of the files. A subset of the sorted list of files is selected for compression, based on the position of the candidate files in the sorted list of candidate files. The files comprising the subset of sorted files is compressed by reducing the files in size. The metadata corresponding to the compressed files is updated to reflect the event of the compression.

Abstract: Methods are described for utilizing user-submitted data to provide a response to a query request. User-submitted data are received and referenced upon receiving a query request from an unregistered requester, a potential response is automatically identified from the user-submitted data, the potential response is extracted, and presented in response to the query request.

Abstract: A computer-implemented method for delivering content is provided, including specifying a rule having a trigger and defining a content presentation action, and receiving a search query from a user. The method further includes generating a result set in response to the search query, identifying at least one characteristic of the result set, and comparing the at least one characteristic to the trigger. If the at least one characteristic satisfies the trigger, the content is presented as specified by the content presentation action that is defined by the rule. Other embodiments are also described.

Abstract: An automated correspondence response system is provide for permitting a receiving entity to generate customized responses based on data extracted from received communications. The system also provides for automated management and manipulation of data extracted from correspondence received by a receiving entity for group profiling and to perform various statistical analysis thereof. The system analyzes content of received correspondence, such as celebrity fan mail, and manages the automation of responses via targeted or “customized” letters, wherein the receiving entity creates content specific fields or terms in order to respond to correspondence in an automated and yet relevant manner. The receiving entity can electronically define what data is extracted from the correspondence.

Abstract: Control statements related to inputting, sorting, filtering, formatting, and outputting data records in a data processing system are scanned to find one or more formatting options related to character translation. Files comprising a plurality of data records are input, processed, and output as directed by the control statements. As specified by the formatting options, character translation operations are conducted on selected characters. The character translation operations are conducted in conjunction with inputting and outputting the data records. In one embodiment, the supported character translation operations include lowercase to uppercase conversion, uppercase to lowercase conversion, EBCDIC-to-ASCII conversion, ASCII-to-EBCDIC conversion, and user-definable character translation. The present invention increases the utility of a data processing system while minimizing the programming burden associated with translating selected characters while processing data records.

Abstract: A method, system, and computer program product provides improved performance for rebuild of user-defined indexes during partition maintenance operations (partition split, merge, and move). A method of maintaining a index of a partitioned database table comprises performing a partition maintenance operation on the partitioned database table wherein a plurality of rows of the partitioned database table are moved from one partition to another, storing mapping information for at least some of the plurality of moved rows, including an old mapping for each of the moved rows and a corresponding new mapping for each of the moved rows, and when rebuilding the index, replacing an old mapping in the index for each of the plurality of moved rows with the corresponding stored new mapping for each of the plurality of moved rows.

Abstract: An indexing system, including a server for providing access to at least one site, a server agent for creating an index file of data relating to the site, and a central index for storing index information from the index file. The server agent initiates communication with the central index to transfer the index file from the server agent to the central index.

Abstract: A system for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The system eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

Abstract: Methods for providing a generic database security application using virtual private database (VPD) functionality are provided. The methods may include inserting rows into a user security table in a database providing VPD functionality, each row comprising a user ID for which database access is to be controlled, the name of a database object to be secured, and a predicate; and defining a security policy function common to all secured database objects, said security policy function generating a second predicate to be appended by the database's VPD functionality to queries made on a queried secured database object by a querying user, said second predicate based on at least one predicate in at least one row in the user security table, the at least one row referencing the name of the queried secured database object and the user ID of the querying user. Related systems and computer program products are also provided.

Abstract: An observation system includes mechanisms for efficiently tracking the state of source components, which include functions, arguments, or values, etc. In one implementation, an observing component requests that a source component processes a request. The observation system then identifies all possible components in a dependency chain for the request, and all such components that are configured for change notifications. A dependency registry stores a representation of each identified component that is configured for change notifications. Any time any component configured for change notifications changes, including indirectly related components, the observing component can be immediately notified of the change, without having to reprocess the entire set of component dependencies.

Abstract: An application persistence system for improving wireless application resource efficiency is provided. The application persistence system comprises a persistence-point definition module for defining conditions that trigger persisting application data, a persistence-point analysis module for identifying efficient and reliable persistence points and a persistence points enforcement module for enforcing persistence points at application runtime. A method of improving wireless application resource efficiency is also provided. The method comprises the steps of defining conditions that trigger persisting application data, identifying efficient and reliable persistence points, defining a persistence mode flag in an application's profile, and enforcing persistence points at application runtime.

Abstract: A method, system, and computer program product for dynamic field-level access control in shared documents. The method comprises: providing a field in a shared document, wherein the field is not owned by a user and can be edited by any user; and assigning sole ownership of the field to a user who first edits the field, wherein the owner of the field controls access to the field using at least one access control list.

Abstract: A condensed version of a plurality of rules for one or more forms being used by a user is loaded from a database. The condensed version of the plurality of rules is stored in cache memory of a computing device. When an event occurs, a rules engine determines if a condensed version of the rule is stored in cache memory. If a rule is not applicable, the rules engine does not query the database. If a rule is applicable, the rules engine determines if an action should be taken for the event. If no action is to be taken, the database is not queried for the rule. If an action is to be taken, the database may be queried for information for the rule to allow performing of the action or if the action is included in the condensed version, the action is performed without querying the database.

Abstract: A method for processing a first data stream specifying locations of a user at different times and a second data stream specifying values of a monitored attribute at a location of interest at different times includes: receiving a location-centric trigger specifying at least one spatial predicate condition relative to the location of interest and at least one non-spatial predicate condition relevant to the location of interest, calculating a safe region that includes locations whose probability of satisfying the spatial predicate condition falls below a first threshold, calculating a safe value container that includes values whose probability of satisfying the non-spatial predicate condition falls below a second threshold, and processing the first data stream and the second data stream against the location-centric trigger, by considering only those locations that are not contained within the safe region and only those values that are not contained within the safe value container.

Abstract: Making data available from a database is disclosed. Making data available includes specifying a query function having a query function name, wherein the query function includes a structure and a member, determining the structure and the member included in the query function, wherein the query function has a query function name and includes the structure and the member, creating an index for the structure on the member, and compiling the query function to be available to a user by invoking the query function name without the user having to specify the structure and the member. Retrieving data from a database is disclosed. Retrieving includes invoking a query function that specifies a plurality of structures and a value, accessing a cross index of the plurality of structures, and using the cross index to access the data.

Abstract: A cluster manager is configured to manage a plurality of copies of a mid-tier database as a mid-tier database cluster. The cluster manager may concurrently manage a backend database system. The cluster manager is configured to monitor for and react to failures of mid-tier database nodes. The cluster manager may react to a mid-tier database failure by, for example, assigning a new active node, creating a new standby node, creating new copies of the mid-tier databases, implementing new replication or backup schemes, reassigning the node's virtual address to another node, or relocating applications that were directly linked to the mid-tier database to another host. Each node or an associated agent may configure the cluster manager to behave in this fashion during initialization, based on common cluster configuration information. Each copy of the mid-tier database may be, for example, a memory resident database. Thus, a node must reload the entire database into memory to recover a copy of the database.

Abstract: An automatic task generation mechanism provides generation of tasks such as maintenance tasks for a computer system. A set of tasks is set up along with rules for performing the tasks. The rules may be associated with metadata that allow the tasks to be mapped to the tasks. Events may be detected that are related to database operations such as a create, modify, delete or add command. Upon event detection by the system, the system may store the event and associated metadata. Another process may query the event and metadata storage and compare those items to the rules previously set up. If there is a match between the rules and the event, one or more tasks may be established which correspond to an action that is desired to be taken. The task may then be inserted into a computer system for subsequent execution.

Abstract: A computer-implemented update-triggered document-defined workflow method provides for triggering an update to an original source document to yield an updated document. In response, a document handler executes the document-defined workflow method so as to create, delete, or modify a target document or so as to create a workflow description calling for creating, deleting, or modifying a target document.

Abstract: A method and system for providing package resolution in a database system is disclosed. The method and system comprise providing a statement within a server which allows an application to identify a list of package collections. The method and system further includes executing the statement to obtain the appropriate package. A system and method in accordance with the present invention provides a new current package path value, which is set via a statement referred to as Set Current Package Path. The SET CURRENT PACKAGE PATH statement allows the application to supply a precedence list of qualified package collections during execution time, therefore the scheme for resolving packages can be changed at any point during execution. The SET CURRENT PACKAGE PATH statement improves application development by making the package resolution mechanism less error prone and less tedious for the application developer, while providing an optimal-performance solution in the client-server environment.

Abstract: An observation system includes mechanisms for efficiently tracking the state of source components, which include functions, arguments, or values, etc. In one implementation, an observing component requests that a source component processes a request. The observation system then identifies all possible components in a dependency chain for the request, and all such components that are configured for change notifications. A dependency registry stores a representation of each identified component that is configured for change notifications. Any time any component configured for change notifications changes, including indirectly related components, the observing component can be immediately notified of the change, without having to reprocess the entire set of component dependencies.

Abstract: A method and a system for controlling media playing and a metadata execution unit are provided. The metadata execution unit obtains metadata provided by a metadata providing unit, and executes corresponding metadata according to trigger information for executing metadata. The metadata execution unit generates media content control indication information according to an execution result, and sends the media content control indication information. A media content control unit then controls media content playing correspondingly according to the media content control indication information. By using the method and apparatus, metadata is distributed to a suitable network entity to be executed for controlling media playing. In this way, decentralized execution of a policy is achieved. Therefore, processing efficiency is improved.

Abstract: A deterministic UDF processing mechanism processes user-defined functions (UDFs) using multiple hash tables. Data access patterns for a UDF are collected, and an appropriate hash table set is then determined for the UDF from the data access patterns. If a UDF accesses some similar columns and some disjoint columns, the similar columns are grouped together, and one or more hash tables are allocated to the similar columns. Disjoint columns are allocated their own hash tables. In addition, the allocation of hash tables may be adjusted based on historical access patterns collected over time. By dynamically allocating and adjusting sets of hash tables to a deterministic UDF, the performance of the UDF is greatly increased.

Abstract: An architecture for the initial development and later adaptation of information systems comprising a database, one or more clients and any number of supporting libraries whose system data, application data and rule data are stored in the database alongside the content data so that the correctness of the system can be conclusively verified without having to test every combination of behaviour at run-time. A framework in the database stores system, application and rule data and frameworks in the clients load the system, application and rule data to generate objects and, in doing so, define an domain-specific system. The integrity of system and application data is maintained by the database though predefined triggers and the integrity of content data is maintained by the database through triggers loading rule data and executing the rule definitions calling functions in dynamically linked libraries.

Abstract: An XML Extractor that extracts XML data from streamed input based on registered XPaths is provided. XPaths and associated content handlers instances are registered at runtime with the XML Extractor. The XML Extractor receives streaming input that represents XML data at a stream-based parser, and evaluates the received input against the registered XPaths expression. In response to detecting that the received streaming input includes an XPath that matches a registered XPath expression, the XML Extractor generates output to the content handler associated with the matching registered XPath expression.

Abstract: For a data processing system having memory for storing a database, a method, a system and a computer program product for directing the data processing system to process a record to be inserted into the database is disclosed. The database includes a plurality of base tables.

Abstract: An assigning unit included in a device assigns an ID to a verification-target character string. A mapping file creating unit creates a mapping file in which the ID is associated with location data that indicates a location of the verification-target character string. In addition, an encoding unit included in the device encodes the ID into a zero-width character string. A character-string concatenating unit concatenates the zero-width character string to the verification-target character string. Furthermore, a decoding unit included in the device decodes the zero-width character string to the ID in response to selection of the verification-target character string displayed by a verification-target character string output unit. An extracting unit extracts the location data from the mapping file on the basis of the decoded ID. A mapping data output unit included in the device displays the mapping data including the extracted location data.

Abstract: The present system, software, and methods relate to computer system security, particularly to tracking and controlling electronic access to legacy applications and data records without modifying the legacy applications or records. The present system, software, and methods allow for implementation of complex access audit and control rules even when the continued use of legacy application and data are required.

Abstract: The present invention presents a method, system and computer-implementable medium for remapping child references when parent reference updates are processed.

Abstract: The present invention relates to systems and methods for employing a trigger based mechanism to detect changes in a database table, providing a notification when the database table changes and registering to receive the notification. The systems and methods employ a listeners table to store information associated with registered database tables. Alter a database table changes, a trigger mechanism associated with the database change facilitates a search of the listeners table for a parameter associated with the changed database table. If the changed database table is registered, the information from the listeners table is provided to a delivery service which transmits a message indicating the registered database table changed. After receiving the message, a notification runtime service can route a notification to a client(s) registered to receive the notification. The foregoing mitigates performing time intensive queries and utilizing inconsistent query results.

Abstract: The present invention generally relates to data processing, and more specifically to executing a query against a partitioned database. One embodiment provides a computer-implemented method of managing execution of a query against a partitioned database having a plurality of data partitions. The method comprises issuing a query for execution against each of the plurality of data partitions. Then, it is determined whether a complete query result is returned for the query before execution of the query has completed against each of the plurality of data partitions. If so, execution of the query is terminated on at least one of the plurality of data partitions.

Abstract: A method for encapsulation of extensibility records for backup and restore comprises determining whether a storage object to be backed up, such as a file or a directory of a primary data set, has an extensibility record associated with it. In response to determining that the storage object has an associated extensibility record, the method may include storing an encoding of at least a portion of the extensibility record, and generating a backup version of the storage object.