Free Essay

Archiving Complex Relational Data

In: Business and Management

Submitted By member222
Words 420
Pages 2
Executive summary
Continued database growth, long-term data retention regula- tions and storage requirements are increasing operational costs. As a result, more CIOs are examining the potential ben- efits of implementing cost-effective strategies for managing data and information throughout its life cycle. Because most of the historical data stored in high-performance application databases is inactive, more companies are realizing the value of database archiving as an essential component in an effective data management strategy.
Allowing application data growth to continue can degrade performance, limit availability, increase costs and slow disaster recovery. Yet, archiving complex relational data poses many challenges. Organizations need the capability to archive historical data and safely remove it from the production environment. They also need capabilities to store archives cost-effectively, retain access and dispose of data appropriately to comply with data retention regulations. In short, organiza- tions need an effective archiving strategy for managing application data throughout its life cycle.
In searching for the ideal archiving solution, some organiza- tions consider in-house development, but soon realize that the short- and long-term costs do not offset the expected return on investment. Implementing an off-the-shelf archiving solution does offer advantages in faster acquisition and imple- mentation. However, the ideal solution must provide the archiving capabilities needed to support current and future data management requirements across often heterogeneous application environments.
This white paper explains how the IBM
®
InfoSphere™
Optim™ Data Growth Solution provides comprehensive technology and capabilities that make archiving complex rela- tional data both practical and desirable. Archives can be easily managed and stored on the most cost-effective media, and his- torical data remains accessible until retention periods expire.
Maintaining only current active data in production environ- ments helps improve service levels, increase availability and improve disaster recovery initiatives. Archiving also helps organizations to reclaim valuable capacity and lower costs.
The InfoSphere Optim Data Growth Solution addresses a critical operational need for enterprises that rely on large complex relational databases.
Database growth: Impact and opportunity
Industry analysts and leading computing publications report that the rapid accumulation of data worldwide continues at an unprecedented rate. Forrester Research, Inc. estimates that on average, data repositories for large applications grow by
50 percent annually.
1
Enterprise databases are doubling and even tripling in size and exceeding projected estimates, result- ing in serious consequences.
Accumulating more data means degraded performance and slower response time. Availability is limited because routine database maintenance requires more processing time, often taking systems out of service. Managing larger databases also…...

Similar Documents

Premium Essay

Relational Algebra

...The relational algebra is a theoretical language with operations that work on one or more relations to define another relation without changing the original relation. Thus, both the operands and the results are relations; hence the output from one operation can become the input to another operation. This allows expressions to be nested in the relational algebra. This property is called closure. Relational algebra is an abstract language, which means that the queries formulated in relational algebra are not intended to be executed on a computer. Relational algebra consists of group of relational operators that can be used to manipulate relations to obtain a desired result. Knowledge about relational algebra allows us to understand query execution and optimization in relational database management system. Role of Relational Algebra in DBMS Knowledge about relational algebra allows us to understand query execution and optimization in relational database management system. The role of relational algebra in DBMS is shown in Fig. 3.1. From the figure it is evident that when a SQL query has to be converted into an executable code, first it has to be parsed to a valid relational algebraic expression, then there should be a proper query execution plan to speed up the data retrieval. The query execution plan is given by query optimizer. Relational Algebra Operations Operations in relational algebra can be broadly classified into set operation and database......

Words: 344 - Pages: 2

Free Essay

Advantages of a Relational Database

...Advantages of a Relational database Relational databases are the standard when creating industrial standard efficient and scalable databases. They are based on a structure of tables which are logically connected to each other and can be queried in complex way to extract relevant and meaningful information. The querying of a relational database is done using a high level language called SQL which stands for structured query language. SQL is very easy to understand and unlike traditional programming languages does not rely on arcane syntax, rather structured query language uses English like meaningful syntax in its operations. As opposed to flat file databases this logical organization of data across tables in the form of columns greatly simplifies the organization and retrieval of highly complex data. As the business needs of the client rises so will the size and complexity of data, on of the biggest advantages of relational databases is the scalability associated with them, so as the company grows expanding the database will not be a problem and making sense of the data and extracting meaningful information from it will only get slightly harder. Relational databases come with a plethora of security options and views can be enforced to ensure that unauthorized access to the sensitive information in the database is not allowed. Relational databases also avoid redundancy of information and such databases can be highly optimized by methods such as normalization and good......

Words: 652 - Pages: 3

Premium Essay

Relational Databases

...Relational Database: Design This paper evaluates four similar web databases and concludes with an overview of considerations for designing web databases. The web databases reviewed are: (a) the Academy of Motion Pictures and Arts (Academy, 2013), (b) IMDb (IMDb, 2013), (c) Complete Index to World Film (Complete Index, 2013), and (d) Labor Film Database (Labor Film, 2013). Table 1 summarizes each database in terms of purpose, target audience, functions, and usability. Table 1 Summary of Web Database Reviews Academy IMDb CITWF Labor Films Purpose • Digital artifact preservation for movie industry • Movie industry research • Search vast amounts of information on just about any film, game or actor • Search fair amount of information on just about any film in the world • Educate • Research Audience • Journalists • Filmmakers • Students • Hobbyists • General public • Film buffs • Journalists • Hobbyists • Gamers • Students • Researchers • Film buffs • Hobbyists • Researchers • Activists • General public Functions • Basic and advanced searches • Six advanced query functions using: fill-in-the-box, check-a-square, and pre-filled drop-down database values • Collects information in user-defined lists. • Watch lists • Simple Search: user selects film or person from a drop-down box and enters a search phrase • Advanced Search: user builds multiple-condition • One-size-fits-all search via a drop-down box of extensive search categories • On-demand......

Words: 2130 - Pages: 9

Premium Essay

Relational Algebra

...For Evaluation Only. Computer Science Volume 1 Silberschatz−Korth−Sudarshan • Database System Concepts, Fourth Edition Front Matter 1 1 11 11 35 35 36 87 140 140 141 194 229 260 307 307 308 337 363 393 393 394 446 494 529 563 563 564 590 637 Preface 1. Introduction Text I. Data Models Introduction 2. Entity−Relationship Model 3. Relational Model II. Relational Databases Introduction 4. SQL 5. Other Relational Languages 6. Integrity and Security 7. Relational−Database Design III. Object−Based Databases and XML Introduction 8. Object−Oriented Databases 9. Object−Relational Databases 10. XML IV. Data Storage and Querying Introduction 11. Storage and File Structure 12. Indexing and Hashing 13. Query Processing 14. Query Optimization V. Transaction Management Introduction 15. Transactions 16. Concurrency Control 17. Recovery System iii VI. Database System Architecture 679 679 680 705 750 773 773 774 810 856 884 Introduction 18. Database System Architecture 19. Distributed Databases 20. Parallel Databases VII. Other Topics Introduction 21. Application Development and Administration 22. Advanced Querying and Information Retrieval 23. Advanced Data Types and New Applications 24. Advanced Transaction Processing iv Silberschatz−Korth−Sudarshan: Database System Concepts, Fourth Edition Front Matter Preface © The McGraw−Hill Companies, 2001 1 Preface Database management has evolved from a specialized computer......

Words: 301237 - Pages: 1205

Premium Essay

What Is Data Warehousing

...What is Data Warehousing? A data warehouse can be defined as follows: • subject oriented • integrated • time-variant • nonvolatile It is a collection of data in support of management decision-making process. Benefits of Data Warehousing Data warehousing is intended to support reporting and analysis of data. Here are the benefits as follows: • Potential High Returns on Investment • Competitive Advantage • Increased Productivity of Corporate Decision Makers Problems of Data Warehousing Here are some problems associated with developing and maintaining a data warehouse as follows: • Underestimation of Resources for Data Loading • Hidden Problems with Source Systems • Required Data not Captured • Required Data not Captured • Increased End User Demands • Data Homogenization • High Demand for Resources • Data Ownership • High Maintenance • Long Duration Projects • Complexity of Integration Data Warehouse Architecture Operational Data Store • A repository of current and integrated operational data used for analysis Load Manager • Performs all the operations associated with the extraction and loading of data into the extraction and loading of data into the warehouse Warehouse Manager • Performs all the operations associated with the management of data in the warehouse Query Manager • Performs all the operations......

Words: 843 - Pages: 4

Free Essay

Journaling and Archiving

...Journaling and Archiving Author Note This research is being submitted on September 7, 2013, for N234/CET2810C Section 01 Microsoft Exchange Server course. Journaling and Archiving Archiving is the process of moving a message from one data store to another. Usually this is a user-centric function, being done so a mail user has later access to a message not stored in their main mail file. Often, there is a 1:1 relationship between the primary mail file and the archive. Thus, each user has access to their own archive. Archiving is a kind of agreement between the e-mail and the user being supported. On one hand, the administrator frees up space on the primary server, while on the other hand the user retains access to move messages. Journaling is the process of copying a message from one data store to another. Journaling is a company-centric management technique and is done to demonstrate compliance and facilitates e-discovery. Unlike archives, typical users generally have little to do with the journaled messages. Here are some key reasons why an administrator should consider archiving and journaling: Archiving * Server Performance: Moving messages off the mail server will greatly increase its performance. Mail applications will open faster, providing a better user experience. * Efficient Search and Retrieval for Users: Depending on the archive policy you implement, your users may find that they rarely need to access the archive, but when they do, they......

Words: 543 - Pages: 3

Premium Essay

Database Records and Relational Data Worksheet

...University of Phoenix Material Database Records and Relational Data Worksheet Complete Parts A and B of this worksheet. Cite your sources. Part A: Database Records l Answer the following patient information questions using the table provided. Refer to figure 4-10 on p. 83 of Health Information Technology and Management for assistance. 1. What patient resides in California? What is the patient number? The patient that resides in California Sofia Yakaria Pallares. Her patient number is 10259. Gartee, R. (2011). 2. Who is the provider of Sofia Yakaria Pallares? What credentials does her provider have? Ruth Ann Raymond is Sofia’s provider and Ruth Ann Raymond has her MD license. Gartee, R. (2011). 3. What patient was seen on 11/05/2010? What is the patient’s date of birth? John Peters was seen on 11/05/2010 and his date of birth is 05/25/1965. Gartee, R. (2011). 4. What date and time did patient #1298 visit the doctor’s office? What is the patient’s name and date of birth? The patient had a visit to the doctor on 06/04/2011 at 17:15 or 5:15. The patient is Lucy Ann Johnson and her date of birth is 06/12/1975. Gartee, R. (2011). 5. What patient lives in 1704 N. Atlantic Ave Ontario, AZ 85320? What is its encounter number? John Peters lives at 1704 N. Atlantic Ave Ontario, AZ 85320 with and encounter number of 111218. Gartee, R. (2011). Patient Info......

Words: 994 - Pages: 4

Free Essay

E-Mail Archiving

...Data and E-mail Archiving 1 Data and E-mail Archiving: Legal Concerns Joel Zart Capella University TS5536-Ethics in Technology Data and E-mail Archiving 2 Table of Contents Abstract……………………………………………………………………………………Page 3 Introduction to the world of Archiving……………………………………………………Page 4 Laws and penalties associated with archiving……………………………………………..Page 5 My ethical and legal dilemma……………………………………………………………...Page 6 Ethical dilemmas in archiving……………………………………………………………...Page 6 Process of identifying archiving liability…………………………………………………...Page 7 The solution based on law…………………………………………………………………..Page 8 The affects…………………………………………………………………………………..Page 9 The solution………………………………………………………………………………...Page 10 Conclusion………………………………………………………………………………….Page 11 References………………………………………………………………………………….Page 12 Data and E-mail Archiving 3 Abstract The purpose of this is to analyze the importance of data and e-mail archiving within an enterprise organization. At my organization I am currently in the planning stages of having a fully fledged data and e-mail archiving solution in place by the end of 2009. Archiving data and e-mail within an enterprise is important for legal litigation. According to industry experts 90% of communication in business takes place through e-mail and electronic documentation such as instant messaging and word documents (2009 para.1). Companies are now required to archive all communication to not only protect the company but also their employees....

Words: 2619 - Pages: 11

Premium Essay

Relational Databases

...Relational Databases Jason A. Mizener Professor Merkel Intro to Information Technology 17 August 2014 Relational Databases As technology as grown throughout the years, so has the information it utilizes. Early on databases were organized through the hierarchical model, which was the earliest representation of the parent-child structure (each parent can have multiple children, but each child can only have one parent). Shortly thereafter the network database model was incorporated to more effectively represent complex data relationships. Large amounts of data became better organized, which improved database performance. Additionally, the parent-child structure was improved to where children could now have multiple parents. Despite these advances, databases continued to grow increasingly cumbersome and complex, and further advances were necessary to keep everything manageable. The relational database, designed in 1970 by E. F. Codd, represented a major breakthrough in database technology for both designers and users alike. The relational model is very simple, yet very effective in concept. As strange as it may be to think, the relational database pioneered the concept of using tables to hold and organize data. An Excel spreadsheet is probably the most obvious example of a relational database that the end user can relate to today. Essentially, a relational database is the logical view, rather than the physical view, of information. (Carlos Coronel,......

Words: 1200 - Pages: 5

Free Essay

Relational Database

...Relational Model of Shared Data Banks Abstract How does one decide best practice for a database management design? Who has used mathematics and science as a basis to assist organizations with a baseline relational model for database management? Well for over the last forty years credit has been given to entrepreneur Edgar F. Codd. The evolution of relational databases remain ever changing, however the foundation laid by Cobb remains best practice for the vast majority of organizations. Simple principles defined in his writing “A Relational Model of Data for Large Shared Data Banks” exhibits pros and cons in comparison to other databases. Although databases range in size, durability, and ease all plays a significant role in an organization growth, success, and failure. Relational Model of Shared Data Banks The paper “A Relational Model of Data for Large Shared Data Banks”, written by E. F. Codd explains the advantages of a relational database model primarily in comparison to the tree-structure and network model. The author points out the importance of derivability, redundancy and consistency of relations within the relational model versus other prototypes. One of Cobb’s example cites, “The network model, on the other hand, has spawned a number of confusions, not the least of which is mistaking the derivation of connection for the derivation of relations” (Cobb, 1970, p. 377). Cobb’s overall goal is to make sure readers see how effective and how successful an organization...

Words: 516 - Pages: 3

Free Essay

Importance of Relational Database

...A relational database is a collection of relations or tables. The rows of a table in a relational database are known as tuples and each column of a table is called an attribute. By definition, a relation becomes a set of tuples having the same attributes. Operations, which can be performed on the relations are select, project and join. The join operation combines the relations. The select queries are used for data retrieval, and the project operation identifies attributes. The information of the organization can be captured, manipulated, managed, and shared using relational database. The value database brings to the organization will be immense. To name few advantages of a relational database it can contribute in a huge manner to sound logical design: it is easy to understand and program, and it is amenable to change as business requirements change. The main earlier systems include file-based systems and Codasyl databases. Both systems are currently used in our company. File-based systems are complex and tended to be inherently restrictive and quickly reached the point where a complete rewrite becomes necessary if business requirements change. It is also very time consuming compare to using database. Codasyl databases are a vast improvement on the old file-based systems, but it requires high level of expertise to design properly, and just like file-based system it will be unable to support changes to business requirements. A properly designed relational database reflects......

Words: 535 - Pages: 3

Premium Essay

Relational Leadership

...million training in situational leadersip and nearly 400 out of 500 fortune company implementing this model. Fernandez, C. F. and Vecchio, R. P. Situational Leadership Theory Revisited: A Test of an Across-Jobs Perspective, Leadership Quarterly, 8(1), p. 67 1997. One of the problems with this situational model of leadership is that it assumes that a leader can ascertain the maturity level of the subordinate in relation to the task in hand. [Strunz H., Dorsch M.,2001, page 146] . This may not be possible to achieve. Other disadvantages [pic] Transformational leadership Relational leadership Relational leadership theory is a relatively new concept. It focuses more and on the relationship than on the attributes of the leader. “Leadership is always dependent on the context, but thecontext is established by the relationships we value” (Wheatley, 1992, p. 144). The common relational model focuses on 5 components. It is a process orientated model with all the four remaining components being accomplished. It is a ‘purposeful’ leadership, which is ‘inclusive’ of all the people within a given group. It is achieved through positive purpose that ‘empowers’ those involved and is done ‘ethically’. Purposeful This involves clear defined social vision that is based in a common goal. Therefore it brings positive change. This is very different from an individual leader with their own personal vision. The social vision is described by Komives as one that all......

Words: 2379 - Pages: 10

Premium Essay

Data

...Data - raw facts about things and events Information - transformed data that has value for decision making 1. Persistent - data that resides on stable storage such as a magnetic disk (does not have to be forever - can be deleted or archived when no longer needed) 2. Shared - multiple uses and multiple users 3. Interrelated - data stored as separate units can be connected to provide a whole picture Database Management System - DBMS - A collection of components that supports: 1. creation, user, and maintenance of databases 2. data acquisition, dissemination, retrieval, and formatting Table – a named, two-dimensional arrangement of data. A table consists of two parts: Slide 5 1. heading defining a) table name b) column names 2. body containing rows of data Structured Query Language - SQL – an industry standard database language that includes statements for database definition, database manipulation, and database control. Nonprocedural Database Language - a language such as SQL that allows you to specify the parts of a database to access rather than to code a complex procedure and also does not include looping statements Three Types of SQL Statements Data Definition Language – DDL – SQL statements for database definition Examples: CREATE TABLE, CREATE VIEW, etc. Data Manipulation Language – DML – SQL statements for manipulation of data. Examples: SELECT, INSERT, UPDATE, DELETE, etc. Data Control Language – DCL – SQL statements for database......

Words: 1567 - Pages: 7

Free Essay

Dell Medical Information Archiving

...Dell’s Medical Information Archiving (MIA) Strategic Business Unit (SBU) project portfolio process is essential to long-term market positioning. The SBU’s mission is to maintain Dell’s current role as the leading global provider of electronic medical information solutions. Dell’s dedication to meeting these solutions is evident through a standards based approach to improvement of enhanced data management applications. Dell’s MIA SBU is able to deliver a low cost, highly efficient storage and secure data storage platform for medical records through the constant identification and research of information needs. Dell understands that traditional record filing methods are too costly and time consuming for offices to manage. The development of a mobile clinical computing platform will help to maximize productivity through enhanced automation and communication features. These features will increase data management effectiveness by offering more cost effective, secure, timely, and accessible files. The MIA SBU has identified that customers have limited storage capabilities, but an increasing storage demand. Development of an open shelf file storage system provides customers with a cost effective approach to storing more files off-site. The off-site location is a secure database capable of offering fast retrieval and delivery of medical files. The project portfolio process will identify viable avenues to Dell’s retention of MIA market shares. Projects will be scrutinized...

Words: 286 - Pages: 2

Free Essay

Relational Databases

...UNDERSTANDING THE RELATIONAL DATABASES Student’s Name Instructor’s Name Course Name 03/05/2016 RELATIONAL DATABASES Being a data administrator is to handle and organize the bulk of data masses for easy and convenient retrieval of the information at any point of time. I generally believe that compiling a bulk of data is very difficult task for anyone who has the responsibility to manage the information. Therefore, here we go through and understand the concept of relational databases and use of tables designed to manage the data for the problem cases in our daily life. A relational database is a defined group of data items systematized and controlled as a set of formally defined tables from which the collected and unmanageable data can be reassembled or accessed in various different techniques deprived of having to restructure the pre-arranged database tables (Rouse, n.d.). According to Codd (1982), “Relational processing entails treating whole relationships as operands. Its primary purpose is loop-avoidance, an absolute requirement for end users to be productive at all, and a clear productivity booster for application programmers” (p.298). It comprises of designed data tables that are connected together in some important way. For instance, consider an organization that offers items to clients. The organization keeps up a database of the items it offers. Every item has a one of a kind code so it can be uniquely recognized. The item database comprises of a table, and......

Words: 631 - Pages: 3