473,587 Members | 2,412 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DBMS advantage and disadvantage

Hello,

My company want to use database for ERP, any website to discuss DBMS
advantage and disadvantage ? or someone post to here for references ?
Thanks
Jun 27 '08 #1
12 6390
leiw wrote:
Hello,

My company want to use database for ERP, any website to discuss DBMS
advantage and disadvantage ? or someone post to here for references ?
Thanks
As in an Oracle group they'll tell you about Oracle.
Ask in a DB2 group they'll tell you about DB2.
Ask here and they'll tell you about SQL Server.
And there is no way you'll be able to weigh the varying opinions.

No group is going to post anything that isn't specific to what they know
best.

If you want objective information this is about the worst way to ask for
it imaginable.

The question is which ERP system are you going to buy? For all intents
and purposes there are only two vendors ... Oracle and SAP. Oracle will,
of course, preferentially support their own database. And it is no
secret that SAP sells most of their systems on top of Oracle.

My recommendation is not that you should jump on Oracle without making
a good evaluation of competing systems. But you should approach this
from the ERP vendor decision first.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu (replace x with u to respond)
Jun 27 '08 #2
DA Morgan (da******@psoug .org) writes:
The question is which ERP system are you going to buy? For all intents
and purposes there are only two vendors ... Oracle and SAP. Oracle will,
of course, preferentially support their own database. And it is no
secret that SAP sells most of their systems on top of Oracle.
A company that I do work for, uses an ERP system which appears to come
from Oracle. And based on that experience, I strongly recommend getting
something else. I only use it to report my hours, and the interface for
it sucks big time. At one point, I had to check an invoice and that was
a whole worse! I see colleagues who have to register travel expenses, and
I don't envy them.

Of course, it may be that the local implementation of Oracle ERP is
unusually poor at this site. But I'm really surprised that Oracle agrees
to put its name on such crap.

In any case, there are more alternatives on the market than Oracle and
SAP. I believe that I know of three only in the Nordic countries. Surely
there are a lot more world-wide. Oracle and SAP may be the only on the
global market, and that are able to handle major companies.
My recommendation is not that you should jump on Oracle without making
a good evaluation of competing systems. But you should approach this
from the ERP vendor decision first.
Yup. Get the product first. Then decide on the RDBMS, if the vendor
offer you a choice. But take a look at what they offer. If they suggest
that you would run their system on Access or Paradox, look for a
different vendor. :-)

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '08 #3
Hi Leiw,

Ignore DA Morgan - he's the most anti-Microsoft person you will come across;
he is very very anti SQL Server because he knows full well that it's beating
Oracle up left right and centre in the BI and RDBMS market on the Windows
platform - the platform of choice for most businesses.

A place to start to is
http://www.microsoft.com/dynamics/na...questions.mspx

The Microsoft product set you are talking about for ERP is Microsoft
Dynamics.

Tony.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"leiw" <no**@000.comwr ote in message
news:15******** *************** *************** @0000.com...
Hello,

My company want to use database for ERP, any website to discuss DBMS
advantage and disadvantage ? or someone post to here for references ?
Thanks
Jun 27 '08 #4
More biased retric Denial Again?

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"DA Morgan" <da******@psoug .orgwrote in message
news:12******** *******@bubblea tor.drizzle.com ...
leiw wrote:
>Hello,

My company want to use database for ERP, any website to discuss DBMS
advantage and disadvantage ? or someone post to here for references ?
Thanks

As in an Oracle group they'll tell you about Oracle.
Ask in a DB2 group they'll tell you about DB2.
Ask here and they'll tell you about SQL Server.
And there is no way you'll be able to weigh the varying opinions.

No group is going to post anything that isn't specific to what they know
best.

If you want objective information this is about the worst way to ask for
it imaginable.

The question is which ERP system are you going to buy? For all intents
and purposes there are only two vendors ... Oracle and SAP. Oracle will,
of course, preferentially support their own database. And it is no
secret that SAP sells most of their systems on top of Oracle.

My recommendation is not that you should jump on Oracle without making
a good evaluation of competing systems. But you should approach this
from the ERP vendor decision first.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu (replace x with u to respond)
Jun 27 '08 #5
Erland Sommarskog wrote:
DA Morgan (da******@psoug .org) writes:
>The question is which ERP system are you going to buy? For all intents
and purposes there are only two vendors ... Oracle and SAP. Oracle will,
of course, preferentially support their own database. And it is no
secret that SAP sells most of their systems on top of Oracle.

A company that I do work for, uses an ERP system which appears to come
from Oracle.
I would have expected something better than this from you. "Appears to
come?" You don't know what is is. You don't know what version it is?
You don't know how old (obsolete) it may be? And you don't know how
well or poorly managed it has been. Hardly the basis for rendering an
opinion one way or the other.
Of course, it may be that the local implementation of Oracle ERP is
unusually poor at this site. But I'm really surprised that Oracle agrees
to put its name on such crap.
One paragraph ago you didn't know the name of the product and now you
are jumping to Oracle putting its name on it? I'm disappointed.
In any case, there are more alternatives on the market than Oracle and
SAP.
There are indeed. But no one I know takes any of them seriously. And
try to find a pool of experienced professionals to install, configure,
and manage them. Good luck! An ERP system without a certain critical
mass of technical expertise in the marketplace is a great way for an IT
manager to get an opportunity to work on a career change.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu (replace x with u to respond)
Jun 27 '08 #6
Tony Rogerson wrote:
Hi Leiw,

Ignore DA Morgan - he's the most anti-Microsoft person you will come
across;
The fine folks in Redmond don't seem to agree with you Tony. <G>

Do you have to work at being a clown or is it a talent?
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu (replace x with u to respond)
Jun 27 '08 #7
Tony Rogerson wrote:
More biased retric Denial Again?
So, in other words, you think someone should pick their database vendor
first and then go shopping for an ERP vendor. Brilliant. I presume you
get paid by the hour.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu (replace x with u to respond)
Jun 27 '08 #8
DA Morgan (da******@psoug .org) writes:
I would have expected something better than this from you. "Appears to
come?" You don't know what is is. You don't know what version it is?
You don't know how old (obsolete) it may be? And you don't know how
well or poorly managed it has been. Hardly the basis for rendering an
opinion one way or the other.
Let me put it this way: I know very well what I have to use every
day is a piece of crap. It scares me to know that there are probably
people in this corporation that use data the employees enter as some
sort of fact and performs analysis from it. But given how poor the
UI is, as a user you easily cut corners and you are not terribly
exact when you report your times.

When I say that it appears to come from Oracle, it is because it says
Oracle in several screens. But I would really like to think that such crap
can not come out from a vendor like Oracle. It more looks like some
locally developed hack that had a limited budget. In fact, the system
is referred to as TERP where the T comes from the company's name.

It is quite possible that this is a bad implementation of Oracle ERP.
Then again, I would expect the entry forms for time reporting to be
quite standard. Or do they do UI developement for each customer?
Because it is the web UI that sucks big time.
There are indeed. But no one I know takes any of them seriously. And
try to find a pool of experienced professionals to install, configure,
and manage them. Good luck!
As I said, there are at least three local vendors here on the Nordic
market. It is not that all them are thriving, but they are there.

Furthermore, maybe it's worth considering the size of the company.
I suspect that leiw who asked this question is not working for a large
corporation, but rather a small shop with < 100 employees. I have a
feeling that SAP or Oracle ERP is not really the choice here.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '08 #9
Erland Sommarskog wrote:
DA Morgan (da******@psoug .org) writes:
>I would have expected something better than this from you. "Appears to
come?" You don't know what is is. You don't know what version it is?
You don't know how old (obsolete) it may be? And you don't know how
well or poorly managed it has been. Hardly the basis for rendering an
opinion one way or the other.

Let me put it this way: I know very well what I have to use every
day is a piece of crap.
Most people feel the same way you do and I would expect that the
vast majority are correct.
It scares me to know that there are probably
people in this corporation that use data the employees enter as some
sort of fact and performs analysis from it. But given how poor the
UI is, as a user you easily cut corners and you are not terribly
exact when you report your times.
Again I'm not disagreeing. But keep in mind that for any of the major
ERP systems these UI's have undoubtedly been extensively customized by
your employer.
When I say that it appears to come from Oracle, it is because it says
Oracle in several screens. But I would really like to think that such crap
can not come out from a vendor like Oracle. It more looks like some
locally developed hack that had a limited budget. In fact, the system
is referred to as TERP where the T comes from the company's name.
It may well be something from Oracle ... it may not be ... still
impossible to tell. But do keep in mind that Oracle just purchased
PeopleSoft, J.D. Edwards, Siebel, and a large number of other vendor's
products and has not yet had time to create a major release of their
own in any of them. Check into Project Fusion.
It is quite possible that this is a bad implementation of Oracle ERP.
That wouldn't surprise me.
Then again, I would expect the entry forms for time reporting to be
quite standard. Or do they do UI developement for each customer?
Time reporting is always customized. And the best time reporting of
which I am aware in any major ERP system is PeopleSoft's. My
understanding is that it is the PeopleSoft screen that will be used
as the basis for Fusion but that is just rumor and I could be wrong.
Because it is the web UI that sucks big time.
Oracle is no Apple but then it could just be customizations. I can't say.
As I said, there are at least three local vendors here on the Nordic
market. It is not that all them are thriving, but they are there.
You might want to contact Mogens Norgaard at Miracle A/S in Denmark.
He is your local Nordic expert on all things Oracle and SQL Server
though I don't believe Miracle works with apps.
Furthermore, maybe it's worth considering the size of the company.
I suspect that leiw who asked this question is not working for a large
corporation, but rather a small shop with < 100 employees. I have a
feeling that SAP or Oracle ERP is not really the choice here.
You may well be right. But that does not change the calculus. First
you pick your ERP vendor. Then you pick the databases they support.
If the ERP vendor is small and only supports SQL Server 2000 then
the entire issue becomes moot.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu (replace x with u to respond)
Jun 27 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3950
by: Alex_Bxl | last post by:
Hi to all I have to choose a DBMS and a database architecture for an Ebay like website about to be launched. The company wants to use a web hosting service and not host the database on dedicated servers at the office. The database will contain web-only information and lots of back end information that is not really needed to be stored...
10
1912
by: Fred the man | last post by:
Hi, Some of our customers have remote offices. I was wondering if it'd be safe to have a DBMS running at their central office, and have our client application running on hosts in the branches connect to it through a VPN via the Net? What happens if the connection goes south while a branch office was making changes? Does the DBMS just...
2
1817
by: Tony Johansson | last post by:
Hello experts! My question is what advantage and disadvantage have public inheritance. The answer that I have to this is that sometimes it is an advantage to let a client have access to everything declared in the public section of the derived class and the base class and sometimed it is an disadvantage. Another important advantage is...
19
7703
by: cody | last post by:
Iam wondering what the benefit of using const over static readonly is. static readonly is a runtime constant and can be set once in the initializer or the static ctor, whereas const is suffering from binary incompatibility since it is hardbaked into the binary. I do not believe there is a performance advantage with using const over static...
5
4486
by: Jason Ho | last post by:
Hi, For distributing .NET application, client need to install .NET framework. Especially for win98/Me users, installing the framework need to restart computer and it takes a quite long time for the whole installation process. Do you think it is a serious disadvantage for developing application e.g. ImageViewer in .NET at this moment?...
50
8506
by: lovecreatesbea... | last post by:
Could you extract examples of the characteristics of C itself to demonstrate what the advantages of C are? What are its pleasant, expressive and versatile characteristics? And what are its disadvantages?
0
992
by: manyuaditya | last post by:
Hi, I'm developing this scientific application that does the following- 1. read a data table ( 100's of millions of rows ) 2. Create a tree out of this data ( a kd-tree which is sort of like a binary search tree but over multiple dimensions ) 3. store this tree in a database table Part2
2
2489
by: Tony Johansson | last post by:
Hello! Below I have a working program. I have one generic class called Farm<T> with this header definition public class Farm<T: IEnumerable<Twhere T : Animal Now to my question I changed the inheritance of the IEnumerable from the generic IEnumerable<T> to the generel IEnumerable and the program function just the same so no
8
3044
AmberJain
by: AmberJain | last post by:
Hello, My new semester has started and I have a subject named DBMS (Database Management System). This is the first time I'm studying databases and so I'm not feeling very enthusiastic about databases (partly because I already had learnt C/C++ and I feel that programming is a lot easier that DBMS). Nevertheless, I must learn at least one DBMS as...
0
7918
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7843
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8206
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8340
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7967
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6621
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5713
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3840
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.