Wednesday 6 November 2013

MBA All Subject notes, Data vs Information,DBMS Solved Assignment

Data vs Information

Data is data and statistics collected in raw form for reference or analysis of data, while the information is processed . There are certain terms of the English language we take for granted and used interchangeably without knowing the correct use of these words. Two of these terms are the data and information used in daily life and replace it with the others as we please . However, no significant difference between the two words that requires clarity , even for those whose mother tongue is English.

data
Data are presented raw data for later use . This can be present in a disorganized way that may not make sense at all to organized properly. When researchers conduct surveys , get answers to your questions through tools such as questionnaires . These questionnaires in most current times have choices like "a" , " b", " c" , etc. when these scripts are compiled together are meaningless by themselves until they start referring to certain situations , responses and conditions. In computer jargon , the data are basically symbols or signals that are passed as command . What that translates the information is organized . Data on its own may be of no use until properly organized . information
Information is processed data becomes useful for someone as raw data alone does not provide the type of information that can be used for charitable purposes . The information is meaningful, relevant and helps the user to develop an understanding of the data they provide no consistency or certainty in what it represented. When the input data and then researchers are correlations between the data and variables have , which provides certain relationships between variables are known as information. Difference between data and information , with any head of research , information is the most basic form of input that a researcher has no meaning. Need some data that can be arranged, while others need to be met with different variables to show the consistency of the results. Data can be both qualitative and quantitative when arranged provides the user with information that can be used to gain knowledge or can act as a food for thought. In computer jargon , data is written to the computer is present as binary form when gives an output is provided for the user that is of importance to the user. Therefore, a product called as information.
Data vs Information
Data is data and statistics collected in raw form for reference or analysis of data, while the information is processed . There are certain terms of the English language we take for granted and used interchangeably without knowing the correct use of these words. Two of these terms are the data and information used in daily life and replace it with the others as we please . However, no significant difference between the two words that requires clarity , even for those whose mother tongue is English.
data
Data are presented raw data for later use . This can be present in a disorganized way that may not make sense at all to organized properly. When researchers conduct surveys , get answers to your questions through tools such as questionnaires . These questionnaires in most current times have choices like "a" , " b", " c" , etc. when these scripts are compiled together are meaningless by themselves until they start referring to certain situations , responses and conditions. In computer jargon , the data are basically symbols or signals that are passed as command . What that translates the information is organized . Data on its own may be of no use until properly organized .
information
Information is processed data becomes useful for someone as raw data alone does not provide the type of information that can be used for charitable purposes . The information is meaningful, relevant and helps the user to develop an understanding of the data they provide no consistency or certainty in what it represented. When the input data and then researchers are correlations between the data and variables have , which provides certain relationships between variables are known as information.
Difference between data and information
At the start of any research data is the most basic form of input that a researcher has no meaning. Need some data that can be arranged, while others need to be met with different variables to show the consistency of the results. Data can be both qualitative and quantitative when arranged provides the user with information that can be used to gain knowledge or can act as a food for thought. In computer jargon , data is written to the computer is present as binary form when gives an output is provided for the user that is of importance to the user. Therefore, a product called as information.
database
A database is an organized collection of data for one or more purposes, usually in digital form . The data are typically organized to model relevant aspects of reality ( for example, the availability of rooms in hotels) , in a way that supports processes requiring this information (for example , finding a hotel with vacancies ) . The term " database" refers both to the way users view, and to the logical and physical materialization of the data , the content of computer files , memory and data storage . This definition is very general, and is independent of the technology used. However, not all data collection is a database, the database data term implies that achieved a certain level of quality (measured in terms of accuracy, availability , ease of use, and resilience ) and this in turn often entails the use of a generally - purpose database management system (DBMS ) . A general purpose DBMS is typically a complex software system that meets many usage requirements , and maintaining databases are often large and complex.
Examples of types of databases are examples of different types of DB . Most of them have received special attention because of the requirements of end users . Some of the types of functionality provided is incorporated (some part) in the existing DBMS .
Database triggers an active database is a database that includes an event-driven architecture that can respond to conditions both inside and outside the database. Possible uses include security monitoring , alerting, statistics gathering and authorization. Relational databases modern features include active database as shot database .
Analysts analytical database can do their work directly against a data warehouse or create a separate analytic database for Online Analytical Processing ( OLAP ) . For example , a company can obtain sales records for analyzing the effectiveness of advertising and other sales promotions at an aggregate level .
Data Warehouse Data Warehouse data files operational databases and often from external sources such as market research firms . Often operational data undergoes transformation on its way to the warehouse, getting summarized, anonymous , reclassified , etc. The warehouse becomes the main source of data for use by managers and other end users who can not access operational data . For example , sales data might be aggregated to weekly totals and converted from internal product codes to use UPC codes so that it can be compared to data from Nielsen . Some basic components and data storage essential include the recovery , analysis and data mining , processing, and data management load so that it is available for subsequent use . Operations in a data warehouse are typically concerned with greater data manipulation , and as such, is unusual and inefficient to target individual rows for update , insert or delete . Bulk native loaders for data input and passes the SQL greater aggregation are the norm. distributed database
The definition of a distributed database is large , and can be used in various meanings. Usually refers to the spatial distribution of a database , and possibly on the DBMS computers and sometimes over the different sites. Examples include databases of working groups and local departments of regional offices , offices , factories and other workplaces . These databases can include segments of both common operational database and common user as well as data generated and used only at a user's own site .
Oriented database documents
Used to conveniently store , manage, edit and retrieve documents .
Database of end user
These databases are the data developed by individual end users . Examples of these are collections of documents in spreadsheets , word processing and downloaded files .
external database
These databases contain data collected for use across multiple organizations , either freely or via subscription . Internet Movie Database is one example.
graphic database
A graph database is a kind of NoSQL database that uses graph structures with nodes , edges , and properties to represent and store information. General databases of graphs that can store any graph are distinct from databases as triplestores specialized graphics and databases on the network. hypermedia databases
The World Wide Web can be viewed as a database , although spread across millions of independent computing systems . Web browsers "process" this page of data at a time , while web crawlers and other programs are the equivalent of database indexes to support search and other activities. In memory database in a database memory (DVD , also the database in the main memory or MMDB ) is a database that resides mainly in the main memory , but typically backed nonvolatile storage computer data . Databases in main memory is faster than disk databases . Accessing data in memory reduces the activity of read I / S where, for example , query the data. In applications where response time is critical, such as telecommunications network equipment , often used databases of main memory.
operational database
These databases store detailed information about the operations of an organization. They are usually organized by topic , process relatively high volumes of updates using transactions. Essentially every major organization on earth uses databases. Examples include customer databases that record contact , credit , and demographic information about customers of a business , databases containing personal information , such as salary , benefits , skills data about employees, enterprise resource planning that record details about product components , parts inventory , and financial databases that keep track of the organization's money , accounting and financial transactions.
Parallel database
Database realtime
spatial database
temporary database
relational database
The relational databases such as MySQL , Microsoft SQL Server and Oracle , have a much more logical in the way data is stored . Tables can be used to represent real-world objects , with each field that acts as an attribute. For example , a table called books could have the column title , author and ISBN , which describe the details of each book where each row of the table is a new book. The "relationship" comes from the fact that the tables can be linked together, for example, the author of a book might be a cross reference to the authors table ( assuming there was one) to provide more information about the author. Such relationships can be quite complex in nature, and it would be difficult to replicate in the standard flat file format One of the main advantages of the relational model is that if a database is designed efficiently, there should be no duplicating the data , helping to maintain the integrity of the database. This can also mean big savings in file size, which is important when dealing with large volumes of data. Having said that , joining large tables together to obtain the necessary data for a query can be very heavy on the processor , so that in some cases, especially when the data is read-only , it can be beneficial to have some duplicate data one relational databases database.Relational also have functions " built in " to help them recover , sort and edit data in many different ways . These functions save script designers having to worry about filtering the results obtained , so you can go pretty far to accelerate the development and production of web applications .
Question # 1 . Part B
Advantages in the database approach advantages in the approach to the database are:
• The three directors are using the same database, so any report with the information will not be inconsistent.All the three administrators can view the database according to your needs.
• application systems can be developed independently of the database.
• Data validation and updating will be one and the same for all
• Information is shared by all users.
• Data security and privacy can be managed and secured because data entry in the database occurs once and is protected by security measures .
• Since the database is information storing structured queries can be answered quickly by using the logic of the data structures .
• Reduction of data redundancy
• Reduced errors and increased consistency update
• The integrity and independence of application programs data
• Improve access to user data through the use of host and query languages
• Improved data security
• Reduction of data entry, storage and retrieval costs
• Facilitation of the development of new applications program
Question # 1 of Part C
What are the main components of database environment
human
Data administrators - the role of database administrators is the management or have direct control of the database . The developers of the system - this is the people who are responsible for the development of computer applications break data into smaller steps and computer codes transfer to a more convenient and understandable to end users. End users - users of the system / application.
machine
User Interface - This is the design or the way that the software application will appear . It's a much easier and understandable for end users interact and to implement the system. Application Programs - This is the heart and mind of the computer application of the organization. It employs users of the application the task is to do with the system .
database
Repository - centralized knowledge base containing all data from the screen and report format definitions and the definitions of other organizations and system components . Management System Database - commercial software system used to create, maintain and provide controlled access to the repository database . Database - A collection of logically related data to meet the information needs of multiple users in an organization .

Share

& Comment

0 comments:

Post a Comment

 

Copyright © 2015 Latest updates™ is a registered trademark.

Designed by Templateism. Hosted on Blogger Platform.