Data Management, Databases, and Big Data

Databases are a collection of logically related data. The data and the relationships included built into databases to fulfill a need of the person or organization in charge of the database. To understand database design, we’ll look at its properties, steps and finally core operations.  The 4 properties of DBMS 1. Atomicity - an operation in a database system should be executed completely or not at all. This means that an operation cannot be interrupted or done partially because it would be completely aborted, and the user would be forced to restart. In other words, it maintains the atomicity of the data. 2. Consistency - all the data in a database system is updated before and after an operation is performed. Every fact in our database needs to be checked to make sure everything is consistent and running smoothly. 3. Isolation - each operation runs individually in a database system, preventing interruptions from each other. The data in one database should not affect the other dat...

Every day we interact with data, whether it’s through our everyday decision-making or at a business operational level. However, data is unstructured and our goal as business and data analysts is to turn it into information and knowledge. Sometimes, analysts forget this goal and focus too much on building complex databases and data warehouses without paying attention to the quality and applicability of the data. Data management is the foundation block to everything else that has to do with analyzing data. If our first steps are thoughtless, then our whole structure could crumble. In data management, we gather, process, and examine our data based on the end goal established.  1. Information extraction - Our first step is information extraction, where we use different tools such as website, documents, and other sources to retrieve the specific information we’re trying to analyze. The data we extract needs to help answer the goal that’s set at the beginning. There are different ways w...