Saturday, May 25, 2019

Data Base Management

Data BaseIt is the collection of entropy regarding an individual, group of people working together, a department in an formation or an organic law.1Types of Data BaseDepending on the number of people, database is classified into 4 types.1. Personal Database It is for an individual or single user.2. Workgroup Database If the employees number is in between 10-15 people.3. segment Database It is for 15-50 employees.4. Enterprise Database If the no of employees is more than 50 people.Database ModelA Database Model is a visual plan for building a database. It focuses on representing the data as the user actuall(a)y sees it, bridging between the concepts that make up real-world events.Raw DataThis is the process in which, raw data is collected and is converted into information which is the filtered raw data. Then, the information is exposit in the proper form called as the meta data which is the data description and this data is collected to form a database. So, database is the organi zed collection of related data.Data expositionOne very important role of a database management system is to maintain the data definitions for each table and columns in the database. Each piece of data must be assigned a name, a data type (e.g. date, alphanumeric, numeric) and a mandatory/optional status.2ArchitectureThere are three levels in the programme architecture of the database.1. User design It can be used by any no of users. It is operational database.2. Logical design It is the licit structure of database. It is regardless of the hardware or other things. It concerns only with logical structure.3. Physical design It concerns with the hardware indispensablenesss of the data base. It is not related to either the user or the logical structure.There are different types of DBMS products relational, network and hierarchical etc but the most commonly used database management system by most of the commercial organization is the Relational Database Management Systems (RDBMS).D ata Structures Data structures (fields, records, files and objects) optimized to deal with very large amounts of data stored on a permanent data storage device (which implies relatively slow access compared to volatile main memory).Database ProjectThe database project would be developed in different stages like1. Initiation which includes the gathering and defining the data and their types.2. Planning of the requirement and how to generate the required outputs.3. Design which includes two parts1. Physical Design Gathering the hardware requirements.2. Logical Design Designing the logical structure of database.4. Implementation in which we provide the required data to the database.5. Maintenance It includes the proper co-ordination of the input and the requirement.MaintenanceThe database project will be maintained using a repository server which provides all the required data and logical functions that are used in the project.DeployIt is a process of delivery of the output obtained i n the project to the client who sends the feed patronise depending on the report he receives.ReferencesEncyclopediaData base management systems, Retrieved 1206, 17 December 2007.https//en.wikipedia.org/wiki/DatabaseBookRobert V.Henry, Data Base Management System.Internet blog1. info Technology Toolbox, Inc. (1998-2007)2. Database Management systems.1 EncyclopediaData base management systems, Retrieved 1206, 17 December 2007.https//en.wikipedia.org/wiki/Database 2 Information Technology Toolbox, Inc. (1998-2007)http//database.ittoolbox.com/

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.