| In today's market, there are a lot of database options and solutions out there. Whether you're looking for a small, desktop-based dbase or an enterprise-level cloud solution hosted online, there are literally thousands of options. The four major database types are: Cloud DBaaS, Desktop, Server, and Web-enabled. Most solutions can access or publish to the Web, but not all are really Web-based or real-time online. For the most part, desktop solutions are a personal or very small business (less than 10 employees) option. In those situations where not many people need access to the data or the data needs to be securely kept away from public networks (such as with financial information), then a desktop solution is often the way to go. Assuming remote access is not required. Web-enabled databases are almost always server-based, but Server databases are not always Web-enabled. Which is why these two are kept separate. Server-based solutions can be totally in-house on closed intranets that are not accessible from the outside world. Or they may be limited in their accessibility via the Web - say to allow users to retrieve some data or get a synopsis like a published info-graphic, but not actually have full access to view or manipulate the data itself unless they are connected via the secured in-house network. Web-enabled databases, on the other hand, are generally fully accessible via the World Wide Web. Cloud DBaaS is a Web-enabled or Server-based solution, but is sold as a service (DataBase as a Service) that is not owned or controlled by the company using the database. This is a popular new outsourcing option that allows enterprises to minimize their expenditures on DBA requirements while still gaining access to high-end technology for their data needs. Along with these four types of database, there are a myriad of storage options, DB languages to be supported (such as SQL and its multitude of renderings), data integrity solutions, and commercial or open source delivery. On top of all of this comes server options as well, though these are nearly always based on the other options rather than being a stand-alone option themselves. For most looking for a database management solution (DBMS), the sheer number of options can appear staggering. Luckily, the type of data you have and the way you wish to be able to access and manipulate it will greatly narrow the field of candidates. Unfortunately, that doesn't necessarily mean that your decision will be cut-and-dried. Further, having a lot of options available to you in your new database may or may not be conducive to a useful, low-cost solution. The three points you'll need to put on the table to completely narrow the field, no matter the type of database you're considering, are these: 1. How much data do you have now and how much do you project to have next year, three years from now, and five years down the road? 2. What type of security do you need and do you expect that this will change with time? Security includes backups, so plan for how this will be facilitated as well. 3. Do you have a specific platform requirement, such as the ability to collaborate with multiple operating systems, human or computer languages, etc.? Answering those three questions will tell your DBA the best options for your real needs. Leaving any of those questions unanswered or ambiguous will mean you'll likely spend too much or get a solution that is not quite a good fit and that will require a lot of tweaking and expensive upgrading over time. |
| Author Resource:- [About] The DBA Shoppe specializes in remote DBA servicesfor clients with Oracle, DB2 and SQL Server databases. Providing certified Database Administrators for your day to day requirements, the DBA Shoppe saves you time and money. How healthy are your databases? Discover today at http://www.TheDBAShoppe.com |
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment