Monday 16 February 2015

Analytics On The Fly

The basis for real-time analytics is to have all resources at disposal in the moment they are called for . So far, special materialized data structures, called cubes, have been created to efficiently serve analytical reports. Such cubes are based on a fixed number of dimensions along which analytical reports can define their result sets. Consequently, only a particular set of reports can be served by one cube. If other dimensions are needed, a new cube has to be created or existing ones have to be extended. In the worst case, a linear increase in the number of dimensions of a cube can result in an exponential growth of its storage requirements. 

Extending a cube can result in a deteriorating performance of those reports already using it. The decision to extend a cube or build a new one has to be considered carefully. In any case, a wide variety of cubes may be built during the lifetime of a system to serve reporting, thus increasing storage requirements and also maintenance efforts.

Instead of working with a predefined set of reports, business users should be able to formulate ad-hoc reports. Their playground should be the entire set of data the company owns, possibly including further data from external sources. Assuming a fast in-memory database, no more pre-computed materialized data structures are needed. As soon as changes to data are committed to the database, they will be visible for reporting. The preparation and conversion steps of data if still needed for reports are done during query execution and computations take place on the fly. 

Computation on the fly during reporting on the basis of cubes that do not store data, but only provide the interface for reporting, solves a problem that has existed up to now and allows for performance optimization of all analytical reports likewise

Baby Steps Of Financial Planning

Do you remember the feeling that you had when you first held your child in your arms? Some say it was happiness, others say it was responsibility. A part of this sense of responsibility is to provide everything to the bundle of joy. According to a study conducted by Principal Retirement Advisors, children’s education and marriage was the top most financial goal (68%) across age groups of respondents, followed by buying a house (57%). 

Mint spoke to some soon-to-be parents and new parents to understand how they plan their finances to meet their children’s needs, including day-to-day expenses, education and marriage. Here is what we found, along with suggestions on what to do to meet these financial goals. 

In good faith Most parents depend on existing income for the day-to-day expenses. Mumbai-based Prianka Singh, 34, a stay-at-home mother to four-year-old Eva, and expecting her second child in two months, said, “We all know that there will be immediate financial needs such as medical care and other expenses when you are going to have a baby. We are dependent on my husband’s current income for these.” However, for the long-term needs such as education, she prefers to invest in equity. 

While Singh’s choice of investment is equity, many parents choose to invest heavily in fixed deposits, insurance products and physical gold for long-term needs. Dubai-based Sreeja V. Ramachandran, a 30-year-old homemaker and mother to four-year-old Dakshina, is one of them. “We have an insurance policy and a couple of fixed deposits to meet the education needs of our child. I also invest in the form of physical gold coins every year for my daughter. These gold coins are for the marriage kitty,” said Ramachandran. Then there are those who invest only in real estate. “I have a daughter and a son. I only invest in real estate. So far, I have bought three plots near my house,” said Thrissur-based Jayan Raman, 45, who works with Kerala State Electricity Board Ltd. His daughter Archa is 5 years old and son Aromal is 6 years old. 

When asked why he invested in real estate, he said, “Frankly, I don’t understand financial products such as equity. My father used to invest in land and the value of the property he bought has appreciated. I hope that the plot I have bought will also appreciate in value.” Parents try their best to provide for their children, even if they need to compromise in other areas. The blame for the trend can partly be attributed to peer pressure. “Many parents today are making choices that are steadily ratcheting up the amounts they spend on their children, be it for education or leisure. They are also losing sight of what is going on and are constantly trying to push their purchasing power,” said Chandni Parekh, a Mumbai-based social psychologist.