DATABASE PROCESSING METHOD AND APPARATUS FOR NETWORK TV STATISTICAL ANALYSIS SYSTEM

摘要

A database processing method and database processing apparatus for a network TV statistical analysis system are disclosed, and the database processing method includes: extracting data from a service database to obtain the data extracted this time; comparing the data extracted this time with the data extracted last time to find out the deleted information record which does not exist in the data extracted this time but exists in the data extracted last time, wherein the data extracted last time is the data when extracting resources from the service database last time; adding the deletion flag in the deleted information record, combining the deleted information record into the data extracted this time, obtaining the combined data resources, and loading the combined data resources into a statistical analysis database. This method and apparatus analyze the loaded data resources when updating the statistical analysis database, load the deleted program record whose related data fields are deleted into the statistical analysis database, and avoid the problem that the deletion of relevant information causes incorrect statistical analysis results.