corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Database Application Question:


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Database Application Question:
VegasPhil
Premium Member

Avatar

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
14th Nov 05 at 14:03   View Garage View User's Profile U2U Member Reply With Quote
Hi, Just been asked to define pros and cons and write a little bit about each database application below:

Oracle
SQL Server
Microsoft Access
Informix

Started on Oracle Pros, couldn't find a lot of information, so far got:
• Easy Setup
• It’s Free
• Separate Databases protect against Oracle Errors

Cheers



Corsa 2.0 16v Vegas - Sold
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
14th Nov 05 at 14:06   View Garage View User's Profile U2U Member Reply With Quote
MS Access.

Provides simple ways to link a database to a Visual Basic rendered front end.

Thats all I know

Lotus Elise 111R

Impreza WRX STi
VegasPhil
Premium Member

Avatar

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
14th Nov 05 at 14:23   View Garage View User's Profile U2U Member Reply With Quote
That's what we're doing

Corsa 2.0 16v Vegas - Sold
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
14th Nov 05 at 14:27   View Garage View User's Profile U2U Member Reply With Quote
A2 Computing?

Lotus Elise 111R

Impreza WRX STi
VegasPhil
Premium Member

Avatar

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
14th Nov 05 at 15:42   View Garage View User's Profile U2U Member Reply With Quote
BTEC National Diplona: IT Practitioners

Corsa 2.0 16v Vegas - Sold
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
14th Nov 05 at 17:08   View Garage View User's Profile U2U Member Reply With Quote
Ah cool.

I did all this shizzle at A level

Lotus Elise 111R

Impreza WRX STi
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
14th Nov 05 at 17:21   View Garage View User's Profile U2U Member Reply With Quote
Oracle
SQL Server

Pros - Both enterprise scale (ie. loads of data, big structure), both support multiple connections to the same data, both support commit and rollback, no GUI so integrates efficiently with other apps; Java, VB if MS, web apps, whatever. Fully configurable permissions so per table, different privs within one table for different users etc.

MS SQL integrates with NT domain for authentication? Not sure any other reason to use it...

Cons - Difficult to set up, costly to administer.

Microsoft Access

Pro - cheaper and easier to use

Cons - shit

Informix

Informwwhooo?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
14th Nov 05 at 17:22   View Garage View User's Profile U2U Member Reply With Quote
Actually Access supports multiple connections via ODBC....
VegasPhil
Premium Member

Avatar

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
14th Nov 05 at 18:07   View Garage View User's Profile U2U Member Reply With Quote
OK, Cheers Ian. Yeh i'll try to find out something about Informix, I might jst have spelt it completley wrong .

We will be using MS Access to produce this. I just have to write a bit about each one to like research the possibilities or whatever.

Corsa 2.0 16v Vegas - Sold
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
14th Nov 05 at 18:40   View Garage View User's Profile U2U Member Reply With Quote
Your conclusion will probably be that you don't need fancy locking or commit/rollback and that you like Access interface with forms/queries etc. nice and point and click.

Disappointed MySQL isn't in there though, ask your tutor why the db powering this forum and many other web applications around the world isn't in your list but a company more famous for managerial blunders than fast queries is.

http://en.wikipedia.org/wiki/Informix
VegasPhil
Premium Member

Avatar

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
14th Nov 05 at 18:49   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
Your conclusion will probably be that you don't need fancy locking or commit/rollback and that you like Access interface with forms/queries etc. nice and point and click.

Disappointed MySQL isn't in there though, ask your tutor why the db powering this forum and many other web applications around the world isn't in your list but a company more famous for managerial blunders than fast queries is.

http://en.wikipedia.org/wiki/Informix


I'll ask him tomorrow

Corsa 2.0 16v Vegas - Sold
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
14th Nov 05 at 21:59   View Garage View User's Profile U2U Member Reply With Quote
we use informix at work.

Fuck knows what it is.


or does.




Lotus Elise 111R

Impreza WRX STi
VegasPhil
Premium Member

Avatar

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
16th Nov 05 at 12:31   View Garage View User's Profile U2U Member Reply With Quote
Asked the tutor about MySQL.

Answer he gave was. We need to use Access. We're just exploring the possibilities. He says MySQL is better than Access . A couple of cons he gave is we have to get a copy and put it on the system etc. Then teach everybody to use it.

Corsa 2.0 16v Vegas - Sold
Sam
Moderator
Premium Member

Registered: 24th Dec 99
Location: West Midlands
User status: Offline
16th Nov 05 at 12:52   View User's Profile U2U Member Reply With Quote
MS Access is slow and crap!
VegasPhil
Premium Member

Avatar

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
17th Nov 05 at 00:57   View Garage View User's Profile U2U Member Reply With Quote
^ I wasn't allowed to put that

Corsa 2.0 16v Vegas - Sold
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
17th Nov 05 at 01:00   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by VegasPhil
He says MySQL is better than Access
Good lad.

He's right thought, slightly more difficult to get going with it.
Tim
Site Administrator

Avatar

Registered: 21st Apr 00
User status: Offline
17th Nov 05 at 09:52   View Garage View User's Profile U2U Member Reply With Quote
Oracle is not free. An Enterprise license is STUPIDLY expensive...

They may provide a download link but that's for developers
Gavin
Premium Member

Avatar

Registered: 3rd Apr 02
Location: West Midlands
User status: Offline
19th Nov 05 at 13:25   View Garage View User's Profile U2U Member Reply With Quote
Oracle

better secuirty and support

*i believe*

pew pew pew pewwwww

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Anybody know anything about the OSI 7 layer network model? Recaro1 General Chat 16 541
17th Mar 03 at 20:52
by Mikee24		  
car insurance set to rise by £60? mk4_astra General Chat 5 1408
26th Jan 04 at 20:15
by Nath		  
Help with transferring a private reg Kerry General Chat 39 1438
31st May 04 at 15:01
by Kerry		  
C Programming luca2020 General Chat 14 1198
18th Jul 04 at 22:17
by Ian		  
Writing a PHP forum from scratch James Geek Day 8 1017
2nd Nov 05 at 23:40
by Ian		  

Corsa Sport » Message Board » Off Day » Geek Day » Database Application Question: 29 database queries in 0.0142231 seconds