The difference between MySQL and other DBMS Choose better DBMS for web service

[bx93 0]

Maybe Mysql is the most popular DBMS used in Web programming, but what about the others such as Oracle, DB2?How to choose the better one in website planning?

[jackson_cn 0]

and the MS Access or .txt file DB

[bx93 0]

Oh, yes. But MS Access may only run on MS platform, could it run on Linux server?Another question: Is .txt file DB easy to be used? and what's the performance bottleneck?

[dissipate 0]

flat files (.txt) vs. RDBMss (relational database management systems)

 

problems with flat files

- when the file gets large (if you store tons of stuff), it can be very slow to work with.

- searching for a particular record or group of records is difficult

- it's a problem if many people want to access the file at the same time, e.g. if you are using a flat file for an ecommerce site and two people are placing orders at the same time. to avoid this problem, file locking is used. but what if there are 100 people placing orders at the same time? people will have to wait for the file to be unlocked -> bottleneck.

- inserting records into or deleting records from the middle of the file is quite difficult and significant overhead is caused if the file is big and you do this.

- it's not possible to offer different levels of access to the data in the file as you can only set file permissions.

 

RDBMss in response

- provde faster access to data compared to flat files.

- can easily be queried to retrieve a record or sets of records.

- deal with concurrent access with built-in mechanisms, no worries on your side.

- provide random access to data, addressing the middle of file issue

- have built-in privilege systems.

 

 

i think if you're just trying to store small sets of data and not many people are going to be accessing the database at the same time to write to it, flat files are alright. otherwise, RDBMss are better.

[honeycomb 0]

mysql is fast DBMS, but it lack some complex feature , such as store procedure, and sql query like "select * from adb where id in (select id from bdb)" is not alowed. in many cases , mysql is enough. it can run windows and linux.

[The Mortgage Man 0]

Not knowing mySQL well, here is my best guess.MySQL should be fine for personal stuff, and for proto-typing. Porting/adapting SQL code is no big deal if you are a competent programmer.Oracle and DB2 seem to be preferred by Brick and Mortar companies. More progressive companies seem to be happy with mySQL, and other SQL databases.If you want to be saleable as a consultant, you'd do well to have Oracle on your resume. I see a lot more jobs for Oracle than DB2.

[snowlion 0]

i'm lil confused..can anyone help..when do u use MySQL and when do u use ORACLE Database??

[rhammadkhan 0]

Maybe Mysql is the most popular DBMS used in Web programming, but what about the others such as Oracle, DB2?

How to choose the better one in website planning?

<{POST_SNAPBACK}>

well..thats easy-

for larger databases .txt files have soo many problems including inconsistency of data, repitition of records wrt to the departments. Specially if we talk abt the case of larger databases, difficult to handle nonstandard approaches to get into DBases.

Now abt Databases and Relational Databases. Relational ofcourse uses Connectivity relationships. MYSQL and SQL and Oracle.

MySql is less secure than Oracle or SQL -

MySql is Opensource thats why it is used more, otherwise there is nothing such that its better than SQL or ORacle.

adios