peter fox data science – csci/erth/itws-6961 week 9, october 30, 2012
DESCRIPTION
Academic Basis for Data and Information Science, Data Models, Schema, Data Tools and Data as Service Paradigms. Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012. Contents. Informatics Data models Schema Tools Markup languages Data as service - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/1.jpg)
1
Peter Fox
Data Science – CSCI/ERTH/ITWS-6961
Week 9, October 30, 2012
Academic Basis for Data and Information Science, Data
Models, Schema, Data Tools and Data as Service
Paradigms
![Page 2: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/2.jpg)
Contents• Informatics
• Data models
• Schema
• Tools
• Markup languages
• Data as service
• How are the projects going?
2
![Page 3: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/3.jpg)
Definitions (revisited)
• Data - are pieces of <x> that represent the qualitative or quantitative attributes of a variable or set of variables.
• Data (plural of "datum", which is seldom used) - are typically the results of measurements and can be the basis of graphs, images, or observations of a set of variables.
• Data - are often viewed as the lowest level of abstraction from which information and knowledge are derived 3
![Page 4: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/4.jpg)
Definitions ctd.
• Information– Representations (of facts? data?) in a form that
lends itself to human use
• Knowledge– …. meaning
4
![Page 5: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/5.jpg)
Data-Information-Knowledge Ecosystem
5
Data Information Knowledge
Producers Consumers
Context
PresentationOrganization
IntegrationConversation
CreationGathering
Experience
![Page 6: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/6.jpg)
6
Mind the gap• As we aim to use modern technology to
advance data science:
• There is often a gap between science and
the underlying infrastructure and technology
that is available
• Cyberinfrastructure is the new research environment(s) that support advanced data acquisition, data storage, data management, data integration, data mining, data visualization and other computing and information processing services over the Internet.
Informatics - information science includes the
science of (data and) information, the practice
of information processing, and the engineering
of information systems. Informatics studies the
structure, behavior, and interactions of natural
and artificial systems that store, process and
communicate (data and) information. It also
develops its own conceptual and theoretical
foundations. Since computers, individuals and
organizations all process information,
informatics has computational, cognitive and
social aspects, including study of the social
impact of information technologies. Wikipedia.
![Page 7: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/7.jpg)
A moment of history
• In the late 1950’s (actually around 1957-1958) the modern informatics term was coined
• Existed for a while but then split into library science and computer science and developed their own fields, became disconnected
• Now coming back to be relevant to science
• Informatics IS NOT just having a scientist work with an “IT/ICT” person (NOT, NOT, NOT) 7
![Page 8: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/8.jpg)
Advertisement• Spring 2013 – Xinformatics
• http://tw.rpi.edu/web/course/Xinformatics/2013
8
![Page 9: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/9.jpg)
Library science• Curates the artifacts of knowledge
• Organizes and manages them for consumers– Cataloging and classification
• Preservation– ‘maintaining or restoring access to artifacts,
documents and records through the study, diagnosis, treatment and prevention of decay and damage’ (wikipedia)
• Digital age– Curation and preservation
9
![Page 10: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/10.jpg)
Cognitive Science• Cognitive science is an interdisciplinary study
of the mind and intelligence
• It operates at the intersection of psychology, philosophy, computer science, linguistics, anthropology, and neuroscience.
• Of relevance for data and information science are three significant theoretical underpinnings– mental representation,– the nature of expertise, – and intuition
• Very relevant to model, data/metadata choice10
![Page 11: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/11.jpg)
Social Science• Branch of humanities
• Especially as it relates to networks of scientists
• Exploits sociology of groups, teams
• Cultural norms as well as discipline norms– Modes of what and how rewards are given– Between those who produce and those who
consume data (and information)– More
11
![Page 12: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/12.jpg)
Information theory• Semiotics, also called semiotic studies or
semiology, is the study of sign processes (semiosis), or signification and communication, signs and symbols, into three branches:– Syntactics: Relation of signs to each other in
formal structures– Semantics: Relation between signs and the
things to which they refer; their denotata– Pragmatics: Relation of signs to their impacts on
those who use them 12
![Page 13: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/13.jpg)
Note: we have theories for…
• Knowledge -> various forms of logic(s)
• Information (Shannon, Weaver, Peirce…)
• But not ‘Data’ (except for Mealy and some other person I keep forgetting ;-( …)
![Page 14: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/14.jpg)
Premise
14
Data Information Knowledge
Context
PresentationOrganization
IntegrationConversation
CreationGathering
Experience
![Page 15: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/15.jpg)
1. Assume context free• Content and Structure• D=f(x;p)• D=data, f=transduction function, x=thing, p=parametric
dependence (e.g. time of transduction)
• HAVE – Syntax • DO NOT HAVE - Semantics – no meaning without context• OR - Pragmatics – no use without meaning??
• What about - Uncertainty, quality, bias (error) – none without context?
![Page 16: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/16.jpg)
2. Assume minimal context• Minimal = incomplete?• E.g. know instrument but not when, or of what• E.g. know what but not how
• Partial uncertainty? Conditional entropy?
• Constructive induction?
![Page 17: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/17.jpg)
(Information) Architecture
• Definition: – “is the art of expressing a model or concept of
information used in activities that require explicit details of complex systems” (wikipedia)
– “… I mean architect as in the creating of systemic, structural, and orderly principles to make something work - the thoughtful making of either artifact, or idea, or policy that informs because it is clear.” Wuman
17
![Page 18: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/18.jpg)
Information Models• Conceptual models, sometimes called domain
models, are typically used to explore domain concepts
• High-level conceptual models are often created as part of initial requirements envisioning efforts as they are used to explore the high-level static business or science or medicine structures and concepts.
• Conceptual models are often created as the precursor to logical models or as alternatives to them
• Followed by logical and physical models• http://en.wikipedia.org/wiki/Data_modelling
18
![Page 19: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/19.jpg)
Data Models• Conceptual data models, sometimes called domain
models, are typically used to explore domain concepts
• High-level conceptual models are often created as part of initial requirements envisioning efforts as they are used to explore the high-level static business structures and concepts.
• Conceptual data models are often created as the precursor to logical data models or as alternatives to LDMs.
19
![Page 20: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/20.jpg)
Conceptual model
20
![Page 21: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/21.jpg)
Data Models• Logical data models (LDMs). • LDMs are used to explore the domain concepts,
and their relationships, of your problem domain. • This could be done for the scope of a single project
or for your entire enterprise. • LDMs depict the logical entity types, typically
referred to simply as entity types, the data attributes describing those entities, and the relationships between the entities.
21
![Page 22: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/22.jpg)
Logical model
22
![Page 23: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/23.jpg)
Data Models• Physical data models (PDMs). • PDMs are used to design the internal schema of a
database, depicting the data tables, the data columns of those tables, and the relationships between the tables.
• PDMs often prove to be useful on a range of applications
23
![Page 24: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/24.jpg)
Physical model
24
![Page 25: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/25.jpg)
25
![Page 26: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/26.jpg)
26
![Page 27: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/27.jpg)
27
![Page 28: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/28.jpg)
28
![Page 29: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/29.jpg)
Conceptual model – shoreline photos
29
![Page 30: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/30.jpg)
Logical model – shoreline photos
30
![Page 31: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/31.jpg)
However as a consumer• Do you ever really see these data models?
• What’s the most common form of making data available to others?
• What’s the most common means? Second most common?
31
![Page 32: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/32.jpg)
Example XML<?xml version="1.0" encoding="ISO-8859-1"?>
<shiporder orderid="889923"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="shiporder.xsd">
<orderperson>John Smith</orderperson>
<shipto>
<name>Ola Nordmann</name>
<address>Langgt 23</address>
<city>4000 Stavanger</city>
<country>Norway</country>
</shipto>
<item>
<title>Empire </title>
<note>Special Edition</note>
<quantity>1</quantity>
<price>10.90</price>
</item>
<item>
<title>Hide your heart</title>
<quantity>1</quantity>
<price>9.90</price>
</item>
</shiporder>
32
![Page 33: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/33.jpg)
Very simple schema<?xml version="1.0" encoding="ISO-8859-1" ?>
<xs:schema xmlns:xs=http://www.w3.org/2001/XMLSchema>
<xs:element name="shiporder">
<xs:complexType>
<xs:sequence>
<xs:element name="orderperson" type="xs:string"/>
<xs:element name="shipto">
<xs:complexType>
<xs:sequence>
<xs:element name="name" type="xs:string"/>
<xs:element name="address" type="xs:string"/>
<xs:element name="city" type="xs:string"/>
<xs:element name="country" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
33
<xs:element name="item" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="title" type="xs:string"/>
<xs:element name="note" type="xs:string" minOccurs="0"/>
<xs:element name="quantity" type="xs:positiveInteger"/>
<xs:element name="price" type="xs:decimal"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="orderid" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>
![Page 34: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/34.jpg)
Markup Languages• Reminder:
– Mixes data and metadata, and yes, information– Tag structure does not always model the
underlying data structure– Modeling the XML itself, i.e. the schema is
another task– Does have the potential benefit that it is more for
use than storage
• Parsing the file:– Incomplete versus complete tags– Empty or optional fields 34
![Page 35: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/35.jpg)
Data tools (just a few)• Models
– http://www.datamodel.org/– MSDN:
http://msdn.microsoft.com/en-us/library/bb399249.aspx
• Schema– The Schematron differs in basic concept from other
schema languages in that it not based on grammars but on finding tree patterns in the parsed document. This approach allows many kinds of structures to be represented which are inconvenient and difficult in grammar-based schema languages. If you know XPath or the XSLT expression language, you can start to use The Schematron immediately.
– http://www.schematron.com/35
![Page 36: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/36.jpg)
Markup Language tools• Any context-sensitive editor
• XMLSpy, XML Notepad, XML Editor, oXygen
36
![Page 37: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/37.jpg)
Data as Service• Modern internet architectures allow for
– Service oriented architectures– Resource oriented architectures
• Why is this important for data models, schema, etc.– Hides/ obscures underlying model, schemas– Service interfaces are often a poor/ hybrid match
for underlying models
• UML and ISO 19xxx family of standards, e.g. 19135 are changing the landscape
• Mature in certain settings.37
![Page 38: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/38.jpg)
Open Geospatial Consortium• Web Feature Service (WFS)
– http://www.opengeospatial.org/standards/wfs– support INSERT, UPDATE, DELETE, LOCK,
QUERY and DISCOVERY operations on geographic features using HTTP as the distributed computing platform
– Built on Geographic Markup Language (GML)
• Tutorial– http://docs.codehaus.org/display/MAP/
WFS+Tutorial
38
![Page 39: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/39.jpg)
WFS examples
39
![Page 40: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/40.jpg)
Open Geospatial Consortium• Web Mapping Service (WMS)
– http://www.opengeospatial.org/standards/wms– produces maps of spatially referenced data
dynamically from geographic information ("map" is a portrayal of geographic information as a digital image file suitable for display on a computer screen). A map is not the data itself. WMS-produced maps are generally rendered in a pictorial format such as PNG, GIF or JPEG, or occasionally as vector-based graphical elements in Scalable Vector Graphics formats.
– http://www.intl-interfaces.com/cookbook/WMS/– http://oceanesip.jpl.nasa.gov/esipde/guide.html
40
![Page 41: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/41.jpg)
Open Geospatial Consortium• Web Coverage Service (WCS)
– http://www.opengeospatial.org/standards/wcs– supports electronic interchange of geospatial
data as "coverages" – that is, digital geospatial information representing space-varying phenomena
41
![Page 42: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/42.jpg)
Open Geospatial Consortium• Sensor Observation Service (SOS)
– http://www.opengeospatial.org/standards/sos
• SWE Common– http://www.opengeospatial.org/projects/groups/
swecommonswg – Get_capabilities
42
![Page 43: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/43.jpg)
IVOA (www.ivoa.net)• Simple Image Access Protocol
– http://ivoa.net/Documents/SIA/20091008/PR-SIA-1.0-20091008.pdf
– This specification defines a protocol for retrieving image data from a variety of astronomical image repositories through a uniform interface. The interface is meant to be reasonably simple to implement by service providers. A query defining a rectangular region on the sky is used to query for candidate images.
– The service returns a list of candidate images formatted as a VOTable. For each candidate image an access reference URL may be used to retrieve the image. Images may be returned in a variety of formats including FITS and various graphics formats. Referenced images are often computed on the fly, e.g., as cutouts from larger images.
43
![Page 44: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/44.jpg)
IVOA (www.ivoa.net)• E.g. Simple Spectrum Access Protocol
– http://ivoa.net/Documents/REC/DAL/SSA-20080201.pdf– The Simple Spectrum Access (SSA) Protocol (SSAP)
defines a uniform interface to remotely discover and access one dimensional spectra. SSA is a member of an integrated family of data access interfaces altogether comprising the Data Access Layer (DAL) of the IVOA.
– SSA is based on a more general data model capable of describing most tabular spectrophotometric data, including time series and spectral energy distributions (SEDs) as well as 1-D spectra; however the scope of the SSA interface as specified in this document is limited to simple 1-D spectra, including simple aggregations of 1-D spectra.
44
![Page 45: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/45.jpg)
Discussion• Theoretical concepts?
• Data models?
• Schema?
• Tools?
• Service paradigms?
• Relation to data management?
• Provenance considerations– Is encapsulation good?
45
![Page 46: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/46.jpg)
Summary• Informatics as a new field
• Data models and schema and the tools that go with them are plentiful
• Modern use of XML and specific markup languages obscure the underlying data structure (physical and logical) but have other advantages
• Data as service carry this to another level
46
![Page 47: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/47.jpg)
What is next• Next week
– Data Workflow Management, Preservation and Data Stewardship
• Reading:– See web site
47
![Page 48: Peter Fox Data Science – CSCI/ERTH/ITWS-6961 Week 9, October 30, 2012](https://reader036.vdocuments.us/reader036/viewer/2022062322/56814553550346895db222ee/html5/thumbnails/48.jpg)
How about those projects?
48