The Hindu Business Line  Jul 14  Comment 
Angelique Kerber ripped up the script when she stunned Serena Williams 6-3 6-3 to win her first Wimbledon title on Saturday.The 11th seed took advanta
The Hindu Business Line  Jul 28  Comment 
Shares of Advanta will remain in focus ahead of its merger with UPL, as the stock will turn ex-date on August 1. Advanta shareholders will get one equity share and three preference shares of UPL for...
The Economic Times  Jul 21  Comment 
"We continue to like companies in the agriculture and finance segments. Within the agriculture space, we see potential in UPL and Advanta," an expert said.
The Hindu Business Line  Jun 23  Comment 
The High Court of Gujarat has approved the merger of Advanta with its promoter UPL, the latter informed the exchanges on Thursday. UPL said the merger would come into effect after a copy of the order ...
The Hindu Business Line  Jun 10  Comment 
InterContinental Hotels Group (IHG), one of the world’s leading hotel companies, has opened Pune’s first Crowne Plaza. The 173-room hotel will operate under a management agreement with The Advanta...
The Economic Times  Jan 29  Comment 
Seed company Advanta Ltd today reported an over two-fold jump in consolidated net profit at Rs 60.67 crore for the quarter ended December 31.
The Hindu Business Line  Dec 31  Comment 
The board of directors of Advanta has approved allotment of 39.7 lakh shares to JP Morgan Chase Bank to facilitate listing of global depository receipts (GDRs) on account of conversion of 2...
The Hindu Business Line  Nov 23  Comment 
Move to expand product portfolio and engage directly with farmers
The Hindu Business Line  Nov 23  Comment 
Agrochemical major UPL Ltd today announced merger of the group’s seed firm Advanta with itself as part of its strategy to provide all agri—solutions through one single entity and enhance shareholde...
The Economic Times  Nov 23  Comment 
The Hindu Business Line  Nov 20  Comment 
The boards of Advanta and UPL will meet on Monday to consider a proposal to merge the former with the latter. As on September 30, a total of nine promoters held 59.5 per cent stake in Advanta, of...


i wanted to post a reply I made rerdaging an email question on this post:Question: On #3, could you provide some more cons to reporting against a transactional database?Reply:Good question, there are a few reasons why it's not optimal to report against a transactional database:1.A big reason is performance – reporting uses a lot of memory and CPU, especially, reports that use data cubes or mdx queries.2.Data locks can happen more frequently, when someone is adding data while someone is trying to report against it.3.Database designs for reporting are usually different than that for transaction databases. Transactional database should be normalized, with primary and foreign key relationships to ensure the data integrity and to eliminate duplicate or orphaned records. Reporting data structures are usually not normalized, or flat. Using a star database design, or a “table for each major reporting area” is typical for speed on the queries. Also, the indexes many times would be different. Databases for your applications are usually OLTP (On-Line Transaction Processing) and optimized to store data. Reporting databases are usually OLAP (On-Line Analytic Processing) optimized to retrieve data.4.Also, consider scalability if your reporting against your transactional database. How will it perform in a year from now with growth, more data, more reporting requirements, etc.?

Wikinvest © 2006, 2007, 2008, 2009, 2010, 2011, 2012. Use of this site is subject to express Terms of Service, Privacy Policy, and Disclaimer. By continuing past this page, you agree to abide by these terms. Any information provided by Wikinvest, including but not limited to company data, competitors, business analysis, market share, sales revenues and other operating metrics, earnings call analysis, conference call transcripts, industry information, or price targets should not be construed as research, trading tips or recommendations, or investment advice and is provided with no warrants as to its accuracy. Stock market data, including US and International equity symbols, stock quotes, share prices, earnings ratios, and other fundamental data is provided by data partners. Stock market quotes delayed at least 15 minutes for NASDAQ, 20 mins for NYSE and AMEX. Market data by Xignite. See data providers for more details. Company names, products, services and branding cited herein may be trademarks or registered trademarks of their respective owners. The use of trademarks or service marks of another is not a representation that the other is affiliated with, sponsors, is sponsored by, endorses, or is endorsed by Wikinvest.
Powered by MediaWiki