# Patent

## Title
Visual structuring of multivariable data

## Abstract

Visual structuring of multivariable data sets provided in records which include fields, and are displayed in tabular form. A method comprising: defining a key field; sorting records by defined key field; finding equivalent field values in fields in records arranged adjacent to each other; defining a block for fields having equivalent field values; displaying one field value of fields of a block having equivalent field values and masking all other fields within the block having equivalent field values like the one field value. Facilitating monitoring or analysis of large multivariable data sets provided in records and displayed in tabular form it is proposed to define blocks of fields having equivalent field values and display only one field value of a block. The visual output is useful to identify patterns indicative of an attack. A service provider monitors records provided by a customer and notifies the customer of the attack.

## Background
TECHNICAL FIELD
The invention relates to visual structuring of multivariable data sets being provided in records. One of the records includes a plurality of fields, the records are displayed in tabular form on a display device. It further relates to displaying multivariable data.
BACKGROUND OF THE INVENTION
Nowadays the amount of data to be processed increases very rapidly. This increasing amount of data could be found in almost every business field, especially in the area of computer network security. However other business fields use data bases managing large amount of data also.
The invention could be applied in the field of interactive support systems for security event monitoring and in particular systems supporting centralized monitoring of security events and alarms generated by a multiplicity of sensors such as intrusion detection systems. However further application areas are the analysis of data in online analytical processing of marketing data.
Most often tabular displays of records are used for analyzing multivariable data sets. Each row in the table represents a record and a column of the table displays field values of the records. For larger numbers of records such tabular display will only contain a few records fitting on the screen, other records being reachable through interactive scrolling, by which the window of visible records is moved. One frequently needed analysis in such contexts is to identify groups of similar records having identical or close to identical values in at least one of their fields. Once such a group or block of similar records is identified, the second question is then how homogeneous the group is, that is, how well the records in the group match in their most important field values to be treated as closely related, or whether a more homogenous subgroup can be identified.
A usual method for identifying groups of records that have a particular field value in common is to sort the records in the table according to the given field value. Such sorting places all records with the same field value next to each other. Users can then inspect the list of records and their field values more closely and find out how many groups with different field values are present in the list and how homogeneous the identified groups are.
However, the difficulty with this approach is that it can be difficult to recognize the groups and assess their homogeneity if field values are visually similar. For example, if only a few digits in a long number are different, it can be difficult to spot these differences by glancing over the list of records. Therefore, to be really sure, users spend considerable time for detailed inspection of field values if they want to be sure that they have correctly assessed the equality or inequality of field values. Depending on the importance of the decision and the number of fields that can contain visually similar field values the effort needed for this group identification task can be a burden to users and slow them down considerably in their overall task.
With the expansion of the Internet, electronic commerce and distributed computing, the amount of information transmitted via computer networks is continuously increasing. Such possibilities have opened many new business horizons. However, they have also resulted in a considerable increase of illegal computer intrusions. That is why intrusion detection has become a rapidly developing domain. An intrusion detection system is composed of hardware components and software components. The hardware components are used for receiving, processing and displaying the so-called events. An event is a multivariable data record having multiple data properties or fields. The events are monitored for determining if an attack or if a potential intrusion has occurred. Given the current state of network intrusion detection systems and event correlation technology the monitoring of events by human specialists is used for considerably reducing the number of false alarms that network-based intrusion detection system typically report.
To perform this task more efficient and effective, human operators are supported in their task. However before an event is visualized it is processed by means of a pattern detection algorithm. This pattern detection algorithm enables to detect whether an arrived event is part of a given pattern on the basis of a comparison of the fields allocated to this given pattern and the fields associated to the arrived event. After using that kind of pattern recognition for filtering the arriving events, the detected events or alarms are visualized or displayed.
The alarms are generated by a multiplicity of sensors, wherein these sensors generate a large number of ‘false positive’ events, that are events that are not actual indications of a threat to a network. To determine whether an event or set of events can be classified as ‘false positive’ operators inspect one or more of the different properties of the events under investigation. Examples of intrusion event properties include source-IP, destination-IP and alarm type, etc.
Typically operators in such centralized security operation center monitor a number of sensors in parallel. This number of sensors generates a number of security events which are studied to determine whether they imply a potential threat. Frequently operators will try to assess events at a level of groups or blocks of events which have at least one property in common. For this, operators sort the events in the table according to one of the event properties so that events with the same field value are moved next to each other. They can then investigate the resulting blocks of similar events and in many cases deal with them at the level of event-groups, which is faster than at the level of individual events. Often there will be more events to process than can be displayed on a single screen, and even a single block of events with the same field value might spawn more than a screen. In some situations it is important to operators to know the relative size of the currently viewed block of events compared to other blocks, to know how many different field values (and therefore blocks of events) are represented in the current list of events, and to find the largest block of events. With state of the art tools for security event monitoring operators scroll through the whole list of events to gain the needed overview to be able to answer these questions.
SUMMARY OF THE INVENTION
Therefore it is an aspect of the invention to provide methods, apparatus and systems for facilitating the monitoring or analysis of multivariable data sets being provided in records displayed in tabular form. The invention is based on the idea that by masking equivalent values in same fields the amount of data to be checked can be reduced. The decision which field values are similar or equivalent is taken automatically, i.e. by a comparison algorithm performed by a computer.
In an example embodiment of the present invention a color or a hatching is assigned to records having equivalent values in the key field. Thus the finding of blocks of records, counting the number of blocks and assessing their size can be further supported. The colors or hatchings should be alternated. Record rows with the same sorted-by field value as the record in the row above are colored with the same color. Rows of records with a differing field value are displayed in a new or alternating color. This way, blocks of records are further visually emphasized.
In another embodiment of the present invention the multivariable data sets are created by an intrusion detection system, wherein a multivariable data record being an event, each event being provided with fields including a source IP address, signature and/or time of arrival. The events are generated by sensors arranged in an intrusion detection system. Such sensors receive data, e.g. network data from the Internet, and generate events. At least one agent in the intrusion detection system is searching the events for predetermined patterns. Having detected such pattern the event will be displayed in tabular form on a display.
In still another embodiment of the present invention there is no manual defining of a key field used for sorting. All fields of the multivariable data set are searched for equivalent values within the fields. In a next step the number of equivalent values in each kind of fields is counted, wherein the field having the most equivalent values is used for sorting the records. In that way the records are sorted automatically based on the field having the most equivalent values (i.e. the fewest group of values). In respect of monitoring the records this field is more important, since records with fields having many equivalent values should be monitored more precisely.



DESCRIPTION OF THE DRAWINGS
Embodiments of the invention are described in detail below, by way of example only, with reference to the following drawings, in which:
FIG. 1 represents a tabular representation of records according to the present invention;
FIG. 2 shows a detail view according to the present invention;
FIG. 3 shows an arrangement of blocks for navigating in between;
FIG. 4 shows a plurality of summarized information items used for the detail view;
FIG. 5 shows a distribution of values of a certain field;
FIG. 6 shows an alternative representation of the distribution shown in FIG. 5;
and
FIG. 7 shows a system for displaying events according to the invention.



DETAILED DESCRIPTION OF THE INVENTION
The present invention provides methods, systems and apparatus for facilitating the monitoring or analysis of multivariable data sets being provided in records displayed in tabular form. The invention is based on the idea that by masking equivalent values in same fields the amount of data to be checked can be reduced. The decision which field values are similar or equivalent is taken automatically, i.e. by a comparison algorithm performed by a computer.
An aspect of the invention removes repeated field values of a certain field in the tabular display of adjacent records to facilitate the visual identification of blocks. This masking or hiding is performed in the columns for fields having equivalent values. The effect will be most visible in the column of the key field that is used for sorting the records. With n different occurring field values in that key field n blocks will be built. In each of the blocks only one value of the field in the block is displayed, usually the first one visible in table view, wherein this one visible value of the block could also be displayed in the middle of the block. The other fields in the block will be displayed by using a blank value or other indicator for repeated values. This way it becomes easy to assess the number and size of blocks of fields in records that have matching field values in the key field that was used for sorting.
In a example embodiment of the present invention a color or a hatching is assigned to records having equivalent values in the key field. Thus the finding of blocks of records, counting the number of blocks and assessing their size can be further supported. The colors or hatchings should be alternated. Record rows with the same sorted-by field value as the record in the row above are colored with the same color. Rows of records with a differing field value are displayed in a new or alternating color. This way, blocks of records are further visually emphasized. Another possibility of supporting the visibility could be achieved by removing the border lines of the fields within the block. Thus only the border lines of the block are displayed.
In another example embodiment of the present invention the multivariable data sets are created by an intrusion detection system, wherein a multivariable data record being an event, each event being provided with fields including a source IP address, signature and/or time of arrival. The events are generated by sensors arranged in an intrusion detection system. Such sensors receive data, e.g. network data from the Internet, and generate events. At least one agent in the intrusion detection system is searching the events for predetermined patterns. Having detected such pattern the event will be displayed in tabular form on a display.
In still another example embodiment of the present invention there is no manual defining of a key field used for sorting. All fields of the multivariable data set are searched for equivalent values within the fields. In a next step the number of equivalent values in each kind of fields is counted, wherein the field having the most equivalent values is used for sorting the records. In that way the records are sorted automatically based on the field having the most equivalent values (i.e. the fewest group of values). In respect of monitoring the records this field is more important, since records with fields having many equivalent values should be monitored more precisely.
It is further advantageous to arrange a panorama bar. Since the amount of records displayable on the display device is limited, the operator would have to scroll through all records to find the biggest blocks. The panorama bar provides a bar of the full list of records and allows seeing without scrolling the big picture of all records and to asses the number of blocks and thereby the number of distinct field values and their relative size. The panorama bar has a scaled size fitting on the display without scrolling for providing an overview for a distribution of the blocks within all records. In particular the panorama bar indicates sizes of all blocks for a predetermined field of the multivariable data set including all records to be displayed. The panorama bar is composed of block elements set in relation to the size of each of the blocks for the predetermined field for all records.
In another example embodiment of the present invention the block elements of the panorama bar are colored or hatched as the blocks of the predetermined fields.
According to a example embodiment of the inventive method there is an indicator frame on the panorama bar indicating a current displayed position within the records. Thus the estimation of the number of records in each block is further supported. The indicator frame is a box in the panorama bar showing the position and size of the currently visible records in main view.
According to another example embodiment of the inventive method a detail view of a selected group of fields or records is provided. Most fields within the records show unique values, however there are also fields indicating a range of values. The detail view provides summarized information for the range of values. The detail view is displayed in a separate display, such as a pop-up window, which shows the content of all relevant fields, including those that are not visible in the normal display table view. In the case of a single entry in a field, such detail views are easy to produce. In a collection of entries, however, each field needs to show a potentially large number of field values. This summarized information is given in a summarized information item showing a trend, a distribution of values, a number of different values etc. By illustrating the range of values of a field within a selected block or group regular patterns could be easily detected.
The detail view allows users to quickly study detail data for a selected block or a group of data and find relevant patterns within the selected data. The challenge of a group detail view is that each field might potentially include a relatively large number of different values. The group detail view highlights patterns in the field data by using the summarized information item. The group detail view utilizes the fact that a user selects a group of entries or fields where it is suspected to find regularities. These regularities of a certain field are detected by the method and summarized in a concise and for the application more relevant form. The group detail view indicates the temporal distribution of data in the most important fields. This means that if a certain value, for example a particular event signature, occurs more and more frequently over time, such a trend becomes visible.
According to another example embodiment of the inventive method it is possible to use an inputting device like a keyboard or a mouse to quickly navigate between blocks. The block navigation in combination with the group detail view has the potential to significantly increase efficiency of, for instance, users monitoring security events.
The aspect of the present invention is also solved by a computer program. It is further solved by a system for displaying multivariable data. Embodiments of the invention are described in detail below, by way of example only, with reference to the following schematic drawings.
The drawings are provided for illustrative purpose only and do not necessarily represent practical examples of the present invention to scale. In the following the various exemplary embodiments of the invention are described. Although the present invention is applicable in a broad variety of applications it will be described with the focus put on intrusion detection applications or security event monitoring applications. Another field for applying the invention might be an online analysis function for large amount of data. Before embodiments of the present invention are described, some basics, in accordance with the present invention, are addressed.
The invention deals with an approach for visual structuring events triggered by one or more intrusion detection systems in a computer network. However, the inventive technique may also be useful for displaying other types of events, not just intrusion events.
The monitoring of events, in particular intrusion events, represents a task that requires high skill and attention from the monitoring staff. The reason for this is that in many applications a large fraction of the reported events are simply so-called ‘false’ positive alarms. The challenge for the operator is therefore to spot those events that are associated with a real security problem. In order to identify such security events, the operator of the intrusion detection system on the one hand is interested in continuously watching a main characteristic of the incoming events and on the other hand to uncover interesting event patterns.
Referring to FIG. 1, in accordance with an inventive method the multivariable data sets are provided in records 11. Each event is illustrated as a record 11. The record 11 is represented in tabular form on a display device. Each record 11 forms a row in the tabular view. A record 11 includes several fields 12, 12a, 12b, 12c characterizing different attributes or properties of the event. Field values of the same field in the records 11 are arranged in columns. To find patterns or regularities the set of records 11 is sorted. Therefore a key field 12a is defined to be used for sorting the records 11.
In FIG. 1 the “Signature” field 12a is exemplarily defined as the key field. That means the records 11 will be sorted based on the “Signature” field 12a. After having sorted the records 11, equivalent field values of the key field 12a are grouped so as to form a block 14. There are different field values in the key field 12a, so several blocks 14 are defined having here different sizes. As can be recognized in the column of the Source IP field 12b there are also blocks having equivalent field values in this column. It can be useful to define a second key field for sorting the records. In the present case the second key field is the “time of receiving” field 12c. According to the invention only one field value 15 in a block 14 is displayed. All other field values of that block 14 are hidden or masked. So the operator will easily see the respective one field value 15 of the field 12a in the block 14. This will drastically facilitate the monitoring of records.
To further support the visibility, colors or hatchings are used for the number of records 11 having equivalent field values in the defined key field 12a. FIG. 1 uses different hatchings, wherein by using different colors the blocks 14 could also be differentiated very easily. Also the removing of border lines of cells within a block 14 supports the visibility.
FIG. 1 illustrates a panorama bar 16. The panorama bar 16 is arranged nearby the tabular form. It is composed of block elements 17. Each block element 17 represents a block 14 in the tabular view, wherein the size of the block elements 17 is set in relation to the size of the blocks 14. The panorama bar 16 fits on the display. Therefore it is possible to see the big picture of blocks 14 without scrolling through the whole set of records 11. The block elements 17 are colored or hatched in the same style as the related blocks 14.
FIG. 2 represents a detail view 20. The detail view 20 will be shown in a separate window. To show the detail view 20, the operator selects a block 14 or a group of events. The detail view 20 shows the field values in the field 12 of the records related to the selected block 14 or group. In this example, the most field values of the field 12 are unique. However the fields “receiving time” 12a, 21, the “generation time” 12, 22, the “source IP address” 12b, 23 and the “destination IP address” 24 have field values within a certain range. The detail view 20 summarizes the range of field values in a summarized information item 25. By using the summarized information item 25 the operator can quickly assess if there is a certain trend or distribution of field values representing an intrusion.
In the following the detail view 20 is explained in more detail. In some application domains, for example in event monitoring, group detail views are called up when the user expects to find some regularity within the data of the collection. Therefore, the user is less interested in seeing every single field value, but they are interested in potential patterns within field values and how these patterns differ over several fields. For example, if the user selects a group of entries or records 11 that all have the same field value in field 12a it is interesting to see whether field 12b also includes only a single value, or randomly distributed unique field values, or a sequence of ascending field values without duplications etc.
Depending on the application domain there are regularities which are of particular interest to the user. The goal of the group detail view 20 is to analyze the collection of field values, detect these special cases and to highlight them in the detail view 20. Examples for such regularities are

    
    
        a) all records 11 show the same field value in a certain field
        b) there is a relatively small number of different field values, e.g. 2 or 3 values
        c) all records 11 are unique
        d) the records 11 completely cover a specified range of field values
        e) the records 11 show a pattern within a range (such as: every second value or only even numbers occur)
        f) the field values show an unusual distribution. For example almost all records 11 are in a relatively small range, but one field value is different.
    
    


In large amounts of records 11 it is very difficult to find such cases using a tabular representation. On the other hand, a detail view 20 which highlights these special cases makes finding such regularities easier. The specific method to detect such a pattern can be selected from methods known in the art. Algorithms can be used which are applied on the range of field values to generate the summarized information items 25.
The detail view 20 can also provide an indication about the temporal distribution of field values. This assumes that each entry is associated with a time stamp which is the typical case in domains such as event monitoring. In these domains it is not only of interest how the field values are distributed within a group of events, but also how a certain field value is distributed over time within the entire set of records 11. Such temporal information typically is shown only for a certain field, such as the key field 12a in the data. For example, a bar chart 26 can indicate the relative frequency of a certain field value within specified time ranges. Another indicator 27 would show the relative frequency of a certain field value within the list of reviewed and unreviewed events. For example, in an event monitoring application, the event signature (field 12a) tells the user about the kind of event. It is useful to know if a certain type of event occurs unusually often. The bar chart 26 is an embodiment of a temporal distribution indicator. The indicator bar 27 to the left shows the proportion of reviewed and unreviewed occurrences of the signature field 12a within a predetermined time, e.g. the last hour. The bar chart 28 to the right indicates the occurrence frequency of that signature within 6 time slices, e.g. 10 minute duration, with the leftmost bar representing the most recent one. In this depicted example, the signature value under consideration does not show a special trend over the last hour.
When generating the detail view 20, the group of events to be shown might include more than one field value in the signature field 12a. In such a case the same principle is used to generate the chart showing temporal distribution. The only difference is that the bars now do not show the frequency of a single field value (signature) but of several signatures. Should one field include only one unique field value, the example embodiment would indicate this special case, for example by changing the color of the field representation.
As mentioned above, the detail view 20 does not try to show every field value within a group. Sometimes, though, users may need to study individual field values. It is possible to select a number of field values within the detail view 20 and call up an additional view showing only these field values. This third view shows fewer entries (only the group of entries originally selected) and fewer fields. Thus, it should be sufficient to handle these field values in a conventional table view. In order to display detail field values for individual fields a simple scrollable list should be sufficient.
FIG. 3 shows an exemplary arrangement of blocks 14 having equivalent field values. In tabular data it is often necessary to select groups of entries that exhibit similarity in one of the table columns. For example, after sorting a table by column A a user might want to perform an operation on all entries or records 11 with a specific field value in that column A. In table-based representations such as spread sheets, but also in event viewers, users would drag over the whole range of rows with the mouse or click on the first row of that range, then scroll to the last row and Shift-click that last row.
As described above, a part of a table column with identical field values is denoted as block 14. To easily navigate between the blocks 14, a selection method is proposed for a contiguous range of rows by double clicking into any cell within a block. That activity selects the entire block 14, including those rows which might be off screen. Essentially, the action first selects one cell and then extends the selection upward and downward as long as it finds identical field values within the column that was clicked. The block 14 selected in that way becomes the current block.















515
MINOR
199.173.225.5
206.160.217.226


516
MINOR
208.30.146.37
151.36.194.150


517
CRITICAL
129.33.64.116
204.116.44.2


518
MINOR
129.33.65.36
24.26.139.180


519
MINOR
57.8.195.50
192.168.196.2


520
MINOR
153.2.242.83
67.97.251.18


521
CRITICAL
129.33.64.111
204.116.44.2









In the table shown double-clicking on the word “MINOR” in row 519 selects the three rows 518 till 520 because the first column includes the identical field value in all three rows. The current block becomes the three cells including the field value “MINOR” in rows 518-520. This kind of use for block selection is convenient for spreadsheet applications where the user wants to perform some action on a block of identical field values.
In applications like event monitoring, a user does not select individual cells, but is interested in complete rows. Therefore, when the user performs a block select as described, the block 14 with the value “MINOR” becomes the “current block” but the selection is the complete three rows 518-520. This activity also calls up a detail view 20 for the three events represented in these rows.
In a state-of-the-art event monitoring application users select a row in the event table, call up a detail view 20 and then use the cursor keys to move to the next rows, updating the detail view 20. Using the block selection technique described in combination with the detail view 20 described above allows users to quickly and easily select related groups of events for further study. It is useful to allow users to provide keystroke navigation not just for row-by-row navigation, but also for moving around the event table based on groups of related blocks 14.
The FIG. 3 shows a sketch of an event table sorted by two columns. Double-clicking the block labeled I makes block I to the current block and selects all the rows including cells within that block. Using a key combination and cursor right the current block becomes the first block to the right 2 and the row selection and the detail view 20 updates accordingly. Moving the cursor down, the current block becomes block 3 and the selection and detail view 20 updates again. Moving the cursor left would then select again block 1 as current block. For this interaction technique to be intuitive, the system provides two selection highlights. One of them indicates the range of rows that are selected, the “selection” in the traditional sense. The other highlight shows the current block. The combination of block selection, block keyboard navigation and detail view 20 is an extremely powerful tool for exploring event data.
In the following some examples are given for representing patterns within field values.
As described, the detail view 20 is based on the idea to illustrate patterns within field values, as users are less interested in individual field values than in the distribution of field values within a group of selected entries or records 11. A number of example representations will be described.
Depending on the application domain an embodiment will highlight some of these cases as special but not others. For example, case a) (unique field value) could be highlighted as special in some applications, but considered less interesting in others.
If all field values within a group are identical, the unique field value is displayed. If the field includes only a relatively small number of different field values, a list of the different field values will be displayed. A example embodiment also indicates the number of occurrences of each field value. For example, if a field includes only the numbers 1 and 2, this could be shown as fieldname: 1, 2 or fieldname: 1 (32), 2 (11), wherein the number in brackets gives the number of occurrences of the certain field value.
The amount of space within the detail view 20 needed to display each field value determines the appropriate maximum number of field values to show. Typically, the number of field values to show will be in the range of 2 to 5.
In another example the field values do not exhibit any particular pattern. In this case a wildcard character is used, such as “*” or fieldname: *(50). The number in brackets should show the number of field values in the field. A example embodiment provides a facility to call up the individual field values of that field as a scrollable list. The user can call up the list if they are interested in.
In another example a pattern is detected within the field values. In this case a wildcard character or a range description and an icon describing the pattern found are displayed. As described the types of interesting patterns are dependent on the application domain. Typically there should be summarized information icons as shown in FIG. 4 A-E:

    
    
        For ascending values a possible icon is shown in FIG. 4A.
        For descending values a possible icon is shown in FIG. 4B.
        For alternating values a possible icon is shown in FIG. 4C.
        For values covering a range of field values, the lowest and highest field values in that range are indicated. A typical indicator is [a . . . b]
        For field values covering 2 or 3 ranges of values with distinct gaps in between a typical indicator is [a . . . b] [c . . . d]. A possible icon is shown in FIG. 4D.
        For field values mostly covering a range of values [a . . . b] with very few outliers c, d a typical indicator might be [a . . . b], c, d. A possible icon is shown in FIG. 4E.
    
    


Further icons could be used depending on the quality of display. To increase the amount of information or the advertentcy of the user the icons could be colored.
Many such patterns can be described using regular expressions, which is well known. However the goal of the detail view 20 is not to describe every possible pattern, but to highlight a relatively small number of interesting patterns. Therefore a example embodiment will keep the number of patterns, icons and representations relatively small and relatively simple. In another case the field values show a mathematically describable distribution, for example a normal distribution. This case should be shown using a wildcard and either an icon to indicate the distribution, or a textual description. A potential icon for a normal distribution is shown in FIG. 4F. The icons given in FIG. 4A-F could be supported by the possibility to call up a list of the field values.
In some cases, it might be appropriate to visualize the distribution of field values in a field. This kind of visualization differs from a visualization of temporal occurrence as shown in FIG. 2, which shows the distribution of time stamps for a specific value. For instance, for a field that can take field values in the range [0 . . . 99] only it is easily possible to visualize occurrence of field values in that range. This way both the distribution as well as the relative frequency of field values is visible. An example for such visualization is shown in FIG. 5. Each field value in the range [0 . . . 99] is shown as a vertical bar, the length of which indicates the relative frequency of a field value in the data set. If the system cannot detect unusual patterns, such visualization can give the user some idea of the distribution of the field values.
If the range of field values exceeds the available space it is possible to group subranges into summary bars. For instance, the range [0 . . . 255] can be represented as 16 groups with a range of 16 field values each, as illustrated in FIG. 6. That way, that range can be shown as a chart with only 16 bars. This chart shows less information, but for some applications, it is sufficient to indicate all field values grouped in a relatively small value range with relatively few outliers. FIG. 6 shows field values in a range of [0 . . . 255] exhibiting a similar pattern as the values in FIG. 5.
It is also possible to create an abstract visualization which yields an icon-like representation of the characteristic distribution as follows: The frequency of each value in the range is classified into a number, here a small number of 3, of value ranges (low, middle, high). For instance, if the least frequent value occurs once and the most frequent one occurs 10 times, these ranges could be [1 . . . 3] [4 . . . 7] [8 . . . 10]. Then the visualization of frequency is generated from the lowest to the highest value. The frequency of the first value (n) is drawn as a bar indicating the frequency as low, middle or high. If the next value (n+1) is in the same frequency range, it is not drawn. However, if it is in a different range, it is shown. This procedure is repeated through the whole range of values. Thus consecutive identical bars that indicate the same frequency range are eliminated and the visualization is shortened. In the worst case this representation can be as long as the representation in FIG. 5, but in the optimal case it is much shorter. Furthermore, as this representation reduces the distribution data into 3 value ranges, the representation is limited in height which makes it especially appropriate to be used inline within text. The kind of displaying the summarized information icon for a certain field depends on the application domain.
If there are fields including textual data a pattern matcher might find more complex patterns within the field data, such as reoccurring substrings, password data, or parts of command strings. Highlighting such cases is especially useful in longer textual fields which potentially cannot be shown in their entirety.
A typical case in the event monitoring domain is that event data includes a comment field which is seldom shown. The comment field frequently is empty, but it can also include a large amount of text. It is difficult to provide adequate space for long text in a detail view 20 if it is used only sparingly. Thus, these fields are often not checked. It can be very relevant, though, to know when such a comment field includes URL information, passwords or other potentially sensitive information. A pattern matcher can be used to check for these occurrences and indicate them. Again depending on the application domain a relatively small number of icons can describe whether such special cases were found in a textual field. An example for such a representation might be: “http://*” (3), x@y.z (5) this could indicate that 3 “strings look like URLs” and 5 “strings look like email addresses” were found.
Another special case is the representation of groups of IP numbers. This case is especially relevant in the event monitoring domain. IP numbers consist of several numerical fields, separated by dots. An example is the IP number 127.2.1.47. A typical example for an interesting pattern in event data occurs when an intruder sequentially scans through a range of IP numbers. This would generate a group of events where this IP number field shows a distinct pattern. Displaying such a pattern for IP numbers is actually a special case of a representation for a single field because 4 numerical fields which can include the values [0 . . . 255] are grouped together. Typically interesting patterns in IP numbers occur through variation within one field.
For example, a “port scan” could generate events that show the following IP numbers: 127.1.2.1:0, 127.1.2.1:1, 127.1.2.1:2, 127.1.2.1:3, etc. Intruders try to distribute their actions over time so that events with these IP numbers do not occur one right after the other. However, when sorting event data by signature field and receiving or generation time, these events get grouped together and become easier to find. Selecting such a group and calling up a group detail view 20 then highlights the IP number sequence, shown above. Instead of a user having to detect the pattern visually in the event table, the detail view 20 points out a potentially interesting pattern to the user who can focus on assessing the threat.
The representation of IP numbers uses the same principles as for single field values. Thus, this example can be represented as a combination of the representations described above. The first example shows a purely textual information icon. The second example shows a combination of a textual information icon with an iconic representation of a pattern in the group of field values.

    
    
        textual representation: 127.1.2.[1 . . . 63]
        iconic representation: 127.1.2.[1 . . . 63] ()
    
    


The inventive characteristic of the detail view 20 is the analyzing collections of data and finding an appropriate formal description of the patterns encountered in field values.
Patterns in the data which are considered relevant for the application domain are then highlighted either using a formal or an iconic representation.
To find patterns it is not necessary to look for identical field values only. For certain application domains it can be useful to consider a similarity among field values. For example, a field called signature (describing a class of events) might include signatures that are only small variations within an event class, such as “someevent—1234” and “someevent—1235”. Depending on the application domain it can be appropriate to consider these two signatures as “similar” and to treat them as one field value within the group detail view 20. This case does not change the embodiments described in this document. A example embodiment would simply consider such similar field values as identical when detecting patterns and generating temporal distribution charts for the group detail view 20.
FIG. 7 illustrates a system environment for performing the inventive method. The data are generated somewhere in the Internet 30. A plurality of sensors 33 is monitoring the data and generating events depending on the monitoring task. An intrusion detection system 32 receives the events from the sensors 33. The intrusion detection system 32 comprises agents 36 or adapters for performing a pattern recognition or pattern correlation on the incoming events. The agents 36 check whether among the received events there are events showing patterns, which are relevant for the security. Such detected events are displayed on a security console or display device 34 in tabular form 35 as described above.
The inventive method provides a possibility to facilitate the monitoring of records 11 in tabular form. Especially in the field of intrusion detection systems the displaying of only one field value for blocks of fields having equivalent values improves the monitoring or analyzing of multivariable data sets. The combination with a detail view 20 showing details of field values of a selected block in summarized information items provides an advantageous function that reduces the amount of elaborate sorting work. Thus an operator of a security console can concentrate on finding threats.
The method can be used by a service provider to offer a service to a customer. The customer can send its records to the service provider who performs the described method to obtain as output the records in the visually structured form. The output can be delivered to the customer. Also, the output can further be used by the service provider to perform a record analysis based on the visually structured form. The record analysis is used to identify patterns within the record fields that are indicative of an undesired situation, such as an attack by a third party. The identified attack can be notified to the customer. Also, upon identification of an attack, the service provider can provide the service of performing a protective attack countermeasure for the customer, such as blocking the attack, quarantining the customer system, deleting the attacking code or the like.
Variations described for the present invention can be realized in any combination desirable for each particular application. Thus particular limitations, and/or embodiment enhancements described herein, which may have particular advantages to a particular application need not be used for all applications. Also, not all limitations need be implemented in methods, systems and/or apparatus including one or more concepts of the present invention.
The present invention can be realized in hardware, software, or a combination of hardware and software. A visualization tool according to the present invention can be realized in a centralized fashion in one computer system, or in a distributed fashion where different elements are spread across several interconnected computer systems. Any kind of computer system—or other apparatus adapted for carrying out the methods and/or functions described herein—is suitable. A typical combination of hardware and software could be a general purpose computer system with a computer program that, when being loaded and executed, controls the computer system such that it carries out the methods described herein. The present invention can also be embedded in a computer program product, which comprises all the features enabling the implementation of the methods described herein, and which—when loaded in a computer system—is able to carry out these methods.
Computer program means or computer program in the present context include any expression, in any language, code or notation, of a set of instructions intended to cause a system having an information processing capability to perform a particular function either directly or after conversion to another language, code or notation, and/or reproduction in a different material form.
Thus the invention includes an article of manufacture which comprises a computer usable medium having computer readable program code means embodied therein for causing a function described above. The computer readable program code means in the article of manufacture comprises computer readable program code means for causing a computer to effect the steps of a method of this invention. Similarly, the present invention may be implemented as a computer program product comprising a computer usable medium having computer readable program code means embodied therein for causing a a function described above. The computer readable program code means in the computer program product comprising computer readable program code means for causing a computer to effect one or more functions of this invention. Furthermore, the present invention may be implemented as a program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps for causing one or more functions of this invention.
It is noted that the foregoing has outlined some of the more pertinent objects and embodiments of the present invention. This invention may be used for many applications. Thus, although the description is made for particular arrangements and methods, the intent and concept of the invention is suitable and applicable to other arrangements and applications. It will be clear to those skilled in the art that modifications to the disclosed embodiments can be effected without departing from the spirit and scope of the invention. The described embodiments ought to be construed to be merely illustrative of some of the more prominent features and applications of the invention. Other beneficial results can be realized by applying the disclosed invention in a different manner or modifying the invention in ways known to those familiar with the art.

## Claims

1. A computer implemented method for visual structuring comprising:
providing visual structuring of multivariable data sets in records, wherein each event of a plurality of events being illustrated as a record from a set of records, said record is represented in tabular form on a display device, each record forms a row in a tabular view, each record includes a plurality of fields characterizing different attributes or properties of said each event, field values of a same field in the records are arranged in columns;
defining a key field used for sorting the records;
sorting said set of records to find patterns or regularities employing said key field;
grouping equivalent field values of the key field in an equivalent field value group;
forming a corresponding blocks for each equivalent field value group, each corresponding block having a block size;
displaying only one field value for each block, and hiding or masking all other field values of said each block,
employing a visibility enhancement taken from a group of enhancements consisting of colors, hatching, adding border lines to cells, or removing border lines of cells or any combination of these enhancements; and
enabling an operator only to see each respective one field value of the field in the block and monitor said set of records.

2. The method as claimed in claim 1, further comprising:
showing a detail view in a separate window by said operator selecting a block or a group of events, said detail view showing field values in a field of the records related to the block or group selected; or
calling up domains when said operator expects to find some regularity within data of a collection, to show potential patterns within field values and how the potential patterns differ over several fields; and
enabling said operator, when a group selected includes entries or records all having a same field value in a [particular, exhibiting whether another field also includes only a same single value, includes randomly distributed unique field values, or a sequence of ascending field values without duplications.

3. The method as claimed in claim 1, further comprising:
showing a detail view providing an indication about the temporal distribution of field values, when each entry is associated with a time stamp for at least one certain field, such as the key field in the data.