//AMIS Technology Blog » IT Architecture » Page 5

IT Architecture

Knowledge Center IT Architecture

Vacatures bij AMIS services

I don't like a reclaimable database disk copy

0
2 years ago
by Harry Dragstra in ,

As of Oracle 10g it’s possible to recover (or wind forward) a RMAN disk copy of the database to a specific time in the past. This type of backup is quite suitable for big databases (> 100GB), because you have to perform a time consuming full backup only once. All other backups to disk will be incremental ones, and with block change tracking on, these backups are done in a fraction of the time a full backup takes.

A setup like this needs a bit of disk space. Using the FRA (Flash Recovery Area, but from 11gR2 on it stands for the more appropriate Fast Recovery Area ), you may need to size it to 2 times the size of the database, or even more, depending on the number of database transactions. However, till now I have been able to convince most clients I worked for of the benefits of this kind of backup regime, and to provide or even buy the extra disks necessary.

My favorite configuration of a RMAN database backup is as follows: In the first week, on a Sunday, a onetime full (level 0) disk backup (copy of datafiles) to the FRA, and a subsequent backup of the database copy to tape. From then on, every day an incremental level 1 disk backup, and the backup to tape of all archives and More >

SIG Event

Compliments; Instant productivity improvement for software teams, with a small effort….

0
3 years ago
by Robbrecht van Amerongen in , , , ,

Hello, you project manager/team leader. I expected this title to grasp your attention. Would you like to know how to improve the performance of your team members?  This can be done without massive statistics or an expensive performance improvement program. This magic pill is called positive feedback. Just give your team members the credits for their work and compliment them for their achievements.

As a project manager we are aimed on the end result. In our day to day job we are focused on the things that are not yet done and the things that could go wrong. This focus on future result and possible impediments make us forget the past achievements of our team.

(more…)

SIG Event

Automatic testing Oracle Service Bus using Hudson, maven and SoapUI

0
3 years ago
by Robbrecht van Amerongen in , , , , , , , , , , , , ,
A lot of current projects are implementing some sort of service based architecture. Testing in this architecture becomes more complex. When implementing an OSB project with Scrum you test-automation is imperative. Scrum will require more frequent testing of your system. This is only feasible (in time and money) when you automate as much as possible.   Using soapUI you are able to create visually SOAP tests on your OSB implementation and running them against the defined infrastructure (develop, test, acceptance).  SoapUI enables with easy tools to implements verification and validation of the responses of your OSB implementation. When running the test you are also able to set limits in SLA response times on all the calls. This way you are able to monitor depreciation of performance in older parts of your OSB implementation when adding new services.   You can record and edit your SOAP test easy with the soapUI interface and edit it later. When you maven-enable your project it is quite easy running your tests when you implement the “maven-soapui-plugin” (see my other posting http://technology.amis.nl/blog/3061/automated-soap-testing-with-maven).  In the meantime version 3.0 of More >
SIG Event

Agile software development, the principles. Principle 11: The best architectures, requirements, and designs emerge from self-organizing teams.

1
3 years ago
by Robbrecht van Amerongen in , , , , , , , ,
This is the eleventh of 12 posts about the principles of agile software development. Purpose is to go back to the start of the agile manifesto (http://agilemanifesto.org/principles.html) and discuss the implementation of the 12 principles in real life software engineering. Goals of agility are to go deliver software of higher quality, faster, with a higher acceptance to end-users and able to follow the changing business requirements to strive for competitive advantage.   The question is: is this going to work in practice or is this only based on a nice marketing and sales story.   Principle 11: The best architectures, requirements, and designs emerge from self-organizing teams.   For a long time the engineering expertise (and also software engineering) was based upon the condition that you worked with specialists. These specialists emerged from the principle of division of labour and made it possible for these specialists to focus their attention on their specialism and create the best solution within their field of expertise. The Interaction designer designed a user interface, the architect created a global systems model, developers created code and More >
Vacatures bij AMIS services

Oracle Enhances XBRL Reporting Capabilities with UBmatrix, Inc.

3 years ago
by Marco Gralike in , , , , , , ,

Oracle posted a press release about their involvement and commitment for UBMatrix XBRL technologies last Wednesday saying (among others):

"To help publicly held companies facilitate the preparation, publishing and automatic exchange of financial statements in XBRL (eXtensible Business Reporting Language), Oracle will embed UBmatrix, Inc.’s leading XBRL technology into Oracle’s Enterprise Performance Management (EPM) System, Oracle announced today."

"Oracle and UBmatrix are also working together to provide enterprise class storage and management for XBRL-based information in Oracle® Database 11g. Using Oracle Database’s XML DB feature, organizations can easily and quickly store, access and query their XBRL data."

A lot of you might ask themselves: "Who are or what is UBMatrix?" and "How does it all fit in…?"

UBMatrix is one of those small but cool companies that have an idea and drive that idea to bigger heights. Their ideas about how to deal with XBRL and how to make it more succes full are very innovative. XBRL is an open standard to exchange and/or embed business and financial related data via XML. "Nothing more and nothing less…", but applying it has a great impact to other More >

Vacatures bij AMIS services

Enhancing fast queries using "Tapio-Indexes"

3 years ago
by Gerwin Hendriksen in , , , , , ,

During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these situations the execution plans, from such queries can look like:

 

OPERATION            OPTIONS                 OBJECT# NAME                         -------------------- -------------------- ---------- ----------------------------------- SELECT STATEMENT                                     .                           SORT                 ORDER BY                        .                           TABLE ACCESS         BY INDEX ROWID           120713 XXX.TABLE_WITH_MANY_COLUMNS INDEX                RANGE SCAN               121558 XXX.INDEX_WITH_FEW_COLUMNS 

 

In a lot of cases we deal with a query for example which is returning fewer columns than exists in the involved table like four, from an involved table having twenty columns. Although the execution plan looks already pretty “OK”, it still results in a query which is in top three most resource taking queries.

 

To enhance the query we can use “Fat Indexes” or nowadays better known “Tapio Indexes” (I call them like that nowadays). What are these kind of indexes…. In More >

Go to Top