US20040024740A1 - Method and system for validating data submitted to a database application - Google Patents
Method and system for validating data submitted to a database application Download PDFInfo
- Publication number
- US20040024740A1 US20040024740A1 US10/629,485 US62948503A US2004024740A1 US 20040024740 A1 US20040024740 A1 US 20040024740A1 US 62948503 A US62948503 A US 62948503A US 2004024740 A1 US2004024740 A1 US 2004024740A1
- Authority
- US
- United States
- Prior art keywords
- data
- exception
- input
- client
- data input
- 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.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
- G06F40/226—Validation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99932—Access augmentation or optimizing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99936—Pattern matching access
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
Definitions
- the present invention is generally related to a system and method for validating data entry and, more particularly, is related to a system and method for validating data entry by establishing an exception set upon submission of data and adding exceptions to the exception set where data cannot be validated.
- each data entry field is validated against a predetermined criteria. This process is generally referred to as validating the data input. This validation process is often used to ensure that data is input in the proper format and within a reasonable range of expected values. For example, a data entry field which solicits a telephone number should not typically include letters. Thus, during the validation process, the criteria established for this data entry field which requires that all data input into the telephone number field be numeric will be checked. To assure validation consistency among all applications using a database, the validation criteria is typically defined by a set of validation rules.
- the validation rules are often included as a part of, and enforced by, the database application. If the criteria is not met, validation will fail and will require correction of the entered data before it can be accepted and stored in the database. Typically, once the submitted data has failed to be validated, no further data entry fields on the submitted data entry form will be reviewed regardless of whether or not the other data fields contain valid data which meets all predetermined criteria for validation. This failure in data validation results in the database application generating an exception indicating that the submitted data entry form contains data which does not meet the predefined criteria for validation. The data entry form is presented to a user again. The user can then make corrections to data entry fields as may be necessary and then resubmit the data entry form.
- GUI graphical user interface
- the present invention provides a system and method for validating data submitted to a database application.
- a client-side network device is provided for receiving data entry from a user, and submitting the data to a database via a server application.
- a database is provided for receiving the data entry.
- the database application validates data submitted to the database.
- the present invention can also be viewed as providing a method for validating data. In this regard, the method can be broadly summarized by the following steps: receiving data input; validating data input; adding an exception to an exception set when data input cannot be validated; and returning multiple validation errors.
- FIG. 1 is an illustration of one embodiment of a system according to the present invention where data is collected at a client-side terminal and submitted over a network to a database residing on a server;
- FIG. 2 is an illustration depicting one example of a GUI presenting a data entry form
- FIG. 3 is a flowchart illustrating the method of the present invention
- FIG. 4 is a further illustration of one embodiment of the system of the present invention.
- FIG. 5 is a diagram illustrating a validation routine and exception set class
- FIG. 6 is a block diagram illustrating an embodiment of a database server 250 .
- FIG. 7 is a block diagram illustrating an embodiment of a client-side terminal 200 .
- the present invention provides for a method and system for validating data submitted to a server and database application, hereinafter known as the data survey collection system.
- data input may be submitted from, for example, a client-side network device, via a data entry form presented to a user via a graphical user interface (GUI).
- GUI graphical user interface
- This data input is then submitted to a server application for incorporation of the data into a database.
- the data entry form presented to the user via the GUI typically will include multiple data entry fields, each for receiving data input of a particular type.
- the data input is then submitted to a server application.
- the server application will submit the data to the database application.
- the server application and database application may be integrated into a single application.
- the database application will review each field of the submitted data input to ensure that it meets predetermined criteria (validation rules). This review process is referred to as data validation. Where a data field is found to not meet the validation rules, tile data is said to be invalid and a validation error occurs. When a validation error occurs the database application will generate an exception object (exception) that identifies the data field of the submitted input data that is invalid. Each exception identifying data fields found to contain invalid data will be included in an exception set that aggregates all generated exceptions which specify data fields containing invalid data input. Subsequently, after all data fields of submitted data input have been validated, the exception set containing all exceptions identifying the data fields containing invalid data input will be provided to a client-side network device for correction.
- exception exception
- the server application will aggregate, or accumulate, the exceptions generated for each field of data input which contains invalid data into a single exception set.
- This exception set will then be returned to the client-side network device.
- the client-side network device will then process the validation failures specified by the exceptions contained in the exception set at one time by presenting all of the questions to the user again, which are associated with the data fields specified in the exception set as containing invalid data.
- the user will then have the opportunity to make corrections and re-entry of all invalid data at one time, thereby improving the work efficiency of the user and reducing the overall system processing time.
- FIG. 1 illustrates an embodiment of the data survey collection system of the present invention.
- Client-side terminal 200 includes a display device 202 and a network interface 45 .
- Client-side terminal 200 is connected to network 1 via network interface 45 .
- a database server 250 is provided for receiving data and updating data stored in database 251 .
- Client-side terminal 200 presents a form 602 (FIG. 2) to a user via, for example, a graphical user interface 600 (GUI) (FIG. 2) displayed on display device 202 .
- Network 1 may be, for example, a local area network (LAN), a wide area network (WAN) or the Internet.
- LAN local area network
- WAN wide area network
- the Internet the global information network
- Network interface 45 may be, for example, a wireless interface, such as a radio frequency (RF) or infra-red (IR) interface. Additionally, network interface 45 may be a wired type interface in which data is transmitted via an electrical or optical cable. A user inputs data solicited via the form. The data input is then provided to database server 250 , which causes the data input to be incorporated into the database 251 after it has been validated to confirm that predetermined rules (example: format) have been met.
- Client-side terminal 200 may be, for example, a personal computer, a kiosk, a wireless access protocol (WAP) compliant device, personal digital assistant (PDA) or other web enabled device.
- WAP wireless access protocol
- PDA personal digital assistant
- client-side terminal 200 can be configured so as to include all functional aspects of database server 250 and database 251 , thus alleviating any need for a separate database server 250 , database 251 or network 1 , if so desired.
- FIG. 2 illustrates a graphical user interface (GUI) 600 , which is displayed on a display device 202 (FIG. 1).
- GUI 600 is used to present a visual representation of a data entry form 602 to a user.
- Data entry form 602 includes a series of questions 51 , 52 and 53 that are answered via user input in the respective input fields 61 , 62 , 63 or 64 .
- question 51 (“Telephone Number:”) solicits telephone number information.
- the proper format of an answer (response) to this question will require, for example, that all data input be numeric, of a certain length, and/or a certain order. It will be recognized that the format could also specify that the answer conform or otherwise exhibit other predetermined attributes.
- answer/response data is received ( 100 ) by the server 250 from client-side terminal 200 .
- An exception set is created to identify all fields of data that are found not to conform to the validation rules ( 101 ).
- Each field of received data is validated ( 102 ).
- each field of data is reviewed and compared to a predetermined criteria and/or validation rules. Where a field of data does not meet a predetermined criteria and/or a validation rule, an exception identifying the field which does not meet the predetermined criteria and/or the validation rule is generated and added to the exception set created at 101 ( 103 ).
- the exception set is, for example, a data object that may be called into action or thrown, when the exception set contains exceptions.
- a fatal exception is an error or other condition that would not warrant any further validation of data until such time as the error or condition has been corrected/resolved. For example, an alphabetic character entered into a data field that requires numbers only could constitute a fatal exception.
- the exception set is presented to the user via the server application for re-entry or correction of data ( 106 ). Otherwise, it is determined whether all fields of submitted data have been validated ( 105 ). If so, then the exception set is presented to the user via the server application for re-entry or correction of data ( 106 ). Otherwise the next field of submitted data is validated ( 102 ).
- the exception set 106 will be returned over the network 1 (FIG. 1) to the client-side terminal 200 . Those fields of data that are identified in the exception set will be presented to the user again via the GUI 600 (FIG. 2) for data re-entry/correction of errors.
- Application 150 which includes an application-programming interface (API) 152 .
- Application 150 may be, for example, an e-commerce application or the like.
- Application 150 may be installed and run on client-side terminal 200 or downloaded from database server 250 as, for example, an applet.
- Application 150 causes a data entry form 602 to be generated, which incorporates a question or questions to be presented to a user as a GUI 600 (FIG. 2) on, for example, a display device 202 (FIG. 1).
- Database update record 155 specifies the data input by the user for a particular set of questions ( 51 through 54 ). This record is then passed through the API 152 to the server application 253 , which in turn performs the database update via the database (DB) software 160 . If this update fails because, for example, the data does not meet the criteria specified by the validation rules, the server application 253 will interact with the database software 160 to validate as many data fields as possible. Each error reported to the server application 253 will be added to an exception set as an exception. An exception specifies, for example, the data input field that contains data that cannot be validated.
- the exception set is returned to the application 150 which causes the data entry form 602 to be re-presented to the user for correction/re-entry of answer information to conform with the pre-determined criteria. If no exceptions are contained in the exception set, the server application 253 and the database software 160 causes the database 251 to be updated to include the data. When the application 150 receives an empty exception set, it continues with the next step (often the capture and submission of a different set of data to the database).
- Database software 160 may be, for example, an OracleTM database package with Java Database Connectivity (JDBC) interface, EX or MicrosoftTM Object Oriented Database Connectivity (MS ODBC) interface.
- JDBC is an application-programming interface (API) for linking JavaTM programs to a database system.
- API application-programming interface
- JDBC allows linking of any Java based program to any database utilizing the JDBC interface.
- database software 160 may be a special purpose application designed especially for, and/or integrated into, the data survey collection system.
- the application 150 (FIG. 4), database software 160 and server application 253 , each comprise an ordered listing of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions.
- a “computer-readable medium” can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
- the computer-readable medium can be, for example but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, device, or propagation medium. More specific examples (a nonexhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic) having one or more wires, a portable computer diskette (magnetic), a random access memory (RAM) (electronic), a read-only memory (ROM) (electronic), an erasable programmable read-only memory (EPROM or Flash memory) (electronic), an optical fiber (optical), and a portable compact disc read-only memory (CDROM) (optical).
- an electrical connection having one or more wires
- a portable computer diskette magnetic
- RAM random access memory
- ROM read-only memory
- EPROM or Flash memory erasable programmable read-only memory
- CDROM portable compact disc read-only memory
- the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance, optical scanning of the paper or other medium then compiled, interpreted or otherwise processed in a suitable manner, if necessary, and then stored in a computer memory.
- FIG. 5 illustrates a validation routine 60 that creates an instance of an exception set class (exception set) 75 .
- the validation routine specifies that for each field of data presented for validation that does not meet a predetermined criteria and/or a validation rule, an exception will be added to the exception set 75 . More particularly, in FIG. 5, the validation routine 60 has added exceptions 76 through 78 to the exception set 75 to indicate that certain answer data A 1 through A 3 , respectively, cannot be validated. The exception set 75 will then be used to cause the questions and answer fields associated with the specified answer data to be represented to the user for correction/re-entry of the answers that could not be validated.
- exception set 75 will then be used to cause the questions and answer fields associated with the specified answer data to be represented to the user for correction/re-entry of the answers that could not be validated.
- FIG. 6 illustrates one embodiment of a database server 250 which is set up to interface with a client-side terminal 200 via network 1 (FIG. 1).
- a processor 602 There is provided a processor 602 , a local interface bus 604 , a storage memory 606 for storing electronic format instructions (software) 605 and data 608 .
- storage memory 606 can include both volatile and non-volatile memory.
- An input/output interface 612 is provided for interfacing with, for example, the network 1 , a display 615 , and input devices such as a keyboard 620 and pointing device 625 .
- Processor 602 controls and grants access to the data stored in memory 606 and database 251 (FIG. 1) in accordance with the instructions stored on memory 606 .
- processor 602 controls the execution of instructions stored on storage memory 606 .
- the electronic instructions (software) 605 necessary to receive and validate data input and incorporate it into database 251 (FIG. 1).
- Database 251 may be stored as data 608 on memory storage 606 if desired.
- Software 605 may include, for example, server application 253 as well as database software 160 , if desired.
- Server 250 may be configured so as to receive input via the user input interface 610 .
- User input interface may include devices such as keyboard 620 or pointing device 625 .
- FIG. 7 a block diagram of client-side terminal 200 . It can be seen that there is provided a processor 702 , a local interface bus 704 , a storage memory 706 for storing electronic format instructions (software) 707 and data 708 .
- Storage memory 706 can include both volatile and non-volatile memory.
- An input/output interface 719 is provided for interfacing with, for example, the network 1 , a display 202 , and input devices such as a keyboard 720 and pointing device 725 .
- Processor 702 preferably controls and grants access to data 708 stored in memory 706 in accordance with software 707 stored on memory 706 .
- the software 707 may include software application 150 (FIG. 4), which may be, for example, an e-commerce application or the like.
Abstract
A system and method for validating data entry in which an exception set class is defined and where, during a validation process, each data entry field is reviewed to determined whether or not certain predetermined validation criteria are met. Where data entry does not meet validation criteria, an exception is added to the exception set class to identify the data entry field that contains data that does not meet the validation criteria. After all data entry fields have been reviewed, the exception set is thrown if it contains any exceptions. Based upon this exception set, the data entry fields will be re-presented (submitted) to the user for correction/revision of the data to meet the validation criteria.
Description
- The present invention is generally related to a system and method for validating data entry and, more particularly, is related to a system and method for validating data entry by establishing an exception set upon submission of data and adding exceptions to the exception set where data cannot be validated.
- In data collection systems wherein data is solicited and input via an entry data entry form made up of multiple data entry fields, it is typical that when the data entry form is submitted to the database application for entry, each data entry field is validated against a predetermined criteria. This process is generally referred to as validating the data input. This validation process is often used to ensure that data is input in the proper format and within a reasonable range of expected values. For example, a data entry field which solicits a telephone number should not typically include letters. Thus, during the validation process, the criteria established for this data entry field which requires that all data input into the telephone number field be numeric will be checked. To assure validation consistency among all applications using a database, the validation criteria is typically defined by a set of validation rules. The validation rules are often included as a part of, and enforced by, the database application. If the criteria is not met, validation will fail and will require correction of the entered data before it can be accepted and stored in the database. Typically, once the submitted data has failed to be validated, no further data entry fields on the submitted data entry form will be reviewed regardless of whether or not the other data fields contain valid data which meets all predetermined criteria for validation. This failure in data validation results in the database application generating an exception indicating that the submitted data entry form contains data which does not meet the predefined criteria for validation. The data entry form is presented to a user again. The user can then make corrections to data entry fields as may be necessary and then resubmit the data entry form. Upon re-submission, the data entry fields of the data entry form are again reviewed (submitted for validation). Where multiple errors have been made in the entry of data in the data fields of the submitted form, the typical database system will reject the submitted data form by generating multiple exceptions and representing the data form to a user for correction until each and every invalid data field meets the predetermined criteria. This is a time consuming, resource consuming, iterative process. Typical database systems cause the graphical user interface (GUI) used to present the data entry form to a user, to iterate and be presented to the user for correction each time validation of data entry fails. This increases the time and resources required to validate all fields of data entered.
- Thus, a heretofore unaddressed need exists in the industry to address the aforementioned deficiencies and inadequacies.
- The present invention provides a system and method for validating data submitted to a database application.
- Briefly described, in architecture, the system can be implemented as follows. A client-side network device is provided for receiving data entry from a user, and submitting the data to a database via a server application. A database is provided for receiving the data entry. The database application validates data submitted to the database. The present invention can also be viewed as providing a method for validating data. In this regard, the method can be broadly summarized by the following steps: receiving data input; validating data input; adding an exception to an exception set when data input cannot be validated; and returning multiple validation errors.
- Other systems, methods, features, and advantages of the present invention will be or become apparent to one with skill in the art upon examination of the following drawings and detailed description. It is intended that all such additional systems, methods, features, and advantages be included within this description, be within the scope of the present invention, and be protected by the accompanying claims.
- The invention can be better understood with reference to the following drawings. The components in the drawings are not necessarily to scale, emphasis instead being placed upon clearly illustrating the principles of the present invention. Moreover, in the drawings, like reference numerals designate corresponding parts throughout the several views.
- FIG. 1 is an illustration of one embodiment of a system according to the present invention where data is collected at a client-side terminal and submitted over a network to a database residing on a server;
- FIG. 2 is an illustration depicting one example of a GUI presenting a data entry form;
- FIG. 3 is a flowchart illustrating the method of the present invention;
- FIG. 4 is a further illustration of one embodiment of the system of the present invention;
- FIG. 5 is a diagram illustrating a validation routine and exception set class;
- FIG. 6 is a block diagram illustrating an embodiment of a
database server 250; and - FIG. 7 is a block diagram illustrating an embodiment of a client-
side terminal 200. - The present invention provides for a method and system for validating data submitted to a server and database application, hereinafter known as the data survey collection system. With the data survey collection system, data input may be submitted from, for example, a client-side network device, via a data entry form presented to a user via a graphical user interface (GUI). This data input is then submitted to a server application for incorporation of the data into a database. The data entry form presented to the user via the GUI typically will include multiple data entry fields, each for receiving data input of a particular type. The data input is then submitted to a server application. In turn, the server application will submit the data to the database application. In some embodiments, the server application and database application may be integrated into a single application.
- The database application will review each field of the submitted data input to ensure that it meets predetermined criteria (validation rules). This review process is referred to as data validation. Where a data field is found to not meet the validation rules, tile data is said to be invalid and a validation error occurs. When a validation error occurs the database application will generate an exception object (exception) that identifies the data field of the submitted input data that is invalid. Each exception identifying data fields found to contain invalid data will be included in an exception set that aggregates all generated exceptions which specify data fields containing invalid data input. Subsequently, after all data fields of submitted data input have been validated, the exception set containing all exceptions identifying the data fields containing invalid data input will be provided to a client-side network device for correction.
- Where data entry cannot be validated, the server application will aggregate, or accumulate, the exceptions generated for each field of data input which contains invalid data into a single exception set. This exception set will then be returned to the client-side network device. The client-side network device will then process the validation failures specified by the exceptions contained in the exception set at one time by presenting all of the questions to the user again, which are associated with the data fields specified in the exception set as containing invalid data. The user will then have the opportunity to make corrections and re-entry of all invalid data at one time, thereby improving the work efficiency of the user and reducing the overall system processing time.
- FIG. 1 illustrates an embodiment of the data survey collection system of the present invention. There is shown a client-
side terminal 200. Client-side terminal 200 includes adisplay device 202 and anetwork interface 45. Client-side terminal 200 is connected tonetwork 1 vianetwork interface 45. Adatabase server 250 is provided for receiving data and updating data stored indatabase 251. Client-side terminal 200 presents a form 602 (FIG. 2) to a user via, for example, a graphical user interface 600 (GUI) (FIG. 2) displayed ondisplay device 202.Network 1 may be, for example, a local area network (LAN), a wide area network (WAN) or the Internet.Network interface 45 may be, for example, a wireless interface, such as a radio frequency (RF) or infra-red (IR) interface. Additionally,network interface 45 may be a wired type interface in which data is transmitted via an electrical or optical cable. A user inputs data solicited via the form. The data input is then provided todatabase server 250, which causes the data input to be incorporated into thedatabase 251 after it has been validated to confirm that predetermined rules (example: format) have been met. Client-side terminal 200 may be, for example, a personal computer, a kiosk, a wireless access protocol (WAP) compliant device, personal digital assistant (PDA) or other web enabled device. Further, it will be recognized by those skilled in the art that client-side terminal 200 can be configured so as to include all functional aspects ofdatabase server 250 anddatabase 251, thus alleviating any need for aseparate database server 250,database 251 ornetwork 1, if so desired. - FIG. 2 illustrates a graphical user interface (GUI)600, which is displayed on a display device 202 (FIG. 1).
GUI 600 is used to present a visual representation of adata entry form 602 to a user.Data entry form 602 includes a series ofquestions questions 51 through 54, ofdata entry form 602, the data will be submitted to database server 250 (FIG. 1) for validation. During the validation process, the user's response to each question will be checked to confirm that it meets predetermined requirements specified by a set of validation rules. For example, the validation rules may specify the format of the answer or permissible answers. - With reference to FIG. 3, a flow chart describing the method of the present invention is shown. Initially, answer/response data is received (100) by the
server 250 from client-side terminal 200. An exception set is created to identify all fields of data that are found not to conform to the validation rules (101). Each field of received data is validated (102). During validation, each field of data is reviewed and compared to a predetermined criteria and/or validation rules. Where a field of data does not meet a predetermined criteria and/or a validation rule, an exception identifying the field which does not meet the predetermined criteria and/or the validation rule is generated and added to the exception set created at 101 (103). The exception set is, for example, a data object that may be called into action or thrown, when the exception set contains exceptions. - It Is then determined if the exception is fatal (104). A fatal exception is an error or other condition that would not warrant any further validation of data until such time as the error or condition has been corrected/resolved. For example, an alphabetic character entered into a data field that requires numbers only could constitute a fatal exception. Where a fatal exception occurs, the exception set is presented to the user via the server application for re-entry or correction of data (106). Otherwise, it is determined whether all fields of submitted data have been validated (105). If so, then the exception set is presented to the user via the server application for re-entry or correction of data (106). Otherwise the next field of submitted data is validated (102). Once all fields of submitted data have been reviewed 106, the exception set 106 will be returned over the network 1 (FIG. 1) to the client-
side terminal 200. Those fields of data that are identified in the exception set will be presented to the user again via the GUI 600 (FIG. 2) for data re-entry/correction of errors. - With reference to FIG. 4 and FIG. 2 a diagram illustrating one embodiment of the system of the present invention is shown. There is an
application 150, which includes an application-programming interface (API) 152.Application 150 may be, for example, an e-commerce application or the like.Application 150 may be installed and run on client-side terminal 200 or downloaded fromdatabase server 250 as, for example, an applet.Application 150 causes adata entry form 602 to be generated, which incorporates a question or questions to be presented to a user as a GUI 600 (FIG. 2) on, for example, a display device 202 (FIG. 1). Once the user has completed answering the questions presented via entering data intodata fields 61 through 64,application 150 causes a database (DB)update record 155 to be created.Database update record 155 specifies the data input by the user for a particular set of questions (51 through 54). This record is then passed through theAPI 152 to theserver application 253, which in turn performs the database update via the database (DB)software 160. If this update fails because, for example, the data does not meet the criteria specified by the validation rules, theserver application 253 will interact with thedatabase software 160 to validate as many data fields as possible. Each error reported to theserver application 253 will be added to an exception set as an exception. An exception specifies, for example, the data input field that contains data that cannot be validated. After all fields of data have been reviewed (validated), the exception set is returned to theapplication 150 which causes thedata entry form 602 to be re-presented to the user for correction/re-entry of answer information to conform with the pre-determined criteria. If no exceptions are contained in the exception set, theserver application 253 and thedatabase software 160 causes thedatabase 251 to be updated to include the data. When theapplication 150 receives an empty exception set, it continues with the next step (often the capture and submission of a different set of data to the database). -
Database software 160 may be, for example, an Oracle™ database package with Java Database Connectivity (JDBC) interface, EX or Microsoft™ Object Oriented Database Connectivity (MS ODBC) interface. JDBC is an application-programming interface (API) for linking Java™ programs to a database system. JDBC allows linking of any Java based program to any database utilizing the JDBC interface. In an alternative embodiment of the data survey collection system,database software 160 may be a special purpose application designed especially for, and/or integrated into, the data survey collection system. - Any process descriptions or blocks in flow charts should be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps in the process, and alternate implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.
- The application150 (FIG. 4),
database software 160 andserver application 253, each comprise an ordered listing of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. In the context of this document, a “computer-readable medium” can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. The computer-readable medium can be, for example but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, device, or propagation medium. More specific examples (a nonexhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic) having one or more wires, a portable computer diskette (magnetic), a random access memory (RAM) (electronic), a read-only memory (ROM) (electronic), an erasable programmable read-only memory (EPROM or Flash memory) (electronic), an optical fiber (optical), and a portable compact disc read-only memory (CDROM) (optical). Note that the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance, optical scanning of the paper or other medium then compiled, interpreted or otherwise processed in a suitable manner, if necessary, and then stored in a computer memory. - FIG. 5 illustrates a
validation routine 60 that creates an instance of an exception set class (exception set) 75. The validation routine specifies that for each field of data presented for validation that does not meet a predetermined criteria and/or a validation rule, an exception will be added to the exception set 75. More particularly, in FIG. 5, thevalidation routine 60 has addedexceptions 76 through 78 to the exception set 75 to indicate that certain answer data A1 through A3, respectively, cannot be validated. The exception set 75 will then be used to cause the questions and answer fields associated with the specified answer data to be represented to the user for correction/re-entry of the answers that could not be validated. - FIG. 6 illustrates one embodiment of a
database server 250 which is set up to interface with a client-side terminal 200 via network 1 (FIG. 1). There is provided aprocessor 602, alocal interface bus 604, astorage memory 606 for storing electronic format instructions (software) 605 anddata 608. Further,storage memory 606 can include both volatile and non-volatile memory. An input/output interface 612 is provided for interfacing with, for example, thenetwork 1, adisplay 615, and input devices such as akeyboard 620 andpointing device 625.Processor 602 controls and grants access to the data stored inmemory 606 and database 251 (FIG. 1) in accordance with the instructions stored onmemory 606. Further,processor 602 controls the execution of instructions stored onstorage memory 606. The electronic instructions (software) 605 necessary to receive and validate data input and incorporate it into database 251 (FIG. 1).Database 251 may be stored asdata 608 onmemory storage 606 if desired.Software 605 may include, for example,server application 253 as well asdatabase software 160, if desired.Server 250 may be configured so as to receive input via theuser input interface 610. User input interface may include devices such askeyboard 620 orpointing device 625. - With reference to FIG. 7, a block diagram of client-
side terminal 200. It can be seen that there is provided aprocessor 702, alocal interface bus 704, astorage memory 706 for storing electronic format instructions (software) 707 anddata 708.Storage memory 706 can include both volatile and non-volatile memory. An input/output interface 719 is provided for interfacing with, for example, thenetwork 1, adisplay 202, and input devices such as akeyboard 720 andpointing device 725.Processor 702 preferably controls and grants access todata 708 stored inmemory 706 in accordance withsoftware 707 stored onmemory 706. Thesoftware 707 may include software application 150 (FIG. 4), which may be, for example, an e-commerce application or the like. - It should be emphasized that the above-described embodiments of the present invention, particularly, any “preferred” embodiments, are merely possible examples of implementations, merely set forth for a clear understanding of the principles of the invention. Many variations and modifications may be made to the above-described embodiment(s) of the invention without departing substantially from the spirit and principles of the invention. All such modifications and variations are intended to be included herein within the scope of this disclosure and the present invention and protected by the following claims.
Claims (27)
1. A method of validating data submitted to a database application comprising the steps of:
receiving data input in response to a query presented to a user;
comparing said data with a predetermined validation criteria; and
adding a criteria exception rule to an exception set class where said data fails to meet said predetermined validation criteria, said exception identifies a data field of said data input which does not meet said validation criteria.
2. The method of claim 1 , further including the steps of comparing said data to a validation rule and adding an exception rule to said exception set class.
3. The method of claim 2 , further comprising the step of presenting said exception set class to a user for review.
4. The method of claim 3 , further comprising the steps of accepting a corrected data input from said user, comparing said corrected data input with said predetermined validation criteria, comparing said corrected data input with said validation rule, adding said criteria exception when said corrected data input fails to compare with said predetermined validation criteria, and adding said rule exception when said corrected data input fails to compare with said validation rule.
5. The method of claim 1 , wherein said data input is received from a client-side application.
6. The method of claim 1 , wherein said exception set class comprises a data object.
7. The method of claim 6 , wherein said data object comprises an exception set.
8. The method of claim 7 , wherein said exception set comprises a plurality of exceptions.
9. The method of claim 1 , wherein said data input comprises a data field.
10. The method of claim 9 , wherein said data field is associated with a throwable object where said data field cannot be validated.
11. The method of claim 10 , wherein said throwable object comprises an exception.
12. The method of claim 1 , wherein said data input comprises a plurality of data fields.
13. The method of claim 12 , wherein said exception set specifics a plurality of data fields which cannot be validated.
14. The method of claim 1 , further comprising the step of causing a question to be re-presented to a user in accordance with said exception set.
15. The method of claim 14 , wherein said exception set is output to said client-side application when all of said data input has been reviewed.
16. A system for validating data input comprising:
a database server comprising a database residing in a memory, said database for storing a plurality of input data;
an interface for receiving input data representing a user response to a presented question; and
a controller for causing said input data to be validated in accordance with a predetermined validation routine, and adding an exception to an exception set class each time said data input fails to meet predetermined criteria for validation.
17. A system for validating data input according to claim 16 , wherein said controller further causes said exception set to be output to a client-side application.
18. A system according to claim 17 , wherein said client-side application is run on a client-side terminal.
19. A system for validating data input according to claim 16 , wherein said interface comprises a network interface.
20. A system for validating data input according to claim 16 , wherein said network interface comprises a wireless network interface.
21. A system according to claim 19 , wherein said network comprises a local area network.
22. A system according to claim 19 , wherein said network comprises the Internet.
23. A system according to claim 18 , wherein said client-side terminal comprises a wireless access protocol (WAP) compliant device.
24. A system according to claim 16 , wherein said client-side terminal comprises a personal digital assistant (PDA).
25. A system according to claim 17 , wherein said client-side terminal comprises a display device; and
controller for re-presenting a data entry form to said user via said display device in accordance with an exception set record generated by a database server.
26. A system for validating data input comprising:
a storage memory for storing a plurality of instructions and a plurality of input data;
a controller for operating on said plurality of input data in accordance with said at least one instruction stored on said storage memory;
wherein said plurality of instructions further includes;
at least one receiving instruction stored on said storage memory for receiving said plurality of input data submitted in response to a query presented to a user;
at least one validating instruction stored on said storage memory for validating said input data; and
at least one exception instruction stored on said storage memory for adding an exception to an exception set class where one of said input data is invalid, said exception identifies a data field of said one input data which is invalid.
27. A system for validating data input, comprising:
client-side terminal for presenting a data entry form to a user; and
database server for receiving a data entry record from said client-side terminal and incorporating it into database where certain pre-determined validation criteria are met.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/629,485 US20040024740A1 (en) | 2001-01-16 | 2003-07-29 | Method and system for validating data submitted to a database application |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/765,883 US6629098B2 (en) | 2001-01-16 | 2001-01-16 | Method and system for validating data submitted to a database application |
US10/629,485 US20040024740A1 (en) | 2001-01-16 | 2003-07-29 | Method and system for validating data submitted to a database application |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/765,883 Continuation US6629098B2 (en) | 2001-01-16 | 2001-01-16 | Method and system for validating data submitted to a database application |
Publications (1)
Publication Number | Publication Date |
---|---|
US20040024740A1 true US20040024740A1 (en) | 2004-02-05 |
Family
ID=25074777
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/765,883 Expired - Fee Related US6629098B2 (en) | 2001-01-16 | 2001-01-16 | Method and system for validating data submitted to a database application |
US10/629,485 Abandoned US20040024740A1 (en) | 2001-01-16 | 2003-07-29 | Method and system for validating data submitted to a database application |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/765,883 Expired - Fee Related US6629098B2 (en) | 2001-01-16 | 2001-01-16 | Method and system for validating data submitted to a database application |
Country Status (1)
Country | Link |
---|---|
US (2) | US6629098B2 (en) |
Cited By (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040194112A1 (en) * | 2003-03-28 | 2004-09-30 | Microsoft Corporation | Entity linking system |
US20040205136A1 (en) * | 2003-03-28 | 2004-10-14 | Kevin Whittenberger | Document message state management engine |
US20060074982A1 (en) * | 2004-09-23 | 2006-04-06 | Spodaryk Joseph M | Method for comparing tabular data |
GB2435954A (en) * | 2006-01-27 | 2007-09-12 | Claricom Ltd | Two part security code generation, printing and validation |
US20100191700A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Communication Handler for Flex Integration with a Secure Application |
US20100191559A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Sample Management for a Sales Call |
US20100192166A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Flex integration with a secure application |
US20100191560A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Pharmaceutical Sample Management for a Sales Call |
US20100198908A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Implementing Asynchronous Processes on a Mobile Client |
US20100198654A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Personalized Content Delivery and Analytics |
US20100199199A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Manipulation of Window Controls in a Popup Window |
US20100195808A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Adding Contacts During Personalized Content Delivery and Analytics |
US20100199194A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Configurable Toolbar |
US20110125827A1 (en) * | 2009-11-20 | 2011-05-26 | Microsoft Corporation | Validation Pipeline |
US20160070733A1 (en) * | 2014-09-10 | 2016-03-10 | Ab Initio Technology Llc | Conditional validation rules |
US9977659B2 (en) | 2010-10-25 | 2018-05-22 | Ab Initio Technology Llc | Managing data set objects |
US10175974B2 (en) | 2014-07-18 | 2019-01-08 | Ab Initio Technology Llc | Managing lineage information |
US10180957B2 (en) * | 2014-08-14 | 2019-01-15 | International Business Machines Corporation | Automatic detection of problems in a large-scale multi-record update system and method |
US10489360B2 (en) | 2012-10-17 | 2019-11-26 | Ab Initio Technology Llc | Specifying and applying rules to data |
US10558650B2 (en) | 2014-04-07 | 2020-02-11 | International Business Machines Corporation | Enhanced batch updates on records and related records system and method |
US11341155B2 (en) | 2008-12-02 | 2022-05-24 | Ab Initio Technology Llc | Mapping instances of a dataset within a data management system |
Families Citing this family (38)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2001057663A2 (en) | 2000-02-04 | 2001-08-09 | America Online Incorporated | Optimized delivery of web application code |
WO2001057720A2 (en) * | 2000-02-04 | 2001-08-09 | America Online Incorporated | Automated client-server data validation |
US6874025B2 (en) * | 2000-12-22 | 2005-03-29 | Intel Corporation | System and method of application input validation |
US7000236B2 (en) * | 2001-07-30 | 2006-02-14 | Bellsouth Intellectual Property Corporation | System and method for using web based applications to manipulate data with manipulation functions |
US7353248B1 (en) | 2001-07-30 | 2008-04-01 | At&T Delaware Intellectual Property, Inc. | Application server and method to perform hierarchical configurable data validation |
US7296297B2 (en) * | 2001-07-30 | 2007-11-13 | At&T Bls Intellectual Property Corporation | System and method for using web-based applications to validate data with validation functions |
US7441007B1 (en) | 2001-07-30 | 2008-10-21 | At&T Intellectual Property I, L.P. | System and method for allowing applications to retrieve properties and configuration information from a persistent store |
US6907451B1 (en) | 2001-09-29 | 2005-06-14 | Siebel Systems, Inc. | Method, apparatus, and system for immediate posting of changes in a client server environment |
US7146617B2 (en) | 2001-09-29 | 2006-12-05 | Siebel Systems, Inc. | Method, apparatus, and system for implementing view caching in a framework to support web-based applications |
US7885996B2 (en) | 2001-09-29 | 2011-02-08 | Siebel Systems, Inc. | Method, apparatus, and system for implementing notifications in a framework to support web-based applications |
US8359335B2 (en) * | 2001-09-29 | 2013-01-22 | Siebel Systems, Inc. | Computing system and method to implicitly commit unsaved data for a world wide web application |
US7870492B2 (en) | 2001-10-02 | 2011-01-11 | Siebel Systems, Inc. | Method, apparatus, and system for managing commands in a client server environment |
US7426521B2 (en) * | 2002-07-19 | 2008-09-16 | Microsoft Corporation | Property and object validation in a database system |
US20040024842A1 (en) * | 2002-07-31 | 2004-02-05 | Sap Aktiengesellschaft | Validation framework for validating markup page input on a client computer |
WO2005050475A1 (en) * | 2003-11-21 | 2005-06-02 | Agency For Science, Technology And Research | Method and system for validating the content of technical documents |
US20070016960A1 (en) * | 2005-07-18 | 2007-01-18 | Nt Objectives, Inc. | NTO input validation technique |
US20080222611A1 (en) * | 2007-03-09 | 2008-09-11 | Microsoft Corporation | Generic validation layer for object properties |
US20080301185A1 (en) * | 2007-05-31 | 2008-12-04 | Microsoft Corporation | Property Validation Framework |
US8688508B1 (en) | 2007-06-15 | 2014-04-01 | Amazon Technologies, Inc. | System and method for evaluating correction submissions with supporting evidence |
US8146136B1 (en) | 2007-06-15 | 2012-03-27 | Amazon Technologies, Inc. | Automated acceptance or rejection of consumer correction submissions |
US7861072B2 (en) * | 2007-06-25 | 2010-12-28 | Microsoft Corporation | Throwing one selected representative exception among aggregated multiple exceptions of same root cause received from concurrent tasks and discarding the rest |
US8146085B2 (en) * | 2007-06-25 | 2012-03-27 | Microsoft Corporation | Concurrent exception handling using an aggregated exception structure |
US20100094663A1 (en) * | 2007-11-30 | 2010-04-15 | Jamie Spriggs | Health plan enrollment systems and methods of use thereof |
US8321914B2 (en) * | 2008-01-21 | 2012-11-27 | International Business Machines Corporation | System and method for verifying an attribute in records for procurement application |
US20090204881A1 (en) * | 2008-02-08 | 2009-08-13 | M/S. Scmooth (India) Private Limited | Method and system for knowledge-based filling and verification of complex forms |
US8224797B2 (en) * | 2008-03-04 | 2012-07-17 | International Business Machines Corporation | System and method for validating data record |
US8473508B2 (en) * | 2009-10-01 | 2013-06-25 | Oracle International Corporation | Dynamic rule creation and caching |
US9210030B1 (en) | 2010-11-01 | 2015-12-08 | Aol Advertising Inc. | Methods and systems for data validation in a client-server environment |
US20150356104A9 (en) * | 2011-10-04 | 2015-12-10 | Electro Industries/Gauge Tech | Systems and methods for collecting, analyzing, billing, and reporting data from intelligent electronic devices |
JP5950369B2 (en) * | 2013-01-22 | 2016-07-13 | Necソリューションイノベータ株式会社 | Input support system, input support method, and input support program |
US10102195B2 (en) | 2014-06-25 | 2018-10-16 | Amazon Technologies, Inc. | Attribute fill using text extraction |
US10223344B2 (en) | 2015-01-26 | 2019-03-05 | Adobe Inc. | Recognition and population of form fields in an electronic document |
US20160335239A1 (en) * | 2015-05-13 | 2016-11-17 | Union Pacific Railroad Company | Intelligent system and method of completing a form using a device |
US10740547B2 (en) * | 2015-10-27 | 2020-08-11 | Allscripts Software, Llc | Managing data relationships of customizable forms |
US10438264B1 (en) | 2016-08-31 | 2019-10-08 | Amazon Technologies, Inc. | Artificial intelligence feature extraction service for products |
WO2020146642A1 (en) * | 2019-01-11 | 2020-07-16 | North Fork Holdings, Llc | Machine for exception handling in a processing network |
US11863589B2 (en) | 2019-06-07 | 2024-01-02 | Ei Electronics Llc | Enterprise security in meters |
US11860715B2 (en) * | 2021-11-08 | 2024-01-02 | Sap Se | Messaging for OData error targets |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5596752A (en) * | 1989-09-01 | 1997-01-21 | Amdahl Corporation | System for creating, editing, displaying, and executing rules-based programming language rules having action part subsets for both true and false evaluation of the conditional part |
US5710901A (en) * | 1995-12-29 | 1998-01-20 | Tci Summitrak Of Texas, Inc. | Method and apparatus for validating data entered by a user |
US5752018A (en) * | 1991-08-20 | 1998-05-12 | Powersoft Corporation | Buffered database table interface object system |
US5991758A (en) * | 1997-06-06 | 1999-11-23 | Madison Information Technologies, Inc. | System and method for indexing information about entities from different information sources |
US6115694A (en) * | 1995-08-25 | 2000-09-05 | General Electric Company | Method for validating specified prices on real property |
US6341282B1 (en) * | 1999-04-19 | 2002-01-22 | Electronic Data Systems Corporation | Information retrieval system and method |
US6377932B1 (en) * | 1998-07-02 | 2002-04-23 | Ita Software, Inc. | Rules validation for travel planning system |
US6389414B1 (en) * | 1998-09-21 | 2002-05-14 | Microsoft Corporation | Internal database validation |
US6484180B1 (en) * | 1999-08-02 | 2002-11-19 | Oracle Corporation | Accessing domain object data stored in a relational database system |
US6961855B1 (en) * | 1999-12-16 | 2005-11-01 | International Business Machines Corporation | Notification of modifications to a trusted computing base |
US6968349B2 (en) * | 2002-05-16 | 2005-11-22 | International Business Machines Corporation | Apparatus and method for validating a database record before applying journal data |
-
2001
- 2001-01-16 US US09/765,883 patent/US6629098B2/en not_active Expired - Fee Related
-
2003
- 2003-07-29 US US10/629,485 patent/US20040024740A1/en not_active Abandoned
Patent Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5596752A (en) * | 1989-09-01 | 1997-01-21 | Amdahl Corporation | System for creating, editing, displaying, and executing rules-based programming language rules having action part subsets for both true and false evaluation of the conditional part |
US5752018A (en) * | 1991-08-20 | 1998-05-12 | Powersoft Corporation | Buffered database table interface object system |
US6115694A (en) * | 1995-08-25 | 2000-09-05 | General Electric Company | Method for validating specified prices on real property |
US5710901A (en) * | 1995-12-29 | 1998-01-20 | Tci Summitrak Of Texas, Inc. | Method and apparatus for validating data entered by a user |
US5991758A (en) * | 1997-06-06 | 1999-11-23 | Madison Information Technologies, Inc. | System and method for indexing information about entities from different information sources |
US6377932B1 (en) * | 1998-07-02 | 2002-04-23 | Ita Software, Inc. | Rules validation for travel planning system |
US6389414B1 (en) * | 1998-09-21 | 2002-05-14 | Microsoft Corporation | Internal database validation |
US6341282B1 (en) * | 1999-04-19 | 2002-01-22 | Electronic Data Systems Corporation | Information retrieval system and method |
US6484180B1 (en) * | 1999-08-02 | 2002-11-19 | Oracle Corporation | Accessing domain object data stored in a relational database system |
US6961855B1 (en) * | 1999-12-16 | 2005-11-01 | International Business Machines Corporation | Notification of modifications to a trusted computing base |
US6968349B2 (en) * | 2002-05-16 | 2005-11-22 | International Business Machines Corporation | Apparatus and method for validating a database record before applying journal data |
Cited By (39)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040205136A1 (en) * | 2003-03-28 | 2004-10-14 | Kevin Whittenberger | Document message state management engine |
US7614057B2 (en) * | 2003-03-28 | 2009-11-03 | Microsoft Corporation | Entity linking system |
US8112481B2 (en) | 2003-03-28 | 2012-02-07 | Microsoft Corporation | Document message state management engine |
US20040194112A1 (en) * | 2003-03-28 | 2004-09-30 | Microsoft Corporation | Entity linking system |
US20060074982A1 (en) * | 2004-09-23 | 2006-04-06 | Spodaryk Joseph M | Method for comparing tabular data |
GB2435954A (en) * | 2006-01-27 | 2007-09-12 | Claricom Ltd | Two part security code generation, printing and validation |
GB2435954B (en) * | 2006-01-27 | 2008-03-05 | Claricom Ltd | Printing method |
US11341155B2 (en) | 2008-12-02 | 2022-05-24 | Ab Initio Technology Llc | Mapping instances of a dataset within a data management system |
US20100191700A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Communication Handler for Flex Integration with a Secure Application |
US20100191560A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Pharmaceutical Sample Management for a Sales Call |
US20100192166A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Flex integration with a secure application |
US9684736B2 (en) | 2009-01-29 | 2017-06-20 | Oracle International Corporation | Communication handler for flex integration with a secure application |
US9659335B2 (en) | 2009-01-29 | 2017-05-23 | Oracle International Corporation | Sample management for a sales call |
US9063806B2 (en) | 2009-01-29 | 2015-06-23 | Oracle International Corporation | Flex integration with a secure application |
US20100191559A1 (en) * | 2009-01-29 | 2010-07-29 | Oracle International Corporation | Sample Management for a Sales Call |
US8452640B2 (en) | 2009-01-30 | 2013-05-28 | Oracle International Corporation | Personalized content delivery and analytics |
US20100199199A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Manipulation of Window Controls in a Popup Window |
US20100198908A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Implementing Asynchronous Processes on a Mobile Client |
US20100199194A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Configurable Toolbar |
US8762883B2 (en) | 2009-01-30 | 2014-06-24 | Oracle International Corporation | Manipulation of window controls in a popup window |
US8762448B2 (en) | 2009-01-30 | 2014-06-24 | Oracle International Corporation | Implementing asynchronous processes on a mobile client |
US9760381B2 (en) | 2009-01-30 | 2017-09-12 | Oracle International Corporation | Configurable toolbar |
US20100195808A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Adding Contacts During Personalized Content Delivery and Analytics |
US20100198654A1 (en) * | 2009-01-30 | 2010-08-05 | Oracle International Corporation | Personalized Content Delivery and Analytics |
US9026580B2 (en) * | 2009-11-20 | 2015-05-05 | Microsoft Technology Licensing, Llc | Validation pipeline |
CN102696036A (en) * | 2009-11-20 | 2012-09-26 | 微软公司 | Validation pipeline |
US20110125827A1 (en) * | 2009-11-20 | 2011-05-26 | Microsoft Corporation | Validation Pipeline |
US9977659B2 (en) | 2010-10-25 | 2018-05-22 | Ab Initio Technology Llc | Managing data set objects |
US10489360B2 (en) | 2012-10-17 | 2019-11-26 | Ab Initio Technology Llc | Specifying and applying rules to data |
US10558650B2 (en) | 2014-04-07 | 2020-02-11 | International Business Machines Corporation | Enhanced batch updates on records and related records system and method |
US10901984B2 (en) | 2014-04-07 | 2021-01-26 | International Business Machines Corporation | Enhanced batch updates on records and related records system and method |
US10318283B2 (en) | 2014-07-18 | 2019-06-11 | Ab Initio Technology Llc | Managing parameter sets |
US10175974B2 (en) | 2014-07-18 | 2019-01-08 | Ab Initio Technology Llc | Managing lineage information |
US11210086B2 (en) | 2014-07-18 | 2021-12-28 | Ab Initio Technology Llc | Managing parameter sets |
US10180957B2 (en) * | 2014-08-14 | 2019-01-15 | International Business Machines Corporation | Automatic detection of problems in a large-scale multi-record update system and method |
US10204134B2 (en) | 2014-08-14 | 2019-02-12 | International Business Machines Corporation | Automatic detection of problems in a large-scale multi-record update system and method |
US10956407B2 (en) | 2014-08-14 | 2021-03-23 | International Business Machines Corporation | Automatic detection of problems in a large-scale multi-record update system and method |
US9626393B2 (en) * | 2014-09-10 | 2017-04-18 | Ab Initio Technology Llc | Conditional validation rules |
US20160070733A1 (en) * | 2014-09-10 | 2016-03-10 | Ab Initio Technology Llc | Conditional validation rules |
Also Published As
Publication number | Publication date |
---|---|
US6629098B2 (en) | 2003-09-30 |
US20020095406A1 (en) | 2002-07-18 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US6629098B2 (en) | Method and system for validating data submitted to a database application | |
US7039833B2 (en) | Stack trace generated code compared with database to find error resolution information | |
US6618857B1 (en) | Method and system for installing software on a computer system | |
US6185583B1 (en) | Parallel rule-based processing of forms | |
US20070016544A1 (en) | Best practices analyzer | |
JPH05101072A (en) | Method and system for controlling management of engineering change | |
JP2004192644A (en) | Electronic software design specification document verification method and device, and computer-readable medium | |
US8954949B2 (en) | Smart patch delivery system | |
WO2020237798A1 (en) | Upgrade method and device | |
CN106708897B (en) | Data warehouse quality guarantee method, device and system | |
CN110648126A (en) | Payment type configuration method, device, server and storage medium | |
US20090299992A1 (en) | Methods and systems for identifying desired information | |
CN113191889A (en) | Wind control configuration method, configuration system, electronic device and readable storage medium | |
US9058313B2 (en) | Test method for distributed processing system and distributed processing system | |
CN115774881A (en) | Code auditing method, device, equipment and medium | |
CN115454472A (en) | Remote upgrading problem solving method, device, equipment and readable storage medium | |
CN112905469B (en) | Method and apparatus for detecting applet capability features | |
CN101295314A (en) | File management system, file management method, support device thereof, and program thereof | |
CN110502350B (en) | Node calling method and device, terminal and computer readable storage medium | |
CN114527993A (en) | Application deployment method, device, equipment and medium | |
CN108563759B (en) | Method for clearing login user, device storage medium and electronic equipment | |
CN112596816A (en) | Form processing method and device and electronic equipment | |
CN114327602B (en) | Information processing method, device, electronic equipment and storage medium | |
CN114356441B (en) | Plug-in preloading method and device, electronic equipment and storage medium | |
CN112527820B (en) | Method and system for uniformly checking various service application data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |