| R. Agrawal, A. Somani, and Y. Xu. Storage and querying of e-commerce data. In VLDB, pages 149--158. Morgan Kaufmann Publishers Inc., 2001. |
....technologies. These technologies suffer from two primary drawbacks: 1) they were designed and optimized for intra enterprise, client server applications, with clear, rigid requirements and (2) they are not deployed in a manner consistent with multi tier, standards based distributed architectures [1,10]. A new data management architecture is needed. We propose an approach to this problem, called eXtensible Data Management (XDM) The goal of XDM is to provide high performance management of data that is irregularly structured, or whose structure may change over time. The system must be able to ....
R. Agrawal, A. Somani and Y. Xu. Storage and querying of e-commerce data. In Proceedings VLDB, September 2001.
....current application development tools designed for the horizontal format no longer work. For example, an original simple query SELECT A1 FROM H WHERE A1 = a now may have to be written as SELECT Val FROM V WHERE Key = A1 and Val = a To solve this problem, we propose an enablement layer [ASX01] that hides the complexity of the queries over the vertical table and gives a horizontal view of the vertical representation to the user (application) Figure 3 shows the architecture of the enablement layer. The layer accepts user s query against the horizontal view, parses the query, and ....
....level of capabilities from the underlying database engine. # VerticalUDF: The implementation exploits objectrelational extensions to SQL (e.g. user defined table functions) Our performance experiments show that both strategies uniformly outperform the horizontal representation for sparse data [ASX01]. Demonstration We store our sample data in IBM DB2 7.1 using the vertical representation, and define the corresponding horizontal view in the enablement layer. We also Figure 3: Architecture of query enablement layer store a copy of the data using the horizontal representation. The ....
Rakesh Agrawal, Amit Somani, and Yirong Xu. Storage and querying of e-commerce data. In Proc. of the 27th Int'l Conference on Very Large Databases (VLDB), pages 149--158, Rome, Italy, September 2001.
....the horizontal format to vertical format. We discuss the implementation strategies in Section 3 and give performance results in Section 4. We conclude with a summary and some pointers for the database system practitioners in Section 5. We also refer the reader to the extended version of this paper [3] that contains additional explanations and performance results. 2 Create a separate vertical table for every data type. A catalog table maintains data type information for each attribute. Thus we might have a scheme as shown below: ATTRIBUTES (KEY CHAR(K) PRIMARY KEY, DATATYPE CHAR(N ) V ....
....operations on the horizontal view over a vertical table. We give two forms of rewritings: one with and the other without using the v2h operation. The former can be used on a SQL 92 system whereas the latter can exploit the implementation of v2h operation using the object relational extensions. See [3] for illustrative examples of these rewritings. Projection Let the projection be on attributes A1#: #Ak. We have, from the definition of the v2h operation: A1#: #Ak (H) Omega k (V ) 3) Oid (V ) k i=1 Oid #Val (oe Key= Ai 0 (V ) 4) Selection We discuss the usual ....
[Article contains additional citation context not shown here]
R. Agrawal, A. Somani, and Y. Xu. Storage and Querying of E-Commerce data. Research report, IBM Almaden Research Center, San Jose, CA 95120, June 2001. Available from http://www.almaden.ibm.com/cs/quest.
No context found.
R. Agrawal, A. Somani, and Y. Xu. Storage and querying of e-commerce data. In VLDB, pages 149--158. Morgan Kaufmann Publishers Inc., 2001.
No context found.
Agrawal, R., Somani, A., Xu, Y.: Storage and querying of e-commerce data. In: VLDB '01: Proceedings of the 27th International Conference on Very Large Data Bases, Morgan Kaufmann Publishers Inc. (2001) 149--158
No context found.
R. Agrawal, A. Somani, and Y. Xu. Storage and querying of e-commerce data. In Proc. of the 27th Int'l Conference on Very Large Databases (VLDB 2001.
No context found.
R. Agrawal, A. Somani, and Y. Xu. Storage and querying of e-commerce data. In Proc. of the 27th Int'l Conference on Very Large Databases (VLDB 2001.
No context found.
R. Agrawal, A. Somani, and Y. Xu. Storage and Querying of E-Commerce Data. In Proceedings VLDB, Rome, Italy, pages 149--158, September 2001.
No context found.
R. Agrawal, A. Somani, and Y. Xu. Storage and querying of e-commerce data. In Proc. of the 27th Int'l Conference on Very Large Databases (VLDB 2001.
No context found.
R. Agrawal, A. Somani, and Y. Xu. Storage and Querying of E-Commerce Data. In Proc. of VLDB 2001, the 27th International Conference on Very Large Data Bases. 2001.
No context found.
R. Agrawal, A. Somani and Y. Xu. Storage and querying of e-commerce data. In Proceedings VLDB, September 2001.
No context found.
R. Agrawal, A. Somani, and Y. Xu. Storage and querying of e-commerce data. In VLDB'01, Proceedings of 27rd International Conference on Very Large Data Bases, September 11-14, 2001, Roma, Italy. Morgan Kaufmann, 2001.
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC