Abstract: Records stored in a database are reset on an as-accessed basis. A record in the database to receive new data is identified when new data arrives to be incorporated with existing data in a given field. A next reset date stored in the record is read and compared with the current date. If the current date is later than the next reset date, the existing data in the field is replaced with a predetermined default value prior to incorporating or incrementing the new data in the field. Additionally, another next reset date is calculated and substituted for the previous next reset date in the record.

Abstract: A system and apparatus is disclosed which stores, retrieves and analyzes relational and non-relational data. An application program provides a data query statement containing both relational and non-relational portions to a relational server. In an embodiment, the query statement is a Structured Query Language ("SQL") CONTAINS stored procedure or CONTAINS function statement. The relational data server then provides the non-relational query to either a text queue or database management language ("DML") queue. A non-relational data server then accesses either the text queue or the DML queue. The non-relational data server obtains pointers to the non-relational data and stores them in a temporary table. The pointers and relational data portion are processed by the relational server to obtain the relational and non-relational data. In an embodiment, the non-relational data server is a text server including an engine, filter, lexer, data storage and word list.