O'Reilly logo

Data Clean-Up and Management by Kenneth Furuta, Margaret Hogarth

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

9

Access techniques

Abstract:

A carefully designed database with clean, normalized data is a powerful tool. Create a database by uploading or building a table, copy tables, define fields, specify data type and indexing, and begin work.

Key words

database

entities

data

Access

field

data

What is a database?

A database is a container for data. If there is a large amount of data, long strings of information in the fields, many people will be working on it, and/or data needs to be combined with other data, a database is the best tool to use. Databases can be flat or relational. A flat database is like a spreadsheet. An example is COUNTER Journal 1 data. If I wanted to find the usage of a particular journal, all platforms, I would ask for the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required