Relational Database Management System: A relational database management system is a database management system that stores the data as tables which can related to each other. The tables might be related to each other by common attributes. It consists of a set of tables or files containing data that is fitted into some particular groups. These tables have data in the forms of rows and columns. Relational databases allows the user to update delete add and access a data entry from the tables.
o The types of architecture varies in the data integration and storing process and the way data warehouse and data marts are related. o In centralised data warehouse architecture, a centralised data warehouse exists. No dependent or independen data marts are there in this type of
Store data is usually organized into fields, records, files and databases. 3. Retrieval of information. MIS retrieves information from its stores as and when required by various users. According to the requirement of the management of users, the retrieved information is spread or rework to meet the specific requirements.
III. DISTRIBUTED DATABASE DESIGN Distributed Database Systems are needed for the applications where data and its accesses are inherently distributed and to increase the availability during failures. However, some additional factors have been considered for a Distributed Database: A. Data Fragmentation: In Distributed Databases, we need to specify and understand the logical unit of Database Distribution and allocation. The database may be broken up into logical units called fragments which will be stored at various sites.
It includes the software that assists with making decisions and the data resources such as databases. Moreover, the hardware assets, decision support system, people management project management applications and computerized processes that make organizational units to move economically. In addition, Nader et al., (2013) state that management information system has dual parts: Ecosystem, comprising of, people, concerned with system accessibility of information, the tools and technology on hand for the system. Endosystem, includes variables that an engineer can manipulate and direct, for instance, tools, algorithms, and processes employed. Meanwhile, Jennifer (2014) defines management information system as an approach that gathers, and manipulates data (information) and gives it to administrators at all echelons who utilizes it , for decision-making, designing, programme execution and control.
Case in point, dynamic sites, bookkeeping data frameworks, finance frameworks and stock administration frameworks depend on inward databases as a compartment to store and deal with their information. Numerous product improve-ment firms today are creating and delivering DBMS frameworks that cost between zero dollars if there should arise an occurrence of free and open-source DBMSs, and a huge number of dollars in the event of exclusive DBMSs. Specifically, every DBMS is por-trayed by an arrangement of assorted utili-tarian and non-practical components and specs each having their favorable circum-stances and detriments. One of which is exe-cution which decides how quick a DBMS can process and execute inquiries. Paper displays a near study from an execution viewpoint between five distinctive DBMSs accessible today available.
This can reduce the risk of the data being loss as the database can be saved in a variety of different forms. - This type of database makes it simple for the editor to update as the data is split into separate data fields instead of multiple tables. Disadvantages: - The database doesn’t require a relational link meaning that when information is changed for one individual it will not automatically change for all the records of that individual meaning that you would have to find each record of that person and change it for all the records data collected for that person. - The database normally involves you repeatedly writing the same data which can cause many issues such as human error meaning that mistakes could be made causing records not to be presented when looking for records about a particular person. - When updating the database it can be often hard to identify any errors contained within the database as multiple records of data is contained within the database - The flat file database doesn’t prevent similar data being typed for two individuals which could cause confusion as it would bring up multiple records for multiple people with similar records making it hard to find out information about a
Now a days every organization has automated their systems of information by handling the database with personal or any type of secret information. So, with these type of crucial and sensitive data, security and privacy issues becomes necessary. Now the question arises that what is database security and how it can be achieved? Protecting the private and personal data saved in any archive is known as database security. It deals with securing the database from intruders and illegal actions.
• With In-memory processing the source database is queried only once instead of accessing the database every time a query is run thereby eliminating repetitive processing and reducing the burden on database servers. • By scheduling to populate In-memory database overnight the database servers can be used for operational purposes during peak hours. Disadvantages of In-memory BI • With increase in number of users and data volumes the amount of RAM needed also increases which in turn affects the hardware costs. Who is it for? While In-memory processing has a great potential for end users it is not the answer to everyone.