What should be stored in a database?

Question

What should be stored in the database (RDBMS)? Application logs. Configuration details (like server IP addresses etc.) System information (e.g., names of shell scripts, scheduling information for batch jobs, batch jobs status etc.)

What type of data can we store in database?

Data Type CategoryPrimary UseTextual DataFor storing words, numbers, and symbols, both large and small.Numeric DataStores numbers and only numbers can be integers, decimals, or floating point values.

Why data should be stored in database?

Databases support good data access because: Large volumes of data can be stored in one place. Multiple users can read and modify the data at the same time. Databases are searchable and sortable, so the data you need can be found quick and easily.

How do we store data in a database?

Relational databases store data in tables. Think of a table as a spreadsheet. The database stores data for each table in a row, just like in a spreadsheet. There are lots of different column types, but a column type is just a fancy way of defining the format of a column.

Expert · Answer