WO2008002578A3 - Procédés et appareil pour améliorer la performance d'un entrepôt de données - Google Patents
Procédés et appareil pour améliorer la performance d'un entrepôt de données Download PDFInfo
- Publication number
- WO2008002578A3 WO2008002578A3 PCT/US2007/014834 US2007014834W WO2008002578A3 WO 2008002578 A3 WO2008002578 A3 WO 2008002578A3 US 2007014834 W US2007014834 W US 2007014834W WO 2008002578 A3 WO2008002578 A3 WO 2008002578A3
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data warehouse
- methods
- improving data
- warehouse performance
- performance
- Prior art date
Links
- 238000000034 method Methods 0.000 title abstract 3
- 238000013507 mapping Methods 0.000 abstract 2
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99934—Query formulation, input preparation, or translation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Priority Applications (5)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CA002656188A CA2656188A1 (fr) | 2006-06-26 | 2007-06-26 | Procedes et appareil pour ameliorer la performance d'un entrepot de donnees |
EP07796458A EP2041676A4 (fr) | 2006-06-26 | 2007-06-26 | Procédés et appareil pour améliorer la performance d'un entrepôt de données |
CN2007800237797A CN101542478B (zh) | 2006-06-26 | 2007-06-26 | 提高数据仓库性能的方法和装置 |
US12/088,809 US7523124B2 (en) | 2006-06-26 | 2007-06-26 | Methods and apparatus for improving data warehouse performance |
HK10100275.4A HK1132815A1 (en) | 2006-06-26 | 2010-01-12 | Methods and apparatus for improving data warehouse performance |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US81642306P | 2006-06-26 | 2006-06-26 | |
US60/816,423 | 2006-06-26 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2008002578A2 WO2008002578A2 (fr) | 2008-01-03 |
WO2008002578A3 true WO2008002578A3 (fr) | 2008-09-04 |
Family
ID=38846271
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2007/014834 WO2008002578A2 (fr) | 2006-06-26 | 2007-06-26 | Procédés et appareil pour améliorer la performance d'un entrepôt de données |
Country Status (6)
Country | Link |
---|---|
US (3) | US7523124B2 (fr) |
EP (1) | EP2041676A4 (fr) |
CN (2) | CN102929901B (fr) |
CA (1) | CA2656188A1 (fr) |
HK (1) | HK1132815A1 (fr) |
WO (1) | WO2008002578A2 (fr) |
Families Citing this family (44)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9390132B1 (en) * | 2009-10-16 | 2016-07-12 | Iqor Holdings, Inc. | Apparatuses, methods and systems for a universal data librarian |
CN102929901B (zh) | 2006-06-26 | 2016-12-14 | 尼尔森(美国)有限公司 | 提高数据仓库性能的方法和装置 |
CN101441733A (zh) * | 2007-08-27 | 2009-05-27 | 北京奥腾讯达科技有限公司 | 基于库存数据的企业生产控制系统 |
US7860822B1 (en) * | 2007-10-18 | 2010-12-28 | Google Inc. | Distributed aggregation mapping |
US7822712B1 (en) | 2007-10-18 | 2010-10-26 | Google Inc. | Incremental data warehouse updating |
US8452636B1 (en) * | 2007-10-29 | 2013-05-28 | United Services Automobile Association (Usaa) | Systems and methods for market performance analysis |
JP4564044B2 (ja) * | 2007-12-27 | 2010-10-20 | 株式会社日立製作所 | 電子機器サービス・システム |
US8055609B2 (en) * | 2008-01-22 | 2011-11-08 | International Business Machines Corporation | Efficient update methods for large volume data updates in data warehouses |
US20090313232A1 (en) * | 2008-03-26 | 2009-12-17 | Thomas Austin Tinsley | Methods and Apparatus to Calculate Audience Estimations |
US8266582B2 (en) * | 2008-03-31 | 2012-09-11 | Oracle America, Inc. | Method for creating unified binary files |
US8972463B2 (en) * | 2008-07-25 | 2015-03-03 | International Business Machines Corporation | Method and apparatus for functional integration of metadata |
US9110970B2 (en) * | 2008-07-25 | 2015-08-18 | International Business Machines Corporation | Destructuring and restructuring relational data |
US8943087B2 (en) * | 2008-07-25 | 2015-01-27 | International Business Machines Corporation | Processing data from diverse databases |
CA2660748C (fr) * | 2009-03-31 | 2016-08-09 | Trapeze Software Inc. | Systeme d'agregation de donnees et procede connexe |
US9053146B1 (en) * | 2009-10-16 | 2015-06-09 | Iqor U.S. Inc. | Apparatuses, methods and systems for a web access manager |
CN102043800A (zh) * | 2009-10-16 | 2011-05-04 | 无锡华润上华半导体有限公司 | 数据存储实现方法及数据仓库 |
US8812482B1 (en) | 2009-10-16 | 2014-08-19 | Vikas Kapoor | Apparatuses, methods and systems for a data translator |
US9110968B2 (en) | 2010-04-14 | 2015-08-18 | At&T Intellectual Property I, L.P. | Removal of invisible data packages in data warehouses |
US8402044B2 (en) * | 2010-07-12 | 2013-03-19 | Sap Ag | Systems and methods for secure access of data |
US9069846B2 (en) | 2011-09-29 | 2015-06-30 | International Business Machines Corporation | Business content hierarchy |
US8700679B2 (en) * | 2012-04-17 | 2014-04-15 | Sap Ag | Classic to in-memory cube conversion |
US8983993B2 (en) * | 2012-12-18 | 2015-03-17 | Sap Se | Data warehouse queries using SPARQL |
US20150058195A1 (en) * | 2013-08-21 | 2015-02-26 | Miami International Securities Exchange, LLC | System and method for monitoring an equity rights transaction for strategic investors in a securities exchange |
US9396246B2 (en) | 2013-11-08 | 2016-07-19 | International Business Machines Corporation | Reporting and summarizing metrics in sparse relationships on an OLTP database |
CN103927337B (zh) * | 2014-03-26 | 2017-12-19 | 北京国双科技有限公司 | 用于联机分析处理中关联关系的数据处理方法和装置 |
WO2016055907A1 (fr) | 2014-10-10 | 2016-04-14 | Pfizer Inc. | Associations synergiques d'auristatine |
US10740292B2 (en) | 2015-05-18 | 2020-08-11 | Interactive Data Pricing And Reference Data Llc | Data conversion and distribution systems |
US10474692B2 (en) * | 2015-05-18 | 2019-11-12 | Interactive Data Pricing And Reference Data Llc | Data conversion and distribution systems |
US10733155B2 (en) * | 2015-10-23 | 2020-08-04 | Oracle International Corporation | System and method for extracting a star schema from tabular data for use in a multidimensional database environment |
JP6846356B2 (ja) | 2015-10-23 | 2021-03-24 | オラクル・インターナショナル・コーポレイション | 表形式データから、多次元データベース環境に使用されるキューブスキーマを自動的に推論するためのシステムおよび方法 |
CN105426434A (zh) * | 2015-11-04 | 2016-03-23 | 北京航天金盾科技有限公司 | 基于多维度的人口信息统计分析系统 |
US11372880B2 (en) * | 2016-02-26 | 2022-06-28 | Crysp Intelligence Pty Ltd | Data source system agnostic fact category partitioned information repository and methods for the insertion and retrieval of data using the information repository |
US10366098B2 (en) * | 2016-11-17 | 2019-07-30 | Bank Of America Corporation | Data upload—process integration tool |
US10528541B2 (en) * | 2016-12-13 | 2020-01-07 | Sap Se | Offline access of data in mobile devices |
CN107908672B (zh) * | 2017-10-24 | 2022-01-14 | 深圳前海微众银行股份有限公司 | 基于Hadoop平台的应用报表实现方法、设备及存储介质 |
CN108062973A (zh) * | 2017-11-30 | 2018-05-22 | 江西洪都航空工业集团有限责任公司 | 一种医疗卫生数据分析方法 |
WO2019135953A2 (fr) * | 2018-01-02 | 2019-07-11 | Alibaba Group Holding Limited | Collecte de données de configuration |
CN110007952B (zh) | 2018-01-02 | 2022-07-12 | 斑马智行网络(香港)有限公司 | 数据处理方法、装置、设备和机器可读介质 |
CN109214906A (zh) * | 2018-11-01 | 2019-01-15 | 山东浪潮商用系统有限公司 | 基于大数据仓库分层的税务数据资产分类管理方法及系统 |
CN109448859B (zh) * | 2018-11-09 | 2020-09-29 | 贵州医渡云技术有限公司 | 数据处理方法及装置、电子设备、存储介质 |
CN110597851B (zh) * | 2019-09-20 | 2022-06-07 | 深圳易嘉恩科技有限公司 | 一种基于大数据的数据处理及报表展示方法 |
CN110851543A (zh) * | 2019-11-08 | 2020-02-28 | 深圳市彬讯科技有限公司 | 一种数据建模的方法、装置、设备以及存储介质 |
US20230334068A1 (en) * | 2021-08-20 | 2023-10-19 | Boe Technology Group Co., Ltd. | Data processing method and apparatus thereof, electronic device, and computer-readable storage medium |
CN113742370B (zh) * | 2021-11-02 | 2022-04-19 | 阿里云计算有限公司 | 全加密数据库的数据查询方法、统计信息密文生成方法 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020156877A1 (en) * | 2001-04-23 | 2002-10-24 | Lu James C. | System and method for the duplication of a software system onto an appropriate target computer |
US20040044671A1 (en) * | 2002-08-30 | 2004-03-04 | Mitsuhiko Yoshimura | Method for changing database construction information |
US20040215560A1 (en) * | 2003-04-25 | 2004-10-28 | Peter Amalraj | Integrated payment system and method |
Family Cites Families (30)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6141663A (en) * | 1994-03-18 | 2000-10-31 | Unimax Systems Corporation | Automatic external data synchronization method |
US5675785A (en) | 1994-10-04 | 1997-10-07 | Hewlett-Packard Company | Data warehouse which is accessed by a user using a schema of virtual tables |
US5819066A (en) * | 1996-02-28 | 1998-10-06 | Electronic Data Systems Corporation | Application and method for benchmarking a database server |
US6202070B1 (en) * | 1997-12-31 | 2001-03-13 | Compaq Computer Corporation | Computer manufacturing system architecture with enhanced software distribution functions |
US6604108B1 (en) * | 1998-06-05 | 2003-08-05 | Metasolutions, Inc. | Information mart system and information mart browser |
US6263332B1 (en) | 1998-08-14 | 2001-07-17 | Vignette Corporation | System and method for query processing of structured documents |
US7739167B2 (en) * | 1999-03-05 | 2010-06-15 | Era Systems Corporation | Automated management of airport revenues |
US6163774A (en) * | 1999-05-24 | 2000-12-19 | Platinum Technology Ip, Inc. | Method and apparatus for simplified and flexible selection of aggregate and cross product levels for a data warehouse |
US6604113B1 (en) * | 2000-04-14 | 2003-08-05 | Qwest Communications International, Inc. | Method and apparatus for providing account information |
US7117215B1 (en) | 2001-06-07 | 2006-10-03 | Informatica Corporation | Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface |
US6671689B2 (en) | 2001-01-19 | 2003-12-30 | Ncr Corporation | Data warehouse portal |
EP1258812B1 (fr) | 2001-05-17 | 2004-02-25 | Peter Pressmar | Base de données virtuelle de structures de données hétérogènes |
US6947929B2 (en) | 2002-05-10 | 2005-09-20 | International Business Machines Corporation | Systems, methods and computer program products to determine useful relationships and dimensions of a database |
US7092931B1 (en) | 2002-05-10 | 2006-08-15 | Oracle Corporation | Methods and systems for database statement execution plan optimization |
JP2004030221A (ja) * | 2002-06-26 | 2004-01-29 | Hitachi Ltd | 変更対象テーブル自動検出方法 |
US20040064501A1 (en) * | 2002-09-30 | 2004-04-01 | Jan Salman Jaffer | Methods and apparatus for centralized provisioning of multi-domain web content |
US20040090460A1 (en) | 2002-11-12 | 2004-05-13 | Hideya Kawahara | Method and apparatus for updating a User Interface for a computer system based on a physics model |
US7181450B2 (en) | 2002-12-18 | 2007-02-20 | International Business Machines Corporation | Method, system, and program for use of metadata to create multidimensional cubes in a relational database |
US7111000B2 (en) * | 2003-01-06 | 2006-09-19 | Microsoft Corporation | Retrieval of structured documents |
US20040148278A1 (en) | 2003-01-22 | 2004-07-29 | Amir Milo | System and method for providing content warehouse |
US20050050030A1 (en) | 2003-01-30 | 2005-03-03 | Decode Genetics Ehf. | Set definition language for relational data |
US7152073B2 (en) | 2003-01-30 | 2006-12-19 | Decode Genetics Ehf. | Method and system for defining sets by querying relational data using a set definition language |
US7895191B2 (en) | 2003-04-09 | 2011-02-22 | International Business Machines Corporation | Improving performance of database queries |
US7487173B2 (en) * | 2003-05-22 | 2009-02-03 | International Business Machines Corporation | Self-generation of a data warehouse from an enterprise data model of an EAI/BPI infrastructure |
US7089266B2 (en) | 2003-06-02 | 2006-08-08 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for the query and visualization of multidimensional databases |
JP2006127229A (ja) * | 2004-10-29 | 2006-05-18 | Toshiba Corp | 構造化文書検索システム、構造化文書検索方法及びプログラム |
US7630956B2 (en) | 2005-03-07 | 2009-12-08 | Skytide, Inc. | System and method for analyzing and reporting extensible data from multiple sources in multiple formats |
US20070061287A1 (en) | 2005-09-09 | 2007-03-15 | Jian Le | Method, apparatus and program storage device for optimizing a data warehouse model and operation |
US7451155B2 (en) | 2005-10-05 | 2008-11-11 | At&T Intellectual Property I, L.P. | Statistical methods and apparatus for records management |
CN102929901B (zh) | 2006-06-26 | 2016-12-14 | 尼尔森(美国)有限公司 | 提高数据仓库性能的方法和装置 |
-
2007
- 2007-06-26 CN CN201210154165.5A patent/CN102929901B/zh active Active
- 2007-06-26 US US12/088,809 patent/US7523124B2/en active Active
- 2007-06-26 EP EP07796458A patent/EP2041676A4/fr not_active Ceased
- 2007-06-26 WO PCT/US2007/014834 patent/WO2008002578A2/fr active Application Filing
- 2007-06-26 CA CA002656188A patent/CA2656188A1/fr not_active Abandoned
- 2007-06-26 CN CN2007800237797A patent/CN101542478B/zh active Active
-
2009
- 2009-03-10 US US12/400,962 patent/US8219521B2/en active Active
-
2010
- 2010-01-12 HK HK10100275.4A patent/HK1132815A1/xx unknown
-
2012
- 2012-06-21 US US13/529,359 patent/US8738576B2/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020156877A1 (en) * | 2001-04-23 | 2002-10-24 | Lu James C. | System and method for the duplication of a software system onto an appropriate target computer |
US20040044671A1 (en) * | 2002-08-30 | 2004-03-04 | Mitsuhiko Yoshimura | Method for changing database construction information |
US20040215560A1 (en) * | 2003-04-25 | 2004-10-28 | Peter Amalraj | Integrated payment system and method |
Also Published As
Publication number | Publication date |
---|---|
CN101542478B (zh) | 2012-07-18 |
CN102929901B (zh) | 2016-12-14 |
EP2041676A4 (fr) | 2012-05-16 |
US20090172000A1 (en) | 2009-07-02 |
US20130159244A1 (en) | 2013-06-20 |
CN102929901A (zh) | 2013-02-13 |
US7523124B2 (en) | 2009-04-21 |
CN101542478A (zh) | 2009-09-23 |
WO2008002578A2 (fr) | 2008-01-03 |
US20090043730A1 (en) | 2009-02-12 |
US8219521B2 (en) | 2012-07-10 |
HK1132815A1 (en) | 2010-03-05 |
CA2656188A1 (fr) | 2008-01-03 |
US8738576B2 (en) | 2014-05-27 |
EP2041676A2 (fr) | 2009-04-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2008002578A3 (fr) | Procédés et appareil pour améliorer la performance d'un entrepôt de données | |
WO2007103352A3 (fr) | Systèmes et procédés d'annotation de documents | |
WO2007148259A3 (fr) | Procédé pour la collecte de données | |
WO2009006070A3 (fr) | Techniques de gestion de transformations d'annotation pour les changements de contexte | |
WO2006019385A8 (fr) | Techniques d'enregistrement de contenu | |
WO2006113078A3 (fr) | Procede et systeme permettant d'acceder et de visionner des fichiers sur des dispositifs mobiles | |
WO2007133625A3 (fr) | Extraction d'information multilingue | |
WO2006137977A3 (fr) | Indexation de contenu specifique de dispositif pour fonctionnement de dispositif optimise | |
WO2008147622A3 (fr) | Effets haptiques de personnalisation sur un dispositif utilisateur final | |
WO2008027683A3 (fr) | Annotation de contenu multimedia avec des informations associées | |
WO2009131861A3 (fr) | Gestion de contenus multimédias | |
WO2008080143A3 (fr) | Procédé et système permettant de rechercher des données stockées | |
WO2010078972A3 (fr) | Procédé et agencement pour gérer des informations non textuelles | |
WO2007092719A3 (fr) | Outil de télécommunication multiplexée et de multimédias d'échanges commerciaux | |
WO2004010328A3 (fr) | Balise d'indexage multimedia et dispositif de capture | |
WO2008073701A3 (fr) | Système et procédé d'authentification et de versionnage de fichiers mettant en oeuvre des identifiants de contenu uniques | |
WO2007109706A3 (fr) | Procédé et système d'analyse de fragmentation de données rapide d'un système ntfs (système de fichiers de technologie nouvelle) | |
WO2012094551A8 (fr) | Procédé et appareil de mise à jour d'une base de données dans un dispositif de réception | |
TW200744337A (en) | Methods, communication device, and communication system for presenting multi-media content in conjunction with user identifications corresponding to the same channel number | |
WO2008149843A1 (fr) | Système de présentation d'information, procédé de présentation d'information et programme de présentation d'information | |
WO2007095589A3 (fr) | Méthodes et système d'agrégation et d'utilisation d'échantillons physiques et de données dans un environnement virtuel | |
MX2008000162A (es) | Manejo de datos sensible al contexto. | |
WO2008157684A3 (fr) | Système et procédé d'identification biométrique utilisant un dispositif d'interface portable pour système de présentation de contenu | |
GB2430058A (en) | A system and method for retrieving information and a system and method for storing information | |
HK1110718A1 (en) | Method and system for optimizing metadata passing |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
WWE | Wipo information: entry into national phase |
Ref document number: 200780023779.7 Country of ref document: CN |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 07796458 Country of ref document: EP Kind code of ref document: A2 |
|
WWE | Wipo information: entry into national phase |
Ref document number: 12088809 Country of ref document: US |
|
ENP | Entry into the national phase |
Ref document number: 2656188 Country of ref document: CA |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
REEP | Request for entry into the european phase |
Ref document number: 2007796458 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2007796458 Country of ref document: EP |
|
NENP | Non-entry into the national phase |
Ref country code: RU |