 prfbrown
|
| Joined: 09 Aug 2005 |
| Total Posts: 5 |
| |
|
LittleSteps: RDBMS portal software for SQL Server
Posted: 07 Sep 2005 10:28 PM |
This post is to introduce the resourcefulness of an extremely versatile tool in the SQL Server database environment. We have called the tool LittleSteps, due to the simple and sure methodology of approach by which one can develop and implement information reporting applications, and immediately distribute them in an organisationally sensitive manner to the end user.
Its claim to "new technology" is by way of the method of development of applications, both reporting applications and data update applications. All development work (meaning 100%)
is actually performed within the database, in the creation and maintenance of stored procedures written in TSQL.
If a primary application were to be written with the tool, it would consist of the LittleSteps user interface tool, a database of application specific data, and a database of application specific TSQL stored procedures. The tool obviates in entirety the client layer and any associated middle tier layer, and reduces all development to SQL code.
Complex multi-layered drill down reports are engineered simply by chaining together the corresponding number (per drilling level required) of stored procedures --- it's that easy.
LittleSteps is described as 'portal software' because it provides a direct service level connection to the database, by which the user activates (pre-designed and pre-registered) stored procedures, and by which the resultant data output is presented to the user.
The end user can subsequently sort this data by any column, and/or filter the data set by any element contained therein. Print preview, and export to various formats including excel and word (tables) is then optional.
A description of the product and some of its benefits can be found here:
http://www.mountainman.com.au/software/LittleSteps/SQLServer/product_information.html
We are prepared to demonstrate the tool at a future (Australian) SQL Server user group meeting, if there is sufficient interest. In the interim period, I am happy to repond to any questions, or receive any comments, in this thread.
Pete Brown
IT Managers & Engineers
Falls Creek, NSW, Australia
http://www.mountainman.com.au
|
|
|
 |
|