Hi everyone! On this blog, I would like to share to you guys about what I have learned and understood about database and information management. But before that, one thing that we should know about is that data is really important as data really helps to make better decisions. In addition, I also learned about database management system and how is important is database management system. Basically, DBMS or simply known as “database management system” is a system software for creating and managing databases. One thing about the DBMS is that it actually provides users and programmers with a systematic way to create, retrieve, update and manage data. About the DBMS itself, one thing that we should know is that DBMS actually makes it possible for end users to create, read, update and even delete data in a database. Also, the DBMS basically serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible. In fact, the DBMS actually brings one of the biggest advantages and one of them is it lets end users and application programmers access and use the same data while managing data integrity which basically means that the data is protected and maintained well.
Besides, there’s types of Database management System including RDBMS and Non Relational or NoSQL (complex). A RDBMS or simply known as “Relational Database management system” is database in a tabular form (tables). Data can be accessed or reassembled in many different ways without having to reorganize the database tables. Here you can see the difference between RDBMS vs No SQL below.
Additionally, I also learned about business intelligent process. In terms of business intelligent process, one thing that we should know is about business intelligent (capturing), business intelligent (analyzing), and data mining and here is the explanation below.
- Business intelligent (capturing)
- Internal source (Data warehouse is a database that stores current and historical data from different department)
- External source
- The two sources then combined by a software called Hadoop and break it down to analyst
- Business intelligent (analyzing)
- Online Analytical Processing (OLAP) performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
- OLAP supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions
- Data mining
- Examining databases (deeper) in order to generate new information and pattern to predict future behavior for decision making.
- Data mining provides insights into corporate data that cannot be obtained with OLAP
Overall, that is all that I would like to share to you and I hope that this blog can be useful and give you some knowledge, also. Thank you very much and have a great day 🙂
Jonathan Andianto 