Home 
Support
Documentation
Databases
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 Patient Manager 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
Patient Manager 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.
 |
MSDE databases install by default with network availability disabled. Read how to install MSDE ready for network use. |
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.
|
For MySql databases, after installation you must Extend the max_allowed_packet variable. |
Related Articles
The Database Connection Wizard
Top of Page
Vertikal Systems |
Privacy Policy |
Terms of Use
Copyright © 2010 Vertikal Systems - EHR Medical Software, Electronic Medical Records and Medical Scheduling Sofware
