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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: BOLSIUS ROGER, MALANEY KEVIN, JAKUBIAK MATTHEW
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.