NDLI: Semi-automated approach for converting ERD to semi-star schema

Content Provider	IEEE Xplore Digital Library
Author	Latif, A. Javed, M.Y. Khan, S.
Copyright Year	2008
Description	Author affiliation: Coll. of Electr. & Mech. Eng., NUST, Rawalpindi (Javed, M.Y.) \|\| Mil. Coll. of Signals, NUST, Rawalpindi (Latif, A.) \|\| Sch. of Electr. Eng. & Comput. Sci., NUST, Islamabad (Khan, S.)
Abstract	Small and medium enterprises cannot afford the cost of creating a data warehouse and if they do so, they fail to maintain it due to high updation cost. To solve this problem, semi-star schema has already been proposed. Semi-star schema modeling is a new technique, so data warehouse designers may face problems in creating it. Some method based on source-driven approach is required to generate it because source driven approaches are stable, as far as the data is stable in a database. To avoid complexities of semi-star generation, a semi-automated approach to convert entity relation diagram to semi-star schema is presented in this paper. This approach uses some automation steps of entity relationship diagram to star schema conversion that calculates connection topology value and apply threshold on it and the rest of the steps are its own. Thus the complex process of data warehouse generation is simplified using approach presented here.
Starting Page	264
Ending Page	268
File Size	2296181
Page Count	5
File Format	PDF
ISBN	9781424422104
DOI	10.1109/ICET.2008.4777512
Language	English
Publisher	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Publisher Date	2008-10-18
Publisher Place	Pakistan
Access Restriction	Subscribed
Rights Holder	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Subject Keyword	data warehouse Costs Automation Military computing Decision making Data warehouses entity relationship diagram Educational institutions Topology Mechanical engineering semi-star schema star schema Computer science transactional systems Databases
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in