We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Optimising Spatial Data Analysis With PostgreSQL And PostGIS

00:00

Formal Metadata

Title
Optimising Spatial Data Analysis With PostgreSQL And PostGIS
Title of Series
Number of Parts
95
Author
License
CC Attribution - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date
Language
Production PlaceNottingham

Content Metadata

Subject Area
Genre
Abstract
In this talk we will demonstrate spatial data analysis on the relational database system PostgreSQL (http://www.postgresql.org) equipped with the spatial extension PostGIS (http://www.postgis.org). We will gradually introduce some of the optimisation techniques provided by PostgreSQL, by applying them to the solution of increasingly complex problems belonging to the PostGIS domain. Our aim is to point out as clearly as possible the main ideas behind each example, showing the link in both projects between development of new features and the need to tackle real-world problems. Topics mentioned in this talk include: the special index types GiST and SP-GiST; custom database objects, such as data types, functions and operators; query and workload profiling.
Data analysisStokes' theoremCausalityComputer animation
Database transactionConcurrency (computer science)Set theoryData integrityLogicData storage deviceData modelDatabaseNim-SpielSession Initiation ProtocolFreewareSpeech synthesisFinite element methodVarianceView (database)Operator (mathematics)Replication (computing)Subject indexingField extensionStreaming mediaPerturbation theoryType theoryRange (statistics)Thermal expansionTable (information)Relational databaseConstraint (mathematics)PredictabilityMetropolitan area networkOvalData structureMiniDiscFocus (optics)Fourier seriesBeer steinGeometryStandard deviationData analysisCore dumpBASIC-ASet (mathematics)Flow separationTheoryRelational databaseDatabaseData storage deviceSpeech synthesisPartition (number theory)Different (Kate Ryan album)Ocean currentElectronic mailing listSpacetimeNeuroinformatikExtension (kinesiology)Subject indexingInformationComputer filePhysical systemGeometryEndliche ModelltheorieMappingOperating systemPresentation of a groupPoint (geometry)Set (mathematics)Type theoryOperator (mathematics)Data typePlanningObject (grammar)Client (computing)QuicksortAreaOpen setComputer hardwareMultiplication signConcurrency (computer science)Web-DesignerLogicArithmetic meanTable (information)Query languageCalculationMiniDiscImplementationServer (computing)HypermediaSystem callState of matterHand fanMereologyDemosceneLocal ringNatural numberNumberFunction (mathematics)Adaptive behaviorData structureVotingCodeWhiteboardRenewal theoryWebsiteGame theoryDivisorWater vaporProcess (computing)FrequencyPopulation densityBasis <Mathematik>View (database)Customer relationship managementMathematicsSeries (mathematics)Level (video gaming)DistanceComputer animation
GeometryStandard deviationNim-SpielType theorySubject indexingCore dumpField extensionBASIC-ASet (mathematics)Flow separationPairwise comparisonPoint (geometry)Generic programmingPrice indexAlgorithmSpacetimeObject (grammar)CubeCirclePolygonSubsetAreaScalar fieldOperator (mathematics)Boolean algebraMathematical optimizationUniform resource nameNumberShape (magazine)Loop (music)Run time (program lifecycle phase)Lattice (order)Digital filterThermal expansionPort scannerProgrammschleifeNumberMultiplication signRow (database)NeuroinformatikSubject indexingSymbol tableMereologyReverse engineeringCuboidChemical equationType theoryPoint (geometry)Table (information)Set (mathematics)Query languageFunction (mathematics)2 (number)Network topologyResultantCASE <Informatik>Order (biology)QuicksortShape (magazine)Different (Kate Ryan album)DatabaseWritingVideo gameKeyboard shortcutPhysical systemCircleOnline helpIdeal (ethics)State of matterCausalityLimit (category theory)DemosceneSubsetLiquidDimensional analysisStaff (military)Computer animation
Thermal expansionLoop (music)Run time (program lifecycle phase)Shape (magazine)Memory managementPort scannerSubject indexingPoint (geometry)GeometryDigital filterLattice (order)International Date LineProgrammschleifeNumberAreaCuboidPoint (geometry)Online helpReading (process)MereologyMultiplication signSubject indexingWater vaporShape (magazine)Line (geometry)Computer fileSoftware testingSequenceAutomatic differentiationProgrammer (hardware)Basis <Mathematik>Volume (thermodynamics)ResultantCoefficient of determinationMusical ensemblePatch (Unix)Radical (chemistry)Different (Kate Ryan album)NeuroinformatikRectangleQuery languageRow (database)Variable (mathematics)Function (mathematics)Structural loadPort scanner1 (number)Table (information)Database2 (number)Operator (mathematics)AreaComputer animation
Nim-SpielPoint (geometry)Shape (magazine)NumberCuboidAreaLoop (music)Run time (program lifecycle phase)Thermal expansionMemory managementPort scannerInternational Date LineSubject indexingGeometryDigital filterProgrammschleifeData analysisElectronic program guideQuantum3 (number)Revision controlSubject indexingPoint (geometry)Shape (magazine)CASE <Informatik>Software maintenanceBeat (acoustics)Window1 (number)Type theory2 (number)Multiplication signDecision theoryMathematicsSlide ruleCodeFood energyProcedural programmingIdentity managementPartition (number theory)Schweizerische Physikalische GesellschaftQuicksortCircleRow (database)CuboidAreaLine (geometry)SpacetimeRectangleEquivalence relationComputer animation
Transcript: English(auto-generated)