data management question

03-27-2023 01:09 PM
Labels (3)
New Contributor

I know this is a vague question, but does anyone have suggestions on data management.

Maybe a book, website, or other resources for data management?

I want to get better with my data management. I feel like I'm all over the place and I would love some tips.


0 Kudos
5 Replies
MVP Esteemed Contributor

You'll probably get pretty vague answers, honestly. The "best" way to manage data depends a lot on what kind of data, how it's being used, how many people need to access and / or update it, whether it's sensitive, etc, etc.

Are you able to share more details about the kinds of data you're working with, and the operational needs related to that data?

- Josh Carlson
Kendall County GIS
0 Kudos
Frequent Contributor II

You could consider advancing your SQL skills, if applicable. Understanding the power of SQL is a superpower. Example: One-to-first joins: Control what related record is used

SQL Resources:

  1. This is the best general SQL book I've come across: SQL in 10 Minutes a Day, Sams Teach Yourself 5th Ben Forta.
    There are also database-specific versions:
    Teach Yourself Oracle PL/SQL
    Teach Yourself Microsoft SQL Server T-SQL
  2. And this PostgreSQL-focused book is helpful too, even if you use a different database: 
    SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights by Cathy Tanimura.
  3. There are video courses and live trainer-led courses on O'Reilly Learning. And video courses on LinkedIn Learning.
0 Kudos
New Contributor III

You could also refer to the below mentioned articles for reference. I am not sure if you want to manage an enterprise geodatabase or just a database in general. However, few key points can be considered from the links below. 

Troubleshooting Performance Issues with Enterprise Geodatabase.

Geodatabase Tuning and Performance

General management practice can also include: 

  • Start with a better naming convention. 
  • Data storage options (Eg: Network drive, external disk, cloud storage, etc.)
  • Make sure to Document everything.
  • Automate/Perform database backups in a timely manner.
  • Archive your data.
  • Encrypt sensitive data.

I hope this is helpful. 



Esri Contributor

Esri offers two great training courses that may help you and your organization.

Deploying and Maintaining a Multiuser Geodatabase -

Managing Geospatial Data in ArcGIS -

If you have access to LinkedIn Learning there is an abundance of database management content there.

0 Kudos
Frequent Contributor II

Hi everyone, just a heads up, this is a spam post. Similar posts get reposted by different users once or twice a month. @JesseCloutier has already deleted some previous posts. We just got anther one over the weekend.

0 Kudos