Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Database application (Read 1856 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Database application
02.06.09 at 21:31:11
 
Database application
 
A database application is software that is centered around a store of data, a database. Data can be collected for various reasons in a database and usually some kind of software application is needed on top to make use of the data. Typically a database application provides screens to view, manipulate and enter data internally using the SQL select, update and insert statements.  
 
The source code structure of a database application can vary. It is generally accepted that a application design involves separation of code into functional areas. Different code to do the front-end (screens, reports, etc), separate code to do the underlying database work. A further separation can be achieved by introducing a layer of business code where the front-end code consults services from a layer of business functions executing specific tasks. The business functions in turn interact with the database and even that can be further separated from the business code. It is not uncommon that an API is developed directly on top of the tables inside a database to help to validate new data and to maintain data structures.
 
In developing such a database application with code separation into multiple layers performance issues play an important role. Performance should therefore at all stages of design and implementation be considered. There are choices in algorithms to make. With the recent trend of using distributed services where the database is accessed through web services this becomes even more important.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1