first_imgTags:#databases To listen to the media, you would think that the end of the relational database is about to strike at any moment, leaving behind a shattered mess of tables and queries strewn about in proprietary servers, collecting silicon dust.Truth be told, the future for relational databases has really never been better — though it’s a future that’s changing rapidly, altered by the ascendency of big data and non-relational databases.In an earlier article this week, we reviewed how and when a business should consider using non-relational (NoSQL) databases. While not comprehensive, the uses for NoSQL databases center around the acquisition of fast-growing data or data that does not easily fit within uniform structures.(See also: When NoSQL Databases Are — Yes — Good For You And Your Company)In describing the use cases for relational databases, it would be easy to say at this point that such databases — Oracle, SQL Server, PostgreSQL or MySQL — pretty much take care of every thing else. In the broadest sense that may be true, but that’s an overly simplistic view.Stability Is KeyFirst, the easy answer: relational databases are very well-suited  for data sets that aren’t likely to suddenly expand. Even the most successful company, for instance, is not going to see its HR database (or an asset management database) grow faster than it can handle the new entries. One could argue, of course, that a merger with another organization that’s at or larger than your organization could result in a rapidly expanding database. But such merger and acquisitions are rare in the course of normal business, and they are usually seen coming months in advance — which, of course, gives plenty of time to merge relational data sets.Data in such collections is also structured, meaning that once a schema for the data is defined, (length of fields, type of data for fields, etc), data doesn’t depart from that schema. Unstructured data can include weblog information, which can be highly varied in organization, depending on what’s being monitored.The term I usually use to describe these data set to my students is “non-exploding” data, which is colorful, but fairly apt. Data will grow and change, but not beyond the normal capability for the relational database software to keep up.Legacy MattersRelational databases have been around for over four decades, and that means something in the IT world.Over those years, a lot of applications have been written to manage and manipulate data that’s been held in SQL databases — some good, some bad. But if you’re considering ripping and replacing apps or data architecture, it’s important to remember that you don’t have to fix what ain’t broke.Yes, apps can be improved, and data schemes enhanced. Better, faster databases can be installed, too. But it may not be necessary to haul your data over to a non-relational database just because it’s new and shiny. If your workflow uses structured data, is the cost of moving to non-relational systems really worth it?Hand-In-HandMy favorite use case for relational databases revolves around big data.Yeah, you read that right: big data.Confused? Hang on a sec. See, while it is true that rapidly changing data sets do better being stored in NoSQL databases or distributed unstructured data warehouses like Hadoop, there is still a very strong and growing need for relational databases to tap into subsets of that data to perform data analysis in a timely manner.Time after time you can read about yet-another data vendor that’s built in hooks to the rock-star popular Hadoop, for this very reason. Hadoop is great for what it does: storing data across distributed commodity servers. But for real-time analysis? Meh. Better, then, to use a known relational database tool to create familiar queries to grab some of that data and crunch it that way you need to. This is a use case that’s growing very quickly these days, and which should keep relational database vendors in Dutch for the foreseeable future.Image courtesy of Shutterstock. brian proffitt 3 Areas of Your Business that Need Tech Now Related Posts center_img Massive Non-Desk Workforce is an Opportunity fo… IT + Project Management: A Love Affair Cognitive Automation is the Immediate Future of…last_img read more

first_imgGoa Congress president Girish Chodankar on Friday slammed the BJP-led coalition government for failing to protect Sidharth Kuncalienkar, the BJP’s candidate for Panaji bypoll. It also demanded that at least 100 police personnel should throw a permanent security cordon around Mr. Kuncalienkar.Mr. Chodankar was responding to a complaint by Mr. Kuncalienkar who on Thursday accused the Opposition of acting out of frustration, after two unknown persons on Thursday night flung a bottle at Mr. Kuncalienkar’s car while he was returning home.Mr. Chodankar also questioned the law and order situation in the city saying that the BJP-led coalition government had failed to provide security for its own candidate. “The Congress is not in power. If your candidate is not safe, then how can you safeguard people?,” asked Mr. Chodankar at a press conference here.“First of all, it is a shame for the government and the Chief Minister. Government is run by the Chief Minister and Home Ministry is also under him,” Mr. Chodankar said, emphasising that the police needs to arrest the culprit as soon as possible. A police complaint was registered at the Panaji town police station on Friday after the incident. Mr. Kuncalienkar was travelling along with a friend on Thursday night in Panaji’s Mala ward when unknown persons riding a two-wheeler flung a bottle at his car’s wind shield. Mr. Kuncalienkar said further in his complaint that the incident happened while passing through his constituency, after a public meeting addressed by Union Minister for Road Transport and Highways Nitin Gadkari was over on Thursday evening.“My opponents must have been rattled after the success of the meeting, which is why they resorted to this act in desperation,” Mr. Kuncalienkar said while speaking to the media persons. Mr. Kuncalienkar is facing Atanasio Monserrate of the Congress, Valmiki Naik of the Aam Aadmi Party and Subhash Velingkar of the Goa Suraksha Manch, among others in the May 19 bypoll for Panaji, which is taking place following the demise of Chief Minister Manohar Parrikar on March 17.last_img read more

first_imgThe long-term water supply projects in Rajasthan will be completed on time to ensure the availability of water in the geographically difficult areas. Chief Minister Ashok Gehlot has given instructions for speeding up implementation of water supply schemes for both drinking and irrigation.Mr. Gehlot said at a review meeting here after the appointment of committees for the Rajiv Gandhi Jal Sanchay Yojana that the long-term projects would permanently resolve the issue of paucity of water caused by scanty and erratic rainfall in the State. “The projects should be formulated to meet the local needs and regularly monitored,” he said.The progress of projects financed by institutions such as the National Bank for Agriculture and Rural Development, Japan International Cooperation Agency and New Development Bank as well as the dam, canal and small irrigation projects was reviewed on the occasion.The committees appointed at the district, block and village panchayat levels for the Yojana will coordinate the activities of various departments and monitor the progress of work for water conservation.last_img read more