answersLogoWhite
Oracle Database

Why oracle is so popular database vendor?

323334

Top Answer
User Avatar
Wiki User
2011-09-13 16:09:30
2011-09-13 16:09:30
Why Oracle Is So PopularIn a nutshell because for the longest time they had the best database with the best performance. DB2, SQLServer, and others have closed the gap, but they're still the Cadillac of databases. I know, I work with Oracle databases every day.
  • I have been an Oracle DBA, Informix DBA and am now an HPNonStop Tandem DBA. Along with Oracle's performance, it is also easier to learn, administer and has the best GUI tools included with the product (meaning you don't have to purchase tools separately).

I personally think Oracle leaves a lot to be desired. In my experience, Oracle seems to require many more resources to operate and upgrade than DB2. I would prefer DB2.

1

Related Questions

User Avatar

Is there an ODBC driver available for your Oracle database? If so, the ODBC functions may be the way to go.

User Avatar

Oracle 11i refers to the Oracle ERP Application Suite (often called Oracle E-Business Suite) and really has nothing to do with the database. The latest release (12) will be referred to as 12i. The confusing part is that Oracle used to call its database "i" for "internet" in releases 8 and 9, but now calls the database "g" for "grid". So, to summarize, Oracle 11i refers to the apps and Oracle 11g refers to the database.

User Avatar

oracle is known as keeping word best data base company. It provides database to so many company so that they can operate thier business well.

User Avatar

An OCA DBA fresher salary is in between 1.75 LPA - 2 Lac per annum, in India. Now a days Oracle database administrator are good in demand. SO its better go for oracle certification, for online preparation for oracle database adminsitration certification training, check out training.com.

User Avatar

Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.Excel does have databasing capabilities, but it is not extensive and so unless you were doing simple databases you would not really choose it as the package to design a database. You would go with something like Access or Oracle.

User Avatar

becoz of the company database is very large and can not easy to handle it use of the company use of the oracle ... and suppose any company member ask to you xyz person data information given ...so use of the oracle so can easy to find the person information and get it....

User Avatar

Filemaker is one of the more obscure (and Mac-based) database packages, so you'll have to consult with your vendor.

User Avatar

The process of creating and managing duplicate versions of a database. Replication not only copies a database but also synchronizes a set of replicas so that changes made to one replica are reflected in all the others. The beauty of replication is that it enables many users to work with their own local copy of a database but have the database updated as if they were working on a single, centralized database. For database applications where users are geographically widely distributed, replication is often the most efficient method of database access.

User Avatar

Yes, Excel can be used as a database but not to the same extent as other applications. It is primarily a spreadsheet application, so it does not have all the facilities you might want if you are creating a database. Something like Oracle or MySQL or Microsoft Access are better suited to be used as a database.

User Avatar

This is just speculation on my part, but I suspect it's something like this: Oracle makes their money on licensing the database, and it's to their advantage to have a "pet" OS where they can make any enhancements the database needs directly without having to trust that, say, Microsoft will say "Sure, Oracle, we'll make that change you need in Windows Server 2008 so you can sell your database at the expense of our own SQL Server". Oracle can afford to give away Solaris to help drive Oracle Enterprise Server sales.

User Avatar

Most database vendors offer an API for this purpose. The usage will vary by vendor, but generally you open a connection, query (or runcommand), check or step through results, close connection. In the MS Windows environment, you can also use ODBC (Open Database Connectivity), which is an API that abstracts (no, its not C++ classes) the database, its tables, and its query language. You still have to install a vendor specific ODBC driver, and a vendor specific database client, so you still need to consult the vendor documentation. The procedure is similar to the non ODBC solution - you open the connection, query it, step through the results cursor, and close the connection.

User Avatar

The Oracle database administrator is responsible for supporting the Oracle databases of a company, which means ensuring their top quality performance, security, and availability.The Oracle database is an ORDBMS, or an object relational database management system. It has, since its inception in 1977, become the industry standard in its field. As many companies have already chosen the Oracle software to handle its databasing needs, the administrator position holds a very large and central role within the information technology aspects of many top companies.The average Oracle database administrator makes US $100,000 as a starting salary.The responsibilities of an Oracle database administrator can include -Ensuring the ongoing peak performance and availability of the databases supporting the core system.The responsibility for releasing and implementing changes to the database as they are submitted to the developersWork with an interdepartmental team to ensure that the resources associated with the hardware are properly allocated to databases.Ensuring the optimum performance and availability of said hardware.Final responsibility for maintenance and improvement of databases, including upgrades and rollout.Monitoring the databases to ensure implementation of security measures.Monitoring the databases to ensure minimum downtime.Final responsibility for problem escalation to third parties and to the Oracle Development Team as found appropriate.Providing the service management team with trend analysis so thay they can make informed decisions about the allocation of resources.Oracle provides official certification in its products, which can help tremendously with employment as an Oracle database manager. Many times this is a required attribute for an application. Oracle database administrators are also expected to develop interdepartmental project management skills and be able to communicate with a wide variety of professionals, not just other engineers or information technologists.General experience in SQL systems is often a desired trait, as many times a company running Oracle will have to communicate with a company running a database system that is not Oracle. The database manager will have to know how to make the systems work together.In short, the Oracle database administrator is in high demand because of his or her technical expertise, but anyone wishing to advance their career must really learn how it affects the entire company.

User Avatar

A manual database is a paper based database. A computerized database is one which is held on a computer in an organised manner. A computerized database is more advantageous than manual database in terms of speed, flexibility, and ease.

User Avatar

To be senior we assume you are already at least junior or entry-level oracle - yes? And by "Oracle" we further assume you mean an Oracle database administrator (DBA) versus say a senior Oracle product manager. If you meant a DBA, then may we assume you already are familiar with Oracle publications like "Oracle Database 11g, The Complete Reference" ISBN 978-0-07-159875-0? Have you read the materials published by Oracle online at oracle's web site? If so, then to be considered a "senior" Oracle person, you will want to a) have at least three to five years work experience with Oracle technologies, and b) become accomplished with some of the soft skills, e.g., working with system administrators, working with application developers and customers, documenting your work, working with management. These are skills that separate the senior professional from the beginner. Piece of cake - go get them and prosper!

User Avatar

Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.

User Avatar

They are two different applications. Oracle is a database and Excel is a spreadsheet. So it will depend on what it is you are intending to do that determines which application you would use. Spreadsheets are for numerical analysis and manipulation. Databases are for dealing with lists of data and processing them. There are things both can do.

User Avatar

The database administrator performs a critical role within an organization and is an important and key role in Database Management Systems. The major responsibility of a database administrator is to handle the process of developing the database and maintaining the database of an organization. The database administrator is responsible for defining the internal layout of the database and ensuring the internal layout optimizes system performance.The database administrator has full access over all type of important data of an organization. The database administrator decides what data will be stored in the database and how to organize data in database so that it can be access easily on requirement or need of an organization. To design the database of an organization, the database administrator must have a meeting with users and determine their requirements.

User Avatar

Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.Excel can do some database activities, but it is not a database application, so it only has limited database capabilities. So it depends what you want to do. It could be used for very simple databases, but you are better off to use an established database application.

User Avatar

Most people who select oracle over mysql are doing so for a variety of reasons, not one specific feature. Price is usually the most important factor. MySQL is free, and that's why many people choose to use it. Oracle is time-tested/proven, and that is why many people choose it.However, many corporations purchase volume licenses and so the cost of adding an new database/user to an oracle database is not as much as it would be to start your first implementation.Reasons to use oracle instead of MySQL:1.Oracle has many built in functions such as decode that make some queries easier to build.2. Oracle is a private company, and some people argue this means that they will deliver releases/fix defects/etc more regularly, since they rely on the income to survive.3. Oracle has PL/SQL, a built in language that is very powerful. You can also have java stored procedures, this is much more powerful then what MySQL offers.4. Oracle has support for sequences, MySQL does not.5. Mysql does not support table snapshots6. Oracle can be customized and tuned, much more then MySQL can.7. Oracle provides Hot Backup/Standby facility, Mysql provides this facility only for selected engines.8. Oracle provides Clustering Mechanism, where as MYSql does not.9. Oracle Provides two way replication, Mysql provides only one-way replication.10. Oracle provides DB links to connect to a remote oracle server.

User Avatar

Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.Access is a database. Records are what each set of data is, so they are a key aspect of Access and any database. So that is why the icon is like it is.

User Avatar

Actually coming to this one, we need to discuss about those companies which are invented the java(Sun Micro System) and database(Oracle), in olden days these companies were tie up that time, so that's why we are accessing the database with application program written in java. now coming to our topic, We need to select the suitable drivers to our application(Desktop or Web Application) load the drivers through application. Those drivers are JDBC drivers, JDBC is nothing but pool of drivers in which some drivers are default in Windows OS, when ever we create the DATABASE Application like ORACLE, then automatically drivers are also included in JDBC.

User Avatar

Microsoft SQL Server 2008R2 received the most license purchases for 2011 - though other competitors are Oracle Database, DB2, Teradata, Informatica. MySQL is the most popular open source (free) database platform, though it is specifically geared for website back-ends. However Microsoft SQL Server Express is also free, and includes advanced services such as SQL Analysis Services, SQL Reporting Services. http://www.microsoft.com/download/en/details.aspx?id=25174 From a business intelligence standpoint, Microsoft SQL Server BI Suite leads in the ability to execute, while SAP edges Microsoft in market saturation. http://blog.saasinct.com/wp-content/uploads/2011/02/GartnerBI20111.png As a side note, while Microsoft Access may not be as powerful as SQL Server, it is in fact the most installed database platform by far, though the contention that it is actually a full database platform is arguable, it can hold millions of rows, capping out (.accdb file) at 2 gigabytes. Do not use Oracle Database, it is ridiculously overpriced, and none of what you buy comes bundled, so you if you want to tune your database, the tuning pack costs $5,000 per processor. And even for an average IT person, Oracle will take you four times as long to install, because it's poorly packaged.

User Avatar

All business applications are SCREENS + BUSINESS LOGIC + DATABASES Microsoft SQL Server 2008R2 received the most license purchases for 2011 - though other competitors are Oracle Database, DB2, Teradata, Informatica. MySQL is the most popular open source (free) database platform, though it is specifically geared for website back-ends. However Microsoft SQL Server Express is also free, and includes advanced services such as SQL Analysis Services, SQL Reporting Services. From a business intelligence standpoint, Microsoft SQL Server BI Suite leads in the ability to execute, while SAP edges Microsoft in market saturation. As a side note, while Microsoft Access may not be as powerful as SQL Server, it is in fact the most installed database platform by far, though the contention that it is actually a full database platform is arguable, it can hold millions of rows, capping out (.accdb file) at 2 gigabytes. See the related links. Do not use Oracle Database, it is ridiculously overpriced, and none of what you buy comes bundled, so you if you want to tune your database, the tuning pack costs $5,000 per processor. And even for an average IT person, Oracle will take you four times as long to install, because it's poorly packaged.

User Avatar

In Oracle 10g, 'g' stands for grid computing. For more details about Oracle 10g and overall Oracle DB please refer the following link:http://en.wikipedia.org/wiki/Oracle_Database

User Avatar

You are qualified for any types of jobs related to computer science and possibly software jobs. Most of their jobs have to do with working on their database system so that is another you would be qualified for.


Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.