PostgreSQL as a Schemaless Database

pages

Documents

2013

Lire un extrait

Obtenez un accès à la bibliothèque pour le consulter en ligne En savoir plus

Découvre YouScribe en t'inscrivant gratuitement

Je m'inscris

Découvre YouScribe en t'inscrivant gratuitement

Je m'inscris

pages

Documents

2013

Lire un extrait

Obtenez un accès à la bibliothèque pour le consulter en ligne En savoir plus

Publié par

kyann

Publié le

04 juillet 2013

Nombre de lectures

158

PostgreSQL as a Schemaless Database. Christophe Pettus PostgreSQL Experts, Inc. PgDay FOSDEM 2013 Welcome! I’m Christophe.• PostgreSQL person since 1997.• Consultant with PostgreSQL Experts, Inc.• cpettus@pgexperts.com• thebuild.com• @xof on Twitter.• What’s on the menu? What is a schemaless database?• How can you use PostgreSQL to store • schemaless data? How does do the various schemaless • options perform? A note on NoSQL. Worst. Term. Ever.• It’s true that all modern schemaless • databases do not use SQL, but… Neither did Postgres before it became • PostgreSQL. (Remember QUEL?) The deﬁning characteristic is the lack of a • ﬁxed schema. Schematic. A schema is a ﬁxed (although mutable • over time) deﬁnition of the data. Database to schema (unfortunate term) to • table to ﬁeld/column/attribute. Individual ﬁelds can be optional (NULL).• Adding new columns requires a schema • change. Rock-n-Roll! Schemaless databases store “documents” • rather than rows. They have internal structure, but…• … that structure is per document.• No ﬁelds! No schemas! Make up whatever • you like! We are not amused. Culturally, very different from the glass • house data warehouse model. Grew out of the need for persistent object • storage… … and impatience with the (perceived) • limitations of relational databases and object-relational managers. Let us never speak of this again. There’s a lot to talk about in schemaless vs • traditional relational databases. But let’s not.

Voir

Publié par

kyann

Publié le

04 juillet 2013

Nombre de lectures

158

Informatique Marketing et communication

PostgreSQL
as a Schemaless Database.

Christophe Pettus
PostgreSQL Experts, Inc.
PgDay FOSDEM

2013

•
•
•
•
•
•

Welcome!

f xo Tonttwi.erC rhsiotIm’tgreSQL phe.Posecni991 sreps noanltwit C7.suon LxEerQSsogthtP cpetnc.s, Ipertoc.strepxegp@sut@om.clduiebthm
sselameesabatadt haWch s aistsrg eoPt oSeLQw ca?Hou usn yo dows oeHrots es chemalesraoisus odt ehv options perform?

schemaless data?

•
•
•

What’s on the menu?

scn erodsslemahe . EvTermIt’ser. ehtt urllm taa esgref be or bitmace eeNtieh rid doPtssi citsiretcarah aofk ac lhe tng ceﬁnihe dT•
•
•
•

A note on NoSQL.

Postgre
SQL
. (Remember QUEL?)

databases do not use SQL, but…

ﬁxed schema.

st. Wor
tablh mue dexﬁ a guohtla( sAisa emch )ot unfortunate termesab ot ehcs( amtaDa.AdULL)l (Nionao tp neb saceﬁdll uaidivndISchematic.

over time) deﬁnition of the data.

•
•
•
•

change.

table to ﬁeld/column/attribute.

am a s hesceq rreuiloc snmugnidwen
nts”aheveh yTctrustl naernt itaht ……tub ,erucSat dasabmahessleod“ emucs seerotre Rock-n-Roll!

rather than rows.

•
•
•
•

you like!

s rtcuuteri sepr document.No ﬁsdleoN !hcs sameMa! ukewhp evat
rof deen eht fot ouw reGa dn… tbjecnt oistepers tnemorfid yreffy,ller vulCratuss the glaWe are not amused.

•
•
•

limitations of relational databases and
object-relational managers.

storage…

house data warehouse model.

he tpe (eircd)vepmi eita ecnhtiw
tuB in schelk about samelssv heTat ot tol a s’er tah nac uoyepxe?cttraditional relational databases.

schemaless data in PostgreSQL, how can
you?

Let us never speak of this
again.

•
•
•

•

And wot tnaw erots sonel’tdoya.tTopic’s t you: If
eg tti.•
•

What is schemaless data?

•
•

hierarchical structure of arrays and key-
value pairs.

one of these…

t if it doesn’t r/wo )si=(erocdrcument” Each “dorutc.denu nurtsot nea ms esesdomelaShc and how to reac …t ha etoecxpint acilnoitonk w sw appThe a
reJSONhsto.otdocument types:
•
XML
•
•

•

PostgreSQL has you
covered.

y’he gvehw et ta’teLes s tnooNid eerht tnereff tot ne,t bu, wo

Voir