Method for managing a relational database of the sql type
AssigneeInfovista SA
InventorsSerge ADDA, Olivier CHEDRU
Life of this patent
Estimating the term…
Abstract
A method is provided for managing a relational database of the SQL type for information technology and network infrastructure service information, including a method in which the following are created, in a system for managing a database of the MySQL type, a read-only data storage engine, and unmodifiable tables, for example of WORM, defined as “Write Once Read Many” type managed by the storage engine; each table includes a column of digital counting data called a “timestamp”; each table is partitioned by time intervals; partition files are grouped in subdirectories of a file system, these directories forming a tree structure, each node of which is uniquely identified from a timestamp.
Claims14
A method for managing a relational database of the SQL type for information technology and network infrastructure service information, comprising a method in which the following are created, in a system for managing a relational database:
- a read-only data storage engine, and
- unmodifiable tables managed by the storage engine;
- each table comprises a column of digital counting data called a “timestamp”;
- each table is partitioned by time intervals;
- partition files are grouped in subdirectories of a file system, these directories forming a tree structure, each node of which is uniquely identified from a timestamp.
Dependencies are inferred from the claim text.