Database, Data Warehouse and Mobile Internet

According to Robert Primer, the term structured data is generally applied to database while the unstructured data is applied to everything else. Mostly, the unstructured data is related to information that is not to be in column-row database and not to be stored in database. This type of data often including the text and multimedia such as email, video, audio file and photo. Nowadays, there are lots of company that use the unstructured data as it helps the company to manage their storage space including software and hardware efficiently.

(Fosdick 1995) Databases are currently in the process of integration. Standardizing data, once done predominately by large corporations, is now filtering down to medium- size and small companies. The meshing of the old and new database causes administrators to maintain two or three database products on a single network. (Wong 1995) Relational database management systems incorporate complex features and components to help with logic procedures. This requires organizations to expand the traditional approach to database management and administration.

Chapter I Define each of the following terms in your own word a) Database b) DBMS c) Metadata a) Database (Crucial Concept): A database is essentially a means of storage and retrieval of items of data. The data is usually either numerical or textual, although other data forms can be accommodated. A database is a collection of data held logically and with a purpose. Is designed and organized in such manner that it can be accessed later on for different purposes. For example we need to access our Database to update some information from it or just to extract it.

Differentiate between database management system and information retrieval system by focusing on their functionalities. Answer Database Management System A database management system (DBMS) is the main software tools of the database management approach because it controls the creation, maintenance and use of the databases of an organization and its end users. There are several functions that a DBMS performs to ensure data integrity and consistency of data in the database. There have ten function of database management system. there are data dictionary management, data storage management, data transformation and presentation, security management, multiuser access control, backup and recovery management, data integrity management, database access languages and application programming interfaces, database communication interfaces, and transaction management.

Databases are made to operate all type of informations by storing, retrieving and managing that informations. Databases are made so that user can interact with databases itself. DBMS is usually responsible for mainting all the data in a system and if that data lost then DBMS will restore the data itself. Databases are used for business operations but increasing number of database systems are usually made for more stable interaction with the users. Some users of database applications are end users means they don’t know about any of its in processing applications they ... ... middle of paper ... ... used to speak to information in information warehouses in a manner that information could be effectively abridged utilizing online expository handling, or OLAP questions.

Abstract "Throughout your career, you will be directly or indirectly accessing a variety of databases, ranging from a simple roster of departmental employees to a fully integrated corporate database. You will probably access these databases using software called a database management system (DBMS). A DBMS consists of a group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs. A database, a DBMS, and the application programs that use the data in the database make up a database environment. Understanding basic database system concepts can enhance your ability to use the power of a computerized database system to support organizational goals and advance your career."

There are many different types of databases, different performances of databases, and different database software functions. Before we get to much into databases lets take a step back and think about what a database really is and how they are applied. A database is a software program arranged to collect hold and process information. There are quite a bit of software programs out there already that can allow you to do all this. However, what makes databases different is that once you enter information in to, the database will operate the information in ways that allow you to analyze the information.

Types of database management system is centralized and distributed. A centralized database stores all related files in one physical and distributed is has complete copies of a database or portions a database. Types of retrieval they provide for users. Many previous attempts have been made to couple Database management system and Information Retrieval systems together, either by integrating the two into a unified framework. Function of database management system can designed to manage data and information that large bodies within a company management involves both defining the structure Function of information retrieval a deals with various sources of information on the one hand and users’ requirements on the other.

All these components are interact under the web services framework to provide a seemless automated HR function. This single example simpler more cost effective integration will The concepts that underpin Web Services are not new: · The componentization of software and the encapsulation of discrete business functions as software components has a long history in object technologies. · Distributed computing has been a major goal of successive waves of client/server development. · Electronic Data Interchange (EDI) is founded on the use of a common syntax and standard messages for business transactions. · Enterprise application integration (EAI) is based on the need to optimize integration between systems by sharing data and business logic.

Comparing and Contrasting the Relational Database Model and OO Model The relational database model is based upon tables or relations. In this model, the physical implementation of the database is abstracted away from the user. Users query the database using a high-level query language, such as SQL. The relations are made up of columns, which have headings indicating the attribute represented by that column. Tables have key fields, which can be used to identify unique records.