Microsoft SQL Server, NoSQL, and the in-memory database wars are the highlights among this year's headlines.
Fuggedabout Hadoop. Databases are still the backbone of transactional and analytical applications, and they stoked big reader interest in 2013. But times are changing, with a new breed NoSQL database and, ironically, the desire for SQL querying on top of Hadoop being big themes this year.
Measuring by the yardstick of page views -- which is admittedly skewed toward juicy headlines and Internet search-engine-ranking algorithms -- here's my personal selection of top database headlines in 2013:
1. Microsoft SQL Server 2014: Final Countdown The top-selling database by volume (Oracle tops revenue) has a lot of fans. This story looks under the hood of the second community technology preview (beta) release to describe the in-memory capabilities and other new features expected with the next release in the first half of 2014.
3. MetLife Uses NoSQL For Customer Service Breakthrough Were you thinking NoSQL databases would be just a passing fad among Internet giants? It turned lots of heads when this mainstream insurance company tapped MongoDB to solve the age-old 360-degree customer view problem. This story makes the case for freedom from the confines of rigid relational data models.
4. Oracle's Ellison Tries To Outmaneuver SAP Hana If you can't beat 'em, join 'em. Larry Ellison takes the wind out of SAP's Hana sails (and, he hopes, sales) with the announcement that Oracle Database, too, will support in-memory processing. But he didn't say when this new Oracle 12c In-Memory Option would arrive.
6. Inside IBM's Big Data, Hadoop Moves Forget the headline. IBM's biggest news of this day was the release of BLU Acceleration for DB2, which employs a slew of compression, query acceleration, and in-memory analysis techniques previously seen here and there, but never before combined to this degree of success.
8. Oracle OpenWorld: 5 Rants and Raves Rant #1: Larry Ellison pre-announcing the Oracle 12c In-Memory Option with no release data or roadmap. He's still talking as if it exists, but in late December he revealed it would be beta in the second half of 2014 and shipping late in the year. But then, how many years did he say Oracle Fusion was coming?
10. Teradata Joins SQL-On-Hadoop Bandwagon Partnering with Hortonworks, data-warehousing leader Teradata finds a way to query the world's largest data warehouse and the world's largest Hadoop clusters.
The past is prologue, so expect more headlines on Microsoft SQL Server 2014, NoSQL, and in-memory and cloud database options in 2014. Happy New Year!
Doug Henschen is executive editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor-in-chief of Intelligent Enterprise, editor-in-chief of Transform Magazine, and executive editor at DM News.
There's no single migration path to the next generation of enterprise communications and collaboration systems and services, and Enterprise Connect delivers what you need to evaluate all the options. Register today and learn about the full range of platforms, services, and applications that comprise modern communications and collaboration systems. Register with code MPIWK and save $200 on the entire event and Tuesday-Thursday conference passes or for a Free Expo pass. It happens in Orlando, Fla., March 17-19.
The Agile ArchiveWhen it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
2014 Analytics, BI, and Information Management SurveyITís tried for years to simplify data analytics and business intelligence efforts. Have visual analysis tools and Hadoop and NoSQL databases helped? Respondents to our 2014 InformationWeek Analytics, Business Intelligence, and Information Management Survey have a mixed outlook.
InformationWeek Tech Digest, Nov. 10, 2014Just 30% of respondents to our new survey say their companies are very or extremely effective at identifying critical data and analyzing it to make decisions, down from 42% in 2013. What gives?