Blogs

JQuery FlexiGrid Plugin for Pentaho

 

 

Attached is a version of the plugin that addresses a number of challenges. No other changes.
Groups eGlu have been using this plugin with good results.
We have developed a transmission based on this component KPIs, really responded well.

Regards

 

 

Mariano

Improve MySQL performance by adjusting some parameters

 

MySQL, like most database managers, can easily modify the parameters that control memory sizes engaged in certain tasks, resource utilization, concurrency limits, etc.

Properly adjusting these parameters can be obtained many performance improvements, especially if the server / s of the database is not about resources, and if the SQL optimization can not be improved more.

I've recently made some basic settings in a MySQL database, so I take this opportunity to explain some of the process I followed for those who seek an easy way to make a first optimization of parameters in the database. This is not to say that this is the best way to do just that to me has worked out well;)

The first comment that can be very helpful to look in phpMyAdmin to the sections 'Show information about MySQL runtime' and 'Show MySQL system variables', normally accessible from the home page of the application.

The first displays information and statistics collected and maintained the system since its beginning. Pay special attention to the values of variables that are displayed in red, and the advice provided to the right of these values.

Please refer to the variables used to determine the current values of the parameters that could later be modified to improve performance.

 

SQL08: affinity_mask, IO_affinity_mask and like riding two on a single server environments without being "walked"

 

We put ourselves in position
In our environment we may need to have two replicas of a / s data base distinct environments (the classic example would be production and test). In deciding as we do the most common questions we must ask ourselves are:

- Is this new environment will be temporary? Does large data bases in terms of volume and / or load to be borne is high (even test)?
- Is there version SqlServer2008 development? That alone is at hand if you have an MSDN subscription ...
- Is there an extra server?

Based on these questions and all that it can happen one can opt for different solutions:
"The easiest and if the database to bear the burden are small we can use the same server for all databases (created on the same server with different names (_test) and Holy Easter ...). In order not to disturb each other we can use Resource Governor.
"The most" aseptic "if resources permit and where it would be worthwhile to mount on different servers (if we have the development version)
"Another option is a mixture of the above. Fit the two environments on the same server but different instances.
-Etc ...

1 server cpu n (n> 1) + 2 = 2 instances environments

SQL08: Synchronization Database Microsoft Dynamics AX 2009 on SQL Server 2008

 

For those database administrators who have to deal with such a Dynamics Ax 2009 and his henchmen (developers, consultants, etc. )  I leave here a couple of things you should know (or I should say) when we join ax2009 and sql server 2008. Sometimes you can point to the database as a source of the problem but not always. Some requirements to consider for installing Ax2009 are that the user you want access to the system should be user and DOMAIN in sql server role must be a member of securityadmin dbcreator and to create the new database from Ax installer. Once installed (or during the installation process) the problem with the database that we can find include: 

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

 

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:

Oracle10g: Manual standby database (initial approach)

 

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:

We release the weekly Newsletter Dataprix

 

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.

Slowly Changing Dimensions

 

Slowly changing dimensions or SCD (Slowly Changing Dimensions) are dimensions in which their data tend to change over time, either occasional or constant, or involving a single record or the entire table. When these changes occur, you can opt to follow one of these two great options:

@ User Manual in Spanish Spoon

 
Good.

I have just completed the update of User Manual in Spanish Spoon @  (See manual..)

The manual has been prepared in full, based on the translation I have been provided by Leonardo M. Tito and Felipe Mullicundo:

jQuery FlexiGrid 2 in Pentaho

 
Hello People

Following a series of needs I have decided to develop for the group eglu and, of course, to all of you, a plugin that allows you to use jQuery FlexiGrid since Pentaho-CDF.
Not if you permit to happen, my especially if they need a list with a number of features such as filtering, sorting, paging, sorting, selection of visible columns, resize, etc.. Without doubt, this is what jQuery provides FlexiGrid 2.0. The theme is to make it work in Pentaho is somewhat cumbersome, this was my trigger. Without further ado I attached a video showing the functionality of the plugin. In a few days annexed to the plugin, source, demos and documentation so they can try and give me feedback. 

Syndicate content