| 摘要 |
<p>#CMT# #/CMT# The method involves creating a read-only data storage engine in a relational database managing system. Unmodifiable tables e.g. Write Once Read Many type tables, managed by the storage engine are created, where each table includes a column of digital counting data i.e. timestamp. Each table is partitioned by time intervals, and the partition files are grouped in subdirectories of a file system, where the directories form a tree structure and each node of the trees structure is uniquely identified from a timestamp. The timestamp is used for joining the partitions into a new partition. #CMT#USE : #/CMT# Method for managing a relational SQL database for computer infrastructure such as server and application, service information and network infrastructure service information, in a MySQL 5.1 database managing system. #CMT#ADVANTAGE : #/CMT# The method enables massive-partitioning the tables contained in the database to efficiently manage the data and to eliminate a single call system of data corresponding to a time period. The method enables the partitions to be built in memory and written into memory on a disk so as to provide reports in real time. The method avoids maintenance and reconstruction of indexes for indexed data. The read-only data storage engine permits insertion of data and avoids updation of data already present in data management system, thus avoiding functionalities such as transactions and updations, which slow down the system due to consumption of computing time, thus avoiding consumption of unnecessary resources. #CMT#DESCRIPTION OF DRAWINGS : #/CMT# The drawing shows a schematic representation of tree of partitions of a table.'(Drawing includes non-English language text)'.</p> |
