Interactive error handling means in database management

• US 4,888,690 A
• Filed: 03/21/1988
• Issued: 12/19/1989
• Est. Priority Date: 01/11/1985
• Status: Expired due to Term

• Current Assignee: Intel Corporation
• Original Assignee: Wang Laboratories Incorporated
• Inventors: Huber, Val J.
• Primary Examiner(s): Shaw, Gareth D.
• Assistant Examiner(s): Kriess, Kevin A.
• Application Number:
  US07/171,231
• Time in Patent Office: 638 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

In a relational database management system, errors can be corrected by an interactive user so that noninteractive operation can continue. A fetch module operates against a cursor to retrieve a record occurrence noninteractively for a selected operation. The selected operation is validated; an error condition can be set. When the selected operation is valid, the operation is performed, and a return signal is provided, causing the fetch module to retrieve the next record occurrence. When the selected operation is invalid, the fetch module responds to the error condition by operating interactively to display the previously retrieved record occurrence with an error message.

Claims

1. For use in a relational database management system, interactive error-handling means, comprising

display means and input means,

storage means providing:

record occurrence signals comprising record occurrences in a relational database;

status signals;

currency signals;

format signals; and

message file signals representing the characters of displayable error message; and

providing means defining an operation buffer and first and second record occurrence buffers,

calling means,

operation means, and

fetch means,

said operation means comprising;

means responsive to an operation call signal for validating an operation selected to be performed with respect to record occurrence signals in said second record occurrence buffer and providing an output signal having one of two values, said values representing valid and invalid conditions,

means responsive to a said invalid condition value of said output signal for generating corresponding status invalid signals, and providing an operation return signa,

means responsive to a said valid condition value of said output signal for performing said selected operation with respect to said record occurrence signals, and providing an operation return signal,

said fetch means comprising;

noninteractive means responsive to a fetch call signal, a noninteractive condition, and said currency signals for retrieving record occurrence signals from said database, for placing said retrieved signals into said first and second buffers, for incrementing said currency signals, and for providing a fetch return signal, and

interactive means responsive to a fetch call signal and an interactive condition signal, and comprising

means responsive to said status valid signals and to said currency signals for retrieving said record occurrence signals from said database, and for copying said retrieved signals into said first and second buffers, and

means responsive to said status invalid signals for copying said record occurrence signals from said first to said second buffer, and

display means responsive to said format signals and to said signals in said second buffer for controlling said display to display a representation of said record occurrence, and responsive to operator input signals from said input means, for placing an operation selection signal in said operation buffer, and providing a fetch return signal,

said display means being further responsive to said status invalid signals and said message signals for displaying representations of a said error message with said record occurrence representation, and

said calling means being responsive to said operation return signals and to said status invalid signal for providing a fetch means call signal, and responsive to said fetch return signal for providing an operation call signal.

2. The error-handling means of claim 1, wherein said display means is further responsive to operator input signals to modify said signals in said second buffer.

3. The error-handling means of claim 1, wherein

said fetch means further comprises condition means responsive to a format identifier signal, to a first value of a condition parameter signal, and to said status invalid signal to provide a said interactive condition signal, and

responsive to a format identifier signal, to a first value of a condition parameter signal, and to said status valid signal to provide a said noninteractive condition signal.

4. A data processing system having:

input means for providing input signals;

a visual display;

storage means providing signals representing a plurality of record occurrences organized as relations within a relational database;

working storage; and

a processor having means for controlling said visual display, for reading and writing said working storage, and for responding to said input signals, and access means for retrieving record occurrence signals from said database and for storing retrieved record occurrence signals in said working storage, characterized in having

means in said working storage for providing format signals representative of predefined LIST, DISPLAY and SELECT mode display formats, said format signals including mode indicators each corresponding to a said mode display format; and

cursor signals representative of a cursor defined against a target comprising at least one of said relations in said database; and

relational operator means for providing signals representative of a result relation defined interactively through said input means, said operator means comprising;

cursor acceptance means for accepting from said working storage said cursor signals, said system access means being responsive to said cursor acceptance means and to signals derived from said LIST mode indicator to retrieve from said target, record occurrence signals specified by said cursor,

screen image defining means

responsive to said LIST mode indicator for accepting from said working storage said LIST mode format signals, and for defining and storing LIST mode screen image signals representative of a LIST mode screen image, responsive to said LIST mode format signals and to said retrieved record occurrence signals,

responsive to said DISPLAY mode indicator for accepting from said working storage said DISPLAY mode format signals, and for defining and storing screen image signals representative of a screen image, responsive to said DISPLAY mode format signals and said retrieved record occurrence signals,

responsive to said SELECT mode indicator for accepting from said working storage said SELECT mode format signals, and for defining and storing responsive thereto screen image signals representative of a screen image providing generic elements and open elements,

responsive to said predefined display format signals to define in a said screen image, representations of a plurality of selectable operations executable by said processor, a said plurality of said selectable operations being defined for each said mode format,

said plurality of selectable operations

defined for said LIST mode format including a transition operation from display according to said LIST mode format to display according to said SELECT mode format, and a transition operation from display according to said LIST mode format to display according to said DISPLAY mode format,

defined for said SELECT mode format including a transition operation from display according to said SELECT mode format to display according to said LIST mode format, and

defined for said DISPLAY mode format including a transition operation from display according to said DISPLAY mode format to display according to said LIST mode format,

said processor being responsive to said operator means

to control said display to display a representation of a said stored screen image, and to modify said stored screen image signals corresponding to signals from said input means, input during such display, and

to accept, during such display, operation selection signals from said input means, effecting selection of one of the said plurality of operations defined for said display format, said processor storing said operation selection signals,

said operator means further comprising

means for deriving from said modified LIST mode screen image signals together with said cursor signals, output signals defining a result relation, membership in which is defined enumeratively,

means for deriving from said modified SELECT mode screen image signals together with said cursor signals, output signals defining a result relation, membership in which is defined characteristically, and

means for storing said output signals in said working storage,

said operator means further providing

means responsive to said stored operation selection signals for providing and storing an output signal representative of said selected operation,

means responsive to a said output signal representative of said transition operation from LIST to DISPLAY to provide a said DISPLAY mode indicator to said screen image defining means,

means responsive to a said output signal representative of said transition operation from DISPLAY to LIST to provide a LIST mode indicator to said screen image defining means,

means responsive to said output signal representative of said transition operation from LIST to SELECT to provide signals representative of said SELECT mode indicator to said screen image defining means, and

means responsive to said output signal representative of said transition operation from SELECT to LIST to provide signals representative of said LIST mode indicator to said screen image defining means and to said cursor acceptance means, said cursor acceptance means being thereafter responsive to said modified cursor signals to retrieve record occurrence signals from said target.

5. The data processing system of claim 4, further characterized in that

said working storage further provides means for providing format signals representative of a predefined UPDATE display format, and

said plurality of selectable operation defined for each of said LIST, DISPLAY and SELECT display formats includes a transition operation to display according to said UPDATE display format signals,

said data processing system further providing update means responsive to said operator means output signal representing said transition to UPDATE display, and to said output signals defining a result relation, for executing said update operation on said database record occurrences, said update means providing

means for accessing said UPDATE display format signals and for defining and storing screen image signals representative of an UPDATE screen image having representations of a said enumerated record occurrence and a selectable update operation performable on said record occurrence,

said processor being responsive to said update means to control said display to display a representation of said stored UPDATE screen image signals and to receive and store an update operation selection signal input from said input means,

said update means further providing means responsive to said stored update operation selection signal to execute said update operation on said enumerated record occurrence.

7. The data processing system of claim 5, further characterized in that

said operator screen image defining means is further responsive to said predefined display format signals to define in said screen image representations of a plurality of selectable operations executable by said processor,

said processor being responsive to said operator means to accept, during such display, operation selection signals input from said input means, effecting selection of one of said defined plurality of operations, said processor storing said operation selection signals,

said operator means further providing means responsive to said stored operation selection signals for providing and storing an output signal representative of said selected operation.

16. The data processing system of claim 7, further characterized in that

said working storage further provides means for providing format signals representative of a predefined update display format,

said plurality of selectable operations including a transition to display according to said update display format signals,

said data processing system further providing update means responsive to said operator means output signal representing said transition operation, and to said output signals defining a result relation, for executing said update operation on said database record occurrences, said update means providing

means for accessing said update display format signals and for defining and storing screen image signals representative of a screen image having representations of a said enumerated record occurrence and a selectable update operation performable on said record occurrence,

said processor being responsive to said update means to control said display to display a representation of said stored screen image signals and to receive and store an update operation selection signal input from said input means,

said update means further providing means responsive to said stored update operation selection signal to execute said update operation on said enumerated record occurrence.

17. The data processing system of claim 7, further characterized in that

said format signals include signals representative of first and second mode predefined display formats, said format signals including first and second mode indicators corresponding to said first and second mode display formats respectively,

said screen image defining means being responsive to said first mode indicator for accepting from said working storage said first mode format signals, and for defining and storing screen image signals representative of a screen image, responsive to said first mode format signals and to said stored retrieved record occurrences,

said screen image defining means being responsive to said second mode indicator for accepting from said working storage said second mode format signal, and for defining and storing screen image signals representative of a screen image, responsive to said second mode format signals and said stored retrieved record occurrences,

said screen image defining means being further responsive to said predefined display format signals to define in a said screen image, representations of a plurality of selectable operations executable by said processor, a said plurality of said selectable operations being defined for each said mode format,

said plurality of selectable operations for said first mode format including a transition operation from display according to said first mode format to display according to said second mode format,

said plurality of selectable operations for second second mode format including a transition operation from display according to said second mode format to display according to said first mode format,

said processor being responsive to said operator means to accept, during such display, operation selection signals input from said input means, effecting selection of one of said defined plurality of operations, said processor storing said operation selection signals,

said operator means further providing means responsive to said stored operation selection signals for providing and storing an output signal representative of said selected operation,

said operator means further providing means responsive to a said stored transition operation selection output signal to provide a corresponding said mode indicator to said screen image defining means.

6. A data processing system having:

input means providing input signals;

a visual display;

storage means providing signals representing a plurality of record occurrences organized as relations within a relational database;

working storage; and

a processor having means for controlling said visual display, for reading and writing said working storage, and for responding to said input signals, and access means for retrieving record occurrence signals from said database and for storing retrieved record occurrence signals in said working storage,

characterized in having

means in said working storage for providing format signals representative of a predefined display format and cursor signals representative of a cursor defined against a target comprising at least one of said relations in said database, and

relational operator means for providing signals representative of a result relation, membership in said result relation being defined enumeratively and interactively through said input means, said operator means comprising;

cursor acceptance means for accepting from said working storage said cursor signals, said system access means being responsive to signals from said cursor acceptance means to retrieve from said target record occurrence signals specified by said cursor;

screen image defining means for accepting from said working storage said format signals, and for defining and storing screen image signals representative of a screen image, responsive to said format signals and to said stored retrieved record occurrence signals,

said processor being responsive to said operator means to control said display to display a representation of said stored screen image signals, and to modify said stored screen image signals corresponding to enumerating signals from said input means, input during such display, effecting enumeration of certain of said retrieved record occurrences,

said operator further comprising means for deriving from said modified screen image signals together with said cursor signals, output signals defining a result relation, membership in which is defined enumeratively, and for storing said output signals in said working storage.

14. The data processing system of claim 6, further characterized in that

said working storage provides first and second buffer locations,

said format signals including signals representative of first and second mode predefined display formats, said format signals including first and second mode indicators corresponding to said first and second mode display formats respectively, and a screen limit signal associated with said first mode display format,

said system access means being responsive to said cursor acceptance means and to said screen image defining means to retrieve from said target record occurrence signals specified by said cursor and to store said record occurrence signals in said first buffer location,

said screen image defining means being responsive to said first mode indicator for successively moving successively retrieved said record occurrence signals from said first buffer location to said second buffer location and for controlling said system access means to retrieve further record occurrence signals until a plurality of said record occurrence signals are provided in said second buffer location, said plurality being defined by said screen limit signal,

said screen image defining means being thereafter responsive to said first mode indicator for accepting from said working storage said first mode format signals, and for defining and storing screen image signals representative of a screen image, responsive to said first mode format signals and to said stored plurality of retrieved record occurrence signals in said second buffer location,

said screen image defining means being responsive to said second mode indicator for accepting from said working storage said second mode format signals, and for defining and storing screen image signals representative of a screen image, responsive to said second mode format signals and to said retrieved record occurrence signals in said first buffer location.

15. The data processing system of claim 14, further characterized in that

said operator means screen image defining means is further responsive to said predefined display format signals to define in a said screen image, representations of a plurality of selectable operations executable by said processor, a said plurality of said selectable operations being defined for each said mode format,

said processor being responsive to said operator means to accept, during such display, operation selection signals input from said input means, effecting selection of one of said defined plurality of operations, said processor storing said operation selection signals,

said operator means further providing means responsive to said stored operation selection signals for providing and storing an output signal representative of said selected operation.

8. A data processing system having:

input means providing input signals;

a visual display;

storage means providing signals representing a plurality of record occurrences organized as relations within a relational database;

working storage; and

a processor having means for controlling said visual display, for reading and writing said working storage, and for responding to said input signals, and access means for retrieving record occurrence signals from said database and for storing retrieved record occurrence signals in said working storage,

characterized in having

means in said working storage for providing format signals representative of a predefined display format, and cursor signals representative of a cursor defined against a target comprising at least one of said relations in said database, and

relational operator means for providing signals representative of a result relation, membership in said result relation being defined in terms of record occurrence attributes explicitly defined in said database, said result relation being defined interactively through said input means, said operator means comprising;

screen image defining means for accepting said format signals from said working storage, and for defining and storing signals representative of a screen image providing generic elements and open elements,

said processor being responsive to said operator means to control said display to display a representation of said screen image, and to modify said stored screen image open elements responsive to characterizing signals from said input means, input during such display, effecting characterization of said cursor,

said operator further comprising means for deriving from said modified screen image together with said cursor signals, output signals defining a modified cursor which defines a result relation, membership in which is defined characteristically, and for storing said output signals in said working storage.

9. The data processing system of claim 8, further characterized in that

said operator screen image defining means is further responsive to said predefined display format signals to define in said screen image representations of a plurality of selectable operations executable by said processor,

said processor being responsive to said operator means to accept, during such display, operation selection signals input from said input means, effecting selection of one of said defined plurality of operations, said processor storing said operation selection signals,

said operator means further providing means responsive to said stored operation selection signals for providing and storing an output signal representative of said selected operation.

10. A data processing system having:

input means providing input signals;

a visual display;

storage means providing signals representing a plurality of record occurrences organized as relations within a relational database;

working storage; and

a processor having means for controlling said visual display, for reading and writing said working storage, and for responding to said input signals, and access means for retrieving record occurrence signals from said database and for storing retrieved record occurrence signals in said working storage,

characterized in having

means in said working storage for providing format signals representative of predefined first and second mode display formats, said format signals including first and second mode indicators corresponding to said first and second mode display formats respectively; and

cursor signals representative of a cursor defined against a target comprising at least one of said relations in said database; and

relational operator means for providing signals representative of a result relation defined interactively through said input means, said operator means comprising;

cursor acceptance means for accepting from said working storage said cursor signals,

said system access means being responsive to said cursor acceptance means and to signals derived from said first mode indicator to retrieve from said target record occurrence signals specified by said cursor,

screen image defining means responsive to said first mode indicator for accepting from said working storage said first mode format signals, and for defining and storing first mode screen image signals representative of a first mode screen image, responsive to said first mode format signals and to said retrieved record occurrence signals,

said processor being responsive to said operator means to control said display to display a representation of said first mode screen image, and to modify said stored first mode screen image signals corresponding to enumerating signals input from said input means during such display,

said screen image defining means being responsive to signals derived from said second mode indicator for accepting from said working storage said second mode format signals, and for defining and storing second mode screen image signals representative of a second mode screen image providing generic elements and open elements,

said processor being responsive to said operator means to control said display to display a representation of said second mode screen image, and to modify said stored second mode screen image open elements responsive to characterizing signals input from said input means during such display, effecting characterization of said cursor,

said operator means further comprising

means for deriving from said modified first mode screen image signals together with said cursor signals, output signals defining a result relation, membership in which is defined enumeratively;

means for deriving from said modified second mode screen image signals together with said cursor signals, output signals defining a result relation, membership in which is defined characteristically;

and means for storing said output signals in said working storage.

11. The data processing system of claim 10, further characterized in that

said operator means screen image defining means is further responsive to said predefined display format signals to define in a said screen image, representations of a plurality of selectable operations executable by said processor, a said plurality of said selectable operations being defined for each said mode format,

said processor being responsive to said operator means to accept, during such display of a said screen image, operation selection signals input from said input means, effecting selection of one of the said plurality of operations defined for said display format, said processor storing said operation selection signals,

said operator means further providing means responsive to said stored operation selection signals for providing and storing an output signal representative of said selected operation.

12. The data processing system of claim 11, further characterized in that

said plurality of selectable operations defined for said first mode format includes a transition operation from display according to said first mode format to display according to said second mode format,

said operator means further including means responsive to said output signal representative of said transition operation to provide signals representative of said second mode indicator to said screen image defining means.

13. The data processing system of claim 11, further characterized in that

said plurality of selectable operations defined for said second mode format includes a transition operation from display according to said second mode format to display according to said first mode format,

said operator means further including means responsive to said output signal representative of said transition operation to provide signals representative of said first mode indicator to said screen image defining means and to said cursor acceptance means,

said cursor acceptance means being thereafter responsive to said modified cursor signals to retrieve record occurrence signals from said target.

18. A data processing system having

input means and display means,

storage providing stored signals representative of record occurrences modeled as a set of relations,

storage means and access means for storing and retrieving said record occurrence signals,

and first operator means for operating upon retrieved signals representative of at least one operand relation of said set to produce a result relation, defined by at least one of the operators Union, Intersection, Difference, Select, Project, and Join, and for controlling said storage means to store signals representative of said result relation in said storage,

said set being closed under said defined operation, said data processing system being characterized by having,

second operator means responsive to cursor signals for controlling said access means to retrieve signals representative of an operand relation defined by said cursor, and for controlling said display means to display a representation of said relation,

said second operator means being thereafter responsive to enumerating actuation of said input means, during said display, for defining an enumerated result relation derived from said displayed relation, and for controlling said storage means to store signals representative of said enumerated result relation in said storage,

said enumerated result relation being a member of said set and said set being closed under said enumerative operation.

19. A data processing system having

user input means and display means,

storage providing stored signals representative of record occurrences modeled as a set of relations, each said record occurrence comprising at least one attribute,

and first operator means for operating upon signals representative of at least one operand relation of said set to produce a result relation, defined by at least one of the operators Union, Intersection, Difference, Select, Project, and Join, and for storing signals representative of said result relation in said storage,

said set being closed under said operation, said data processing system being characterized in that

said storage further provides stored screen image signals representative of a screen image and associated stored cursor signals representative of a cursor, both defined with respect to a target relation, said screen image providing unmodifiable elements and modifiable attribute elements,

said data processing system further having

second operator means for controlling said display means to display a representation of a said stored screen image,

said second operator means being thereafter responsive to characterizing actuation of said input means, during said display, for modifying said stored screen image modifiable elements, and for effecting corresponding characterization of said associated stored cursor to provide a modified cursor,

said modified cursor defining a relation which is a member of said set.