August 22, 2010 at 9:22 am
I just want to know what would be the best dbms to use? especially for a new business or company. just really something that endusers would find easy to use. Thanks!
August 23, 2010 at 2:00 am
Well, you're asking on a forum dedicated to Microsoft SQL Server. What answer do you think you'll get? 🙂
August 23, 2010 at 4:55 am
The world's most popular database by a long long way and well known as easy to use by end users is Excel.
The world's most troublesome database system for people dealing with corporate data management who need to ensure their organisation's data is consistent and reliable is Excel.
You need to look at what is truly important to your organisation and choose what is best for you.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 23, 2010 at 5:17 am
EdVassie (8/23/2010)
The world's most popular database by a long long way and well known as easy to use by end users is Excel.The world's most troublesome database system for people dealing with corporate data management who need to ensure their organisation's data is consistent and reliable is Excel.
You need to look at what is truly important to your organisation and choose what is best for you.
Only problem is... Excel is not a DBMS 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 23, 2010 at 5:24 am
abe.nito (8/22/2010)
I just want to know what would be the best dbms to use? especially for a new business or company. just really something that endusers would find easy to use. Thanks!
Answering specific question the best DBMS would be a RDBMS.
Going further and in no particular order today's specials are: SQL Server, DB2, Sybase, Oracle, MySQL and, Postgres.
To make a decision look at: Size, Criticality, Budget, In-house skillset and your Personal preference.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 23, 2010 at 5:29 am
Excel is not a DBMS
There are 34.6 million hits on Google for the term "excel database". Excel may not have had DBMS capabilities as its primary design goal, but it has enough for millions of people to use it as a DBMS :crying:. The resulting mess keeps many true DBMS people in jobs :-D:-D
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 23, 2010 at 6:35 am
PaulB-TheOneAndOnly (8/23/2010)
To make a decision look at: Size, Criticality, Budget, In-house skillset and your Personal preference.
....and available talent in your area. Don't pick a platform only to find out that there aren't a lot of DBA's with that skill set.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 23, 2010 at 7:36 am
End users typically don't work with the database. Unless it's Excel, and then you have concurrency, scalability, reliability issues.
All of the databases work fine. There's no "best". I think the skills of your people, and the software you use, are the primary concerns. Microsoft SQL Server tends to be easier for many people to get started on, but it lacks some features that the other platforms have, has some advantages they don't.
August 23, 2010 at 8:15 am
Well put Steve..... BRAVO!
September 30, 2010 at 10:53 pm
A database can be a set of flat files stored on computer tape or disk or it could consist of database tables that are managed by a Database Management System (DBMS).
There are different types of DBMS products: relational, network and hierarchical. The most widely commonly used type of DBMS today is the Relational Database Management Systems (RDBMS).
Some Data Base Management Systems can be accessed directly using programming languages such as COBOL while others provide their own programming language for interacting with the database. Many DBMS applications also provide reporting and query tools to view data in the database.
______________
December 15, 2011 at 4:35 am
You don't want your average business person mucking about in your database. First thing is to have something in front of it to make it easy for those people.
Next, the best one... the one you know. Every one of the RDBMS systems out there can handle fundamental business information storage and retrieval. All of them. So the best one is the one that you can support. Personally, I know the least about DB2, so I don't think I'd pick that for my business. I know the most about SQL Server. That's probably what I'm going to pick. But, if the business couldn't afford SQL Server, I might go to MySQL because I know a little about that. But it's based on my knowledge, not whether or not the business can run on the system.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 15, 2011 at 6:19 am
forumreg711 (9/30/2010)
There are different types of DBMS products: relational, network and hierarchical. The most widely commonly used type of DBMS today is the Relational Database Management Systems (RDBMS).
You are showing your age pal 😀
Don't worry, I myself started my "database career" working with Cincom's Total - probably the most beautiful "network" dbms ever created.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 15, 2011 at 11:55 am
Impossible to say without knowing the business. I have a friend who owns a small (2 employees) side business who was looking at moving all his paper records to an electronic version. After figuring out what kind of records he was keeping and taking his sales figures into consideration I told him for his purposes access and excel would work fine. I would get laughed at if I ever recommended the use of access in a project meeting though...
December 15, 2011 at 12:03 pm
I'll join the fray and answer this question over a year late.
A best DBMS is one that fits your needs, performance, cost, scalability and support. If that is Firebird - then fine. If you think you can accomplish it in Excel - be my guest. Just dot your t's and cross your i's.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2011 at 12:05 pm
LOL...didn't even realize this was from 2010.
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply