| Author |
 Topic Search  Topic Options
|
SlumKing 
Newbie
Joined: 30 March 2003
Location: Scotland
Status: Offline
Points: 4
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: creating a web-database
Posted: 30 March 2003 at 10:34am |
Need to know for a project of mine
Cheers
Derek McCormack
|
 |
Gullanian
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
SlumKing
Newbie
Joined: 30 March 2003
Location: Scotland
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
Gullanian
Senior Member
Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
SlumKing
Newbie
Joined: 30 March 2003
Location: Scotland
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
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/ 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?
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
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
Edited by Bunce
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
