Data set visualizer for tree based file systems

• US 10,423,597 B2
• Filed: 03/27/2016
• Issued: 09/24/2019
• Est. Priority Date: 03/27/2016
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bohling, III, Neal E., Perez, Roity Prieto, Witter, Helen M.
• Primary Examiner(s): Bashore, William L
• Assistant Examiner(s): Distefano, Gregory A
• Application Number:
  US15/081,899
• Publication Number:
  US 20170277416A1
• Time in Patent Office: 1,276 Days
• CPC Class Codes: G06F 16/11 File system administration, e.g. details of archiving or snapshots file system backup G06F11/14
• CPC Class Codes: G06F 16/168 Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs query results presentation G06F16/156
• CPC Class Codes: G06F 16/2246 Trees, e.g. B+trees
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials

Abstract

A method, apparatus and computer program product for performing database maintenance is described. Index information for data stored in a tree based file system running in a computer is received. The file system includes a set of data blocks arranged in logical layers and a set of pointers within the set of data blocks which reference respective data blocks in different logical layers. The received index information is parsed. A model of the file system is built based on the parsed index information. A graphical user interface having an index panel is presented. In the index panel, ones of a plurality of icons respectively represent ones of the set of data blocks and are arranged in layers representing the logical layers.

Claims

1. A method for performing database maintenance comprising:

receiving index information for data stored in a tree based file system running in a computer, the file system including a set of data blocks arranged in logical layers and a set of pointers within the set of data blocks which reference respective data blocks in different logical layers;

parsing the index information;

building a model of the file system based on the parsed index information;

displaying a graphical user interface having an index panel in which ones of a plurality of icons respectively represent ones of the set of data blocks and are arranged in layers representing the logical layers

detecting out of sequence keys in a storage block; and

highlighting an icon in the graphical user interface in response to an out of sequence keys problem.

2. The method as recited in claim 1, further comprising responsive to user selection of a first icon representing a first data block, presenting an index path between respective data blocks according to a subset of pointers.

3. The method as recited in claim 1, further comprising:

receiving data set information for the data stored in the tree based file system running in a computer;

parsing the data set information;

updating the model of the file system based on the parsed data set information;

displaying a data panel in the graphical user interface having a plurality of icons which respectively represent ones of the set of data blocks.

4. The method as recited in claim 1, further comprising:

receiving catalog information for data stored in the tree based file system running in a computer;

parsing the catalog information;

updating the model of the file system based on the parsed catalog information;

displaying an information panel in the graphical user interface presenting information on a selected data block of the set of data blocks.

5. The method as recited in claim 1, wherein the index panel is a scrollable window and the graphical user interface presents information concerning which index layers are displayed in the index panel.

6. The method as recited in claim 2, further comprising:

detecting selection of an icon representing a selected data block in the index panel;

presenting an index chain in the index panel according to pointers associated with the selected data block; and

presenting the data panel so that an icon representing the selected data block is presented in the data panel.

7. The method as recited in claim 1, further comprising responsive to user input, reorganizing the data stored in the tree based file system.

8. The method as recited in claim 6, wherein the data stored in the tree based file system is a KSDS VSAM data set, wherein each layer has a plurality of index block icons, each index block icons representing a respective control interval.

9. Apparatus, comprising:

a processor;

computer memory holding computer program instructions executed by the processor for performing database maintenance, the computer program instructions comprising;

program code, operative to receive index information for data stored in a tree based file system running in a computer, the file system including a set of data blocks arranged in logical layers and a set of pointers within the set of data blocks which reference respective data blocks in different logical layers;

program code, operative to parse the index information;

program code, operative to build a model of the file system based on the parsed index information;

program code, operative to display a graphical user interface having an index panel in which ones of a plurality of icons respectively represent ones of the set of data blocks and are arranged in layers representing the logical layers;

program code, operative to detect out of sequence keys in a storage block;

and

program code, operative to highlight an icon in the graphical user interface in response to an out of sequence keys problem.

10. The apparatus as recited in claim 9, further comprising program code operative to present an index path between respective data blocks according to a subset of pointers and a selection of a first data block.

11. The apparatus as recited in claim 9, further comprising:

program code, operative to display a data panel in the graphical user interface having a plurality of icons which respectively represent ones of the set of data blocks, wherein the data panel is selectively displayed in a physical mode or a logical mode, wherein in the physical mode the plurality of icons are organized according to respective physical volumes in which the data blocks are stored and in the logical mode the plurality of icons are organized according to a pointer order of a set of pointers referring to the data blocks.

12. The apparatus as recited in claim 9, further comprising:

program code, operative to present a statistics panel including a size of a data block, a number of index levels and a percentage of storage used.

13. The apparatus as recited in claim 11, further comprising:

program code operative to detect selection of an icon representing a selected data block in the panel;

presenting the index panel so that an icon representing the selected data block is presented in the index panel; and

presenting an index chain in the index panel according to pointers associated with the selected data block.

14. The apparatus as recited in claim 11, wherein the index panel and the data panel are zoomable.

15. A computer program product in a non-transitory computer readable medium for use in a data processing system, the computer program product holding computer program instructions executed by the data processing system for performing database maintenance, the computer program instructions comprising:

program code, operative to program code, operative to receive index information for data stored in a tree based file system running in a computer, the file system including a set of data blocks arranged in logical layers and a set of pointers within the set of data blocks which reference respective data blocks in different logical layers;

program code, operative to parse the index information;

program code, operative to build a model of the file system based on the parsed index information;

program code, operative to display a graphical user interface having an index panel in which ones of a plurality of icons respectively represent ones of the set of data blocks and are arranged in layers representing the logical layers

program code, operative to detect out of sequence keys in a storage block; and

program code, operative to highlight an icon in the graphical user interface in response to an out of sequence keys problem.

16. The computer program product as recited in claim 15, further comprising program code operative to present an index path between respective data blocks according to a subset of pointers and a selection of a first data block.

17. The computer program product as recited in claim 15, further comprising:

program code, operative to display a data panel in the graphical user interface having a plurality of icons which respectively represent ones of the set of data blocks, wherein the data panel is selectively displayed in a physical mode or a logical mode, wherein in the physical mode the plurality of icons are organized according to respective physical volumes in which the data blocks are stored, and wherein in the logical mode the plurality of icons are organized according to a pointer order of a set of pointers referring to the data blocks.

18. The computer program product as recited in claim 15, further comprising:

program code operative to detect selection of an icon representing a selected data block in the panel;

presenting the index panel so that an icon representing the selected data block is presented in the index panel; and

presenting an index chain in the index panel according to pointers associated with the selected data block.

19. The computer program product as recited in claim 15, wherein a broken index chain is presented the index panel showing a break between layers of the plurality of icons.