Both R language and esProc have the outstanding ability to perform the stepwise computations. However, in the particulars they differ from each other. A comparison between them will be done by the following example:A company’s Sales department wants to select out the outstanding salespersons through statistics, that is, the salespersons whose sales amounts are always among the top 3 in each month from the January this year to the previous year. The data is mainly from the order table of MSSQL database: salesOrder, and the main fields include the ID of order: ordered, name of salesperson: name,
sales amount: sales, and date of order: salesDate.The solution is like this substantially:1. Compute the beginning dates of this year and this month, and filter the data by date.2. Group by month and salesperson, and compute the sales amount of each salesperson in each month.3. Group by month, and compute the rankings of sales amount in each group.4. Filter out the top 3 salespersons from each group.5. Compute the set of intersections of each group, that is, salespersons always among the top 3 in each month.The solution of R language is as...(Read whole news on source site)
Originally posted on: http://geekswithblogs.net/TATWORTH/archive/2014/04/22/apress-deal-of-the-day---22apr2014---sql-server.aspx Today's $10 deal of the day from APress at http://www.apress.com/9781430247913 is SQL Server 2012 Data Integration Recipes "SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of moving data in and out of SQL Server, helping to create robust and resilient ETL environments. "
InterBase is a high-performance relational database system that is full of features, and is used primarily in software development, especially by those who want a lightweight database for mobile applications at a relatively low cost. InterBase is used mostly on platforms like, iOS, Android, Windows, Linux, Solaris, etc. and provides the platform powerful security, disaster recovery, and support for all the drivers necessary for database deployment with flexibility. Features of InterBase Based on the application it is to be used with, you can create database of required size, which makes the InterBase highly scalable. Along with this, many of the features added to the InterBase are mentioned below: No Administration and
Least Disk Space The applications (such as ISV, OEM, and VAR) that require small databases best suit the InterBase, as along with its compact size, it is full of features and can keep your business critical data safe. The key feature that increases its demands is that no expensive support as well as maintenance cost is involved, which costs a lot in other database engines. In this way, InterBase is preferred the most for the development of lightweight applications. High Security and User Access Control At zero administration cost, InterBase features data encryption that is required to keep your business-critical data secure. You can encrypt the database with AES (Advanced Encryption Standard)...(Read whole news on source site)
full DAY of Angular!) and there are still several lessons left to record. In this post I organize some of the content and resources I’ve created as a guide to help you link into information, code snippets, and other information that may help you build your Angular apps. If you’re in the early stages of learning Angular, you might ask yourself “Why?” That’s why I wrote 10 Reasons Web Developers Should Learn AngularJS. I attended one of the first Angular conferences in the U.S. that sold out in minutes, and had the opportunity to meet with other .NET...(Read whole news on source site)
Story so far Lately I have been moving towards more functional style programming. One way that you can categorize functional languages is those that have their own complete ecosystem (haskell, erlang, oCaml) and those that piggyback off an existing ecosystem, runtime and standard library (F#, scala, clojure). It is clear that the second category has a substantial advantage for adoption. The runtimes are well established, reliable and fast. The standard libraries and package managers provide the best guarantee possible that I will not be left missing a critical component. There are downsides too. The integration between the functional programming syntax and
underlying standard library are well designed but awkward. However, on balance the piggyback functional languages (F#, scala and clojure) provide a practical and valuable way to move to functional programming. For me F# has some distinct advantages. I think types are one of the most important tools we have for writing working software, so dynamic languages like clojure have less appeal. Having spent 10 years working with .net the CLR is more approachable to me than the JVM. Finally, scala displeases me aesthetically. Recently, my employer sponsored a professional development activity where I investigated the feasibility of applying...(Read whole news on source site)