MYSql and Postgres on a Multiprocessor Environment

Durante dei test di confronto di performance tra i database Postgress & MySQL sono venuti fuori dei risultati molto interessanti a favore del primo. I test replicano l’utilizzo di routine dei database, con query di inserzione e gestione di dati. Non vengono utilizzate funzioni, triggers, stored procedures e nessun’altra funzione proprietaria del db.

MySQL è veloce in fase di popolazione dei database a causa di una differente gestione del disco in fase di scrittura. Ma in fase di selezione che è normalmente la piú importante nella storia dell’utilizzo di un db è lento rispetto al rivale Postgres. Questa differenza puó dipendere dal fatto che MySQL deve essere meglio personalizzato per lavorare in un contesto multiprocessore, peró questi risultati (i test sono effettuati in data 01 Novembre 2008) sono molto interessanti.

Riassunto dei test: Database, Macchine utilizzate e Query effettuate (con rispettivi identificativi utilizzati durante i test)

• Database
  • [pg] : PostgreSQL 8.3.5
  • [ms] : MySQL 5.1
• Hardware
  • [blade]: parallel of 3 Blade Dell, each of them with a double Quad-core CPU Intel Xeon E5450, 3Ghz with a 1333MHz BUS and 16 Gb RAM
  • [phobos] SUN Workstation with two Opteron 280, 2Ghz+ and 8Gb Ram
  • [localhost] cluster of 3 Acer Mini PC Intel Core Duo E2140, 1.6Ghz with 2Gb RAM
• Query
  • Creazione di una tabella con 2 coppie di String, di Integer, di Double
  • Inserzione di 100.000 righe con elementi random sui campi creati
  • Creazione di una tabella con 2 coppie di String, di Integer, di Double
  • Inserzione di 100.000 righe con elementi random sui campi creati
  • Query di selezione I
  • Query di selezione II

MASBIO 2008

This workshop is aimed at bringing together and creating synergies between researchers working on software agents, on the one hand, and bioinformatics and computational biology, on the other hand, to discuss relevant issues and approaches aimed at assessing and promoting the adoption of innovative technologies in such fields. Bioinformatics and computational biology are emerging disciplines that use information technology to organize, analyze, and distribute biological information in order to answer complex biological questions. As for bioinformatics, it typically refers to activities that involve researching, developing, or applying computational tools and techniques aimed at dealing with biological data –including those to acquire, store, organize, archive, analyse, or visualize them. As for Computational Biology, it refers to the development and use of analytical data and theoretical methods, mathematical modelling and simulation techniques aimed at studying biological, behavioural, and social systems. The amount of available information is constantly increasing, and it is difficult to exploit available data from all sources. Many of the available data are interrelated, but it is currently difficult to identify, select, clean, or use all relevant data, as different tools use different data formats with different semantics. There is a need to devise methods aimed at learning and discovering knowledge by “intelligently” combining these distributed data and information sources. In particular, after experiments are run, interpreting results requires gathering together potentially related data. Also, the context in which an experiment is run, such as the hypothesis to be tested or the legal constraints of the institution, may inform which resources are appropriately combined, again requiring “intelligence”. Moreover, some classical problems could be better tackled by resorting to a suitable computational paradigm using various interaction protocols, e.g., cooperation or competition.

TIR 2008

I sistemi robotici hanno incontrato considerevoli difficoltà per quanto riguarda il loro inserimento nella vita quotidiana di categorie anche molto diverse di utenti (disabili, operatori, bambini, adolescenti, single, gruppi familiari). Le ragioni di questa contrastata assimilazione dei sistemi dotati di intelligenza artificiale da parte degli utenti sono dovute a varie motivazioni riassumibili con: insufficiente capacità di calcolo; insufficiente capacità sensoristica e motoria; insufficiente autonomia e adattabilità; insufficiente capacità di essere percepiti dagli utenti come «personalità artificiale». È possibile individuare un tipo di architettura robotica in grado di esibire quelle caratteristiche che permettono una integrazione con la comunità degli esseri umani? E’ forse necessaria una nuova intersezione tra robotica, scienze cognitive, intelligenza artificiale e neuroscienze? Negli organismi biologici, quella parte dell’attività cognitiva nota come attività intenzionale corrisponde a quelle capacità, in termini di integrazione dell’informazione, autonomia, definizione di nuovi obiettivi, interazione con altri agenti, sviluppo di aspetti intenzionali del comportamento, che – negli esseri umani e negli organismi più complessi – sono reputate necessarie e sufficienti affinché un essere intelligente sia accettato dalla comunità degli esseri umani quale «agente intenzionale».

NLP 2008

This workshop aims at exploring new trends of research and development on the integration between ontologies and linguistic resources, where complementary levels of semantic specification meet.

In general, the actual practice of enhancing ontologies with linguistic content basically depends on the multifariousness of lexical resources and on the explicit linguistic information they expose. Multilingual scenarios also demand for a proper lexicalization of ontological content according to different idioms and languages. From simple vocabularies of terms to wordnet-like structures, distinct lexical models need a solid and comprehensive framework of representation to enable a full-operational integration with ontologies. The integration between frame-based lexical databases and ontologies complicates the overall scenario and constitutes another important aspect of the above-mentioned integration process and a relatively brand-new trend in the scientific community. These topics have recently become more and more important also in the challenge of combining Human-Language Technologies with Semantic Web technologies, towards the creation of next-generation knowledge systems.

DMBIO 2008

Bioinformatics and Life Science Informatics are emerging disciplines, which are concerned with the organization, modeling, analysis, and interpretation of data and information arising from research and development within the life sciences. A great deal of this work is directed towards understanding the structure and function of proteins, cells, the genome, and the process of natural evolution. The considerable algorithmic complexity of the underlying biological systems requires a huge amount of detailed information for their complete description. Very rapidly, vast amounts of biological information are becoming available in public information repositories, including DNA/RNA and protein sequence and structure databases, metabolic and signaling pathway databases, biomedical literature repositories, image databases, and many others. The key to advances in life science research and development lies in these information repositories and in future biological experiments and studies.

IABC 2008

Following a consolidated tradition, this new Workshop again aims to represent an opportunity for comparing possible contributions of artificial intelligence and other innovative technologies to conservation, valorisation and fruition of the cultural heritage. The main goal is to encourage possible interactions and aggregations between the different agents and to constitute a community of institutions able to tackle this new challenge. The proliferation of computer applications in the sphere of cultural assets renders the ascertainment of the state of the arts even more urgent. The workshop will provide the opportunity to present, share and discuss the experience of researchers in managing cultural heritage resources.

AI*IA 2008

AI*IA’08 is the tenth in a symposium on advances in Artificial Intelligence held bi-annually in Italy by the Italian Association of Artificial Intelligence (AI*IA). In the 2008 the focus was on artificial intelligence and life sciences. The technical program for the symposium included five worksohps, invited lectures, and presentations of refereed posters.

Logo samples

Celebration

MediaFire Servers

MediaFire è un servizio dall’aspetto accattivante, ma si rivela assolutamente inaffidabile al momento dell’utilizzo.

L’esperienza di utilizzo di MediaFire è frustrante, sopratutto quando ci si accorge dell’inattendibilità dei server dopo aver speso settimane per caricarvi i propri lavori.

Il servizio di comunicazione con il cliente rispecchia la filosofia del gruppo. Si dimostrano subito gentilissimi e disponibili, fino ad accorgersi un giorno che le loro mail per lo più sono mail di scuse inviate per lo più in maniera automatica.

[...]
I experienced problem since its first use, unfortunately only after the whole upload of files for a blog transfer.
MediaFire User
Posted On: Jan 25, 2008 08:17 PM

---

Hi User,
Thank you for contacting us. Could you please provide more information about the problem? Are you having difficulty viewing the images, or downloading them? Also could you please provide the URLs of these files?
Best regards,
Amanda, The MediaFire Team

---

Amanda, every time you ask me for details. More than the half of my images don’t work, this depends on the day on the time on lot of stuff. I’m tired, and waiting somebody say me if the problem can be resolved.
MediaFire User

Hi User,
Thank you for contacting us.  We are currently looking into the issue you reported to find a solution.  For now, if you need the images immediately you may want to try reuploading them.
Amanda, The MediaFire Team
Posted On: Jul 08, 2008 02:13 PM

---

Years are passing and you didn’t resolved the disappearing of the files from your servers.
This service is the worst thing i ever used on internet. Unfortunately I spent week filling it with images that i can’t download almost of times, and i have not that wish and the time to do all the work again on a reliable service, and i am hoping in vane you’re going to resolve, the hope is the last thing to die.
I am not comfortable with ugly words but I am really tired of all this and I am going to receive with another answer “we’re going to resolve”.
It is an incredibly unreliable service.
MediaFire User

Perciò prima di utilizzare questo servizio, controllate anche le alternative.