Abstract: Embodiments disclosed herein provide data management systems with an ability to integrate parent-child and peer-to-peer relationships (e.g., hierarchies) in a single interface, allowing a user to parent/unparent, link/unlink, merge/unmerge, and modify trusted attributes in a single interaction using highly accurate algorithms to provide data, including hints and recommendations for the management of these hierarchies. A user interface allows a user to perform hierarchy global management functions including read, write, business-to-business (B2B) search, navigation, and maintenance.

Abstract: A system and method for preventing user-input text strings of illegal lengths from being submitted to a database where, for each character in the string, a character length is determined in quantities of digital units of storage according to an encoding schema, the character lengths are accumulated into a total string length, also measured in digital units of storage, and the total string length is compared to one or more database input field requirements such as non-null and maximum length specifications. If a limit is not met, the system and method are suitably disposed in a manner to block or prevent submission of the user-input string to the database. Overflow sub-strings are extracted and stored from input strings which exceed the input length limit, and are further processed to yield additional storage and resource allocation.

Abstract: A method and apparatus for retention of active data stored in memory using multiple indexing systems for data storage. An embodiment of a method for retention of active data in a storage server includes reading data into a first location of a main memory of the storage server. The data in the first location indexes data elements in a long-term data storage in a first manner. The method further provides for copying the data from the first location into a second location in the main memory of the storage server, where the data in the second location indexing the data elements in the long-term data storage in a second manner.

Abstract: A system and method for managing a device profile in a communications device based on a computer application environment wherein the device profile is indicative of a computer application environment. A computer software agent inspects application program attributes of at least one running application on the user's computer. The device profile is managed responsive to said inspection. A notification system notifies a party attempting to contact the user's communication device with an indication corresponding to termination of communication. The notification system informs the user regarding details of attempted communications occurring while the at least one application was running, such as time of communications, identity and communication information of communicators, whether disabled communicator left a message, and the like.

Abstract: Systems and methods for classifying documents into categories based on text associated with the documents are disclosed. Embodiments of the present invention further provide methods for establishing a database of hierarchical classes and a system for classifying text-related content into the hierarchical classes. Text relating to documents is parsed into features with at least one feature having a plurality of terms. Vocabulary is determined from the features based on feature frequency and for each class into which a document is classified, the vocabulary that occurs in the text associated with the document is stored.

Abstract: A method for incrementally maintaining column cardinality estimates in database management systems. In one embodiment, the system includes system catalog table containing a cardinality estimate for a column that is extended to include an appropriate data structure. A modified linear counting technique is used in a first embodiment of a method for column cardinality estimation. The cardinality estimate is produced by an initial scan of the data but is then further maintained without requiring a full scan of the data. Data changes are reflected incrementally in modifications to the initial cardinality estimate, keeping the cardinality statistics more current with respect to the database condition. The technique of the invention typically provides a capability for a database management system to produce more efficient search plans providing more effective responses to user queries through the use of improved cardinality statistics.

Abstract: A system and method for preventing user-input text strings of illegal lengths from being submitted to a database where, for each character in the string, a character length is determined in quantities of digital units of storage according to an encoding schema, the character lengths are accumulated into a total string length, also measured in digital units of storage, and the total string length is compared to one or more database input field requirements such as non-null and maximum length specifications. If a limit is not met, the system and method are suitable disposed in a manner to block or prevent submission of the user-input string to the database. The invention can alternatively be realized as a plug-in for database front-end application programs, as a stand-alone web services provider, or as a plug-in for a client-side database access program such as a web browser.