Requirements For Advanced Database Technologies Computer Science Essay

Published: Last Edited:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Due to business needs and challenges, there is a need for advanced database technologies. There will be need of clustered servers, large memory models and high compressed storage.

Although there has been great improvements on database management systems (DBMS) there remains requirements and potential for improvement and creation virtualized, structured or unstructured access to data resulting in simple data management process which is highly intelligent and automated.

There can be evolution in technology of DBMS and support of middleware which can handle information fabric by managing virtualized access to data resulting in the trends which offer evolutionary paths to a future world of data management. Resulting in easier management process of information. Increased automation means lower cost at data integration and access information.

Most of the organizations will upgrade or extend their infrastructure and system resulting in increased competition and productivity in the database market which already at matured state.

For business units like banking, insurance, telecommunication, financial services and retail industries, database is the most critical assets. Large MNC enterprises are already dedicating huge amount of IT budget for improved and secured management of data. Small and Medium Business (SMB) are also getting aware of these benefits and starting to investment in DBMS. But most of the cause is largely driven by the mandatory requirements for enterprise applications like ERP, SAP and CRM, etc.

Advanced Database Technologies in use

The industry has recognized and aware of the emergence of business intelligence and data warehousing as a major factor influencing business decisions. "Application Phase" is no longer useful for Businesses as business decisions are done purely based on the phase where application data is being used accurately and timely to enhance the effectiveness of system.

Because of the changes in customer's demand, the database systems will also have to evolved and developed. Since they are still core of transaction process; however we can estimate that there are distinct changes in focus which lead to providing databases that support superior reporting and data management performance, also data mining and data analytics are concerned. Those demands have led to the creation of new and advanced databases categories such as.

Mobile Database

A mobile database is a type of database that can be connected to by using the mobile over the mobile network 3G data communication. The wireless connection will be able to link client and server. The frequent transactions are maintained in cache so that they are not lost when there is connection failure or disruption.

There is increase in demand for the use of portable devices such as Laptops, PDAs, iPads and mobiles so in future, there will be improved development for the mobile systems. It is clear that there will be requirement of the use of a database technology which result in leading the requirement for the ability to retrieve information from data warehouses repository and operate on this information even when their location is out of range or disconnected.

In a mobile workforce, user may require the access of system and get updated information from directories on a server or personal data of specific customer within a database. With the mobile databases, users can use their portable communication mobile devices to connect databases to retrieve or exchange data without having to worry about location or time. Client can access their data by using portable computing devices and wireless communication from any location. After altering or managing the desired data, users can synchronize the updated information later time when they have access to actual database server.

[1] Mobile Database. Retrieved from Wikipedia

Current problems on Mobile Database

There are some Hardware and Software problems that must be solved to enhance the maximum potential of mobile computing.

i.e. Lack of database recovery when synchronization is not possible.

Hardware problems are more difficult.

Limitation on wireless coverage might set the area of usage narrow.

Low Battery Life might prevent the user on using the system for longer duration.

Because of the changes in network topology, communication can be lost or disrupted.

Wireless Transmission Speed may prevent the user to synchronize huge amount of data.

Mobile Computing Architecture

Mobile Ad-Hoc Network (MANET)

By using MANET, fixed network is not necessary between communications of co-located mobile units. Bluetooth technology can be used instead, resulting in formation. Normally mobile units process as both base station and client. Data routing is managed by its own unit. It should be able to handle network topology changes and robust enough to manage arrival or departure of mobile units. P2P architecture can be relevant to MANET.

[2] MANET. Retrieved from

Characteristics of Mobile Environments

Communication latency

Due to the data transfer capacity resulting latency issues in communication.

Intermittent connectivity

Due to network coverage and traffic, connectivity lost can be expected.

Limited battery life

Low duration of battery life prevent the user to have adequate usage.

Changing client location

Location of the user can be dynamic resulting in adjusting of communication.

Those are the data management impact of mobile computing.

There can be difficulties between server and client.

Proxies can be added to the client and the server to assist in cache updates when incase of difficulties in network connection.

Proxy will automatically forward the transaction updates to its distention when the connectivity is established.

There may be scalability issues due to the involvement of latency between wireless communications resulting in server unable to handle sufficient clients since it increases the time taken to serve the request of each client.

However, Broadcasting used by Servers can enhance in solving the problem.

Since it will reduces the load greatly on the server, as there is no need for maintenance of active connections to the clients.

eg. Stock update, Price Change, Weather Broadcasting, etc..

[3] Database profiles. Retrieved from

Data Management Issues

There are two possible scenarios in Mobile databases:

With the possible requirement of full or particle replication, the entire database may be distributed among the wired components.

Extra functions can be handled for management fixed hosts.

The database may be distributed among wired and wireless components.

Both fixed hosts and mobile units can handle the management.

Since Cache is used in distribution and replication of data, there can be lack of memory or cache capacity.

They are transactions oriented models

All the transaction is done by query processing without permanent storage on device

No recovery can be done on device and poor quality in fault tolerance

Small mobile database design resulting in low performance.

Services are dependent upon location

There may be extra division of labor.

Lack of security due to improper or unauthorized handling.

Application: Intermittently Synchronized Databases

The DBMS and Application is installed and configured in client's local laptop.

Updates are done locally and the server connection is only established via internet when the client require batch of updates by the process of information synchronization.

The distinct characteristic of is that the clients disconnected in most of the time and there's no need for active connection with the server..

However, there may be problems similar to those like the case of client-server based databases, and some from distributed mobile databases.

[4] Intermittently Synchronized Databases.

Retrieved from

Multimedia Database

Multimedia Information Systems are expected to dominate and influence greatly upon our daily life in the coming years ahead.

Nature of Multimedia Data and Applications

Many DBMSs already support different types of data and they are keep on updating the types of data they support.

Nowadays, there are many data types of multimedia available to store and process in latest DBMS storage which include (Graphics, Images, Animation, Video, Audio, Text, etc)

Users can stored and utilize the Multimedia data in many different ways.

Based on the characteristics of data management, applications can be categorized as

Repository applications.

Used for retrieval purposes where large quantity of multimedia data and metadata is stored.

Presentation applications.

Simple application for accessing video or audio data.

Collaborative work using multimedia information.

Engineering application which may require producing complex design task by merging drawings, fitting subjects to design constraints, and generating new documentation, change notifications, etc.

Data Management Issues

The performance of the multimedia applications dealing with huge amount of images, audio and video documents, segments of audio and video, and text data mostly depend critically on:

Proper data modeling technique to produce appropriate data structure and set the format of the content of data.

Appropriate database schemas should be designed for efficiency upon storage and multimedia information retrieval.

There is complexity which embraces set of issues in multimedia information systems:


Sometimes, dealing with large amount and varieties of data types (Graphics, Animations, etc..) can be very complex


Lack of logical, physical and conceptual designs of multimedia has not been addressed properly still remains as an area of improvement.


If the storage is a normal standard disk, there may be problems of compression, representation, map hierarchies, archiving and buffering of data when there's input or output operation performing.

Binary Large Object (BOLB Type) is handled by DBMS.

Multimedia information systems are very complex and embrace a large set of issues

Complexity on retrieval of information by queries because the way database retrieve information is purely based on index structures and structured query languages.

Performance constraints are determined by user which involve documents and text.

Physical limitations are most dominant when video playback or audio-video synchronization is done by the application.

Multimedia Database Applications

Records management and document storage.

Knowledge dissemination

Training and Education (Virtualized)

Entertainment, advertising, retail, marketing and travel

Real-time control and monitoring