EP0697667A1 - Method and apparatus for displaying structures and relationships of a relational database - Google Patents
Method and apparatus for displaying structures and relationships of a relational database Download PDFInfo
- Publication number
- EP0697667A1 EP0697667A1 EP95304315A EP95304315A EP0697667A1 EP 0697667 A1 EP0697667 A1 EP 0697667A1 EP 95304315 A EP95304315 A EP 95304315A EP 95304315 A EP95304315 A EP 95304315A EP 0697667 A1 EP0697667 A1 EP 0697667A1
- Authority
- EP
- European Patent Office
- Prior art keywords
- relation
- relations
- view
- displaying
- set forth
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Ceased
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Definitions
- the invention concerns graphical displays for visualing useful characteristics of large databases, in general, and graphical displays for visualizing structures and relationships within large databases, in particular.
- Each relational database consists of data arranged in one or more relations.
- Each relation consists of one or more attributes and one or more tuples.
- the relations can be represented by tables, the attributes by columns of the tables and the tuples by rows of the tables.
- Large databases typically have a straightforward structure that is explicitly defined. However, even a database that is well defined explicitly may still have a high degree of complexity because of the amount of data it stores, the number of relations it contains, the number of relationships between relations or the mapping between displayed views and physical storage. This is especially true of so called "legacy" databases that have existed and evolved for a decade or more.
- each database has an implicitly defined structure. Implicit structure occurs when the same data item or characteristic, such as an attribute or tuple, appears in two or more separate places. This implicit structure is a type of meta data that is very useful for defining objects or simply accessing data in a way different than the way contemplated in the explicit definition.
- An association exists implicitly where data of the same type, or domain, occurs in separate relations. An example of an association between two relations is one in which a non-key attribute in one relation is a key attribute in another relation. Associations are connections where relational joins may be made.
- Collections of relations are often used to define objects. However, such collections are rarely explicitly defined. In such cases, implicit associations between relations many times are used to define collections of relations, which in turn are used to define objects.
- the ERD techniques adds what amounts to an additional layer of semantics and definitions to a database: a complex layer that must be maintained along with the database, thereby adding more work to each change to the relational database. Even with the extra work, for large databases the graphical representations typically are too busy and cluttered to be helpful to a software engineer trying to visualize a large database.
- APT graphic automated presentation tool
- the aforementioned problem is solved and an improvement over the known techniques by providing a method and apparatus for displaying statistics and characteristics of an entire relational database in one overall view without any semantic information to clutter the display and confuse the viewer.
- the semantic information which is purposefully omitted from the overall view, is provided in additional views that are interactively linked to the overall view and to each other.
- the aforementioned problem is solved and an improvement over the known techniques is achieved by providing a method for displaying information about a relational database.
- the method includes a number of steps. Initially, each relation of a plurality of relations in the relational database is identified. Next, for each relation, a respective number of structural characteristics contained in the relation is determined. Also, for each relation, a key structural characteristic for accessing that relation is determined. The plurality of relations is then categorized according to their key structural characteristics. Next, the plurality of relations is visually presented in categories according to their key structural characteristics with each relation being represented by a respective bar whose length is representative of the number of the structural characteristics contained therein.
- FIG. 1 is a block diagram of a computer system for analyzing a relational database according to the present invention.
- FIG. 2 is a gray scale representation of a typical display of an over view according to the present invention.
- FIG. 3 is a gray scale representation of a typical display of a specification view according to the present invention.
- FIG. 4 is a gray scale representation of a typical display of an associations view according to the present invention.
- FIG. 5 is a block diagram showing the locational encoding of the information displayed in the association view shown in FIG. 4.
- FIG. 6 is a gray scale partial expansion of the associations view shown in FIG. 4.
- FIG. 7 is a gray scale representation of a typical display of a path view according to the present invention.
- FIG. 8 is a gray scale representation of a typical code sub-tree display of a code view according to the present invention.
- FIG. 9 is a gray scale representation of a typical display of a layout view according to the present invention.
- FIG. 10 is a gray scale representation of a typical display of a domain view according to the present invention.
- FIG. 11 is a gray scale representation of an over view as in FIG. 2, with two cursors active.
- FIG. 12 is a gray scale representation of an over view display overlaid with a specification view, a path view, and an associations view.
- the system 101 includes terminal 103, which provides output to and receives input from a user of the system, processor 113, which performs the actual analysis operations, memory system 115, which contains programs 117 executed by processor 113 and relations 1191 - 119 i , each of which contains a respective set of attributes and tuples.
- the system 101 also has a mass storage system 120 for storing the relational database, its specifications and the relational database management system or systems (RDBMS) used to query, process and extract information from the relational database.
- the RDBMS is one of the programs 117.
- terminal 103 includes a display screen 105, upon which processor 113 displays information for the user.
- Display screen 105 also includes a cursor 107, which specifies a location in display 105 and may be moved under control of either keyboard 109 or mouse 111. The operator controls the operation of system 101 by inputs from keyboard 109 and/or mouse 111.
- Processor 113 may be any kind of processor, from a personal computer through a workstation or even a super computer.
- Memory system 115 includes any data accessible to system 101, and may thus include random-access memory and/or read-only memory. Connected to memory system 115 is mass storage system 120 from which data is read into memory system 115 to make such data more accessible, or into which data is stored, e.g. for the long term.
- Mass storage system 120 may include magnetic disk and/or optical disk.
- keyboard 109 or mouse 111 When employing computer system 101 to analyze a large relational database, the user may use keyboard 109 or mouse 111 as input devices.
- Processor 113 executes programs 117 as required to perform the analysis on the relational database and graphically displays the results on display screen 105. The user can then use keyboard 109 and/or mouse 111 to interactively examine the results in more detail, or call up other linked displays to obtain more information.
- system 101 runs under the UNIX operating system (UNIX is a registered trademark of UNIX Systems Laboratories) using a workstation, such as a SUN workstation, manufactured by SUN Microsystems, using an X Windows System for workstation applications. (X-Windows is a trademark of Massachusetts Institute of Technology).
- Display 201 is an over view, which is the highest view level of the large relational database.
- the large relational database may contain over 1,000 relations comprising over 10,000 attributes.
- Display 201 has approximately 1,200 relations shown in multiple columns. Each relation is represented by a bar.
- the size of the display screen 105 and the graphic resolution of the computer system 101 determine the smallest relational bar and the largest database that may be displayed in its entirety. Preferably, all the relations of the entire database could be represented in the over view.
- the presentation of all the relations on a single screen gives the user a unifying perspective of the database that allows software personnel to understand how a single relation fits into the structure of the whole database. However, if the graphic limit of computer system 101 and display screen 105 is exceeded, some scrolling of the relations could be used without degrading the overall perspective.
- the relations of display 201 are arranged according to their structural characteristics under control of the user.
- the relations are displayed alphanumerically from 0-9 and from A-Z according to the designation of their access. Since there are no relations having access methods beginning with a numeric character or letters A-B, the first category of relations is a category having access CIND, as shown by the designation CIND next to the first relation shown in the left most column. All of the relations having CIND are listed in alphanumeric order from the upper left of the left most column to over half way down the third column from the left. The remaining columns have similarly organized listings for relations having accesses designated DD, DHSH, DIR, IND, LIN and OPV.
- the relations in each category may be commonly shaded or colored, such as violet for relations with CIND accesses.
- Relations having different accesses may have different shading or coloring, such as accesses DD, DHSH, DIR, IND, LIN and OPV having blue, emerald green, lime green, yellow, light red and dark red, respectively. If color is not available or desired, different shades of gray and patterns as shown in FIG. 2 are used instead.
- Each relation in FIG. 2 is represented by a bar whose length is dependent upon a statistic of the relation, for example the number of attributes, tuples, or bytes in a tuple in the relation.
- a relation bar When a relation bar is touched by the cursor 107 (see FIG. 1) it is highlighted to a color or gray shade that contrasts with the adjacent relation bars, such as relation bar 203. The highlighted color or shade is an indication that this particular relation has been selected for closer examination.
- the name or designation of the selected relation appears in a designation box 205.
- the selected relation bar 203 corresponds to the relation designated RLls_lnk.
- Immediately below the designation box 205 are three boxes that provide statistics for the number of columns (i.e. attributes) in the selected relation, which for RLls_lnk is shown to be 10; the maximum number of tuples, which is shown to be 256; and the size of each tuple, which is shown to be 12 bytes.
- buttons which maybe activated by the cursor to provide additional information about the selected relation, in this case relation RLls_lnk.
- the buttons are labeled: Assocs (abbreviation for Associations), Paths, Code, PRL (abbreviation for Population Rule Language, commonly referred to as the Specification View), Layout, Relations List, Domains, Entity, and Distance.
- Assocs abbreviation for Associations
- Paths abbreviation for Associations
- Code abbreviation for Population Rule Language, commonly referred to as the Specification View
- PRL abbreviation for Population Rule Language, commonly referred to as the Specification View
- Layout Layout
- Relations List Domains, Entity, and Distance.
- Each of these buttons, except Distance may be used to open another window on the screen 105 (see FIG. 1) which displays another view of the relational database under analysis.
- a display 301 is shown on display screen 105 that is called the specification view.
- the specification view the actual specification(s) of the database in the database description language or languages that are understood by the RDBMS may be directly viewed.
- the method and apparatus according to the present invention preprocesses existing explicit descriptions of the relations in the database and the RDBMS application source code, including predefined queries of the database, into a reference file used by the display portion of the database analysis system.
- the specification view accesses this reference file when activated.
- display 301 the specification view is activated while a selection of a relation in display 201 is still active, then the specification view opens up to the selected relation, in this example RLls_lnk. This allows the descriptions of relations and the source code form of queries to be viewed directly in the context of the selected relation.
- queries shown declaring associations between relations in the query have that portion of the display 301 highlighted by a contrasting color or shade of gray.
- the display 301 is typically less than a full screen in size in order to provide interaction with one or more other displays, but may be expanded to occupy the entire display screen if desired.
- the specification view is interactively linked to the over view such that a change of the selected relation in one will cause an automatic and nearly immediate change to the new selected relation in the other.
- display 401 is an associations view.
- the associations view shows the associations between the selected relation and other relations of the database through queries and other mechanisms supported by the RDBMS. This view is used to discover associations between relations. Shown in the associations view are the selected relation 403, RLls_lnk; the associated relations defined in the database specifications; and the type of association between the selected relation and the other relations.
- the selected relation 403 is located in the center of display 401. In this example, it has ten attributes, lsnum, member, lnkgrp, lnkgrpmem, unitnum, master, dfinum, sdl_sm, st_dlt, and sdl_port.
- the associated relations 405, 407, 409, 411, 413 and 415 are located around the selected relation 403. The location of each of the relations 405-415 visually indicates to the user the type of association it has with the selected relation 403.
- FIG. 5 shows an example of a directional, positional encoding scheme used in display 401, although alternative positional schemes could be used as long as the user understands the encoding scheme.
- a strong association means that the association may be used as an access path to directly find a tuple in the associated relation.
- a tuple may be directly accessed if the associated relation provides a complete key attribute to the target relation.
- a strong association contains a complete key.
- a weak association contains only an incomplete key attribute and cannot be directly used to access a tuple.
- Weak associations may be used if the user understands how to complete the incomplete key attribute, or if it can be used for a sequential search. Constraints, such as relation 415, are limitations and are shown for information only since they do not provide accesses.
- each of the relations in the relational view is colored or gray shaded according to a characteristic, such as its respective access, just as in over view display 201.
- a second selection can be made with the cursor (not shown) and if that is done.
- the display of first selected relation 403 has change slightly to the display of first selected relation 603.
- the display of second selected relation 409 has changed and expanded to the display of the second selected association 609 and its expanded form association 6091 with attributes 6092-60913.
- attributes 6032 and 6033 have coordinated shading to show their linkage to attributes 6092 and 6093 respectively. This linkage is also shown by the arrows from 6032 and 6033 to 6092 and 6093. If an attribute is similarly shaded or colored but there is no arrow connecting it to a linked attribute, the association involved concerns a constraint on the value of the attribute instead of a linkage to an attribute of an associated relation.
- rectangles 620-622 are displayed along its bottom edge. These rectangles 620-622 represent the number queries or database specifications where this particular association is mentioned. Taken together, the rectangles 620-622 form an association selector. Pointing to any of the rectangles 620-622 in the association selector causes that association between the selected relations to be displayed in FIG. 6. Different attributes may be involved in different places where the association is mentioned, so the user is offered both for viewing.
- over view display 201 If over view display 201 is active, a touch of any relation in display 401 or display 601 with a cursor will select the corresponding relation in over view display 201. When a relation is selected in over view display 201, its designation, characteristics and statistics are displayed there also.
- display 701 which may be either full screen, or one of many active windows displayed on the display screen 105, is a path view.
- the path view display 701 visually presents all of the shortest paths connecting any two selected relations. In this manner the present invention is a great improvement over techniques, such as ERD which shows many more paths and many more relations than necessary and thereby becomes needlessly confusing and complex.
- the shortness of a path is measured in terms of the number of joins, i.e. steps, required to traverse the path to the selected relation. Only strong paths based on steps made up of strong associations are shown in the path view. This means that each path shown may be used as an access without the further considerations required by weak associations. Since there is always at least one shortest path to any relation, FIG. 7 visually presents to the user an access path between any two relations.
- Access paths are shown as a directed network in the path view.
- two cursors 1102, 1104 are activated in the over view (shown in FIG. 11).
- the color(s) or gray shading(s) of these two cursors 1102, 1104 match the color(s) or gray shadings of the frame 703 of the path view window and also the color(s) or gray shades of highlighted outlines around the two relations 705, 707 for which the shortest path or paths are shown. If the path view and the over view are both open at the same time, as either of the two cursors is moved in the over view, the corresponding relation changes in the path view, and the shortest paths between the two selected relations are displayed as directed networks immediately.
- relations in the over view may be colored or gray shaded according to how many steps from an originating relation there are in an access path.
- the path view may be linked to the association view by the user by attaching both views to the same cursor. If this is accomplished, the relations in both views become linked. In such a case, touching a relation in the path view with the cursor highlights that relation in the association view as well as the path view. Clicking the mouse button on the highlighted relation in the path view is equivalent to clicking the mouse button on the same relation in the association view, i.e., the association is shown in an expanded form as shown in FIG. 6.
- a display 801 is shown on display screen 105 that is called the code view.
- the code view displays the application source code of the RDBMS that uses the currently selected relation, in this case relation RLls_lnk.
- the application source code may be represented as a horizontal tree representing the code hierarchy. The subset or subsets of that horizontal code tree that use the currently selected relation are displayed in the code view.
- the code view may be used by the user to find the application source code which references a relation and also to find where in the application source code the relation is accessed.
- the code view is linked to the over view such that all relations accessed from a unit of application code may be easily identified.
- Each unit of application code is represented by a box in the code view. Touching any code box with a cursor causes that box to be highlighted and its designation to be displayed. For example, code box 803 has been touched by a cursor (not shown) and is now highlighted by a contrasting color to the light blue of the rest of its code sub-tree 805, and its designation (CCs7text.bp) is shown in display area 807. Clicking the mouse button on a code box highlights in the over view all relations that use the corresponding unit of code.
- sub-trees 805 and 809 For the purposes of the code view, application code executing on multiple separate processors in a distributed system is considered to be multiple separate applications, each of which may be examined as a separate code sub-tree.
- Clicking the mouse button on a leaf of a code sub-tree opens a scrolling window which contains the text of the code with the text scrolled to a location in which the currently selected relation is accessed. Since a relation may be accessed multiple times by a unit of code, multiple locations are shown by using a location bar appearing on the right side of the scrolling window next to the scroll bar. Red or light gray lines appearing in the location bar (not shown) indicate the multiple locations. Clicking on a box in the tree highlights all relations on the over view that are accessed by that code.
- a display 901 is shown in a window on display screen 105 that is called the layout view.
- the layout view shows the physical layout in memory of a tuple of a relation, as well as, the relative sizes of attributes of the relation.
- Display 901 shows a tuple 903 and attributes of the currently selected relation RLls_lnk. Attributes lsnum, lnkgrp, dfinum, sld_sm, st_dlt, and sdl_port are represented by rectangles and the size of each rectangle is proportional to the size of its respective attribute.
- a frame 905 of this window is colored or gray shaded the same way that the selected relation to which it corresponds is colored or gray shaded in the other views, for the example of relation RLls_lnk, this highlight shade is dark gray.
- a domain is the set of all possible values belonging to an attribute.
- the domain view shows the domains that are used by a given relation and is useful to the user for exploring how domains are used and shared among relations.
- the domain view shows which domains are in the database.
- the domain view also shows which relations have a particular domain as either a key or a non-key.
- the use of a particular domain as a key in one relation and as a non-key in another relation implies a possible access path between those two relations based upon the domain that they have in common.
- Display 1001 is a representative domain view with a grid 1003 of squares being its main feature. Each square of grid 1003 represents a domain. All of the domains defined for the database under analysis are listed in alphanumeric order.
- the domain view is linked to the over view for user navigation. Touching a relation in the over view with a cursor, for example relation RLls_lnk, causes all domains used by that relation to be visually highlighted.
- the non-key domains are highlighted with the same shade as the current shade of the selected relation bar in the over view, and the keys are with different shades than the non-keys in order to make them readily shaded distinguishable.
- a cursor for example relation RLls_lnk
- relation RLls_lnk has bc22, pn5, un21, un23, un25, and un29 as domains.
- domains un21 and un29 are keys and domains bc22, pn5, un23, and un25 are non-keys.
- Window buttons labeled "key” and "nonkeys" allow the user to limit the respective displaying of key domains only or non-key domains only. Touching a square in the domain view with a cursor causes a display of the domain and a short description in the domain view window. Clicking the mouse button on a square selects that domain for analysis causing relation bars of the relations that contain attributes using the selected domain to be displayed as highlighted in the over view window.
- FIG. 12 shows an over view, a relations view, a path view and an expanded code view all displayed in partially overlapping windows on a display screen. Those views that are displayed together are linked such that cursor motion and selection in one view will have coordinated interactive results in the other open views.
- the shading that appears in the over view is also linked, considering of course the exceptions noted in the description to distinguish important characteristics, to visually aid the user's analysis of the database.
- the interactive visualization method and apparatus of the present invention provides an overall view of the entire relational database.
- the individual relations are categorized according to structural characteristics, such as number of attributes in a relation, number of tuples in a relation, number of bytes in a relation, access method to the relation, distribution of the relation in the database, software application that the relation is used by, logical entity that contains the relation, and the type of storage used for the relation.
- This is the initial structure shown.
- the characteristic may be explicitly defined or this may be an implicit relationship extracted by analysis tools specifically to find such relationships.
- the overall view is purely structural without semantic details to clutter it. If semantic details are desired, they are available in views called the specification view and the code view.
- the associations could be extracted from the database query language with an A* version (A* is a combination of pattern matching that is based on AWK, and parsing that is based on YACC which allows AWK style pattern matching to be applied to grammar productions of a language specified with a YACC grammar) built for that language grammar.
- A* is a combination of pattern matching that is based on AWK, and parsing that is based on YACC which allows AWK style pattern matching to be applied to grammar productions of a language specified with a YACC grammar
- the associations are also preprocessed using FIT, a general-purpose, interpreted programming language that provides good facilitates for text processing and complex data structures.
- Paths are calculated from associations by a C program and the source code references to the relations are extracted from a Cscope database (Cscope is a well known code browser).
- Cscope is a well known code browser.
- the visual displays of the preprocessed information use Motif for windows. For non-UNIX systems equivalent software programs and tools would be necessary.
- a source code listing of a program which along with computer 101, provides the method and apparatus of the present invention is as follows.
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A method and apparatus for visually displaying structural characteristics of a large database for visualizing areas where new developments may be added, or finding places where old developments may need to be re-structured or replaced. This method and apparatus shows the entire structure without showing the entire semantics, which would be too much information. Semantic information is available in other windows that can be opened after the focus of the analysis is selected. After selection, the semantic information is displayed in a focused manner also. This is accomplished by referencing the selected relation to the location of that relation in the database specification or in the RDBMS application code.
Description
- The invention concerns graphical displays for visualing useful characteristics of large databases, in general, and graphical displays for visualizing structures and relationships within large databases, in particular.
- Each relational database consists of data arranged in one or more relations. Each relation consists of one or more attributes and one or more tuples. For two dimensional relational databases, the relations can be represented by tables, the attributes by columns of the tables and the tuples by rows of the tables. Large databases typically have a straightforward structure that is explicitly defined. However, even a database that is well defined explicitly may still have a high degree of complexity because of the amount of data it stores, the number of relations it contains, the number of relationships between relations or the mapping between displayed views and physical storage. This is especially true of so called "legacy" databases that have existed and evolved for a decade or more.
- In addition to the explicitly defined structure, each database has an implicitly defined structure. Implicit structure occurs when the same data item or characteristic, such as an attribute or tuple, appears in two or more separate places. This implicit structure is a type of meta data that is very useful for defining objects or simply accessing data in a way different than the way contemplated in the explicit definition. An association exists implicitly where data of the same type, or domain, occurs in separate relations. An example of an association between two relations is one in which a non-key attribute in one relation is a key attribute in another relation. Associations are connections where relational joins may be made.
- Collections of relations are often used to define objects. However, such collections are rarely explicitly defined. In such cases, implicit associations between relations many times are used to define collections of relations, which in turn are used to define objects.
- Finding the implicit structures and associations within a large database with known techniques is a challenging task for many reasons. First, the total size and complexity of the database may make it difficult to understand. Second, the evolution of the database, i.e. changes, in response to changing requirements may degrade both its implicit and explicit structure. Third, the usual technique for tracking implicit structures in relational databases, Entity Relationship Diagrams or ERDs, is inefficient when used on small databases and does not easily scale up for use on large databases. An ERD explicitly defines entities, e.g. objects, as needed, and the relationships and associations between the entities. The ERD graphically represents relationships and associations as a network. Both the entities and the associations are given names. Thus, the ERD techniques adds what amounts to an additional layer of semantics and definitions to a database: a complex layer that must be maintained along with the database, thereby adding more work to each change to the relational database. Even with the extra work, for large databases the graphical representations typically are too busy and cluttered to be helpful to a software engineer trying to visualize a large database.
- Another known relational database visualization technique is a graphic automated presentation tool (APT) by Mackinlay. APT designs static, two dimensional presentations of relational information. To use APT, a formal characterization of the semantic relational information and precision visual presentation requirements are necessary. APT is an automated system that has a prescriptive mechanism for designing each two dimensional graphic presentation with some user input (usually of less than the entire database). However, unless the user knows exactly where he or she should be looking and can formally characterize the semantic relational information at that point, the resulting static two dimensional graphic from the APT presentation system will not be very helpful for analyzing large databases. A lot of trial and error will be needed unless the user is extremely lucky.
- Therefore, there is a long felt need in the art for a method and apparatus for displaying characteristics of a database without semantic information such that explicit and implicit data structures can be readily observed to facilitate use, development and maintenance of large databases.
- Briefly stated, the aforementioned problem is solved and an improvement over the known techniques by providing a method and apparatus for displaying statistics and characteristics of an entire relational database in one overall view without any semantic information to clutter the display and confuse the viewer. The semantic information, which is purposefully omitted from the overall view, is provided in additional views that are interactively linked to the overall view and to each other.
- According to another aspect of the invention, the aforementioned problem is solved and an improvement over the known techniques is achieved by providing a method for displaying information about a relational database. The method includes a number of steps. Initially, each relation of a plurality of relations in the relational database is identified. Next, for each relation, a respective number of structural characteristics contained in the relation is determined. Also, for each relation, a key structural characteristic for accessing that relation is determined. The plurality of relations is then categorized according to their key structural characteristics. Next, the plurality of relations is visually presented in categories according to their key structural characteristics with each relation being represented by a respective bar whose length is representative of the number of the structural characteristics contained therein.
- FIG. 1 is a block diagram of a computer system for analyzing a relational database according to the present invention.
- FIG. 2 is a gray scale representation of a typical display of an over view according to the present invention.
- FIG. 3 is a gray scale representation of a typical display of a specification view according to the present invention.
- FIG. 4 is a gray scale representation of a typical display of an associations view according to the present invention.
- FIG. 5 is a block diagram showing the locational encoding of the information displayed in the association view shown in FIG. 4.
- FIG. 6 is a gray scale partial expansion of the associations view shown in FIG. 4.
- FIG. 7 is a gray scale representation of a typical display of a path view according to the present invention.
- FIG. 8 is a gray scale representation of a typical code sub-tree display of a code view according to the present invention.
- FIG. 9 is a gray scale representation of a typical display of a layout view according to the present invention.
- FIG. 10 is a gray scale representation of a typical display of a domain view according to the present invention.
- FIG. 11 is a gray scale representation of an over view as in FIG. 2, with two cursors active.
- FIG. 12 is a gray scale representation of an over view display overlaid with a specification view, a path view, and an associations view.
- Referring now to FIG. 1, a block diagram of an example of a relational
database analysis system 101 is shown. Thesystem 101 includesterminal 103, which provides output to and receives input from a user of the system,processor 113, which performs the actual analysis operations,memory system 115, which containsprograms 117 executed byprocessor 113 and relations 119₁ - 119i, each of which contains a respective set of attributes and tuples. Thesystem 101 also has amass storage system 120 for storing the relational database, its specifications and the relational database management system or systems (RDBMS) used to query, process and extract information from the relational database. The RDBMS is one of theprograms 117. - In more detail,
terminal 103 includes adisplay screen 105, upon whichprocessor 113 displays information for the user.Display screen 105 also includes acursor 107, which specifies a location indisplay 105 and may be moved under control of eitherkeyboard 109 ormouse 111. The operator controls the operation ofsystem 101 by inputs fromkeyboard 109 and/ormouse 111.Processor 113 may be any kind of processor, from a personal computer through a workstation or even a super computer.Memory system 115 includes any data accessible tosystem 101, and may thus include random-access memory and/or read-only memory. Connected tomemory system 115 ismass storage system 120 from which data is read intomemory system 115 to make such data more accessible, or into which data is stored, e.g. for the long term.Mass storage system 120 may include magnetic disk and/or optical disk. - When employing
computer system 101 to analyze a large relational database, the user may usekeyboard 109 ormouse 111 as input devices.Processor 113 executesprograms 117 as required to perform the analysis on the relational database and graphically displays the results ondisplay screen 105. The user can then usekeyboard 109 and/ormouse 111 to interactively examine the results in more detail, or call up other linked displays to obtain more information. - The preferred embodiment of
system 101 runs under the UNIX operating system (UNIX is a registered trademark of UNIX Systems Laboratories) using a workstation, such as a SUN workstation, manufactured by SUN Microsystems, using an X Windows System for workstation applications. (X-Windows is a trademark of Massachusetts Institute of Technology). - Referring now to FIGS. 1 and 2, a
display 201 is shown ondisplay screen 105.Display 201 is an over view, which is the highest view level of the large relational database. The large relational database may contain over 1,000 relations comprising over 10,000 attributes.Display 201 has approximately 1,200 relations shown in multiple columns. Each relation is represented by a bar. The size of thedisplay screen 105 and the graphic resolution of thecomputer system 101 determine the smallest relational bar and the largest database that may be displayed in its entirety. Preferably, all the relations of the entire database could be represented in the over view. The presentation of all the relations on a single screen gives the user a unifying perspective of the database that allows software personnel to understand how a single relation fits into the structure of the whole database. However, if the graphic limit ofcomputer system 101 anddisplay screen 105 is exceeded, some scrolling of the relations could be used without degrading the overall perspective. - The relations of
display 201 are arranged according to their structural characteristics under control of the user. Indisplay 201 the relations are displayed alphanumerically from 0-9 and from A-Z according to the designation of their access. Since there are no relations having access methods beginning with a numeric character or letters A-B, the first category of relations is a category having access CIND, as shown by the designation CIND next to the first relation shown in the left most column. All of the relations having CIND are listed in alphanumeric order from the upper left of the left most column to over half way down the third column from the left. The remaining columns have similarly organized listings for relations having accesses designated DD, DHSH, DIR, IND, LIN and OPV. - To assist the user in visualizing the commonality among relations that have the same access, the relations in each category may be commonly shaded or colored, such as violet for relations with CIND accesses. Relations having different accesses may have different shading or coloring, such as accesses DD, DHSH, DIR, IND, LIN and OPV having blue, emerald green, lime green, yellow, light red and dark red, respectively. If color is not available or desired, different shades of gray and patterns as shown in FIG. 2 are used instead.
- Each relation in FIG. 2 is represented by a bar whose length is dependent upon a statistic of the relation, for example the number of attributes, tuples, or bytes in a tuple in the relation. When a relation bar is touched by the cursor 107 (see FIG. 1) it is highlighted to a color or gray shade that contrasts with the adjacent relation bars, such as
relation bar 203. The highlighted color or shade is an indication that this particular relation has been selected for closer examination. Upon selection, the name or designation of the selected relation appears in adesignation box 205. The selectedrelation bar 203 corresponds to the relation designated RLls_lnk. Immediately below thedesignation box 205 are three boxes that provide statistics for the number of columns (i.e. attributes) in the selected relation, which for RLls_lnk is shown to be 10; the maximum number of tuples, which is shown to be 256; and the size of each tuple, which is shown to be 12 bytes. - Across the top of
display 201 are a number of activity buttons which maybe activated by the cursor to provide additional information about the selected relation, in this case relation RLls_lnk. The buttons are labeled: Assocs (abbreviation for Associations), Paths, Code, PRL (abbreviation for Population Rule Language, commonly referred to as the Specification View), Layout, Relations List, Domains, Entity, and Distance. Each of these buttons, except Distance, may be used to open another window on the screen 105 (see FIG. 1) which displays another view of the relational database under analysis. - Referring now to FIG. 3, a
display 301 is shown ondisplay screen 105 that is called the specification view. In the specification view the actual specification(s) of the database in the database description language or languages that are understood by the RDBMS may be directly viewed. The method and apparatus according to the present invention preprocesses existing explicit descriptions of the relations in the database and the RDBMS application source code, including predefined queries of the database, into a reference file used by the display portion of the database analysis system. The specification view accesses this reference file when activated. Whendisplay 301, the specification view is activated while a selection of a relation indisplay 201 is still active, then the specification view opens up to the selected relation, in this example RLls_lnk. This allows the descriptions of relations and the source code form of queries to be viewed directly in the context of the selected relation. In the specification view, queries shown declaring associations between relations in the query have that portion of thedisplay 301 highlighted by a contrasting color or shade of gray. - The
display 301 is typically less than a full screen in size in order to provide interaction with one or more other displays, but may be expanded to occupy the entire display screen if desired. The specification view is interactively linked to the over view such that a change of the selected relation in one will cause an automatic and nearly immediate change to the new selected relation in the other. - Referring now to FIG. 4, display 401 is an associations view. The associations view shows the associations between the selected relation and other relations of the database through queries and other mechanisms supported by the RDBMS. This view is used to discover associations between relations. Shown in the associations view are the selected
relation 403, RLls_lnk; the associated relations defined in the database specifications; and the type of association between the selected relation and the other relations. - The selected
relation 403 is located in the center of display 401. In this example, it has ten attributes, lsnum, member, lnkgrp, lnkgrpmem, unitnum, master, dfinum, sdl_sm, st_dlt, and sdl_port. The associatedrelations relation 403. The location of each of the relations 405-415 visually indicates to the user the type of association it has with the selectedrelation 403. FIG. 5 shows an example of a directional, positional encoding scheme used in display 401, although alternative positional schemes could be used as long as the user understands the encoding scheme. A strong association means that the association may be used as an access path to directly find a tuple in the associated relation. A tuple may be directly accessed if the associated relation provides a complete key attribute to the target relation. A strong association contains a complete key. A weak association contains only an incomplete key attribute and cannot be directly used to access a tuple. Weak associations may be used if the user understands how to complete the incomplete key attribute, or if it can be used for a sequential search. Constraints, such asrelation 415, are limitations and are shown for information only since they do not provide accesses. To further enhance the visual transfer of information to the user, each of the relations in the relational view is colored or gray shaded according to a characteristic, such as its respective access, just as in overview display 201. - To analyze any of the associated relations 405-415 closer, a second selection can be made with the cursor (not shown) and if that is done. display 601 as shown in FIG. 6 appears. Referring now to FIGS. 4 and 6, the display of first selected
relation 403 has change slightly to the display of first selectedrelation 603. The display of second selectedrelation 409 has changed and expanded to the display of the second selectedassociation 609 and its expandedform association 6091 with attributes 6092-60913. In this partially expanded associations view 601, attributes 6032 and 6033 have coordinated shading to show their linkage toattributes - When
display 601 is opened, an array of rectangles 620-622 are displayed along its bottom edge. These rectangles 620-622 represent the number queries or database specifications where this particular association is mentioned. Taken together, the rectangles 620-622 form an association selector. Pointing to any of the rectangles 620-622 in the association selector causes that association between the selected relations to be displayed in FIG. 6. Different attributes may be involved in different places where the association is mentioned, so the user is offered both for viewing. - If
display 601 anddisplay 301, the specification view, are open at the same time and use the same cursor (not shown), the two will be linked and the specification view will be scrolled to the location where the association between the tworelations - If over
view display 201 is active, a touch of any relation in display 401 or display 601 with a cursor will select the corresponding relation in overview display 201. When a relation is selected in overview display 201, its designation, characteristics and statistics are displayed there also. - Referring now to FIG. 7,
display 701, which may be either full screen, or one of many active windows displayed on thedisplay screen 105, is a path view. Thepath view display 701 visually presents all of the shortest paths connecting any two selected relations. In this manner the present invention is a great improvement over techniques, such as ERD which shows many more paths and many more relations than necessary and thereby becomes needlessly confusing and complex. In FIG. 7, the shortness of a path is mesured in terms of the number of joins, i.e. steps, required to traverse the path to the selected relation. Only strong paths based on steps made up of strong associations are shown in the path view. This means that each path shown may be used as an access without the further considerations required by weak associations. Since there is always at least one shortest path to any relation, FIG. 7 visually presents to the user an access path between any two relations. - Access paths are shown as a directed network in the path view. When the path view is opened, two
cursors cursors frame 703 of the path view window and also the color(s) or gray shades of highlighted outlines around the tworelations box 705, in the path view, that box is highlighted, and the corresponding cursor in the over view moves to the corresponding relation bar, such asrelation bar 203, and the relations bar is highlighted. Furthermore, the characteristics and statistics of this selected relation are shown in the over view. Normally, the coloring or gray shading of the relations in the path view will be the same as the coloring or gray shading of the relations in the over view; however, the coloring or gray shading of the relations in the over view may be changed so it is different from the path view in order to see which relations have those characteristics. By activating the Distance button on the over view display, relations in the over view may be colored or gray shaded according to how many steps from an originating relation there are in an access path. - The path view may be linked to the association view by the user by attaching both views to the same cursor. If this is accomplished, the relations in both views become linked. In such a case, touching a relation in the path view with the cursor highlights that relation in the association view as well as the path view. Clicking the mouse button on the highlighted relation in the path view is equivalent to clicking the mouse button on the same relation in the association view, i.e., the association is shown in an expanded form as shown in FIG. 6.
- Referring now to FIG. 8, a
display 801 is shown ondisplay screen 105 that is called the code view. The code view displays the application source code of the RDBMS that uses the currently selected relation, in this case relation RLls_lnk. The application source code may be represented as a horizontal tree representing the code hierarchy. The subset or subsets of that horizontal code tree that use the currently selected relation are displayed in the code view. - The code view may be used by the user to find the application source code which references a relation and also to find where in the application source code the relation is accessed. The code view is linked to the over view such that all relations accessed from a unit of application code may be easily identified. Each unit of application code is represented by a box in the code view. Touching any code box with a cursor causes that box to be highlighted and its designation to be displayed. For example,
code box 803 has been touched by a cursor (not shown) and is now highlighted by a contrasting color to the light blue of the rest of itscode sub-tree 805, and its designation (CCs7text.bp) is shown indisplay area 807. Clicking the mouse button on a code box highlights in the over view all relations that use the corresponding unit of code. - If there are multiple applications that use the same relation, the result will be multiple code sub-trees in the code view, as
sub-trees - Clicking the mouse button on a leaf of a code sub-tree opens a scrolling window which contains the text of the code with the text scrolled to a location in which the currently selected relation is accessed. Since a relation may be accessed multiple times by a unit of code, multiple locations are shown by using a location bar appearing on the right side of the scrolling window next to the scroll bar. Red or light gray lines appearing in the location bar (not shown) indicate the multiple locations. Clicking on a box in the tree highlights all relations on the over view that are accessed by that code.
- Referring now to FIG. 9, a
display 901 is shown in a window ondisplay screen 105 that is called the layout view. The layout view shows the physical layout in memory of a tuple of a relation, as well as, the relative sizes of attributes of the relation.Display 901 shows atuple 903 and attributes of the currently selected relation RLls_lnk. Attributes lsnum, lnkgrp, dfinum, sld_sm, st_dlt, and sdl_port are represented by rectangles and the size of each rectangle is proportional to the size of its respective attribute. Aframe 905 of this window is colored or gray shaded the same way that the selected relation to which it corresponds is colored or gray shaded in the other views, for the example of relation RLls_lnk, this highlight shade is dark gray. - Referring now to FIG. 10, a
display 1001 is shown in a window ondisplay screen 105 that is called the domain view. A domain is the set of all possible values belonging to an attribute. The domain view shows the domains that are used by a given relation and is useful to the user for exploring how domains are used and shared among relations. The domain view shows which domains are in the database. The domain view also shows which relations have a particular domain as either a key or a non-key. The use of a particular domain as a key in one relation and as a non-key in another relation implies a possible access path between those two relations based upon the domain that they have in common. -
Display 1001 is a representative domain view with agrid 1003 of squares being its main feature. Each square ofgrid 1003 represents a domain. All of the domains defined for the database under analysis are listed in alphanumeric order. The domain view is linked to the over view for user navigation. Touching a relation in the over view with a cursor, for example relation RLls_lnk, causes all domains used by that relation to be visually highlighted. The non-key domains are highlighted with the same shade as the current shade of the selected relation bar in the over view, and the keys are with different shades than the non-keys in order to make them readily shaded distinguishable. For thedisplay 1001 shown in FIG. 10, relation RLls_lnk has bc22, pn5, un21, un23, un25, and un29 as domains. Of these, domains un21 and un29 are keys and domains bc22, pn5, un23, and un25 are non-keys. Window buttons labeled "key" and "nonkeys" allow the user to limit the respective displaying of key domains only or non-key domains only. Touching a square in the domain view with a cursor causes a display of the domain and a short description in the domain view window. Clicking the mouse button on a square selects that domain for analysis causing relation bars of the relations that contain attributes using the selected domain to be displayed as highlighted in the over view window. - Thus far, the over view, the specification view, the relations view, the path view, the code view, the layout view and the domain view have all been described. The specification view, the relations view, the path view, the code view, the layout view and the domain view have all been described as being linked to the over view. Further, since all of the views are windows, all or a sub set of the views may be displayed at any one time. For example, FIG. 12 shows an over view, a relations view, a path view and an expanded code view all displayed in partially overlapping windows on a display screen. Those views that are displayed together are linked such that cursor motion and selection in one view will have coordinated interactive results in the other open views. Moreover, the shading that appears in the over view is also linked, considering of course the exceptions noted in the description to distinguish important characteristics, to visually aid the user's analysis of the database.
- The interactive visualization method and apparatus of the present invention provides an overall view of the entire relational database. The individual relations are categorized according to structural characteristics, such as number of attributes in a relation, number of tuples in a relation, number of bytes in a relation, access method to the relation, distribution of the relation in the database, software application that the relation is used by, logical entity that contains the relation, and the type of storage used for the relation. This is the initial structure shown. The characteristic may be explicitly defined or this may be an implicit relationship extracted by analysis tools specifically to find such relationships. The overall view is purely structural without semantic details to clutter it. If semantic details are desired, they are available in views called the specification view and the code view. If further structural details of a particular relation are desired, further details are available in the associations view, the path view, the code view and the domain view. The linking of the views makes them interactive with each other such that changes to one view causes corresponding changes in the other actively linked views. This not only speeds up analysis, but also gives the user a chance to analyze the effects of any changes, e.g. definition of a new object, on the relational database system.
- To speed up the response of the
computer system 101 to user inputs such as cursor touches or mouse button clicks, all the information that might be visually displayed is extracted from the database schema, database specifications and queries, and application source code before the visual analysis is begun. For any type of database, the associations could be extracted from the database query language with an A* version (A* is a combination of pattern matching that is based on AWK, and parsing that is based on YACC which allows AWK style pattern matching to be applied to grammar productions of a language specified with a YACC grammar) built for that language grammar. The associations are also preprocessed using FIT, a general-purpose, interpreted programming language that provides good facilitates for text processing and complex data structures. Paths are calculated from associations by a C program and the source code references to the relations are extracted from a Cscope database (Cscope is a well known code browser). The visual displays of the preprocessed information use Motif for windows. For non-UNIX systems equivalent software programs and tools would be necessary. -
- Thus, it will now be understood that there has been disclosed a method and apparatus for displaying structures and characteristics of a large relational database. While the invention has been particularly illustrated and described with reference to preferred embodiments thereof, it will be understood by those skilled in the art that various changes in form, details, and applications may be made therein. For example, the invention was described as using preprocessed data to make the method more time responsive; however, real time processing could be used just as well and, depending on the real time processing power of the host system, the small delays ignored.
Claims (23)
- A method for displaying information about a relational database comprising the steps of:
identifying each relation of a plurality of relations in the relational database;
determining for each relation a respective number of occurrences of a specific data item contained therein;
determining for each relation a key structural characteristic for access to that relation;
categorizing the plurality of relations according to their key structural characteristics;
visually displaying the plurality of relations in categories according to the key structural characteristics thereof; and
visually displaying for each relation of the plurality of relations a respective bar that is representative of the number of occurrences of the specific data item contained therein. - The method as set forth in claim 1, further comprising the step of:
coloring each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics. - The method as set forth in claim 2, further comprising the step of:
arranging the relations according to their respective key structural characteristic in alphanumeric order. - The method as set forth in claim 1, further comprising the steps of:
coloring each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics;
visually displaying a cursor that is operator controllable over the display area; and
changing the coloring of a visual display of a relation with which the cursor is actively contacting to indicate a selection thereof for a display of further information. - The method as set forth in claim 4, further comprising the step of:
displaying an additional view in an active window displaying further information about the cursor-selected relation. - A method for displaying information about a relational database comprising the steps of:
identifying each relation of a plurality of relations in the relational database;
determining for each relation a respective number of a user selected data item contained therein;
determining for each relation a key structural characteristic for access to that relation;
sorting the plurality of relations according to their key structural characteristics;
visually displaying in an over view the plurality of relations categorized according to the key structural characteristic thereof; and
visually displaying in the over view for each relation of the plurality of relations a respective bar that is representative of the number of the user selected data item therein. - The method as set forth in claim 6, further comprising the step of:
coloring each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics. - The method as set forth in claim 7, further comprising the step of:
arranging the relations in the over view according to their respective key structural characteristic in alphanumeric order. - The method as set forth in claim 6, further comprising the steps of:
coloring in the over view each display of each relation that has the same key structural characteristic with a common color that is different from the coloring of the relations of the other key structural characteristics;
visually displaying in the over view a cursor that is operator controllable over the display area; and
changing the coloring of a visual display of a relation with which the cursor is actively contacting to indicate a selection thereof for a display of further information in another view. - The method as set forth in claim 9, further comprising the step of:
displaying an additional view in an active window that displays further information about the cursor-selected relation. - The method as set forth in claim 10, further comprising the step of:
as the cursor selects a different relation in the over view, displaying in the additional view further information of the different relation in the active window. - The method as set forth in claim 9, further comprising the steps of:
displaying a specification view having specifications of the selected relation from the specification of the large database in an active window. - The method as set forth in claim 9, further comprising the steps of:
displaying an associations view showing the selected relation and its attributes in a center portion of an active window;
locating along a first side of the selected relation are one or more relations from which access to the selected relation can be provided
locating along a second side opposite the first side are one or more relations to which access from the selected relation can be provided. - The method as set forth in claim 9, further comprising the steps of:
displaying an associations view showing the selected relation and its attributes in a center portion of an active window;
locating along a first side of the selected relation are one or more relations from which access to the selected relation can be provided
locating along a second side opposite the first side are one or more relations to which access from the selected relation can be provided; and
locating along a top edge are one or more relations that can provide both access to and access from the selected relation. - The method as set forth in claim 9, further comprising the step of:
displaying a code tree view showing a subtree of a source code tree that accesses the selected relation in an active window. - The method as set forth in claim 9, further comprising the step of:
displaying a memory layout view showing a memory layout of the selected relation and its attributes in an active window. - The method as set forth in claim 9, further comprising the steps of:
displaying a domain view showing all defined domains of all of the attributes of the database in an active window; and
highlighting each domain of the attributes of the selected relation in a different color than the other domains. - The method as set forth in claim 9, further comprising the steps of:
displaying a path view showing the selected relation in an active window;
selecting a second selected relation;
showing the second relation in the path view active window;
locating the selected relations opposite one another; and
displaying a shortest access paths between the selected relations. - The method as set forth in claim 18, further comprising the step of:
matching the colors of a frame of the active path view active window with the colors of the first and second selected relations in the over view. - The method as set forth in claim 19, further comprising the step of:
matching the colors of a frame of the active path view active window with the colors outlining boxes representing the first and second selected relations in the path view. - Apparatus comprising:
a large database having at least one thousand relations, each relation having a set of structural characteristics;
each set of structural characteristics having a key structural characteristic that is used to access its respective relation;
means for visually displaying a plurality of views, each view appearing in an active window that can be sized from covering a fraction of the display area to covering the entire display area or turned off;
means for counting a number of occurrences of a user selected data item for each relation; and
means for visually displaying the plurality of relations, each relation of the plurality of relations is categorized according to its respective key structural characteristic in a first view and represented by a bar having a length that represents the number of occurrences of the user selected data item in the relation. - Apparatus comprising:
a processor;
a random access memory;
a mass storage device having a database with a plurality of relations stored therein; and
display means for visually displaying non-textual graphic representations of said relations derived from said database. - The apparatus of claim 22, wherein the plurality of relations are sorted according to a key structural characteristic of a user selected type each relation and relations having the same key structural characteristic of the user selected type are assigned a distinctive color to distinguish them from the relations having other key structural characteristics of the user selected type.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US269221 | 1988-11-09 | ||
US08/269,221 US5572650A (en) | 1994-06-30 | 1994-06-30 | Method and apparatus for displaying structures and relationships of a relational database |
Publications (1)
Publication Number | Publication Date |
---|---|
EP0697667A1 true EP0697667A1 (en) | 1996-02-21 |
Family
ID=23026325
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
EP95304315A Ceased EP0697667A1 (en) | 1994-06-30 | 1995-06-21 | Method and apparatus for displaying structures and relationships of a relational database |
Country Status (2)
Country | Link |
---|---|
US (1) | US5572650A (en) |
EP (1) | EP0697667A1 (en) |
Families Citing this family (26)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5983220A (en) * | 1995-11-15 | 1999-11-09 | Bizrate.Com | Supporting intuitive decision in complex multi-attributive domains using fuzzy, hierarchical expert models |
US5796398A (en) * | 1996-03-08 | 1998-08-18 | Ncr Corporation | Information visualization icons |
US5701460A (en) * | 1996-05-23 | 1997-12-23 | Microsoft Corporation | Intelligent joining system for a relational database |
US6600481B1 (en) * | 1996-06-10 | 2003-07-29 | Glenayre Electronics, Inc. | Data entry apparatus and method |
US5721911A (en) * | 1996-06-25 | 1998-02-24 | International Business Machines Corporation | Mechanism for metadata for an information catalog system |
US5892510A (en) * | 1996-07-02 | 1999-04-06 | Sun Microsystems, Inc. | Field objects and a method for developing a graphical user interface containing the field objects |
US6112194A (en) * | 1997-07-21 | 2000-08-29 | International Business Machines Corporation | Method, apparatus and computer program product for data mining having user feedback mechanism for monitoring performance of mining tasks |
US6356285B1 (en) | 1997-12-17 | 2002-03-12 | Lucent Technologies, Inc | System for visually representing modification information about an characteristic-dependent information processing system |
US6345258B1 (en) | 1997-12-30 | 2002-02-05 | William E. Pickens | Information system for new home builders |
US6243862B1 (en) * | 1998-01-23 | 2001-06-05 | Unisys Corporation | Methods and apparatus for testing components of a distributed transaction processing system |
US6489979B1 (en) | 1998-10-30 | 2002-12-03 | International Business Machines Corporation | Non-computer interface to a database and digital library |
US6978269B1 (en) * | 1999-07-13 | 2005-12-20 | International Business Machines Corporation | Apparatus and method for generating and displaying a schema diagram for a database |
AUPQ498500A0 (en) * | 2000-01-07 | 2000-02-03 | Flixco Pty Limited | Information system |
AU767847B2 (en) * | 2000-01-07 | 2003-11-27 | Flixco Pty Limited | Information system |
US7110936B2 (en) * | 2001-02-23 | 2006-09-19 | Complementsoft Llc | System and method for generating and maintaining software code |
AUPR621201A0 (en) * | 2001-07-06 | 2001-08-02 | Flixco Pty Limited | Information system |
US7069343B2 (en) * | 2001-09-06 | 2006-06-27 | Avaya Technologycorp. | Topology discovery by partitioning multiple discovery techniques |
US7200122B2 (en) * | 2001-09-06 | 2007-04-03 | Avaya Technology Corp. | Using link state information to discover IP network topology |
US7571239B2 (en) | 2002-01-08 | 2009-08-04 | Avaya Inc. | Credential management and network querying |
US7426577B2 (en) * | 2003-06-19 | 2008-09-16 | Avaya Technology Corp. | Detection of load balanced links in internet protocol netwoks |
US7259763B2 (en) * | 2003-11-13 | 2007-08-21 | International Business Machines Corporation | Embedded analytics in information visualization |
US20070162409A1 (en) * | 2006-01-06 | 2007-07-12 | Godden Kurt S | Creation and maintenance of ontologies |
US7924810B2 (en) * | 2007-06-21 | 2011-04-12 | Hewlett-Packard Development Company, L.P. | Method and computing system for controlling access |
US8276113B2 (en) * | 2008-08-11 | 2012-09-25 | International Business Machines Corporation | Dynamic highlighting of related artifacts in a UML diagram |
US9501849B2 (en) * | 2012-05-11 | 2016-11-22 | Vmware, Inc. | Multi-dimensional visualization tool for browsing and troubleshooting at scale |
US9576020B1 (en) | 2012-10-18 | 2017-02-21 | Proofpoint, Inc. | Methods, systems, and computer program products for storing graph-oriented data on a column-oriented database |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5301313A (en) * | 1990-07-17 | 1994-04-05 | Sanyo Electric Co., Ltd. | Manipulating data in a relational data base having operational manipulations defined in an input table and displayed results in an output table with a line displayed designating direction of data flow |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5442690A (en) * | 1992-08-25 | 1995-08-15 | Bell Communications Research, Inc. | Telecommunication service record structure and method of execution |
US5430870A (en) * | 1992-10-13 | 1995-07-04 | Sun Microsystems, Inc. | Saving and restoring traversal state attributes of a directed acyclic graph structure network for a parent structure when it invokes a child structure for traversal |
-
1994
- 1994-06-30 US US08/269,221 patent/US5572650A/en not_active Expired - Lifetime
-
1995
- 1995-06-21 EP EP95304315A patent/EP0697667A1/en not_active Ceased
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5301313A (en) * | 1990-07-17 | 1994-04-05 | Sanyo Electric Co., Ltd. | Manipulating data in a relational data base having operational manipulations defined in an input table and displayed results in an output table with a line displayed designating direction of data flow |
Also Published As
Publication number | Publication date |
---|---|
US5572650A (en) | 1996-11-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5572650A (en) | Method and apparatus for displaying structures and relationships of a relational database | |
US8776023B2 (en) | Software testing | |
US6831668B2 (en) | Analytical reporting on top of multidimensional data model | |
US5644692A (en) | Information display apparatus and methods | |
KR100214911B1 (en) | Data searching method | |
US6377287B1 (en) | Technique for visualizing large web-based hierarchical hyperbolic space with multi-paths | |
US7734576B2 (en) | Apparatus and method for relating graphical representations of data tables | |
US5894311A (en) | Computer-based visual data evaluation | |
US6263339B1 (en) | Dynamic object visualization and code generation | |
US5999192A (en) | Interactive data exploration apparatus and methods | |
US5864856A (en) | Process and apparatus for simplifying access to information stored in databases | |
US6915301B2 (en) | Dynamic object properties | |
US5603025A (en) | Methods for hypertext reporting in a relational database management system | |
AU768367B2 (en) | Property based context portals | |
US6216138B1 (en) | Computer interface system for automatically generating graphical representations of computer operations linked together according to functional relationships | |
US5412774A (en) | Apparatus for and method of displaying a data item of a database using the display function of a selected data item | |
US5636350A (en) | Using symbols whose appearance varies to show characteristics of a result of a query | |
US5892510A (en) | Field objects and a method for developing a graphical user interface containing the field objects | |
US20060224998A1 (en) | Multi-dimensional systems and controls | |
JPH05290098A (en) | Generation method for database inquiry | |
JP3066681B2 (en) | Apparatus and method for graphically displaying related information in relational database | |
US5544298A (en) | Code generation and data access system | |
US20020147725A1 (en) | Method and apparatus for database table definition | |
US5671379A (en) | System and method for managing windows | |
US7080086B2 (en) | Interaction with query data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PUAI | Public reference made under article 153(3) epc to a published international application that has entered the european phase |
Free format text: ORIGINAL CODE: 0009012 |
|
AK | Designated contracting states |
Kind code of ref document: A1 Designated state(s): DE FR GB IT |
|
17P | Request for examination filed |
Effective date: 19960812 |
|
17Q | First examination report despatched |
Effective date: 19990826 |
|
STAA | Information on the status of an ep patent application or granted ep patent |
Free format text: STATUS: THE APPLICATION HAS BEEN REFUSED |
|
18R | Application refused |
Effective date: 20050317 |