why we go for data warehouse?
81953
Why a Data Warehouse?\nIt allows for the following benefits to the business and Business Intelligence layer:\n\n1.Speed: The data structure in a Data Warehouse (Star Schema) is the optimal structure for delivering a result set to the Business Intelligence layer; and hence is many times faster then going against Database directly, which has a structure optimized for storing data, not delivering it\n\n2.Pre-Gathered Values: One of the primary challenges in producing reports against Database directly is developing the logical joins and relationships in the data to appropriately deliver reports.  In a Data Warehouse these values are all prepared up front.  This leads to benefit #3\n\n3.Development Speed: If a new report needs to be created against Database today, it will require piecing together the different tables in the database.  Having this work done up front allows reports and universe elements to be created quickly\n\n4.Offloaded Processing:  When the Business Intelligence layer requests data from the database, the database will require processing power to produce the result set.  If Database is being hit directly with this request it will take processing power away from other resources that need the Database database.  Namely the applications themselves\n\n5.Independence:  If the organization ever decides to move away from their application (say a CRM) to another application (another CRM) the Business Intelligence layer can remain in tact as the majority of changes would occur in the Data Warehouse.  However, if Database is being accessed directly by the reports then the organization would be required to rewrite the logic for each and every report individually\n\n6.Singularity:  The Data Warehouse delivers a single location from which the data is extracted giving confidence to the business that there is a single version of the truth.  Additionally, IT benefits from a higher ROI per hour spent producing data relationship logic (in the Data Warehouse), as the logic can be leveraged over and over by the Business Intelligence layer\n\nImportant things to be aware of in a Data Warehouse\nThe benefits of a Data Warehouse are great but they require and awareness of the following items:\n\n1.Scheduled Data:  The data in a Data Warehouse is extracted (from Database), transformed, and then loaded into the Data Warehouse (another database).  This is a scheduled process and thus the data will not be “live” against the database.  This doesn’t mean that values cannot be pulled live for certain report values outside the Data Warehouse; but in general the Business Intelligence implementation will be pulling from data that is a day or half-day old.  This can also become a benefit, as the schedules can be kicked off when other processes finish, thus avoiding the danger of delivering incomplete numbers to the business. (ie. receiving a report that ran before the accounting books closed in the system, producing incompatible results, unbeknownst to the business)\n\n2.Investment:  The implementation of the Data Warehouse needs to be seen as a long term investment.  Inevitably, down the road there will be business processes that change, or business that are added, requiring these results to be reflected in the Data Warehouse.  Hence, best practices, and a strong starting point are critical.
1135100
It is a datawarehouse. You can create queries and reports in Business Warehouse.
349121
Advantages of a Database\n·        Reduction in data redundancy \n·        Maintenance of data integrity and quality \n·        Avoidance of inconsistency  \n·        Reduced cost of software development  \n·        Security restrictions  \n\n\nThe biggest advantage is that if a standard way to organize and store data that  allows you to decouple the representation of the data from the software that uses it.\n\nThis allows you to move or reorganize data without have to find every program that uses the data and change them to match the change in the data. \n\n\naccess speed and increase in space to represent the data are the big disadvantages.
514553
As long as there are computers, there will be a need for Data warehousing. This offers companies a back-up for disaster recovery plans. It will grow as more companies develop these disaster recovery plans. I believe that ISO 9001 requires a plan in order to be certified.\n\nAnother promising field is electronic archiving of hard copies. So many companies have to hold onto old documents, but would like to have those stored electronically. The problem is the time involved in scanning and recording all these documents.
347043
SAP ? I understand that you should be having volumnous data and many modules of control.\n\nSAP can handle from planning, finance, production, accounting, budgeting, costing and the list goes on. And the best thing is all these functions act on an integrated platform. They interchange data between modules. \n\nHope you got the point. You can contact me on my mail id.
928193
if i understood ur question right, because we can store more and more data in a smaller physical space or device. like the nanotube technology for example.
457283
Data mining software allows users to analyze large databases to solve business decision problems. Data mining is, in some ways, an extension of statistics, with a few artificial intelligence and machine learning twists thrown in. Like statistics, data mining is not a business solution, it is just a technology.  For example, consider a catalog retailer who needs to decide who should receive information about a new product. The information operated on by the data mining process is contained in a historical database of previous interactions with customers and the features associated with the customers, such as age, zip code, their responses. The data mining software would use this historical information to build a model of customer behavior that could be used to predict which customers would be likely to respond to the new product. By using this information a marketing manager can select only the customers who are most likely to respond.  The operational business software can then feed the results of the decision to the appropriate touch point systems (call centers, direct mail, web servers, email systems, etc.) so that the right customers receive the right offers.\n\nSo no matter what ever it is, all that matters is you use the way.
252665
Low cost, the likelihood of finding other software on the market that can exchange data with your software, and the probability that you will easily obtain help, training resources, and documentation for your software, particularly if it is a popular product. Also, upgrades will be inexpensive, and you might benefit from the complaints or suggestions of other users in cases where the software supplier responds to users’ comments with fixes and enhancements.
1170574
The primary goal of supermarket chains is to have the correct products on the shelves. They want to give bigger shelf space to faster moving items rather than slow moving items.\n\nSo, typically, these supermarket chains would use DBMS and datamining to discover which items are moving fast and which items need to be removed from their shelves.\n\nDataMining can also be used to discover which suppliers deliver on time, which items get the most damage, which items are frequently bought together (e.g. toothpaste with toothbrushes). You name it, and data mining can be used to get it.
405600
While what you want to do could be done with Access, programming Access to do it -- make the forms, the queries and reports needed -- is very difficult, if you don't have fairly advanced database / Access skills.\n\nAlso, you're going to want this product to have rock-solid support -- because once you start using it, you'll be tied to it, and if it fails, you'll need it fixed ASAP.\n\nAs a result, you're not going to find something like what you are asking for out there for free, and having it custom programmed is going to cost more than buying it off the shelf -- at least, if the programmer is worth his salt.\n\nInstead, you should look for an off-the-shelf solution.\n\nQuickbooks -- http://www.intuit.com -- is one option; it technically is bookkeeping software, but it has advanced inventory management features and can handle purchase orders / autodepleting inventory based on purchase orders.\n\nIt will cost several hundred dollars to purchase, but you will find, again, that even so, it's one of the more affordable solutions.\n\nShort of that, there are lots of other software packages out there; most will cost even more than Quickbooks.\n\nA final option might be to find a college student who is in a database administration or programming course, and see if he's be willing to build this for you on the cheap. But remember, you get what you pay for.
206637
A data warehouse is a collection of data gathered and organized so that it can easily by analyzed, extracted, synthesized, and otherwise be used for the purposes of further understanding the data. It may be contrasted with data that is gathered to meet immediate business objectives such as order and payment transactions, although this data would also usually become part of a data warehouse.\n\nor\n\nA technique for properly assembling and managing data from various sources for the purpose of answering business questions and making decisions that were not previously possible.
1173761
Oracle was the first commercial relational database management system.  Prior to oracle, computer data was stored and retrieved much like physical files are, by sorted location within a file.  Database software used indexes to locate data, and the more advanced databases, called 'network' databases, created shared indexes, so that data could be retrieved from more than one file in the same request.\n         Oracle stores data simply in no particular order and uses sophisticated algorithms to retrieve, connect and combine data from any of the tables by any field the query writer wants to use.\nThe complexity is in the software and not in the data arrangement.\nAll major databases are relational now.  \n         Oracle's expansion of the features of it's databases has been phenomenal over the years, and has kept them in the front of the pack.  Their databases can be expanded to phenomenal size, can be configured for no-loss stability, and interface with cutting-edge software.\n          I have worked with Oracle for 21 years, and have managed tiny databases that stayed running without any maintenance downtime for years, and large multi-national databases that pump HUGE volumes of data in every hour.\n          I read recently that Oracle has lowered pricing at the low end, so it may be competitive for mid-range databases now, too.  Oracle provides much information online.
362124
It is an ETL tool.  It is most often used by customers who have already purchased the Cognos BI tools and want to move data into information database such as data warehouses, datamarts or decision support databases.  There is some metadata sharing between the Cognos ETL and BI tools that can make implementation easier.  You could just as easily populate a Cognos BI database using any other ETL tool.
657055
It is a database software.
421396
It dosn't realy matters, but known brands like Sony, Philips, TDK, Veribitem are expensive but r for high quality data... They have a longer life span then the cheap ones...
1129148
Given that Yahoo has huge list of services (http://docs.yahoo.com/docs/family/more ), some free and some premium, I believe there are very different database requirements on different functions of those services and they hand-pick the optimal database and configuration for a specific purpose - MySQL, gdbm, Berkeley db, Oracle,  home-cooked databases, etc.
211702
The software vendors that are writing popular ERP and other large business systems have selected Oracle as the background data store that they write their software to use.\n\nFor large data collections Oracle has many attributes that are important, such as ;\nscalability, consistency, concurrency, point-in-time recovery,multi platform availability  and a forward looking adoption policy for new technology.