naveen98456
Age : 34
Joined : 08 Mar 2008
Posts : 1264
|  Subject: An Enterprise Database Security Primer  Thu 20 Mar - 23:22 | |
| An Enterprise Database Security Primer Last Update 2006/7/20 8:53
Category Database
Description
For many system administrators, the terms “open systems” and “security” can seem impossibly opposite. Maintaining security for a centralized database system is difficult enough, and when faced with a network of networked databases, maintaining a level of access and update security is a formidable challenge. Security is often an afterthought, and the database industry is plagued with sub-standard security, especially for enterprise databases that are cobbled-together as a result of external factors such as corporate acquisitions.
Hits: 59 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Getting Real With Databases in PHP Last Update 2006/8/1 10:36
Category Programming Languages PHP : Database
Description
This article shows how to abstracts database queries into separate objects for each table, adapting the Ruby on Rails to PHP.
Hits: 47 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Extreme Programming and Database Administration: Problems, Solutions and Issues Last Update 2006/8/13 10:06
Category Database : Approaches, Process, Methods, Techniques Agile Extreme Programming (XP)
Description
Discusses unique aspects of Extreme Programming projects that include a significant database administration role. Describes how a DBA team fits into the broader context of the overal XP team.
Hits: 92 Rating: 10.00 (1 vote)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
A Roadmap for Regression Testing of Relational Databases Last Update 2006/8/13 10:09
Category Database : Test and Quality Assurance Testing
Description
This article overviews the importance of, and strategies for, regression testing relational databases. If your organization considers data to be a corporate asset and/or you're implementing mission-critical functionality within your databases, shouldn't you have a database testing strategy in place?
Hits: 141 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Increasing the Effectiveness of Automated Testing Last Update 2006/8/18 10:31
Category Database : Test and Quality Assurance Testing : Approaches, Process, Methods, Techniques Agile Extreme Programming (XP) : Tools
Description
Describes techiques (such as an in-memory database) for reducing the execution time and maintenance costs of automated regression test suites.
Hits: 171 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Java and the Empowered Database Last Update 2006/9/14 10:44
Category Programming Languages Java : Database
Description
The connection between object-oriented systems and relational databases is commonly solved by employing a so-called O/R mapping (ORM) framework whose goal it is to map object-oriented models to entity relationship models which are used, often generated, in relational databases. An unwritten consensus in the industry is that the best approach in solving these problems is a process where the business requirements are modelled in the object domain and where the resulting object model is mapped via an O/R mapping framework into the relational database system. This article proposes a reversed approach where the modelling is done in the relational tier and as much business logic as possible is handled within the database by employing a set of stored procedures as the middle tier.
Hits: 46 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Implementing Object Caching with AOP Last Update 2006/9/14 12:06
Category Programming Languages Java : Database : Approaches, Process, Methods, Techniques Object Oriented Analysis and Design
Description
Object caching provides a mechanism to store frequently accessed data in memory, minimizing the calls to back-end database, and resulting in significant improvement in the application performance. By making caching an Aspect we get the flexibility of dynamically adding caching ability in a J2EE application for cached objects. We can also remove caching out of the application whenever it becomes a bottleneck in terms of memory usage. In this article, I will provide an example of object caching as an Aspect in J2EE applications and discuss the steps involved in injecting the caching functionality into a sample web application.
Hits: 60 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Cayenne: Being Productive with Object Relational Mapping Last Update 2006/9/18 10:50
Category Programming Languages Java : Database : Tools
Description
This article presents Cayenne - a fast, scalable and easy-to-learn open source Object Relational Mapping (ORM) framework. Cayenne is a rare kind of a Java open source project. It is not just an "edit your own XML" runtime library, but an integrated suite that includes modeling and deployment tools. This article shows how to quickly create an ORM application with Cayenne and discusses its core features and design principles.
Hits: 52 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Object-relation mapping without the container Last Update 2006/10/4 7:28
Category Programming Languages Java : Database : Approaches, Process, Methods, Techniques Agile Test Driven Development : Tools
Description
If you follow the latest developer buzz then you've likely heard of IOC (Inversion of Control) containers and AOP (aspect-oriented programming). Like many developers, however, you may not see where these technologies fit into your development efforts. In this article, I'll begin to remedy that, with a hands-on introduction to using Hibernate and Spring to build a transactional persistence tier for your enterprise applications. Hibernate is a popular, easy-to-use, open source object-relation (OR) mapping framework for the Java platform. Spring is an AOP framework and IOC container. Together, these two technologies will provide the foundation of your development efforts in this article. You'll use Hibernate to map some persistent objects to a relational database and Spring to make Hibernate easier to use and provide declarative transaction support. As an added bonus, I'll throw in a little TDD (test-driven development), as DbUnit was used to write the test code for the example classes. Note that this article assumes that you are familiar with enterprise development on the Java platform, including JDBC, OR mapping issues, J2EE design patterns like DAO, and declarative transaction support such as that provided by Enterprise JavaBeans (EJB) technology. You are not expected to be an expert in any of these technologies in order to follow the discussion, nor do you need to be familiar with AOP, IOC, or TDD, as all three will be introduced in the article.
Hits: 76 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Control your test-environment with DbUnit and Anthill Last Update 2006/10/4 7:31
Category Programming Languages Java : Database : Test and Quality Assurance Testing : Configuration Management : Tools
Description
The inception of the Extreme Programming methodology has brought test-driven development and continuous integration into mainstream Java development practices. Applying these techniques to Java server-side development can quickly become a nightmare if you don't have the right tools. This article describes how to deal with continuous integration and how to use DbUnit in conjunction with JUnit to control the test environment end-to-end by setting up the state of the database before each test.
Hits: 60 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Data Replication as an Enterprise SOA Antipattern Last Update 2006/10/20 9:44
Category Database : Approaches, Process, Methods, Techniques Architecture : Programming Platforms Services
Description
As applications are envisioned and delivered throughout any organization, the desire to use data replication as a “quick-fix” integration strategy often wins favor. This path of least resistance breeds redundancy and inconsistency. Regularly applying this antipattern within an enterprise dilutes the original long-term goals of a service-oriented architecture (SOA). However, depending on the context in which it surfaces, data replication can be viewed either positively or negatively. To successfully deliver to a service-oriented strategy, enterprise architects need to draw from the successes and failures of other architectures. Architecture patterns, when discovered and documented, can provide the best technique for managing the onerous job of influencing change in your enterprise. Weíll use both an antipattern and a pattern to describe how data replication can impact your enterprise architecture.
Hits: 32 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
A Primer on Spring's Data Access Object (DAO) Framework Last Update 2006/12/1 10:09
Category Programming Languages Java : Database
Description
The business components in J2EE applications typically use the JDBC API to access and change persistent data in relational databases. This often leads to the mixing of persistence code with business logic—a bad idea. The Data Access Object (DAO) design pattern addresses this problem by separating the persistence logic into data access classes. This article is a primer on DAO design pattern, highlighting its merits and demerits. It then introduces the Spring 2.0 JDBC/DAO framework and demonstrates how it elegantly addresses the drawbacks in traditional DAO design.
Hits: 69 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Zero-config object persistence with Simple Persistence for Java Last Update 2007/2/21 21:38
Category Programming Languages Java : Database : Tools
Description
Object persistence is a must in almost all Java™ applications, from the desktop to the enterprise. The downside of persistence is that it has never been particularly simple. But that has changed with the most recent version of Simple Persistence for Java, an open source library for object-relational persistence. Simple Persistence for Java version 2.1.0 adds support for HSQLDB, a 100% pure Java database. Neither Simple Persistence for Java nor HSQLDB requires administration or configuration from the application user. Taken together, these tools enable you to introduce persistence to your applications with very little work. This article introduces you to Simple Persistence for Java v2.1.0 and shows you how to use it to achieve almost effortless object persistence in your Java applications.
Hits: 19 Rating: 0.00 (0 votes)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 2 Last Update 2007/2/22 8:24
Category Database : Tools : Programming Platforms AJAX
Description
In this second article in the series on using the Google Web Toolkit (GWT) to build Asynchronous JavaScript + XML (Ajax) applications, learn how to build the Apache Derby database for your Web application, and use it to drive the GWT. Part 1 of this series introduced you to GWT and demonstrated how you can use it to create a rich-client front end for a Web application. This time, you'll go behind the scenes and set up the back end with your database and the code used to convert the data to a format that GWT can use. By the end of this article, you'll be ready for the front end and back end to talk to each other.
Hits: 151 Rating: 10.00 (1 vote)
Rate this Article | Modify | Report Broken Link | Tell a Friend | Comments (0)
An Exploration of XML in Database Management Systems Last Update 2007/3/27 10:09
Category Programming Languages XML : Database
Description
A snapshot of the growing usage of XML in collaboration with database management systems |
|
