archive-info.com » INFO » A » ALBERTON.INFO

Total: 92

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Lorenzo Alberton - Talks - The Art of Scalability - Managing growth
    Databases What When and Why PHPUK2011 PHPNW10 slides and new job Talks The Art of Scalability Managing growth Amsterdam 11 June 2010 Having invested time and energy into your application nothing could be more exciting than seeing it gain popularity and seeing your user base grow However the success of your application could also turn into your worst nightmare What if the site cannot cope with the load and collapses under its own weight The ability to grow and shrink according to the needs and the available resources is an essential part of designing applications In this talk we ll cover the fundamental elements of scalability including aspects involving people processes and technology With sound and proven principles and some advice on how to shape your organisation set the right processes and design your application this session is a must see for developers and technical leads alike The Art of Scalability Managing growth View more presentations from Lorenzo Alberton Back Lorenzo Alberton Lorenzo has been working with large enterprise UK companies for the past years and is now CTO at DataSift He s an international conference speaker and a long time contributor to many open source projects Follow lorenzoalberton Tags

    Original URL path: http://www.alberton.info/talks/show/id/3 (2016-04-24)
    Open archived version from archive


  • Lorenzo Alberton - Talks
    and explaining what processes to put in place what pitfalls to avoid and how to keep the system running We will walk through several scalability patterns clever techniques and cutting edge technologies high throughput message queues nosql databases monitoring tools each accompanied by one or more concrete examples Scalable Architectures Taming the Twitter Firehose View more presentations from Lorenzo Alberton Scaling Teams Processes and Architectures London Scalability Meetup 01 London UK 16 April 2012 Generic presentation about scalability challenges First London Scalability Meetup Quick overview of the DataSift architecture Scaling Teams Processes and Architectures View more presentations from Lorenzo Alberton Trees in the Database Advanced Data Structures PGCon 2011 Ottawa Canada 18 May 2011 Despite the NoSQL movement trying to flag traditional databases as a dying breed the RDBMS keeps evolving and adding new powerful weapons to its arsenal In this talk we ll explore Common Table Expressions SQL 99 and how SQL handles recursion breaking the bi dimensional barriers and paving the way to more complex data structures like trees and graphs and how we can replicate features from social networks and recommendation systems We ll also have a look at window functions SQL 2003 and the advanced reporting features they make finally possible The first part of this talk will cover several different techniques to model a tree data structure into a relational database parent child adjacency list model materialized path nested sets nested intervals hybrid models Common Table Expressions Then we ll move one step forward and see how we can model a more complex data structure i e a graph with concrete examples from today s websites Starting from real world examples of social networks and recommendation systems features and with the help of some graph theory this talk will explain how to represent and traverse a graph in the database Finally we will take a look at Window Functions and how they can be useful for data analytics and simple inline aggregations among other things All the examples have been tested on PostgreSQL 8 4 Trees In The Database Advanced data structures View more documents from Lorenzo Alberton Graphs in the database RDBMS in the social networks age PGCon 2011 Ottawa Canada 18 May 2011 Despite the NoSQL movement trying to flag traditional databases as a dying breed the RDBMS keeps evolving and adding new powerful weapons to its arsenal In this talk we ll explore Common Table Expressions SQL 99 and how SQL handles recursion breaking the bi dimensional barriers and paving the way to more complex data structures like trees and graphs and how we can replicate features from social networks and recommendation systems We ll also have a look at window functions SQL 2003 and the advanced reporting features they make finally possible The first part of this talk will cover several different techniques to model a tree data structure into a relational database parent child adjacency list model materialized path nested sets nested intervals hybrid models Common Table Expressions Then we

    Original URL path: http://www.alberton.info/talks/ (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles
    Full support for Kafka 0 7 with robust socket handling complete test suite Zookeeper based consumer and many other improvements Musings on some technical papers I read this weekend Google Dremel NoSQL comparison Gossip Protocols Database Data structures Performance Scalability NoSQL 3 September 2012 Some random comments on Dremel and a benchmark on Key Value stores How to evaluate technical papers and read between the lines Historical Twitter access A journey into optimising Hadoop jobs Data structures Performance Scalability Hadoop 7 August 2012 A journey into optimising Hadoop jobs the strategies to scan and filter a PetaByte of archived data schedule new jobs and deliver data fast Kafka proposed as Apache incubator project PHP Performance Scalability NoSQL Message Queues Kafka 24 June 2011 Kafka is a distributed publish subscribe messaging system developed at LinkedIn designed to support a very high throughput persistent messages and parallel loading into Hadoop A proposal has been submitted to make Kafka an Apache incubator project NoSQL Databases What When and Why PHPUK2011 Database Data structures Performance Scalability NoSQL 27 February 2011 Some considerations about NoSQL databases and slides of my talk given at PHPUK 2011 NoSQL Databases What When and Why PHPNW10 slides and new job PHP Zend Framework Apache Performance Scalability Profiling 19 October 2010 Summary of the PHPNW10 conference Slides about my talk Profile your PHP application and make it fly and new job The Art of Scalability DPC10 wrapup PHP Database Performance Scalability 13 June 2010 A wrapup of the Dutch PHP Conference 2010 Uploaded slides of my talk The Art of Scalability Managing growth PHP UK 2010 RDBMS in the social networks age PHP Database PostgreSQL Firebird SQL Oracle SQL Server Data structures 27 February 2010 Wrapup of the PHP UK Conference 2010 Uploaded slides of my talk RDBMS in the

    Original URL path: http://www.alberton.info/articles/index/page/1 (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles - Catching up - July 2007
    wonderful chance to visit Zürich and finally meet Harry and all the smart people in his team thanks for inviting me I also met Lukas in person for the first time It s really incredible how you can work with someone for years without ever seeing each other pear dev Apart from the lack of time I haven t been much active on the pear general and pear dev mailing lists either because they suddenly failed to reach my inbox and apparently there s no way to subscribe again If you posted a question regarding one of my packages and didn t get an answer please send me a mail I quickly scanned the online archives and saw a lot of discussions going on about the PEAR future I m sure there s a lot of interesting stuff there maybe someone can post a brief wrap up New PEAR packages Along with the other emails I ve also missed a few interesting package proposals like File Fortune and I18N UnicodeNormalizer I m glad they made it into PEAR and I m sure other nice ones will follow soon I was also hoping to have a first draft of PEAR Mail Queue2 ready by now but spare time must be a rare commodity for anyone nowadays Benoit if you read this post please drop me a mail Uh and I m particulary happy about Christian s efforts of a better QA infrastructure for PEAR Good job MDB2 PEAR MDB2 developement is progressing with the usual bug fixing activity A special thank you to Charles Woodcock and Hugh Dixon for their help with the Oracle driver execute now supports bind I O parameters and the driver uses prepared queries in many places the Reverse module should be considerably faster I still need

    Original URL path: http://www.alberton.info/catching_up_july_2007.html (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles - PEAR MDB2 updates (FOREIGN KEY support!)
    to PEAR MDB2 both in the Manager createConstraint and in the Reverse module getTableConstraintDefinition The constraint definition is translated to this array structure some key names could change slightly before an official release so they are in sync with MDB2 Schema array primary true false unique true false foreign true false check true false fields array field1name array one entry per each field covered by the constraint field2name array field3name array sorting ascending descending references array table name fields array field1name position one entry for each referenced field field2name position field3name position deferrable true false initially deferred true false on update CASCADE RESTRICT SET NULL SET DEFAULT NO ACTION on delete CASCADE RESTRICT SET NULL SET DEFAULT NO ACTION match SIMPLE PARTIAL FULL The next step will be adding CHECK constraint support If you feel brave enough please fetch the CVS version of MDB2 and give it a go And of course send me some feedback Updated INFORMATION SCHEMA tutorials On a side note I ve updated my tutorials on INFORMATION SCHEMA and system tables for Firebird Interbase PostgreSQL and SQL Server and added one for Oracle Interbase Firebird INFORMATION SCHEMA Oracle INFORMATION SCHEMA PostgreSQL INFORMATION SCHEMA SQL Server INFORMATION

    Original URL path: http://www.alberton.info/pear_mdb2_foreign_key_support.html (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles - PEAR MDB2 2.4.1 released
    field basis so you don t have to resort to the decimal places option which is global to all the fields A similar fix is included in MDB2 Schema already so you can use something like this in your XML schema definition field name revenue name type decimal type length 10 4 length notnull false notnull field The MDB2 v 2 4 1 release also features a number of important fixes including a patch for a regression bug in MySQL and MySQLi transaction support and a patch for a memory leak in the prepare execute statements so I warmly recommend you to upgrade Changelog MDB2 2 4 0 MDB2 Driver ibase 1 4 0 MDB2 Driver mysql 1 4 0 MDB2 Driver mysqli 1 4 0 MDB2 Driver mssql 1 2 0 MDB2 Driver oci8 1 4 0 MDB2 Driver pgsql 1 4 0 MDB2 Driver sqlite 1 4 0 Subpackages Thanks to a nice feature of the PEAR installer since MDB2 v 2 4 0 you can install upgrade the drivers in this simple way pear install MDB2 mysql pear upgrade MDB2 pgsql How nice is that As usual many thanks to all the contributors and bug reporters Have

    Original URL path: http://www.alberton.info/pear_mdb2_2_4_1.html (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles - PEAR MDB2 2.4.0 released
    4 0 MDB2 Driver mysqli 1 4 0 MDB2 Driver mssql 1 2 0 MDB2 Driver oci8 1 4 0 MDB2 Driver pgsql 1 4 0 MDB2 Driver sqlite 1 4 0 I ve personally tested most drivers Firebird SQL MySQL MySQLi MS SQL Server Oracle PostgreSQL SQLite and made sure that everyone of them is in good shape The MDB2 test suite was extended to cover almost all the public and private methods also the ones in the Manager and Reverse modules that aren t standard features across all the DBMS like TRIGGERs VIEWs and FUNCTIONs The Manager and Reverse modules of all the drivers sport a load of new features just browse the API docs and the official documentation yes it was improved extended as well for the details I put a lot of effort in these modules I hope they re useful I would like to gather some comments about the new methods to retrieve the TRIGGER and FUNCTION definitions please let me know if you like them and or what you would change A special thank you goes to Andrew Hill and Monique Szpak for contributing some ideas patches and a lot of new test cases

    Original URL path: http://www.alberton.info/pear_mdb2_2_4_0.html (2016-04-24)
    Open archived version from archive

  • Lorenzo Alberton - Articles - An update on my PEAR packages
    the nasty process of quoting the table and field names in the queries which was one of the most requested features and he s working on improving the documentation Thanks Elmar The new package release includes even more fixes and additions than the ones mentioned above see the changelog for the complete list I also backported most of the changes to DB QueryTool but I expect this to be its last release the package is now officially deprecated in favour of MDB QueryTool Mail Queue2 As said in a number of occasions the Mail Queue package while quite popular suffers from a number of problems that can t be fixed without breaking BC so its developement is sort of stalled Benoit Perroud offered his help in developing a new Mail Queue2 package that should overcome all the shortcomings of the v 1 x release We ve discussed some details and AFAIK he already has a working implementation so expect some news on this front soon probably in March MDB2 Since Lukas left the MDB2 developement and put me in charge I kept myself busy fixing a number of bugs in various drivers improving both the documentation and the testsuite and personally testing most of the drivers So I ve added Oracle and SQL Server to my existing Firebird PostgreSQL MySQL setup This also allowed me to implement most of the methods in the Reverse Module of each driver It s still a work in progress especially wrt the trigger definition handling which I need to ponder some more I d still love to receive some feedback about the charset handling and I hereby add a call for maintainers for the querysim sqlite and fbsql drivers Recently a guy named J Norment offered to write an ODBC driver let s see

    Original URL path: http://www.alberton.info/pear_updates_feb2007.html (2016-04-24)
    Open archived version from archive



  •