|
|||||
|
Databases Overview
Applications use Relational Databases to organize, store and retrieve objects. A possible definition of a database is a collection of records stored in a computer in a systematic way, so that a computer program can consult it to answer questions. The central concept of a database is that of a collection of records, or pieces of knowledge. Typically, for a given database, there is a structural description of the type of facts held in that database: this description is known as a schema. The schema describes the objects that are represented in the database, and the relationships among them. The objects of the VORG System map themselves on the relational schema of the database for storage and retrieval of data, but additionally they have incorporated business logic.
Supported Database Types VORG Systems support three database types: 1. Microsoft Access Access databases are based on the relational Microsoft Jet Database Engine. This database size is limited to 2GB and store up to 32000 objects. You should use Access database, only when you need to store a small amount of data in a single user (or few users) environment, or when you have very low resources, such as memory or disk. Because of its limited capabilities we recommend this database type to be used by personal use scenarios, by small businesses or within departments of large corporations. 2. Microsoft MSDE and Microsoft SQL Server MSDE databases are based on Microsoft SQL Server technology. This database size is limited to 2GB, like Access, but overall is more robust and secure. It has the advantage of being easily upgradeable to a SQL Server database. Like for Access, we recommend this database type to be used by personal use scenarios, by small businesses or within departments of large corporations. Microsoft SQL Server is the main relational database management system produced by Microsoft. This database has virtually unlimited size and supports a large number of concurrent users. We recommend this database type for usage scenarios which involve a large amount of date and a large amount of users. Read How to obtain and install Microsoft MSDE and How to install Microsoft SQL Server.
3. MySQL This database has virtually unlimited size and supports a large number of concurrent users. We recommend this database type for usage scenarios which involve a large amount of date and a large amount of users. Read How to install MySQL on Windows.
Related Articles The Database Connection Wizard
|
