Database Discussion - creating a web-database

Print Page | Close Window

creating a web-database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1485
Printed Date: 29 March 2026 at 2:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: creating a web-database

Posted By: SlumKing
Subject: creating a web-database
Date Posted: 30 March 2003 at 10:34am

Does anyone know the most appropriate programming languages/technologies/vendor products behind building a web database? such as the one at https://www.insurance.co.uk/insurance/ - https://www.insurance.co.uk/insurance/ ?

Need to know for a project of mine

Cheers

Derek McCormack

-------------
student needs help

Replies:

Posted By: Gullanian
Date Posted: 30 March 2003 at 11:12am

Ok well, if you talking about the most appropriate database to use, lloyds are probably using Microsoft SQL

Languages to connect and pass queries through to a Microsoft database with most ease are ASP and ASP.net.

Posted By: SlumKing
Date Posted: 30 March 2003 at 12:14pm

Thanks, that will be right.

I wasn't sure as there seems to be so many technologies for integrating web & DBMSs (xml, java, PHP, Perl, CGI)...

Do you rate the Oracle internet platform?

-------------
student needs help

Posted By: Gullanian
Date Posted: 30 March 2003 at 1:04pm

You wouldnt need to use Oracle unless you were developing a huge system, SQL can manage huge systems perfectly, for example if im not mistkaen Amazon.com runs off an SQL database, so unless your talking bigger than amazon you shouldnt need to think about oracle.

MS Access database wasnt designed for web use, you should only use it for very small applications.

Posted By: SlumKing
Date Posted: 30 March 2003 at 1:40pm

Absolutely true.

I might as well ask as you seem very knowledgeable.

See at https://www.insurance.co.uk/insurance/ - https://www.insurance.co.uk/insurance/ for example if I ordered car insurance they don�t actually sell it but offer a selection from different panels of insurers.

Are all those car quotes stored on the one SQL server?

Or does this company somehow communicate in real-time with those panels of insurers� databases?

-------------
student needs help

Posted By: michael
Date Posted: 30 March 2003 at 2:47pm

Usually those are linked database systems, where each insurance gives query rights, or they are grabbing data with xml or so.
To add to Gullanians about Oracle> It is not necessarily a huge system that needs Oracle. It so much depends on the type of application. There are many things oracle can do sql server cannot natively. For example in oracle you can execute a query like
INSERT INTO ACCOUNTS
(SELECT * FROM ACCOUNTS AS OF TIMESTAMP
TO_TIMESTAMP(�31-MAR-03 16:44:58�,�DD-MON-YY HH24:MI:SS�)
MINUS
SELECT * FROM ACCOUNTS);
This would let you roll back a "Human error" for example. Only the transactions in Accounts would be rolled back. In SQL you would have to do a transaction log restore to that point, at this time the db would be offline and all other tables would be rolled back as well. That is just one example. Like I said it always depends on what you want to do. For most web based applications SQL server is more then sufficient though.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Bunce
Date Posted: 30 March 2003 at 5:05pm

Cool! Didn't know you could do that. So there's like an inbuilt flag on every record with a date-created value stored (or linked live to the trans log somehow.) Is there mcuh overhead in this?

I suppose you could just use a timestamp field in SQL but you're right, its not native.

Gullanian, I don't think you can simply assume that a certain website is using a certain database. There are many different platforms, which all have there place depending on the system requirements.

Likewise, I don't think you can assume that ASP or even ASP.Net is the 'easiest' language to use to develop data-enabled web-sites. Again it depends on the developer and the system

I personally think that for a new developer with little coding background, ColdFusion is the easiest language to get started in. But thats just my opinion.

Cheers,
AH

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: michael
Date Posted: 30 March 2003 at 6:01pm

Bunce, it takes those values out of the transaction log. In SQL there are excellent tools like Lumingent Log Explorer to do that but it's so easy in Oracle. Also one feature I hate in SQL, for an application we must limit the transaction log file size but we must keep it because it's for banking purposes. Now we have to run a transaction log backup every day in Oracle you can automatically archive logs. Anyway, you are right, it is very hard to guess what backend they are using. Lots are using DB2 because it is very wasy to tie it to their AS/400 hosts system. there are just to many to guess.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: SlumKing
Date Posted: 14 April 2003 at 3:56pm

Does anyone know how for instance at https://www.insurance.co.uk/ when I type in my postcode they automatically display my address and door number. Do they have this information or is it stored by some third party database?

-------------
student needs help

Posted By: ultramods
Date Posted: 15 April 2003 at 5:28am

Yes they would be using a third party database. I found this one http://www.afd.co.uk - http://www.afd.co.uk