Methods and systems for auto-partitioning of schema objects

摘要

A method of partitioning a schema object containing Web server log file data that includes a plurality of dated entries. Existing partitions within the schema object are identified, as well as the date associated with each existing partition. Unique dates of the entries within the log file data are also identified. A separate partition within the schema object is then automatically created for a) each identified unique date of the entries within the log file data that is not associated with an identified existing partition, and for b) each date immediately preceding each date in a) unless the partition has previously been created. This method avoids splitting loaded partitions when the Web server log file data is loaded out of turn.