Onnet Systems Inc. SQLSequencer

Added to bookmarks
Bookmarks list

Bookmark has been removed
Bookmarks list

You can't add any more bookmarks

By registering as a member, you can increase the number of bookmarks you can save and organize them with labels.
Free membership registration

last updated：Jan 30, 2011

Official site

A methodology for building batch processing solely with SQL statements.

SQLSequencer (hereinafter referred to as SQLS) is a system that sequentially executes multiple SQL statements that have been arranged in order in advance. Since our establishment in 2000, we have consistently built core business systems, and SQLS was born out of the thought process regarding how to standardize programs that do not involve screen processing (hereinafter referred to as batch processing). The prototype was developed in 2005, and we have experienced significant results from its actual use. Since then, we have not engaged in almost any batch programming at our company. We perform processing solely by describing the execution control XML given to SQLS. We have realized through actual system construction that SQLS allows for the construction of business systems at a very low cost and with high reliability. The only necessary knowledge is database design skills and SQL statements. In typical programming, additional knowledge such as language knowledge, object-oriented knowledge, and standardization rules for log output are also required. In this way, SQLS enables system construction with the minimum necessary knowledge, allowing participation in system construction tasks with minimal training. Moreover, it achieves high productivity and reduces variability in quality.

Related Link - http://www.onnet.ne.jp/products/dev_sqls.html#sqls…

Inquire About This Product

basic information

【Features】 ○ Execute SQL sequentially: • SQL statements are written in order. It is also possible to branch based on the execution results, allowing the combination of SQL to behave like a single program. ○ Replace SQL with external parameter strings: • In addition to executing predetermined SQL, there may be cases where you want to change the content of the SQL at runtime. For example, changing search conditions or inserting total values into an UPDATE statement. Replacing SQL with external parameters leads to the generalization of processing. ○ Branch based on execution results: • There may be cases where you want to branch processing based on the execution results of SQL. For example, obtaining the number of records with a SELECT statement and stopping processing if there are zero records. Additionally, branching can return to a previous SQL, allowing it to behave like a program. ○ Perform error handling: • It is also possible to branch based on errors output by the DBMS. Detection of key value duplication, exclusive conflicts, etc., is possible. Branching after detection can also be performed. ● For more details, please contact us or refer to the catalog.