dbTalk Databases Forums  

Re: [Info-Ingres] Forrester's Enterprise DBMS report

comp.databases.ingres comp.databases.ingres


Discuss Re: [Info-Ingres] Forrester's Enterprise DBMS report in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Roy Hann
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 07-13-2009 , 07:08 PM






On net wrote:

Quote:
Roy - this isn't a dig at ingres corp I can see that they are trying
Heck, dig away, if digging is justified.

Just be right, or interesting.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

Reply With Quote
  #12  
Old   
Mark R. Winston
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 07-13-2009 , 08:55 PM






On net wrote:
Quote:
Emiliano wrote:
On 2009-07-13, On net <a@b.com> wrote:
Ingres badly needs a USP, or a clear cost advantage.
[snip]
..or ingres had some special characteristic/feature or speciality that
the others didn't have.

Ingres needs that USB and in some evolving technology.
While I was (briefly) at Ingres Corp. I suggested that the Top 3 value
propositions for INGRES were

1.) INGRES Net (now DAS): The ability to exchange data across platforms
is something that is increasingly a cost burden as it requires a lot of
intervention; if I can install INGRES across my enterprise and
consolidate I can, in most cases, replace much higher cost
aggregation/replication solutions. You can't do this with native
PostgreSQL or MySQL, support subscription (for the latter) or not.

I think this is more relevant now than it was a few years ago.

2.) Simple Backup/Recovery: Having worked in a environment that crammed
stuff down DMF's throat via RAAT <shudder>, I could vouch for INGRES'
backup and recovery integrity and relative ease on both Windows (NT4
even) and Unix (AIX 4.3 even ).

3.) Reverse Hybrid x64 GNU/Linux: I created a Sales PoC for INGRES x64
on RHEL4 vs. MSSQL Server 2005 x64 on Windows Server x64 for Service
Desk with a partner in preparation for the Service Desk r11 upgrade. In
short, the cost comparison, inclusive of the support subscription for
INGRES on GNU/Linux and the RHEL4 subscription, was 1/3 of that for
Windows Server 2003 x64 + MSSQL Server 2005 x64 per-socket licensing.

INGRES outperformed MSSQL Server on a 2-socket, dual-core CPU system
with 16GB of RAM because I was able to tune INGRES appropriately. The
angle was the Ingres Corp.'s SI partner would offer a complete "upgrade"
package, inclusive of the services at or below the cost of the Microsoft
licenses alone.

What was great, IMO, was that this was the perfect example of where the
DBMS was merely a repository for the application and there was full,
*pre-existing* support for both INGRES and MSSQL Server. Sold as a
packaged deal, the customer didn't need to worry about what was
persisting the data because they only interacted with the "front-end",
even for administration of the system. The Sales staff understood this
so well, both internally and at the SI partner, that they could repeat
it back to me with integrity. Dirt simple.


Ingres Corp. fumbled this so piss poorly it really soured me and, quite
frankly, I haven't seen much difference in the general business m.o.
since, specifically in the U.S. I know that there *is* much difference
in the U.K., EMEA, and ANZ regions, particularly with regard to
OpenROAD, but the general perception in the U.S., out of the mouth of
people with whom I interact from multiple regions and business and
technology sectors, regard INGRES as "legacy".

I make a consistent effort to different INGRES and OpenROAD as
technologies from Ingres Corp., the Oracle/CA Expat Exec Zone (excluding
the quality Engineers from this slight, of course).


--

Mark R. Winston
www.datavailable.com

Reply With Quote
  #13  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 07-14-2009 , 04:02 AM



I could not make dbjmin work with Ingres. Does anyone know how to
configure it?


--
dejan

Reply With Quote
  #14  
Old   
Bodo
 
Posts: n/a

Default Re: Forrester's Enterprise DBMS report - 07-14-2009 , 08:37 AM



On Jul 14, 12:57*am, On net <a...@b.com> wrote:
Quote:
...
When I used to be involved in discussions about why we should use ingres
versus Oracle or Microsoft I was never aware of any definitive way to show that
the ingres cost of ownership is significantly better than any of it's
rivals, and in the context of having a corporate where oracle and ingres
is in place, it's obviously beneficial to squeeze out ingres by offering
the stakeholders good deals in respect of the ingres projects.
...
The Ingres TCO Calculator at http://www.ingres.com/tco/ shows exactly
this.

Bodo.

Reply With Quote
  #15  
Old   
On net
 
Posts: n/a

Default Re: Forrester's Enterprise DBMS report - 07-14-2009 , 11:18 AM



Bodo wrote:
Quote:
On Jul 14, 12:57 am, On net <a...@b.com> wrote:
...
When I used to be involved in discussions about why we should use ingres
versus Oracle or Microsoft I was never aware of any definitive way to show that
the ingres cost of ownership is significantly better than any of it's
rivals, and in the context of having a corporate where oracle and ingres
is in place, it's obviously beneficial to squeeze out ingres by offering
the stakeholders good deals in respect of the ingres projects.
...
The Ingres TCO Calculator at http://www.ingres.com/tco/ shows exactly
this.

Bodo.
Aha!

I wish it had been around when I was having to defend using ingres
rather than Oracle, and still got forced into a migration plan that
delivered no benefit to the end user (or indeed anybody, though I seem
to recollect the initiative was spurred on by a hike in ingres licence
fees in those CA days).

Reply With Quote
  #16  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 07-14-2009 , 03:18 PM



After reading the source code (svn checkout 'dbjmin - Revision 135:
/trunk' (http://dbjmin.googlecode.com/svn/trunk/) dbjmin-read-only) of
this tool and a quick run indicates that it is a question of adding
Ingres JDBC configuration parameters for Ingres to DBConnector.java (
package db2jmin.pojo.data) to eliminate the NullPointerException.

It would be few hours of work to make source code
changes/compile/run/test to make sure it works with Ingres. Will get
back to this once I get cycles to work on this. The changes need to be
submitted back to this open source project along with Ingres JDBC driver
so that it gets put in the lib directory of dbjmin installation for easy
use of Ingres.

Regards,
Usha

C:\dbjmin-win>start_dbjmin.bat

C:\dbjmin-win>java -classpath
lib\;lib\iijdbc.jar;lib\db2jcc.jar;lib\db2jcc_lice
nse_cu.jar;app\;app\db2jmin.pojo.jar;lib\mysql-connector-java-5.0.3-bin.jar;lib\
ojdbc14.jar;lib\derby.jar;lib\derbyclient.jar;lib\ postgresql-8.1-407.jdbc3.jar;l
ib\jaybird-full-2.1.0.jar;lib\jetty-6.1.0.jar;lib\jetty-embedded-6.1.5.jar;lib\j
etty-util-6.1.0.jar;lib\servlet-api-2.5.jar; db2jmin.pojo.swing.Launch
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at
db2jmin.pojo.data.DBconnector.testConn(DBconnector .java:248)
at
db2jmin.pojo.util.InputDataValidation.formValidati onGen(InputDataVali
dation.java:121)
at
db2jmin.pojo.swing.SwingUtils.isValidFormData(Swin gUtils.java:448)
at
db2jmin.pojo.swing.ValidadeUserData4Connection.isV alidated(ValidadeUs
erData4Connection.java:55)
at
db2jmin.pojo.swing.Launch$1.actionPerformed(Launch .java:295)
at
javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:18
49)
at
javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.jav
a:2169)
at
javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel
.java:420)
at
javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:258
)
at
javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonL
istener.java:236)
at java.awt.Component.processMouseEvent(Component.jav a:5517)
at
javax.swing.JComponent.processMouseEvent(JComponen t.java:3135)
at java.awt.Component.processEvent(Component.java:528 2)
at java.awt.Container.processEvent(Container.java:196 6)
at java.awt.Component.dispatchEventImpl(Component.jav a:3984)
at java.awt.Container.dispatchEventImpl(Container.jav a:2024)
at java.awt.Component.dispatchEvent(Component.java:38 19)
at
java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4212
)
at
java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:3892)

at
java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:3822)
at java.awt.Container.dispatchEventImpl(Container.jav a:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791 )
at java.awt.Component.dispatchEvent(Component.java:38 19)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 463)
at
java.awt.EventDispatchThread.pumpOneEventForHierar chy(EventDispatchTh
read.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThre
ad.java:163)
at
java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:157)

at
java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:149)

at
java.awt.EventDispatchThread.run(EventDispatchThre ad.java:110)


--
rajus01

Reply With Quote
  #17  
Old   
James K. Lowden
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 07-14-2009 , 10:28 PM



On net wrote:
Quote:
I have seen and (been victim to) exactly the same tactics from SAP - who

seem to get senior management onboard, neatly sidestepping any
technical issues completely with a very smooth powerpoint performance.
How often is the decision in the hands of anyone who knows anything?

I worked a project 10 years ago. We started on Sybase, then moved to
Microsoft. As soon as it was in production, the whole thing was migrated
to Oracle. Where it lives today with some mumble glue to replicate to
downstream Microsoft servers. The hand-crafted stored procedures -- often
written in a peculiar way because of how Microsoft's query "optimizer"
behaved -- were mechanically converted to Oracalese. The result would
make it easy for a camel to win a beauty prize.

I was the senior designer. I developed the load jobs, indexes, views, and
stored procedures. No one ever asked me what the platform should be.

Then there's inertia. Nowadays I work in with a bunch of
quasi-programmers who share a research database. If Ingres came with with
5 years of free support and training *then* it might make sense to
consider switching instead of upgrading. But it's a huge risk and an
enormous undertaking to retrain a small army of people whose job isn't
really databases. The loss in productivity makes switching virtually
impossible absent a compelling stand-out feature.

Tutorial D, anyone?

--jkl

Reply With Quote
  #18  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 09-17-2009 , 02:20 PM



The changes to DBconnector.java and SwingUtils.java have been submitted
to 'Issue 2 - dbjmin - DBJMIN enhancements to connect to Ingres
database. - Project Hosting on Google Code'
(http://code.google.com/p/dbjmin/issues/detail?id=2) for including the
changes in the next release of this utility.

Regards,
Usha


--
rajus01

Reply With Quote
  #19  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 09-17-2009 , 03:17 PM



Hi Dejan,

If you want to try out the fix that I have made for Ingres, I am
attaching here-with a ZIP archive (db2jmin-ingres.zip) containing the
required jars. Extract the jars into a folder. You need JRE 1.5. Also, I
assume that you have Ingres up and running...

Command:
java -classpath .\iijdbc.jar;.\db2jmin.pojo.jar;.\rsyntaxtextarea. jar
db2jmin.pojo.swing.Launch

See how it goes....

Regards,
Usha


--
rajus01

Reply With Quote
  #20  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Forrester's Enterprise DBMS report - 09-17-2009 , 03:47 PM



Hi Dejan,

If you want to try out the fix that I have made for Ingres, I have
placed ZIP archive containing the required jars including the JDBC
driver that I used for testing in our FTP server: ftp.ingres.com.
(Login:anonymous, passwd:your e-mail address;cd
/outgoing/db2jmin-ingres;get db2jmin-ingres.zip) Extract the jars into a
folder. You need JRE 1.5. Also, I assume that you have Ingres up and
running...

Command:
java -classpath .\iijdbc.jar;.\db2jmin.pojo.jar;.\rsyntaxtextarea. jar
db2jmin.pojo.swing.Launch

Happy testing!

Regards,
Usha


--
rajus01

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.