Thursday, July 18, 2019

Data Base Management

Data BaseIt is the army of data regarding an individual, group of people operative together, a department in an scheme or an organization.1Types of Data BaseDepending on the sum of people, data infantry is classified into 4 types.1. individualised Database It is for an individual or single user.2. Workgroup Database If the employees number is in between 10-15 people.3. Department Database It is for 15-50 employees.4. try Database If the no of employees is more than 50 people.Database object lessonA Database Model is a opthalmic plan for building a database. It focuses on representing the data as the user in reality sees it, bridging between the concepts that make up real-world events.Raw DataThis is the functioning in which, raw data is sedate and is converted into instruction which is the filtered raw data. Then, the in nervous straination is described in the proper form called as the meta data which is the data translation and this data is collected to form a database. So, database is the organized collection of associate data.Data definitionOne really important radiation pattern of a database management system is to proceed the data definitions for each table and columns in the database. Each piece of data moldiness be assigned a name, a data type (e.g. date, alphanumeric, numeric) and a obligatory/optional status.2ArchitectureThere are tercet levels in the design architecture of the database.1. drug user design It can be apply by any no of users. It is practicable database.2. Logical design It is the analytical expression of database. It is irrespective of the hardware or another(prenominal) things. It concerns only with logical structure.3. Physical design It concerns with the hardware requirements of the data base. It is not related to either the user or the logical structure.There are different types of DBMS products relational, entanglement and hierarchical etc but the most ordinarily employ database management system by mo st of the commercial organization is the relational Database Management Systems (RDBMS).Data Structures Data structures (fields, records, files and objects) optimized to deal with very large amounts of data stored on a permanent data storage thingummy (which implies relatively slow access compared to inconstant main memory).Database ProjectThe database project would be developed in different stages like1. origin which includes the gathering and defining the data and their types.2. cooking of the requirement and how to generate the take outputs.3. image which includes two parts1. Physical Design accumulation the hardware requirements.2. Logical Design scheming the logical structure of database.4. Implementation in which we provide the required data to the database.5. guardianship It includes the proper co-ordination of the input and the requirement.MaintenanceThe database project go forth be maintained using a repository server which provides all the required data and logic al functions that are used in the project.DeployIt is a process of bringing of the output obtained in the project to the guest who sends the feed back depending on the bailiwick he receives.References encyclopaediaData base management systems, Retrieved 1206, 17 declination 2007.https//en.wikipedia.org/wiki/DatabaseBookRobert V.Henry, Data Base Management System.Internet blog1. Information engineering science 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.