1 / 29

Databases and Landwor k

Databases and Landwor k. WebEx Broadcast October 4, 2013. a comprehensive collection of related data organized for convenient access, generally in a computer. What is a database?. a comprehensive collection of related data organized for convenient access, generally in a computer

lesa
Download Presentation

Databases and Landwor k

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. Databases and Landwork WebEx Broadcast October 4, 2013

  2. a comprehensive collection of related data organized for convenient access, generally in a computer What is a database?

  3. a comprehensive collection of related data organized for convenient access, generally in a computer • Phone book • Dictionary • Index books

  4. Per definition, database is simply the data • A Program or System is what facilitates entry and processing of that data • The terms ‘Database’ and ‘Database System’ are essentially interchangeable Database vs. Database Program or System

  5. CourthouseIndexes • Printed and electronic • State Mineral Websites (Sonris, NDIC, etc.) • Search Engines • Google • Bing • Social Media • Facebook • Linked In Everyday databases in land work

  6. And of course… • Spreadsheets • Simple but powerful • Sorting • Arithmetic • We will revisit spreadsheets when we discuss design options Everyday databases in land work

  7. Image files may contain “metadata” • State Mineral Websites • Well and production data • Vs. • Associated image of document Images and Associated Files vs. Data

  8. Speed • Accuracy • Convenience • Control • Standardization • Normalization Benefits of an Electronic Database

  9. Speed • Generally real-time • Data is already normalized (see below) • Info not only gathered but manipulated instantly • Accuracy • Not subject to human mistakes Benefits of Electronic Databases

  10. Convenience • Don’t have to handle paper sources • Web access even better • Database program gathers and manipulates data for you Benefits of an Electronic Database

  11. Control • Very easy based on User IDs, authority levels • Types of authority • Degrees or areas of access • Prospects • States • Divisions • Standardization • Users select from options • Normalization • Table structure and general design tailored to task Benefits of an Electronic Database

  12. Security, Security, Security • Users • Hackers • Viruses • Failures • Disasters Drawbacks of an Electronic Database

  13. Flat • Spreadsheets • Easier to set up, more difficult to maintain • Has orientation as described below • Much data repetition • Relational • Related tables • More difficult to set up, easier to maintain Two Types of Databases

  14. Worth mentioning… • Object Oriented • Tables not directly related • Usually best for very large amounts of data with relatively few tables Two Three Types of Databases

  15. Four broad types of permission • Read • Write • Edit • Delete • Much of what we have discussed is read access only Database Permission Types

  16. Divided into 2 broad categories • Acquisition/Tracking • Tract-oriented database • Concerned with % signed, restrictions, etc. • Management • Contract-oriented database • Concerned with rights and obligations Databases for the Land Industry

  17. Several companies • TotaLand • iLandman • Land Boss • Commonly tract-oriented • Document generation (leases, reports, etc.) • Real-time reporting • Linking to GIS • Data Gathering Field Acquisition and Tracking Systems

  18. Note the repetition of records Tract-Oriented Design

  19. Leading companies • Tobin • Quorum • Land Pro • Generally contract-oriented • Tracking of rights, obligations over time • Deaths, sales, expirations • WI, RI, ORRI, NPRI • Division Orders • Joint Interest Billing Asset Management Systems

  20. Contract-Oriented Design Again, note the repetition of records

  21. Non-Oriented Design Cross Tables as opposed to Sub Tables

  22. Each design has pros and cons • All systems attempt to relate key data • Tracts • Contracts • Parties • Units • Wells • Instruments • Projects • Payments • Etc., etc. Common Thread

  23. Review - Electronic Databases

  24. Review - Electronic Databases Tract-oriented Contract-oriented Non-oriented

  25. Databases are all around us • Electronic databases are critical to everyday life, and the land industry is no exception • Generally speaking, the front end side of the land industry has been slow to embrace significant integration of databases • Solutions are getting better, prices are coming down • Get on the bus or get left behind… Closing thoughts…

  26. Please type in questions Questions

  27. Bill Justice BJustice@TotaLand.com CE Credit Affidavits

  28. The recording of this webinar will be posted on our WebEx portal shortly after complete. TotaLand.Webex.com Thank you! Databases and Landwork

More Related