Linker IT Software
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 (Read 1810 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
28.09.08 at 11:22:29
A database is a more or less structured collection of data, stored and managed in some way for a user community to use.
A database can be structured according to a database model, a set of rules that define the data. In less structured databases the data is stored more informally.
A collection of flat files is an example of a unstructured database where at most there could be a naming convention for the files to indicate the files contents. Spreadsheets have some more structure in the sense that information in cells can be found using a cell address. In Excel for instance a unique cell reference is obtained using the following address format: [workbook]Sheet!Cell. A further step up in database structure is the use of a simpel relational database like MS Access. In relational databases data is stored tables that are interlinked. When these relational links are enforced the structure of the data becomes more tight. When done properly a relational database contains data one cannot corrupt.
Database management systems have been developed to manage very large quantities of data and to provide additional services such as programming and management environments. Examples are Oracle and SQL Server. Besides the relational database model there are other models in use too. In the hierarchical database model data is presented in tree like structures. In the network model records can participate in any number of relationships.
The SQL*XL software successfully combines the environment of a less formal data storing environment of MS Excel with capabilities to interact with RDBMS data stored in high end database management systems. It combined the flexibility of Excel with the robustness and data integrity features of the relational database.
Why not give SQL*XL a try today.  
SQL*XL: SQL Excel software

Download SQL*XL now!

More information:
SQL*XL software information
Back to top
« Last Edit: 28.09.08 at 11:23:54 by Gerrit-Jan Linker »  

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