is an electronic system that allows data to be easily accessed, manipulated and updated. In other words, a
is used by an organization as a method of storing, managing and retrieving information. Modern
are managed using a
management system (DBMS).
What are the different types of databases?
explains this pretty well. Here is an excerpt (Number 8) which relates to the type of database you need:
These databases are categorized by a set of tables where data gets fit into a pre-defined category. The table consists of rows and columns where the column has an entry for data for a specific category and rows contains instance for that data defined according to the category. The Structured Query Language (SQL) is the standard user and application program interface for a relational database.
There are various simple operations that can be applied over the table which makes these databases easier to extend, join two databases with a common relation and modify all existing applications.
How does the server relate to the database?
This diagram explains it pretty well:
The server is a special computer which you can log into remotely. It is setup in a way that multiple people can use it at once and that it can manage data-heavy tasks.
The server is hardware
(even cloud servers exist in the real world at a server farm) while
the database is software
CollectionsMax is also software.
- Front-end (GUI) graphical user interface Software which is user friendly. This is how you and your staff access accounts. CollectionsMax requires a
to operate. The database exists only on the
- The virtual PC which is configured to allow multiple connections.
The Database that you are going to use is called
, it is a
used to be built on
was purchased by Oracle several years back, some of the developers were worried that Oracle would start charging for this free program so they created an identical spin-off called MariaDB.
The version of MariaDB that CollectionsMax is built on is
is useless without a database, and a database is useless without a front-end User Interface unless you know SQL and plan on answering calls while simultaneously writing code such as:
((100 - d.contingencyamount), '%')
d.id = p.maindatabaseid
d.primaryphone = '555-555-5555'
That is an example of what you would need to type in to your command prompt within your SQL Server Database Command Line to look up someone calling from 555-555-5555 and stating that their File Number is 123456.
CollectionsMax prevents you from having to learn SQL and instead makes it user-friendly by writing this code for you on the back end and only showing you the results in an easy to understand way.
That is why you can click [
] → [
Promise to Pay
] instead of typing out:
d.statusname = "Promise to Pay"
d.id = @DebtorID;