DatabasesShared data systems try hardly to satisfy data consistency, system availability and tolerance to network partitions.
In a distributed system it is impossible to simultaneously provide all these guarantees at any given moment in time.
The purpose of the talk is to show the mechanism used by data storage systems such as Dynamo and BigTable in order to satisfy two guarantees at a time.
DatabasesMost software centers around some type of database or at least data structures. As software developers we need to understand the principles of Database Normalization. For the most part the first three normal forms are common sense. We’ll discuss the normal forms and use the classic example of an invoice to demonstrate how to apply the principles.
DatabasesSi la facilité de développement est assurée avec Django, il n'en est pas de même pour la scabilité. L'utilisation abusive de certains modules comme Paginator peuvent vite se transformer en gouffre à IO. Il sera fait une démonstration de l'utilisation de fonctions comme bulk_create ou cursor.copy_from, vous ne ferez plus jamais un .save() dans une boucle sans y réfléchir.
DatabasesNoSQL document databases are increasingly being used in a large number of use-cases for web and mobile apps. This session provides a brief overview of Couchbase Server, a document database, its underlying architecture, and drill down into three specific customer use cases : Paypal – A multi data center session store, LivePerson - A scalable, real time analytics system, and Orbitz – A highly available cache solution.
DatabasesEvery time you choose how to store data in your database, a lot of things happen under the hood.
Making the best choice is even more important in those applications that aim to high performance.
The purpose of the talk is to show how indexes work and how slightly changing their combinations can impact on the performance of your application.
DatabasesNoSQL and Big Data are conflated – many view them as synonyms. But the problems these technologies address are quite different. While hadoop "the Big Data poster child", is focused on data analysis, NoSQL tech focuses on delivering operational data management for modern web and mobile apps; the Big User problem. In this presentation, we will explore why every NoSQL deployment should be paired with Hadoop by exploring some real-life use-cases.
DatabasesTraditional relational databases have a rigid schema, and most NoSQL databases are completely schemaless. But reality often demands something in between, and this is why PostgreSQL 9.4 ships with new and enhanced JSON support that allows the best of both worlds.
In this talk we'll look at the new "jsonb" datatype, it's flexible and performant indexes, and how to use those to get a "dynamic schema" architecture.
DatabasesHow can you track all changes to your data across time? This talk will introduce you to the techniques you need to do that. We’ll examine the theory behind temporal database tables as well as the changes in the SQL:2011 standard that support them. We’ll also look at how you can implement temporal tables, both for DBMS that support SQL:2011 and those that don't. By the end of this talk you should be able to take your data to the fourth dimension.
DatabasesMySQL 5.7 will be the first release of MySQL to enable the strict SQL mode by default for all installations. This change means that instead of truncating input and returning a warning to the application, MySQL will now refuse input and return an error. This change is one of a series of related changes to make MySQL safe by default.
This talk will describe what breaks, and how you can be best prepare for the upgrade.
DatabasesIn this session I will describe tools and best practices for using MySQL as part of your continuous integration or continuous delivery environment.
Topics covered will include using MySQL Sandbox to bootstrap new MySQL installations, optional configuration for MySQL that is faster (but not safe for production), and extracting test-run metrics from MySQL.
To provide the best experiences, the usage of cookies are necessary. Some are essential for the proper functioning of the site, while others help us better cater to your interests.