Shopping Cart

No products in the cart.

BSI PD ISO/IEC TR 19075-8:2019

$215.11

Information technology database languages. SQL technical reports – Multi-dimensional arrays (SQL/MDA)

Published By Publication Date Number of Pages
BSI 2019 78
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

PDF Catalog

PDF Pages PDF Title
2 undefined
5 Contents
7 Tables
8 Figures
9 Foreword
10 Introduction
11 1 Scope
13 2 Normative references
15 3 Terms and definitions
17 4 Multidimensional Arrays (MDA) concepts
4.1 Concept
4.2 Why consider support for MDA in SQL?
19 4.3 Array representations
4.4 Use cases for MDA support in SQL
4.4.1 The use cases
4.4.2 Array data ingestion and storage
20 4.4.3 Integrated querying of array and relational data
4.4.4 Updating stored array data
4.4.5 Exporting arrays
4.5 Non-Use cases: Direct access to external array data
21 5 SQL/MDA data model
5.1 Data model concepts
5.2 MD-array
22 5.3 MD-array type definition
5.3.1 Type definition concepts
5.3.2 Element type
23 5.3.3 MD-dimension
5.3.4 MD-axis names
5.3.5 MD-axis lower and upper limits
24 5.3.6 Putting it all together
26 5.4 MD-array creation
5.4.1 MD-array creation concepts
27 5.4.2 Explicit element enumeration
28 5.4.3 From SQL table query result
29 5.4.4 Construction by implicit iteration
30 5.4.5 Decoding a format-encoded array
31 5.5 MD-array updating
5.5.1 MD-array updating introduction
32 5.5.2 Updating MD-arrays of equal MD-dimension
33 5.5.3 Updating MD-arrays of greater MD-dimension
34 5.5.4 Updating a single element of an MD-array
5.6 Exporting MD-arrays
5.6.1 Encoding to a data format
36 5.6.2 Converting to an SQL table
39 6 SQL/MDA operations
6.1 Introduction to SQL/MDA operations
6.2 MD-extent probing operators
41 6.3 MD-array element reference
42 6.4 MD-extent modifying operations
6.4.1 Introduction to MDE-extent modifying operations
6.4.2 Subsetting
44 6.4.3 Reshaping
46 6.4.4 Shifting
6.4.5 MD-axis renaming
47 6.5 MD-array deriving operators
6.5.1 Introduction to MD-array deriving operators
6.5.2 Scaling
49 6.5.3 Concatenation
6.5.4 Induced operations
56 6.5.5 Join MD-arrays on their coordinates
57 6.6 MD-array aggregation
6.6.1 General aggregation expression
58 6.6.2 Shorthand aggregation functions
61 7 Remote sensing example
7.1 Introduction to remote sensing example
7.2 Data setup
63 7.3 Band math
7.3.1 Introduction to band math
7.3.2 NDVI
66 7.3.3 Band Swapping
67 7.4 Histograms
68 7.5 Change detection
69 7.6 Extracting features
70 7.7 Data search and filtering
BSI PD ISO/IEC TR 19075-8:2019
$215.11