Ict world news : An Articles for Questionnaires of Information Technology . How would you define the term “database”? How would you define the term “database management system”?

A database is a systematic collection of structured information, or data, typically stored electronically in a computer system. In simple words, A database in a place where the data is stored.

Database management system

Database Management System (DBMS) is software package system used to store, retrieve, and run queries on data. A DBMS distributes as an interface between a data user and a database, also allowing users to create, read, update, and delete data in the database. Database management system is set up on specific data handling concepts. A complete database is usually controlled by a database management system (DBMS).

Databases make data management easily accessible, manageable and update. Together, the data and the database management system (DBMS), along with the applications that are associated with them. Maximum types of databases use structured query language (SQL) for writing and querying data.

To explain this better, a database example: An online telephone directory uses a database to store information data of people, phone numbers, and other contact details. Our utility service provider uses a database to manage billing, client-related issues, handle fault data, etc. (Oracle Database, 2022) (Techopedia, 2020) (Peterson, 2022)

What is an entity-relationship diagram, and what is its purpose?

An Entity Relationship diagram (ERD) is a type of data modeling blueprint that graphically illustrates the logical structure of databases how “entities” such as people, objects or concepts relate to each other within a system. Its information system’s entities and the relationships between those entities. An Entity Relationship diagram is a conceptual and representational model of data used to represent the entity framework system. (Techopedia, 2017)

What is database as a service (DaaS)?

DaaS is similar to software as a service, or SaaS, a cloud computing strategy that lets users access and use a cloud database system without purchasing and setting up their own hardware, installing their own database software, No experts are needed to manage this database. Databases can be managed themselves.

Data-as-a-service (DaaS) system is deployment model that focuses on the cloud (public or private) to deliver a variety of data-related services such as storage, processing, and analytics. The model uses a cloud based underlying technology that supports SOA and Web services. DaaS information is stored in the cloud database system and is accessible through different devices. (Hazelcast, 2022) (Alexander S. Gillis, Technical Writer and Editor, 2019) (Talend, 2022)

What are the advantages and disadvantages of using the DaaS approach?

Database-as-a-service is a fully programmable database system offers many advantages, it also creates special challenges.

Advantages:

• Ability to move data easily from one cloud platform to another.
• DaaS System setup time is very Minimal. Organizations can begin storing and processing data is very fast using a DaaS solution.
• DaaS Cloud platform is less likely to fail, cloud system making DaaS workloads less prone to downtime or disruptions.
• DaaS is more scalable and flexible than the other alternative.
• Cost savings: Data management and processing costs are easier to reduce with a DaaS solution. Companies can allocate just the mi of resources to their data workloads in the cloud and increase or decrease those allocations as needs change.
• DaaS platforms tools and services are automatically managed and kept up-to-date by the DaaS provider, eliminating the need for end-users to manage the tools themselves.
• When using a DaaS platform, organizations do not need expert staff to manage this database. Databases can be managed themselves. These tasks are handled by the DaaS provider and secure 24/7.

Disadvantages

• Disadvantages to DaaS include concerns with privacy, security and data governance.
• DaaS requires users to move data into cloud platform and transfer data over the network, it can create security risks that would not exist if data remained on local, behind-the-firewall platform. These challenges can be mitigated using encryption for data in transit period.
• When users using DaaS platform to transferring large volumes of data it can take time due to network bandwidth limitations. Depending on how frequently user needs to move data into a DaaS platform, this may or may not pose a serious challenge. (Talend, 2020) (Alexander S. Gillis, 2019)

 What is big data? Identify three characteristics associated with big data.

Big Data is describes of data that is huge in volume, yet growing gradually with time. It is a data with so large size, velocity, and variety information assets that demand cost-effective and complexity that none of traditional data management tools can store it or process it efficiently. In words, Big data is also a data but with huge size, high-volume, velocity, and variety information.

Three characteristics define Big Data there is volume, variety, and velocity. Together, these three characteristics define “Big Data”.

1) Variety

Variety of Big Data refers to the types of data which is structured, unstructured, and semi structured data that is gathered from multiple sources. While in the recent past, data could only be collected from spreadsheets and databases. Now data can be collected from many sources. There are various types of data. Today data comes in an array of forms such as photos, emails, videos, audios, PDFs, SM posts, and so much more. Variety is one of the most essential characteristics of big data.

2) Velocity

The term ‘Velocity’ essentially refers to the processing speed at which data is being created in real-time. Simultaneously, Velocity comprises the rate of change, linking of incoming data sets at varying speeds, and activity bursts.

Big Data Velocity works with the speed at which data flows in from sources like business processes, application logs, networks, and social media platforms, sensors, Mobile devices, etc. The flow of data is huge and continuous.

3) Volume

Volume is one of the significant characteristics of big data. We already informed that Big Data refers huge ‘volumes’ of data that is being generated on a daily basis from various sources like social media platforms, business platforms, machines, networks, human interactions, etc. Such a large amount of data are stored in data infrastructures. In this way, comes to the end of characteristics of big data. (Abhinav Rai, 2020) (Taylor, 2022)

What is a data warehouse, and how is it different from a Traditional database used to support OLTP?

What is a data warehouse?

A data warehouse is a type of data management system that gathers or collect data from different sources into central repository or in words, we can say that it is a complete and consistent store of data that obtained from different sources. It is an influential database model that enhances user ability to analyze massive multidimensional data sets to allow user to make a business decision based on facts and for tracking quick and effective decisions or providing necessary data information. Data warehouses are exclusively intended to perform queries and analysis and often contain big amounts of historical data. The data within a data warehouse is usually derived from a massive range of sources such as application log files and transaction applications. (Oracle, 2022) (Ginni, 2021) (ayushjoshi599, 2022)

How is it different from a Traditional database used to support OLTP?

Here are mainstream key differences between Traditional databases and Data Warehouse:

What is a data lake, and how is it different from a data warehouse?

A data lake is a centralized repository designed to store, process, and secure large amounts of structured, unstructured, and semistructured data that is gathered from multiple sources. It can store data in its granular format and process any variety of it, ignoring size limits.

 Here are main key differences between Data Lake and Data Warehouse:

(Talend Website, 2022) (Amazon Web Services, 2022) (Bismart, 2022) (Datacamp , 2022) (Google Cloud, 2022)

References

Abhinav Rai, D. A. (2020, May 06). Upgrad: Blog. Retrieved from upGrad Education Private Limited Web Site: https://www.upgrad.com/blog/what-is-big-data-types-characteristics-benefits-and-examples/

Alexander S. Gillis, T. W. (2019, May 10). Techtarget. Retrieved from https://www.techtarget.com/: https://www.techtarget.com/searchdatamanagement/definition/data-as-a-service

Alexander S. Gillis, Technical Writer and Editor. (2019, May 10). Data management: techtarget.com. Retrieved from https://www.techtarget.com/: https://www.techtarget.com/searchdatamanagement/definition/data-as-a-service

Amazon Web Services. (2022). Big Data: Amazon. Retrieved from Amazon Web Services: https://aws.amazon.com/big-data/datalakes-and-analytics/what-is-a-data-lake/

ayushjoshi599, C. w. (2022, July 08). Geeksforgeeks. Retrieved from Geeksforgeeks Web Site: https://www.geeksforgeeks.org/difference-between-data-warehousing-and-online-transaction-processing-oltp/

Bismart. (2022). Blog: Bismart. Retrieved from bismart.com Web Site:
https://blog.bismart.com/en/what-is-the-difference-between-a-data-lake-and-a-data-warehouse

Datacamp . (2022). Data engineering: Datacamp . Retrieved from Datacamp.com Web Site: https://www.datacamp.com/blog/data-lakes-vs-data-warehouses

Ginni. (2021, November 2021). Post: tutorialspoint. Retrieved from Tutorialspoint web Site: https://www.tutorialspoint.com/difference-between-a-data-warehouse-database-and-an-oltp-database

Google Cloud. (2022). Learn: Google Cloud. Retrieved from cloud.google.com Web Site: https://cloud.google.com/learn/what-is-a-data-lake

Hazelcast. (2022). hazelcast. Retrieved March 17, 2022, from hazelcast.com/glossary: https://hazelcast.com/glossary/data-as-a-service/

Oracle. (2022). Database: oracle. Retrieved from Oracle Web Site:
https://www.oracle.com/database/what-is-a-data-warehouse/

Oracle Database. (2022). oracle.com/database. Retrieved March 17, 2022, from
https://www.oracle.com/
https://www.oracle.com/database/what-is-database/#:~:text=A%20database%20is%20an%20organized,database%20management%20system%20(DBMS).

Peterson, R. (2022, January 27). guru99.com/introduction-to-database-sql. Retrieved March 17, 2022, from https://www.guru99.com/ https://www.guru99.com/introduction-to-database-sql.html

Talend. (2020). www.talend.com/resources. Retrieved from https://www.talend.com/: https://www.talend.com/resources/what-is-data-as-a-service/

Talend. (2022). www.talend.com/resources. Retrieved from https://www.talend.com/  https://www.talend.com/resources/what-is-data-as-a-service/

Talend Website. (2022). Resources: Talend . Retrieved from www.talend.com Web Site: https://www.talend.com/resources/what-is-data-lake/

Taylor, D. (2022, January 22). Post: guru99. Retrieved from Guru99 Web Site:
https://www.guru99.com/what-is-big-data.html

Techopedia. (2017, June 20). techopedia.com/definition. Retrieved March 17, 2022, from https://www.techopedia.com/ https://www.techopedia.com/definition/1200/entity-relationship-diagram-erd

Techopedia. (2020, AUgust 07). techopedia.com/definition. Retrieved March 2022, 2022, from https://www.techopedia.com/ https://www.techopedia.com/definition/24361/database-management-systems-dbms

Read more: Scholarly articles for Questionnaires of Information Technology