data management question

[erik2]

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.

Thanks,

[jcarlson]

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?

[Bud]

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 Edition.by 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.

[VaibhavS]

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.

https://www.esri.com/content/dam/esrisites/en-us/about/events/media/UC-2019/technical-workshops/tw-6...

Geodatabase Tuning and Performance
http://downloads.esri.com/support/ProjectCenter/Geodatabase_Tuning_and_Performance.pdf

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. 

Thanks,

Vaibhav

[SimonAlfordEsriAU]

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

Deploying and Maintaining a Multiuser Geodatabase - https://www.esri.com/training/catalog/57630436851d31e02a43f104/deploying-and-maintaining-a-multiuser...

Managing Geospatial Data in ArcGIS - https://www.esri.com/training/catalog/59c407ad3049c71bb91d784f/managing-geospatial-data-in-arcgis/

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

[Bud]

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.