Patent ep0560543a2 – computer user interface for relating key and index properties to database … – google patents

A particularly complex aspect of database organization relates to the creation and use of keys, and particularly the linking of keys between multiple tables to ensure referential integrity. Database diagram tool Referential integrity helps enforce data integrity within the database system by setting constraints on the database table values, such that all references from one table to anotherare valid and accurate. Database field types Though the individual formats and functions of relational database primary keys and foreign keys (sometimes referred to as secondary keys) are described in user manuals, the actual relationships which they create within the tables are difficult to visualize in the manner that such keys are routinely used. Data recovery best buy For example, if a database has two tables of diverse information and uses telephone numbers in each of the tables to identify distinct rows in the tables, and the tables are related by such telephone numbers as a key, referential integrity ensures that the data in one table is not contaminated or destroyed by a change in the other table by linking for consistency.


Although the concepts of primary keys, foreign keys, and table indexes have existed for a long time in relational database technology, their efficient creation in a database which provides referential integrity can often be challenging. Raid 5 data recovery In general, the primary key is composed of one or more non-null columns which uniquely identify each row in a table. Database administrator salary nyc In the context of our earlier example, a column of telephone numbers could serve as a primary key to identify related addresses until such time that the table extended into different area codes. Database p Under such circumstances, the primary key would have to include both the area code column and the local telephone number column. Cloud 9 database The column or columns defining a foreign key reference a primary key. Data recovery on ssd In the typical situation where the foreign key is in a different table than the primary key, the table possessing the primary key is referred to as the parent table. Database query tools The value of each foreign key, in our example the combination of area code and local telephone number columns, must match one of the combined values in the associated primary key in the parent table. Database 2000 Thus, a table can have only one primary key, which itself can be composed of multiple columns, but can have a multiplicity of foreign keys related thereto.

Creating primary keys, foreign keys and indexes related thereto, is not only challenging but prone to error when accomplished in the context of present user interfaces for defining tables. Database business rules The conventional practice of defining tables with keys involves the use of text descriptions. Iphone 5 data recovery For example, according to the practice in the aforementioned IBM Extended Services for OS/2 Database Manager program, primary keys and foreign keys are defined by specific text statements to that effect. Database implementation Other commonly used practices, an example being the earlier noted Borland International Paradox program, mandates the placement of asterisks or other symbols adjacent descriptors of the columns during the definition of the table primary keys, and applies the concept of linking through borrowed columns to relate columns in othertables. Raid 1 data recovery software In either case, the names and properties of the columns which make up the table are specified in text listings of columns and their related properties. Seagate data recovery Thus, each table is treated separately and has its column names and properties defined by parallel adjacent lists, with table-to-table relationships integrated by text of coded symbol representation.

In a preferred practice of the invention, two or more matrices are depicted simultaneously in windows, or panes of a video display. Database report Table structure and property information is presented in at least one matrix, while other matrices simultaneously present the linking relationships between tables. Data recovery specialist In one form, the linking relationships are presented simultaneously in a succession of window panes. Data recovery iphone 6 In another form, the individualized linking relationships are selected and situated juxtaposed the table parameter listing. Database building The properties associated with each linking matrix are presented in a form that allows selectability, as well as selected addition, deletion and amendment of properties defined therein. Data recovery top 10 Thus, the user has concurrently available both the table structure information and the table relationship information, and in a graphically depicted form amenable to user friendly manipulation. Database hosting The user interface is particularly beneficial in the context of understanding foreign keys, in that the preferred implementation provides direct information regarding the affected columns, the other tables to which they relate, deletion rules, and translations of column equivalence.

A preferred set of general operational features for working within a set of windows analogous to figures 4-6 are set forth in the ensuing paragraph to confirm the ease and flexibility of the user interface. Data recovery best As an operation, double clicking with the cursor on a column icon always brings up the full definition of the column in a dialog box or similar presentation structure. Data recovery program Achange to a column, such as data type, will be reflected through all instances of the column within the table. 7 data recovery 94fbr A similar situation exists for the key icons, whereby double clicking on the corresponding primary or foreign key icon pulls up the related definition window. Database languages All matrix lists have a blank line at the bottom for new entries, unless the maximum size of the capacity of the definition table has been reached the database implementation sets the capactiy of each database table object definition, such as the number of columns allowed in a primary key. Database ranking As each line of information is entered, a corresponding icon is generated. Data recovery youtube Commit occurs when specifically commanded, with error locations highlighted. 911 database Achange in a column sequence number (see Figs. Data recovery download 8 and 9), results in a rearrangement of the rows to reflect the newly defined sequence in the database table. Data recovery after factory reset Columns can be copied from table to table by dragging on an icon and dropping it thereafter in a new location. Database schema design And finally, deletions of columns, keys or indexes could be made to require confirmation before commitment.

The foreign key definition window is used to create new foreign keys or to modify existing ones. Database uml When the user enters this window, the foreign key name will already be present. Data recovery ntfs New foreign keys are given a name in the foreign key list window before the user can get to the foreign key definition pane. Database error Though the name can be changed, the only way to delete a key is to delete the icon, in a manner to be described hereafter with reference to the foreign key list window, or by blanking out all the entries in the foreign key definition window. Database functions According to a preferred practice of the invention, the delete rules are selected from a pull-down list, and include as representative examples restrict, delete, cascade deletes, and set to null rules. Top 10 data recovery The parent table field in the window of Fig. Database job titles 4 allows the user to fill in a blank field or to select from a pull-down selection list of all available tables in the connected database. Data recovery linux live cd The parent table field also allows resources for the selection of a table by dragging and dropping of a table icon.

The structure of the foreign key list matrix appears in the window depiction of fig.6. S pombe database The contents of the matrix includes foreign key icons and corresponding foreign key names, including a conventional scrolling control mechanism for viewing a list of extended content. Database usa The foreign key list window provides a comprehensive list of all foreign keys for the table under consideration. Data recovery pro license key Double clicking on a foreign key icon calls up the corresponding foreign key definition window, such as that depicted in fig. Data recovery on android 4, where the user can modify or delete an existing foreign key or add a new key definition. Icare data recovery 94fbr To add a foreign key in the context of the foreign key list window in fig. Image database 6, one merely types the name and a foreign key icon will be created by the system, then double clicks on the foreign key icon to access the foreign key definition window for further entry of information. Database web application Removing a foreign key is accomplished by selecting the icon and initiating a delete function, or by dragging the icon to a delete icon.

A new table is defined using the screen presentation as appears in fig. Database graphic 8. In databases a category of data is called a This presentation can extend over the whole screen or can reside within a window on the screen. Database wordpress The nature of the information to be inserted into each of the columns is identified by headings at the top of each column. Note 2 data recovery The table name is entered by typing into the field identified as NEW. Tally erp 9 data recovery The properties of each column within the database table are defined line by line, where the example in fig. Database erd 9 shows data from the example tables following the definition of the third column, MGRNO. Database google docs To proceed to the next stage, the title bar icon, identified in fig. Database 5500 8, is selected. Data recovery kit In the context of our example, the user selects the “index” from the action list provided by the title bar icon. Database meaning The outcome appears in fig. Gale database 10. Data recovery pc Note in particular that the work area for defining index properties is windowed into a side by side arrangement with the table to which it pertains. Data recovery easeus Note that the matrix defining the structure of the table columns is visually linked by juxtaposition to the matrix serving to define the index characteristics. Top 10 data recovery software The column upon which the index will be based is selected by placing the cursor on the column icon for the column known as DEPTNO and dragging that icon to the index window. Database oracle The “duplicates not allowed” selection is also shown to have been made in the example index definition window.

Continuing in the context of the example, when the primary key tab is selected, the right window presents the image depicted in fig. Data recovery services reviews 11. Database 12c new features At this stage, the table matrix in the window at the left is situation juxtaposed the primary key matrix to be defined in the window at the right. Database lyrics Selection of DEPTNO as primary key is accomplished by clicking by mouse actuation on the corresponding icon from the matrix on the left and then dragging the icon into the first row of the notebook matrix of the primary key window. Database 360 A preferred implementation of the invention also contemplates that the user have immediate access back to the full contents of the base matrix of the table being manipulated. Database architect salary This is accomplished by selecting the column icon from the matrix on the left and double clicking with the mouse. Database administrator job description Thereupon, a dialog window is created with the full content of the row selected thereby. Data recovery app An example of this has not been specifically shown in the drawings given that it is readily understandable.

Creation of a structure to establish referential integrity follows. R database connection To accomplish this, the foreign key tab on the notebook control is selected and thereupon defines the foreign key dialog window depicted in figure 12 for the table EMPLOYEE. Database weak entity The foreign key relationship between the two tables is created in the context of the foreign key dialog window. Data recovery vancouver In the example of figure 12, the foreign key is given the name DEPT, a deletion restriction is imposed, and the parent table, DEPARTMENT, is identified. Level 3 data recovery Once the parent table named DEPARTMENT is entered, the third and fourth columns in the matrix of the dialog window are filled in with the name and type of the column in the primary key of the parent table. Database blob The corresponding column from the table EMPLOYEE, WRKDEPT, is dragged in conventional manner from the table property matrix at the left for insertion into the second column of the dialog window matrix. Database examples Since the columns WRKDEPT and DEPTNO match in data properties and content, the foreign key will be accepted as valid upon commitment.

banner