nosql? how about "nodbms"?

48
NoSQL? How About NoDBMS? NoSQL and the Spreadsheet, Separated at Birth?

Upload: dataversity

Post on 27-May-2015

342 views

Category:

Technology


0 download

DESCRIPTION

"NoSQL" encompasses many ideas, including the type and size of the targeted data, its physical storage on disk, its logical organization, how queries are expressed, and how the database software is managed. It is a way of doing databases that is different from that of the traditional RDBMS, and it makes a lot of sense, given the limitations of traditional technologies and emerging needs in our changing world. But what if databases were unnecessary altogether? In this session we will explore idea of taking "no SQL" to it's logical conclusion.

TRANSCRIPT

  • 1. NoSQL? How About NoDBMS?NoSQL and the Spreadsheet,Separated at Birth?

2. What is NoSQL? 3. Size of Data 4. Size of Data Physical Format 5. Size of Data Physical Format Logical Format 6. Size of Data Physical Format Logical Format 7. Size of Data Physical Format Logical Format 8. Size of Data Physical Format Logical Format Type of Data: Structured, Semi-structured, or Unstructured 9. Size of Data Physical Format Logical Format Type of Data: Structured, Semi-structured, or UnstructuredWhoSubmitsQueriesand How? 10. Size of Data Physical Format Logical Format Type of Data: Structured, Semi-structured, or UnstructuredWhoWhoSubmitsOwns theQueriesSoftware?and How? 11. Size of Data Physical Format Logical Format Type of Data: Structured, Semi-structured, or UnstructuredWhoWhoSubmitsOwns theQueriesSoftware?and How? 12. Size of Data Physical Format Logical Format Type of Data: Structured, Semi-structured, or UnstructuredWhoWhoSubmitsOwns theQueriesSoftware?and How? 13. Size of Data Physical Format Logical Format Type of Data: Structured, Semi-structured, or UnstructuredWhoWhoSubmitsOwns theQueriesSoftware?and How? 14. Size of Data Physical Format Logical Format Type of Data: Structured, Semi-structured, or UnstructuredWhoWhoSubmitsOwns theQueriesSoftware?and How? 15. Big Data?+ ? +?Data WarehouseMicrosoft Access Spreadsheet 16. UsabilitySolutionComplexityand CostData Size 17. DATA 18. Database 19. Database 20. DATA 21. SQL 22. Visual 23. VisualInteractive 24. VisualInteractiveUnguided 25. Why cant spreadsheetshandle a trillion rows? 26. Solution: The Cloud 27. Solution: The Cloud Again 28. Solution: BetterTechnology in the Cloud 29. The Trillion-Row SpreadsheetUser can see, combine, manipulateand analyze all available datathrough a web browser without alocal copy of any of the data.All source data recordsremain in a single cloud-based repository ofunlimited size. 30. Trillion-Row Spreadsheet Benefits Faster than the fastest database Easier to use than a desktop spreadsheet More powerful analytics than either On-demand data integration No hardware or software to buy 31. Trillion-Row Spreadsheet Reality Table size is virtually unlimited 425,000,000,000 (0.4T) row table the largest so far Fast and easy source data loading 75B records/hour (~20M/sec), no need for ETL Safe, reliable data asset management Six Nines data center, fault-tolerant clustering 32. Browser-Based Big Data Analytics 33. Direct Analysis of Whole Data No summaries, aggregation, or sampling Real-time scrolling, search and selection Full source data displayed in browser UI Incremental operations with full undo 34. On-Demand Data Integration Join tables on the fly No schemas, indexes, or keys No need for table and query optimization 35. Unmatched Analyst Productivity Hundreds of built-in analytical functions Multi-language API ODBC connection for legacy SQL Fully integrated with Microsoft Excel Parameterized, reusable, sharable queries Powerful, simple macro language