Caching Oracle Data for ASP.NET Applications
For building scalable and high-performance Web based applications, ASP.NET provides a feature called data caching. Data caching enables programmatic storing of frequently accessed data objects in memory. This feature can be extended to vastly improve performance for ASP.NET applications that query data stored in an Oracle database. This article describes a strategy for caching Oracle [...]
Creating an Ajax Process Using PHP and Oracle
For some time now, Ajax (Asynchronous JavaScript and XML), has been all the rage in the Web development world. Coming to the forefront with some of Google's features (Suggest, Maps, Gmail, and so on), Ajax performs server requests without the user having to submit a form or click on a link. In other words, the [...]
Database-Based Authentication for PHP Apps, Part 2
In Part 2, you will expand on the example authentication and user entry solution constructed previously. Whereas the current solution treats all users as equals, the idea of users accessing all things equally is unusual in real applications. Rather, your users probably have roles and privileges limiting their access to data based on their position [...]
Database-Based Authentication for PHP Apps, Part 1
Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, database-based authentication is the solution.
Authentication systems contain an Access Control List (ACL) that lists your user credentials and matches them to [...]
Introduction to Legacy Modernization in Oracle
In this article by Tom Laszewski and Jason Williamson, we have outlined five methods of modernization: SOA Integration, Re-architecture, Platform Migration, Replacement, and Data Modernization as well as some key factors to be considered for each option.
Introducing SQL Developer Data Modeler: Part 2
Working with diagrams and their components
You can waste away many hours laying out the elements on a diagram. Therefore, this aspect of modeling can be time consuming. However, a model serves as documentation and a communication device. Therefore, taking the time to make sure it is well annotated and clearly designed is important. Most of [...]
Introducing SQL Developer Data Modeler: Part 1
Oracle SQL Developer Data Modeler is available as an independent product, providing a focused data modeling tool for data architects and designers. There is also a Data Modeler Viewer extension to SQL Developer, which allows users to open previously created data models and to create read-only models of their database schemas. SQL Developer Data Modeler [...]
Working with the Report Builder in Microsoft SQL Server 2008: Part 2
In the previous part of the article, we had a look at the Report Builder overview and described the Report Builder 2.0 interface. In this part by Jayaram Krishnaswamy, we will discuss about Enabling and reviewing My Reports, and will see how to Modify a basic report.
Working with the Report Builder in Microsoft SQL Server 2008: Part 1
Report Builder 2.0 is feature-rich reporting tool with the latest Microsoft Office look and feel. In this two part article by Jayaram Krishnaswamy, we will see how the Report Builder 2.0 provides an extremely flexible GUI with user friendly wizards for creating the Tablix data regions, a versatile construct that includes tables, matrix, and charts [...]
Introduction to database design
This article/tutorial will teach the basis of relational database design and explains how to make a good database design. It is a rather long text, but we advise to read all of it. Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know [...]