Can Microsoft Access and OpenOffice Base be considered full-fledged DBMS?

Question

IT education

Can such products as Microsoft Access and OpenOffice Base be considered full-fledged DBMS? They say that they are flawed and not suitable for study. In what their inferiority in comparison with other DBMS?

Answer 1

It depends on what the teacher means by "full-fledged DBMS".
In some school textbooks, the DBMS that provides the tools for developing the user interface is considered complete.
In this regard, Access is much more complete than mysql / postresql
But Oracle has an oracle application, which has a mustache itself.
I have not heard about OpenOffice, but judging by the wiki, yes, technically it is also a full-fledged DBMS.
And if you can still find a lot of legacy on Access, then I have not seen any live projects in OpenOffice.
Another question is that both products - Access and Openoffice have long been out of trend.
Because the trend now is either relational databases that support SQL, and not their own incomprehensible language. Or nosql bases for specific solutions (mongo, for example).
Therefore, it is quite possible to study a DBMS using the example of Access, but in practice, it would be better if it were any SQL database, even sqlite.

Answer 2

IMHO Microsoft Access can be considered a full-fledged DBMS.
I haven't even heard of OpenOffice Base to be honest ))

Answer 3

For some tasks, these are quite suitable as a DBMS.
Their niche is about the same as that of sqlite, IMHO. Only in access you can also build a GUI.
By the way, Access itself is not needed to work with the database - the OLE DB driver for the Access is quite enough. But in this case, there will be no built-in GUI either.

Answer 4

There is a good rule: if you want to ask "why they say so", ask, first of all, those who speak, and not strangers.
Access and its replacement from Open Office are solutions that are designed for office tasks, which, in fact, are self-contained, include both the database engine itself and the user interface development tool for it. For a distributed architecture - they are not suitable, for simultaneous work with one database by several users - also, the standards have their own, incompatible with generally accepted ones. They are suitable for studying at the courses of office enikey specialists, for studying at the institute the fundamental principles of working with a DBMS, which can then be applied to work with what you have listed in the picture - not really.