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

Spatial Support in MySQL

00:00
subtitles
off
playback rate
1
subtitles
off
English (auto-generated)
playback rate
0.25
0.5
0.75
1
1.25
1.5
1.75
2
quality
576p
9
 Cite
 Share
 Related Material
 Download Purchase
No logo availableFOSS4G
Logo of Open Source Geospatial Foundation (OSGeo)Open Source Geospatial Foundation (OSGeo)
 Ryeng, Norvald H.

Formal Metadata

Title
Spatial Support in MySQL
Title of Series
Number of Parts
295
Author
Contributors
License
CC Attribution 3.0 Germany:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
MySQL 8.0 was a huge step in terms of spatial support -- a step up from flat Cartesian coordinate systems to ellipsoidal geography. In this talk we'll go on a quick tour of the spatial support in MySQL. We'll cover data types, functions, indexes, coordinate reference systems and other core topics. We'll look at both the big design decisions and practical use. What can MySQL do? How does it work? What are the limitations? Join us for answers to these questions and more!
Keywords
00:00
Pole (complex analysis)Social classGroup actionSlide rulePhysical systemLecture/Conference
00:53
Subject indexingSystem programmingType theoryData storage deviceFunction (mathematics)Computer programOracleAlgorithmGeometryCartesian productEllipsoidPhysical systemType theoryWordData managementData typeOrder (biology)AlgorithmDatabaseProduct (business)Set (mathematics)Computing platformMultiplicationMetadataRun time (program lifecycle phase)AdditionString (computer science)NumberComputer hardwareMultiplication signLibrary (computing)Video gameBitStandard deviationInclined planeService (economics)Direction (geometry)Suite (music)Line (geometry)Computer configurationResultantFunctional (mathematics)Computer animation
04:48
Frame problemRun time (program lifecycle phase)Tablet computerProcess (computing)Lecture/Conference
05:26
OracleGeometryAlgorithmCartesian productSystem programmingEllipsoidData dictionaryTable (information)View (database)ParsingFunction (mathematics)PolygonString (computer science)Line (geometry)MultiplicationType theoryCartesian productDatabaseCoordinate systemNumberLine (geometry)Library catalogType theoryString (computer science)Extension (kinesiology)Physical systemNeuroinformatikData typeGraph (mathematics)InformationOpen sourceSpacetimeNetwork topology2 (number)Military baseInstallation artPlanningProcess (computing)Descriptive statisticsSkewnessSelf-organizationPolygonComputer animation
07:17
System programmingStatement (computer science)Physical systemDrop (liquid)Cartesian coordinate systemData dictionaryCloud computingOracleDirection (geometry)Execution unitPlanningProduct (business)GeometryLibrary catalogPhysical systemCartesian coordinate systemDefault (computer science)Moment (mathematics)MereologySet (mathematics)Projective planeOrder (biology)Procedural programmingOffice suiteRegulator geneProcess (computing)MassComputer animation
09:02
Execution unitEllipsoidGeodesicLine (geometry)OracleSubject indexingData storage deviceGeometryWKB-MethodePoint (geometry)Key (cryptography)IntegerPrice indexTable (information)Cartesian coordinate systemFunction (mathematics)Functional (mathematics)CuboidCartesian coordinate systemNetwork topologyMultiplication signString (computer science)Line (geometry)Table (information)Point (geometry)System callObservational studyPhysical systemData storage deviceWebsiteType theoryAxiom of choiceHydraulic jumpDifferent (Kate Ryan album)GeometryMereologyLogicPlanningQuery languageMoment (mathematics)Ferry CorstenGreat circleInterpreter (computing)DemosceneGroup actionWritingProcess (computing)Decision theory1 (number)Office suiteSphereCurveExecution unitCircleHash functionSubject indexingBinary codeData typeMathematical optimizationEllipsoidCartesian productMixed realityFront and back endsExtension (kinesiology)Computer animation
12:52
Expert systemFunction (mathematics)Convex hullPairwise comparisonGeometryInsertion lossStandard deviationField (computer science)Open setWeb 2.0Pairwise comparisonSubject indexingCategory of beingINTEGRALFunctional (mathematics)
13:37
OraclePairwise comparisonFunction (mathematics)Functional (mathematics)Standard deviationNeuroinformatikShape (magazine)Right angleGeometryCuboidTouchscreenComputer configurationExecution unitLengthPhysical systemBound stateMathematicsLevel (video gaming)Envelope (mathematics)Operator (mathematics)View (database)Data conversionMeasurementWebsiteMultiplication signSoftware testingBuffer solutionBitAreaMetreResultantDecision theoryComputer animation
15:16
Function (mathematics)Drag (physics)Wechselseitige InformationPhysical systemDistanceAreaExecution unitRing (mathematics)Set (mathematics)LengthFunctional (mathematics)MetrePoint (geometry)Computer animation
15:49
Function (mathematics)OracleCartesian productException handlingGeometryFunctional (mathematics)GeometryRule of inferenceRevision controlPhysical systemData typeNetwork topologyTouch typingMobile appMereologyAreaComputer animation
17:04
Function (mathematics)Cartesian productException handlingGeometryPatch (Unix)SoftwareFunctional (mathematics)Software developerProjective planeOpen sourceOpen setCellular automatonProduct (business)Lecture/ConferenceComputer animation
18:00
Function (mathematics)Product (business)WordOrder (biology)Projective planeComputer animation
18:51
OracleSource codeComa BerenicesData managementBlogSoftware developerServer (computing)Source codeLevel (video gaming)InformationUsability
19:54
Symbol tableCartesian coordinate systemOrder (biology)MathematicsProjective planeComputer clusterSet (mathematics)SpacetimeDirection (geometry)Physical systemState of matterPolarization (waves)Statement (computer science)1 (number)NumberArithmetic meanDifferent (Kate Ryan album)Lecture/Conference
22:04
Projective planeLecture/Conference
Transcript: English(auto-generated)