answersLogoWhite

0

There are many databases (Database server) solutions available for the Windows Operating system. The choice made is depending about many factors; such as: Scalability requirements Intellectual capital within the firm (Which produce the IT people know how to work with). Existing system platforms being used Capital available for building and maintaining a solution Some examples of database solutions would be: (Commercial Solutions) Microsoft SQL Server Oracle Microsoft Access (Open Source Solutions) MySQL Postgress SQL More about the solutions available: Microsoft SQL This is the most popular solutions. MS SQL is idea in most all situations however Oracle has a scale advantage in VERY heavy transaction environments where millions of records will be inserted on an ongoing basis. MS SQL server has a free desktop version as well as various licensed models to fit a wide spectrum of installation needs; which includes clustering, etc. Oracle Oracle is known to be a very expensive solution and is typically installed in very large installations. Additionally Oracle is often selected in a MIXED OS environment. As an example a firm may have some Unix Oracle installations and Windows OS installations. (The free alternatives) MySQL MySQL as come a long way however it is still not truly a database engine on the backside. MySQL is more a flat data stored with an interface program (not a server based product) that allows for the accessing of the data through SQL program code. Some will argue that MySQL is very good while most SQL programmers would strongly advice against it. This is not a debate that we will enter into here. MySQL has been around for a long time and independent programmers and small software companies have implemented it successfully. MySQL is closest to MSSQL in its SQL language deployment. This being said it is a viable option for a SQL deployment however popular opinion might suggest other routes. PostGress SQL is often related to Oracle in its SQL language deployment (more like Oracle than MSSQL). While I do not have hands on experience with Oracle OR PostGress my understanding from highly trusted resources is that PostGress is a very strong open source option. Postgress is stable, adheres to ANSI SQL standards and is a true database engine. Given my limited knowledge on Postgress and Oracle overall I would say that Postgress is a strong alternative however research should be done to insure that this is the right option for you. Postgress SQL is another free

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What is registry file?

A registry file, or most would called it "Windows Registry" is a database that stores hardware, software settings and options of Microsoft Windows Operating System.


Is Windows 7 software?

Yes. Windows 7 is an operating system, a type of software.


What software serves as the interface between the user the application software?

Operating System software. Like Windows or OSX.


Is windows 7 hardware or software?

Software. An operating system, specifically.


What software is windows use to run?

operating


What is the operating system in the software programs?

Windows


What kind of software is Windows Vista?

Windows Vista is an operating system.


What kind of software is Windows XP?

Windows XP is an operating system.


The most common operating system and the most common application software used?

The two most commonly used operating systems are Windows XP and Windows Vista. If you consider all versions of Windows to be the same product, then the most know about operating systems are windows and mac OS X but Linux is used more than mac.So the two most used operating systems are windows and mac. Microsoft even said that Linux is more of a threat than mac.


Can you instoll Mac Programs on Windows?

Software is written to work with a particular operating system. Windows software requires the Windows operating system and Mac software requires Apple's Mac OS X. The two are not interchangeable. A Mac can run the Windows operating system and thus Windows software but Mac OS X can only be used on Apple's own computers.


What software is Windows 7 used to run?

Everything included(software) to run Windows 7 is in the DVD. Read up on "Operating systems" or Microsoft's "Windows Virtual PC".


What sort of software is windows?

Windows is a family of operating systems. Linux is a kernel upon which operating systems are built.