Selvidiya Testing: Database

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="hentry-meta" style="background-color: white; border-bottom-color: rgb(255, 88, 0); border-bottom-style: solid; border-width: 0px 0px 1px; font-family: Helvetica, Arial, sans-serif; font-size: 10px; margin: 0px 0px 5px; outline: 0px; padding: 0px 0px 15px; vertical-align: baseline;"><h1 style="background-color: transparent; border: 0px; color: #323232; font-size: 30px; line-height: 33px; margin: 0px; outline: 0px; padding: 0px 0px 10px; vertical-align: baseline;"><span class="Apple-style-span" style="font-size: small;"><span class="Apple-style-span" style="font-size: 12px; font-weight: normal; line-height: normal;"><span class="Apple-style-span"><span class="Apple-style-span" style="font-size: 30px; line-height: 33px;"><b><br /></b></span></span></span></span></h1></div><div class="hentry-container clear" style="background-color: white; border: 0px; font-family: Helvetica, Arial, sans-serif; font-size: 10px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div class="hentry-middle" style="background-color: transparent; border: 0px; float: none; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; width: 620px;"><div class="hentry-content clear" style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: #323232; font-size: 14px; line-height: 1.5; margin: 0px; outline: 0px; overflow: hidden; padding: 15px 0px 0px; vertical-align: baseline; width: 610px;"><div class="introduction" style="background-color: transparent; border-bottom-color: rgb(255, 88, 0); border-bottom-style: double; border-width: 0px 0px 3px; font-family: Georgia; font-size: medium; font-style: italic; margin-bottom: 15px; outline: 0px; padding: 10px; vertical-align: baseline;"><a href="http://www.linuxforu.com/wp-content/uploads/2013/12/database.jpg" style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; color: #007ac9; font-size: 16px; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><img alt="database" class="alignleft size-full wp-image-13169" height="375" src="http://www.linuxforu.com/wp-content/uploads/2013/12/database.jpg" style="background-color: transparent; border: 1px double rgb(239, 239, 239); display: inline; float: left; height: auto; margin: 4px 15px 4px 0px; max-width: 610px; outline: 0px; padding: 0px; vertical-align: baseline;" width="590" /></a>Choosing a database is a long term decision and altering that decision later can be a difficult and expensive proposition. So, IT managers need to get it right the first time around.</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">Choosing a database is a long term decision and changing that decision later can be a difficult and expensive proposition. So, IT managers cannot afford to go wrong in the first instance. MySQL and PostgreSQL are the two popular alternatives in the world of open source databases, and are the most popular amongst admins preparing a new rollout.</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">According to Rohit Rai, sales director, India, South East Asia and Australia at EnterpriseDB, “The database market today is very mature and it is a mature technology too. We are talking about a 25 year-old database market. There are many databases that have come and gone, and now there are a few commercial choices that are left in the world. If you look at the database as a technology, apart from being pretty mature, it is standards compliant and well-documented. Open source databases also started out a long time back. If you look at the history of PostgreSQL, it’s over 15 years old and has a healthy community around it.”</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Things to consider while selecting an open source database</strong><br />With a number of database options available in the market, the job of IT managers actually becomes difficult while trying to choose one of them. So, how should admins go about it? The best point to start from is evaluating your requirements. A database needs to be selected based on the underlying data and the usage of that data. Some of the pointers are given below:</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;"><br /></div><ul style="background-color: transparent; border: 0px; list-style: square; margin: 0px 0px 15px 16px; outline: 0px; padding: 0px; vertical-align: baseline;"><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What type of data is it? [Words (English/multilingual), numbers, books, images, movies, maps, etc]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What is the volume of data that the database needs to contain? [Megabytes, terabytes or petabytes]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">How fast is the data generated? [Bytes/sec, MBps or GBps]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">How many people access it concurrently?  [In the 10s, 100s, 1000s or millions]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What is the read vs write volume? [Will only the same person who is writing read it, will one person write and millions read it, or will there be millions of writes but very few reads, i.e., log records?]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Does the data need to be distributed? [Single computer or across countries]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">How much computation is involved in extracting information from the data? [Nothing - data is extracted as-is; some simple computation; complex joins of data or huge analytics computations]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What expertise level do you expect your engineers to have? [Will they be able to manipulate data themselves or will you need expert database admins?]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">In what language does the data need to be accessed? [C, C++ to Ruby, Python or Golang]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">How valuable is the data? [Useless once the connection is lost, i.e., mobile phone locations or Web transactions; extremely important like bank accountsl; or critical, wherein lives may be lost if the data is lost, such as while monitoring rocket stability, satellite orbits, ICU device data, etc]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What kind of data safety measures do you require? [Ranging from taking back-up once in a while to complex multi-country and fire safe disaster recovery mechanisms]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What level of security do you need for the data? [Is it common knowledge or top secret data?]</li><li style="background-color: transparent; border: 0px; margin: 3px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">What kind of integration/ecosystem support does your product need? [A product uses a lot of technologies besides the database. The database you use needs to integrate and work well with these other technologies. An ecosystem ensures that these integrations work as new versions of the products continue to roll out.]</li></ul><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">An IT manager needs to look at some or more such questions to find the right database to use.  For a database that needs to be used on the Web usability, scalability, security and read distribution matters greatly.</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">Apart from these, one should have a futuristic approach while choosing a database. It is one of the most important criteria that an IT manager should keep in mind. Typically, IT managers should factor in the current requirements including scalability, security, robustness and ease of use, and should also consider what may emerge in the future as the organisation grows, and look for a database that is flexible enough to meet the upcoming challenges.</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Acceptance of open source databases</strong><br />Acceptance of open source is increasing in all fields and this is also true for open source databases. Government legislation is also pushing the usage of open source technologies. Rai of EnterpriseDB asserts, “Because of the fact that database technologies have existed for a long time, they seem to offer a lot of functionalities. Open source databases are as good as any other commercial alternative. What may prevent their adoption is lack of awareness. IT managers may not have the confidence to say that open source databases can actually fulfil their needs completely.”</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">But things are changing gradually; economic conditions are pushing IT managers to find alternatives to the traditional commercial licensing models and go for options where they have to pay only for support. This is why open source databases are being viewed as even more attractive.</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">Comfort also comes from having references from other organisations that have successfully deployed open source databases. For MySQL, there are many such successful implementations in India and all over the world. What additionally inspires confidence is the amount of help you can get for your implementation. This includes both the help from the open source forums as well as professional help.</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Managing open source databases is easy</strong></div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">Once you are able to choose the right database for your business, the next challenge is to manage it.  Rai says, “If IT managers want to bet on open source databases, there is no risk to it. All they need to do is to manage them. Even if you have not used an open source database before, you can transfer your skills quickly. Open source databases like PostgreSQL are not a challenge, so one can use them effectively from Day 1 itself. It’s just a change of mindset that has to happen. Many companies and government organisations have already started doing that.”</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Latest trends in the world of database</strong><br />The latest trends are towards Big Data, the cloud, NoSQL, high availability, adapting to the multi-core microprocessor architectures and solid state devices (SSDs).</div><div style="background-color: transparent; border: 0px; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;"><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Let’s look at each of these in detail.</strong><br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Big Data</strong>: A lot of data is being automatically generated by devices, i.e., data about traffic, climate, user activity on the Web, etc. This data is huge and increasing by the second. As individual nuggets of information, the data has not much value, but once aggregated, it is a goldmine. Climate patterns, traffic flow patterns and social connectivity patterns can be mined. Big Data needs special handling for collection and processing.<br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">The cloud:</strong> More and more businesses want to avoid investing in their own infrastructure. They want to use a publicly available service that can be expanded and reduced based on the fluctuating demands.<br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">NoSQL:</strong> Applications providers want to have more flexibility with the underlying structures that contain their data. Users are demanding a database for which they do not have to initially create a fixed structure. As the application matures, application developers want to have the flexibility to change the structure of the underlying database. NoSQL is a trend which allows this flexibility.<br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">High availability:</strong> Data is growing and the world is shrinking. The data therefore is getting more and more distributed. The data generators and data consumers are spread across a wide geography. This now requires databases to manage the distribution of the data. The data should also be resilient to underlying failures of hardware and software.<br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Multi-core processors:</strong> Processor technology is moving to multiple cores. Where erstwhile processors concentrated on the speed, contemporary microprocessors have multiple cores which can process data in parallel. Newer software architectures need to exploit the ability of computing in parallel.<br /><strong style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Solid state devices:</strong> The era of hard disks seems to be passing. All kinds of rotating disks like CDs and DVDs have given way to pen drives and SD cards. These solid state memory devices have vastly different speeds for reading and writing, compared to the rotating hard disks. The optimisations required for a solid state device differ greatly from a hard disk.</div></div></div></div></div>

Here’s How You Can Choose the Right Database For Your Business!

Choosing a database is a long term decision and altering that decision later can be a difficult and expensive proposition. So, IT managers n...