Benefits
- Support for encryption and cryptography
- Built-in defense mechanisms
- 3rd library support and high 3rd party framework availability
- Ability to integrate via SOAP and REST
- Load balancing and session fail over support
A database is the name for the system in which data is collected, organized and linked to each other. Data can be requested quickly from linked computers. Extensive analyzes are now also possible via the database model. Finally, the most modern databases are also able to provide complex data for specialized reports.
First Normal Form (1NF)
For a table to be in the First Normal Form, it should follow the following 4 rules:
1. It should only have single(atomic) valued attributes/columns.
2. Values stored in a column should be of the same domain
3. All the columns in a table should have unique names.
4. And the order in which data is stored, does not matter.
Second Normal Form (2NF)
For a table to be in the Second Normal Form,
1. It should be in the First Normal form.
2. And, it should not have Partial Dependency.
Third Normal Form (3NF)
A table is said to be in the Third Normal Form when,
1. It is in the Second Normal form.
2. And, it doesn't have Transitive Dependency.
Fourth Normal Form (4NF)
A table is said to be in the Fourth Normal Form when,
1. It is in the Boyce-Codd Normal Form.
2. And, it doesn't have Multi-Valued Dependency.
What databases do i use?
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams. Redis has built-in replication, Lua scripting, LRU eviction, transactions, and different levels of on-disk persistence, and provides high availability via Redis Sentinel and automatic partitioning with Redis Cluster
Oracle MySQL Database Service is a fully managed database service that lets developers quickly develop and deploy secure cloud native applications using the world’s most popular open source database. The MySQL Database Service Analytics Engine is the only MySQL service with a massively-scalable integrated real-time analytics engine. This service, only available in Oracle Cloud, overcomes the limitations of traditional data warehouse and analytics environments that use periodic long-running ETL batch jobs required to refresh the data.