Storing Data Thierry Sans Modern Web Platform Client Side Server - PowerPoint PPT Presentation

Mar 03, 2024 •372 likes •475 views

Storing Data Thierry Sans Modern Web Platform Client Side Server Side Web API Database Why using a database Persistency Concurrency (avoid race conditions) Query Scalability SQL vs NoSQL databases Relational database (SQL

Storing Data Thierry Sans
Modern Web Platform Client Side Server Side Web API Database
Why using a database • Persistency • Concurrency (avoid race conditions) • Query • Scalability
SQL vs NoSQL databases
Relational database (SQL database) Data structure tables and tuples Query language SQL Inconvenient not-optimized for big data analysis Advantage complex queries PostgreSQL, MySQL, MariaDB, Technology SQLite, MSSQL
NoSQL database Data structure key/value pairs Query language API style Inconvenient not adequate for complex queries Advantage optimized for big data analysis Technology MongoDB, Redis, CouchDB, NeDB
ORM - Object Relational Mapping ➡ Mapping between (OOP) objects and the database structure Examples • Sequelize for PostgreSQL, MySQL, MariaDB, SQLite • Mongoose for MongoDB
Connecting the REST API with a database
Do/Don't • Do retrieve selected elements only rather than retrieving an entire collection and filtering afterwards • Do defi ne primary keys rather than relying on auto-generated ones • Do split data into different collections rather than storing list attributes • Do create join collections whenever appropriate (only for NoSQL database without performant join feature)
Retrieving collections with paginated results ➡ Only retrieve what you need from a potentially large collection Examples GET /messages[?page=0] GET /messages?page=1 GET /messages[?max=100] GET /messages?max=20

Download Presentation

Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

11. Persistence The use of files, streams and serialization for storing object model data

11. Persistence The use of files, streams and serialization for storing object model data Storing Application Data Without some way of storing data off-line computers would be virtually unusable imagine a Word Processor which forced you

288 views • 16 slides

CS371m - Mobile Computing Persistence Storing Data Multiple options for storing data

CS371m - Mobile Computing Persistence Storing Data Multiple options for storing data associated with apps Shared Preferences Internal Storage device memory External Storage SQLite Database Network Connection 2 Saving

1.23k views • 55 slides

Storing Data Review Data collection is an important issue Dirty data Multiple

Storing Data Review Data collection is an important issue Dirty data Multiple sources Data collection Data consolidation Data cleaning Data integration CMPT 354: Database I -- Storing Data 2 What Is the Next

272 views • 23 slides

Week 12 - Monday What did we talk about last time? Generics Storing data is a

Week 12 - Monday What did we talk about last time? Generics Storing data is a fundamental part of programming The Java Collections Framework (JCF) provides a rich set of libraries for storing data in different ways It is the

537 views • 20 slides

Storing and Retrieving Data Database Management Systems need to: Store large volumes of

Storing and Retrieving Data Database Management Systems need to: Store large volumes of data Storing Data: Disks and Files Store data reliably (so that data is not lost!) Retrieve data efficiently Alternatives for storage

176 views • 6 slides

Storing Data: Disks and Database Management Systems need to: Files Store large volumes of

Storing and Retrieving Data Storing Data: Disks and Database Management Systems need to: Files Store large volumes of data Store data reliably (so that data is not lost!) Retrieve data efficiently Alternatives for storage

584 views • 7 slides

Data Structures and What is a data structure? Algorithms Way of storing data in computer

Introduction: Data Structures Data Structures and What is a data structure? Algorithms Way of storing data in computer so can be used efficiently Set of operations that access the data in prescribed ways Prof. Nadeem Abdul Hamid

683 views • 10 slides

Storing Data: Disks and Files Database Management System, R. Ramakrishnan and J. Gehrke 1

Storing Data: Disks and Files Database Management System, R. Ramakrishnan and J. Gehrke 1 Storing and Retrieving Data v Database Management Systems need to: Store large volumes of data Store data reliably (so that data is not lost!)

538 views • 16 slides

an introduction reach1to1 - 1 / 25 what we do big data solutions for capturing, storing,

an introduction reach1to1 - 1 / 25 what we do big data solutions for capturing, storing, searching and analyzing structured and unstructured data from multiple sources reach1to1 - 2 / 25 big data technology benefits cluster of low cost

466 views • 25 slides

Storing Data: Database Organization Yea, from the table of my memory Ill wipe away all

Storing Data: Database Organization Yea, from the table of my memory Ill wipe away all trivial fond records. -- Shakespeare, Hamlet 340151 Big Data & Cloud Computing (P. Baumann) 1 ...Now Databases, Again Buffering

569 views • 25 slides

Data Structures + BIG-O Notation Understanding the engineering trade-offs when storing data

CSSE 220 Data Structures + BIG-O Notation Understanding the engineering trade-offs when storing data Checkout LinkedListSimple project from public git Checkout SinglyLinkedList homework from git Data Structures Efficient ways to store data

239 views • 9 slides

Checkout DataStructures from SVN Understanding the engineering trade-offs when storing data

Data-structure-palooza Checkout DataStructures from SVN Understanding the engineering trade-offs when storing data Boil down data types (e.g., lists) to their essential operations Choosing a data structure for a project then becomes:

664 views • 14 slides

Hash tables Most data structures that were going to see are about storing and manipulating data

Hash tables Most data structures that were going to see are about storing and manipulating data When only operations Insert , Search and Delete as dictionary operations are needed, hash tables can be quite good Many variations of hash tables

1.04k views • 17 slides

Programming With Data One-Slide Summary A list is a data structure , a way of storing and

Programming With Data One-Slide Summary A list is a data structure , a way of storing and organizing data. cons creates a pair of two values. car and cdr (or first and rest ) extract the first and second elements of a cons pair. A

205 views • 8 slides

Simple SQL Queries (1) Review Collecting data Storing data into databases Create

Simple SQL Queries (1) Review Collecting data Storing data into databases Create relational tables in SQL Server 2005 Insert tuples into tables Specifying some integrity constraints CMPT 354: Database I -- Simple SQL (1)

268 views • 24 slides

Physical Data Organization and Indexing Chapter 9 1 Disks Capable of storing large

Physical Data Organization and Indexing Chapter 9 1 Disks Capable of storing large quantities of data cheaply Non-volatile Extremely slow compared with cpu speed Performance of DBMS largely a function of the number of disk

1.35k views • 76 slides

Reassembleable Disassembling Shuai Wang, Pei Wang, Dinghao Wu Pennsylvania State University 24th

Reassembleable Disassembling Shuai Wang, Pei Wang, Dinghao Wu Pennsylvania State University 24th USENIX Security Symposium, August 2015 1 / 14 Motivation Analysing and retrofitting COTS binaries with. . . software fault isolation control-flow

512 views • 18 slides

MIPS Assembly (Arithmetic, Branches) 2 Lab Schedule Activities Assignments Due This Week Lab

Computer Systems and Networks ECPE 170 Jeff Shafer University of the Pacific MIPS Assembly (Arithmetic, Branches) 2 Lab Schedule Activities Assignments Due This Week Lab 10 Due by Apr 11 th 5:00am Tuesday: MIPS lecture

726 views • 47 slides

Using Alloy in a Language Lab Approach to Introductory Discrete Mathematics Charles Wallace

Using Alloy in a Language Lab Approach to Introductory Discrete Mathematics Charles Wallace Michigan Technological University In collaboration with Laura Brown, Adam Feltz Supported by the National Science Foundation under grant DUE-1504860

368 views • 15 slides

Environment Setup Assignment 0 The Technology Stack Manages node_modules (external tools)

Environment Setup Assignment 0 The Technology Stack Manages node_modules (external tools) Creates web server Stores data persistently with JSON logic. Utilizes NoSQL instead of SQL Facilitates HTTP requests and

350 views • 11 slides

CISC 322 Software Architecture Lecture 13: Reflexion Models and Source Sticky Notes Emad

CISC 322 Software Architecture Lecture 13: Reflexion Models and Source Sticky Notes Emad Shihab Paper by: Ahmed E. Hassan and Richard C. Holt Slides adapted from Ahmed E. Hassan Midterm Group presentations Tuesday Team Phoenix

669 views • 29 slides

Continuous Database Evolution Prof. Dr. Uta Strl Darmstadt University of Applied Sciences

Continuous Database Evolution Prof. Dr. Uta Strl Darmstadt University of Applied Sciences Application version n Application version n + Schema Management Schema Management Schema Evolution Data Migration February 2019 Motivation

679 views • 31 slides

Peter Doschkinow ORACLE Deutschland B.V. & Co. KG The following is intended to outline our

Avatar Erweiterung der Java EE Plattform fr JavaScript Fans Peter Doschkinow ORACLE Deutschland B.V. & Co. KG The following is intended to outline our general product direction. It is intended for information purposes only, and may not be

719 views • 42 slides

Node.js MVC Construction Rabbit.js MVC @ Rabbit.js a fast

Node.js MVC Construction Rabbit.js MVC @ Rabbit.js a fast and light mvc framework for Nodejs https://github.com/xinyu198736/Rabbit.js sudo npm install rabbitjs -g FAST LIGHT why use it light

484 views • 19 slides