Database Express. One way to start with the big ones.

By respinosamilla on Tue, 04/13/2010 - 10:36

In a previous blog entry ( OpenSource Databases. Why did we choose for our project Mysql?), talked about the Open Source databases such as interesting and reliable option for the development of business intelligence projects. We saw some different products and compare between them.

But there are other alternatives (with limitations in most cases) that allow us to start working with "big" of a free. Express versions are called. Versions are designed for small systems, for development work or training, for prototyping or evaluation, that allow us to "initiation" with the great managers of relational databases. In most cases, the product is offered fully functional, but with limitations (the maximum size of the database, use Ram memory or processors of the machine, etc). There may also be features that are not active in these versions (such as partitioning version  of Oracle Express).  I leave the link to the manufacturers' web sites where you can download these versions:

Pentaho Solutions: Reviews

By bernabeu_dario on Tue, 04/27/2010 - 13:19

 

Good.
I finally finished reading the book Pentaho Solutions, who kindly have sent me Roland Bouman (co-author of the book) and Wiley.

On that occasion will realize different reviews from different points of view, as I did with Pentaho Reporting. Here are the reviews:

 

1) Overview :  It is a very easy book to read and handled very well the theoretical and practical.

As the concepts are giving more complex and heavy, is always accompanied with an example, graphic or exercise.

This book is really very useful and indispensable reading both for those who are just beginning to work with Pentaho, and for that we have some time.

 

 

Information is the power, Business Intelligence on Corporate Governance

By Litebi on Tue, 04/27/2010 - 11:26

 

"The goal of Business Intelligence is to provide the information they need, when you need it and in a form appropriate to people who have to make decisions."

The aim of this paper is to support the Business Intelligence or BI should be, of all business software tools (including CRM, ERP, or BI himself), that is closest to the role of management, specifically the Executive Officer.

Since the computer revolution and the explosion of Internet, information is becoming more and more importance. Everything is or will soon be digitized, the amount of information available each year is multiplied and the activity of our business is computerized in most respects.

Studies tell us that the information maintained by companies is doubling every two years and that 80% of decisions are made with only 10% of the available information.

And all of this information is power! Is necessary, vital, to compete. 

Defragment to optimize MySQL tables

By Carlos on Mon, 04/26/2010 - 12:49

 

In MySQL, when you delete records from a table, space is reallocated automatically. It is as empty space and forming new attachments will advantage.

The problem is that if a table perform many DELETE operations, the physical space of the table will become increasingly fragmented and the performance is reduced.

In the MyISAM and InnoDB, OPTIMIZE TABLE command available to perform an optimization on any table that, among other things, performs an automatic defragmentation of the table.

It is highly recommended to use this command regularly especially on tables that are more statements of disposal of records.

As a precaution, keep in mind that during implementation, of course, the table is blocked. You have to remember when you are going to use with large tables and busy.

Supersimples The syntax is:

 

OPTIMIZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE mi_tabla1 [, mi_tabla2] ...;

To make a fragmented table optimization can be selected to have free space, probably as a result of DELETE statements:

We release the weekly Newsletter Dataprix

By Dataprix on Tue, 03/23/2010 - 13:26

Subscripción a la Newsletter Semanal de DataprixWe have modified the email subscription system to Dataprix content.

So far this subscription using the Feedburner system associated with the main RSS Dataprix to send automatically to every user subscribed to a daily email with the new publications of the previous day.

We decided to change this system to one that allows itself a subscription / low snapshot from the same page. For registered users only a matter of pressing a button, and the user is not only need to enter an email address and validate it later from the mail that will be sent.

Another advantage we get is that we will create a newsletter for each language Dataprix for each one would reach the new content of your preferred language.

Furthermore, the creation of the Newsletter will be weekly and manual, thus having the possibility to further customize the content of it, and select what they consider most interesting of everything published during the week.

The Newsletter is sent every Tuesday, referring to the new content published since the previous Tuesday.

Pentaho BI Server 3.5.2 stable

By magm on Mon, 03/08/2010 - 10:42

A few minutes are up to publish the stable versions of Pentaho BI Server 3.5.2.

You can download it at: https://sourceforge.net/projects/pentaho/files/
 

I have not reviewed this version, but I am doing beta testing before and have found no major changes in the UI, just some updates of bookstores, but not widen too much.

Whenever I get more information, I have the relevant comments.

Greetings
 

Oracle10g: Change the character set of the database

By il_masacratore on Wed, 03/10/2010 - 10:23

It may happen that after you install or configure a new Oracle database we realize that the character set chosen during installation is not correct. What we may happen in cases like this is to delete the database and reconfigure it or worse ...But you do not. We can change the character set stopping the database, looking up strictly by changing the settings and restart the database. Howto:
 

- First we connect to the database 

$ sqlplus sys/pwd@prod as sysdba
 

- We stop the database 

SQL>SHUTDOWN IMMEDIATE;

 

- We raise strictly * 

SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER DATABASE OPEN;

- Change the character map 

SQL>ALTER DATABASE CHARACTER SET <new characters map>;

- Restart the database and yata 

Spectacular graphics that meets the key figures for Google

By Carlos on Fri, 03/12/2010 - 14:36

Spectacular graphics that meets the key figures for Google

 

To get an idea of the volume of business that moves Google infografia nothing better than that prepared in pingdom, which collected on the same graph one timeline with key milestones of the company, impressive numbers on the form, increase in revenues , figures on company employees, and the most significant data on other successful products such as Android, YouTube, Blogger, Gmail, Chrome, Orkut or Analytics.

A good source of inspiration for anyone eager to create a scorecard where we could see these evolve dynamically as so well chosen indicators.

Surely more than one person has clicked on an indicator in the chart to see if anything more;)..

Oracle10g: Manual standby database (initial approach)

By il_masacratore on Wed, 03/24/2010 - 12:15

An Oracle database in Standby is an exact copy of an operational database on a remote server, used as a backup, and copy for reference, disaster recovery, etc..

A database in the Standby mode is more than a normal backup because it can be put into production disaster in less time than if we had to restore a copy (either from a simple rman or export).Restore a copy from file takes time, and during this period the system is unavailable. With an additional database in standby mode there is nothing (or almost nothing to restore) in case of disaster. Within minutes, allowing the change is continuity of service. It offers the performance advantages of a cluster or safety of the mirror but the ratio of costs versus benefits and leave time seems right to me.

From a global perspective: