Beyond Relational Databases

CowboyRobot writes "Relational databases were developed in the 1970s as a way of improving the efficiency of complex systems. But modern warehousing of data results in terabytes of information that needs to be organized, and the growing prevalence of mobile devices points to the increasing need for intelligent caching on the local hardware. According to the ACM, the future of database architecture must include more modularity and configuration. Although no concrete solutions are included, the article is a good overview of the problems with modern data systems."

Comments

Less is more

[WiFireWire]

'nuff said. thekeyboardgoblinsstolemyspacebar

Multi-Terabyte Data Warehouse and MySQL

[MexicanMenace]

That's nice. It won't handle a multi-terabyte database, though. That's the domain of Terabase, Oracle, and (blech) DB2. It's also what the article is about.

http://www.mysqluc.com/cs/mysqluc2005/view/e_sess/ 6218

Sabre is using MySQL to analyze data that was not feasible to analyze before by replacing tape drives with online accessible information that is affordable. This talk outlines the project--data warehousing with large multi-gigabyte tables containing billions of rows of information--and gives details into the architecture, design, and rollout. Benzinger provides information on design decisions, lessons learned, performance tuning measures, and results obtained. Download presentation file

Slide 6 shows their MySQL database to be 26TB in size with 600,000 I/O per second.

Just so you know.

Re:KISS

[vsync64]

Your nickname is accurate, for sure...