Accessing Persistent Data In A Relational Database

2345 words - 9 pages

Most applications will need to access persistent data at some point, which may reside in relational databases, flat files, mainframe systems, LDAP repositories, or be provided by services through external systems. When business components need to access a data source, they need to use the appropriate mechanism to achieve connectivity and manipulate the stored data. Mechanisms to access these different types of persistent storage differ greatly, often incorporating proprietary APIs; access mechanisms for different data sources rarely have much in common. For example, accessing a relational database in Java requires using the JDBC API – this API cannot be used in many circumstances other than accessing a relational database.
Usage of these different access mechanisms can potentially create a direct dependency between business logic and data access code. If a business module relies on the internal workings or implementation of a data access module, or if the business module directly includes some aspects of the connectivity and data access code, a tight coupling is created between the business and data logic, directly affecting the portability of each.
The following diagram illustrates the structure of a typical application which accesses persistent data stored in a relational database. The data logic and JDBC API are embedded to some degree within the business logic, tightly coupling the two layers together.

Figure 1 - Typical Application Structure
Tight coupling between modules will produce a number of difficulties and issues:
• Changes in one module will potentially force a ripple of changes in the other module
• Modules will be more difficult to understand in isolation
• Modules will be difficult to reuse or test because all dependent modules must be included
With specific regard to a tight coupling between business and data logic, the code dependency will also make it difficult and tedious to migrate the application from one type of data source to another. If the data source changes, the business components will also need to be changed to handle the new data source. 
Industry Design Patterns
Design patterns are general, repeatable solutions to commonly occurring development and design issues. Usage of design patterns helps to prevent issues that can cause major problems, improves code readability for developers familiar with the patterns, and speeds development and design processes by using proven solutions rather than creating a possibly flawed custom solution. Two commonly-used design patterns exist which are meant to decouple the business and data layers: the Data Access Object (DAO) and Factory patterns.
Data Access Object
A Data Access Object encapsulates all access to a persistent data store, providing a uniform API to its clients (usually business modules) as an interface. The interface only defines the general access methods that will be accessible to the clients, not the specific implementation of...

Find Another Essay On Accessing Persistent Data in a Relational Database

Big Data Analytics: A discussion of the importance of big data in today's world. - South Dakota State University/ Data Science - Essay

627 words - 3 pages , processing and analysis of data that was previously ignored. In other words, big data analytics can be understood to be the gathering, systematic processing and analysis of much more data by a business entity. There are several terms related to the big data concept. These related terms which help in the definition and further understanding of big data are the four Vs; namely, volume, variety, velocity and veracity. The main aim of the big data concept

Database: CIS/319 Prepare a 2-3 page paper analyzing the use of databases in your organization

793 words - 3 pages for viewing. Also since our factory is in China, our productivity does not come to a halt as a result of waiting. It is a great tool and has become a necessity for our company.Microsoft Excel allows you to organize and analyze data to simplify common business tasks using functions in a spreadsheet. Excel includes functions to calculate formulas, perform arithmetic functions, store and perform macros, create graphs and tables, and import data. Excel

The Importance of Data Protection in the EU: A Critical Reflection

1057 words - 5 pages situations when this data is wrongfully entered in the database that might have serious consequences when the information is used in another data base or transferred to a third party. When information related to an illness is lost during the automated process, the remaining data will include limited information related to the data subject and thus prevents the subject from having the necessary medical treatment. To prevent this kind of risks, rules to standardize data processing are of outmost importance in order to prevent an inaccurate data set.

Notes from Business Data Communication Class, Local Area Network Technology. (download it is set up in a table)

2902 words - 12 pages ) guarantees for voice and video (but not necessarily for data)ATM preparation using meshes and virtual circuits to reduces switching costsComparisons between ATM and Ethernet in handling brief traffic peaksLegacy LANs Including:token -ring networks and early Ethernet standardsLARGER ETHERNET NETWORKSIn a hierarchy There is only on possible path between any two stationEthernet Requires hierarchical arrangement for its switchesLOW-COST SWITCHING

You are a researcher working on data from the EPICA ice core as described in epica.csv. You are required to write a short report that presents an analysis of the temporal trends, statistical...

659 words - 3 pages until stabilising at -405dD in 12541B.P. A slight decreasing trend then occurs from this point in the graph.Figure 2: Time series of temperature difference ( C) from today between 50022B.P. and 129B.P. Data is derived from deuterium record of EPICA Dome C Ice Core, Antarctica.The time series of temperature difference in figure 2 has a linear relationship with the graph in figure 1, since each year's temperature difference from today in this

The Factors That Affect Mathematics In A Group Of Grade Five Students In A Rural School: Design for the Collection of Data

891 words - 4 pages will use the survey method to gather data that will provide information on some factors that affect the Mathematics Performance of a Group of Grade Five students in a rural school in Clarendon.A survey is described by Creswell (2005) as a means of gathering information. The researcher through this method is provided the opportunity to administer questionnaires to a sample population, in order to acquire information. This type of research is a

Metrics that should be developed to measure the performance of a data warehouse in the following environments: 1) health care, 2) retail and 3) pharma

1525 words - 6 pages In most of the Database guide papers, eight performance-based metrics were used to communicate areas of concern to the data warehousing vendor. Also, the ninth one was developed as a weighted average measure using four of the eight metrics, which were deemed the most critical to the organization assessing data warehouse performance to determine how the vendor stacked up relative to data quality and systems quality.The nine metrics that were

Investigating the benefits of accessing to pre-school before attending primary school: A case study of Bridgeton School in Phnom Penh

651 words - 3 pages -school, they might not adapt well to the school environment. They may be cry loudly or feel depress when they leave their parents for the first school period. However, other pupils feel like making new friends and carefree if they leave their parents to school. Therefore, pre-school plays important role for pay pupil’s gratitude to gain their social develop. They stay together with other pupils. Especially, they start work in a team by sharing their

Design a Network Infrastructure Because Networks are Configured in Many Ways, Network Systems and Data Communications Analysts are Needed to Design, Test, and Evaluate Systems Such as Local Area...

8965 words - 36 pages Cover PageNetwork systems andData communicationDesign a network infrastructureBecause networks are configured in many ways, network systems and data communications analysts are needed to design, test, and evaluate systems such as local area networks (LANs), wide area networks (WANs), the Internet, intranets, and other data communications systems.The term WAN (Wide Area Network) refers to a network, which covers a large geographical area, and use

Six-Sigma: A Data-Driven Approach and Methodology for Eliminating Defects in Any Process

1791 words - 8 pages Six Sigma Methodologies: MAIC was developed, and this evolved into DMAIC, where D stands for define, M stands for measure, A stands for analyze, I stands for improve and C stands for control. Experience shows that D is the essential phase for achieving dramatic improvement quickly, and C is the most critical phase for realizing return on investment in six sigma projects. The define phase requires the implementation of many tools, and the control

Relational and Object-oriented Database Management Systems

2226 words - 9 pages Relational and Object-oriented Database Management Systems A database is a “shared collection of logically related data designed to meet the information needs of multiple users in an organization” (Hoffer 709). Databases contain data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Databases allows multiple users in an organization to easily access, manage, store, and update data when

Similar Essays

Database, Data Handling, How To Create A Database System

9426 words - 38 pages would help sort out the database and delete any old information. This will also help with the data protection act 1998.User friendly, the new system will need to be user friendly, it should be able to be run by anyone who have never used a computer before. It would also need to be a very quick system and adding a new product; new customer or making a new order will need to be done in a number of minutes.Error message's that are very user

Why Was Unemployment Such A Persistent Problem In Britain During The Inter War Years?

1995 words - 8 pages Why was unemployment such a persistent problem in Britain during the inter war years?Unemployment was an important feature after the First World War and a conditioning influence on the economy and society. The inter-war years saw Britain fail to recapture its control over markets that it had dominated once before through its staple industries and saw USA and Germany become leading international producers. Alongside misguided international and

The Gilded Age, It Earned A Reputation Of Widespread Corruption In Government And Business, As Well As Persistent Economic, Social, And Political Problems Facing The Nation

703 words - 3 pages In the years following Reconstruction, America changed from a country of farms into a nation of growing businesses, factories, and cities. Despite these changes, the decades of the Gilded Age earned a reputation of widespread corruption in government and business, as well as the failure of the era's Presidents to resolve the persistent economic, social, and political problems facing the nation.The rise of industry and business defined the period

Implementing A Data Warehouse In A Kar Dealer Network

1378 words - 6 pages data cubes (Elmasri, & Navathe, 2011). The dimensional modeling technique, which is based on the star-join schema to store data, was developed by Ralph Kimball (Hammergren & Simon, 2009) (Burkhow, 2011). Whereas a relational database design transforms the data into a normalized form, the dimensional model denormalizes the data. Denormalized data reduces the number of joins needed to store information which drastically improves read operations