According to William Inmon, data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data in support of the management’s decision-making process. Data warehouse is a database containing data that usually represents the business history of an organization. This historical data is used for analysis that supports business decisions at many levels, from strategic planning to performance evaluation of a discrete organizational unit. It provides an effective integration of operational databases into an environment that enables strategic use of data. These technologies include relational and MDDB management systems, client/server architecture, meta-data modelling and repositories, graphical user interface and much more. The emergence of cross discipline domain such as knowledge management in finance, health and e-commerce have proved that vast amount of data need to be analyzed. The evolution of data in data warehouse can provide multiple dataset dimensions to solve various problems. Thus, critical decision making process of this dataset Continue reading
Data Management
What Is Big Data?
Around the late 1990s the term “Big Data”, was launched at the Silicon Graphics Inc although it did not become a massive buzz word until 2011. Big Data can be defined as a term, used to described the huge datasets, which consist of both structured and non-structured data. These data sets can be very complex, however with techniques and various types of tools, this can enable the collecting, storage, cleansing, extract of the data to be analyzed. The analyzed data can offer great benefits to various types of industry. There is a massive market for companies for all types of industries to know what people want. For example, the television company might what to know what types of programs people like to watch? This means the company could stream the data from a live feed such as Facebook or twitter. As the internet, has grown people are now communicating at Continue reading
Database Management System (DBMS) – Components, Advantages, and Disadvantages
A Database management system (DBMS) is software designed to manage and maintain large quantities of data. The DBMS serves as the mediator between the user and the database. The database structure itself is stored as a collection of files. The data in these files can only be accessed through the DBMS. A single, integrated view of the data in the database is shown to the user by the DBMS. All application requests received by the DBMS are translated into complex operations required to fulfill these requests. The database’s internal complexity is hidden by the DBMS from the application programs and users. The application program might be written by a computer programmer using a programming language, such as Visual Basic, NET, Java, or C#, or it might be created through a DBMS utility program. Components of a Database Management System A data definition language (DDL) allows users to define the database. Continue reading
Database Security Threats and Countermeasures
Information is very critical asset. Organizations create so much information and they use database systems to handle the information within them to automate various functions. Due to information importance, information protection is a critical component of the database management system. Information security is the goal of a database management system (DBMS), also called database security. To be able to manage a huge amount of data effectively and fast, a well organized system is needed to build. It will also need to store and retrieve data easily. Generally, a database system is designed to be used by many users simultaneously for the specific collections of data. Databases are classified based on their types of collections, such as images, numeric, bibliographic or full-text. Digitized databases are created by using management system to make, store, maintain or search the data. Oracle, MS SQL and Sybase servers are mostly used in companies, agencies and Continue reading
Data Mining – Meaning, Steps and Business Applications
Data mining or knowledge discovery is the process of analyzing data from different perspectives & summarizing it into useful information. This information can be used to increase revenue & cut cost or both. We know that data mining software is one of a number of analytical tools for analyzing data. It allows users to analyze data from many angels & categories it. It also summarizes the relationship identified. Technically speaking data mining is the process of correlations among dozens of fields in large relational database. In other words it is the process of sorting through large amount of data & picking out important information. It is often use by business intelligence organizations & financial analysts. It is also used in the sciences to extract information from the data set generated by modern experiment & observational methods. Data mining in relation to Enterprise Resource Planning(ERP) is the statistical & logical Continue reading
What Is Data Strategy?
Data Strategy defines a set of choices and actions that, together, define a high-level course of action to achieve high-level goals. It involves business plans to use knowledge to a competitive advantage to support business objectives. A Data Strategy requires an understanding of the data needs inherent in the Business Strategy. Like many other terms, “data strategy” has several synonyms in data management. They include but are not limited to business data strategy, business data management strategy, information management strategy, business information management strategy, information strategic plan. All these terms refer to the same concept of a single, enterprise plan for the use of organizational data as an essential asset for strategic and operational decision-making. A data strategy defines the approach that the enterprise will take to manage and use its data and information to achieve its business and technology goals and to realize a competitive advantage using this asset. The Continue reading