What is advantage and disadvantage of DBMS?
349121
Advantages of a Database\n·        Reduction in data redundancy \n·        Maintenance of data integrity and quality \n·        Avoidance of inconsistency  \n·        Reduced cost of software development  \n·        Security restrictions  \n\n\nThe biggest advantage is that if a standard way to organize and store data that  allows you to decouple the representation of the data from the software that uses it.\n\nThis allows you to move or reorganize data without have to find every program that uses the data and change them to match the change in the data. \n\n\naccess speed and increase in space to represent the data are the big disadvantages.
133043
Microsoft SQL Server and Oracle Database are both relational database products that are used to store and organize information. The major differences are:\n\n1. Procedure languages: SQL Server uses T-SQL while Oracle uses PL/SQL.\n\n2. Platforms: SQL only runs on Windows (duh) while Oracle runs in Unix, Linux, and Windows.\n\n3. Oracle is marginally more expensive than SQL server. In addition SQL server has more add-on products included.\n\n4. Oracle is generally recognized as more scaleable than SQL  server -- primarily due to support on large SMP Unix hardware.\n\n5. SQL Server is intented to be more user-friendly and does not require a specialized DBA to maintain the database.\n\n6. SQL Server supports many extensions using .NET while Oracle integrates with Java.\n\n7. Oracle supports more advanced features for data objects, maintenance functions, and database partitioning, though SQL is catching up.\n\n8. Oracle has been considered as generally more secure. SQL's security issues are often related to Windows issues. Later versions of both products have much improved security.\n\nPicking a database is a complicated and you need to be careful to define your client and backend requirements.
416714
good for standardizing data between different RDBMs\ngood as a medium form in converting from RDBMs to another\ngood in webpages\n\nyou cannot compare XML with the above RDBMs because XML is not a database its just a temporary data storage form
669433
Both have their advantages...........and disadvantages.
414169
Access is Microsofts attempt to do databases which is horrible. SQL or Oracle are better but people still use that for some reason. Below are links on Amazon for books on Access 2003 best is to just follow through one of those and fumble around to teach yourself.
487089
The main advantage of a network is that computers can share information.  A computer network can store more data than a stand-alone computer.  This is great if you have a business because your employees can exchange vital information easier.\n\nThe main disadvantage would be security concerns, i.e. someone hacking into your network.  However, you can buy software and hardware to help prevent this.  Just remember that any protection you get can be broken if the hacker has enough time and patience.
605942
I think there are more challenges than advantages in this situation.  First of all, if you all don't have the same naming conventions you are screwed right off the bat.  Secondly, how are you going to split the work?  Because you can't have people working on the same table or query or report at the same time.  It just seems like a nightmare to me.  I develop extensive Access databases and much prefer to work alone.  I have an assistant, but I keep him mainly on troubleshooting and maintaining databases after I have created them.  Who knows how many problems you will run into.  Is this a school project or work?
937744
If what you are asking is what you can use to store and manage data (don't know about the 'buy' part) I can take a stab at it. \n\nI am a software engineer that has been writing database applications for 13 years. What I have used are:\nMicrosoft Access (http://office.microsoft.com/en-us/access/default.aspx)\nMySQL (an Open Source, free database) (http://www.mysql.com/)\nMicrosoft SQL Server (http://www.microsoft.com/sql/default.mspx) and \nOracle (http://www.oracle.com/index.html).  \n\nThese are pretty much the viable solutions depending on the application. MS Access is more of a poor-mans solution but certainly capable of handling 100's of thousands of rows of data, MySQL is a bit more complex but has evolved and even has a User Interface to manage the database now and fairly capable in terms of it's data capacity. SQL Server/Oracle are the full-blown Database Management Systems (DBMS) that cost the big bucks to license but are what large enterprises/web sites use to hold all their data.\n\nHope this helps.
228687
These are two types of database managment softwares in a nutshell RDBMS are better becaus they reduce data redundancy (data duplication) by using Normalization.\n\nfor a database to be classified as RDBMS they have to follow certin rules by Dr. EF Codd.\n\nyou questions answer is quite descriptive, why dont you try the following links:\n\n1. http://www.webopedia.com/TERM/R/RDBMS.html\n2. http://en.wikipedia.org/wiki/RDBMS\n\nyou'll learn more this way.\n\nbye
80708
The advantage is it's free.\n\nThe disadvantage is that is very unsophisticated and gives you very little control as what to allow in or out.\n\nZone Alarm is a much better choice.
1033121
That being a microsoft program u can use a ligter version which i beleive is free too... it's called SQL 2005 Express Edition... if you want something fully robust and not deal with the high cost, I would personally recommend MySQL. I have used it in all my softwares and we currently use it in our main datacenter to handle all our data from our 35 remote offices world wide... it is extremely fast... we handle over a million transactions a day... give it a try.
46332
The main thing is that how to divide the application design between java and pl/sql. Generally java is used for the display and the front end and pl/sql for backend. So that if the need arises to change the business login then it is a lot more easier in pl/sql than in java. In case of implementing business logic, java have to make seperate calls for all the database access thus resulting in high overhead. Whereas in pl/slq the complete business logic can be written at the backend and only single call from java give desired results. Thus the application user interface design and navigation logic is implemented in java and complete business logic( i mean the data manupulation and calculations) is implemented in pl/sql.
1135447
One thing they both have in common is that they are both powerful and excellent SQL database management systems, evolved from years of constant research and improvement. They are both more than capable of handling large amounts of data and heavy workloads on Linux, Unix, and Windows, provided the DBAs and sysadmins are adequately trained. Proof of the capabilities of both Oracle and DB2 can be found at http://tpc.org which publishes the results of strictly regulated database benchmarks that must be independently audited for accuracy in all areas.\n\nAlthough limited editions of many database products, including DB2 and Oracle, are available for production use at no cost, DB2  Express-C edition is far less limited: Express-C allows the use of dual-core CPUs, 64-bit addressing, up to 4GB of system RAM, and no data size limit whatsoever.\n\nOracle stores its tables within schemas of an instance, while DB2 has the concept of a database that sits above the tables but below the instance level.\n\nOracle manages usernames and passwords within the DBMS, while DB2 uses O/S level groups, usernames, and passwords for authenticating connections to DB2. However, DB2's authentication can be adjusted to use LDAP, Active Directory, or third party authentication plugins like Kerberos.\n\nEach DBMS offers a different dialect of proprietary SQL that you may decide to use in your applications. However, it is possible to minimize or even eliminate proprietary SQL in favor of ANSI standard SQL. Some shops will even go as far as to demand that proprietary SQL in the application be kept to a minimum just in case they decide to migrate to a different DBMS someday.\n\nOracle and DB2 offer different types of storage enhancements for their tables. As with most differences between the two, the pros and cons of each difference are hotly debated. \n\nOn the high end, when a database is partitioned across multiple machines for improved scalability, DB2 uses a shared-nothing architecture in its Data Partitioning Feature, while Oracle Real Application Cluster requires a shared disk. \n\nIn about a month, IBM will be releasing version 9 of DB2 for Linux, Unix, and Windows, which will offer many new features, including a hierarchical storage engine (pureXML) that is optimized for truly native handling of XML data, not just shredding it or treating it as a BLOB/CLOB. DB2 9 will also offer a completely new mechanism for compressing data within each table that is arguably superior to Oracle's compression scheme, since patterns within a column can be compressed, as well as patterns of data that span multiple contiguous columns. \n\nAnother new interesting feature unique to DB2 9 is an autonomic performance tuning subsystem called self-tuning memory management, that can be enabled to constantly monitor important configuration settings and adjust them to maximize performance, even as the workload changes. This is a big help for DBAs who would tune for OLTP and get clobbered when the workload switched over to a series of batch jobs each night.
133576
the database + the management softwares
860812
when you have specific questions like that, make the search (yahoo/google) your friend.  That's how all programmers get quick information.  Do you have to use access?  SQL Server is so much easier to use and more robust.
707588
I'm assuming you mean: CD-ROM\n\nThe advantages would be: They let you read CD's\n\nThe Disadvantage is: They don't write CD's, or read or write DVD's
235181
1> When a lot of records exist in a single table, indexing is an issue\n2> Procedure compilation is a bit limited than oracle\n3> Works only on Windows platform\n4> No rollback segments as like in Oracle\n5> Archivelog not supported well as in oracle\n6> Not for very large data warehouses