1 / 17

Managing Data to Produce Information

Managing Data to Produce Information. Base line. Data is words, numbers, dates, images, sounds etc without context . is processed by computers, the resulting  information  can then be used to make decisions http:// www.bbc.co.uk/schools/gcsebitesize/ict/databases/0datainforev1.shtml

bruis
Download Presentation

Managing Data to Produce Information

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Managing Data to Produce Information

  2. Base line • Data • is words, numbers, dates, images, sounds etc without context. • is processed by computers, the resulting information can then be used to make decisions • http://www.bbc.co.uk/schools/gcsebitesize/ict/databases/0datainforev1.shtml • Nice definition for modern data processing

  3. Information • is a collection of words, numbers, dates, images, sounds etc put into context, ie to give them meaning. • Same source • Not so nice, what does “give them meaning” actually mean ?

  4. So is this the best song ever ? • Gangnam video first to hit two billion views on YouTube • By Rick Kelsey • Newsbeat reporter • 31 May 2014 • http://www.bbc.co.uk/newsbeat/27647802

  5. Information Systems • is the study of complementary networks of hardware and software ….. • that people and organizations use to collect, filter, process, create and distribute data • Jessup; Joseph  Information Systems Today

  6. Management information System • is a computer system that assists in decision making and the wider conduct of the management function within an organisation: • “A computerized database ... for every level of management” (Inc.com, 2014). • For example, financial systems should be able to produce reports that inform management on fiscal matters, which is almost always a critical part of an organisation's concerns.

  7. Graphical Information System • is a computer system specifically relating to real word geographic data, • “which can be used for scientific investigations, resource management and development planning” • “capable of capturing, storing, analyzing, and displaying geographically referenced information” • (Koury, Downing & Semenza, 2012).

  8. http://www.jobstats.co.uk/ • Data or information • Information System or Management Information System

  9. On jobstats • Search for • SQL • Big data • And use the quick link to SQL Alternate site http://www.computing.co.uk/jobs • For SQL jobs • Big data

  10. Big Data • Standard definition • Big data is high-volume, high-velocity and high-variety information assets that demand cost-effective, innovative forms of information processing for enhanced insight and decision making. • http://www.gartner.com/it-glossary/big-data/

  11. Various sources

  12. or • IBM data scientists break big data into four dimensions: volume, variety, velocity and veracity • http://www.ibmbigdatahub.com/infographic/four-vs-big-data

  13. Other V’s • Value • Visualization • As you can see, Big Data depends on your point of view and which definition you decide to select • Is quality address ?

  14. or • Some definitions discuss issues to do with • Structured data • Semi structured data • Unstructured data • standard XML data feed • Take Yahoo weather feed

  15. Or • Discuss dig data in terms • Of documents • Rather than data • http://www.mongodb.org/ • “Data in MongoDB has a flexible schema. Collections do not enforce document structure. This flexibility gives you data-modeling choices to match your application and its performance requirements.”

  16. Traditional DB • Is rows and columns • Structured, semi structured • Or is columns and rows • Weather data • Google Bigquery

  17. For this workshop • Use Oracle • Via Oracle SQLplus • From a CMD window • sqlplus SURFS/UP@crusstuora1/stora • Or MYSQL • Web browser • http://web.fces.staffs.ac.uk/phpmyadmin/ • User id raf1/raf1

More Related